1 CREATE TABLE `nucleus_actionlog` (
2 `timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
3 `message` varchar(255) NOT NULL default ''
6 CREATE TABLE `nucleus_activation` (
7 `vkey` varchar(40) NOT NULL default '',
8 `vtime` datetime NOT NULL default '0000-00-00 00:00:00',
9 `vmember` int(11) NOT NULL default '0',
10 `vtype` varchar(15) NOT NULL default '',
11 `vextra` varchar(128) NOT NULL default '',
15 CREATE TABLE `nucleus_ban` (
16 `iprange` varchar(15) NOT NULL default '',
17 `reason` varchar(255) NOT NULL default '',
18 `blogid` int(11) NOT NULL default '0'
21 CREATE TABLE `nucleus_blog` (
22 `bnumber` int(11) NOT NULL auto_increment,
23 `bname` varchar(60) NOT NULL default '',
24 `bshortname` varchar(15) NOT NULL default '',
25 `bdesc` varchar(200) default NULL,
26 `bcomments` tinyint(2) NOT NULL default '1',
27 `bmaxcomments` int(11) NOT NULL default '0',
28 `btimeoffset` decimal(3,1) NOT NULL default '0.0',
29 `bnotify` varchar(128) default NULL,
30 `burl` varchar(100) default NULL,
31 `bupdate` varchar(60) default NULL,
32 `bdefskin` int(11) NOT NULL default '1',
33 `bpublic` tinyint(2) NOT NULL default '1',
34 `bconvertbreaks` tinyint(2) NOT NULL default '1',
35 `bdefcat` int(11) default NULL,
36 `bnotifytype` int(11) NOT NULL default '15',
37 `ballowpast` tinyint(2) NOT NULL default '0',
38 `bincludesearch` tinyint(2) NOT NULL default '0',
39 `breqemail` tinyint(2) NOT NULL default '0',
40 `bfuturepost` tinyint(2) NOT NULL default '0',
41 PRIMARY KEY (`bnumber`),
42 UNIQUE KEY `bshortname` (`bshortname`)
45 INSERT INTO `nucleus_blog` VALUES (
47 'My Nucleus CMS', /* bname */
48 'mynucleuscms', /* bshortname */
52 0.0, /* btimeoffset */
54 'http://localhost:8080/nucleus/', /* burl */
58 1, /* bconvertbreaks */
62 0, /* bincludesearch */
67 CREATE TABLE `nucleus_category` (
68 `catid` int(11) NOT NULL auto_increment,
69 `cblog` int(11) NOT NULL default '0',
70 `cname` varchar(200) default NULL,
71 `cdesc` varchar(200) default NULL,
75 INSERT INTO `nucleus_category` VALUES (1, 1, 'General', 'Items that do not fit in other categories');
77 CREATE TABLE `nucleus_comment` (
78 `cnumber` int(11) NOT NULL auto_increment,
79 `cbody` text NOT NULL,
80 `cuser` varchar(40) default NULL,
81 `cmail` varchar(100) default NULL,
82 `cemail` varchar(100),
83 `cmember` int(11) default NULL,
84 `citem` int(11) NOT NULL default '0',
85 `ctime` datetime NOT NULL default '0000-00-00 00:00:00',
86 `chost` varchar(60) default NULL,
87 `cip` varchar(15) NOT NULL default '',
88 `cblog` int(11) NOT NULL default '0',
89 PRIMARY KEY (`cnumber`),
90 KEY `citem` (`citem`),
91 FULLTEXT KEY `cbody` (`cbody`),
92 INDEX `cblog` (`cblog`)
95 CREATE TABLE `nucleus_config` (
96 `name` varchar(20) NOT NULL default '',
97 `value` varchar(128) default NULL,
101 INSERT INTO `nucleus_config` (`name`, `value`) VALUES
102 ('DefaultBlog', '1'),
103 ('AdminEmail', 'example@example.org'),
104 ('IndexURL', 'http://localhost:8080/nucleus/'),
105 ('Language', 'japanese-utf8'),
106 ('SessionCookie', ''),
107 ('AllowMemberCreate', ''),
108 ('AllowMemberMail', '1'),
109 ('SiteName', 'My Nucleus CMS'),
110 ('AdminURL', 'http://localhost:8080/nucleus/nucleus/'),
111 ('NewMemberCanLogon', '1'),
113 ('DisableSiteURL', 'http://www.this-page-intentionally-left-blank.org/'),
115 ('MediaURL', 'http://localhost:8080/nucleus/media/'),
116 ('AllowedTypes', 'jpg,jpeg,gif,mpg,mpeg,avi,mov,mp3,swf,png'),
117 ('AllowLoginEdit', ''),
118 ('AllowUpload', '1'),
119 ('DisableJsTools', '2'),
121 ('CookieDomain', ''),
122 ('CookieSecure', ''),
123 ('CookiePrefix', ''),
124 ('MediaPrefix', '1'),
125 ('MaxUploadSize', '1048576'),
126 ('NonmemberMail', ''),
127 ('PluginURL', 'http://localhost:8080/nucleus/nucleus/plugins/'),
128 ('ProtectMemNames', '1'),
130 ('SkinsURL', 'http://localhost:8080/nucleus/skins/'),
131 ('ActionURL', 'http://localhost:8080/nucleus/action.php'),
132 ('URLMode', 'normal'),
133 ('DatabaseVersion', '360'),
135 ('DefaultListSize', '10'),
136 ('AdminCSS', 'contemporary_jp');
138 CREATE TABLE `nucleus_item` (
139 `inumber` int(11) NOT NULL auto_increment,
140 `ititle` varchar(160) default NULL,
141 `ibody` text NOT NULL,
143 `iblog` int(11) NOT NULL default '0',
144 `iauthor` int(11) NOT NULL default '0',
145 `itime` datetime NOT NULL default '0000-00-00 00:00:00',
146 `iclosed` tinyint(2) NOT NULL default '0',
147 `idraft` tinyint(2) NOT NULL default '0',
148 `ikarmapos` int(11) NOT NULL default '0',
149 `icat` int(11) default NULL,
150 `ikarmaneg` int(11) NOT NULL default '0',
151 `iposted` tinyint(2) NOT NULL default '1',
152 PRIMARY KEY (`inumber`),
153 KEY `itime` (`itime`),
154 INDEX `iblog` (`iblog`),
\r
155 INDEX `idraft` (`idraft`),
\r
156 INDEX `icat` (`icat`),
157 FULLTEXT KEY `ibody` (`ibody`, `ititle`, `imore`)
158 ) TYPE=MyISAM PACK_KEYS=0;
160 CREATE TABLE `nucleus_karma` (
161 `itemid` int(11) NOT NULL default '0',
162 `ip` char(15) NOT NULL default ''
165 CREATE TABLE `nucleus_member` (
166 `mnumber` int(11) NOT NULL auto_increment,
167 `mname` varchar(32) NOT NULL default '',
168 `mrealname` varchar(60) default NULL,
169 `mpassword` varchar(40) NOT NULL default '',
170 `memail` varchar(60) default NULL,
171 `murl` varchar(100) default NULL,
172 `mnotes` varchar(100) default NULL,
173 `madmin` tinyint(2) NOT NULL default '0',
174 `mcanlogin` tinyint(2) NOT NULL default '1',
175 `mcookiekey` varchar(40) default NULL,
176 `deflang` varchar(20) NOT NULL default '',
177 `mautosave` tinyint(2) NOT NULL default '1',
178 PRIMARY KEY (`mnumber`),
179 UNIQUE KEY `mname` (`mname`)
182 INSERT INTO `nucleus_member` VALUES (
184 'example', /* mname */
185 'example', /* mrealname */
186 '1a79a4d60de6718e8e5b326e338ae533', /* mpassword */
187 'example@example.org', /* memail */
188 'http://localhost:8080/nucleus/', /* murl */
192 'd767aefc60415859570d64c649257f19', /* mcookiekey */
197 CREATE TABLE `nucleus_plugin` (
198 `pid` int(11) NOT NULL auto_increment,
199 `pfile` varchar(40) NOT NULL default '',
200 `porder` int(11) NOT NULL default '0',
202 KEY `porder` (`porder`)
205 CREATE TABLE `nucleus_plugin_event` (
206 `pid` int(11) NOT NULL default '0',
207 `event` varchar(40) default NULL,
211 CREATE TABLE `nucleus_plugin_option` (
212 `ovalue` text NOT NULL,
213 `oid` int(11) NOT NULL auto_increment,
214 `ocontextid` int(11) NOT NULL default '0',
215 PRIMARY KEY (`oid`, `ocontextid`)
218 CREATE TABLE `nucleus_plugin_option_desc` (
219 `oid` int(11) NOT NULL auto_increment,
220 `opid` int(11) NOT NULL default '0',
221 `oname` varchar(20) NOT NULL default '',
222 `ocontext` varchar(20) NOT NULL default '',
223 `odesc` varchar(255) default NULL,
224 `otype` varchar(20) default NULL,
227 PRIMARY KEY (`opid`, `oname`, `ocontext`),
228 UNIQUE KEY `oid` (`oid`)
231 CREATE TABLE `nucleus_skin` (
232 `sdesc` int(11) NOT NULL default '0',
233 `stype` varchar(20) NOT NULL default '',
234 `scontent` text NOT NULL,
235 PRIMARY KEY (`sdesc`,`stype`)
238 CREATE TABLE `nucleus_skin_desc` (
239 `sdnumber` int(11) NOT NULL auto_increment,
240 `sdname` varchar(20) NOT NULL default '',
241 `sddesc` varchar(200) default NULL,
242 `sdtype` varchar(40) NOT NULL default 'text/html',
243 `sdincmode` varchar(10) NOT NULL default 'normal',
244 `sdincpref` varchar(50) NOT NULL default '',
245 PRIMARY KEY (`sdnumber`),
246 UNIQUE KEY `sdname` (`sdname`)
249 CREATE TABLE `nucleus_team` (
250 `tmember` int(11) NOT NULL default '0',
251 `tblog` int(11) NOT NULL default '0',
252 `tadmin` tinyint(2) NOT NULL default '0',
253 PRIMARY KEY (`tmember`, `tblog`)
256 INSERT INTO `nucleus_team` VALUES (1, 1, 1);
258 CREATE TABLE `nucleus_template` (
259 `tdesc` int(11) NOT NULL default '0',
260 `tpartname` varchar(64) NOT NULL default '',
261 `tcontent` text NOT NULL,
262 PRIMARY KEY (`tdesc`, `tpartname`)
265 CREATE TABLE `nucleus_template_desc` (
266 `tdnumber` int(11) NOT NULL auto_increment,
267 `tdname` varchar(64) NOT NULL default '',
268 `tddesc` varchar(200) default NULL,
269 PRIMARY KEY (`tdnumber`),
270 UNIQUE KEY `tdname` (`tdname`)
273 CREATE TABLE `nucleus_tickets` (
274 `ticket` varchar(40) NOT NULL default '',
275 `ctime` datetime NOT NULL default '0000-00-00 00:00:00',
276 `member` int(11) NOT NULL default '0',
277 PRIMARY KEY (`ticket`,`member`)