table.sql

AntiSlaed是一款来自于俄罗斯的免费网站内容管理系统(CMS)。

  PRIMARY KEY (`mid`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_modules` (
  `mid` int(11) NOT NULL auto_increment,
  `title` varchar(50) NOT NULL default '',
  `custom_title` varchar(50) NOT NULL default '',
  `active` int(1) NOT NULL default '0',
  `view` int(1) NOT NULL default '0',
  `inmenu` tinyint(1) NOT NULL default '1',
  `mod_group` int(10) default '0',
  `blocks` int(1) NOT NULL default '0',
  `blocks_c` int(1) NOT NULL default '0',
  PRIMARY KEY (`mid`),
  KEY `title` (`title`),
  KEY `custom_title` (`custom_title`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_page` (
  `pid` int(11) NOT NULL auto_increment,
  `catid` int(11) NOT NULL default '0',
  `uid` int(11) NOT NULL default '0',
  `name` varchar(25) NOT NULL default '',
  `title` varbinary(100) default NULL,
  `time` datetime default NULL,
  `hometext` text,
  `bodytext` mediumtext NOT NULL,
  `comments` int(11) NOT NULL default '0',
  `counter` int(11) NOT NULL default '0',
  `acomm` int(1) NOT NULL default '0',
  `score` int(11) NOT NULL default '0',
  `ratings` int(11) NOT NULL default '0',
  `ip_sender` varchar(60) default NULL,
  `status` int(1) NOT NULL default '0',
  PRIMARY KEY (`pid`),
  KEY `catid` (`catid`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_referer` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `uid` int(11) NOT NULL,
  `name` varchar(25) NOT NULL,
  `ip` varchar(15) NOT NULL default '',
  `referer` varchar(255) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `lid` int(11) NOT NULL default '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_session` (
  `uname` 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',
  `module` varchar(255) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  PRIMARY KEY (`time`),
  KEY `guest` (`guest`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_stories` (
  `sid` int(11) NOT NULL auto_increment,
  `catid` int(11) NOT NULL default '0',
  `uid` int(11) NOT NULL default '0',
  `name` varchar(25) NOT NULL default '',
  `title` varbinary(100) default NULL,
  `time` datetime default NULL,
  `hometext` text,
  `bodytext` text NOT NULL,
  `field` text NOT NULL,
  `comments` int(11) default '0',
  `counter` int(11) NOT NULL default '0',
  `ihome` int(1) NOT NULL default '0',
  `acomm` int(1) NOT NULL default '0',
  `score` int(11) NOT NULL default '0',
  `ratings` int(11) NOT NULL default '0',
  `associated` text NOT NULL,
  `ip_sender` varchar(60) default NULL,
  `status` int(1) NOT NULL default '0',
  PRIMARY KEY (`sid`),
  KEY `catid` (`catid`),
  KEY `counter` (`counter`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_survey` (
  `poll_id` int(11) NOT NULL auto_increment,
  `poll_date` datetime default NULL,
  `poll_title` varchar(255) NOT NULL default '',
  `poll_questions` text NOT NULL,
  `poll_answer_1` int(11) NOT NULL default '0',
  `poll_answer_2` int(11) NOT NULL default '0',
  `poll_answer_3` int(11) NOT NULL default '0',
  `poll_answer_4` int(11) NOT NULL default '0',
  `poll_answer_5` int(11) NOT NULL default '0',
  `poll_answer_6` int(11) NOT NULL default '0',
  `poll_answer_7` int(11) NOT NULL default '0',
  `poll_answer_8` int(11) NOT NULL default '0',
  `poll_answer_9` int(11) NOT NULL default '0',
  `poll_answer_10` int(11) NOT NULL default '0',
  `poll_answer_11` int(11) NOT NULL default '0',
  `poll_answer_12` int(11) NOT NULL default '0',
  `pool_vote` int(11) NOT NULL default '0',
  `pool_comments` int(11) NOT NULL default '0',
  `planguage` varchar(30) NOT NULL default '',
  `acomm` int(1) NOT NULL default '0',
  PRIMARY KEY (`poll_id`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_clients` (
  `client_id` int(11) NOT NULL auto_increment,
  `client_id_user` int(11) NOT NULL default '0',
  `client_id_product` int(11) NOT NULL default '0',
  `client_id_partner` int(11) NOT NULL default '0',
  `client_partner_proz` int(3) NOT NULL default '0',
  `client_name` varchar(255) NOT NULL default '',
  `client_adres` varchar(255) NOT NULL default '',
  `client_phone` varchar(255) NOT NULL default '',
  `client_email` varchar(255) NOT NULL default '',
  `client_website` varchar(255) NOT NULL default '',
  `client_regdate` int(10) NOT NULL default '0',
  `client_enddate` int(10) NOT NULL default '0',
  `client_key` varchar(20) NOT NULL default '',
  `client_active` tinyint(1) NULL default '0',
  PRIMARY KEY (`client_id`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_products` (
  `product_id` int(11) NOT NULL auto_increment,
  `product_cid` int(11) NOT NULL default '0',
  `product_time` datetime default NULL,
  `product_title` varbinary(100) default NULL,
  `product_text` text NOT NULL,
  `product_desc` text NOT NULL,
  `product_preis` int(11) NOT NULL default '0',
  `product_assoc` text NOT NULL,
  `product_com` int(11) NOT NULL default '0',
  `product_count` int(11) NOT NULL default '0',
  `product_votes` int(11) NOT NULL default '0',
  `product_totalvotes` int(11) NOT NULL default '0',
  `product_active` tinyint(1) NULL default '0',
  PRIMARY KEY (`product_id`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_partners` (
  `partner_id` int(11) NOT NULL auto_increment,
  `partner_id_user` int(11) NOT NULL default '0',
  `partner_name` varchar(255) NOT NULL default '',
  `partner_adres` varchar(255) NOT NULL default '',
  `partner_phone` varchar(255) NOT NULL default '',
  `partner_email` varchar(255) NOT NULL default '',
  `partner_website` varchar(255) NOT NULL default '',
  `partner_webmoney` varchar(255) NOT NULL default '',
  `partner_paypal` varchar(255) NOT NULL default '',
  `partner_regdate` int(10) NOT NULL default '0',
  `partner_rest` int(10) NOT NULL default '0',
  `partner_bek` int(10) NOT NULL default '0',
  `partner_active` tinyint(1) NULL default '0',
  PRIMARY KEY (`partner_id`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_newsletter` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(50) NOT NULL,
  `content` text,
  `mails` mediumtext,
  `send` int(10) NOT NULL default '0',
  `time` datetime default NULL,
  `endtime` datetime default NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_rating` (
  `id` int(11) NOT NULL auto_increment,
  `mid` int(11) NOT NULL default '0',
  `modul` varchar(50) NOT NULL default '',
  `time` varchar(14) NOT NULL default '',
  `uid` int(11) NOT NULL default '0',
  `host` varchar(60) default NULL,
  PRIMARY KEY (`id`),
  KEY `mid` (`mid`),
  KEY `modul` (`modul`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_order` (
  `id` int(11) NOT NULL auto_increment,
  `mail` varchar(255) NOT NULL default '',
  `info` text NOT NULL,
  `com` text NOT NULL,
  `ip` varchar(255) NOT NULL default '',
  `agent` varchar(255) NOT NULL default '',
  `date` datetime default NULL,
  `status` int(1) NOT NULL default '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_users` (
  `user_id` int(11) NOT NULL auto_increment,
  `user_name` varbinary(25) NOT NULL default '',
  `user_email` varchar(255) NOT NULL default '',
  `user_website` varchar(255) NOT NULL default '',
  `user_avatar` varchar(255) NOT NULL default '',
  `user_regdate` datetime NOT NULL,
  `user_icq` varchar(15) default NULL,
  `user_occ` varchar(100) default NULL,
  `user_from` varchar(100) default NULL,
  `user_interests` varchar(150) NOT NULL default '',
  `user_sig` varchar(255) default NULL,
  `user_viewemail` tinyint(1) default NULL,  
  `user_aim` varchar(18) default NULL,
  `user_yim` varchar(25) default NULL,
  `user_msnm` varchar(25) default NULL,
  `user_password` varchar(40) NOT NULL default '',
  `user_storynum` tinyint(4) NOT NULL default '10',
  `user_blockon` tinyint(1) NOT NULL default '0',
  `user_block` tinytext NOT NULL,
  `user_theme` varchar(255) NOT NULL default '',  
  `user_newsletter` int(1) NOT NULL default '0',
  `user_lastvisit` datetime NOT NULL,
  `user_lang` varchar(255) NOT NULL default 'russian',  
  `user_points` int(10) default '0',
  `user_last_ip` varchar(15) NOT NULL default '0',
  `user_warnings` int(5) NOT NULL default '0',
  `user_group` int(1) NOT NULL default '0',
  `user_birthday` date default NULL,
  `user_gender` int(1) NOT NULL default '0',
  `user_votes` int(11) NOT NULL default '0',
  `user_totalvotes` int(11) NOT NULL default '0',
  `user_field` text NOT NULL,
  `user_agent` varchar(255) NOT NULL default '',
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_users_temp` (
  `user_id` int(10) NOT NULL auto_increment,
  `user_name` varchar(25) NOT NULL default '',
  `user_email` varchar(255) NOT NULL default '',
  `user_password` varchar(40) NOT NULL default '',
  `user_regdate` datetime NOT NULL,
  `check_num` varchar(50) NOT NULL default '',
  `time` varchar(14) NOT NULL default '',
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM;