【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,--install.sql,希望对大家有所帮助!
CREATE TABLE `nucleus_actionlog` (
`timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`message` varchar(255) NOT NULL default ''
) TYPE=MyISAM;
CREATE TABLE `nucleus_activation` (
`vkey` varchar(40) NOT NULL default '',
`vtime` datetime NOT NULL default '0000-00-00 00:00:00',
`vmember` int(11) NOT NULL default '0',
`vtype` varchar(15) NOT NULL default '',
`vextra` varchar(128) NOT NULL default '',
PRIMARY KEY (`vkey`)
) TYPE=MyISAM;
CREATE TABLE `nucleus_ban` (
`iprange` varchar(15) NOT NULL default '',
`reason` varchar(255) NOT NULL default '',
`blogid` int(11) NOT NULL default '0'
) TYPE=MyISAM;
CREATE TABLE `nucleus_blog` (
`bnumber` int(11) NOT NULL auto_increment,
`bname` varchar(60) NOT NULL default '',
`bshortname` varchar(15) NOT NULL default '',
`bdesc` varchar(200) default NULL,
`bcomments` tinyint(2) NOT NULL default '1',
`bmaxcomments` int(11) NOT NULL default '0',
`btimeoffset` decimal(3,1) NOT NULL default '0.0',
`bnotify` varchar(60) default NULL,
`burl` varchar(100) default NULL,
`bupdate` varchar(60) default NULL,
`bdefskin` int(11) NOT NULL default '1',
`bpublic` tinyint(2) NOT NULL default '1',
`bsendping` tinyint(2) NOT NULL default '0',
`bconvertbreaks` tinyint(2) NOT NULL default '1',
`bdefcat` int(11) default NULL,
`bnotifytype` int(11) NOT NULL default '15',
`ballowpast` tinyint(2) NOT NULL default '0',
`bincludesearch` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`bnumber`),
UNIQUE KEY `bnumber` (`bnumber`),
UNIQUE KEY `bshortname` (`bshortname`)
) TYPE=MyISAM;
INSERT INTO `nucleus_blog` VALUES (1, 'My Nucleus CMS', 'mynucleuscms', '', 1, 0, 0.0, '', 'ment` (
`cnumber` int(11) NOT NULL auto_increment,
`cbody` text NOT NULL,
`cuser` varchar(40) default NULL,
`cmail` varchar(100) default NULL,
`cmember` int(11) default NULL,
`citem` int(11) NOT NULL default '0',
`ctime` datetime NOT NULL default '0000-00-00 00:00:00',
`chost` varchar(60) default NULL,
`cip` varchar(15) NOT NULL default '',
`cblog` int(11) NOT NULL default '0',
PRIMARY KEY (`cnumber`),
UNIQUE KEY `cnumber` (`cnumber`),
KEY `citem` (`citem`),
FULLTEXT KEY `cbody` (`cbody`)
) TYPE=MyISAM;
CREATE TABLE `nucleus_config` (
`name` varchar(20) NOT NULL default '',
`value` varchar(128) default NULL,
PRIMARY KEY (`name`)
) TYPE=MyISAM;
INSERT INTO `nucleus_config` VALUES ('DefaultBlog', '1');
INSERT INTO `nucleus_config` VALUES ('AdminEmail', 'example@example.org');
INSERT INTO `nucleus_config` VALUES ('IndexURL', 'http://localhost:8080/nucleus/');
INSERT INTO `nucleus_config` VALUES ('Language', 'english');
INSERT INTO `nucleus_config` VALUES ('SessionCookie', '');
INSERT INTO `nucleus_config` VALUES ('AllowMemberCreate', '');
INSERT INTO `nucleus_config` VALUES ('AllowMemberMail', '1');
INSERT INTO `nucleus_config` VALUES ('SiteName', 'My Nucleus CMS');
INSERT INTO `nucleus_config` VALUES ('AdminURL', 'http://localhost:8080/nucleus/nucleus/');
INSERT INTO `nucleus_config` VALUES ('NewMemberCanLogon', '1');
INSERT INTO `nucleus_config` VALUES ('DisableSite', '');
INSERT INTO `nucleus_config` VALUES ('DisableSiteURL', 'http://www.this-page-intentionally-left-blank.org/');
INSERT INTO `nucleus_config` VALUES ('LastVisit', '');
INSERT INTO `nucleus_config` VALUES ('MediaURL', 'http://localhost:8080/nucleus/media/');
INSERT INTO `nucleus_config` VALUES ('AllowedTypes', 'jpg,jpeg,gif,mpg,
mpeg,avi,mov,mp3,swf,png');
INSERT INTO `nucleus_config` VALUES ('AllowLoginEdit', '');
INSERT INTO `nucleus_config` VALUES ('AllowUpload', '1');
INSERT INTO `nucleus_config` VALUES ('DisableJsTools', '2');
INSERT INTO `nucleus_config` VALUES ('CookiePath', '/');
INSERT INTO `nucleus_config` VALUES ('CookieDomain', '');
INSERT INTO `nucleus_config` VALUES ('CookieSecure', '');
INSERT INTO `nucleus_config` VALUES ('CookiePrefix', '');
INSERT INTO `nucleus_config` VALUES ('MediaPrefix', '1');
INSERT INTO `nucleus_config` VALUES ('MaxUploadSize', '1048576');
INSERT INTO `nucleus_config` VALUES ('NonmemberMail', '');
INSERT INTO `nucleus_config` VALUES ('PluginURL', 'http://localhost:8080/nucleus/nucleus/plugins/');
INSERT INTO `nucleus_config` VALUES ('ProtectMemNames', '1');
INSERT INTO `nucleus_config` VALUES ('BaseSkin', '5');
INSERT INTO `nucleus_config` VALUES ('SkinsURL', 'http://localhost:8080/nucleus/skins/');
INSERT IN