-CREATE TABLE nucleus_actionlog (\r
- timestamp datetime NOT NULL default '0000-00-00 00:00:00',\r
- message varchar(255) NOT NULL default ''\r
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
-\r
-CREATE TABLE nucleus_activation (\r
- vkey varchar(40) NOT NULL default '',\r
- vtime datetime NOT NULL default '0000-00-00 00:00:00',\r
- vmember int(11) NOT NULL default '0',\r
- vtype varchar(15) NOT NULL default '',\r
- vextra varchar(128) NOT NULL default '',\r
- PRIMARY KEY (vkey)\r
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
-\r
-CREATE TABLE nucleus_ban (\r
- iprange varchar(15) NOT NULL default '',\r
- reason varchar(255) NOT NULL default '',\r
- blogid int(11) NOT NULL default '0'\r
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
-\r
-CREATE TABLE nucleus_blog (\r
- bnumber int(11) NOT NULL auto_increment,\r
- bname varchar(60) NOT NULL default '',\r
- bshortname varchar(15) NOT NULL default '',\r
- bdesc varchar(200) default NULL,\r
- bcomments tinyint(2) NOT NULL default '1',\r
- bmaxcomments int(11) NOT NULL default '0',\r
- btimeoffset decimal(3,1) NOT NULL default '0.0',\r
- bnotify varchar(128) default NULL,\r
- burl varchar(100) default NULL,\r
- bupdate varchar(60) default NULL,\r
- bdefskin int(11) NOT NULL default '1',\r
- bpublic tinyint(2) NOT NULL default '1',\r
- bconvertbreaks tinyint(2) NOT NULL default '1',\r
- bdefcat int(11) default NULL,\r
- bnotifytype int(11) NOT NULL default '15',\r
- ballowpast tinyint(2) NOT NULL default '0',\r
- bincludesearch tinyint(2) NOT NULL default '0',\r
- breqemail TINYINT( 2 ) DEFAULT '0' NOT NULL,\r
- bfuturepost TINYINT(2) DEFAULT '0' NOT NULL,\r
- PRIMARY KEY (bnumber),\r
--- UNIQUE KEY bnumber (bnumber),\r
- UNIQUE KEY bshortname (bshortname)\r
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
-\r
-INSERT INTO nucleus_blog VALUES (1, 'My Nucleus CMS', 'mynucleuscms', '', 1, 0, 0.0, '', 'http://localhost:8080/nucleus/', '', 5, 1, 1, 1, 1, 1, 0, 0, 0);\r
-\r
-CREATE TABLE nucleus_category (\r
- catid int(11) NOT NULL auto_increment,\r
- cblog int(11) NOT NULL default '0',\r
- cname varchar(200) default NULL,\r
- cdesc varchar(200) default NULL,\r
- PRIMARY KEY (catid)\r
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
-\r
-INSERT INTO nucleus_category VALUES (1, 1, 'General', 'Items that do not fit in other categories');\r
-\r
-CREATE TABLE nucleus_comment (\r
- cnumber int(11) NOT NULL auto_increment,\r
- cbody text NOT NULL,\r
- cuser varchar(40) default NULL,\r
- cmail varchar(100) default NULL,\r
- cemail VARCHAR( 100 ),\r
- cmember int(11) default NULL,\r
- citem int(11) NOT NULL default '0',\r
- ctime datetime NOT NULL default '0000-00-00 00:00:00',\r
- chost varchar(60) default NULL,\r
- cip varchar(15) NOT NULL default '',\r
- cblog int(11) NOT NULL default '0',\r
- PRIMARY KEY (cnumber),\r
--- UNIQUE KEY cnumber (cnumber),\r
- KEY citem (citem),\r
- FULLTEXT KEY cbody (cbody),\r
- INDEX cblog (cblog)\r
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
-\r
-CREATE TABLE nucleus_config (\r
- name varchar(20) NOT NULL default '',\r
- value varchar(128) default NULL,\r
- PRIMARY KEY (name)\r
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
-\r
-INSERT INTO nucleus_config VALUES ('DefaultBlog', '1');\r
-INSERT INTO nucleus_config VALUES ('AdminEmail', 'example@example.org');\r
-INSERT INTO nucleus_config VALUES ('IndexURL', 'http://localhost:8080/nucleus/');\r
-INSERT INTO nucleus_config VALUES ('Locale', 'en_Latn_US');\r
-INSERT INTO nucleus_config VALUES ('SessionCookie', '');\r
-INSERT INTO nucleus_config VALUES ('AllowMemberCreate', '');\r
-INSERT INTO nucleus_config VALUES ('AllowMemberMail', '1');\r
-INSERT INTO nucleus_config VALUES ('SiteName', 'My Nucleus CMS');\r
-INSERT INTO nucleus_config VALUES ('AdminURL', 'http://localhost:8080/nucleus/nucleus/');\r
-INSERT INTO nucleus_config VALUES ('NewMemberCanLogon', '1');\r
-INSERT INTO nucleus_config VALUES ('DisableSite', '');\r
-INSERT INTO nucleus_config VALUES ('DisableSiteURL', 'http://www.this-page-intentionally-left-blank.org/');\r
-INSERT INTO nucleus_config VALUES ('LastVisit', '');\r
-INSERT INTO nucleus_config VALUES ('MediaURL', 'http://localhost:8080/nucleus/media/');\r
-INSERT INTO nucleus_config VALUES ('AllowedTypes', 'jpg,jpeg,gif,mpg,mpeg,avi,mov,mp3,swf,png');\r
-INSERT INTO nucleus_config VALUES ('AllowLoginEdit', '');\r
-INSERT INTO nucleus_config VALUES ('AllowUpload', '1');\r
-INSERT INTO nucleus_config VALUES ('DisableJsTools', '2');\r
-INSERT INTO nucleus_config VALUES ('CookiePath', '/');\r
-INSERT INTO nucleus_config VALUES ('CookieDomain', '');\r
-INSERT INTO nucleus_config VALUES ('CookieSecure', '');\r
-INSERT INTO nucleus_config VALUES ('CookiePrefix', '');\r
-INSERT INTO nucleus_config VALUES ('MediaPrefix', '1');\r
-INSERT INTO nucleus_config VALUES ('MaxUploadSize', '1048576');\r
-INSERT INTO nucleus_config VALUES ('NonmemberMail', '');\r
-INSERT INTO nucleus_config VALUES ('PluginURL', 'http://localhost:8080/nucleus/nucleus/plugins/');\r
-INSERT INTO nucleus_config VALUES ('ProtectMemNames', '1');\r
-INSERT INTO nucleus_config VALUES ('BaseSkin', '5');\r
-INSERT INTO nucleus_config VALUES ('SkinsURL', 'http://localhost:8080/nucleus/skins/');\r
-INSERT INTO nucleus_config VALUES ('ActionURL', 'http://localhost:8080/nucleus/action.php');\r
-INSERT INTO nucleus_config VALUES ('URLMode', 'normal');\r
-INSERT INTO nucleus_config VALUES ('DatabaseVersion', '350');\r
-INSERT INTO nucleus_config VALUES ('DebugVars', '0');\r
-INSERT INTO nucleus_config VALUES ('DefaultListSize', '10');\r
-INSERT INTO nucleus_config VALUES ('AdminCSS', 'original');\r
-\r
-CREATE TABLE nucleus_item (\r
- inumber int(11) NOT NULL auto_increment,\r
- ititle varchar(160) default NULL,\r
- ibody text NOT NULL,\r
- imore text,\r
- iblog int(11) NOT NULL default '0',\r
- iauthor int(11) NOT NULL default '0',\r
- itime datetime NOT NULL default '0000-00-00 00:00:00',\r
- iclosed tinyint(2) NOT NULL default '0',\r
- idraft tinyint(2) NOT NULL default '0',\r
- ikarmapos int(11) NOT NULL default '0',\r
- icat int(11) default NULL,\r
- ikarmaneg int(11) NOT NULL default '0',\r
- iposted tinyint(2) NOT NULL default '1',\r
- PRIMARY KEY (inumber),\r
--- UNIQUE KEY inumber (inumber),\r
- KEY itime (itime),\r
- INDEX iblog (iblog),\r
- INDEX idraft (idraft),\r
- INDEX icat (icat),\r
- FULLTEXT KEY ibody (ibody,ititle,imore)\r
-) ENGINE=MyISAM PACK_KEYS=0 DEFAULT CHARSET=utf8;\r
-\r
-CREATE TABLE nucleus_karma (\r
- itemid int(11) NOT NULL default '0',\r
- ip char(15) NOT NULL default ''\r
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
-\r
-CREATE TABLE nucleus_member (\r
- mnumber int(11) NOT NULL auto_increment,\r
- mname varchar(32) NOT NULL default '',\r
- mrealname varchar(60) default NULL,\r
- mpassword varchar(40) NOT NULL default '',\r
- memail varchar(60) default NULL,\r
- murl varchar(100) default NULL,\r
- mnotes varchar(100) default NULL,\r
- madmin tinyint(2) NOT NULL default '0',\r
- mcanlogin tinyint(2) NOT NULL default '1',\r
- mcookiekey varchar(40) default NULL,\r
- mlocale varchar(20) NOT NULL default '',\r
- mautosave tinyint(2) NOT NULL default '1',\r
- PRIMARY KEY (mnumber),\r
--- UNIQUE KEY mnumber (mnumber),\r
- UNIQUE KEY mname (mname)\r
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
-\r
-INSERT INTO nucleus_member VALUES (1, 'example', 'example', '1a79a4d60de6718e8e5b326e338ae533', 'example@example.org', 'http://localhost:8080/nucleus/', '', 1, 1, 'd767aefc60415859570d64c649257f19', '', 1);\r
-\r
-CREATE TABLE nucleus_plugin (\r
- pid int(11) NOT NULL auto_increment,\r
- pfile varchar(40) NOT NULL default '',\r
- porder int(11) NOT NULL default '0',\r
- PRIMARY KEY (pid),\r
--- KEY pid (pid),\r
- KEY porder (porder)\r
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
-\r
-CREATE TABLE nucleus_plugin_event (\r
- pid int(11) NOT NULL default '0',\r
- event varchar(40) default NULL,\r
- KEY pid (pid)\r
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
-\r
-CREATE TABLE nucleus_plugin_option (\r
- ovalue text NOT NULL,\r
- oid int(11) NOT NULL auto_increment,\r
- ocontextid int(11) NOT NULL default '0',\r
- PRIMARY KEY (oid,ocontextid)\r
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
-\r
-CREATE TABLE nucleus_plugin_option_desc (\r
- oid int(11) NOT NULL auto_increment,\r
- opid int(11) NOT NULL default '0',\r
- oname varchar(20) NOT NULL default '',\r
- ocontext varchar(20) NOT NULL default '',\r
- odesc varchar(255) default NULL,\r
- otype varchar(20) default NULL,\r
- odef text,\r
- oextra text,\r
- PRIMARY KEY (opid,oname,ocontext),\r
- UNIQUE KEY oid (oid)\r
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
-\r
-CREATE TABLE nucleus_skin (\r
- sdesc int(11) NOT NULL default '0',\r
- stype varchar(20) NOT NULL default '',\r
- scontent text NOT NULL,\r
- PRIMARY KEY (sdesc,stype)\r
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
-\r
--- INSERT INTO nucleus_skin VALUES (2, 'index', '<?xml version=\"1.0\" encoding=\"<%charset%>\"?>\n\n<feed xml:lang=\"en-us\" xmlns=\"http://www.w3.org/2005/Atom\">\n <title><%blogsetting(name)%></title>\n <id><%blogsetting(url)%>:<%blogsetting(id)%></id>\n\n <link rel=\"alternate\" type=\"text/html\" href=\"<%blogsetting(url)%>\" />\n <link rel=\"self\" type=\"application/atom+xml\" href=\"<%blogsetting(url)%><%self%>\" />\n <generator uri=\"http://nucleuscms.org/\"><%version%></generator>\n <updated><%blog(feeds/atom/modified,1)%></updated>\n\n <%blog(feeds/atom/entries,10)%>\n</feed>');\r
--- INSERT INTO nucleus_skin VALUES (4, 'index', '<?xml version="1.0"?>\r\n<rsd version="1.0">\r\n <service>\r\n <engineName><%version%></engineName>\r\n <engineLink>http://nucleuscms.org/</engineLink>\r\n <homepageLink><%sitevar(url)%></homepageLink>\r\n <apis>\r\n <api name="MetaWeblog" preferred="true" apiLink="<%adminurl%>xmlrpc/server.php" blogID="<%blogsetting(id)%>">\r\n <docs>http://nucleuscms.org/documentation/devdocs/xmlrpc.html</docs>\r\n </api>\r\n <api name="Blogger" preferred="false" apiLink="<%adminurl%>xmlrpc/server.php" blogID="<%blogsetting(id)%>">\r\n <docs>http://nucleuscms.org/documentation/devdocs/xmlrpc.html</docs>\r\n </api>\r\n </apis>\r\n </service>\r\n</rsd>');\r
--- INSERT INTO nucleus_skin VALUES (3, 'index', '<?xml version="1.0" encoding="<%charset%>"?>\r\n<rss version="2.0">\r\n <channel>\r\n <title><%blogsetting(name)%></title>\r\n <link><%blogsetting(url)%></link>\r\n <description><%blogsetting(desc)%></description>\r\n <language>en-us</language> \r\n <generator><%version%></generator>\r\n <copyright>?</copyright> \r\n <category>Weblog</category>\r\n <docs>http://backend.userland.com/rss</docs>\r\n <image>\r\n <url><%blogsetting(url)%>/nucleus/nucleus2.gif</url>\r\n <title><%blogsetting(name)%></title>\r\n <link><%blogsetting(url)%></link>\r\n </image>\r\n <%blog(feeds/rss20,10)%>\r\n </channel>\r\n</rss>');\r
-\r
-CREATE TABLE nucleus_skin_desc (\r
- sdnumber int(11) NOT NULL auto_increment,\r
- sdname varchar(20) NOT NULL default '',\r
- sddesc varchar(200) default NULL,\r
- sdtype varchar(40) NOT NULL default 'text/html',\r
- sdincmode varchar(10) NOT NULL default 'normal',\r
- sdincpref varchar(50) NOT NULL default '',\r
- PRIMARY KEY (sdnumber),\r
--- UNIQUE KEY sdnumber (sdnumber),\r
- UNIQUE KEY sdname (sdname)\r
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
-\r
--- INSERT INTO nucleus_skin_desc VALUES (2, 'feeds/atom', 'Atom 1.0 weblog syndication', 'application/atom+xml', 'normal', '');\r
--- INSERT INTO nucleus_skin_desc VALUES (3, 'feeds/rss20', 'RSS 2.0 syndication of weblogs', 'text/xml', 'normal', '');\r
--- INSERT INTO nucleus_skin_desc VALUES (4, 'xml/rsd', 'RSD (Really Simple Discovery) information for weblog clients', 'text/xml', 'normal', '');\r
--- INSERT INTO nucleus_skin_desc VALUES (5, 'default', 'Nucleus CMS default skin', 'text/html', 'skindir', 'default/');\r
-\r
-CREATE TABLE nucleus_team (\r
- tmember int(11) NOT NULL default '0',\r
- tblog int(11) NOT NULL default '0',\r
- tadmin tinyint(2) NOT NULL default '0',\r
- PRIMARY KEY (tmember,tblog)\r
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
-\r
-INSERT INTO nucleus_team VALUES (1, 1, 1);\r
-\r
-CREATE TABLE nucleus_template (\r
- tdesc int(11) NOT NULL default '0',\r
- tpartname varchar(64) NOT NULL default '',\r
- tcontent text NOT NULL,\r
- PRIMARY KEY (tdesc,tpartname)\r
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
-\r
--- INSERT INTO nucleus_template VALUES (3, 'ITEM', '<item>\r\n <title><%title(xml)%></title>\r\n <link><%blogurl%>index.php?itemid=<%itemid%></link>\r\n<description><![CDATA[<%body%><%more%>]]></description>\r\n <category><%category%></category>\r\n<comments><%blogurl%>index.php?itemid=<%itemid%></comments>\r\n <pubDate><%date(rfc822)%></pubDate>\r\n</item>');\r
--- INSERT INTO nucleus_template VALUES (3, 'EDITLINK', '<a href="<%editlink%>" onclick="<%editpopupcode%>">edit</a>');\r
--- INSERT INTO nucleus_template VALUES (3, 'FORMAT_DATE', '%x');\r
--- INSERT INTO nucleus_template VALUES (3, 'FORMAT_TIME', '%X');\r
--- INSERT INTO nucleus_template VALUES (4, 'ITEM', '<%date(utc)%>');\r
--- INSERT INTO nucleus_template VALUES (5, 'ITEM', '<entry>\n <title type=\"html\"><![CDATA[<%title%>]]></title>\n <link rel=\"alternate\" type=\"text/html\" href=\"<%blogurl%>index.php?itemid=<%itemid%>\" />\n <author>\n <name><%author%></name>\n </author>\n <updated><%date(utc)%></updated>\n <published><%date(iso8601)%></published>\n <content type=\"html\"><![CDATA[<%body%><%more%>]]></content>\n <id><%blogurl%>:<%blogid%>:<%itemid%></id>\n</entry>');\r
--- INSERT INTO nucleus_template VALUES (5, 'POPUP_CODE', '<%media%>');\r
--- INSERT INTO nucleus_template VALUES (5, 'IMAGE_CODE', '<%image%>');\r
--- INSERT INTO nucleus_template VALUES (5, 'MEDIA_CODE', '<%media%>');\r
--- INSERT INTO nucleus_template VALUES (3, 'POPUP_CODE', '<%image%>');\r
--- INSERT INTO nucleus_template VALUES (3, 'MEDIA_CODE', '<%media%>');\r
--- INSERT INTO nucleus_template VALUES (3, 'IMAGE_CODE', '<%media%>');\r
-\r
-CREATE TABLE nucleus_template_desc (\r
- tdnumber int(11) NOT NULL auto_increment,\r
- tdname varchar(64) NOT NULL default '',\r
- tddesc varchar(200) default NULL,\r
- PRIMARY KEY (tdnumber),\r
--- UNIQUE KEY tdnumber (tdnumber),\r
- UNIQUE KEY tdname (tdname)\r
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
-\r
--- INSERT INTO nucleus_template_desc VALUES (4, 'feeds/atom/modified', 'Atom feeds: Inserts last modification date');\r
--- INSERT INTO nucleus_template_desc VALUES (5, 'feeds/atom/entries', 'Atom feeds: Feed items');\r
--- INSERT INTO nucleus_template_desc VALUES (3, 'feeds/rss20', 'Used for RSS 2.0 syndication of your blog');\r
--- INSERT INTO nucleus_template_desc VALUES (8, 'default/index', 'Nucleus CMS default index template');\r
--- INSERT INTO nucleus_template_desc VALUES (9, 'default/item', 'Nucleus CMS default item template');\r
-\r
-CREATE TABLE nucleus_tickets (\r
- ticket varchar(40) NOT NULL default '',\r
- ctime datetime NOT NULL default '0000-00-00 00:00:00',\r
- member int(11) NOT NULL default '0',\r
- PRIMARY KEY (ticket,member)\r
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r
+CREATE TABLE nucleus_actionlog (
+ timestamp datetime NOT NULL default '0000-00-00 00:00:00',
+ message varchar(255) NOT NULL default ''
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+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)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+CREATE TABLE nucleus_ban (
+ iprange varchar(15) NOT NULL default '',
+ reason varchar(255) NOT NULL default '',
+ blogid int(11) NOT NULL default '0'
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+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(128) 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',
+ 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 ) DEFAULT '0' NOT NULL,
+ bfuturepost TINYINT(2) DEFAULT '0' NOT NULL,
+ PRIMARY KEY (bnumber),
+-- UNIQUE KEY bnumber (bnumber),
+ UNIQUE KEY bshortname (bshortname)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+INSERT INTO nucleus_blog VALUES (1, 'My Nucleus CMS', 'mynucleuscms', '', 1, 0, 0.0, '', 'http://localhost:8080/nucleus/', '', 5, 1, 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)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+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),
+ INDEX cblog (cblog)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+CREATE TABLE nucleus_config (
+ name varchar(20) NOT NULL default '',
+ value varchar(128) default NULL,
+ PRIMARY KEY (name)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+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 ('Locale', 'en_Latn_US');
+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', '350');
+INSERT INTO nucleus_config VALUES ('DebugVars', '0');
+INSERT INTO nucleus_config VALUES ('DefaultListSize', '10');
+INSERT INTO nucleus_config VALUES ('AdminCSS', 'original');
+INSERT INTO nucleus_config VALUES ('AdminSkin', '0');
+INSERT INTO nucleus_config VALUES ('BookmarkletSkin', '0');
+
+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),
+ INDEX iblog (iblog),
+ INDEX idraft (idraft),
+ INDEX icat (icat),
+ FULLTEXT KEY ibody (ibody,ititle,imore)
+) ENGINE=MyISAM PACK_KEYS=0 DEFAULT CHARSET=utf8;
+
+CREATE TABLE nucleus_karma (
+ itemid int(11) NOT NULL default '0',
+ ip char(15) NOT NULL default ''
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+CREATE TABLE nucleus_member (
+ mnumber int(11) NOT NULL auto_increment,
+ mname varchar(32) 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,
+ mlocale varchar(20) NOT NULL default '',
+ mautosave tinyint(2) NOT NULL default '1',
+ madminskin tinyint(2) NOT NULL default '0',
+ mbkmklt tinyint(2) NOT NULL default '0',
+ PRIMARY KEY (mnumber),
+-- UNIQUE KEY mnumber (mnumber),
+ UNIQUE KEY mname (mname)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+INSERT INTO nucleus_member VALUES (1, 'example', 'example', '1a79a4d60de6718e8e5b326e338ae533', 'example@example.org', 'http://localhost:8080/nucleus/', '', 1, 1, 'd767aefc60415859570d64c649257f19', '', 1, 0, 0);
+
+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)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+CREATE TABLE nucleus_plugin_event (
+ pid int(11) NOT NULL default '0',
+ event varchar(40) default NULL,
+ KEY pid (pid)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+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)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+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)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+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)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- INSERT INTO nucleus_skin VALUES (2, 'index', '<?xml version=\"1.0\" encoding=\"<%charset%>\"?>\n\n<feed xml:lang=\"en-us\" xmlns=\"http://www.w3.org/2005/Atom\">\n <title><%blogsetting(name)%></title>\n <id><%blogsetting(url)%>:<%blogsetting(id)%></id>\n\n <link rel=\"alternate\" type=\"text/html\" href=\"<%blogsetting(url)%>\" />\n <link rel=\"self\" type=\"application/atom+xml\" href=\"<%blogsetting(url)%><%self%>\" />\n <generator uri=\"http://nucleuscms.org/\"><%version%></generator>\n <updated><%blog(feeds/atom/modified,1)%></updated>\n\n <%blog(feeds/atom/entries,10)%>\n</feed>');
+-- INSERT INTO nucleus_skin VALUES (4, 'index', '<?xml version="1.0"?>\r\n<rsd version="1.0">\r\n <service>\r\n <engineName><%version%></engineName>\r\n <engineLink>http://nucleuscms.org/</engineLink>\r\n <homepageLink><%sitevar(url)%></homepageLink>\r\n <apis>\r\n <api name="MetaWeblog" preferred="true" apiLink="<%adminurl%>xmlrpc/server.php" blogID="<%blogsetting(id)%>">\r\n <docs>http://nucleuscms.org/documentation/devdocs/xmlrpc.html</docs>\r\n </api>\r\n <api name="Blogger" preferred="false" apiLink="<%adminurl%>xmlrpc/server.php" blogID="<%blogsetting(id)%>">\r\n <docs>http://nucleuscms.org/documentation/devdocs/xmlrpc.html</docs>\r\n </api>\r\n </apis>\r\n </service>\r\n</rsd>');
+-- INSERT INTO nucleus_skin VALUES (3, 'index', '<?xml version="1.0" encoding="<%charset%>"?>\r\n<rss version="2.0">\r\n <channel>\r\n <title><%blogsetting(name)%></title>\r\n <link><%blogsetting(url)%></link>\r\n <description><%blogsetting(desc)%></description>\r\n <language>en-us</language> \r\n <generator><%version%></generator>\r\n <copyright>?</copyright> \r\n <category>Weblog</category>\r\n <docs>http://backend.userland.com/rss</docs>\r\n <image>\r\n <url><%blogsetting(url)%>/nucleus/nucleus2.gif</url>\r\n <title><%blogsetting(name)%></title>\r\n <link><%blogsetting(url)%></link>\r\n </image>\r\n <%blog(feeds/rss20,10)%>\r\n </channel>\r\n</rss>');
+
+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)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- 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)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+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)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- INSERT INTO nucleus_template VALUES (3, 'ITEM', '<item>\r\n <title><%title(xml)%></title>\r\n <link><%blogurl%>index.php?itemid=<%itemid%></link>\r\n<description><![CDATA[<%body%><%more%>]]></description>\r\n <category><%category%></category>\r\n<comments><%blogurl%>index.php?itemid=<%itemid%></comments>\r\n <pubDate><%date(rfc822)%></pubDate>\r\n</item>');
+-- INSERT INTO nucleus_template VALUES (3, 'EDITLINK', '<a href="<%editlink%>" onclick="<%editpopupcode%>">edit</a>');
+-- INSERT INTO nucleus_template VALUES (3, 'FORMAT_DATE', '%x');
+-- INSERT INTO nucleus_template VALUES (3, 'FORMAT_TIME', '%X');
+-- INSERT INTO nucleus_template VALUES (4, 'ITEM', '<%date(utc)%>');
+-- INSERT INTO nucleus_template VALUES (5, 'ITEM', '<entry>\n <title type=\"html\"><![CDATA[<%title%>]]></title>\n <link rel=\"alternate\" type=\"text/html\" href=\"<%blogurl%>index.php?itemid=<%itemid%>\" />\n <author>\n <name><%author%></name>\n </author>\n <updated><%date(utc)%></updated>\n <published><%date(iso8601)%></published>\n <content type=\"html\"><![CDATA[<%body%><%more%>]]></content>\n <id><%blogurl%>:<%blogid%>:<%itemid%></id>\n</entry>');
+-- 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)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- 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)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
OSDN Git Service
