DROP TABLE IF EXISTS Buyers;
CREATE TABLE Buyers (
  Name varchar(100) NOT NULL default '',
  Address1 varchar(100) NOT NULL default '',
  Address2 varchar(100) NOT NULL default '',
  City varchar(100) NOT NULL default '',
  State char(2) NOT NULL default '',
  Zip varchar(20) NOT NULL default '',
  Email varchar(100) NOT NULL default '',
  DayPhone varchar(100) NOT NULL default '',
  EvePhone varchar(100) NOT NULL default '',
  Contact int(1) NOT NULL default '0',
  PayMethod varchar(100) NOT NULL default '',
  CCType varchar(100) NOT NULL default '',
  CCNum varchar(100) NOT NULL default '',
  CCExpire varchar(100) NOT NULL default '',
  OrderTotal decimal(8,2) NOT NULL default '0.00',
  Date varchar(100) NOT NULL default '',
  OrderNumber bigint(20) NOT NULL default '0',
  UserID varchar(100) NOT NULL default '',
  BuyerID bigint(20) NOT NULL auto_increment,
  Pass varchar(10) NOT NULL default '',
  PRIMARY KEY  (BuyerID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `CartItems`
#

DROP TABLE IF EXISTS CartItems;
CREATE TABLE CartItems (
  UserID varchar(100) NOT NULL default '',
  ItemID varchar(25) NOT NULL default '',
  ItemQuantity int(4) NOT NULL default '0',
  Date varchar(100) NOT NULL default '',
  CartItemsID bigint(20) NOT NULL auto_increment,
  ItemOptions text,
  PRIMARY KEY  (CartItemsID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `Category`
#

DROP TABLE IF EXISTS Category;
CREATE TABLE Category (
  Category varchar(100) NOT NULL default '',
  CategoryID bigint(20) NOT NULL auto_increment,
  PagingStep int(11) NOT NULL default '10',
  PRIMARY KEY  (CategoryID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `ItemOption`
#

DROP TABLE IF EXISTS ItemOption;
CREATE TABLE ItemOption (
  OptionID int(11) NOT NULL auto_increment,
  ItemID int(11) NOT NULL default '0',
  OptionName varchar(100) NOT NULL default '',
  OptionType varchar(10) NOT NULL default '',
  PRIMARY KEY  (OptionID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `Items`
#

DROP TABLE IF EXISTS Items;
CREATE TABLE Items (
  ItemSKU varchar(25) NOT NULL default '',
  ItemName varchar(100) NOT NULL default '',
  ItemDescription mediumtext NOT NULL,
  ItemCost decimal(7,2) NOT NULL default '0.00',
  Category bigint(20) NOT NULL default '0',
  ShippingCost decimal(6,2) NOT NULL default '0.00',
  ItemID bigint(20) NOT NULL auto_increment,
  ItemGraphic text,
  PaymentCycle char(1) NOT NULL default 'O',
  PRIMARY KEY  (ItemID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `OrderOption`
#

DROP TABLE IF EXISTS OrderOption;
CREATE TABLE OrderOption (
  OptionID int(11) NOT NULL auto_increment,
  OptionName varchar(100) NOT NULL default '',
  OptionType varchar(10) NOT NULL default '',
  PRIMARY KEY  (OptionID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `OrderOptionValue`
#

DROP TABLE IF EXISTS OrderOptionValue;
CREATE TABLE OrderOptionValue (
  ValueID int(11) NOT NULL auto_increment,
  OptionID int(11) NOT NULL default '0',
  ValueName varchar(100) NOT NULL default '',
  PRIMARY KEY  (ValueID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `Orders`
#

DROP TABLE IF EXISTS Orders;
CREATE TABLE Orders (
  BuyerID bigint(20) NOT NULL default '0',
  UserID varchar(100) NOT NULL default '',
  Date varchar(100) NOT NULL default '',
  OrderTotal decimal(8,2) NOT NULL default '0.00',
  OrderNumber bigint(20) NOT NULL auto_increment,
  OrderStatus varchar(10) NOT NULL default 'processing',
  bName varchar(100) NOT NULL default '',
  bAddress1 varchar(100) NOT NULL default '',
  bAddress2 varchar(100) NOT NULL default '',
  bCity varchar(100) NOT NULL default '',
  bState char(2) NOT NULL default '',
  bZip varchar(20) NOT NULL default '',
  bDayPhone varchar(100) NOT NULL default '',
  bEvePhone varchar(100) NOT NULL default '',
  bContact int(1) NOT NULL default '0',
  bPayMethod varchar(100) NOT NULL default '',
  bCCType varchar(100) NOT NULL default '',
  bCCNum varchar(100) NOT NULL default '',
  bCCExpire varchar(100) NOT NULL default '',
  OrderOptions text,
  PaymentCycle char(1) NOT NULL default 'O',
  PaymentStatus int(11) NOT NULL default '0',
  PRIMARY KEY  (OrderNumber)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `Receipts`
#

DROP TABLE IF EXISTS Receipts;
CREATE TABLE Receipts (
  BuyerID bigint(20) NOT NULL default '0',
  UserID varchar(100) NOT NULL default '',
  OrderNumber bigint(20) NOT NULL default '0',
  Date varchar(100) NOT NULL default '',
  ItemID bigint(20) NOT NULL default '0',
  ItemSKU varchar(25) NOT NULL default '',
  ItemName varchar(100) NOT NULL default '',
  ItemCost decimal(7,2) NOT NULL default '0.00',
  ShippingCost decimal(6,2) NOT NULL default '0.00',
  ItemQuantity int(11) NOT NULL default '0',
  TotalCost decimal(8,2) NOT NULL default '0.00',
  ItemOptions text,
  PaymentCycle char(1) NOT NULL default 'O'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `Users`
#

DROP TABLE IF EXISTS Users;
CREATE TABLE Users (
  User varchar(100) NOT NULL default '',
  Date int(4) NOT NULL default '0'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke65_jobapply`
#

DROP TABLE IF EXISTS nuke65_jobapply;
CREATE TABLE nuke65_jobapply (
  no bigint(20) NOT NULL auto_increment,
  jcode int(11) NOT NULL default '0',
  jobseeker varchar(30) NOT NULL default '0',
  employer varchar(30) NOT NULL default '',
  date date NOT NULL default '0000-00-00',
  PRIMARY KEY  (no)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke65_jobclient`
#

DROP TABLE IF EXISTS nuke65_jobclient;
CREATE TABLE nuke65_jobclient (
  user_id varchar(30) NOT NULL default '',
  clientname varchar(100) NOT NULL default '',
  clientcompany varchar(255) NOT NULL default '',
  clientcompanyindustry tinyint(4) NOT NULL default '0',
  clientaddress varchar(255) NOT NULL default '',
  clientcity varchar(50) NOT NULL default '',
  clientstate varchar(50) NOT NULL default '',
  clientzipcode varchar(10) NOT NULL default '',
  clientcountry tinyint(4) NOT NULL default '0',
  clientphone varchar(255) NOT NULL default '',
  clientfax varchar(30) NOT NULL default '',
  clientemail varchar(255) NOT NULL default '',
  clienturl varchar(100) NOT NULL default '',
  clientcompanydesc text NOT NULL,
  PRIMARY KEY  (user_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke65_jobdepartment_wanted`
#

DROP TABLE IF EXISTS nuke65_jobdepartment_wanted;
CREATE TABLE nuke65_jobdepartment_wanted (
  jobseeker char(30) NOT NULL default '',
  id_department tinyint(4) NOT NULL default '0',
  language char(30) NOT NULL default ''
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke65_jobeducation`
#

DROP TABLE IF EXISTS nuke65_jobeducation;
CREATE TABLE nuke65_jobeducation (
  no int(11) NOT NULL auto_increment,
  user_id varchar(50) NOT NULL default '',
  institute varchar(255) NOT NULL default '',
  fk_degree tinyint(3) unsigned NOT NULL default '0',
  fk_subject tinyint(3) unsigned NOT NULL default '0',
  year varchar(4) NOT NULL default '',
  PRIMARY KEY  (no)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke65_jobemployment`
#

DROP TABLE IF EXISTS nuke65_jobemployment;
CREATE TABLE nuke65_jobemployment (
  no int(11) NOT NULL auto_increment,
  user_id varchar(50) NOT NULL default '',
  employer varchar(255) NOT NULL default '',
  fk_industry tinyint(3) unsigned NOT NULL default '0',
  position varchar(50) NOT NULL default '',
  start_year varchar(4) NOT NULL default '',
  end_year varchar(4) NOT NULL default '',
  responsibilities text NOT NULL,
  PRIMARY KEY  (no)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke65_jobinvite`
#

DROP TABLE IF EXISTS nuke65_jobinvite;
CREATE TABLE nuke65_jobinvite (
  no bigint(20) NOT NULL auto_increment,
  jcode bigint(20) NOT NULL default '0',
  jobseeker varchar(30) NOT NULL default '',
  employer varchar(30) NOT NULL default '',
  application text NOT NULL,
  date date NOT NULL default '0000-00-00',
  PRIMARY KEY  (no)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke65_joblisting`
#

DROP TABLE IF EXISTS nuke65_joblisting;
CREATE TABLE nuke65_joblisting (
  jcode bigint(20) NOT NULL auto_increment,
  cname varchar(50) NOT NULL default '',
  title varchar(200) NOT NULL default '',
  responsibility text NOT NULL,
  qualification text NOT NULL,
  posted date NOT NULL default '0000-00-00',
  validuntil date NOT NULL default '0000-00-00',
  city varchar(60) NOT NULL default '',
  country tinyint(4) NOT NULL default '1',
  salary tinyint(4) NOT NULL default '1',
  department tinyint(4) NOT NULL default '1',
  hits int(11) NOT NULL default '0',
  language varchar(20) NOT NULL default '',
  PRIMARY KEY  (jcode)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke65_joblocation`
#

DROP TABLE IF EXISTS nuke65_joblocation;
CREATE TABLE nuke65_joblocation (
  id tinyint(3) unsigned NOT NULL auto_increment,
  location varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke65_jobobjective`
#

DROP TABLE IF EXISTS nuke65_jobobjective;
CREATE TABLE nuke65_jobobjective (
  no int(11) NOT NULL auto_increment,
  user_name varchar(30) NOT NULL default '',
  salary tinyint(1) NOT NULL default '0',
  location varchar(80) default NULL,
  industry tinyint(3) default NULL,
  position varchar(50) default NULL,
  PRIMARY KEY  (no)
) TYPE=MyISAM COMMENT='&amp;#20851;&amp;#20110;&amp;#27714;&amp;#32844;&amp;#32773;';
# --------------------------------------------------------

#
# ݱĽṹ `nuke65_joboffer`
#

DROP TABLE IF EXISTS nuke65_joboffer;
CREATE TABLE nuke65_joboffer (
  no bigint(20) NOT NULL auto_increment,
  jobseeker varchar(30) NOT NULL default '',
  employer varchar(30) NOT NULL default '',
  letter text NOT NULL,
  date date NOT NULL default '0000-00-00',
  PRIMARY KEY  (no)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke65_jobreference`
#

DROP TABLE IF EXISTS nuke65_jobreference;
CREATE TABLE nuke65_jobreference (
  rid tinyint(3) unsigned NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  phone varchar(25) NOT NULL default '',
  email varchar(255) default NULL,
  KEY rid (rid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke65_jobskill`
#

DROP TABLE IF EXISTS nuke65_jobskill;
CREATE TABLE nuke65_jobskill (
  no int(11) NOT NULL auto_increment,
  user_id varchar(50) NOT NULL default '',
  skill varchar(255) NOT NULL default '',
  experience tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (no)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke65_jobuser`
#

DROP TABLE IF EXISTS nuke65_jobuser;
CREATE TABLE nuke65_jobuser (
  user_id varchar(50) NOT NULL default '',
  fname varchar(60) NOT NULL default '',
  lname varchar(60) NOT NULL default '',
  dob date NOT NULL default '0000-00-00',
  addr1 varchar(255) NOT NULL default '',
  addr2 varchar(255) default NULL,
  city varchar(100) NOT NULL default '',
  state varchar(100) NOT NULL default '',
  zip varchar(20) NOT NULL default '',
  fk_country tinyint(3) unsigned NOT NULL default '0',
  phone varchar(25) NOT NULL default '',
  email varchar(100) NOT NULL default '',
  url varchar(100) default NULL,
  posted date NOT NULL default '0000-00-00',
  KEY rid (user_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_access`
#

DROP TABLE IF EXISTS nuke_access;
CREATE TABLE nuke_access (
  access_id int(10) NOT NULL auto_increment,
  access_title varchar(20) default NULL,
  PRIMARY KEY  (access_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_authors`
#

DROP TABLE IF EXISTS nuke_authors;
CREATE TABLE nuke_authors (
  aid varchar(25) NOT NULL default '',
  name varchar(50) default NULL,
  url varchar(255) NOT NULL default '',
  email varchar(255) NOT NULL default '',
  pwd varchar(40) default NULL,
  counter int(11) NOT NULL default '0',
  radminarticle tinyint(2) NOT NULL default '0',
  radmintopic tinyint(2) NOT NULL default '0',
  radminuser tinyint(2) NOT NULL default '0',
  radminsurvey tinyint(2) NOT NULL default '0',
  radminsection tinyint(2) NOT NULL default '0',
  radminlink tinyint(2) NOT NULL default '0',
  radminephem tinyint(2) NOT NULL default '0',
  radminfaq tinyint(2) NOT NULL default '0',
  radmindownload tinyint(2) NOT NULL default '0',
  radminreviews tinyint(2) NOT NULL default '0',
  radminnewsletter tinyint(2) NOT NULL default '0',
  radminforum tinyint(2) NOT NULL default '0',
  radmincontent tinyint(2) NOT NULL default '0',
  radminency tinyint(2) NOT NULL default '0',
  radminsuper tinyint(2) NOT NULL default '1',
  admlanguage varchar(30) NOT NULL default '',
  PRIMARY KEY  (aid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_autonews`
#

DROP TABLE IF EXISTS nuke_autonews;
CREATE TABLE nuke_autonews (
  anid int(11) NOT NULL auto_increment,
  catid int(11) NOT NULL default '0',
  aid varchar(30) NOT NULL default '',
  title varchar(80) NOT NULL default '',
  time varchar(19) NOT NULL default '',
  hometext text NOT NULL,
  bodytext text NOT NULL,
  topic int(3) NOT NULL default '1',
  informant varchar(20) NOT NULL default '',
  notes text NOT NULL,
  ihome int(1) NOT NULL default '0',
  alanguage varchar(30) NOT NULL default '',
  acomm int(1) NOT NULL default '0',
  PRIMARY KEY  (anid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_banlist`
#

DROP TABLE IF EXISTS nuke_banlist;
CREATE TABLE nuke_banlist (
  ban_id int(10) NOT NULL auto_increment,
  ban_userid int(10) default NULL,
  ban_ip varchar(16) default NULL,
  ban_start int(32) default NULL,
  ban_end int(50) default NULL,
  ban_time_type int(10) default NULL,
  PRIMARY KEY  (ban_id),
  KEY ban_id (ban_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_banner`
#

DROP TABLE IF EXISTS nuke_banner;
CREATE TABLE nuke_banner (
  bid int(11) NOT NULL auto_increment,
  cid int(11) NOT NULL default '0',
  imptotal int(11) NOT NULL default '0',
  impmade int(11) NOT NULL default '0',
  clicks int(11) NOT NULL default '0',
  imageurl varchar(100) NOT NULL default '',
  clickurl varchar(200) NOT NULL default '',
  date datetime default NULL,
  PRIMARY KEY  (bid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_bannerclient`
#

DROP TABLE IF EXISTS nuke_bannerclient;
CREATE TABLE nuke_bannerclient (
  cid int(11) NOT NULL auto_increment,
  name varchar(60) NOT NULL default '',
  contact varchar(60) NOT NULL default '',
  email varchar(60) NOT NULL default '',
  login varchar(10) NOT NULL default '',
  passwd varchar(10) NOT NULL default '',
  extrainfo text NOT NULL,
  PRIMARY KEY  (cid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_bannerfinish`
#

DROP TABLE IF EXISTS nuke_bannerfinish;
CREATE TABLE nuke_bannerfinish (
  bid int(11) NOT NULL auto_increment,
  cid int(11) NOT NULL default '0',
  impressions int(11) NOT NULL default '0',
  clicks int(11) NOT NULL default '0',
  datestart datetime default NULL,
  dateend datetime default NULL,
  PRIMARY KEY  (bid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_bbtopics`
#

DROP TABLE IF EXISTS nuke_bbtopics;
CREATE TABLE nuke_bbtopics (
  topic_id int(10) NOT NULL auto_increment,
  topic_title varchar(100) default NULL,
  topic_poster int(10) default NULL,
  topic_time varchar(20) default NULL,
  topic_views int(10) NOT NULL default '0',
  topic_replies int(10) NOT NULL default '0',
  topic_last_post_id int(10) NOT NULL default '0',
  forum_id int(10) NOT NULL default '0',
  topic_status int(10) NOT NULL default '0',
  topic_notify int(2) default '0',
  PRIMARY KEY  (topic_id),
  KEY topic_id (topic_id),
  KEY forum_id (forum_id),
  KEY topic_last_post_id (topic_last_post_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_blocks`
#

DROP TABLE IF EXISTS nuke_blocks;
CREATE TABLE nuke_blocks (
  bid int(10) NOT NULL auto_increment,
  bkey varchar(15) NOT NULL default '',
  title varchar(60) NOT NULL default '',
  content text NOT NULL,
  url varchar(200) NOT NULL default '',
  position char(1) NOT NULL default '',
  weight int(10) NOT NULL default '1',
  active int(1) NOT NULL default '1',
  refresh int(10) NOT NULL default '0',
  time varchar(14) NOT NULL default '0',
  blanguage varchar(30) NOT NULL default '',
  blockfile varchar(255) NOT NULL default '',
  view int(1) NOT NULL default '0',
  PRIMARY KEY  (bid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_catagories`
#

DROP TABLE IF EXISTS nuke_catagories;
CREATE TABLE nuke_catagories (
  cat_id int(10) NOT NULL auto_increment,
  cat_title varchar(100) default NULL,
  cat_order varchar(10) default NULL,
  PRIMARY KEY  (cat_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_comments`
#

DROP TABLE IF EXISTS nuke_comments;
CREATE TABLE nuke_comments (
  tid int(11) NOT NULL auto_increment,
  pid int(11) default '0',
  sid int(11) default '0',
  date datetime default NULL,
  name varchar(60) NOT NULL default '',
  email varchar(60) default NULL,
  url varchar(60) default NULL,
  host_name varchar(60) default NULL,
  subject varchar(85) NOT NULL default '',
  comment text NOT NULL,
  score tinyint(4) NOT NULL default '0',
  reason tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (tid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_config`
#

DROP TABLE IF EXISTS nuke_config;
CREATE TABLE nuke_config (
  config_id int(10) NOT NULL auto_increment,
  allow_html int(2) default NULL,
  allow_bbcode int(2) default NULL,
  allow_sig int(2) default NULL,
  selected int(2) NOT NULL default '0',
  posts_per_page int(10) default NULL,
  hot_threshold int(10) default NULL,
  topics_per_page int(10) default NULL,
  email_sig varchar(255) default NULL,
  email_from varchar(100) default NULL,
  PRIMARY KEY  (config_id),
  UNIQUE KEY selected (selected)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_counter`
#

DROP TABLE IF EXISTS nuke_counter;
CREATE TABLE nuke_counter (
  type varchar(80) NOT NULL default '',
  var varchar(80) NOT NULL default '',
  count int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_disallow`
#

DROP TABLE IF EXISTS nuke_disallow;
CREATE TABLE nuke_disallow (
  disallow_id int(10) NOT NULL auto_increment,
  disallow_username varchar(50) default NULL,
  PRIMARY KEY  (disallow_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_downloads_categories`
#

DROP TABLE IF EXISTS nuke_downloads_categories;
CREATE TABLE nuke_downloads_categories (
  cid int(11) NOT NULL auto_increment,
  title varchar(50) NOT NULL default '',
  cdescription text NOT NULL,
  parentid int(11) NOT NULL default '0',
  PRIMARY KEY  (cid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_downloads_downloads`
#

DROP TABLE IF EXISTS nuke_downloads_downloads;
CREATE TABLE nuke_downloads_downloads (
  lid int(11) NOT NULL auto_increment,
  cid int(11) NOT NULL default '0',
  sid int(11) NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  url varchar(100) NOT NULL default '',
  description text NOT NULL,
  date datetime default NULL,
  name varchar(100) NOT NULL default '',
  email varchar(100) NOT NULL default '',
  hits int(11) NOT NULL default '0',
  submitter varchar(60) NOT NULL default '',
  downloadratingsummary double(6,4) NOT NULL default '0.0000',
  totalvotes int(11) NOT NULL default '0',
  totalcomments int(11) NOT NULL default '0',
  filesize int(11) NOT NULL default '0',
  version varchar(10) NOT NULL default '',
  homepage varchar(200) NOT NULL default '',
  PRIMARY KEY  (lid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_downloads_editorials`
#

DROP TABLE IF EXISTS nuke_downloads_editorials;
CREATE TABLE nuke_downloads_editorials (
  downloadid int(11) NOT NULL default '0',
  adminid varchar(60) NOT NULL default '',
  editorialtimestamp datetime NOT NULL default '0000-00-00 00:00:00',
  editorialtext text NOT NULL,
  editorialtitle varchar(100) NOT NULL default '',
  PRIMARY KEY  (downloadid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_downloads_modrequest`
#

DROP TABLE IF EXISTS nuke_downloads_modrequest;
CREATE TABLE nuke_downloads_modrequest (
  requestid int(11) NOT NULL auto_increment,
  lid int(11) NOT NULL default '0',
  cid int(11) NOT NULL default '0',
  sid int(11) NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  url varchar(100) NOT NULL default '',
  description text NOT NULL,
  modifysubmitter varchar(60) NOT NULL default '',
  brokendownload int(3) NOT NULL default '0',
  name varchar(100) NOT NULL default '',
  email varchar(100) NOT NULL default '',
  filesize int(11) NOT NULL default '0',
  version varchar(10) NOT NULL default '',
  homepage varchar(200) NOT NULL default '',
  PRIMARY KEY  (requestid),
  UNIQUE KEY requestid (requestid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_downloads_newdownload`
#

DROP TABLE IF EXISTS nuke_downloads_newdownload;
CREATE TABLE nuke_downloads_newdownload (
  lid int(11) NOT NULL auto_increment,
  cid int(11) NOT NULL default '0',
  sid int(11) NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  url varchar(100) NOT NULL default '',
  description text NOT NULL,
  name varchar(100) NOT NULL default '',
  email varchar(100) NOT NULL default '',
  submitter varchar(60) NOT NULL default '',
  filesize int(11) NOT NULL default '0',
  version varchar(10) NOT NULL default '',
  homepage varchar(200) NOT NULL default '',
  PRIMARY KEY  (lid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_downloads_votedata`
#

DROP TABLE IF EXISTS nuke_downloads_votedata;
CREATE TABLE nuke_downloads_votedata (
  ratingdbid int(11) NOT NULL auto_increment,
  ratinglid int(11) NOT NULL default '0',
  ratinguser varchar(60) NOT NULL default '',
  rating int(11) NOT NULL default '0',
  ratinghostname varchar(60) NOT NULL default '',
  ratingcomments text NOT NULL,
  ratingtimestamp datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (ratingdbid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_encyclopedia`
#

DROP TABLE IF EXISTS nuke_encyclopedia;
CREATE TABLE nuke_encyclopedia (
  eid int(10) NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  description text NOT NULL,
  elanguage varchar(30) NOT NULL default '',
  active int(1) NOT NULL default '0',
  PRIMARY KEY  (eid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_encyclopedia_text`
#

DROP TABLE IF EXISTS nuke_encyclopedia_text;
CREATE TABLE nuke_encyclopedia_text (
  tid int(10) NOT NULL auto_increment,
  eid int(10) NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  text text NOT NULL,
  counter int(10) NOT NULL default '0',
  PRIMARY KEY  (tid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_ephem`
#

DROP TABLE IF EXISTS nuke_ephem;
CREATE TABLE nuke_ephem (
  eid int(11) NOT NULL auto_increment,
  did int(2) NOT NULL default '0',
  mid int(2) NOT NULL default '0',
  yid int(4) NOT NULL default '0',
  content text NOT NULL,
  elanguage varchar(30) NOT NULL default '',
  PRIMARY KEY  (eid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_faqanswer`
#

DROP TABLE IF EXISTS nuke_faqanswer;
CREATE TABLE nuke_faqanswer (
  id tinyint(4) NOT NULL auto_increment,
  id_cat tinyint(4) default NULL,
  question varchar(255) default NULL,
  answer text,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_faqcategories`
#

DROP TABLE IF EXISTS nuke_faqcategories;
CREATE TABLE nuke_faqcategories (
  id_cat tinyint(3) NOT NULL auto_increment,
  categories varchar(255) default NULL,
  flanguage varchar(30) NOT NULL default '',
  PRIMARY KEY  (id_cat)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_ff_config`
#

DROP TABLE IF EXISTS nuke_ff_config;
CREATE TABLE nuke_ff_config (
  disappphoto mediumtext NOT NULL,
  disappprofile mediumtext NOT NULL,
  approveprofile mediumtext NOT NULL,
  maxsize int(7) NOT NULL default '100000',
  checkprofile tinyint(1) NOT NULL default '0',
  showstars tinyint(1) NOT NULL default '0',
  showtop tinyint(1) NOT NULL default '0',
  showdetailedsearch tinyint(1) NOT NULL default '0',
  showchatrooms tinyint(1) NOT NULL default '0',
  forsgonly tinyint(1) NOT NULL default '0',
  offset int(4) NOT NULL default '10',
  numberofstars int(4) NOT NULL default '4',
  latestmembers int(4) NOT NULL default '20',
  latestphotos int(4) NOT NULL default '20',
  numoftop int(4) NOT NULL default '10',
  thisyear int(4) NOT NULL default '2003',
  showonline tinyint(1) NOT NULL default '0',
  version varchar(4) NOT NULL default '2.1'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_forum_access`
#

DROP TABLE IF EXISTS nuke_forum_access;
CREATE TABLE nuke_forum_access (
  forum_id int(10) NOT NULL default '0',
  user_id int(10) NOT NULL default '0',
  can_post tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (forum_id,user_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_forum_mods`
#

DROP TABLE IF EXISTS nuke_forum_mods;
CREATE TABLE nuke_forum_mods (
  forum_id int(10) NOT NULL default '0',
  user_id int(10) NOT NULL default '0'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_forums`
#

DROP TABLE IF EXISTS nuke_forums;
CREATE TABLE nuke_forums (
  forum_id int(10) NOT NULL auto_increment,
  forum_name varchar(150) default NULL,
  forum_desc text,
  forum_access int(10) default '1',
  forum_moderator int(10) default NULL,
  forum_topics int(10) NOT NULL default '0',
  forum_posts int(10) NOT NULL default '0',
  forum_last_post_id int(10) NOT NULL default '0',
  cat_id int(10) default NULL,
  forum_type int(10) default '0',
  PRIMARY KEY  (forum_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_forumtopics`
#

DROP TABLE IF EXISTS nuke_forumtopics;
CREATE TABLE nuke_forumtopics (
  topic_id int(10) NOT NULL auto_increment,
  topic_title varchar(100) default NULL,
  topic_poster int(10) default NULL,
  topic_time varchar(20) default NULL,
  topic_views int(10) NOT NULL default '0',
  forum_id int(10) default NULL,
  topic_status int(10) NOT NULL default '0',
  topic_notify int(2) default '0',
  PRIMARY KEY  (topic_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_headlines`
#

DROP TABLE IF EXISTS nuke_headlines;
CREATE TABLE nuke_headlines (
  hid int(11) NOT NULL auto_increment,
  sitename varchar(30) NOT NULL default '',
  headlinesurl varchar(200) NOT NULL default '',
  PRIMARY KEY  (hid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_links_categories`
#

DROP TABLE IF EXISTS nuke_links_categories;
CREATE TABLE nuke_links_categories (
  cid int(11) NOT NULL auto_increment,
  title varchar(50) NOT NULL default '',
  cdescription text NOT NULL,
  parentid int(11) NOT NULL default '0',
  PRIMARY KEY  (cid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_links_editorials`
#

DROP TABLE IF EXISTS nuke_links_editorials;
CREATE TABLE nuke_links_editorials (
  linkid int(11) NOT NULL default '0',
  adminid varchar(60) NOT NULL default '',
  editorialtimestamp datetime NOT NULL default '0000-00-00 00:00:00',
  editorialtext text NOT NULL,
  editorialtitle varchar(100) NOT NULL default '',
  PRIMARY KEY  (linkid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_links_links`
#

DROP TABLE IF EXISTS nuke_links_links;
CREATE TABLE nuke_links_links (
  lid int(11) NOT NULL auto_increment,
  cid int(11) NOT NULL default '0',
  sid int(11) NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  url varchar(100) NOT NULL default '',
  description text NOT NULL,
  date datetime default NULL,
  name varchar(100) NOT NULL default '',
  email varchar(100) NOT NULL default '',
  hits int(11) NOT NULL default '0',
  submitter varchar(60) NOT NULL default '',
  linkratingsummary double(6,4) NOT NULL default '0.0000',
  totalvotes int(11) NOT NULL default '0',
  totalcomments int(11) NOT NULL default '0',
  PRIMARY KEY  (lid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_links_modrequest`
#

DROP TABLE IF EXISTS nuke_links_modrequest;
CREATE TABLE nuke_links_modrequest (
  requestid int(11) NOT NULL auto_increment,
  lid int(11) NOT NULL default '0',
  cid int(11) NOT NULL default '0',
  sid int(11) NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  url varchar(100) NOT NULL default '',
  description text NOT NULL,
  modifysubmitter varchar(60) NOT NULL default '',
  brokenlink int(3) NOT NULL default '0',
  PRIMARY KEY  (requestid),
  UNIQUE KEY requestid (requestid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_links_newlink`
#

DROP TABLE IF EXISTS nuke_links_newlink;
CREATE TABLE nuke_links_newlink (
  lid int(11) NOT NULL auto_increment,
  cid int(11) NOT NULL default '0',
  sid int(11) NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  url varchar(100) NOT NULL default '',
  description text NOT NULL,
  name varchar(100) NOT NULL default '',
  email varchar(100) NOT NULL default '',
  submitter varchar(60) NOT NULL default '',
  PRIMARY KEY  (lid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_links_votedata`
#

DROP TABLE IF EXISTS nuke_links_votedata;
CREATE TABLE nuke_links_votedata (
  ratingdbid int(11) NOT NULL auto_increment,
  ratinglid int(11) NOT NULL default '0',
  ratinguser varchar(60) NOT NULL default '',
  rating int(11) NOT NULL default '0',
  ratinghostname varchar(60) NOT NULL default '',
  ratingcomments text NOT NULL,
  ratingtimestamp datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (ratingdbid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_main`
#

DROP TABLE IF EXISTS nuke_main;
CREATE TABLE nuke_main (
  main_module varchar(255) NOT NULL default ''
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_market`
#

DROP TABLE IF EXISTS nuke_market;
CREATE TABLE nuke_market (
  id tinyint(4) NOT NULL auto_increment,
  TYPE tinyint(4) NOT NULL default '0',
  topic varchar(80) NOT NULL default '',
  province tinyint(2) NOT NULL default '0',
  cat int(2) NOT NULL default '0',
  email varchar(30) NOT NULL default '',
  oicq varchar(20) default NULL,
  tel varchar(20) NOT NULL default '0',
  location varchar(30) default NULL,
  description mediumtext,
  time date default NULL,
  expire varchar(20) NOT NULL default '',
  click int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_message`
#

DROP TABLE IF EXISTS nuke_message;
CREATE TABLE nuke_message (
  mid int(11) NOT NULL auto_increment,
  title varchar(100) NOT NULL default '',
  content text NOT NULL,
  date varchar(14) NOT NULL default '',
  expire int(7) NOT NULL default '0',
  active int(1) NOT NULL default '1',
  view int(1) NOT NULL default '1',
  mlanguage varchar(30) NOT NULL default '',
  PRIMARY KEY  (mid),
  UNIQUE KEY mid (mid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_modules`
#

DROP TABLE IF EXISTS nuke_modules;
CREATE TABLE nuke_modules (
  mid int(10) NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  custom_title varchar(255) NOT NULL default '',
  active int(1) NOT NULL default '0',
  view int(1) NOT NULL default '0',
  KEY mid (mid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_optimize_gain`
#

DROP TABLE IF EXISTS nuke_optimize_gain;
CREATE TABLE nuke_optimize_gain (
  gain decimal(10,3) default NULL
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_pages`
#

DROP TABLE IF EXISTS nuke_pages;
CREATE TABLE nuke_pages (
  pid int(10) NOT NULL auto_increment,
  cid int(10) NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  subtitle varchar(255) NOT NULL default '',
  active int(1) NOT NULL default '0',
  page_header text NOT NULL,
  text text NOT NULL,
  page_footer text NOT NULL,
  signature text NOT NULL,
  date datetime NOT NULL default '0000-00-00 00:00:00',
  counter int(10) NOT NULL default '0',
  clanguage varchar(30) NOT NULL default '',
  PRIMARY KEY  (pid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_pages_categories`
#

DROP TABLE IF EXISTS nuke_pages_categories;
CREATE TABLE nuke_pages_categories (
  cid int(10) NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  description text NOT NULL,
  PRIMARY KEY  (cid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_poll_check`
#

DROP TABLE IF EXISTS nuke_poll_check;
CREATE TABLE nuke_poll_check (
  ip varchar(20) NOT NULL default '',
  time varchar(14) NOT NULL default '',
  pollID int(10) NOT NULL default '0'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_poll_data`
#

DROP TABLE IF EXISTS nuke_poll_data;
CREATE TABLE nuke_poll_data (
  pollID int(11) NOT NULL default '0',
  optionText char(50) NOT NULL default '',
  optionCount int(11) NOT NULL default '0',
  voteID int(11) NOT NULL default '0'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_poll_desc`
#

DROP TABLE IF EXISTS nuke_poll_desc;
CREATE TABLE nuke_poll_desc (
  pollID int(11) NOT NULL auto_increment,
  pollTitle varchar(100) NOT NULL default '',
  timeStamp int(11) NOT NULL default '0',
  voters mediumint(9) NOT NULL default '0',
  planguage varchar(30) NOT NULL default '',
  artid int(10) NOT NULL default '0',
  PRIMARY KEY  (pollID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_pollcomments`
#

DROP TABLE IF EXISTS nuke_pollcomments;
CREATE TABLE nuke_pollcomments (
  tid int(11) NOT NULL auto_increment,
  pid int(11) default '0',
  pollID int(11) default '0',
  date datetime default NULL,
  name varchar(60) NOT NULL default '',
  email varchar(60) default NULL,
  url varchar(60) default NULL,
  host_name varchar(60) default NULL,
  subject varchar(60) NOT NULL default '',
  comment text NOT NULL,
  score tinyint(4) NOT NULL default '0',
  reason tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (tid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_posts`
#

DROP TABLE IF EXISTS nuke_posts;
CREATE TABLE nuke_posts (
  post_id int(10) NOT NULL auto_increment,
  image varchar(100) default NULL,
  topic_id int(10) NOT NULL default '0',
  forum_id int(10) NOT NULL default '0',
  poster_id int(10) default NULL,
  post_text text,
  post_time varchar(20) default NULL,
  poster_ip varchar(16) default NULL,
  PRIMARY KEY  (post_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_posts_text`
#

DROP TABLE IF EXISTS nuke_posts_text;
CREATE TABLE nuke_posts_text (
  post_id int(10) NOT NULL default '0',
  post_text text,
  PRIMARY KEY  (post_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_priv_msgs`
#

DROP TABLE IF EXISTS nuke_priv_msgs;
CREATE TABLE nuke_priv_msgs (
  msg_id int(10) NOT NULL auto_increment,
  msg_image varchar(100) default NULL,
  subject varchar(100) default NULL,
  from_userid int(10) NOT NULL default '0',
  to_userid int(10) NOT NULL default '0',
  msg_time varchar(20) default NULL,
  msg_text text,
  read_msg tinyint(10) NOT NULL default '0',
  PRIMARY KEY  (msg_id),
  KEY msg_id (msg_id),
  KEY to_userid (to_userid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_queue`
#

DROP TABLE IF EXISTS nuke_queue;
CREATE TABLE nuke_queue (
  qid smallint(5) unsigned NOT NULL auto_increment,
  uid mediumint(9) NOT NULL default '0',
  uname varchar(40) NOT NULL default '',
  subject varchar(100) NOT NULL default '',
  story text,
  storyext text NOT NULL,
  timestamp datetime NOT NULL default '0000-00-00 00:00:00',
  topic varchar(20) NOT NULL default '',
  alanguage varchar(30) NOT NULL default '',
  PRIMARY KEY  (qid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_quotes`
#

DROP TABLE IF EXISTS nuke_quotes;
CREATE TABLE nuke_quotes (
  qid int(10) unsigned NOT NULL auto_increment,
  quote text,
  PRIMARY KEY  (qid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_ranks`
#

DROP TABLE IF EXISTS nuke_ranks;
CREATE TABLE nuke_ranks (
  rank_id int(10) NOT NULL auto_increment,
  rank_title varchar(50) NOT NULL default '',
  rank_min int(10) NOT NULL default '0',
  rank_max int(10) NOT NULL default '0',
  rank_special int(2) default '0',
  rank_image varchar(255) default NULL,
  PRIMARY KEY  (rank_id),
  KEY rank_min (rank_min),
  KEY rank_max (rank_max)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_referer`
#

DROP TABLE IF EXISTS nuke_referer;
CREATE TABLE nuke_referer (
  rid int(11) NOT NULL auto_increment,
  url varchar(100) NOT NULL default '',
  PRIMARY KEY  (rid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_related`
#

DROP TABLE IF EXISTS nuke_related;
CREATE TABLE nuke_related (
  rid int(11) NOT NULL auto_increment,
  tid int(11) NOT NULL default '0',
  name varchar(30) NOT NULL default '',
  url varchar(200) NOT NULL default '',
  PRIMARY KEY  (rid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_reviews`
#

DROP TABLE IF EXISTS nuke_reviews;
CREATE TABLE nuke_reviews (
  id int(10) NOT NULL auto_increment,
  date date NOT NULL default '0000-00-00',
  title varchar(150) NOT NULL default '',
  text text NOT NULL,
  reviewer varchar(20) default NULL,
  email varchar(60) default NULL,
  score int(10) NOT NULL default '0',
  cover varchar(100) NOT NULL default '',
  url varchar(100) NOT NULL default '',
  url_title varchar(50) NOT NULL default '',
  hits int(10) NOT NULL default '0',
  rlanguage varchar(30) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_reviews_add`
#

DROP TABLE IF EXISTS nuke_reviews_add;
CREATE TABLE nuke_reviews_add (
  id int(10) NOT NULL auto_increment,
  date date default NULL,
  title varchar(150) NOT NULL default '',
  text text NOT NULL,
  reviewer varchar(20) NOT NULL default '',
  email varchar(60) default NULL,
  score int(10) NOT NULL default '0',
  url varchar(100) NOT NULL default '',
  url_title varchar(50) NOT NULL default '',
  rlanguage varchar(30) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_reviews_comments`
#

DROP TABLE IF EXISTS nuke_reviews_comments;
CREATE TABLE nuke_reviews_comments (
  cid int(10) NOT NULL auto_increment,
  rid int(10) NOT NULL default '0',
  userid varchar(25) NOT NULL default '',
  date datetime default NULL,
  comments text,
  score int(10) NOT NULL default '0',
  PRIMARY KEY  (cid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_reviews_main`
#

DROP TABLE IF EXISTS nuke_reviews_main;
CREATE TABLE nuke_reviews_main (
  title varchar(100) default NULL,
  description text
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_seccont`
#

DROP TABLE IF EXISTS nuke_seccont;
CREATE TABLE nuke_seccont (
  artid int(11) NOT NULL auto_increment,
  secid int(11) NOT NULL default '0',
  title text NOT NULL,
  content text NOT NULL,
  counter int(11) NOT NULL default '0',
  slanguage varchar(30) NOT NULL default '',
  PRIMARY KEY  (artid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_sections`
#

DROP TABLE IF EXISTS nuke_sections;
CREATE TABLE nuke_sections (
  secid int(11) NOT NULL auto_increment,
  secname varchar(40) NOT NULL default '',
  image varchar(50) NOT NULL default '',
  PRIMARY KEY  (secid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_session`
#

DROP TABLE IF EXISTS nuke_session;
CREATE TABLE nuke_session (
  username varchar(25) NOT NULL default '',
  time varchar(14) NOT NULL default '',
  host_addr varchar(48) NOT NULL default '',
  guest int(1) NOT NULL default '0'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_smiles`
#

DROP TABLE IF EXISTS nuke_smiles;
CREATE TABLE nuke_smiles (
  id int(10) NOT NULL auto_increment,
  code varchar(50) default NULL,
  smile_url varchar(100) default NULL,
  emotion varchar(75) default NULL,
  active tinyint(2) default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_stats_date`
#

DROP TABLE IF EXISTS nuke_stats_date;
CREATE TABLE nuke_stats_date (
  year smallint(6) NOT NULL default '0',
  month tinyint(4) NOT NULL default '0',
  date tinyint(4) NOT NULL default '0',
  hits bigint(20) NOT NULL default '0'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_stats_hour`
#

DROP TABLE IF EXISTS nuke_stats_hour;
CREATE TABLE nuke_stats_hour (
  year smallint(6) NOT NULL default '0',
  month tinyint(4) NOT NULL default '0',
  date tinyint(4) NOT NULL default '0',
  hour tinyint(4) NOT NULL default '0',
  hits int(11) NOT NULL default '0'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_stats_month`
#

DROP TABLE IF EXISTS nuke_stats_month;
CREATE TABLE nuke_stats_month (
  year smallint(6) NOT NULL default '0',
  month tinyint(4) NOT NULL default '0',
  hits bigint(20) NOT NULL default '0'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_stats_year`
#

DROP TABLE IF EXISTS nuke_stats_year;
CREATE TABLE nuke_stats_year (
  year smallint(6) NOT NULL default '0',
  hits bigint(20) NOT NULL default '0'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_stories`
#

DROP TABLE IF EXISTS nuke_stories;
CREATE TABLE nuke_stories (
  sid int(11) NOT NULL auto_increment,
  catid int(11) NOT NULL default '0',
  aid varchar(30) NOT NULL default '',
  title varchar(80) default NULL,
  time datetime default NULL,
  hometext text,
  bodytext text NOT NULL,
  comments int(11) default '0',
  counter mediumint(8) unsigned default NULL,
  topic int(3) NOT NULL default '1',
  informant varchar(20) NOT NULL default '',
  notes text NOT NULL,
  ihome int(1) NOT NULL default '0',
  alanguage varchar(30) NOT NULL default '',
  acomm int(1) NOT NULL default '0',
  haspoll int(1) NOT NULL default '0',
  pollID int(10) NOT NULL default '0',
  score int(10) NOT NULL default '0',
  ratings int(10) NOT NULL default '0',
  PRIMARY KEY  (sid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_stories_cat`
#

DROP TABLE IF EXISTS nuke_stories_cat;
CREATE TABLE nuke_stories_cat (
  catid int(11) NOT NULL auto_increment,
  title varchar(20) NOT NULL default '',
  counter int(11) NOT NULL default '0',
  PRIMARY KEY  (catid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_topics`
#

DROP TABLE IF EXISTS nuke_topics;
CREATE TABLE nuke_topics (
  topicid int(3) NOT NULL auto_increment,
  topicname varchar(20) default NULL,
  topicimage varchar(20) default NULL,
  topictext varchar(40) default NULL,
  counter int(11) NOT NULL default '0',
  PRIMARY KEY  (topicid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_user_friendslist`
#

DROP TABLE IF EXISTS nuke_user_friendslist;
CREATE TABLE nuke_user_friendslist (
  id int(11) NOT NULL auto_increment,
  ffusername varchar(30) NOT NULL default '',
  friendname varchar(30) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_user_photo`
#

DROP TABLE IF EXISTS nuke_user_photo;
CREATE TABLE nuke_user_photo (
  ID bigint(20) unsigned NOT NULL auto_increment,
  ffusername varchar(50) NOT NULL default '',
  approved tinyint(1) NOT NULL default '0',
  denied tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_user_profile1`
#

DROP TABLE IF EXISTS nuke_user_profile1;
CREATE TABLE nuke_user_profile1 (
  id bigint(20) NOT NULL auto_increment,
  ffusername varchar(50) NOT NULL default '',
  sex varchar(20) NOT NULL default '',
  birth date NOT NULL default '0000-00-00',
  degree varchar(20) NOT NULL default '',
  oicq varchar(50) NOT NULL default '',
  selfintro mediumtext,
  stapro varchar(50) NOT NULL default '',
  city varchar(50) NOT NULL default '',
  postcode varchar(50) NOT NULL default '',
  location varchar(100) NOT NULL default '',
  object varchar(100) NOT NULL default '',
  method varchar(50) NOT NULL default '',
  other mediumtext,
  photo tinyint(4) NOT NULL default '0',
  keyword varchar(50) NOT NULL default '',
  time varchar(20) NOT NULL default '',
  click bigint(20) NOT NULL default '0',
  song varchar(50) NOT NULL default '',
  film varchar(50) NOT NULL default '',
  marriage varchar(10) NOT NULL default '',
  tel varchar(50) NOT NULL default '',
  approved tinyint(1) NOT NULL default '0',
  country varchar(30) NOT NULL default '',
  user_occ tinyint(1) NOT NULL default '1',
  havechild tinyint(1) NOT NULL default '1',
  wantchild tinyint(1) NOT NULL default '1',
  drink tinyint(1) NOT NULL default '1',
  smoke tinyint(1) NOT NULL default '1',
  race tinyint(1) NOT NULL default '1',
  denied tinyint(1) NOT NULL default '0',
  ip varchar(30) NOT NULL default '',
  photopath varchar(30) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_user_profile2`
#

DROP TABLE IF EXISTS nuke_user_profile2;
CREATE TABLE nuke_user_profile2 (
  id bigint(20) NOT NULL auto_increment,
  ffusername varchar(30) NOT NULL default '',
  uid int(20) NOT NULL default '0',
  height varchar(10) NOT NULL default '',
  weight varchar(10) NOT NULL default '',
  langspeaks varchar(50) NOT NULL default '',
  dislike varchar(50) NOT NULL default '',
  myfbooks varchar(50) NOT NULL default '',
  myfcolor varchar(50) NOT NULL default '',
  mymostlikeman varchar(50) NOT NULL default '',
  mymostlikeplace varchar(50) NOT NULL default '',
  haircolor varchar(5) NOT NULL default '',
  hairstyle varchar(5) NOT NULL default '',
  facialhair varchar(5) NOT NULL default '',
  eyecolor varchar(5) NOT NULL default '',
  eyewear varchar(5) NOT NULL default '',
  bodytype int(2) NOT NULL default '0',
  favoriteitem varchar(5) NOT NULL default '',
  disabilities varchar(5) NOT NULL default '',
  healthstatus varchar(5) NOT NULL default '',
  religion varchar(5) NOT NULL default '',
  money bigint(10) NOT NULL default '50',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_users`
#

DROP TABLE IF EXISTS nuke_users;
CREATE TABLE nuke_users (
  uid int(11) NOT NULL auto_increment,
  name varchar(60) NOT NULL default '',
  uname varchar(25) NOT NULL default '',
  email varchar(255) NOT NULL default '',
  femail varchar(255) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  user_avatar varchar(30) default NULL,
  user_regdate varchar(20) NOT NULL default '',
  user_icq varchar(15) default NULL,
  user_occ varchar(100) default NULL,
  user_from varchar(100) default NULL,
  user_intrest varchar(150) default NULL,
  user_sig varchar(255) default NULL,
  user_viewemail tinyint(2) default NULL,
  user_theme int(3) default NULL,
  user_aim varchar(18) default NULL,
  user_yim varchar(25) default NULL,
  user_msnm varchar(25) default NULL,
  pass varchar(40) NOT NULL default '',
  storynum tinyint(4) NOT NULL default '10',
  umode varchar(10) NOT NULL default '',
  uorder tinyint(1) NOT NULL default '0',
  thold tinyint(1) NOT NULL default '0',
  noscore tinyint(1) NOT NULL default '0',
  bio tinytext NOT NULL,
  ublockon tinyint(1) NOT NULL default '0',
  ublock tinytext NOT NULL,
  theme varchar(255) NOT NULL default '',
  commentmax int(11) NOT NULL default '4096',
  counter int(11) NOT NULL default '0',
  newsletter int(1) NOT NULL default '0',
  user_posts int(10) NOT NULL default '0',
  user_attachsig int(2) NOT NULL default '0',
  user_rank int(10) NOT NULL default '0',
  user_level int(10) NOT NULL default '1',
  PRIMARY KEY  (uid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# ݱĽṹ `nuke_words`
#

DROP TABLE IF EXISTS nuke_words;
CREATE TABLE nuke_words (
  word_id int(10) NOT NULL auto_increment,
  word varchar(100) default NULL,
  replacement varchar(100) default NULL,
  PRIMARY KEY  (word_id)
) TYPE=MyISAM;

    
