Code:#
# MySQLDiff 1.5.0
#
# http://www.mysqldiff.org
# (c) 2001-2004, Lippe-Net Online-Service
#
# Create time: 09.06.2008 19:03
#
# --------------------------------------------------------
# Source info
# Host: localhost
# Database: rnuke1
# --------------------------------------------------------
# Target info
# Host: localhost
# Database: rnuke2
# --------------------------------------------------------
#
SET FOREIGN_KEY_CHECKS = 0;
#
# DDL START
#
CREATE TABLE nuke_banner_clients (
cid int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
name varchar(60) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
contact varchar(60) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
email varchar(60) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
login varchar(10) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
passwd varchar(10) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
extrainfo text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (cid),
INDEX cid (cid)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
CREATE TABLE nuke_banner_plans (
pid int(10) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
active tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
name varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
description text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
delivery varchar(10) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
delivery_type varchar(25) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
price varchar(25) NOT NULL DEFAULT '0' COMMENT '' COLLATE latin1_swedish_ci,
buy_links text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (pid)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
CREATE TABLE nuke_banner_positions (
apid int(10) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
position_number int(5) NOT NULL DEFAULT '0' COMMENT '',
position_name varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (apid),
INDEX position_number (position_number)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
CREATE TABLE nuke_banner_terms (
terms_body text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
country varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
CREATE TABLE nuke_gcal_cat_group (
id int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
cat_id int(11) NOT NULL DEFAULT 0 COMMENT '',
group_id int(11) NOT NULL DEFAULT 0 COMMENT '',
PRIMARY KEY (id),
INDEX cat_id (cat_id),
INDEX group_id (group_id)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
CREATE TABLE nuke_gcal_category (
id int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
name varchar(128) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (id)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
CREATE TABLE nuke_gcal_config (
id int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
title varchar(128) NOT NULL DEFAULT 'Calendar of Events' COMMENT '' COLLATE latin1_swedish_ci,
image varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
min_year int(10) unsigned NOT NULL DEFAULT '2006' COMMENT '',
max_year int(10) unsigned NOT NULL DEFAULT '2037' COMMENT '',
user_submit enum('off','members','anyone','groups') NOT NULL DEFAULT 'off' COMMENT '' COLLATE latin1_swedish_ci,
req_approval tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
allowed_tags text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
allowed_attrs text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
version varchar(16) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
time_in_24 tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
short_date_format varchar(16) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
reg_date_format varchar(16) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
long_date_format varchar(16) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
first_day_of_week tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
auto_link tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
location_required tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
details_required tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
email_notify tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
email_to varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
email_subject varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
email_msg varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
email_from varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
show_cat_legend tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
wysiwyg tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
user_update tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
weekends set('0','1','2','3','4','5','6') NOT NULL DEFAULT '0,6' COMMENT '' COLLATE latin1_swedish_ci,
rsvp enum('off','on','email') NOT NULL DEFAULT 'off' COMMENT '' COLLATE latin1_swedish_ci,
rsvp_email_subject varchar(255) NOT NULL DEFAULT 'Event RSVP Notification' COMMENT '' COLLATE latin1_swedish_ci,
groups_submit text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
groups_no_approval text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (id)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
CREATE TABLE nuke_gcal_event (
id int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
title varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
no_time tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
start_time time NOT NULL DEFAULT '00:00:00' COMMENT '',
end_time time NOT NULL DEFAULT '00:00:00' COMMENT '',
location text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
category int(11) NOT NULL DEFAULT '0' COMMENT '',
repeat_type enum('none','daily','weekly','monthly','yearly') NOT NULL DEFAULT 'none' COMMENT '' COLLATE latin1_swedish_ci,
details text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
interval_val int(11) NOT NULL DEFAULT '0' COMMENT '',
no_end_date tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
start_date date NOT NULL DEFAULT '0000-00-00' COMMENT '',
end_date date NOT NULL DEFAULT '0000-00-00' COMMENT '',
weekly_days set('0','1','2','3','4','5','6') NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
monthly_by_day tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
submitted_by varchar(25) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
approved tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
rsvp enum('off','on','email') NOT NULL DEFAULT 'off' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (id),
INDEX approved (approved),
INDEX start_date (start_date),
INDEX repeat_type (repeat_type)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
CREATE TABLE nuke_gcal_exception (
id int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
event_id int(11) NOT NULL DEFAULT 0 COMMENT '',
`date` date NOT NULL DEFAULT '0000-00-00' COMMENT '',
PRIMARY KEY (id),
INDEX event_id (event_id),
INDEX `date` (`date`)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
CREATE TABLE nuke_gcal_rsvp (
id int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
event_id int(11) NOT NULL DEFAULT 0 COMMENT '',
user_id int(11) NOT NULL DEFAULT 0 COMMENT '',
PRIMARY KEY (id),
INDEX event_id (event_id, user_id)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
CREATE TABLE nuke_hnl_categories (
cid int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
ctitle varchar(50) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
cdescription text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
cblocklimit int(4) NOT NULL DEFAULT '10' COMMENT '',
PRIMARY KEY (cid)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
CREATE TABLE nuke_hnl_cfg (
cfg_nm varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
cfg_val longtext NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (cfg_nm)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
CREATE TABLE nuke_hnl_newsletters (
nid int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
cid int(11) NOT NULL DEFAULT '1' COMMENT '',
topic varchar(100) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
sender varchar(20) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
filename varchar(32) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
datesent date NULL DEFAULT NULL COMMENT '',
view int(1) NOT NULL DEFAULT '0' COMMENT '',
groups text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
hits int(11) NOT NULL DEFAULT '0' COMMENT '',
PRIMARY KEY (nid),
INDEX cid (cid)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
CREATE TABLE nuke_seo_config (
config_type varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
config_name varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
config_value text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (config_type, config_name)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
CREATE TABLE nuke_seo_disabled_modules (
title varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
seo_module varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (title, seo_module)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
CREATE TABLE nuke_seo_feed (
fid int(6) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
content varchar(20) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
name varchar(20) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
level varchar(20) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
lid int(6) NOT NULL DEFAULT 0 COMMENT '',
title varchar(50) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
`desc` text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
`order` varchar(20) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
howmany char(3) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
active int(1) NOT NULL DEFAULT 0 COMMENT '',
desclimit varchar(5) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
securitycode varchar(50) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
cachetime varchar(6) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
feedburner_address varchar(100) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (fid),
INDEX content (content, title)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
CREATE TABLE nuke_seo_subscriptions (
sid int(6) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
type varchar(256) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
name varchar(60) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
tagline varchar(60) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
image varchar(256) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
icon varchar(256) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
url varchar(256) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
active int(1) NOT NULL DEFAULT 0 COMMENT '',
PRIMARY KEY (sid)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
ALTER TABLE nuke_authors
DROP INDEX aid;
ALTER TABLE nuke_autonews
DROP INDEX anid;
ALTER TABLE nuke_banned_ip
DROP INDEX id;
ALTER TABLE nuke_banner
ADD name varchar(50) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci AFTER cid,
ADD position int(10) NOT NULL DEFAULT '0' COMMENT '' AFTER dateend,
ADD ad_class varchar(5) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci AFTER active,
ADD ad_code text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci AFTER ad_class,
ADD ad_width int(4) NULL DEFAULT '0' COMMENT '' AFTER ad_code,
ADD ad_height int(4) NULL DEFAULT '0' COMMENT '' AFTER ad_width,
DROP type;
DROP TABLE nuke_bannerclient;
ALTER TABLE nuke_bbforums
DROP forum_parent;
ALTER TABLE nuke_bbsessions
DROP PRIMARY KEY,
DROP INDEX session_id_ip_user_id,
ADD INDEX session_ip (session_ip),
ADD INDEX session_id (session_id);
ALTER TABLE nuke_blocks
DROP INDEX bid;
DROP TABLE nuke_cities;
DROP TABLE nuke_clockcalendar;
ALTER TABLE nuke_comments
DROP INDEX tid;
ALTER TABLE nuke_config
ALTER minpass SET DEFAULT 8,
ALTER ultramode SET DEFAULT 1,
ALTER httpref SET DEFAULT 0;
DROP TABLE nuke_donators;
DROP TABLE nuke_donators_config;
DROP TABLE nuke_donators_settings;
ALTER TABLE nuke_downloads_categories
DROP INDEX cid;
ALTER TABLE nuke_downloads_downloads
DROP INDEX lid;
ALTER TABLE nuke_downloads_editorials
DROP INDEX downloadid;
ALTER TABLE nuke_downloads_modrequest
DROP INDEX requestid;
ALTER TABLE nuke_downloads_newdownload
DROP INDEX lid;
ALTER TABLE nuke_downloads_votedata
DROP INDEX ratingdbid;
ALTER TABLE nuke_encyclopedia
DROP INDEX eid;
ALTER TABLE nuke_encyclopedia_text
DROP INDEX tid;
ALTER TABLE nuke_faqanswer
DROP INDEX id;
ALTER TABLE nuke_faqcategories
DROP INDEX id_cat;
DROP TABLE nuke_g2config;
ALTER TABLE nuke_groups
DROP INDEX id,
ADD PRIMARY KEY (id);
ALTER TABLE nuke_groups_points
DROP INDEX id,
ADD PRIMARY KEY (id);
ALTER TABLE nuke_headlines
DROP INDEX hid;
ALTER TABLE nuke_journal
DROP INDEX jid;
ALTER TABLE nuke_journal_comments
DROP INDEX cid;
ALTER TABLE nuke_journal_stats
DROP INDEX id;
ALTER TABLE nuke_links_categories
DROP INDEX cid;
ALTER TABLE nuke_links_editorials
DROP INDEX linkid;
ALTER TABLE nuke_links_links
DROP INDEX lid;
ALTER TABLE nuke_links_modrequest
DROP INDEX requestid;
ALTER TABLE nuke_links_newlink
DROP INDEX lid;
ALTER TABLE nuke_links_votedata
DROP INDEX ratingdbid;
ALTER TABLE nuke_message
DROP INDEX mid;
ALTER TABLE nuke_modules
DROP INDEX mid;
ALTER TABLE nuke_nsnst_cidrs
MODIFY cidr int(2) NOT NULL DEFAULT 0 COMMENT '' auto_increment;
#
# Fieldformat of
# nuke_nsnst_cidrs.cidr changed from int(2) NOT NULL DEFAULT '0' COMMENT '' to int(2) NOT NULL DEFAULT 0 COMMENT '' auto_increment.
# Possibly data modifications needed!
#
DROP TABLE nuke_optimize_gain;
ALTER TABLE nuke_pages
DROP INDEX pid;
ALTER TABLE nuke_pages_categories
DROP INDEX cid;
ALTER TABLE nuke_poll_desc
DROP comments,
DROP INDEX pollID;
ALTER TABLE nuke_pollcomments
DROP INDEX tid;
ALTER TABLE nuke_public_messages
DROP INDEX mid;
ALTER TABLE nuke_queue
DROP INDEX qid;
ALTER TABLE nuke_quotes
DROP INDEX qid;
ALTER TABLE nuke_referer
DROP INDEX rid;
ALTER TABLE nuke_related
DROP INDEX rid;
ALTER TABLE nuke_reviews
DROP INDEX id;
ALTER TABLE nuke_reviews_add
DROP INDEX id;
ALTER TABLE nuke_reviews_comments
DROP INDEX cid;
DROP TABLE nuke_shoutbox_censor;
DROP TABLE nuke_shoutbox_conf;
DROP TABLE nuke_shoutbox_date;
DROP TABLE nuke_shoutbox_emoticons;
DROP TABLE nuke_shoutbox_ipblock;
DROP TABLE nuke_shoutbox_manage_count;
DROP TABLE nuke_shoutbox_nameblock;
DROP TABLE nuke_shoutbox_shouts;
DROP TABLE nuke_shoutbox_sticky;
DROP TABLE nuke_shoutbox_theme_images;
DROP TABLE nuke_shoutbox_themes;
DROP TABLE nuke_shoutbox_version;
ALTER TABLE nuke_stories
DROP INDEX sid;
ALTER TABLE nuke_stories_cat
DROP INDEX catid;
ALTER TABLE nuke_subscriptions
MODIFY userid int(10) NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX id,
ADD PRIMARY KEY (id, userid);
#
# Fieldformat of
# nuke_subscriptions.userid changed from int(10) NULL DEFAULT '0' COMMENT '' to int(10) NOT NULL DEFAULT '0' COMMENT ''.
# Possibly data modifications needed!
#
DROP TABLE nuke_themecpanel;
ALTER TABLE nuke_topics
MODIFY topicimage varchar(20) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
DROP INDEX topicid;
#
# Fieldformat of
# nuke_topics.topicimage changed from varchar(100) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci to varchar(20) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci.
# Possibly data modifications needed!
#
ALTER TABLE nuke_users
MODIFY user_sig varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
MODIFY bio tinytext NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
MODIFY ublock tinytext NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci;
#
# Fieldformats of
# nuke_users.user_sig changed from text NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci to varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci.
# nuke_users.bio changed from tinytext NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci to tinytext NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci.
# nuke_users.ublock changed from tinytext NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci to tinytext NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci.
# Possibly data modifications needed!
#
ALTER TABLE nuke_users_temp
ADD requestor varchar(25) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci AFTER time;
DROP TABLE nuke_whoiswhere;
#
# DDL END
#
SET FOREIGN_KEY_CHECKS = 1;
© 2001-2004, Lippe-Net Online-Service
|