# --------------------------------------------------------
#
# Table structure for table 'nuke_authors'
#

CREATE TABLE nuke_authors (
   aid varchar(25) NOT NULL,
   name varchar(50),
   url varchar(255) NOT NULL,
   email varchar(255) NOT NULL,
   pwd varchar(40),
   counter int(11) DEFAULT '0' NOT NULL,
   radminsuper tinyint(1) DEFAULT '1' NOT NULL,
   admlanguage varchar(30) NOT NULL,
   radminblocker tinyint(2) DEFAULT '0' NOT NULL,
   PRIMARY KEY (aid),
   KEY aid (aid)
);

#
# Dumping data for table 'nuke_authors'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_autonews'
#

CREATE TABLE nuke_autonews (
   anid int(11) NOT NULL auto_increment,
   catid int(11) DEFAULT '0' NOT NULL,
   aid varchar(30) NOT NULL,
   title varchar(80) NOT NULL,
   time varchar(19) NOT NULL,
   hometext text NOT NULL,
   bodytext text NOT NULL,
   topic int(3) DEFAULT '1' NOT NULL,
   informant varchar(20) NOT NULL,
   notes text NOT NULL,
   ihome int(1) DEFAULT '0' NOT NULL,
   alanguage varchar(30) NOT NULL,
   acomm int(1) DEFAULT '0' NOT NULL,
   associated text NOT NULL,
   PRIMARY KEY (anid),
   KEY anid (anid)
);

#
# Dumping data for table 'nuke_autonews'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_banreq'
#

CREATE TABLE nuke_banreq (
   id int(4) NOT NULL auto_increment,
   user_name text NOT NULL,
   reason longtext NOT NULL,
   active char(3) DEFAULT 'No' NOT NULL,
   PRIMARY KEY (id)
);

#
# Dumping data for table 'nuke_banreq'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbacronyms'
#

CREATE TABLE nuke_bbacronyms (
   acronym_id mediumint(9) NOT NULL auto_increment,
   acronym varchar(80) NOT NULL,
   description varchar(255) NOT NULL,
   PRIMARY KEY (acronym_id)
);

#
# Dumping data for table 'nuke_bbacronyms'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbadmin_nav_module'
#

CREATE TABLE nuke_bbadmin_nav_module (
   user_id mediumint(8) DEFAULT '0' NOT NULL,
   modulname varchar(200) NOT NULL
);

#
# Dumping data for table 'nuke_bbadmin_nav_module'
#

INSERT INTO nuke_bbadmin_nav_module VALUES ('1', 'General');


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbadvanced_username_color'
#

CREATE TABLE nuke_bbadvanced_username_color (
   group_id int(10) unsigned NOT NULL auto_increment,
   group_name varchar(255) NOT NULL,
   group_color varchar(6) NOT NULL,
   PRIMARY KEY (group_id)
);

#
# Dumping data for table 'nuke_bbadvanced_username_color'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbarcade'
#

CREATE TABLE nuke_bbarcade (
   arcade_name varchar(255) NOT NULL,
   arcade_value varchar(255) NOT NULL,
   PRIMARY KEY (arcade_name)
);

#
# Dumping data for table 'nuke_bbarcade'
#

INSERT INTO nuke_bbarcade VALUES ('arcade_announcement', 'Welcome to the Arcade!<br>Enjoy!');
INSERT INTO nuke_bbarcade VALUES ('use_category_mod', '1');
INSERT INTO nuke_bbarcade VALUES ('category_preview_games', '5');
INSERT INTO nuke_bbarcade VALUES ('games_par_page', '15');
INSERT INTO nuke_bbarcade VALUES ('game_order', 'Alpha');
INSERT INTO nuke_bbarcade VALUES ('display_winner_avatar', '1');
INSERT INTO nuke_bbarcade VALUES ('stat_par_page', '10');
INSERT INTO nuke_bbarcade VALUES ('winner_avatar_position', 'left');
INSERT INTO nuke_bbarcade VALUES ('maxsize_avatar', '200');
INSERT INTO nuke_bbarcade VALUES ('linkcat_align', '2');
INSERT INTO nuke_bbarcade VALUES ('limit_by_posts', '0');
INSERT INTO nuke_bbarcade VALUES ('posts_needed', '5');
INSERT INTO nuke_bbarcade VALUES ('days_limit', '5');
INSERT INTO nuke_bbarcade VALUES ('limit_type', 'date');
INSERT INTO nuke_bbarcade VALUES ('use_fav_category', '1');

# --------------------------------------------------------
#
# Table structure for table 'nuke_bbarcade_categories'
#

CREATE TABLE nuke_bbarcade_categories (
   arcade_catid mediumint(8) unsigned NOT NULL auto_increment,
   arcade_cattitle varchar(100) NOT NULL,
   arcade_nbelmt mediumint(8) unsigned DEFAULT '0' NOT NULL,
   arcade_catorder mediumint(8) unsigned DEFAULT '0' NOT NULL,
   arcade_catauth tinyint(2) DEFAULT '0' NOT NULL,
   KEY arcade_catid (arcade_catid)
);

#
# Dumping data for table 'nuke_bbarcade_categories'
#

INSERT INTO nuke_bbarcade_categories VALUES ('1', 'Arcade', '0', '1', '0');

# --------------------------------------------------------
#
# Table structure for table 'nuke_bbarcade_comments'
#

CREATE TABLE nuke_bbarcade_comments (
   game_id mediumint(8) DEFAULT '0' NOT NULL,
   comments_value varchar(255) NOT NULL
);

#
# Dumping data for table 'nuke_bbarcade_comments'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbarcade_fav'
#

CREATE TABLE nuke_bbarcade_fav (
  `order` mediumint(8) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `game_id` mediumint(8) NOT NULL default '0'
) TYPE=MyISAM;

#
# Dumping data for table 'nuke_bbarcade_fav'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbattach_quota'
#

CREATE TABLE nuke_bbattach_quota (
   user_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   group_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   quota_type smallint(2) DEFAULT '0' NOT NULL,
   quota_limit_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   KEY quota_type (quota_type)
);

#
# Dumping data for table 'nuke_bbattach_quota'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbattachments'
#

CREATE TABLE nuke_bbattachments (
   attach_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   post_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   privmsgs_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   user_id_1 mediumint(8) DEFAULT '0' NOT NULL,
   user_id_2 mediumint(8) DEFAULT '0' NOT NULL,
   KEY attach_id_post_id (attach_id, post_id),
   KEY attach_id_privmsgs_id (attach_id, privmsgs_id),
   KEY post_id (post_id),
   KEY privmsgs_id (privmsgs_id));

#
# Dumping data for table 'nuke_bbattachments'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbattachments_config'
#

CREATE TABLE nuke_bbattachments_config (
   config_name varchar(255) NOT NULL,
   config_value varchar(255) NOT NULL,
   PRIMARY KEY (config_name)
);

#
# Dumping data for table 'nuke_bbattachments_config'
#

INSERT INTO nuke_bbattachments_config VALUES ('upload_dir', 'files');
INSERT INTO nuke_bbattachments_config VALUES ('upload_img', 'images/icon_clip.gif');
INSERT INTO nuke_bbattachments_config VALUES ('topic_icon', 'images/icon_clip.gif');
INSERT INTO nuke_bbattachments_config VALUES ('display_order', '0');
INSERT INTO nuke_bbattachments_config VALUES ('max_filesize', '262144');
INSERT INTO nuke_bbattachments_config VALUES ('attachment_quota', '52428800');
INSERT INTO nuke_bbattachments_config VALUES ('max_filesize_pm', '262144');
INSERT INTO nuke_bbattachments_config VALUES ('max_attachments', '3');
INSERT INTO nuke_bbattachments_config VALUES ('max_attachments_pm', '1');
INSERT INTO nuke_bbattachments_config VALUES ('disable_mod', '0');
INSERT INTO nuke_bbattachments_config VALUES ('allow_pm_attach', '1');
INSERT INTO nuke_bbattachments_config VALUES ('attachment_topic_review', '1');
INSERT INTO nuke_bbattachments_config VALUES ('allow_ftp_upload', '1');
INSERT INTO nuke_bbattachments_config VALUES ('show_apcp', '1');
INSERT INTO nuke_bbattachments_config VALUES ('attach_version', '2.3.11');
INSERT INTO nuke_bbattachments_config VALUES ('default_upload_quota', '0');
INSERT INTO nuke_bbattachments_config VALUES ('default_pm_quota', '0');
INSERT INTO nuke_bbattachments_config VALUES ('ftp_server', 'ftp.yoursite.com');
INSERT INTO nuke_bbattachments_config VALUES ('ftp_path', '/public_html/files');
INSERT INTO nuke_bbattachments_config VALUES ('download_path', 'http://www.yoursite.com/files');
INSERT INTO nuke_bbattachments_config VALUES ('ftp_user', '');
INSERT INTO nuke_bbattachments_config VALUES ('ftp_pass', '');
INSERT INTO nuke_bbattachments_config VALUES ('ftp_pasv_mode', '1');
INSERT INTO nuke_bbattachments_config VALUES ('img_display_inlined', '1');
INSERT INTO nuke_bbattachments_config VALUES ('img_max_width', '0');
INSERT INTO nuke_bbattachments_config VALUES ('img_max_height', '0');
INSERT INTO nuke_bbattachments_config VALUES ('img_link_width', '0');
INSERT INTO nuke_bbattachments_config VALUES ('img_link_height', '0');
INSERT INTO nuke_bbattachments_config VALUES ('img_create_thumbnail', '1');
INSERT INTO nuke_bbattachments_config VALUES ('img_min_thumb_filesize', '12000');
INSERT INTO nuke_bbattachments_config VALUES ('img_imagick', '/usr/bin/convert');
INSERT INTO nuke_bbattachments_config VALUES ('use_gd2', '0');
INSERT INTO nuke_bbattachments_config VALUES ('wma_autoplay', '0');
INSERT INTO nuke_bbattachments_config VALUES ('flash_autoplay', '0');

# --------------------------------------------------------
#
# Table structure for table 'nuke_bbattachments_desc'
#

CREATE TABLE nuke_bbattachments_desc (
   attach_id mediumint(8) unsigned NOT NULL auto_increment,
   physical_filename varchar(255) NOT NULL,
   real_filename varchar(255) NOT NULL,
   download_count mediumint(8) unsigned DEFAULT '0' NOT NULL,
   comment varchar(255),
   extension varchar(100),
   mimetype varchar(100),
   filesize int(20) DEFAULT '0' NOT NULL,
   filetime int(11) DEFAULT '0' NOT NULL,
   thumbnail tinyint(1) DEFAULT '0' NOT NULL,
   PRIMARY KEY (attach_id),
   KEY filetime (filetime),
   KEY physical_filename (physical_filename),
   KEY filesize (filesize)
);

#
# Dumping data for table 'nuke_bbattachments_desc'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbauth_access'
#

CREATE TABLE nuke_bbauth_access (
   group_id mediumint(8) DEFAULT '0' NOT NULL,
   forum_id smallint(5) unsigned DEFAULT '0' NOT NULL,
   auth_view tinyint(1) DEFAULT '0' NOT NULL,
   auth_read tinyint(1) DEFAULT '0' NOT NULL,
   auth_post tinyint(1) DEFAULT '0' NOT NULL,
   auth_reply tinyint(1) DEFAULT '0' NOT NULL,
   auth_edit tinyint(1) DEFAULT '0' NOT NULL,
   auth_delete tinyint(1) DEFAULT '0' NOT NULL,
   auth_sticky tinyint(1) DEFAULT '0' NOT NULL,
   auth_announce tinyint(1) DEFAULT '0' NOT NULL,
   auth_globalannounce tinyint(1),
   auth_vote tinyint(1) DEFAULT '0' NOT NULL,
   auth_pollcreate tinyint(1) DEFAULT '0' NOT NULL,
   auth_attachments tinyint(1) DEFAULT '0' NOT NULL,
   auth_mod tinyint(1) DEFAULT '0' NOT NULL,
   auth_download tinyint(1) DEFAULT '0' NOT NULL,
   KEY group_id (group_id),
   KEY forum_id (forum_id)
);

#
# Dumping data for table 'nuke_bbauth_access'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbauth_arcade_access'
#

CREATE TABLE nuke_bbauth_arcade_access (
   group_id mediumint(8) DEFAULT '0' NOT NULL,
   arcade_catid mediumint(8) unsigned DEFAULT '0' NOT NULL,
   KEY group_id (group_id),
   KEY arcade_catid (arcade_catid)
);

#
# Dumping data for table 'nuke_bbauth_arcade_access'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbbanlist'
#

CREATE TABLE nuke_bbbanlist (
   ban_id mediumint(8) unsigned NOT NULL auto_increment,
   ban_userid mediumint(8) DEFAULT '0' NOT NULL,
   ban_ip varchar(8) NOT NULL,
   ban_email varchar(255),
   ban_time int(11),
   ban_expire_time int(11),
   ban_by_userid mediumint(8),
   ban_priv_reason text,
   ban_pub_reason_mode tinyint(1),
   ban_pub_reason text,
   PRIMARY KEY (ban_id),
   KEY ban_ip_user_id (ban_ip, ban_userid)
);

#
# Dumping data for table 'nuke_bbbanlist'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbbuddies'
#

CREATE TABLE nuke_bbbuddies (
   user_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   buddy_id mediumint(8) unsigned DEFAULT '0' NOT NULL
);

#
# Dumping data for table 'nuke_bbbuddies'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbcategories'
#

CREATE TABLE nuke_bbcategories (
   cat_id mediumint(8) unsigned NOT NULL auto_increment,
   cat_title varchar(100),
   cat_order mediumint(8) unsigned DEFAULT '0' NOT NULL,
   PRIMARY KEY (cat_id),
   KEY cat_order (cat_order)
);

#
# Dumping data for table 'nuke_bbcategories'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbconfig'
#

CREATE TABLE nuke_bbconfig (
   config_name varchar(255) NOT NULL,
   config_value varchar(255) NOT NULL,
   PRIMARY KEY (config_name)
);

#
# Dumping data for table 'nuke_bbconfig'
#

INSERT INTO nuke_bbconfig VALUES ('config_id', '1');
INSERT INTO nuke_bbconfig VALUES ('board_disable', '0');
INSERT INTO nuke_bbconfig VALUES ('sitename', 'yoursite.com');
INSERT INTO nuke_bbconfig VALUES ('site_desc', '');
INSERT INTO nuke_bbconfig VALUES ('cookie_name', 'phpbb2mysql');
INSERT INTO nuke_bbconfig VALUES ('cookie_path', '/');
INSERT INTO nuke_bbconfig VALUES ('cookie_domain', 'yoursite.com');
INSERT INTO nuke_bbconfig VALUES ('cookie_secure', '0');
INSERT INTO nuke_bbconfig VALUES ('session_length', '3600');
INSERT INTO nuke_bbconfig VALUES ('allow_html', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_html_tags', 'b,i,u,pre');
INSERT INTO nuke_bbconfig VALUES ('allow_bbcode', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_smilies', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_sig', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_namechange', '0');
INSERT INTO nuke_bbconfig VALUES ('allow_theme_create', '0');
INSERT INTO nuke_bbconfig VALUES ('allow_avatar_local', '1');
INSERT INTO nuke_bbconfig VALUES ('allow_avatar_remote', '0');
INSERT INTO nuke_bbconfig VALUES ('allow_avatar_upload', '0');
INSERT INTO nuke_bbconfig VALUES ('override_user_style', '1');
INSERT INTO nuke_bbconfig VALUES ('posts_per_page', '15');
INSERT INTO nuke_bbconfig VALUES ('topics_per_page', '50');
INSERT INTO nuke_bbconfig VALUES ('hot_threshold', '25');
INSERT INTO nuke_bbconfig VALUES ('max_poll_options', '10');
INSERT INTO nuke_bbconfig VALUES ('max_sig_chars', '255');
INSERT INTO nuke_bbconfig VALUES ('max_inbox_privmsgs', '100');
INSERT INTO nuke_bbconfig VALUES ('max_sentbox_privmsgs', '100');
INSERT INTO nuke_bbconfig VALUES ('max_savebox_privmsgs', '100');
INSERT INTO nuke_bbconfig VALUES ('board_email_sig', 'Thanks, Webmaster@yoursite.com');
INSERT INTO nuke_bbconfig VALUES ('board_email', 'Webmaster@yoursite.com');
INSERT INTO nuke_bbconfig VALUES ('smtp_delivery', '0');
INSERT INTO nuke_bbconfig VALUES ('smtp_host', '');
INSERT INTO nuke_bbconfig VALUES ('require_activation', '0');
INSERT INTO nuke_bbconfig VALUES ('flood_interval', '15');
INSERT INTO nuke_bbconfig VALUES ('board_email_form', '0');
INSERT INTO nuke_bbconfig VALUES ('avatar_filesize', '6144');
INSERT INTO nuke_bbconfig VALUES ('avatar_max_width', '80');
INSERT INTO nuke_bbconfig VALUES ('avatar_max_height', '80');
INSERT INTO nuke_bbconfig VALUES ('avatar_path', 'modules/Forums/images/avatars');
INSERT INTO nuke_bbconfig VALUES ('avatar_gallery_path', 'modules/Forums/images/avatars');
INSERT INTO nuke_bbconfig VALUES ('smilies_path', 'modules/Forums/images/smiles');
INSERT INTO nuke_bbconfig VALUES ('default_style', '1');
INSERT INTO nuke_bbconfig VALUES ('default_dateformat', 'D M d, Y g:i a');
INSERT INTO nuke_bbconfig VALUES ('board_timezone', '10');
INSERT INTO nuke_bbconfig VALUES ('prune_enable', '0');
INSERT INTO nuke_bbconfig VALUES ('privmsg_disable', '0');
INSERT INTO nuke_bbconfig VALUES ('gzip_compress', '0');
INSERT INTO nuke_bbconfig VALUES ('coppa_fax', '');
INSERT INTO nuke_bbconfig VALUES ('coppa_mail', '');
INSERT INTO nuke_bbconfig VALUES ('board_startdate', '1013908210');
INSERT INTO nuke_bbconfig VALUES ('default_lang', 'english');
INSERT INTO nuke_bbconfig VALUES ('smtp_username', '');
INSERT INTO nuke_bbconfig VALUES ('smtp_password', '');
INSERT INTO nuke_bbconfig VALUES ('record_online_users', '4');
INSERT INTO nuke_bbconfig VALUES ('record_online_date', '1099781611');
INSERT INTO nuke_bbconfig VALUES ('server_name', 'http://www.yoursite.com');
INSERT INTO nuke_bbconfig VALUES ('server_port', '80');
INSERT INTO nuke_bbconfig VALUES ('script_path', '');
INSERT INTO nuke_bbconfig VALUES ('version', '.0.11');
INSERT INTO nuke_bbconfig VALUES ('enable_confirm', '0');
INSERT INTO nuke_bbconfig VALUES ('sendmail_fix', '0');
INSERT INTO nuke_bbconfig VALUES ('sub_forum', '1');
INSERT INTO nuke_bbconfig VALUES ('sub_forum_over', '0');
INSERT INTO nuke_bbconfig VALUES ('split_cat', '');
INSERT INTO nuke_bbconfig VALUES ('split_cat_over', '0');
INSERT INTO nuke_bbconfig VALUES ('last_topic_title', '');
INSERT INTO nuke_bbconfig VALUES ('last_topic_title_over', '0');
INSERT INTO nuke_bbconfig VALUES ('last_topic_title_length', '24');
INSERT INTO nuke_bbconfig VALUES ('sub_level_links', '2');
INSERT INTO nuke_bbconfig VALUES ('sub_level_links_over', '0');
INSERT INTO nuke_bbconfig VALUES ('display_viewonline', '2');
INSERT INTO nuke_bbconfig VALUES ('display_viewonline_over', '0');
INSERT INTO nuke_bbconfig VALUES ('split_announce', '0');
INSERT INTO nuke_bbconfig VALUES ('split_global_announce', '0');
INSERT INTO nuke_bbconfig VALUES ('split_sticky', '0');
INSERT INTO nuke_bbconfig VALUES ('allow_custom_rank', '100');
INSERT INTO nuke_bbconfig VALUES ('max_smilies', '15');
INSERT INTO nuke_bbconfig VALUES ('sig_perpage', '0');
INSERT INTO nuke_bbconfig VALUES ('sig_images_max_width', '400');
INSERT INTO nuke_bbconfig VALUES ('sig_images_max_height', '300');
INSERT INTO nuke_bbconfig VALUES ('sig_images_max_limit', '1');
INSERT INTO nuke_bbconfig VALUES ('move_when_locked_stat', '-1');
INSERT INTO nuke_bbconfig VALUES ('move_when_locked_id', '1');
INSERT INTO nuke_bbconfig VALUES ('leave_special_topic_stat', '-1');
INSERT INTO nuke_bbconfig VALUES ('who_is_online_time', '30');
INSERT INTO nuke_bbconfig VALUES ('sig_line', '____________');
INSERT INTO nuke_bbconfig VALUES ('allow_quickreply', '0');
INSERT INTO nuke_bbconfig VALUES ('kicker_setting', '0');
INSERT INTO nuke_bbconfig VALUES ('kicker_view_setting', '0');
INSERT INTO nuke_bbconfig VALUES ('ropm_quick_reply', '1');
INSERT INTO nuke_bbconfig VALUES ('ropm_quick_reply_bbc', '0');
INSERT INTO nuke_bbconfig VALUES ('ropm_quick_reply_smilies', '32');
INSERT INTO nuke_bbconfig VALUES ('guests_need_name', '1');
INSERT INTO nuke_bbconfig VALUES ('max_img_width', '0');
INSERT INTO nuke_bbconfig VALUES ('smilie_columns', '4');
INSERT INTO nuke_bbconfig VALUES ('smilie_rows', '5');
INSERT INTO nuke_bbconfig VALUES ('smilie_window_columns', '8');

# --------------------------------------------------------
#
# Table structure for table `nuke_bbconfirm`
# 

CREATE TABLE `nuke_bbconfirm` (
  `confirm_id` char(32) NOT NULL default '',
  `session_id` char(32) NOT NULL default '',
  `code` char(6) NOT NULL default '',
  PRIMARY KEY  (`session_id`,`confirm_id`)
) TYPE=MyISAM;

# 
# Dumping data for table `nuke_bbconfirm`
# 


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbdisallow'
#

CREATE TABLE nuke_bbdisallow (
   disallow_id mediumint(8) unsigned NOT NULL auto_increment,
   disallow_username varchar(25),
   PRIMARY KEY (disallow_id)
);

#
# Dumping data for table 'nuke_bbdisallow'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbextension_groups'
#

CREATE TABLE nuke_bbextension_groups (
   group_id mediumint(8) NOT NULL auto_increment,
   group_name varchar(20) NOT NULL,
   cat_id tinyint(2) DEFAULT '0' NOT NULL,
   allow_group tinyint(1) DEFAULT '0' NOT NULL,
   download_mode tinyint(1) unsigned DEFAULT '1' NOT NULL,
   upload_icon varchar(100),
   max_filesize int(20) DEFAULT '0' NOT NULL,
   forum_permissions varchar(255) NOT NULL,
   PRIMARY KEY (group_id)
);

#
# Dumping data for table 'nuke_bbextension_groups'
#

INSERT INTO nuke_bbextension_groups VALUES ('1', 'Images', '1', '1', '2', '', '262144', '');
INSERT INTO nuke_bbextension_groups VALUES ('2', 'Archives', '0', '1', '2', '', '262144', '');
INSERT INTO nuke_bbextension_groups VALUES ('3', 'Plain Text', '0', '0', '2', '', '262144', '');
INSERT INTO nuke_bbextension_groups VALUES ('4', 'Documents', '0', '0', '2', '', '262144', '');
INSERT INTO nuke_bbextension_groups VALUES ('5', 'Real Media', '0', '0', '2', '', '262144', '');
INSERT INTO nuke_bbextension_groups VALUES ('6', 'Streams', '2', '0', '2', '', '262144', '');
INSERT INTO nuke_bbextension_groups VALUES ('7', 'Flash Files', '3', '0', '2', '', '262144', '');

# --------------------------------------------------------
#
# Table structure for table 'nuke_bbextensions'
#

CREATE TABLE nuke_bbextensions (
   ext_id mediumint(8) unsigned NOT NULL auto_increment,
   group_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   extension varchar(100) NOT NULL,
   comment varchar(100),
   PRIMARY KEY (ext_id)
);

#
# Dumping data for table 'nuke_bbextensions'
#

INSERT INTO nuke_bbextensions VALUES ('1', '1', 'gif', '');
INSERT INTO nuke_bbextensions VALUES ('2', '1', 'png', '');
INSERT INTO nuke_bbextensions VALUES ('3', '1', 'jpeg', '');
INSERT INTO nuke_bbextensions VALUES ('4', '1', 'jpg', '');
INSERT INTO nuke_bbextensions VALUES ('5', '1', 'tif', '');
INSERT INTO nuke_bbextensions VALUES ('6', '1', 'tga', '');
INSERT INTO nuke_bbextensions VALUES ('7', '2', 'gtar', '');
INSERT INTO nuke_bbextensions VALUES ('8', '2', 'gz', '');
INSERT INTO nuke_bbextensions VALUES ('9', '2', 'tar', '');
INSERT INTO nuke_bbextensions VALUES ('10', '2', 'zip', '');
INSERT INTO nuke_bbextensions VALUES ('11', '2', 'rar', '');
INSERT INTO nuke_bbextensions VALUES ('12', '2', 'ace', '');
INSERT INTO nuke_bbextensions VALUES ('13', '3', 'txt', '');
INSERT INTO nuke_bbextensions VALUES ('14', '3', 'c', '');
INSERT INTO nuke_bbextensions VALUES ('15', '3', 'h', '');
INSERT INTO nuke_bbextensions VALUES ('16', '3', 'cpp', '');
INSERT INTO nuke_bbextensions VALUES ('17', '3', 'hpp', '');
INSERT INTO nuke_bbextensions VALUES ('18', '3', 'diz', '');
INSERT INTO nuke_bbextensions VALUES ('19', '4', 'xls', '');
INSERT INTO nuke_bbextensions VALUES ('20', '4', 'doc', '');
INSERT INTO nuke_bbextensions VALUES ('21', '4', 'dot', '');
INSERT INTO nuke_bbextensions VALUES ('22', '4', 'pdf', '');
INSERT INTO nuke_bbextensions VALUES ('23', '4', 'ai', '');
INSERT INTO nuke_bbextensions VALUES ('24', '4', 'ps', '');
INSERT INTO nuke_bbextensions VALUES ('25', '4', 'ppt', '');
INSERT INTO nuke_bbextensions VALUES ('26', '5', 'rm', '');
INSERT INTO nuke_bbextensions VALUES ('27', '6', 'wma', '');
INSERT INTO nuke_bbextensions VALUES ('28', '7', 'swf', '');

# --------------------------------------------------------
#
# Table structure for table 'nuke_bbforbidden_extensions'
#

CREATE TABLE nuke_bbforbidden_extensions (
   ext_id mediumint(8) unsigned NOT NULL auto_increment,
   extension varchar(100) NOT NULL,
   PRIMARY KEY (ext_id)
);

#
# Dumping data for table 'nuke_bbforbidden_extensions'
#

INSERT INTO nuke_bbforbidden_extensions VALUES ('1', 'php');
INSERT INTO nuke_bbforbidden_extensions VALUES ('2', 'php3');
INSERT INTO nuke_bbforbidden_extensions VALUES ('3', 'php4');
INSERT INTO nuke_bbforbidden_extensions VALUES ('4', 'phtml');
INSERT INTO nuke_bbforbidden_extensions VALUES ('5', 'pl');
INSERT INTO nuke_bbforbidden_extensions VALUES ('6', 'asp');
INSERT INTO nuke_bbforbidden_extensions VALUES ('7', 'cgi');

# --------------------------------------------------------
#
# Table structure for table 'nuke_bbforum_prune'
#

CREATE TABLE nuke_bbforum_prune (
   prune_id mediumint(8) unsigned NOT NULL auto_increment,
   forum_id smallint(5) unsigned DEFAULT '0' NOT NULL,
   prune_days tinyint(4) unsigned DEFAULT '0' NOT NULL,
   prune_freq tinyint(4) unsigned DEFAULT '0' NOT NULL,
   PRIMARY KEY (prune_id),
   KEY forum_id (forum_id)
);

#
# Dumping data for table 'nuke_bbforum_prune'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbforums'
#

CREATE TABLE nuke_bbforums (
   forum_id smallint(5) unsigned NOT NULL auto_increment,
   cat_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   forum_name varchar(150),
   forum_desc text,
   forum_status tinyint(4) DEFAULT '0' NOT NULL,
   forum_order mediumint(8) unsigned DEFAULT '1' NOT NULL,
   forum_posts mediumint(8) unsigned DEFAULT '0' NOT NULL,
   forum_topics mediumint(8) unsigned DEFAULT '0' NOT NULL,
   forum_last_post_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   prune_next int(11),
   prune_enable tinyint(1) DEFAULT '1' NOT NULL,
   auth_view tinyint(2) DEFAULT '0' NOT NULL,
   auth_read tinyint(2) DEFAULT '0' NOT NULL,
   auth_post tinyint(2) DEFAULT '0' NOT NULL,
   auth_reply tinyint(2) DEFAULT '0' NOT NULL,
   auth_edit tinyint(2) DEFAULT '0' NOT NULL,
   auth_delete tinyint(2) DEFAULT '0' NOT NULL,
   auth_sticky tinyint(2) DEFAULT '0' NOT NULL,
   auth_announce tinyint(2) DEFAULT '0' NOT NULL,
   auth_globalannounce tinyint(2) DEFAULT '3' NOT NULL,
   auth_vote tinyint(2) DEFAULT '0' NOT NULL,
   auth_pollcreate tinyint(2) DEFAULT '0' NOT NULL,
   auth_attachments tinyint(2) DEFAULT '0' NOT NULL,
   auth_download tinyint(2) DEFAULT '0' NOT NULL,
   PRIMARY KEY (forum_id),
   KEY forums_order (forum_order),
   KEY cat_id (cat_id),
   KEY forum_last_post_id (forum_last_post_id)
);

#
# Dumping data for table 'nuke_bbforums'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbgamehash'
#

CREATE TABLE nuke_bbgamehash (
   gamehash_id char(32) NOT NULL,
   game_id mediumint(8) DEFAULT '0' NOT NULL,
   user_id mediumint(8) DEFAULT '0' NOT NULL,
   hash_date int(11) DEFAULT '0' NOT NULL
);

#
# Dumping data for table 'nuke_bbgamehash'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbgames'
#

CREATE TABLE nuke_bbgames (
   game_id mediumint(8) NOT NULL auto_increment,
   game_pic varchar(50) NOT NULL,
   game_desc varchar(255) NOT NULL,
   game_highscore int(11) DEFAULT '0' NOT NULL,
   game_highdate int(11) DEFAULT '0' NOT NULL,
   game_highuser mediumint(8) DEFAULT '0' NOT NULL,
   game_name varchar(50) NOT NULL,
   game_swf varchar(50) NOT NULL,
   game_scorevar varchar(20) NOT NULL,
   game_type tinyint(4) DEFAULT '0' NOT NULL,
   game_width mediumint(5) DEFAULT '550' NOT NULL,
   game_height varchar(5) DEFAULT '380' NOT NULL,
   game_order mediumint(8) DEFAULT '0' NOT NULL,
   game_set mediumint(8) DEFAULT '0' NOT NULL,
   arcade_catid mediumint(8) DEFAULT '1' NOT NULL,
   KEY game_id (game_id)
);

#
# Dumping data for table 'nuke_bbgames'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbgroups'
#

CREATE TABLE nuke_bbgroups (
   group_id mediumint(8) NOT NULL auto_increment,
   group_type tinyint(4) DEFAULT '1' NOT NULL,
   group_name varchar(40) NOT NULL,
   group_description varchar(255) NOT NULL,
   group_moderator mediumint(8) DEFAULT '0' NOT NULL,
   group_single_user tinyint(1) DEFAULT '1' NOT NULL,
   PRIMARY KEY (group_id),
   KEY group_single_user (group_single_user)
);

#
# Dumping data for table 'nuke_bbgroups'
#

INSERT INTO nuke_bbgroups VALUES (1, 1, 'Anonymous', 'Personal User', 0, 1);
INSERT INTO nuke_bbgroups VALUES ('2', '2', 'Moderators', 'Moderators of this forum.', '2', '0');

# --------------------------------------------------------
#
# Table structure for table 'nuke_bbhackgame'
#

CREATE TABLE nuke_bbhackgame (
   user_id mediumint(8) DEFAULT '0' NOT NULL,
   game_id mediumint(8) DEFAULT '0' NOT NULL,
   date_hack int(11) DEFAULT '0' NOT NULL
);

#
# Dumping data for table 'nuke_bbhackgame'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbposts'
#

CREATE TABLE nuke_bbposts (
   post_id mediumint(8) unsigned NOT NULL auto_increment,
   topic_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   forum_id smallint(5) unsigned DEFAULT '0' NOT NULL,
   poster_id mediumint(8) DEFAULT '0' NOT NULL,
   post_time int(11) DEFAULT '0' NOT NULL,
   poster_ip varchar(8) NOT NULL,
   post_username varchar(25),
   enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
   enable_html tinyint(1) DEFAULT '0' NOT NULL,
   enable_smilies tinyint(1) DEFAULT '1' NOT NULL,
   enable_sig tinyint(1) DEFAULT '1' NOT NULL,
   post_edit_time int(11),
   post_edit_count smallint(5) unsigned DEFAULT '0' NOT NULL,
   post_attachment tinyint(1) DEFAULT '0' NOT NULL,
   PRIMARY KEY (post_id),
   KEY forum_id (forum_id),
   KEY topic_id (topic_id),
   KEY poster_id (poster_id),
   KEY post_time (post_time)
);

#
# Dumping data for table 'nuke_bbposts'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbposts_text'
#

CREATE TABLE nuke_bbposts_text (
   post_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   bbcode_uid varchar(10) NOT NULL,
   post_subject varchar(60),
   post_text text,
   PRIMARY KEY (post_id)
);

#
# Dumping data for table 'nuke_bbposts_text'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbprivmsgs'
#

CREATE TABLE nuke_bbprivmsgs (
   privmsgs_id mediumint(8) unsigned NOT NULL auto_increment,
   privmsgs_type tinyint(4) DEFAULT '0' NOT NULL,
   privmsgs_subject varchar(255) DEFAULT '0' NOT NULL,
   privmsgs_from_userid mediumint(8) DEFAULT '0' NOT NULL,
   privmsgs_to_userid mediumint(8) DEFAULT '0' NOT NULL,
   privmsgs_date int(11) DEFAULT '0' NOT NULL,
   privmsgs_ip varchar(8) NOT NULL,
   privmsgs_enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
   privmsgs_enable_html tinyint(1) DEFAULT '0' NOT NULL,
   privmsgs_enable_smilies tinyint(1) DEFAULT '1' NOT NULL,
   privmsgs_attach_sig tinyint(1) DEFAULT '1' NOT NULL,
   privmsgs_attachment tinyint(1) DEFAULT '0' NOT NULL,
   PRIMARY KEY (privmsgs_id),
   KEY privmsgs_from_userid (privmsgs_from_userid),
   KEY privmsgs_to_userid (privmsgs_to_userid)
);

#
# Dumping data for table 'nuke_bbprivmsgs'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbprivmsgs_archive'
#

CREATE TABLE nuke_bbprivmsgs_archive (
   privmsgs_id mediumint(8) unsigned NOT NULL auto_increment,
   privmsgs_type tinyint(4) DEFAULT '0' NOT NULL,
   privmsgs_subject varchar(255) DEFAULT '0' NOT NULL,
   privmsgs_from_userid mediumint(8) DEFAULT '0' NOT NULL,
   privmsgs_to_userid mediumint(8) DEFAULT '0' NOT NULL,
   privmsgs_date int(11) DEFAULT '0' NOT NULL,
   privmsgs_ip varchar(8) NOT NULL,
   privmsgs_enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
   privmsgs_enable_html tinyint(1) DEFAULT '0' NOT NULL,
   privmsgs_enable_smilies tinyint(1) DEFAULT '1' NOT NULL,
   privmsgs_attach_sig tinyint(1) DEFAULT '1' NOT NULL,
   PRIMARY KEY (privmsgs_id),
   KEY privmsgs_from_userid (privmsgs_from_userid),
   KEY privmsgs_to_userid (privmsgs_to_userid)
);

#
# Dumping data for table 'nuke_bbprivmsgs_archive'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbprivmsgs_text'
#

CREATE TABLE nuke_bbprivmsgs_text (
   privmsgs_text_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   privmsgs_bbcode_uid varchar(10) DEFAULT '0' NOT NULL,
   privmsgs_text text,
   PRIMARY KEY (privmsgs_text_id)
);

#
# Dumping data for table 'nuke_bbprivmsgs_text'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbquota_limits'
#

CREATE TABLE nuke_bbquota_limits (
   quota_limit_id mediumint(8) unsigned NOT NULL auto_increment,
   quota_desc varchar(20) NOT NULL,
   quota_limit bigint(20) unsigned DEFAULT '0' NOT NULL,
   PRIMARY KEY (quota_limit_id)
);

#
# Dumping data for table 'nuke_bbquota_limits'
#

INSERT INTO nuke_bbquota_limits VALUES ('1', 'Low', '262144');
INSERT INTO nuke_bbquota_limits VALUES ('2', 'Medium', '2097152');
INSERT INTO nuke_bbquota_limits VALUES ('3', 'High', '5242880');

# --------------------------------------------------------
#
# Table structure for table 'nuke_bbranks'
#

CREATE TABLE nuke_bbranks (
   rank_id smallint(5) unsigned NOT NULL auto_increment,
   rank_title varchar(50) NOT NULL,
   rank_min mediumint(8) DEFAULT '0' NOT NULL,
   rank_max mediumint(8) DEFAULT '0' NOT NULL,
   rank_special tinyint(1) DEFAULT '0',
   rank_image varchar(255),
   PRIMARY KEY (rank_id)
);

#
# Dumping data for table 'nuke_bbranks'
#

INSERT INTO nuke_bbranks VALUES (1, 'Site Admin', -1, -1, 1, 'modules/Forums/images/ranks/6stars.gif');
INSERT INTO nuke_bbranks VALUES (2, 'Newbie', 1, 0, 0, 'modules/Forums/images/ranks/1star.gif');

# --------------------------------------------------------
#
# Table structure for table 'nuke_bbreport'
#

CREATE TABLE nuke_bbreport (
   report_id mediumint(9) NOT NULL auto_increment,
   report_type mediumint(9) DEFAULT '0' NOT NULL,
   report_status mediumint(9),
   report_date int(8) DEFAULT '0' NOT NULL,
   report_user_id mediumint(9) DEFAULT '0' NOT NULL,
   report_info varchar(80) NOT NULL,
   text text NOT NULL,
   PRIMARY KEY (report_id)
);

#
# Dumping data for table 'nuke_bbreport'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbreport_cat'
#

CREATE TABLE nuke_bbreport_cat (
   cat_id mediumint(9) NOT NULL auto_increment,
   cat_name varchar(80),
   cat_param varchar(80) NOT NULL,
   cat_explain text NOT NULL,
   PRIMARY KEY (cat_id)
);

#
# Dumping data for table 'nuke_bbreport_cat'
#

INSERT INTO nuke_bbreport_cat VALUES ('1', 'Reported Posts', 'reportpost', 'If a post contains material, which is not allowed on this forum, or if a topic is in a wrong category, you should report the post. A moderator will handle the problem as soon as possible.');

# --------------------------------------------------------
#
# Table structure for table 'nuke_bbreport_config'
#

CREATE TABLE nuke_bbreport_config (
   name varchar(255) NOT NULL,
   value varchar(255),
   PRIMARY KEY (name)
);

#
# Dumping data for table 'nuke_bbreport_config'
#

INSERT INTO nuke_bbreport_config VALUES ('color_0', '#A8371D');
INSERT INTO nuke_bbreport_config VALUES ('color_1', '#297F3F');

# --------------------------------------------------------
#
# Table structure for table 'nuke_bbscores'
#

CREATE TABLE nuke_bbscores (
   game_id mediumint(8) DEFAULT '0' NOT NULL,
   user_id mediumint(8) DEFAULT '0' NOT NULL,
   score_game int(11) DEFAULT '0' NOT NULL,
   score_date int(11) DEFAULT '0' NOT NULL,
   score_time int(11) DEFAULT '0' NOT NULL,
   score_set mediumint(8) DEFAULT '0' NOT NULL,
   KEY game_id (game_id),
   KEY user_id (user_id)
);

#
# Dumping data for table 'nuke_bbscores'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbsearch_results'
#

CREATE TABLE nuke_bbsearch_results (
   search_id int(11) unsigned DEFAULT '0' NOT NULL,
   session_id varchar(32) NOT NULL,
   search_array text NOT NULL,
   PRIMARY KEY (search_id),
   KEY session_id (session_id)
);

#
# Dumping data for table 'nuke_bbsearch_results'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbsearch_wordlist'
#

CREATE TABLE nuke_bbsearch_wordlist (
   word_text varchar(50) binary NOT NULL,
   word_id mediumint(8) unsigned NOT NULL auto_increment,
   word_common tinyint(1) unsigned DEFAULT '0' NOT NULL,
   PRIMARY KEY (word_text),
   KEY word_id (word_id)
);

#
# Dumping data for table 'nuke_bbsearch_wordlist'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbsearch_wordmatch'
#

CREATE TABLE nuke_bbsearch_wordmatch (
   post_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   word_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   title_match tinyint(1) DEFAULT '0' NOT NULL,
   KEY word_id (word_id)
);

#
# Dumping data for table 'nuke_bbsearch_wordmatch'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbsessions'
#

CREATE TABLE nuke_bbsessions (
   session_id char(32) NOT NULL,
   session_user_id mediumint(8) DEFAULT '0' NOT NULL,
   session_start int(11) DEFAULT '0' NOT NULL,
   session_time int(11) DEFAULT '0' NOT NULL,
   session_ip char(8) DEFAULT '0' NOT NULL,
   session_page int(11) DEFAULT '0' NOT NULL,
   session_logged_in tinyint(1) DEFAULT '0' NOT NULL,
   PRIMARY KEY (session_id),
   KEY session_user_id (session_user_id),
   KEY session_id_ip_user_id (session_id, session_ip, session_user_id)
);

#
# Dumping data for table 'nuke_bbsessions'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbsmilies'
#

CREATE TABLE nuke_bbsmilies (
   smilies_id smallint(5) unsigned NOT NULL auto_increment,
   code varchar(50),
   smile_url varchar(100),
   emoticon varchar(75),
   smile_stat mediumint(8) unsigned DEFAULT '0' NOT NULL,
   PRIMARY KEY (smilies_id)
);

#
# Dumping data for table 'nuke_bbsmilies'
#

INSERT INTO nuke_bbsmilies VALUES ('1', ':D', 'icon_biggrin.gif', 'Very Happy', '0');
INSERT INTO nuke_bbsmilies VALUES ('2', ':-D', 'icon_biggrin.gif', 'Very Happy', '0');
INSERT INTO nuke_bbsmilies VALUES ('3', ':grin:', 'icon_biggrin.gif', 'Very Happy', '0');
INSERT INTO nuke_bbsmilies VALUES ('4', ':)', 'icon_smile.gif', 'Smile', '0');
INSERT INTO nuke_bbsmilies VALUES ('5', ':-)', 'icon_smile.gif', 'Smile', '0');
INSERT INTO nuke_bbsmilies VALUES ('6', ':smile:', 'icon_smile.gif', 'Smile', '0');
INSERT INTO nuke_bbsmilies VALUES ('7', ':(', 'icon_sad.gif', 'Sad', '0');
INSERT INTO nuke_bbsmilies VALUES ('8', ':-(', 'icon_sad.gif', 'Sad', '0');
INSERT INTO nuke_bbsmilies VALUES ('9', ':sad:', 'icon_sad.gif', 'Sad', '0');
INSERT INTO nuke_bbsmilies VALUES ('10', ':o', 'icon_surprised.gif', 'Surprised', '0');
INSERT INTO nuke_bbsmilies VALUES ('11', ':-o', 'icon_surprised.gif', 'Surprised', '0');
INSERT INTO nuke_bbsmilies VALUES ('12', ':eek:', 'icon_surprised.gif', 'Surprised', '0');
INSERT INTO nuke_bbsmilies VALUES ('13', '8O', 'icon_eek.gif', 'Shocked', '0');
INSERT INTO nuke_bbsmilies VALUES ('14', '8-O', 'icon_eek.gif', 'Shocked', '0');
INSERT INTO nuke_bbsmilies VALUES ('15', ':shock:', 'icon_eek.gif', 'Shocked', '0');
INSERT INTO nuke_bbsmilies VALUES ('16', ':?', 'icon_confused.gif', 'Confused', '0');
INSERT INTO nuke_bbsmilies VALUES ('17', ':-?', 'icon_confused.gif', 'Confused', '0');
INSERT INTO nuke_bbsmilies VALUES ('18', ':???:', 'icon_confused.gif', 'Confused', '0');
INSERT INTO nuke_bbsmilies VALUES ('19', '8)', 'icon_cool.gif', 'Cool', '0');
INSERT INTO nuke_bbsmilies VALUES ('20', '8-)', 'icon_cool.gif', 'Cool', '0');
INSERT INTO nuke_bbsmilies VALUES ('21', ':cool:', 'icon_cool.gif', 'Cool', '0');
INSERT INTO nuke_bbsmilies VALUES ('22', ':lol:', 'icon_lol.gif', 'Laughing', '0');
INSERT INTO nuke_bbsmilies VALUES ('23', ':x', 'icon_mad.gif', 'Mad', '0');
INSERT INTO nuke_bbsmilies VALUES ('24', ':-x', 'icon_mad.gif', 'Mad', '0');
INSERT INTO nuke_bbsmilies VALUES ('25', ':mad:', 'icon_mad.gif', 'Mad', '0');
INSERT INTO nuke_bbsmilies VALUES ('26', ':P', 'icon_razz.gif', 'Razz', '0');
INSERT INTO nuke_bbsmilies VALUES ('27', ':-P', 'icon_razz.gif', 'Razz', '0');
INSERT INTO nuke_bbsmilies VALUES ('28', ':razz:', 'icon_razz.gif', 'Razz', '0');
INSERT INTO nuke_bbsmilies VALUES ('29', ':oops:', 'icon_redface.gif', 'Embarassed', '0');
INSERT INTO nuke_bbsmilies VALUES ('30', ':cry:', 'icon_cry.gif', 'Crying or Very sad', '0');
INSERT INTO nuke_bbsmilies VALUES ('31', ':evil:', 'icon_evil.gif', 'Evil or Very Mad', '0');
INSERT INTO nuke_bbsmilies VALUES ('32', ':twisted:', 'icon_twisted.gif', 'Twisted Evil', '0');
INSERT INTO nuke_bbsmilies VALUES ('33', ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes', '0');
INSERT INTO nuke_bbsmilies VALUES ('34', ':wink:', 'icon_wink.gif', 'Wink', '0');
INSERT INTO nuke_bbsmilies VALUES ('35', ';)', 'icon_wink.gif', 'Wink', '0');
INSERT INTO nuke_bbsmilies VALUES ('36', ';-)', 'icon_wink.gif', 'Wink', '0');
INSERT INTO nuke_bbsmilies VALUES ('37', ':!:', 'icon_exclaim.gif', 'Exclamation', '0');
INSERT INTO nuke_bbsmilies VALUES ('38', ':?:', 'icon_question.gif', 'Question', '0');
INSERT INTO nuke_bbsmilies VALUES ('39', ':idea:', 'icon_idea.gif', 'Idea', '0');
INSERT INTO nuke_bbsmilies VALUES ('40', ':arrow:', 'icon_arrow.gif', 'Arrow', '0');
INSERT INTO nuke_bbsmilies VALUES ('41', ':|', 'icon_neutral.gif', 'Neutral', '0');
INSERT INTO nuke_bbsmilies VALUES ('42', ':-|', 'icon_neutral.gif', 'Neutral', '0');
INSERT INTO nuke_bbsmilies VALUES ('43', ':neutral:', 'icon_neutral.gif', 'Neutral', '0');
INSERT INTO nuke_bbsmilies VALUES ('44', ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green', '0');

# --------------------------------------------------------
#
# Table structure for table 'nuke_bbthemes'
#

CREATE TABLE nuke_bbthemes (
   themes_id mediumint(8) unsigned NOT NULL auto_increment,
   template_name varchar(30) NOT NULL,
   style_name varchar(30) NOT NULL,
   head_stylesheet varchar(100),
   body_background varchar(100),
   body_bgcolor varchar(6),
   body_text varchar(6),
   body_link varchar(6),
   body_vlink varchar(6),
   body_alink varchar(6),
   body_hlink varchar(6),
   tr_color1 varchar(6),
   tr_color2 varchar(6),
   tr_color3 varchar(6),
   tr_class1 varchar(25),
   tr_class2 varchar(25),
   tr_class3 varchar(25),
   th_color1 varchar(6),
   th_color2 varchar(6),
   th_color3 varchar(6),
   th_class1 varchar(25),
   th_class2 varchar(25),
   th_class3 varchar(25),
   td_color1 varchar(6),
   td_color2 varchar(6),
   td_color3 varchar(6),
   td_class1 varchar(25),
   td_class2 varchar(25),
   td_class3 varchar(25),
   fontface1 varchar(50),
   fontface2 varchar(50),
   fontface3 varchar(50),
   fontsize1 tinyint(4),
   fontsize2 tinyint(4),
   fontsize3 tinyint(4),
   fontcolor1 varchar(6),
   fontcolor2 varchar(6),
   fontcolor3 varchar(6),
   span_class1 varchar(25),
   span_class2 varchar(25),
   span_class3 varchar(25),
   img_size_poll smallint(5) unsigned,
   img_size_privmsg smallint(5) unsigned,
   online_color varchar(6),
   offline_color varchar(6),
   hidden_color varchar(6),
   PRIMARY KEY (themes_id)
);

#
# Dumping data for table 'nuke_bbthemes'
#

INSERT INTO nuke_bbthemes VALUES ('1', 'subSilver', 'subSilver', 'subSilver.css', '', '0E3259', '000000', '006699', '5493B4', '', 'DD6900', 'EFEFEF', 'DEE3E7', 'D1D7DC', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, \'Courier New\', sans-serif', '10', '11', '12', '444444', '006600', 'FFA34F', '', '', '', NULL, NULL, '008500', 'DF0000', 'EBD400');

# --------------------------------------------------------
#
# Table structure for table 'nuke_bbthemes_name'
#

CREATE TABLE nuke_bbthemes_name (
   themes_id smallint(5) unsigned DEFAULT '0' NOT NULL,
   tr_color1_name char(50),
   tr_color2_name char(50),
   tr_color3_name char(50),
   tr_class1_name char(50),
   tr_class2_name char(50),
   tr_class3_name char(50),
   th_color1_name char(50),
   th_color2_name char(50),
   th_color3_name char(50),
   th_class1_name char(50),
   th_class2_name char(50),
   th_class3_name char(50),
   td_color1_name char(50),
   td_color2_name char(50),
   td_color3_name char(50),
   td_class1_name char(50),
   td_class2_name char(50),
   td_class3_name char(50),
   fontface1_name char(50),
   fontface2_name char(50),
   fontface3_name char(50),
   fontsize1_name char(50),
   fontsize2_name char(50),
   fontsize3_name char(50),
   fontcolor1_name char(50),
   fontcolor2_name char(50),
   fontcolor3_name char(50),
   span_class1_name char(50),
   span_class2_name char(50),
   span_class3_name char(50),
   PRIMARY KEY (themes_id)
);

#
# Dumping data for table 'nuke_bbthemes_name'
#

INSERT INTO nuke_bbthemes_name VALUES ('1', 'The lightest row colour', 'The medium row color', 'The darkest row colour', '', '', '', 'Border round the whole page', 'Outer table border', 'Inner table border', 'Silver gradient picture', 'Blue gradient picture', 'Fade-out gradient on index', 'Background for quote boxes', 'All white areas', '', 'Background for topic posts', '2nd background for topic posts', '', 'Main fonts', 'Additional topic title font', 'Form fonts', 'Smallest font size', 'Medium font size', 'Normal font size (post body etc)', 'Quote & copyright text', 'Code text colour', 'Main table header text colour', '', '', '');

# --------------------------------------------------------
#
# Table structure for table 'nuke_bbthread_kicker'
#

CREATE TABLE nuke_bbthread_kicker (
   kick_id int(11) NOT NULL auto_increment,
   user_id int(11) DEFAULT '0' NOT NULL,
   topic_id int(11) DEFAULT '0' NOT NULL,
   kicker int(11) DEFAULT '0' NOT NULL,
   post_id int(11) DEFAULT '0' NOT NULL,
   kick_time int(11) DEFAULT '0' NOT NULL,
   kicker_status int(2) DEFAULT '0' NOT NULL,
   kicker_username varchar(30) NOT NULL,
   kicked_username varchar(30) NOT NULL,
   topic_title varchar(60) NOT NULL,
   PRIMARY KEY (kick_id)
);

#
# Dumping data for table 'nuke_bbthread_kicker'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbtopics'
#

CREATE TABLE nuke_bbtopics (
   topic_id mediumint(8) unsigned NOT NULL auto_increment,
   forum_id smallint(8) unsigned DEFAULT '0' NOT NULL,
   topic_title char(60) NOT NULL,
   topic_poster mediumint(8) DEFAULT '0' NOT NULL,
   topic_time int(11) DEFAULT '0' NOT NULL,
   topic_views mediumint(8) unsigned DEFAULT '0' NOT NULL,
   topic_replies mediumint(8) unsigned DEFAULT '0' NOT NULL,
   topic_status tinyint(3) DEFAULT '0' NOT NULL,
   topic_vote tinyint(1) DEFAULT '0' NOT NULL,
   topic_type tinyint(3) DEFAULT '0' NOT NULL,
   topic_last_post_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   topic_first_post_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   topic_moved_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   topic_attachment tinyint(1) DEFAULT '0' NOT NULL,
   PRIMARY KEY (topic_id),
   KEY forum_id (forum_id),
   KEY topic_moved_id (topic_moved_id),
   KEY topic_status (topic_status),
   KEY topic_type (topic_type)
);

#
# Dumping data for table 'nuke_bbtopics'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbtopics_watch'
#

CREATE TABLE nuke_bbtopics_watch (
   topic_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   user_id mediumint(8) DEFAULT '0' NOT NULL,
   notify_status tinyint(1) DEFAULT '0' NOT NULL,
   KEY topic_id (topic_id),
   KEY user_id (user_id),
   KEY notify_status (notify_status)
);

#
# Dumping data for table 'nuke_bbtopics_watch'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbuser_group'
#

CREATE TABLE nuke_bbuser_group (
   group_id mediumint(8) DEFAULT '0' NOT NULL,
   user_id mediumint(8) DEFAULT '0' NOT NULL,
   user_pending tinyint(1),
   KEY group_id (group_id),
   KEY user_id (user_id)
);

#
# Dumping data for table 'nuke_bbuser_group'
#

INSERT INTO nuke_bbuser_group VALUES ('1', '-1', '0');
INSERT INTO nuke_bbuser_group VALUES ('2', '2', '0');

# --------------------------------------------------------
#
# Table structure for table 'nuke_bbvote_desc'
#

CREATE TABLE nuke_bbvote_desc (
   vote_id mediumint(8) unsigned NOT NULL auto_increment,
   topic_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   vote_text text NOT NULL,
   vote_start int(11) DEFAULT '0' NOT NULL,
   vote_length int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (vote_id),
   KEY topic_id (topic_id)
);

#
# Dumping data for table 'nuke_bbvote_desc'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbvote_results'
#

CREATE TABLE nuke_bbvote_results (
   vote_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   vote_option_id tinyint(4) unsigned DEFAULT '0' NOT NULL,
   vote_option_text varchar(255) NOT NULL,
   vote_result int(11) DEFAULT '0' NOT NULL,
   KEY vote_option_id (vote_option_id),
   KEY vote_id (vote_id)
);

#
# Dumping data for table 'nuke_bbvote_results'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbvote_voters'
#

CREATE TABLE nuke_bbvote_voters (
   vote_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
   vote_user_id mediumint(8) DEFAULT '0' NOT NULL,
   vote_user_ip char(8) NOT NULL,
   vote_cast tinyint(4) unsigned DEFAULT '0' NOT NULL,
   KEY vote_id (vote_id),
   KEY vote_user_id (vote_user_id),
   KEY vote_user_ip (vote_user_ip)
);

#
# Dumping data for table 'nuke_bbvote_voters'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_bbwords'
#

CREATE TABLE nuke_bbwords (
   word_id mediumint(8) unsigned NOT NULL auto_increment,
   word char(100) NOT NULL,
   replacement char(100) NOT NULL,
   PRIMARY KEY (word_id)
);

#
# Dumping data for table 'nuke_bbwords'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_blocked'
#

CREATE TABLE nuke_blocked (
   id int(11) NOT NULL auto_increment,
   ip_from int(11) unsigned DEFAULT '0' NOT NULL,
   ip_to int(11) unsigned DEFAULT '0' NOT NULL,
   date int(11),
   info text,
   pers_info varchar(255),
   hits int(4) DEFAULT '0' NOT NULL,
   user varchar(40),
   range int(3),
   time_limit varchar(20) DEFAULT 'NO' NOT NULL,
   banned varchar(40),
   PRIMARY KEY (id),
   KEY ip_from (ip_from, banned)
);

#
# Dumping data for table 'nuke_blocked'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_blocked_agent'
#

CREATE TABLE nuke_blocked_agent (
   agent varchar(150) NOT NULL,
   cookie varchar(50) NOT NULL,
   type varchar(15) NOT NULL
);

#
# Dumping data for table 'nuke_blocked_agent'
#

INSERT INTO nuke_blocked_agent VALUES ('', 'admin', 'cookie');
INSERT INTO nuke_blocked_agent VALUES ('', 'user', 'cookie');
INSERT INTO nuke_blocked_agent VALUES ('', 'lang', 'cookie');
INSERT INTO nuke_blocked_agent VALUES ('', 'msa_resolution', 'cookie');
INSERT INTO nuke_blocked_agent VALUES ('', 'phpbb2mysql_data', 'cookie');

# --------------------------------------------------------
#
# Table structure for table 'nuke_blocked_config'
#

CREATE TABLE nuke_blocked_config (
   system_version varchar(40) NOT NULL,
   auto_prune int(11) DEFAULT '0' NOT NULL,
   tracker_max varchar(10),
   rem_url varchar(100),
   rem_url_on int(11) DEFAULT '0' NOT NULL,
   tracker_del int(11) DEFAULT '0' NOT NULL,
   prune_method int(11) DEFAULT '0' NOT NULL,
   optimize_date varchar(14) NOT NULL,
   mail_admin int(11) DEFAULT '0' NOT NULL,
   inactive_time int(11) DEFAULT '0' NOT NULL,
   error_report int(3) DEFAULT '0' NOT NULL,
   sec_cookie int(3) DEFAULT '0' NOT NULL,
   sec_get int(3) DEFAULT '0' NOT NULL,
   sec_post int(3) DEFAULT '0' NOT NULL,
   query_site varchar(100),
   prune_date varchar(14),
   own_mail varchar(50),
   sec_code varchar(50),
   conf_host int(11),
   god_only int(11) DEFAULT '1' NOT NULL,
   sound_alert int(11) DEFAULT '0' NOT NULL,
   mail_module int(11) DEFAULT '0' NOT NULL,
   ps_time_zone tinyint(4) DEFAULT '0' NOT NULL
);

#
# Dumping data for table 'nuke_blocked_config'
#

INSERT INTO nuke_blocked_config VALUES ('1.15.b3', '0', '50', 'www.fbi.gov', '0', '1', '0', '1099462933', '0', '0', '0', '0', '1', '1', 'http://samspade.org/t/ipwhois?a=', '7', NULL, '69186xUtH.qAra-atrewrutEF+7ubrEt*tr', '1', '1', '0', '0', '0');

# --------------------------------------------------------
#
# Table structure for table 'nuke_blocked_denymod'
#

CREATE TABLE nuke_blocked_denymod (
   id int(11) NOT NULL auto_increment,
   user varchar(30),
   d_mod varchar(30),
   PRIMARY KEY (id),
   KEY user (user, d_mod)
);

#
# Dumping data for table 'nuke_blocked_denymod'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_blocked_hammer'
#

CREATE TABLE nuke_blocked_hammer (
   id int(11) NOT NULL auto_increment,
   hammer_time int(11),
   hammer_limit int(11),
   hammer_protect int(3),
   close_site_blocked int(3),
   hammer_hit int(3),
   site_p_info varchar(250),
   site_protect_admin int(3),
   refuse_proxy int(3),
   auto_protect int(3) DEFAULT '0' NOT NULL,
   auto_protect_hard int(3) DEFAULT '0' NOT NULL,
   protect_admin_hard int(3) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id)
);

#
# Dumping data for table 'nuke_blocked_hammer'
#

INSERT INTO nuke_blocked_hammer VALUES ('1', '180', '90', '0', '0', '30', 'Insert a reason why your site is closed!', '1', NULL, '0', '0', '0');

# --------------------------------------------------------
#
# Table structure for table 'nuke_blocked_iplist'
#

CREATE TABLE nuke_blocked_iplist (
   id int(11) NOT NULL auto_increment,
   ip int(11) unsigned DEFAULT '0' NOT NULL,
   ip_proxy int(11) unsigned DEFAULT '0' NOT NULL,
   user varchar(40),
   last_seen int(11) unsigned DEFAULT '0' NOT NULL,
   reg_date int(11) unsigned DEFAULT '0' NOT NULL,
   notes int(3) DEFAULT '0' NOT NULL,
   hammer_now int(11) unsigned DEFAULT '0' NOT NULL,
   hammer_hits int(11) DEFAULT '0' NOT NULL,
   admin_access int(11) DEFAULT '0' NOT NULL,
   admin_access_date int(11) DEFAULT '0' NOT NULL,
   admin_access_hits int(11) DEFAULT '0' NOT NULL,
   blocker_time int(11) unsigned DEFAULT '0' NOT NULL,
   ps_adm int(11) DEFAULT '0' NOT NULL,
   ps_tot_hits int(11) DEFAULT '0' NOT NULL,
   ps_referer varchar(150),
   agent_fetch varchar(100),
   first_page varchar(250),
   blocker_host varchar(100),
   PRIMARY KEY (id),
   KEY blocker_host (blocker_host),
   KEY ip (ip, user)
);

#
# Dumping data for table 'nuke_blocked_iplist'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_blocked_iptoc'
#

CREATE TABLE nuke_blocked_iptoc (
   ip_from int(10) unsigned zerofill DEFAULT '0000000000' NOT NULL,
   ip_to int(10) unsigned zerofill DEFAULT '0000000000' NOT NULL,
   country_code2 char(2) NOT NULL,
   country_code3 char(3) NOT NULL,
   country_name varchar(50) NOT NULL,
   PRIMARY KEY (ip_from, ip_to)
);

#
# Dumping data for table 'nuke_blocked_iptoc'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_blocked_notes'
#

CREATE TABLE nuke_blocked_notes (
   id int(11) NOT NULL auto_increment,
   spec_notes varchar(250),
   id_locate int(11),
   submitter varchar(30),
   date int(11),
   edited varchar(250),
   PRIMARY KEY (id),
   KEY id_locate (id_locate)
);

#
# Dumping data for table 'nuke_blocked_notes'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_blocked_pagetracker'
#

CREATE TABLE nuke_blocked_pagetracker (
   id int(11) NOT NULL auto_increment,
   id_tracker int(11),
   last_page varchar(250),
   page_date int(11) unsigned DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY id_tracker (id_tracker)
);

#
# Dumping data for table 'nuke_blocked_pagetracker'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_blocked_promod'
#

CREATE TABLE nuke_blocked_promod (
   id int(11) NOT NULL auto_increment,
   promod varchar(40),
   PRIMARY KEY (id)
);

#
# Dumping data for table 'nuke_blocked_promod'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_blocked_promodip'
#

CREATE TABLE nuke_blocked_promodip (
   id int(11) NOT NULL auto_increment,
   promodip varchar(40),
   promod_user varchar(20),
   promod_user_mod varchar(20),
   PRIMARY KEY (id),
   KEY promodip (promodip, promod_user)
);

#
# Dumping data for table 'nuke_blocked_promodip'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_blocked_protected'
#

CREATE TABLE nuke_blocked_protected (
   id int(11) NOT NULL auto_increment,
   ip_protect int(11) unsigned DEFAULT '0' NOT NULL,
   user varchar(40),
   PRIMARY KEY (id)
);

#
# Dumping data for table 'nuke_blocked_protected'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_blocked_ref'
#

CREATE TABLE nuke_blocked_ref (
   referer varchar(150) NOT NULL,
   type varchar(15) NOT NULL
);

#
# Dumping data for table 'nuke_blocked_ref'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_blocked_reflist'
#

CREATE TABLE nuke_blocked_reflist (
   id int(11) NOT NULL auto_increment,
   ps_referer varchar(150),
   user varchar(50),
   ip int(11) unsigned DEFAULT '0' NOT NULL,
   date int(11) unsigned DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY user (user)
);

#
# Dumping data for table 'nuke_blocked_reflist'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_blocked_robot'
#

CREATE TABLE nuke_blocked_robot (
   id int(11) NOT NULL auto_increment,
   robot_ip varchar(40),
   robot_host varchar(100),
   PRIMARY KEY (id),
   KEY robot_ip (robot_ip)
);

#
# Dumping data for table 'nuke_blocked_robot'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_blocked_settings'
#

CREATE TABLE nuke_blocked_settings (
   id int(11) NOT NULL auto_increment,
   banned_rows tinyint(3),
   iplist_rows tinyint(3),
   s_user varchar(30),
   PRIMARY KEY (id)
);

#
# Dumping data for table 'nuke_blocked_settings'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_blocks'
#

CREATE TABLE nuke_blocks (
   bid int(10) NOT NULL auto_increment,
   bkey varchar(15) NOT NULL,
   title varchar(60) NOT NULL,
   content text NOT NULL,
   url varchar(200) NOT NULL,
   bposition char(1) NOT NULL,
   weight int(10) DEFAULT '1' NOT NULL,
   active int(1) DEFAULT '1' NOT NULL,
   refresh int(10) DEFAULT '0' NOT NULL,
   time varchar(14) DEFAULT '0' NOT NULL,
   blanguage varchar(30) NOT NULL,
   blockfile varchar(255) NOT NULL,
   view int(1) DEFAULT '0' NOT NULL,
   groups text NOT NULL,
   expire varchar(14) DEFAULT '0' NOT NULL,
   action char(1) NOT NULL,
   subscription int(1) DEFAULT '0' NOT NULL,
   display varchar(255) DEFAULT 'All' NOT NULL,
   PRIMARY KEY (bid),
   KEY bid (bid),
   KEY title (title)
);

#
# Dumping data for table 'nuke_blocks'
#

INSERT INTO nuke_blocks VALUES ('1', '', 'Navigation', '', '', 'l', '1', '1', '1800', '', '', 'block-Navigation.php', '0', '', '0', 'd', '0', 'All');
INSERT INTO nuke_blocks VALUES ('2', '', 'Administration', '', '', 'l', '2', '1', '1800', '', '', 'block-Admin.php', '2', '', '0', 'd', '1', 'All');
INSERT INTO nuke_blocks VALUES ('3', '', 'Submissions', '', '', 'l', '3', '1', '1800', '', '', 'block-Admin_Submissions.php', '2', '', '0', 'd', '1', 'All');
INSERT INTO nuke_blocks VALUES ('4', '', 'Total Hits', '', '', 'l', '4', '1', '1800', '', '', 'block-Total_Hits.php', '0', '', '0', 'd', '0', 'All');
INSERT INTO nuke_blocks VALUES ('5', '', 'Who is Online', '', '', 'l', '6', '1', '1800', '', '', 'block-Who_is_Online.php', '0', '', '0', 'd', '0', 'All');
INSERT INTO nuke_blocks VALUES ('6', '', 'Support Platinum', '', '', 'r', '1', '1', '1800', '', '', 'block-Platinum_Support.php', '0', '', '0', 'd', '0', 'All');
INSERT INTO nuke_blocks VALUES ('7', '', 'User Information', '', '', 'r', '2', '1', '1800', '', '', 'block-User_Info.php', '0', '', '0', 'd', '0', 'All');
INSERT INTO nuke_blocks VALUES ('8', '', 'Survey', '', '', 'r', '3', '1', '1800', '', '', 'block-Survey.php', '0', '', '0', 'd', '0', 'All');
INSERT INTO nuke_blocks VALUES ('9', '', 'Shout Box', '', '', 'r', '4', '1', '1800', '', '', 'block-Shout_Box.php', '0', '', '0', 'd', '0', 'All');
INSERT INTO nuke_blocks VALUES ('10', '', 'Search', '', '', 'r', '5', '1', '1800', '', '', 'block-Search.php', '0', '', '0', 'd', '0', 'All');
INSERT INTO nuke_blocks VALUES ('11', '', 'Banner Clients', '', '', 'r', '6', '1', '1800', '', '', 'block-Client_Login.php', '0', '', '0', 'd', '0', 'All');
INSERT INTO nuke_blocks VALUES ('12', '', 'PHP-Nuke Platinum Installed!', '', '', 'c', '1', '1', '1800', '', '', 'block-Install.php', '0', '', '0', 'd', '0', 'All');
INSERT INTO nuke_blocks VALUES ('13', '', 'Supporters', '', '', 'c', '2', '1', '1800', '', '', 'block-Supporters_Up.php', '0', '', '0', 'd', '0', 'All');
INSERT INTO nuke_blocks VALUES ('14', '', 'Server Stats', '', '', 'l', '5', '1', '1800', '', '', 'block-Server_Stats.php', '0', '', '0', 'd', '0', 'All');

# --------------------------------------------------------
#
# Table structure for table 'nuke_calendar_categories'
#

CREATE TABLE nuke_calendar_categories (
   id int(11) NOT NULL auto_increment,
   title varchar(128) NOT NULL,
   description text NOT NULL,
   showinblock tinyint(1) DEFAULT '1' NOT NULL,
   KEY id (id)
);

#
# Dumping data for table 'nuke_calendar_categories'
#

INSERT INTO nuke_calendar_categories VALUES ('1', 'Generic', 'This is a generic event.', '1');

# --------------------------------------------------------
#
# Table structure for table 'nuke_calendar_events'
#

CREATE TABLE nuke_calendar_events (
   id int(11) NOT NULL auto_increment,
   title varchar(50) NOT NULL,
   location varchar(64) NOT NULL,
   starttime time DEFAULT '00:00:00' NOT NULL,
   duration time DEFAULT '00:00:00' NOT NULL,
   fulldesc text NOT NULL,
   isactive tinyint(1) DEFAULT '1' NOT NULL,
   isrecurring tinyint(1) DEFAULT '0' NOT NULL,
   categoryid int(11) DEFAULT '1' NOT NULL,
   isapproved tinyint(1) DEFAULT '0' NOT NULL,
   onetime_date date DEFAULT '0000-00-00' NOT NULL,
   recur_weekday tinyint(4) DEFAULT '0' NOT NULL,
   recur_schedule enum('weekly','monthly','yearly') DEFAULT 'weekly' NOT NULL,
   recur_period tinyint(4),
   recur_month tinyint(4),
   KEY id (id)
);

#
# Dumping data for table 'nuke_calendar_events'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_calendar_options'
#

CREATE TABLE nuke_calendar_options (
   allow_user_submitted_events tinyint(1) DEFAULT '0' NOT NULL,
   user_submitted_events_need_admin_aproval tinyint(1) DEFAULT '1' NOT NULL,
   calendar_title varchar(128) DEFAULT 'Calendar of Events' NOT NULL,
   calendar_title_image varchar(255) NOT NULL,
   show_n_events tinyint(6) unsigned DEFAULT '5' NOT NULL,
   in_n_days int(11) unsigned DEFAULT '90' NOT NULL,
   show_bydate_in_block tinyint(1) DEFAULT '1' NOT NULL,
   show_yearly_in_block tinyint(1) DEFAULT '1' NOT NULL,
   show_yearly_recurring_in_block tinyint(1) DEFAULT '1' NOT NULL,
   show_monthly_in_block tinyint(1) DEFAULT '1' NOT NULL,
   show_monthly_recurring_in_block tinyint(1) DEFAULT '1' NOT NULL,
   show_weekly_in_block tinyint(1) DEFAULT '1' NOT NULL,
   month_day_color varchar(6) DEFAULT 'ECECEC' NOT NULL,
   month_today_color varchar(6) DEFAULT 'FFFFFF' NOT NULL,
   month_hover_color varchar(6) DEFAULT 'C0C0C0' NOT NULL,
   show_mdy tinyint(1) DEFAULT '1' NOT NULL
);

#
# Dumping data for table 'nuke_calendar_options'
#

INSERT INTO nuke_calendar_options VALUES ('1', '1', 'Calendar of Events', '', '5', '120', '1', '0', '0', '0', '1', '0', 'E0E0F0', 'EFEFFA', 'EFEFFA', '1');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_brands'
#

CREATE TABLE nuke_cart_brands (
   brand_id int(11) NOT NULL auto_increment,
   brand_name text NOT NULL,
   brand_url text NOT NULL,
   brand_info text NOT NULL,
   creation_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   PRIMARY KEY (brand_id),
   KEY brandID (brand_id)
);

#
# Dumping data for table 'nuke_cart_brands'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_cartitems'
#

CREATE TABLE nuke_cart_cartitems (
   userID varchar(32) DEFAULT '0' NOT NULL,
   userType varchar(10) NOT NULL,
   itemID bigint(20) NOT NULL auto_increment,
   prodID int(11) DEFAULT '0' NOT NULL,
   optID text,
   qty int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (itemID)
);

#
# Dumping data for table 'nuke_cart_cartitems'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_categories'
#

CREATE TABLE nuke_cart_categories (
   category_id int(11) NOT NULL auto_increment,
   title varchar(50) NOT NULL,
   cdescription text NOT NULL,
   ldescription text NOT NULL,
   keywords text NOT NULL,
   parentid int(11) DEFAULT '0' NOT NULL,
   categoryTemplate varchar(255) NOT NULL,
   date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   PRIMARY KEY (category_id),
   KEY cid (category_id)
);

#
# Dumping data for table 'nuke_cart_categories'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_config'
#

CREATE TABLE nuke_cart_config (
   config_name varchar(255) NOT NULL,
   config_value text NOT NULL
);

#
# Dumping data for table 'nuke_cart_config'
#

INSERT INTO nuke_cart_config VALUES ('companyName', 'Your Company Name');
INSERT INTO nuke_cart_config VALUES ('companyInfo', 'Your Store Description');
INSERT INTO nuke_cart_config VALUES ('companyLogo', '');
INSERT INTO nuke_cart_config VALUES ('companyAddress1', '1234 Alfalfa Ct.');
INSERT INTO nuke_cart_config VALUES ('companyAddress2', '');
INSERT INTO nuke_cart_config VALUES ('companyCity', 'Nuketown');
INSERT INTO nuke_cart_config VALUES ('companyState', 'Nukeland');
INSERT INTO nuke_cart_config VALUES ('companyCountry', 'United States');
INSERT INTO nuke_cart_config VALUES ('companyZip', '12345');
INSERT INTO nuke_cart_config VALUES ('companyPhone', '(123) 456-7890');
INSERT INTO nuke_cart_config VALUES ('companyFax', '(123) 456-7891');
INSERT INTO nuke_cart_config VALUES ('cartdomainProtocol', 'http://');
INSERT INTO nuke_cart_config VALUES ('cartdomainURL', 'yourdomain.com/');
INSERT INTO nuke_cart_config VALUES ('cartadminmail', 'admin@yoursite.com');
INSERT INTO nuke_cart_config VALUES ('pagetitle', 'Online Catalogue');
INSERT INTO nuke_cart_config VALUES ('promoTemplate', 'emporiumbasic');
INSERT INTO nuke_cart_config VALUES ('categoryTemplate', 'amazon');
INSERT INTO nuke_cart_config VALUES ('productTemplate', 'emporiumbasic');
INSERT INTO nuke_cart_config VALUES ('viewrightblocks', '1');
INSERT INTO nuke_cart_config VALUES ('userereceipt', '1');
INSERT INTO nuke_cart_config VALUES ('adminereceipt', '1');
INSERT INTO nuke_cart_config VALUES ('sessionfile', 'cookie');
INSERT INTO nuke_cart_config VALUES ('guestCart', '1');
INSERT INTO nuke_cart_config VALUES ('guestCheckout', '1');
INSERT INTO nuke_cart_config VALUES ('thumbFolder', 'images/emporium/products/thumbnails/');
INSERT INTO nuke_cart_config VALUES ('mediaFolder', 'images/emporium/products/media/');
INSERT INTO nuke_cart_config VALUES ('thumbWidth', '80');
INSERT INTO nuke_cart_config VALUES ('imageSoftware', 'gd');
INSERT INTO nuke_cart_config VALUES ('imageSoftwarePath', '');
INSERT INTO nuke_cart_config VALUES ('autoStockRemove', '1');
INSERT INTO nuke_cart_config VALUES ('co_req_shipping_firstname', '1');
INSERT INTO nuke_cart_config VALUES ('co_req_shipping_lastname', '1');
INSERT INTO nuke_cart_config VALUES ('co_req_shipping_address1', '1');
INSERT INTO nuke_cart_config VALUES ('co_req_shipping_address2', '');
INSERT INTO nuke_cart_config VALUES ('co_req_shipping_city', '1');
INSERT INTO nuke_cart_config VALUES ('co_req_shipping_state', '1');
INSERT INTO nuke_cart_config VALUES ('co_req_shipping_zip', '1');
INSERT INTO nuke_cart_config VALUES ('co_req_shipping_country', '1');
INSERT INTO nuke_cart_config VALUES ('co_req_billing_firstname', '1');
INSERT INTO nuke_cart_config VALUES ('co_req_billing_lastname', '1');
INSERT INTO nuke_cart_config VALUES ('co_req_billing_address1', '1');
INSERT INTO nuke_cart_config VALUES ('co_req_billing_address2', '');
INSERT INTO nuke_cart_config VALUES ('co_req_billing_city', '1');
INSERT INTO nuke_cart_config VALUES ('co_req_billing_state', '1');
INSERT INTO nuke_cart_config VALUES ('co_req_billing_zip', '1');
INSERT INTO nuke_cart_config VALUES ('co_req_billing_country', '1');
INSERT INTO nuke_cart_config VALUES ('co_req_billing_email', '1');
INSERT INTO nuke_cart_config VALUES ('co_req_billing_dayphone', '1');
INSERT INTO nuke_cart_config VALUES ('co_req_billing_evephone', '1');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_countries'
#

CREATE TABLE nuke_cart_countries (
   countryID int(11) NOT NULL auto_increment,
   countryName varchar(50) NOT NULL,
   countryCode char(2) NOT NULL,
   PRIMARY KEY (countryID),
   KEY countryID (countryID)
);

#
# Dumping data for table 'nuke_cart_countries'
#

INSERT INTO nuke_cart_countries VALUES ('1', 'Afghanistan', 'AF');
INSERT INTO nuke_cart_countries VALUES ('2', 'Albania', 'AL');
INSERT INTO nuke_cart_countries VALUES ('3', 'Algeria', 'DZ');
INSERT INTO nuke_cart_countries VALUES ('4', 'American Samoa', 'AS');
INSERT INTO nuke_cart_countries VALUES ('5', 'Andorra', 'AD');
INSERT INTO nuke_cart_countries VALUES ('6', 'Angola', 'AO');
INSERT INTO nuke_cart_countries VALUES ('7', 'Anguilla', 'AI');
INSERT INTO nuke_cart_countries VALUES ('8', 'Antarctica', 'AQ');
INSERT INTO nuke_cart_countries VALUES ('9', 'Antigua and Barbuda', 'AG');
INSERT INTO nuke_cart_countries VALUES ('10', 'Argentina', 'AR');
INSERT INTO nuke_cart_countries VALUES ('11', 'Armenia', 'AM');
INSERT INTO nuke_cart_countries VALUES ('12', 'Aruba', 'AW');
INSERT INTO nuke_cart_countries VALUES ('13', 'Australia', 'AU');
INSERT INTO nuke_cart_countries VALUES ('14', 'Austria', 'AT');
INSERT INTO nuke_cart_countries VALUES ('15', 'Azerbaijan', 'AZ');
INSERT INTO nuke_cart_countries VALUES ('16', 'Bahamas', 'BS');
INSERT INTO nuke_cart_countries VALUES ('17', 'Bahrain', 'BH');
INSERT INTO nuke_cart_countries VALUES ('18', 'Bangladesh', 'BD');
INSERT INTO nuke_cart_countries VALUES ('19', 'Barbados', 'BB');
INSERT INTO nuke_cart_countries VALUES ('20', 'Belarus', 'BY');
INSERT INTO nuke_cart_countries VALUES ('21', 'Belgium', 'BE');
INSERT INTO nuke_cart_countries VALUES ('22', 'Belize', 'BZ');
INSERT INTO nuke_cart_countries VALUES ('23', 'Benin', 'BJ');
INSERT INTO nuke_cart_countries VALUES ('24', 'Bermuda', 'BM');
INSERT INTO nuke_cart_countries VALUES ('25', 'Bhutan', 'BT');
INSERT INTO nuke_cart_countries VALUES ('26', 'Bolivia', 'BO');
INSERT INTO nuke_cart_countries VALUES ('27', 'Bosnia and Herzegowina', 'BA');
INSERT INTO nuke_cart_countries VALUES ('28', 'Botswana', 'BW');
INSERT INTO nuke_cart_countries VALUES ('29', 'Bouvet Island', 'BV');
INSERT INTO nuke_cart_countries VALUES ('30', 'Brazil', 'BR');
INSERT INTO nuke_cart_countries VALUES ('31', 'British Indian Ocean Territory', 'IO');
INSERT INTO nuke_cart_countries VALUES ('32', 'British Virgin Islands', 'VG');
INSERT INTO nuke_cart_countries VALUES ('33', 'Brunei Darussalam', 'BN');
INSERT INTO nuke_cart_countries VALUES ('34', 'Bulgaria', 'BG');
INSERT INTO nuke_cart_countries VALUES ('35', 'Burkina Faso', 'BF');
INSERT INTO nuke_cart_countries VALUES ('36', 'Burundi', 'BI');
INSERT INTO nuke_cart_countries VALUES ('37', 'Cambodia', 'KH');
INSERT INTO nuke_cart_countries VALUES ('38', 'Cameroon', 'CM');
INSERT INTO nuke_cart_countries VALUES ('39', 'Canada', 'CA');
INSERT INTO nuke_cart_countries VALUES ('40', 'Cape Verde', 'CV');
INSERT INTO nuke_cart_countries VALUES ('41', 'Cayman Islands', 'KY');
INSERT INTO nuke_cart_countries VALUES ('42', 'Central African Republic', 'CF');
INSERT INTO nuke_cart_countries VALUES ('43', 'Chad', 'TD');
INSERT INTO nuke_cart_countries VALUES ('44', 'Chile', 'CL');
INSERT INTO nuke_cart_countries VALUES ('45', 'China', 'CN');
INSERT INTO nuke_cart_countries VALUES ('46', 'Christmas Island', 'CX');
INSERT INTO nuke_cart_countries VALUES ('47', 'Cocos (Keeling) Islands', 'CC');
INSERT INTO nuke_cart_countries VALUES ('48', 'Colombia', 'CO');
INSERT INTO nuke_cart_countries VALUES ('49', 'Comoros', 'KM');
INSERT INTO nuke_cart_countries VALUES ('50', 'Congo', 'CG');
INSERT INTO nuke_cart_countries VALUES ('51', 'Cook Islands', 'CK');
INSERT INTO nuke_cart_countries VALUES ('52', 'Costa Rica', 'CR');
INSERT INTO nuke_cart_countries VALUES ('53', 'Cote D\'ivoire', 'CI');
INSERT INTO nuke_cart_countries VALUES ('54', 'Croatia', 'HR');
INSERT INTO nuke_cart_countries VALUES ('55', 'Cuba', 'CU');
INSERT INTO nuke_cart_countries VALUES ('56', 'Cyprus', 'CY');
INSERT INTO nuke_cart_countries VALUES ('57', 'Czech Republic', 'CZ');
INSERT INTO nuke_cart_countries VALUES ('58', 'Czechoslovakia', 'CS');
INSERT INTO nuke_cart_countries VALUES ('59', 'Denmark', 'DK');
INSERT INTO nuke_cart_countries VALUES ('60', 'Djibouti', 'DJ');
INSERT INTO nuke_cart_countries VALUES ('61', 'Dominica', 'DM');
INSERT INTO nuke_cart_countries VALUES ('62', 'Dominican Republic', 'DO');
INSERT INTO nuke_cart_countries VALUES ('63', 'East Timor', 'TP');
INSERT INTO nuke_cart_countries VALUES ('64', 'Ecuador', 'EC');
INSERT INTO nuke_cart_countries VALUES ('65', 'Egypt', 'EG');
INSERT INTO nuke_cart_countries VALUES ('66', 'El Salvador', 'SV');
INSERT INTO nuke_cart_countries VALUES ('67', 'Equatorial Guinea', 'GQ');
INSERT INTO nuke_cart_countries VALUES ('68', 'Eritrea', 'ER');
INSERT INTO nuke_cart_countries VALUES ('69', 'Estonia', 'EE');
INSERT INTO nuke_cart_countries VALUES ('70', 'Ethiopia', 'ET');
INSERT INTO nuke_cart_countries VALUES ('71', 'Falkland Islands (Malvinas)', 'FK');
INSERT INTO nuke_cart_countries VALUES ('72', 'Faroe Islands', 'FO');
INSERT INTO nuke_cart_countries VALUES ('73', 'Fiji', 'FJ');
INSERT INTO nuke_cart_countries VALUES ('74', 'Finland', 'FI');
INSERT INTO nuke_cart_countries VALUES ('75', 'France', 'FR');
INSERT INTO nuke_cart_countries VALUES ('76', 'France, Metropolitan', 'FX');
INSERT INTO nuke_cart_countries VALUES ('77', 'French Guiana', 'GF');
INSERT INTO nuke_cart_countries VALUES ('78', 'French Polynesia', 'PF');
INSERT INTO nuke_cart_countries VALUES ('79', 'French Southern Territories', 'TF');
INSERT INTO nuke_cart_countries VALUES ('80', 'Gabon', 'GA');
INSERT INTO nuke_cart_countries VALUES ('81', 'Gambia', 'GM');
INSERT INTO nuke_cart_countries VALUES ('82', 'Georgia', 'GE');
INSERT INTO nuke_cart_countries VALUES ('83', 'Germany', 'DE');
INSERT INTO nuke_cart_countries VALUES ('84', 'Ghana', 'GH');
INSERT INTO nuke_cart_countries VALUES ('85', 'Gibraltar', 'GI');
INSERT INTO nuke_cart_countries VALUES ('86', 'Greece', 'GR');
INSERT INTO nuke_cart_countries VALUES ('87', 'Greenland', 'GL');
INSERT INTO nuke_cart_countries VALUES ('88', 'Grenada', 'GD');
INSERT INTO nuke_cart_countries VALUES ('89', 'Guadeloupe', 'GP');
INSERT INTO nuke_cart_countries VALUES ('90', 'Guam', 'GU');
INSERT INTO nuke_cart_countries VALUES ('91', 'Guatemala', 'GT');
INSERT INTO nuke_cart_countries VALUES ('92', 'Guinea', 'GN');
INSERT INTO nuke_cart_countries VALUES ('93', 'Guinea-Bissau', 'GW');
INSERT INTO nuke_cart_countries VALUES ('94', 'Guyana', 'GY');
INSERT INTO nuke_cart_countries VALUES ('95', 'Haiti', 'HT');
INSERT INTO nuke_cart_countries VALUES ('96', 'Heard and McDonald Islands', 'HM');
INSERT INTO nuke_cart_countries VALUES ('97', 'Honduras', 'HN');
INSERT INTO nuke_cart_countries VALUES ('98', 'Hong Kong', 'HK');
INSERT INTO nuke_cart_countries VALUES ('99', 'Hungary', 'HU');
INSERT INTO nuke_cart_countries VALUES ('100', 'Iceland', 'IS');
INSERT INTO nuke_cart_countries VALUES ('101', 'India', 'IN');
INSERT INTO nuke_cart_countries VALUES ('102', 'Indonesia', 'ID');
INSERT INTO nuke_cart_countries VALUES ('103', 'Iraq', 'IQ');
INSERT INTO nuke_cart_countries VALUES ('104', 'Ireland', 'IE');
INSERT INTO nuke_cart_countries VALUES ('105', 'Islamic Republic of Iran', 'IR');
INSERT INTO nuke_cart_countries VALUES ('106', 'Israel', 'IL');
INSERT INTO nuke_cart_countries VALUES ('107', 'Italy', 'IT');
INSERT INTO nuke_cart_countries VALUES ('108', 'Jamaica', 'JM');
INSERT INTO nuke_cart_countries VALUES ('109', 'Japan', 'JP');
INSERT INTO nuke_cart_countries VALUES ('110', 'Jordan', 'JO');
INSERT INTO nuke_cart_countries VALUES ('111', 'Kazakhstan', 'KZ');
INSERT INTO nuke_cart_countries VALUES ('112', 'Kenya', 'KE');
INSERT INTO nuke_cart_countries VALUES ('113', 'Kiribati', 'KI');
INSERT INTO nuke_cart_countries VALUES ('114', 'Korea', 'KP');
INSERT INTO nuke_cart_countries VALUES ('115', 'Korea, Republic of', 'KR');
INSERT INTO nuke_cart_countries VALUES ('116', 'Kuwait', 'KW');
INSERT INTO nuke_cart_countries VALUES ('117', 'Kyrgyzstan', 'KG');
INSERT INTO nuke_cart_countries VALUES ('118', 'Laos', 'LA');
INSERT INTO nuke_cart_countries VALUES ('119', 'Latvia', 'LV');
INSERT INTO nuke_cart_countries VALUES ('120', 'Lebanon', 'LB');
INSERT INTO nuke_cart_countries VALUES ('121', 'Lesotho', 'LS');
INSERT INTO nuke_cart_countries VALUES ('122', 'Liberia', 'LR');
INSERT INTO nuke_cart_countries VALUES ('123', 'Libyan Arab Jamahiriya', 'LY');
INSERT INTO nuke_cart_countries VALUES ('124', 'Liechtenstein', 'LI');
INSERT INTO nuke_cart_countries VALUES ('125', 'Lithuania', 'LT');
INSERT INTO nuke_cart_countries VALUES ('126', 'Luxembourg', 'LU');
INSERT INTO nuke_cart_countries VALUES ('127', 'Macau', 'MO');
INSERT INTO nuke_cart_countries VALUES ('128', 'Macedonia', 'MK');
INSERT INTO nuke_cart_countries VALUES ('129', 'Madagascar', 'MG');
INSERT INTO nuke_cart_countries VALUES ('130', 'Malawi', 'MW');
INSERT INTO nuke_cart_countries VALUES ('131', 'Malaysia', 'MY');
INSERT INTO nuke_cart_countries VALUES ('132', 'Maldives', 'MV');
INSERT INTO nuke_cart_countries VALUES ('133', 'Mali', 'ML');
INSERT INTO nuke_cart_countries VALUES ('134', 'Malta', 'MT');
INSERT INTO nuke_cart_countries VALUES ('135', 'Marshall Islands', 'MH');
INSERT INTO nuke_cart_countries VALUES ('136', 'Martinique', 'MQ');
INSERT INTO nuke_cart_countries VALUES ('137', 'Mauritania', 'MR');
INSERT INTO nuke_cart_countries VALUES ('138', 'Mauritius', 'MU');
INSERT INTO nuke_cart_countries VALUES ('139', 'Mayotte', 'YT');
INSERT INTO nuke_cart_countries VALUES ('140', 'Mexico', 'MX');
INSERT INTO nuke_cart_countries VALUES ('141', 'Micronesia', 'FM');
INSERT INTO nuke_cart_countries VALUES ('142', 'Moldova, Republic of', 'MD');
INSERT INTO nuke_cart_countries VALUES ('143', 'Monaco', 'MC');
INSERT INTO nuke_cart_countries VALUES ('144', 'Mongolia', 'MN');
INSERT INTO nuke_cart_countries VALUES ('145', 'Montserrat', 'MS');
INSERT INTO nuke_cart_countries VALUES ('146', 'Morocco', 'MA');
INSERT INTO nuke_cart_countries VALUES ('147', 'Mozambique', 'MZ');
INSERT INTO nuke_cart_countries VALUES ('148', 'Myanmar', 'MM');
INSERT INTO nuke_cart_countries VALUES ('149', 'Namibia', 'NA');
INSERT INTO nuke_cart_countries VALUES ('150', 'Nauru', 'NR');
INSERT INTO nuke_cart_countries VALUES ('151', 'Nepal', 'NP');
INSERT INTO nuke_cart_countries VALUES ('152', 'Netherlands', 'NL');
INSERT INTO nuke_cart_countries VALUES ('153', 'Netherlands Antilles', 'AN');
INSERT INTO nuke_cart_countries VALUES ('154', 'New Caledonia', 'NC');
INSERT INTO nuke_cart_countries VALUES ('155', 'New Zealand', 'NZ');
INSERT INTO nuke_cart_countries VALUES ('156', 'Nicaragua', 'NI');
INSERT INTO nuke_cart_countries VALUES ('157', 'Niger', 'NE');
INSERT INTO nuke_cart_countries VALUES ('158', 'Nigeria', 'NG');
INSERT INTO nuke_cart_countries VALUES ('159', 'Niue', 'NU');
INSERT INTO nuke_cart_countries VALUES ('160', 'Norfolk Island', 'NF');
INSERT INTO nuke_cart_countries VALUES ('161', 'Northern Mariana Islands', 'MP');
INSERT INTO nuke_cart_countries VALUES ('162', 'Norway', 'NO');
INSERT INTO nuke_cart_countries VALUES ('163', 'Oman', 'OM');
INSERT INTO nuke_cart_countries VALUES ('164', 'Pakistan', 'PK');
INSERT INTO nuke_cart_countries VALUES ('165', 'Palau', 'PW');
INSERT INTO nuke_cart_countries VALUES ('166', 'Panama', 'PA');
INSERT INTO nuke_cart_countries VALUES ('167', 'Papua New Guinea', 'PG');
INSERT INTO nuke_cart_countries VALUES ('168', 'Paraguay', 'PY');
INSERT INTO nuke_cart_countries VALUES ('169', 'Peru', 'PE');
INSERT INTO nuke_cart_countries VALUES ('170', 'Philippines', 'PH');
INSERT INTO nuke_cart_countries VALUES ('171', 'Pitcairn', 'PN');
INSERT INTO nuke_cart_countries VALUES ('172', 'Poland', 'PL');
INSERT INTO nuke_cart_countries VALUES ('173', 'Portugal', 'PT');
INSERT INTO nuke_cart_countries VALUES ('174', 'Puerto Rico', 'PR');
INSERT INTO nuke_cart_countries VALUES ('175', 'Qatar', 'QA');
INSERT INTO nuke_cart_countries VALUES ('176', 'Reunion', 'RE');
INSERT INTO nuke_cart_countries VALUES ('177', 'Romania', 'RO');
INSERT INTO nuke_cart_countries VALUES ('178', 'Russian Federation', 'RU');
INSERT INTO nuke_cart_countries VALUES ('179', 'Rwanda', 'RW');
INSERT INTO nuke_cart_countries VALUES ('180', 'Saint Lucia', 'LC');
INSERT INTO nuke_cart_countries VALUES ('181', 'Samoa', 'WS');
INSERT INTO nuke_cart_countries VALUES ('182', 'San Marino', 'SM');
INSERT INTO nuke_cart_countries VALUES ('183', 'Sao Tome and Principe', 'ST');
INSERT INTO nuke_cart_countries VALUES ('184', 'Saudi Arabia', 'SA');
INSERT INTO nuke_cart_countries VALUES ('185', 'Senegal', 'SN');
INSERT INTO nuke_cart_countries VALUES ('186', 'Seychelles', 'SC');
INSERT INTO nuke_cart_countries VALUES ('187', 'Sierra Leone', 'SL');
INSERT INTO nuke_cart_countries VALUES ('188', 'Singapore', 'SG');
INSERT INTO nuke_cart_countries VALUES ('189', 'Slovakia', 'SK');
INSERT INTO nuke_cart_countries VALUES ('190', 'Slovenia', 'SI');
INSERT INTO nuke_cart_countries VALUES ('191', 'Solomon Islands', 'SB');
INSERT INTO nuke_cart_countries VALUES ('192', 'Somalia', 'SO');
INSERT INTO nuke_cart_countries VALUES ('193', 'South Africa', 'ZA');
INSERT INTO nuke_cart_countries VALUES ('194', 'Spain', 'ES');
INSERT INTO nuke_cart_countries VALUES ('195', 'Sri Lanka', 'LK');
INSERT INTO nuke_cart_countries VALUES ('196', 'St. Helena', 'SH');
INSERT INTO nuke_cart_countries VALUES ('197', 'St. Kitts And Nevis', 'KN');
INSERT INTO nuke_cart_countries VALUES ('198', 'St. Pierre and Miquelon', 'PM');
INSERT INTO nuke_cart_countries VALUES ('199', 'St. Vincent And The Greadines', 'VC');
INSERT INTO nuke_cart_countries VALUES ('200', 'Sudan', 'SD');
INSERT INTO nuke_cart_countries VALUES ('201', 'Suriname', 'SR');
INSERT INTO nuke_cart_countries VALUES ('202', 'Svalbard and Jan Mayen Islands', 'SJ');
INSERT INTO nuke_cart_countries VALUES ('203', 'Swaziland', 'SZ');
INSERT INTO nuke_cart_countries VALUES ('204', 'Sweden', 'SE');
INSERT INTO nuke_cart_countries VALUES ('205', 'Switzerland', 'CH');
INSERT INTO nuke_cart_countries VALUES ('206', 'Syrian Arab Republic', 'SY');
INSERT INTO nuke_cart_countries VALUES ('207', 'Taiwan', 'TW');
INSERT INTO nuke_cart_countries VALUES ('208', 'Tajikistan', 'TJ');
INSERT INTO nuke_cart_countries VALUES ('209', 'Tanzania, United Republic of', 'TZ');
INSERT INTO nuke_cart_countries VALUES ('210', 'Thailand', 'TH');
INSERT INTO nuke_cart_countries VALUES ('211', 'Togo', 'TG');
INSERT INTO nuke_cart_countries VALUES ('212', 'Tokelau', 'TK');
INSERT INTO nuke_cart_countries VALUES ('213', 'Tonga', 'TO');
INSERT INTO nuke_cart_countries VALUES ('214', 'Trinidad and Tobago', 'TT');
INSERT INTO nuke_cart_countries VALUES ('215', 'Tunisia', 'TN');
INSERT INTO nuke_cart_countries VALUES ('216', 'Turkey', 'TR');
INSERT INTO nuke_cart_countries VALUES ('217', 'Turkmenistan', 'TM');
INSERT INTO nuke_cart_countries VALUES ('218', 'Turks and Caicos Islands', 'TC');
INSERT INTO nuke_cart_countries VALUES ('219', 'Tuvalu', 'TV');
INSERT INTO nuke_cart_countries VALUES ('220', 'Uganda', 'UG');
INSERT INTO nuke_cart_countries VALUES ('221', 'Ukraine', 'UA');
INSERT INTO nuke_cart_countries VALUES ('222', 'United Arab Emirates', 'AE');
INSERT INTO nuke_cart_countries VALUES ('223', 'United Kingdom (Great Britain)', 'GB');
INSERT INTO nuke_cart_countries VALUES ('224', 'United States', 'US');
INSERT INTO nuke_cart_countries VALUES ('225', 'United States Virgin Islands', 'VI');
INSERT INTO nuke_cart_countries VALUES ('226', 'Uruguay', 'UY');
INSERT INTO nuke_cart_countries VALUES ('227', 'Uzbekistan', 'UZ');
INSERT INTO nuke_cart_countries VALUES ('228', 'Vanuatu', 'VU');
INSERT INTO nuke_cart_countries VALUES ('229', 'Vatican City State', 'VA');
INSERT INTO nuke_cart_countries VALUES ('230', 'Venezuela', 'VE');
INSERT INTO nuke_cart_countries VALUES ('231', 'Viet Nam', 'VN');
INSERT INTO nuke_cart_countries VALUES ('232', 'Wallis And Futuna Islands', 'WF');
INSERT INTO nuke_cart_countries VALUES ('233', 'Western Sahara', 'EH');
INSERT INTO nuke_cart_countries VALUES ('234', 'Yemen', 'YE');
INSERT INTO nuke_cart_countries VALUES ('235', 'Yugoslavia', 'YU');
INSERT INTO nuke_cart_countries VALUES ('236', 'Zaire', 'ZR');
INSERT INTO nuke_cart_countries VALUES ('237', 'Zambia', 'ZM');
INSERT INTO nuke_cart_countries VALUES ('238', 'Zimbabwe', 'ZW');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_currencies'
#

CREATE TABLE nuke_cart_currencies (
   currID int(11) NOT NULL auto_increment,
   currency char(3) NOT NULL,
   rvalue decimal(13,6) DEFAULT '0.000000' NOT NULL,
   curradj decimal(4,2) DEFAULT '0.00' NOT NULL,
   active int(1) DEFAULT '0' NOT NULL,
   defcurr int(1) DEFAULT '0' NOT NULL,
   currname varchar(32) NOT NULL,
   currdesc varchar(250),
   dpoint char(3) NOT NULL,
   dplaces int(2) DEFAULT '0' NOT NULL,
   tpoint char(3) NOT NULL,
   symbol_left text NOT NULL,
   symbol_right text NOT NULL,
   PRIMARY KEY (currID),
   KEY currID (currID)
);

#
# Dumping data for table 'nuke_cart_currencies'
#

INSERT INTO nuke_cart_currencies VALUES ('1', 'USD', '1.000000', '0.00', '1', '1', 'US Dollar', '', '.', '2', ',', '$', '');
INSERT INTO nuke_cart_currencies VALUES ('2', 'JPY', '109.450000', '0.00', '1', '0', 'Japanese Yen', '', '', '0', ',', '�', '');
INSERT INTO nuke_cart_currencies VALUES ('3', 'EUR', '0.841396', '0.00', '1', '0', 'Euro', '', ',', '2', '.', 'EUR', '');
INSERT INTO nuke_cart_currencies VALUES ('4', 'CAD', '1.360600', '0.00', '1', '0', 'Canadian Dollar', '', '.', '2', ',', '$', '');
INSERT INTO nuke_cart_currencies VALUES ('5', 'GBP', '0.562653', '0.00', '1', '0', 'Sterling', '', ',', '2', '.', '�', '');
INSERT INTO nuke_cart_currencies VALUES ('6', 'AUD', '1.361280', '0.00', '1', '0', 'Australian Dollar', '', '.', '2', ',', '$', '');
INSERT INTO nuke_cart_currencies VALUES ('7', 'CHF', '1.311700', '0.00', '1', '0', 'Swiss Franc', '', '.', '2', '\'', 'SFr. ', '');
INSERT INTO nuke_cart_currencies VALUES ('8', 'COP', '2680.000000', '0.00', '1', '0', 'Colombian Peso', '', ',', '2', '.', '$', '');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_guests'
#

CREATE TABLE nuke_cart_guests (
   sessionID varchar(32) NOT NULL,
   expires int(11) DEFAULT '0' NOT NULL,
   myCurr int(4) DEFAULT '0' NOT NULL
);

#
# Dumping data for table 'nuke_cart_guests'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_media'
#

CREATE TABLE nuke_cart_media (
   mediaID int(11) NOT NULL auto_increment,
   mediaName text NOT NULL,
   mediaInfo text NOT NULL,
   mediaType varchar(255) NOT NULL,
   mediaGlobal tinyint(1) DEFAULT '0' NOT NULL,
   urlLocal varchar(255) NOT NULL,
   urlRemote varchar(255) NOT NULL,
   date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   PRIMARY KEY (mediaID),
   KEY mediaID (mediaID)
);

#
# Dumping data for table 'nuke_cart_media'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_options'
#

CREATE TABLE nuke_cart_options (
   optionID int(11) NOT NULL auto_increment,
   optionType varchar(255) NOT NULL,
   optionName varchar(255) NOT NULL,
   optionInfo text NOT NULL,
   optionGlobal tinyint(1) DEFAULT '0' NOT NULL,
   date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   PRIMARY KEY (optionID),
   KEY optionID (optionID)
);

#
# Dumping data for table 'nuke_cart_options'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_options_selections'
#

CREATE TABLE nuke_cart_options_selections (
   selectionID int(11) NOT NULL auto_increment,
   optionID int(11) DEFAULT '0' NOT NULL,
   selectionName varchar(255) NOT NULL,
   selectionInfo text NOT NULL,
   selectionAction char(1) NOT NULL,
   selectionValue double(10,2) DEFAULT '0.00' NOT NULL,
   selectionDefault text NOT NULL,
   PRIMARY KEY (selectionID),
   KEY selectionID (selectionID),
   KEY optionID (optionID)
);

#
# Dumping data for table 'nuke_cart_options_selections'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_orders'
#

CREATE TABLE nuke_cart_orders (
   orderID int(11) NOT NULL auto_increment,
   userID varchar(32) NOT NULL,
   userType varchar(10) NOT NULL,
   shipFirstName varchar(64) NOT NULL,
   shipLastName varchar(64) NOT NULL,
   shipAddress1 varchar(64) NOT NULL,
   shipAddress2 varchar(64) NOT NULL,
   shipCity varchar(64) NOT NULL,
   shipState varchar(32) NOT NULL,
   shipZip varchar(16) NOT NULL,
   shipCountry varchar(64) NOT NULL,
   shipMethod int(11) DEFAULT '0' NOT NULL,
   shipMethodName varchar(255) NOT NULL,
   shipMethodData text NOT NULL,
   billEmail varchar(255) NOT NULL,
   billFirstName varchar(64) NOT NULL,
   billLastName varchar(64) NOT NULL,
   billAddress1 varchar(64) NOT NULL,
   billAddress2 varchar(64) NOT NULL,
   billCity varchar(64) NOT NULL,
   billState varchar(32) NOT NULL,
   billZip varchar(16) NOT NULL,
   billCountry varchar(64) NOT NULL,
   billDayPhone varchar(20) NOT NULL,
   billEvePhone varchar(20) NOT NULL,
   payMethod int(11) DEFAULT '0' NOT NULL,
   payMethodName varchar(255) NOT NULL,
   payMethodData text NOT NULL,
   productTotal double(10,2) DEFAULT '0.00' NOT NULL,
   shipTotal double(10,2) DEFAULT '0.00' NOT NULL,
   handlingTotal double(10,2) DEFAULT '0.00' NOT NULL,
   taxTotal double(10,2) DEFAULT '0.00' NOT NULL,
   orderDate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   viewDate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   statusDate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   orderStatus int(11) DEFAULT '0' NOT NULL,
   orderSubStatus int(11) DEFAULT '0' NOT NULL,
   orderNotes text NOT NULL,
   flagOrder tinyint(1) DEFAULT '0' NOT NULL,
   fileOrder tinyint(1) DEFAULT '0' NOT NULL,
   code varchar(32) NOT NULL,
   PRIMARY KEY (orderID),
   KEY orderID (orderID)
);

#
# Dumping data for table 'nuke_cart_orders'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_orders_cartitems'
#

CREATE TABLE nuke_cart_orders_cartitems (
   orderID int(11) DEFAULT '0' NOT NULL,
   userID varchar(32) NOT NULL,
   userType varchar(10) NOT NULL,
   itemID bigint(20) DEFAULT '0' NOT NULL,
   prodID int(11) DEFAULT '0' NOT NULL,
   prodCode text NOT NULL,
   prodName text NOT NULL,
   prodBrand text NOT NULL,
   prodModel text NOT NULL,
   itemCost double(10,2) DEFAULT '0.00' NOT NULL,
   qty int(11) DEFAULT '0' NOT NULL,
   qtyRemain int(11) DEFAULT '0' NOT NULL
);

#
# Dumping data for table 'nuke_cart_orders_cartitems'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_orders_cartitems_options'
#

CREATE TABLE nuke_cart_orders_cartitems_options (
   orderID int(11) DEFAULT '0' NOT NULL,
   userID varchar(32) NOT NULL,
   userType varchar(10) NOT NULL,
   itemID bigint(20) DEFAULT '0' NOT NULL,
   optionID int(11) DEFAULT '0' NOT NULL,
   optionName varchar(255) NOT NULL,
   selectionID int(11) DEFAULT '0' NOT NULL,
   selectionName varchar(255) NOT NULL,
   selectionAction char(1) NOT NULL,
   selectionValue double(10,2) DEFAULT '0.00' NOT NULL
);

#
# Dumping data for table 'nuke_cart_orders_cartitems_options'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_orders_status'
#

CREATE TABLE nuke_cart_orders_status (
   statusID int(2) NOT NULL auto_increment,
   statusType tinyint(4) DEFAULT '0' NOT NULL,
   statusLabel varchar(30) NOT NULL,
   statusInfo text,
   status_default tinyint(4) DEFAULT '0' NOT NULL,
   PRIMARY KEY (statusID)
);

#
# Dumping data for table 'nuke_cart_orders_status'
#

INSERT INTO nuke_cart_orders_status VALUES ('1', '1', 'Pending', 'Order has not yet been processed.', '1');
INSERT INTO nuke_cart_orders_status VALUES ('2', '1', 'Processing', 'Order is being processed.', '0');
INSERT INTO nuke_cart_orders_status VALUES ('3', '1', 'Complete', 'Order has been completed.', '0');
INSERT INTO nuke_cart_orders_status VALUES ('4', '1', 'Declined', 'Order has been declined.', '0');
INSERT INTO nuke_cart_orders_status VALUES ('5', '2', 'Payment Recieved', 'Payment for order has been recieved.', '1');
INSERT INTO nuke_cart_orders_status VALUES ('6', '2', 'Canceled', 'Order has been canceled.', '0');
INSERT INTO nuke_cart_orders_status VALUES ('7', '2', 'Shipped', 'Order has been shipped.', '0');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_payments'
#

CREATE TABLE nuke_cart_payments (
   payment_id int(3) NOT NULL auto_increment,
   payment_label varchar(255) NOT NULL,
   payment_description text NOT NULL,
   payment_active tinyint(1) DEFAULT '0' NOT NULL,
   payment_default tinyint(1) DEFAULT '0' NOT NULL,
   payment_file varchar(255) NOT NULL,
   PRIMARY KEY (payment_id)
);

#
# Dumping data for table 'nuke_cart_payments'
#

INSERT INTO nuke_cart_payments VALUES ('1', '2Checkout', '', '1', '0', '2checkout');
INSERT INTO nuke_cart_payments VALUES ('2', 'Authorize', '', '1', '0', 'authorize');
INSERT INTO nuke_cart_payments VALUES ('3', 'Bank of America', '', '1', '0', 'bankofamerica');
INSERT INTO nuke_cart_payments VALUES ('4', 'Check', '', '1', '0', 'check');
INSERT INTO nuke_cart_payments VALUES ('5', 'Credit Card', '', '1', '0', 'creditcard');
INSERT INTO nuke_cart_payments VALUES ('6', 'Direct Deposit', '', '1', '0', 'directdeposit');
INSERT INTO nuke_cart_payments VALUES ('7', 'Money Order', '', '1', '0', 'moneyorder');
INSERT INTO nuke_cart_payments VALUES ('8', 'NOCHEX', '', '1', '0', 'nochex');
INSERT INTO nuke_cart_payments VALUES ('9', 'PayMate', '', '1', '0', 'paymate');
INSERT INTO nuke_cart_payments VALUES ('10', 'PayPal', '', '1', '1', 'paypal');
INSERT INTO nuke_cart_payments VALUES ('11', 'PaySystems', '', '1', '0', 'paysystems');
INSERT INTO nuke_cart_payments VALUES ('12', 'PSiGate', '', '1', '0', 'psigate');
INSERT INTO nuke_cart_payments VALUES ('13', 'SECPay', '', '1', '0', 'secpay');
INSERT INTO nuke_cart_payments VALUES ('14', 'StormPay', '', '1', '0', 'stormpay');
INSERT INTO nuke_cart_payments VALUES ('15', 'Verisign', '', '1', '0', 'verisign');
INSERT INTO nuke_cart_payments VALUES ('16', 'VirtualTiendas', '', '1', '0', 'virtualtiendas');
INSERT INTO nuke_cart_payments VALUES ('17', 'WorldPay', '', '1', '0', 'worldpay');
INSERT INTO nuke_cart_payments VALUES ('18', 'COD', '', '1', '0', 'cod');
INSERT INTO nuke_cart_payments VALUES ('19', 'Net / Terms', '', '1', '0', 'netterms');
INSERT INTO nuke_cart_payments VALUES ('20', 'Pickup', '', '1', '0', 'pickup');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_payments_options_2checkout'
#

CREATE TABLE nuke_cart_payments_options_2checkout (
   sellerID int(11) DEFAULT '0' NOT NULL,
   tmode varchar(255) NOT NULL,
   ereceipt varchar(255) NOT NULL
);

#
# Dumping data for table 'nuke_cart_payments_options_2checkout'
#

INSERT INTO nuke_cart_payments_options_2checkout VALUES ('12345', 'Y', 'FALSE');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_payments_options_authorize'
#

CREATE TABLE nuke_cart_payments_options_authorize (
   loginID varchar(255) NOT NULL,
   txnMode varchar(255) DEFAULT '0' NOT NULL,
   txnKey varchar(255) NOT NULL,
   txnMethod varchar(255) NOT NULL,
   emCustomer varchar(5) NOT NULL,
   emMerchant varchar(5) NOT NULL
);

#
# Dumping data for table 'nuke_cart_payments_options_authorize'
#

INSERT INTO nuke_cart_payments_options_authorize VALUES ('authnetID', 'test', 'testkey', 'sim', 'TRUE', 'TRUE');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_payments_options_bankofamerica'
#

CREATE TABLE nuke_cart_payments_options_bankofamerica (
   merchantID varchar(255) NOT NULL,
   cvvIndicator varchar(255) NOT NULL
);

#
# Dumping data for table 'nuke_cart_payments_options_bankofamerica'
#

INSERT INTO nuke_cart_payments_options_bankofamerica VALUES ('merchantID', 'PRESENT');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_payments_options_creditcard'
#

CREATE TABLE nuke_cart_payments_options_creditcard (
   typeID int(2) NOT NULL auto_increment,
   label varchar(32) NOT NULL,
   active tinyint(1) DEFAULT '1' NOT NULL,
   PRIMARY KEY (typeID)
);

#
# Dumping data for table 'nuke_cart_payments_options_creditcard'
#

INSERT INTO nuke_cart_payments_options_creditcard VALUES ('1', 'Visa', '1');
INSERT INTO nuke_cart_payments_options_creditcard VALUES ('2', 'MasterCard', '1');
INSERT INTO nuke_cart_payments_options_creditcard VALUES ('3', 'Bankcard', '0');
INSERT INTO nuke_cart_payments_options_creditcard VALUES ('4', 'American Express', '0');
INSERT INTO nuke_cart_payments_options_creditcard VALUES ('5', 'Diners', '0');
INSERT INTO nuke_cart_payments_options_creditcard VALUES ('6', 'Discover', '0');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_payments_options_directdeposit'
#

CREATE TABLE nuke_cart_payments_options_directdeposit (
   bankName varchar(255) NOT NULL,
   routeNum bigint(20) DEFAULT '0' NOT NULL,
   branchNum bigint(20) DEFAULT '0' NOT NULL,
   bacctNum bigint(20) DEFAULT '0' NOT NULL,
   bacctName varchar(255) NOT NULL
);

#
# Dumping data for table 'nuke_cart_payments_options_directdeposit'
#

INSERT INTO nuke_cart_payments_options_directdeposit VALUES ('Your Bank Name', '123456789', '123456789', '123456789', 'Your Name || Business');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_payments_options_nochex'
#

CREATE TABLE nuke_cart_payments_options_nochex (
   nochex_email varchar(255) NOT NULL
);

#
# Dumping data for table 'nuke_cart_payments_options_nochex'
#

INSERT INTO nuke_cart_payments_options_nochex VALUES ('nochex@email.com');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_payments_options_paymate'
#

CREATE TABLE nuke_cart_payments_options_paymate (
   paymate_id varchar(255) NOT NULL
);

#
# Dumping data for table 'nuke_cart_payments_options_paymate'
#

INSERT INTO nuke_cart_payments_options_paymate VALUES ('demonstration');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_payments_options_paypal'
#

CREATE TABLE nuke_cart_payments_options_paypal (
   ppemail varchar(255) NOT NULL,
   ipn tinyint(1) DEFAULT '0' NOT NULL,
   currency text NOT NULL
);

#
# Dumping data for table 'nuke_cart_payments_options_paypal'
#

INSERT INTO nuke_cart_payments_options_paypal VALUES ('email@address.com', '1', 'USD');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_payments_options_paysystems'
#

CREATE TABLE nuke_cart_payments_options_paysystems (
   company_id text NOT NULL
);

#
# Dumping data for table 'nuke_cart_payments_options_paysystems'
#

INSERT INTO nuke_cart_payments_options_paysystems VALUES ('123456');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_payments_options_psigate'
#

CREATE TABLE nuke_cart_payments_options_psigate (
   merchant_id varchar(255) NOT NULL
);

#
# Dumping data for table 'nuke_cart_payments_options_psigate'
#

INSERT INTO nuke_cart_payments_options_psigate VALUES ('teststore');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_payments_options_secpay'
#

CREATE TABLE nuke_cart_payments_options_secpay (
   merchantID varchar(255) NOT NULL,
   teststatus varchar(255) NOT NULL
);

#
# Dumping data for table 'nuke_cart_payments_options_secpay'
#

INSERT INTO nuke_cart_payments_options_secpay VALUES ('secpay', 'true');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_payments_options_stormpay'
#

CREATE TABLE nuke_cart_payments_options_stormpay (
   spemail varchar(255) NOT NULL
);

#
# Dumping data for table 'nuke_cart_payments_options_stormpay'
#

INSERT INTO nuke_cart_payments_options_stormpay VALUES ('email@yoursite.com');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_payments_options_verisign'
#

CREATE TABLE nuke_cart_payments_options_verisign (
   loginID varchar(255) NOT NULL,
   partnerID varchar(255) NOT NULL,
   emCustomer varchar(5) NOT NULL
);

#
# Dumping data for table 'nuke_cart_payments_options_verisign'
#

INSERT INTO nuke_cart_payments_options_verisign VALUES ('loginID', 'partnerID', 'TRUE');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_payments_options_virtualtiendas'
#

CREATE TABLE nuke_cart_payments_options_virtualtiendas (
   storedomain varchar(255) NOT NULL,
   storeroute varchar(255) NOT NULL,
   storecurrency int(11) DEFAULT '0' NOT NULL
);

#
# Dumping data for table 'nuke_cart_payments_options_virtualtiendas'
#

INSERT INTO nuke_cart_payments_options_virtualtiendas VALUES ('', '', '0');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_payments_options_worldpay'
#

CREATE TABLE nuke_cart_payments_options_worldpay (
   vendorID varchar(255) NOT NULL,
   pmode char(3) NOT NULL
);

#
# Dumping data for table 'nuke_cart_payments_options_worldpay'
#

INSERT INTO nuke_cart_payments_options_worldpay VALUES ('vendorID', '0');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_preorders'
#

CREATE TABLE nuke_cart_preorders (
   userID varchar(32) NOT NULL,
   userType varchar(10) NOT NULL,
   shipFirstName varchar(64) NOT NULL,
   shipLastName varchar(64) NOT NULL,
   shipAddress1 varchar(64) NOT NULL,
   shipAddress2 varchar(64) NOT NULL,
   shipCity varchar(64) NOT NULL,
   shipState varchar(32) NOT NULL,
   shipZip varchar(16) NOT NULL,
   shipCountry varchar(64) NOT NULL,
   shipMethod int(11) DEFAULT '0' NOT NULL,
   shipMethodName varchar(255) NOT NULL,
   shipMethodData text NOT NULL,
   billEmail varchar(255) NOT NULL,
   billFirstName varchar(64) NOT NULL,
   billLastName varchar(64) NOT NULL,
   billAddress1 varchar(64) NOT NULL,
   billAddress2 varchar(64) NOT NULL,
   billCity varchar(64) NOT NULL,
   billState varchar(32) NOT NULL,
   billZip varchar(16) NOT NULL,
   billCountry varchar(64) NOT NULL,
   billDayPhone varchar(20) NOT NULL,
   billEvePhone varchar(20) NOT NULL,
   payMethod int(11) DEFAULT '0' NOT NULL,
   payMethodName varchar(255) NOT NULL,
   payMethodData text NOT NULL,
   productTotal double(10,2) DEFAULT '0.00' NOT NULL,
   shipTotal double(10,2) DEFAULT '0.00' NOT NULL,
   handlingTotal double(10,2) DEFAULT '0.00' NOT NULL,
   taxTotal double(10,2) DEFAULT '0.00' NOT NULL,
   step int(2) DEFAULT '0' NOT NULL,
   expires int(11) DEFAULT '0' NOT NULL
);

#
# Dumping data for table 'nuke_cart_preorders'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_preorders_cartitems'
#

CREATE TABLE nuke_cart_preorders_cartitems (
   userID varchar(32) NOT NULL,
   userType varchar(10) NOT NULL,
   itemID bigint(20) DEFAULT '0' NOT NULL,
   prodID int(11) DEFAULT '0' NOT NULL,
   prodCode text NOT NULL,
   prodName text NOT NULL,
   prodBrand text NOT NULL,
   prodModel text NOT NULL,
   itemCost double(10,2) DEFAULT '0.00' NOT NULL,
   qty int(11) DEFAULT '0' NOT NULL
);

#
# Dumping data for table 'nuke_cart_preorders_cartitems'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_preorders_cartitems_options'
#

CREATE TABLE nuke_cart_preorders_cartitems_options (
   userID varchar(32) NOT NULL,
   userType varchar(10) NOT NULL,
   itemID bigint(20) DEFAULT '0' NOT NULL,
   optionID int(11) DEFAULT '0' NOT NULL,
   optionName varchar(255) NOT NULL,
   selectionID int(11) DEFAULT '0' NOT NULL,
   selectionName varchar(255) NOT NULL,
   selectionAction char(1) NOT NULL,
   selectionValue double(10,2) DEFAULT '0.00' NOT NULL
);

#
# Dumping data for table 'nuke_cart_preorders_cartitems_options'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_products'
#

CREATE TABLE nuke_cart_products (
   prodID int(11) NOT NULL auto_increment,
   prodCode varchar(25) NOT NULL,
   category_id int(11) DEFAULT '0' NOT NULL,
   prodName text NOT NULL,
   prodSInfo text NOT NULL,
   prodInfo text NOT NULL,
   prodXInfo text NOT NULL,
   keywords text NOT NULL,
   prodModel text NOT NULL,
   brand_id int(11) DEFAULT '0' NOT NULL,
   prodCounter int(11) DEFAULT '0' NOT NULL,
   prodCost double(10,2) DEFAULT '0.00' NOT NULL,
   msrp_price double(12,2) DEFAULT '0.00' NOT NULL,
   wholesale_price double(12,2) DEFAULT '0.00' NOT NULL,
   shipcost double(10,2) DEFAULT '0.00' NOT NULL,
   shipweight double(10,4) DEFAULT '0.0000' NOT NULL,
   shipping_ets int(11) DEFAULT '0' NOT NULL,
   handlingcost double(10,2) DEFAULT '0.00' NOT NULL,
   tax_class_id int(11) DEFAULT '0' NOT NULL,
   promoActive tinyint(1) DEFAULT '0' NOT NULL,
   promoTitle text NOT NULL,
   promoInfo text NOT NULL,
   promoCost double(10,2) DEFAULT '0.00' NOT NULL,
   promoStartDate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   promoExpireDate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   stockActive tinyint(1) DEFAULT '0' NOT NULL,
   stockQuantity int(11) DEFAULT '0' NOT NULL,
   productTemplate varchar(255) NOT NULL,
   date datetime,
   pthumb varchar(255) NOT NULL,
   product_availability int(11) DEFAULT '0' NOT NULL,
   prodActive tinyint(1) DEFAULT '0' NOT NULL,
   PRIMARY KEY (prodID),
   KEY prodID (prodID)
);

#
# Dumping data for table 'nuke_cart_products'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_products_availability'
#

CREATE TABLE nuke_cart_products_availability (
   avail_id int(11) NOT NULL auto_increment,
   avail_name varchar(255) NOT NULL,
   avail_label varchar(255) NOT NULL,
   avail_description text NOT NULL,
   avail_default tinyint(4) DEFAULT '0' NOT NULL,
   PRIMARY KEY (avail_id),
   KEY avail_id (avail_id)
);

#
# Dumping data for table 'nuke_cart_products_availability'
#

INSERT INTO nuke_cart_products_availability VALUES ('1', 'In Stock', 'In Stock', 'This product is in stock.', '1');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_products_media'
#

CREATE TABLE nuke_cart_products_media (
   prodMediaID int(11) NOT NULL auto_increment,
   prodID int(11) DEFAULT '0' NOT NULL,
   mediaID int(11) DEFAULT '0' NOT NULL,
   mediaPos int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (prodMediaID),
   KEY prodMediaID (prodMediaID),
   KEY prodID (prodID),
   KEY mediaID (mediaID)
);

#
# Dumping data for table 'nuke_cart_products_media'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_products_options'
#

CREATE TABLE nuke_cart_products_options (
   prodOptionID int(11) NOT NULL auto_increment,
   prodID int(11) DEFAULT '0' NOT NULL,
   optionID int(11) DEFAULT '0' NOT NULL,
   optionPos int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (prodOptionID),
   KEY prodOptionID (prodOptionID),
   KEY prodID (prodID),
   KEY optionID (optionID)
);

#
# Dumping data for table 'nuke_cart_products_options'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_products_reviews'
#

CREATE TABLE nuke_cart_products_reviews (
   review_id int(11) NOT NULL auto_increment,
   product_id int(11) DEFAULT '0' NOT NULL,
   user_id varchar(32) NOT NULL,
   user_type varchar(10) NOT NULL,
   review_title varchar(255) NOT NULL,
   review_rating tinyint(1) DEFAULT '0' NOT NULL,
   review_content text NOT NULL,
   date_submitted datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   date_published datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   date_modified datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   status_active tinyint(1) DEFAULT '0' NOT NULL,
   PRIMARY KEY (review_id),
   KEY review_id (review_id),
   KEY product_id (product_id)
);

#
# Dumping data for table 'nuke_cart_products_reviews'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_shipping'
#

CREATE TABLE nuke_cart_shipping (
   shipping_id int(3) NOT NULL auto_increment,
   shipping_label varchar(255) NOT NULL,
   shipping_description text NOT NULL,
   include_handling tinyint(1) DEFAULT '0' NOT NULL,
   tax_class_id int(11) DEFAULT '0' NOT NULL,
   shipping_active tinyint(1) DEFAULT '0' NOT NULL,
   shipping_default tinyint(1) DEFAULT '0' NOT NULL,
   shipping_file varchar(255) NOT NULL,
   PRIMARY KEY (shipping_id)
);

#
# Dumping data for table 'nuke_cart_shipping'
#

INSERT INTO nuke_cart_shipping VALUES ('1', 'Base Cost', '', '1', '0', '1', '1', 'basecost');
INSERT INTO nuke_cart_shipping VALUES ('3', 'Flat Rate', '', '1', '0', '1', '0', 'flatrate');
INSERT INTO nuke_cart_shipping VALUES ('4', 'Per Item', '', '1', '0', '1', '0', 'peritem');
INSERT INTO nuke_cart_shipping VALUES ('5', 'Pick Up', '', '0', '0', '1', '0', 'pickup');
INSERT INTO nuke_cart_shipping VALUES ('9', 'Product Total', '', '1', '0', '1', '0', 'producttotal');
INSERT INTO nuke_cart_shipping VALUES ('11', 'Product Weight', '', '1', '0', '1', '0', 'productweight');
INSERT INTO nuke_cart_shipping VALUES ('13', 'United Parcel Service', '', '1', '0', '1', '0', 'ups');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_shipping_ets'
#

CREATE TABLE nuke_cart_shipping_ets (
   ets_id int(11) NOT NULL auto_increment,
   ets_name varchar(255) NOT NULL,
   ets_label varchar(255) NOT NULL,
   ets_description text NOT NULL,
   ets_default tinyint(4) DEFAULT '0' NOT NULL,
   PRIMARY KEY (ets_id),
   KEY ets_id (ets_id)
);

#
# Dumping data for table 'nuke_cart_shipping_ets'
#

INSERT INTO nuke_cart_shipping_ets VALUES ('1', '2-3 days', '2-3 business days', 'This product will be shipped within 2-3 business days.', '0');
INSERT INTO nuke_cart_shipping_ets VALUES ('3', '1-2 days', '1-2 business days', 'This product will be shipping within 1-2 business days', '0');
INSERT INTO nuke_cart_shipping_ets VALUES ('4', 'Email Delivery', 'Instant Delivery', 'This product will be emailed to you.', '0');
INSERT INTO nuke_cart_shipping_ets VALUES ('5', '3-5 days', '3-5 business days.', 'This product will be shipped within 3-5 business days.', '1');
INSERT INTO nuke_cart_shipping_ets VALUES ('6', '5-13 days', '5-13 business days.', 'This product will be shipped within 5-13 business days.', '0');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_shipping_options_flatrate'
#

CREATE TABLE nuke_cart_shipping_options_flatrate (
   flatratecost double(10,2) DEFAULT '0.00' NOT NULL,
   PRIMARY KEY (flatratecost)
);

#
# Dumping data for table 'nuke_cart_shipping_options_flatrate'
#

INSERT INTO nuke_cart_shipping_options_flatrate VALUES ('10.00');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_shipping_options_peritem'
#

CREATE TABLE nuke_cart_shipping_options_peritem (
   peritemcost double(10,2) DEFAULT '0.00' NOT NULL,
   PRIMARY KEY (peritemcost)
);

#
# Dumping data for table 'nuke_cart_shipping_options_peritem'
#

INSERT INTO nuke_cart_shipping_options_peritem VALUES ('2.00');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_shipping_options_producttotal'
#

CREATE TABLE nuke_cart_shipping_options_producttotal (
   percentage double DEFAULT '0' NOT NULL
);

#
# Dumping data for table 'nuke_cart_shipping_options_producttotal'
#

INSERT INTO nuke_cart_shipping_options_producttotal VALUES ('10');
INSERT INTO nuke_cart_shipping_options_producttotal VALUES ('0');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_shipping_options_productweight'
#

CREATE TABLE nuke_cart_shipping_options_productweight (
   cost double(10,2) DEFAULT '0.00' NOT NULL
);

#
# Dumping data for table 'nuke_cart_shipping_options_productweight'
#

INSERT INTO nuke_cart_shipping_options_productweight VALUES ('2.00');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_shipping_options_ups'
#

CREATE TABLE nuke_cart_shipping_options_ups (
   config_name varchar(255) NOT NULL,
   config_value text NOT NULL
);

#
# Dumping data for table 'nuke_cart_shipping_options_ups'
#

INSERT INTO nuke_cart_shipping_options_ups VALUES ('origin_country_code', 'US');
INSERT INTO nuke_cart_shipping_options_ups VALUES ('origin_postal_code', '21532');
INSERT INTO nuke_cart_shipping_options_ups VALUES ('service_types', '1DM,1DA,1DAPI,1DP,2DM,2DA,3DS,GND,GNDRES,GNDCOM,STD,XPR,XDM,XPD');
INSERT INTO nuke_cart_shipping_options_ups VALUES ('user_id', 'emporiumdev');
INSERT INTO nuke_cart_shipping_options_ups VALUES ('user_password', 'empdev');
INSERT INTO nuke_cart_shipping_options_ups VALUES ('license_number', '7BB0DE52C40237F0');
INSERT INTO nuke_cart_shipping_options_ups VALUES ('service_default', 'GNDRES');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_states'
#

CREATE TABLE nuke_cart_states (
   stateID int(11) NOT NULL auto_increment,
   stateName varchar(32),
   stateCode varchar(32),
   PRIMARY KEY (stateID),
   KEY stateID (stateID)
);

#
# Dumping data for table 'nuke_cart_states'
#

INSERT INTO nuke_cart_states VALUES ('1', 'Alabama', 'AL');
INSERT INTO nuke_cart_states VALUES ('2', 'Alaska', 'AK');
INSERT INTO nuke_cart_states VALUES ('3', 'Arizona', 'AZ');
INSERT INTO nuke_cart_states VALUES ('4', 'Arkansas', 'AR');
INSERT INTO nuke_cart_states VALUES ('5', 'California', 'CA');
INSERT INTO nuke_cart_states VALUES ('6', 'Colorado', 'CO');
INSERT INTO nuke_cart_states VALUES ('7', 'Connecticut', 'CT');
INSERT INTO nuke_cart_states VALUES ('8', 'Delaware', 'DE');
INSERT INTO nuke_cart_states VALUES ('9', 'District of Columbia', 'DC');
INSERT INTO nuke_cart_states VALUES ('10', 'Florida', 'FL');
INSERT INTO nuke_cart_states VALUES ('11', 'Georgia', 'GA');
INSERT INTO nuke_cart_states VALUES ('12', 'Guam', 'GU');
INSERT INTO nuke_cart_states VALUES ('13', 'Hawaii', 'HI');
INSERT INTO nuke_cart_states VALUES ('14', 'Idaho', 'ID');
INSERT INTO nuke_cart_states VALUES ('15', 'Illinois', 'IL');
INSERT INTO nuke_cart_states VALUES ('16', 'Indiana', 'IN');
INSERT INTO nuke_cart_states VALUES ('17', 'Iowa', 'IA');
INSERT INTO nuke_cart_states VALUES ('18', 'Kansas', 'KS');
INSERT INTO nuke_cart_states VALUES ('19', 'Kentucky', 'KY');
INSERT INTO nuke_cart_states VALUES ('20', 'Louisiana', 'LA');
INSERT INTO nuke_cart_states VALUES ('21', 'Maine', 'ME');
INSERT INTO nuke_cart_states VALUES ('22', 'Maryland', 'MD');
INSERT INTO nuke_cart_states VALUES ('23', 'Massachusetts', 'MA');
INSERT INTO nuke_cart_states VALUES ('24', 'Michigan', 'MI');
INSERT INTO nuke_cart_states VALUES ('25', 'Minnesota', 'MN');
INSERT INTO nuke_cart_states VALUES ('26', 'Mississippi', 'MS');
INSERT INTO nuke_cart_states VALUES ('27', 'Missouri', 'MO');
INSERT INTO nuke_cart_states VALUES ('28', 'Montana', 'MT');
INSERT INTO nuke_cart_states VALUES ('29', 'Nebraska', 'NE');
INSERT INTO nuke_cart_states VALUES ('30', 'Nevada', 'NV');
INSERT INTO nuke_cart_states VALUES ('31', 'New Hampshire', 'NH');
INSERT INTO nuke_cart_states VALUES ('32', 'New Jersey', 'NJ');
INSERT INTO nuke_cart_states VALUES ('33', 'New Mexico', 'NM');
INSERT INTO nuke_cart_states VALUES ('34', 'New York', 'NY');
INSERT INTO nuke_cart_states VALUES ('35', 'North Carolina', 'NC');
INSERT INTO nuke_cart_states VALUES ('36', 'North Dakota', 'ND');
INSERT INTO nuke_cart_states VALUES ('37', 'Ohio', 'OH');
INSERT INTO nuke_cart_states VALUES ('38', 'Oklahoma', 'OK');
INSERT INTO nuke_cart_states VALUES ('39', 'Oregon', 'OR');
INSERT INTO nuke_cart_states VALUES ('40', 'Pennsylvania', 'PA');
INSERT INTO nuke_cart_states VALUES ('41', 'Puerto Rico', 'PR');
INSERT INTO nuke_cart_states VALUES ('42', 'Rhode Island', 'RI');
INSERT INTO nuke_cart_states VALUES ('43', 'South Carolina', 'SC');
INSERT INTO nuke_cart_states VALUES ('44', 'South Dakota', 'SD');
INSERT INTO nuke_cart_states VALUES ('45', 'Tennessee', 'TN');
INSERT INTO nuke_cart_states VALUES ('46', 'Texas', 'TX');
INSERT INTO nuke_cart_states VALUES ('47', 'Utah', 'UT');
INSERT INTO nuke_cart_states VALUES ('48', 'Vermont', 'VT');
INSERT INTO nuke_cart_states VALUES ('49', 'Virgin Islands', 'VI');
INSERT INTO nuke_cart_states VALUES ('50', 'Virginia', 'VA');
INSERT INTO nuke_cart_states VALUES ('51', 'Washington', 'WA');
INSERT INTO nuke_cart_states VALUES ('52', 'West Virginia', 'WV');
INSERT INTO nuke_cart_states VALUES ('53', 'Wisconsin', 'WI');
INSERT INTO nuke_cart_states VALUES ('54', 'Wyoming', 'WY');
INSERT INTO nuke_cart_states VALUES ('55', '-Outside the US-', 'N/A');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_taxes_classes'
#

CREATE TABLE nuke_cart_taxes_classes (
   tax_class_id int(11) NOT NULL auto_increment,
   tax_class_name varchar(255) NOT NULL,
   tax_class_description text NOT NULL,
   date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   PRIMARY KEY (tax_class_id),
   KEY tax_class_id (tax_class_id)
);

#
# Dumping data for table 'nuke_cart_taxes_classes'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_taxes_classes_locations'
#

CREATE TABLE nuke_cart_taxes_classes_locations (
   tax_class_id int(11) DEFAULT '0' NOT NULL,
   location_id int(11) DEFAULT '0' NOT NULL,
   location_type varchar(255) NOT NULL,
   tax_value_percent double(10,2) DEFAULT '0.00' NOT NULL,
   tax_value_flat double(10,2) DEFAULT '0.00' NOT NULL
);

#
# Dumping data for table 'nuke_cart_taxes_classes_locations'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cart_users'
#

CREATE TABLE nuke_cart_users (
   user_id int(11) DEFAULT '0' NOT NULL,
   fname text NOT NULL,
   lname text NOT NULL,
   username varchar(25) NOT NULL,
   email text NOT NULL,
   address1 varchar(64),
   address2 varchar(64),
   city varchar(64),
   state varchar(32),
   country varchar(64),
   postcode varchar(16),
   dayPhone varchar(64),
   evePhone varchar(64),
   myCurr int(4) DEFAULT '0' NOT NULL,
   PRIMARY KEY (user_id),
   KEY user_id (user_id)
);

#
# Dumping data for table 'nuke_cart_users'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cnbya_config'
#

CREATE TABLE nuke_cnbya_config (
   config_name varchar(255) NOT NULL,
   config_value longtext,
   UNIQUE config_name (config_name)
);

#
# Dumping data for table 'nuke_cnbya_config'
#

INSERT INTO nuke_cnbya_config VALUES ('sendaddmail', '0');
INSERT INTO nuke_cnbya_config VALUES ('senddeletemail', '0');
INSERT INTO nuke_cnbya_config VALUES ('allowuserdelete', '0');
INSERT INTO nuke_cnbya_config VALUES ('allowusertheme', '0');
INSERT INTO nuke_cnbya_config VALUES ('allowuserreg', '0');
INSERT INTO nuke_cnbya_config VALUES ('allowmailchange', '1');
INSERT INTO nuke_cnbya_config VALUES ('emailvalidate', '0');
INSERT INTO nuke_cnbya_config VALUES ('requireadmin', '0');
INSERT INTO nuke_cnbya_config VALUES ('servermail', '1');
INSERT INTO nuke_cnbya_config VALUES ('useactivate', '1');
INSERT INTO nuke_cnbya_config VALUES ('usegfxcheck', '0');
INSERT INTO nuke_cnbya_config VALUES ('autosuspend', '0');
INSERT INTO nuke_cnbya_config VALUES ('perpage', '100');
INSERT INTO nuke_cnbya_config VALUES ('expiring', '86400');
INSERT INTO nuke_cnbya_config VALUES ('nick_min', '3');
INSERT INTO nuke_cnbya_config VALUES ('nick_max', '20');
INSERT INTO nuke_cnbya_config VALUES ('pass_min', '3');
INSERT INTO nuke_cnbya_config VALUES ('pass_max', '25');
INSERT INTO nuke_cnbya_config VALUES ('bad_mail', 'mysite.com\r\nyoursite.com');
INSERT INTO nuke_cnbya_config VALUES ('bad_nick', 'adm\r\nadmin\r\nanonimo\r\nanonymous\r\nan�nimo\r\ngod\r\nlinux\r\nnobody\r\noperator\r\nroot\r\nstaff\r\nwebmaster');
INSERT INTO nuke_cnbya_config VALUES ('coppa', '1');
INSERT INTO nuke_cnbya_config VALUES ('tos', '0');
INSERT INTO nuke_cnbya_config VALUES ('cookiecheck', '1');
INSERT INTO nuke_cnbya_config VALUES ('cookietimelife', '2592000');
INSERT INTO nuke_cnbya_config VALUES ('cookiepath', '');
INSERT INTO nuke_cnbya_config VALUES ('cookieinactivity', '-');
INSERT INTO nuke_cnbya_config VALUES ('autosuspendmain', '0');
INSERT INTO nuke_cnbya_config VALUES ('version', '4.4.0 b2');
INSERT INTO nuke_cnbya_config VALUES ('codesize', '0');
INSERT INTO nuke_cnbya_config VALUES ('cookiecleaner', '1');
INSERT INTO nuke_cnbya_config VALUES ('tosall', '0');
INSERT INTO nuke_cnbya_config VALUES ('doublecheckemail', '1');

# --------------------------------------------------------
#
# Table structure for table 'nuke_cnbya_field'
#

CREATE TABLE nuke_cnbya_field (
   fid int(10) NOT NULL auto_increment,
   name varchar(255) DEFAULT 'field' NOT NULL,
   value varchar(255),
   size int(3),
   need int(1) DEFAULT '1' NOT NULL,
   pos int(3),
   public int(1) DEFAULT '1' NOT NULL,
   PRIMARY KEY (fid),
   KEY fid (fid)
);

#
# Dumping data for table 'nuke_cnbya_field'
#


# --------------------------------------------------------
#
# Table structure for table 'nuke_cnbya_tos'
#

CREATE TABLE nuke_cnbya_tos (
   id int(11) NOT NULL auto_increment,
   data text NOT NULL,
   status tinyint(4) DEFAULT '0' NOT NULL,
   des text NOT NULL,
   language varchar(25) NOT NULL,
   time text NOT NULL,
   PRIMARY KEY (id)
);

#
# Dumping data for table 'nuke_cnbya_tos'
#

INSERT INTO nuke_cnbya_tos VALUES ('1', '<p><font class=\"content\"><b>1. Acceptance of Terms of Use and Amendments</b><br>\r\nEach time you use or cause access to this web site, you agree to be bound by \r\nthese Terms of Use, and as amended from time to time with or without notice to \r\nyou. In addition, if you are using a particular service on or through this web \r\nsite, you will be subject to any rules or guidelines applicable to those \r\nservices and they shall be incorporated by reference into these Terms of Use. \r\nPlease see our\r\n<a href=\"modules.php?name=Docs&file=privacy\" target=\"_blank\">\r\nPrivacy Statement</a>, which is incorporated into these Terms of Use by \r\nreference.<br>\r\n<br>\r\n<b>2. Our Service</b><br>\r\nOur web site and services provided to you on and through our web site on an AS \r\nIS basis.You agree that the owners of this web site exclusively reserve the \r\nright and may, at any time and without notice and any liability to you, modify \r\nor discontinue this web site and its services or delete the data you provide, \r\nwhether temporarily or permanently. We shall have no responsibilty or liability \r\nfor the timeliness, deletion, failure to store, inaccuracy, or improper delivery \r\nof any data or information.<br>\r\n<br>\r\n<b>3. Your Responsibilities and Registration Obligations</b><br>\r\nIn order to use this web site, you must register o