📄 table.sql

📁 AntiSlaed是一款来自于俄罗斯的免费网站内容管理系统(CMS)。
💻 SQL
📖 第 1 页 / 共 2 页
字号:
12 下一页
CREATE TABLE `{pref}_admins` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(25) NOT NULL default '',
  `title` varchar(50) default NULL,
  `url` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `pwd` varchar(40) default NULL,
  `super` tinyint(1) default NULL,
  `editor` tinyint(1) default NULL,
  `smail` tinyint(1) default NULL,
  `modules` varchar(255) NOT NULL default '',
  `lang` varchar(30) NOT NULL default '',
  `ip` varchar(15) default NULL,
  `regdate` datetime NOT NULL,
  `lastvisit` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_auto_links` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `sitename` varchar(100) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `link` varchar(100) NOT NULL default '',
  `mail` varchar(100) NOT NULL default '',
  `hits` int(11) NOT NULL default '0',
  `outs` int(11) NOT NULL default '0',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_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 '',
  `bposition` 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',
  `expire` varchar(14) NOT NULL default '0',
  `action` char(1) NOT NULL default '',
  `which` text NOT NULL,
  PRIMARY KEY (`bid`),
  KEY `title` (`title`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_categories` (
  `id` int(11) NOT NULL auto_increment,
  `modul` varchar(50) NOT NULL default '',
  `title` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `img` varchar(100) NOT NULL default '',
  `language` varchar(30) NOT NULL default '',
  `parentid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `modul` (`modul`),
  KEY `parentid` (`parentid`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_comment` (
  `id` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `modul` varchar(60) NOT NULL default '',
  `date` datetime default NULL,
  `uid` int(11) NOT NULL default '0',
  `name` varchar(25) NOT NULL default '',
  `host_name` varchar(60) default NULL,
  `comment` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cid` (`cid`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_content` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(100) default NULL,
  `text` mediumtext NOT NULL,
  `field` text NOT NULL,
  `url` varchar(200) NOT NULL default '',
  `time` datetime default NULL,
  `refresh` int(10) NOT NULL default '0',
  `counter` int(11) NOT NULL default '0',
  PRIMARY KEY (`id`),
  KEY `counter` (`counter`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_faq` (
  `fid` 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,
  `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 (`fid`),
  KEY `catid` (`catid`),
  KEY `counter` (`counter`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_files` (
  `lid` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `uid` int(11) NOT NULL default '0',
  `name` varchar(25) NOT NULL default '',
  `title` varbinary(100) NOT NULL default '',
  `description` text NOT NULL,
  `bodytext` text NOT NULL,
  `url` varchar(100) NOT NULL default '',
  `date` datetime default NULL,
  `filesize` int(11) NOT NULL default '0',
  `version` varchar(10) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `homepage` varchar(200) NOT NULL default '',
  `ip_sender` varchar(60) default NULL,
  `votes` int(11) NOT NULL default '0',
  `totalvotes` int(11) NOT NULL default '0',
  `totalcomments` int(11) NOT NULL default '0',
  `hits` int(11) NOT NULL default '0',
  `status` int(1) NOT NULL default '0',
  PRIMARY KEY (`lid`),
  KEY `cid` (`cid`),
  KEY `title` (`title`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_groups` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `points` int(10) NOT NULL default '0',
  `extra` int(1) NOT NULL default '0',
  `rank` varchar(255) NOT NULL default '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_help` (
  `sid` int(11) NOT NULL auto_increment,
  `pid` int(11) NOT NULL default '0',
  `catid` int(11) NOT NULL default '0',
  `uid` int(11) NOT NULL default '0',
  `aid` int(11) NOT NULL default '0',
  `title` varbinary(100) default NULL,
  `time` datetime default NULL,
  `hometext` text,
  `field` text NOT NULL,
  `comments` int(11) default '0',
  `counter` int(11) NOT NULL default '0',
  `ip_sender` varchar(60) default NULL,
  `status` int(1) NOT NULL default '0',
  PRIMARY KEY (`sid`),
  KEY `pid` (`pid`),
  KEY `catid` (`catid`),
  KEY `counter` (`counter`)
) TYPE=MyISAM;

CREATE TABLE `{pref}_jokes` (
  `jokeid` int(11) NOT NULL auto_increment,
  `uid` int(11) NOT NULL default '0',
  `name` varchar(25) NOT NULL default '',
  `date` datetime default NULL,
  `title` varchar(100) NOT NULL default '',
  `cat` int(11) NOT NULL default '0',
  `joke` text NOT NULL,
  `rating` varchar(100) NOT NULL default '0',
  `ratingtot` varchar(100) NOT NULL default '0',
  `ip_sender` varchar(60) default NULL,
  `status` int(1) NOT NULL default '0',
  PRIMARY KEY (`jokeid`),
  KEY `cat` (`cat`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_links` (
  `lid` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `uid` int(11) NOT NULL default '0',
  `name` varchar(25) NOT NULL default '',
  `title` varbinary(100) NOT NULL default '',
  `description` text NOT NULL,
  `bodytext` text NOT NULL,
  `url` varchar(100) NOT NULL default '',
  `date` datetime default NULL,
  `email` varchar(100) NOT NULL default '',
  `ip_sender` varchar(60) default NULL,
  `votes` int(11) NOT NULL default '0',
  `totalvotes` int(11) NOT NULL default '0',
  `totalcomments` int(11) NOT NULL default '0',
  `hits` int(11) NOT NULL default '0',
  `status` int(1) NOT NULL default '0',
  PRIMARY KEY (`lid`),
  KEY `cid` (`cid`),
  KEY `title` (`title`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_media` (
  `id` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `uid` int(11) NOT NULL default '0',
  `name` varchar(25) NOT NULL default '',
  `title` varbinary(100) NOT NULL default '',
  `subtitle` varbinary(100) NOT NULL default '',
  `year` int(11) NOT NULL default '0',
  `director` varchar(100) NOT NULL default '',
  `roles` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `createdby` varchar(100) NOT NULL default '',
  `duration` varchar(100) NOT NULL default '',
  `lang` varchar(100) NOT NULL default '',
  `note` text NOT NULL,
  `format` varchar(100) NOT NULL default '',
  `quality` varchar(100) NOT NULL default '',
  `size` varchar(100) NOT NULL default '',
  `released` varchar(100) NOT NULL default '',
  `links` text NOT NULL,
  `date` datetime default NULL,
  `votes` int(11) NOT NULL default '0',
  `totalvotes` int(11) NOT NULL default '0',
  `totalcom` int(11) NOT NULL default '0',
  `hits` int(11) NOT NULL default '0',
  `ip_sender` varchar(60) default NULL,
  `status` int(1) NOT NULL default '0',
  PRIMARY KEY (`id`),
  KEY `cid` (`cid`),
  KEY `title` (`title`)
) ENGINE=MyISAM;

CREATE TABLE `{pref}_message` (
  `mid` int(11) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  `content` text NOT NULL,
  `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 '',
12 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -