1 CREATE TABLE `nucleus_actionlog` (
2 `logid` int(11) NOT NULL auto_increment,
3 `timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
4 `message` varchar(255) NOT NULL default '',
8 CREATE TABLE `nucleus_activation` (
9 `vkey` varchar(40) NOT NULL default '',
10 `vtime` datetime NOT NULL default '0000-00-00 00:00:00',
11 `vmember` int(11) NOT NULL default '0',
12 `vtype` varchar(15) NOT NULL default '',
13 `vextra` varchar(128) NOT NULL default '',
17 CREATE TABLE `nucleus_ban` (
18 `iprange` varchar(15) NOT NULL default '',
19 `reason` varchar(255) NOT NULL default '',
20 `blogid` int(11) NOT NULL default '0',
21 KEY `iprange` (`iprange`),
22 KEY `blogid` (`blogid`)
25 CREATE TABLE `nucleus_blog` (
26 `bnumber` int(11) NOT NULL auto_increment,
27 `bname` varchar(60) NOT NULL default '',
28 `bshortname` varchar(15) NOT NULL default '',
29 `bdesc` varchar(200) default NULL,
30 `bcomments` tinyint(2) NOT NULL default '1',
31 `bmaxcomments` int(11) NOT NULL default '0',
32 `btimeoffset` decimal(3,1) NOT NULL default '0.0',
33 `bnotify` varchar(60) default NULL,
34 `burl` varchar(100) default NULL,
35 `bupdate` varchar(60) default NULL,
36 `bdefskin` int(11) NOT NULL default '1',
37 `bpublic` tinyint(2) NOT NULL default '1',
38 `bsendping` tinyint(2) NOT NULL default '0',
39 `bconvertbreaks` tinyint(2) NOT NULL default '1',
40 `bdefcat` int(11) default NULL,
41 `bnotifytype` int(11) NOT NULL default '15',
42 `ballowpast` tinyint(2) NOT NULL default '0',
43 `bincludesearch` tinyint(2) NOT NULL default '0',
44 `breqemail` tinyint(2) NOT NULL default '0',
45 `bfuturepost` tinyint(2) NOT NULL default '0',
46 PRIMARY KEY (`bnumber`),
47 -- UNIQUE KEY `bnumber` (`bnumber`),
48 UNIQUE KEY `bshortname` (`bshortname`)
51 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);
54 CREATE TABLE `nucleus_category` (
55 `catid` int(11) NOT NULL auto_increment,
56 `cblog` int(11) NOT NULL default '0',
57 `cname` varchar(200) default NULL,
58 `cdesc` varchar(200) default NULL,
62 INSERT INTO `nucleus_category` VALUES (1, 1, 'General', 'Items that do not fit in other categories');
64 CREATE TABLE `nucleus_comment` (
65 `cnumber` int(11) NOT NULL auto_increment,
66 `cbody` text NOT NULL,
67 `cuser` varchar(40) default NULL,
68 `cmail` varchar(100) default NULL,
69 `cemail` varchar(100),
70 `cmember` int(11) default NULL,
71 `citem` int(11) NOT NULL default '0',
72 `ctime` datetime NOT NULL default '0000-00-00 00:00:00',
73 `chost` varchar(60) default NULL,
74 `cip` varchar(15) NOT NULL default '',
75 `cblog` int(11) NOT NULL default '0',
76 PRIMARY KEY (`cnumber`),
77 -- UNIQUE KEY `cnumber` (`cnumber`),
78 KEY `citem` (`citem`),
79 FULLTEXT KEY `cbody` (`cbody`)
82 CREATE TABLE `nucleus_config` (
83 `name` varchar(20) NOT NULL default '',
84 `value` varchar(128) default NULL,
88 INSERT INTO `nucleus_config` VALUES ('DefaultBlog', '1');
89 INSERT INTO `nucleus_config` VALUES ('AdminEmail', 'example@example.org');
90 INSERT INTO `nucleus_config` VALUES ('IndexURL', 'http://localhost:8080/nucleus/');
91 INSERT INTO `nucleus_config` VALUES ('Language', 'japanese-utf8');
92 INSERT INTO `nucleus_config` VALUES ('SessionCookie', '');
93 INSERT INTO `nucleus_config` VALUES ('AllowMemberCreate', '');
94 INSERT INTO `nucleus_config` VALUES ('AllowMemberMail', '1');
95 INSERT INTO `nucleus_config` VALUES ('SiteName', 'My Nucleus CMS');
96 INSERT INTO `nucleus_config` VALUES ('AdminURL', 'http://localhost:8080/nucleus/nucleus/');
97 INSERT INTO `nucleus_config` VALUES ('NewMemberCanLogon', '1');
98 INSERT INTO `nucleus_config` VALUES ('DisableSite', '');
99 INSERT INTO `nucleus_config` VALUES ('DisableSiteURL', 'http://www.this-page-intentionally-left-blank.org/');
100 INSERT INTO `nucleus_config` VALUES ('LastVisit', '');
101 INSERT INTO `nucleus_config` VALUES ('MediaURL', 'http://localhost:8080/nucleus/media/');
102 INSERT INTO `nucleus_config` VALUES ('AllowedTypes', 'jpg,jpeg,gif,mpg,mpeg,avi,mov,mp3,swf,png');
103 INSERT INTO `nucleus_config` VALUES ('AllowLoginEdit', '');
104 INSERT INTO `nucleus_config` VALUES ('AllowUpload', '1');
105 INSERT INTO `nucleus_config` VALUES ('DisableJsTools', '2');
106 INSERT INTO `nucleus_config` VALUES ('CookiePath', '/');
107 INSERT INTO `nucleus_config` VALUES ('CookieDomain', '');
108 INSERT INTO `nucleus_config` VALUES ('CookieSecure', '');
109 INSERT INTO `nucleus_config` VALUES ('CookiePrefix', '');
110 INSERT INTO `nucleus_config` VALUES ('MediaPrefix', '1');
111 INSERT INTO `nucleus_config` VALUES ('MaxUploadSize', '1048576');
112 INSERT INTO `nucleus_config` VALUES ('NonmemberMail', '');
113 INSERT INTO `nucleus_config` VALUES ('PluginURL', 'http://localhost:8080/nucleus/nucleus/plugins/');
114 INSERT INTO `nucleus_config` VALUES ('ProtectMemNames', '1');
115 INSERT INTO `nucleus_config` VALUES ('BaseSkin', '5');
116 INSERT INTO `nucleus_config` VALUES ('SkinsURL', 'http://localhost:8080/nucleus/skins/');
117 INSERT INTO `nucleus_config` VALUES ('ActionURL', 'http://localhost:8080/nucleus/action.php');
118 INSERT INTO `nucleus_config` VALUES ('URLMode', 'normal');
119 INSERT INTO `nucleus_config` VALUES ('DatabaseVersion', '340');
120 INSERT INTO `nucleus_config` VALUES ('DebugVars', '0');
121 INSERT INTO `nucleus_config` VALUES ('DefaultListSize', '10');
123 CREATE TABLE `nucleus_item` (
124 `inumber` int(11) NOT NULL auto_increment,
125 `ititle` varchar(160) default NULL,
126 `ibody` text NOT NULL,
128 `iblog` int(11) NOT NULL default '0',
129 `iauthor` int(11) NOT NULL default '0',
130 `itime` datetime NOT NULL default '0000-00-00 00:00:00',
131 `iclosed` tinyint(2) NOT NULL default '0',
132 `idraft` tinyint(2) NOT NULL default '0',
133 `ikarmapos` int(11) NOT NULL default '0',
134 `icat` int(11) default NULL,
135 `ikarmaneg` int(11) NOT NULL default '0',
136 `iposted` tinyint(2) NOT NULL default '1',
137 PRIMARY KEY (`inumber`),
138 -- UNIQUE KEY `inumber` (`inumber`),
139 KEY `itime` (`itime`),
140 FULLTEXT KEY `ibody` (`ibody`, `ititle`, `imore`)
141 ) TYPE=MyISAM PACK_KEYS=0;
143 CREATE TABLE `nucleus_karma` (
144 `itemid` int(11) NOT NULL default '0',
145 `ip` char(15) NOT NULL default '',
146 KEY `itemid` (`itemid`)
149 CREATE TABLE `nucleus_member` (
150 `mnumber` int(11) NOT NULL auto_increment,
151 `mname` varchar(16) NOT NULL default '',
152 `mrealname` varchar(60) default NULL,
153 `mpassword` varchar(40) NOT NULL default '',
154 `memail` varchar(60) default NULL,
155 `murl` varchar(100) default NULL,
156 `mnotes` varchar(100) default NULL,
157 `madmin` tinyint(2) NOT NULL default '0',
158 `mcanlogin` tinyint(2) NOT NULL default '1',
159 `mcookiekey` varchar(40) default NULL,
160 `deflang` varchar(20) NOT NULL default '',
161 `mautosave` tinyint(2) NOT NULL default '1',
162 PRIMARY KEY (`mnumber`),
163 -- UNIQUE KEY `mnumber` (`mnumber`),
164 UNIQUE KEY `mname` (`mname`)
167 INSERT INTO `nucleus_member` VALUES (1, 'example', 'example', '1a79a4d60de6718e8e5b326e338ae533', 'example@example.org', 'http://localhost:8080/nucleus/', '', 1, 1, 'd767aefc60415859570d64c649257f19', '', 1);
169 CREATE TABLE `nucleus_plugin` (
170 `pid` int(11) NOT NULL auto_increment,
171 `pfile` varchar(40) NOT NULL default '',
172 `porder` int(11) NOT NULL default '0',
174 -- KEY `pid` (`pid`),
175 KEY `porder` (`porder`)
178 CREATE TABLE `nucleus_plugin_event` (
179 `pid` int(11) NOT NULL default '0',
180 `event` varchar(40) default NULL,
184 CREATE TABLE `nucleus_plugin_option` (
185 `ovalue` text NOT NULL,
186 `oid` int(11) NOT NULL auto_increment,
187 `ocontextid` int(11) NOT NULL default '0',
188 PRIMARY KEY (`oid`, `ocontextid`)
191 CREATE TABLE `nucleus_plugin_option_desc` (
192 `oid` int(11) NOT NULL auto_increment,
193 `opid` int(11) NOT NULL default '0',
194 `oname` varchar(20) NOT NULL default '',
195 `ocontext` varchar(20) NOT NULL default '',
196 `odesc` varchar(255) default NULL,
197 `otype` varchar(20) default NULL,
200 PRIMARY KEY (`opid`, `oname`, `ocontext`),
201 UNIQUE KEY `oid` (`oid`)
204 CREATE TABLE `nucleus_skin` (
205 `sdesc` int(11) NOT NULL default '0',
206 `stype` varchar(20) NOT NULL default '',
207 `scontent` text NOT NULL,
208 PRIMARY KEY (`sdesc`,`stype`)
211 INSERT INTO `nucleus_skin` VALUES (2, 'index', '<?xml version="1.0" encoding="UTF-8"?>\n\n<feed xml:lang="ja" xmlns="http://www.w3.org/2005/Atom\">\n <title><%blogsetting(name)%></title>\n <subtitle><%blogsetting(desc)%></subtitle>\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>');
212 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>');
213 INSERT INTO `nucleus_skin` VALUES (3, 'index', '<?xml version="1.0" encoding="UTF-8"?>\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>ja</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><%adminurl%>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>');
215 CREATE TABLE `nucleus_skin_desc` (
216 `sdnumber` int(11) NOT NULL auto_increment,
217 `sdname` varchar(20) NOT NULL default '',
218 `sddesc` varchar(200) default NULL,
219 `sdtype` varchar(40) NOT NULL default 'text/html',
220 `sdincmode` varchar(10) NOT NULL default 'normal',
221 `sdincpref` varchar(50) NOT NULL default '',
222 PRIMARY KEY (`sdnumber`),
223 -- UNIQUE KEY `sdnumber` (`sdnumber`),
224 UNIQUE KEY `sdname` (`sdname`)
227 INSERT INTO `nucleus_skin_desc` VALUES (2, 'feeds/atom', 'Atom 1.0 weblog syndication', 'application/atom+xml', 'normal', '');
228 INSERT INTO `nucleus_skin_desc` VALUES (3, 'feeds/rss20', 'RSS 2.0 syndication of weblogs', 'text/xml', 'normal', '');
229 INSERT INTO `nucleus_skin_desc` VALUES (4, 'xml/rsd', 'RSD (Really Simple Discovery) information for weblog clients', 'text/xml', 'normal', '');
230 INSERT INTO `nucleus_skin_desc` VALUES (5, 'default', 'Nucleus CMS default skin', 'text/html', 'skindir', 'default/');
232 CREATE TABLE `nucleus_team` (
233 `tmember` int(11) NOT NULL default '0',
234 `tblog` int(11) NOT NULL default '0',
235 `tadmin` tinyint(2) NOT NULL default '0',
236 PRIMARY KEY (`tmember`, `tblog`)
239 INSERT INTO `nucleus_team` VALUES (1, 1, 1);
241 CREATE TABLE `nucleus_template` (
242 `tdesc` int(11) NOT NULL default '0',
243 `tpartname` varchar(64) NOT NULL default '',
244 `tcontent` text NOT NULL,
245 PRIMARY KEY (`tdesc`, `tpartname`)
248 INSERT INTO `nucleus_template` VALUES (3, 'ITEM', '<item>\r\n <title><%title(xml)%></title>\r\n <link><%blogurl%>?itemid=<%itemid%></link>\r\n<description><![CDATA[<%body%><%more%>]]></description>\r\n <category><%category%></category>\r\n<comments><%blogurl%>?itemid=<%itemid%></comments>\r\n <pubDate><%date(rfc822)%></pubDate>\r\n</item>');
249 INSERT INTO `nucleus_template` VALUES (3, 'EDITLINK', '<a href="<%editlink%>" onclick="<%editpopupcode%>">edit</a>');
250 INSERT INTO `nucleus_template` VALUES (3, 'FORMAT_DATE', '%Y-%m-%d');
251 INSERT INTO `nucleus_template` VALUES (3, 'FORMAT_TIME', '%H:%M:%S');
252 INSERT INTO `nucleus_template` VALUES (4, 'ITEM', '<%date(utc)%>');
253 INSERT INTO `nucleus_template` VALUES (5, 'ITEM', '<entry>\r\n <title type="html"><![CDATA[<%title%>]]></title>\r\n <link rel="alternate" type="text/html" href="<%blogurl%>?itemid=<%itemid%>" />\r\n <author>\r\n <name><%author%></name>\r\n </author>\r\n <updated><%date(utc)%></updated>\r\n <published><%date(iso8601)%></published>\r\n <content type="html"><![CDATA[<%body%><%more%>]]></content>\r\n <id><%blogurl%>:<%blogid%>:<%itemid%></id>\r\n</entry>');
254 INSERT INTO `nucleus_template` VALUES (5, 'POPUP_CODE', '<%media%>');
255 INSERT INTO `nucleus_template` VALUES (5, 'IMAGE_CODE', '<%image%>');
256 INSERT INTO `nucleus_template` VALUES (5, 'MEDIA_CODE', '<%media%>');
257 INSERT INTO `nucleus_template` VALUES (3, 'POPUP_CODE', '<%image%>');
258 INSERT INTO `nucleus_template` VALUES (3, 'MEDIA_CODE', '<%media%>');
259 INSERT INTO `nucleus_template` VALUES (3, 'IMAGE_CODE', '<%media%>');
261 CREATE TABLE `nucleus_template_desc` (
262 `tdnumber` int(11) NOT NULL auto_increment,
263 `tdname` varchar(64) NOT NULL default '',
264 `tddesc` varchar(200) default NULL,
265 PRIMARY KEY (`tdnumber`),
266 -- UNIQUE KEY `tdnumber` (`tdnumber`),
267 UNIQUE KEY `tdname` (`tdname`)
270 INSERT INTO `nucleus_template_desc` VALUES (4, 'feeds/atom/modified', 'Atom feeds: Inserts last modification date');
271 INSERT INTO `nucleus_template_desc` VALUES (5, 'feeds/atom/entries', 'Atom feeds: Feed items');
272 INSERT INTO `nucleus_template_desc` VALUES (3, 'feeds/rss20', 'Used for RSS 2.0 syndication of your blog');
273 INSERT INTO `nucleus_template_desc` VALUES (8, 'default/index', 'Nucleus CMS default index template');
274 INSERT INTO `nucleus_template_desc` VALUES (9, 'default/item', 'Nucleus CMS default item template');
276 CREATE TABLE `nucleus_tickets` (
277 `ticket` varchar(40) NOT NULL default '',
278 `ctime` datetime NOT NULL default '0000-00-00 00:00:00',
279 `member` int(11) NOT NULL default '0',
280 PRIMARY KEY (`ticket`,`member`)