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',
KEY `iprange` (`iprange`),
KEY `blogid` (`blogid`)
) 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',
`breqemail` tinyint(2) NOT NULL default '0',
`bfuturepost` 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, '', 'http://localhost:8080/nucleus/', '', 5, 1, 0, 1, 1, 1, 1, 0, 0, 0);
CREATE TABLE `nucleus_category` (
`catid` int(11) NOT NULL auto_increment,
`cblog` int(11) NOT NULL default '0',
`cname` varchar(200) default NULL,
`cdesc` varchar(200) default NULL,
PRIMARY KEY (`catid`)
) TYPE=MyISAM;
INSERT INTO `nucleus_category` VALUES (1, 1, 'General', 'Items that do not fit in other categories');
CREATE TABLE `nucleus_comment` (
`cnumber` int(11) NOT NULL auto_increment,
`cbody` text NOT NULL,
`cuser` varchar(40) default NULL,
`cmail` varchar(100) default NULL,
`cemail` varchar(100),
`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', 'japanese-utf8');
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 INTO `nucleus_config` VALUES ('ActionURL', 'http://localhost:8080/nucleus/action.php');
INSERT INTO `nucleus_config` VALUES ('URLMode', 'normal');
INSERT INTO `nucleus_config` VALUES ('DatabaseVersion', '340');
INSERT INTO `nucleus_config` VALUES ('DebugVars', '0');
INSERT INTO `nucleus_config` VALUES ('DefaultListSize', '10');
CREATE TABLE `nucleus_item` (
`inumber` int(11) NOT NULL auto_increment,
`ititle` varchar(160) default NULL,
`ibody` text NOT NULL,
`imore` text,
`iblog` int(11) NOT NULL default '0',
`iauthor` int(11) NOT NULL default '0',
`itime` datetime NOT NULL default '0000-00-00 00:00:00',
`iclosed` tinyint(2) NOT NULL default '0',
`idraft` tinyint(2) NOT NULL default '0',
`ikarmapos` int(11) NOT NULL default '0',
`icat` int(11) default NULL,
`ikarmaneg` int(11) NOT NULL default '0',
`iposted` tinyint(2) NOT NULL default '1',
PRIMARY KEY (`inumber`),
-- UNIQUE KEY `inumber` (`inumber`),
KEY `itime` (`itime`),
FULLTEXT KEY `ibody` (`ibody`, `ititle`, `imore`)
) TYPE=MyISAM PACK_KEYS=0;
CREATE TABLE `nucleus_karma` (
`itemid` int(11) NOT NULL default '0',
`ip` char(15) NOT NULL default '',
KEY `itemid` (`itemid`)
) TYPE=MyISAM;
CREATE TABLE `nucleus_member` (
`mnumber` int(11) NOT NULL auto_increment,
`mname` varchar(16) NOT NULL default '',
`mrealname` varchar(60) default NULL,
`mpassword` varchar(40) NOT NULL default '',
`memail` varchar(60) default NULL,
`murl` varchar(100) default NULL,
`mnotes` varchar(100) default NULL,
`madmin` tinyint(2) NOT NULL default '0',
`mcanlogin` tinyint(2) NOT NULL default '1',
`mcookiekey` varchar(40) default NULL,
`deflang` varchar(20) NOT NULL default '',
`mautosave` tinyint(2) NOT NULL default '1',
PRIMARY KEY (`mnumber`),
-- UNIQUE KEY `mnumber` (`mnumber`),
UNIQUE KEY `mname` (`mname`)
) TYPE=MyISAM;
INSERT INTO `nucleus_member` VALUES (1, 'example', 'example', '1a79a4d60de6718e8e5b326e338ae533', 'example@example.org', 'http://localhost:8080/nucleus/', '', 1, 1, 'd767aefc60415859570d64c649257f19', '', 1);
CREATE TABLE `nucleus_plugin` (
`pid` int(11) NOT NULL auto_increment,
`pfile` varchar(40) NOT NULL default '',
`porder` int(11) NOT NULL default '0',
PRIMARY KEY (`pid`),
-- KEY `pid` (`pid`),
KEY `porder` (`porder`)
) TYPE=MyISAM;
CREATE TABLE `nucleus_plugin_event` (
`pid` int(11) NOT NULL default '0',
`event` varchar(40) default NULL,
KEY `pid` (`pid`)
) TYPE=MyISAM;
CREATE TABLE `nucleus_plugin_option` (
`ovalue` text NOT NULL,
`oid` int(11) NOT NULL auto_increment,
`ocontextid` int(11) NOT NULL default '0',
PRIMARY KEY (`oid`, `ocontextid`)
) TYPE=MyISAM;
CREATE TABLE `nucleus_plugin_option_desc` (
`oid` int(11) NOT NULL auto_increment,
`opid` int(11) NOT NULL default '0',
`oname` varchar(20) NOT NULL default '',
`ocontext` varchar(20) NOT NULL default '',
`odesc` varchar(255) default NULL,
`otype` varchar(20) default NULL,
`odef` text,
`oextra` text,
PRIMARY KEY (`opid`, `oname`, `ocontext`),
UNIQUE KEY `oid` (`oid`)
) TYPE=MyISAM;
CREATE TABLE `nucleus_skin` (
`sdesc` int(11) NOT NULL default '0',
`stype` varchar(20) NOT NULL default '',
`scontent` text NOT NULL,
PRIMARY KEY (`sdesc`,`stype`)
) TYPE=MyISAM;
INSERT INTO `nucleus_skin` VALUES (2, 'index', '\n\n\n <%blogsetting(name)%>\n <%blogsetting(desc)%>\n <%blogsetting(url)%>:<%blogsetting(id)%>\n\n \n \n <%version%>\n <%blog(feeds/atom/modified,1)%>\n\n <%blog(feeds/atom/entries,10)%>\n');
INSERT INTO `nucleus_skin` VALUES (4, 'index', '\r\n\r\n \r\n <%version%>\r\n http://nucleuscms.org/\r\n <%sitevar(url)%>\r\n \r\n \r\n http://nucleuscms.org/documentation/devdocs/xmlrpc.html\r\n \r\n \r\n http://nucleuscms.org/documentation/devdocs/xmlrpc.html\r\n \r\n \r\n \r\n');
INSERT INTO `nucleus_skin` VALUES (3, 'index', '\r\n\r\n \r\n <%blogsetting(name)%>\r\n <%blogsetting(url)%>\r\n <%blogsetting(desc)%>\r\n ja\r\n <%version%>\r\n ©\r\n Weblog\r\n http://backend.userland.com/rss\r\n \r\n <%adminurl%>nucleus2.gif\r\n <%blogsetting(name)%>\r\n <%blogsetting(url)%>\r\n \r\n <%blog(feeds/rss20,10)%>\r\n \r\n');
CREATE TABLE `nucleus_skin_desc` (
`sdnumber` int(11) NOT NULL auto_increment,
`sdname` varchar(20) NOT NULL default '',
`sddesc` varchar(200) default NULL,
`sdtype` varchar(40) NOT NULL default 'text/html',
`sdincmode` varchar(10) NOT NULL default 'normal',
`sdincpref` varchar(50) NOT NULL default '',
PRIMARY KEY (`sdnumber`),
-- UNIQUE KEY `sdnumber` (`sdnumber`),
UNIQUE KEY `sdname` (`sdname`)
) TYPE=MyISAM;
INSERT INTO `nucleus_skin_desc` VALUES (2, 'feeds/atom', 'Atom 1.0 weblog syndication', 'application/atom+xml', 'normal', '');
INSERT INTO `nucleus_skin_desc` VALUES (3, 'feeds/rss20', 'RSS 2.0 syndication of weblogs', 'text/xml', 'normal', '');
INSERT INTO `nucleus_skin_desc` VALUES (4, 'xml/rsd', 'RSD (Really Simple Discovery) information for weblog clients', 'text/xml', 'normal', '');
INSERT INTO `nucleus_skin_desc` VALUES (5, 'default', 'Nucleus CMS default skin', 'text/html', 'skindir', 'default/');
CREATE TABLE `nucleus_team` (
`tmember` int(11) NOT NULL default '0',
`tblog` int(11) NOT NULL default '0',
`tadmin` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`tmember`, `tblog`)
) TYPE=MyISAM;
INSERT INTO `nucleus_team` VALUES (1, 1, 1);
CREATE TABLE `nucleus_template` (
`tdesc` int(11) NOT NULL default '0',
`tpartname` varchar(64) NOT NULL default '',
`tcontent` text NOT NULL,
PRIMARY KEY (`tdesc`, `tpartname`)
) TYPE=MyISAM;
INSERT INTO `nucleus_template` VALUES (3, 'ITEM', '- \r\n <%title(xml)%>\r\n <%blogurl%>?itemid=<%itemid%>\r\n<%more%>]]>\r\n <%category%>\r\n<%blogurl%>?itemid=<%itemid%>\r\n <%date(rfc822)%>\r\n
');
INSERT INTO `nucleus_template` VALUES (3, 'EDITLINK', 'edit');
INSERT INTO `nucleus_template` VALUES (3, 'FORMAT_DATE', '%Y-%m-%d');
INSERT INTO `nucleus_template` VALUES (3, 'FORMAT_TIME', '%H:%M:%S');
INSERT INTO `nucleus_template` VALUES (4, 'ITEM', '<%date(utc)%>');
INSERT INTO `nucleus_template` VALUES (5, 'ITEM', '\r\n ]]>\r\n \r\n \r\n <%author%>\r\n \r\n <%date(utc)%>\r\n <%date(iso8601)%>\r\n <%more%>]]>\r\n <%blogurl%>:<%blogid%>:<%itemid%>\r\n');
INSERT INTO `nucleus_template` VALUES (5, 'POPUP_CODE', '<%media%>');
INSERT INTO `nucleus_template` VALUES (5, 'IMAGE_CODE', '<%image%>');
INSERT INTO `nucleus_template` VALUES (5, 'MEDIA_CODE', '<%media%>');
INSERT INTO `nucleus_template` VALUES (3, 'POPUP_CODE', '<%image%>');
INSERT INTO `nucleus_template` VALUES (3, 'MEDIA_CODE', '<%media%>');
INSERT INTO `nucleus_template` VALUES (3, 'IMAGE_CODE', '<%media%>');
CREATE TABLE `nucleus_template_desc` (
`tdnumber` int(11) NOT NULL auto_increment,
`tdname` varchar(64) NOT NULL default '',
`tddesc` varchar(200) default NULL,
PRIMARY KEY (`tdnumber`),
-- UNIQUE KEY `tdnumber` (`tdnumber`),
UNIQUE KEY `tdname` (`tdname`)
) TYPE=MyISAM;
INSERT INTO `nucleus_template_desc` VALUES (4, 'feeds/atom/modified', 'Atom feeds: Inserts last modification date');
INSERT INTO `nucleus_template_desc` VALUES (5, 'feeds/atom/entries', 'Atom feeds: Feed items');
INSERT INTO `nucleus_template_desc` VALUES (3, 'feeds/rss20', 'Used for RSS 2.0 syndication of your blog');
INSERT INTO `nucleus_template_desc` VALUES (8, 'default/index', 'Nucleus CMS default index template');
INSERT INTO `nucleus_template_desc` VALUES (9, 'default/item', 'Nucleus CMS default item template');
CREATE TABLE `nucleus_tickets` (
`ticket` varchar(40) NOT NULL default '',
`ctime` datetime NOT NULL default '0000-00-00 00:00:00',
`member` int(11) NOT NULL default '0',
PRIMARY KEY (`ticket`,`member`)
) TYPE=MyISAM;