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(60) 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`)
94 CREATE TABLE `nucleus_config` (
95 `name` varchar(20) NOT NULL default '',
96 `value` varchar(128) default NULL,
100 INSERT INTO `nucleus_config` (`name`, `value`) VALUES
101 ('DefaultBlog', '1'),
102 ('AdminEmail', 'example@example.org'),
103 ('IndexURL', 'http://localhost:8080/nucleus/'),
104 ('Language', 'japanese-utf8'),
105 ('SessionCookie', ''),
106 ('AllowMemberCreate', ''),
107 ('AllowMemberMail', '1'),
108 ('SiteName', 'My Nucleus CMS'),
109 ('AdminURL', 'http://localhost:8080/nucleus/nucleus/'),
110 ('NewMemberCanLogon', '1'),
112 ('DisableSiteURL', 'http://www.this-page-intentionally-left-blank.org/'),
114 ('MediaURL', 'http://localhost:8080/nucleus/media/'),
115 ('AllowedTypes', 'jpg,jpeg,gif,mpg,mpeg,avi,mov,mp3,swf,png'),
116 ('AllowLoginEdit', ''),
117 ('AllowUpload', '1'),
118 ('DisableJsTools', '2'),
120 ('CookieDomain', ''),
121 ('CookieSecure', ''),
122 ('CookiePrefix', ''),
123 ('MediaPrefix', '1'),
124 ('MaxUploadSize', '1048576'),
125 ('NonmemberMail', ''),
126 ('PluginURL', 'http://localhost:8080/nucleus/nucleus/plugins/'),
127 ('ProtectMemNames', '1'),
129 ('SkinsURL', 'http://localhost:8080/nucleus/skins/'),
130 ('ActionURL', 'http://localhost:8080/nucleus/action.php'),
131 ('URLMode', 'normal'),
132 ('DatabaseVersion', '340'),
134 ('DefaultListSize', '10');
136 CREATE TABLE `nucleus_item` (
137 `inumber` int(11) NOT NULL auto_increment,
138 `ititle` varchar(160) default NULL,
139 `ibody` text NOT NULL,
141 `iblog` int(11) NOT NULL default '0',
142 `iauthor` int(11) NOT NULL default '0',
143 `itime` datetime NOT NULL default '0000-00-00 00:00:00',
144 `iclosed` tinyint(2) NOT NULL default '0',
145 `idraft` tinyint(2) NOT NULL default '0',
146 `ikarmapos` int(11) NOT NULL default '0',
147 `icat` int(11) default NULL,
148 `ikarmaneg` int(11) NOT NULL default '0',
149 `iposted` tinyint(2) NOT NULL default '1',
150 PRIMARY KEY (`inumber`),
151 KEY `itime` (`itime`),
152 FULLTEXT KEY `ibody` (`ibody`, `ititle`, `imore`)
153 ) TYPE=MyISAM PACK_KEYS=0;
155 CREATE TABLE `nucleus_karma` (
156 `itemid` int(11) NOT NULL default '0',
157 `ip` char(15) NOT NULL default ''
160 CREATE TABLE `nucleus_member` (
161 `mnumber` int(11) NOT NULL auto_increment,
162 `mname` varchar(32) NOT NULL default '',
163 `mrealname` varchar(60) default NULL,
164 `mpassword` varchar(40) NOT NULL default '',
165 `memail` varchar(60) default NULL,
166 `murl` varchar(100) default NULL,
167 `mnotes` varchar(100) default NULL,
168 `madmin` tinyint(2) NOT NULL default '0',
169 `mcanlogin` tinyint(2) NOT NULL default '1',
170 `mcookiekey` varchar(40) default NULL,
171 `deflang` varchar(20) NOT NULL default '',
172 `mautosave` tinyint(2) NOT NULL default '1',
173 PRIMARY KEY (`mnumber`),
174 UNIQUE KEY `mname` (`mname`)
177 INSERT INTO `nucleus_member` VALUES (
179 'example', /* mname */
180 'example', /* mrealname */
181 '1a79a4d60de6718e8e5b326e338ae533', /* mpassword */
182 'example@example.org', /* memail */
183 'http://localhost:8080/nucleus/', /* murl */
187 'd767aefc60415859570d64c649257f19', /* mcookiekey */
192 CREATE TABLE `nucleus_plugin` (
193 `pid` int(11) NOT NULL auto_increment,
194 `pfile` varchar(40) NOT NULL default '',
195 `porder` int(11) NOT NULL default '0',
197 KEY `porder` (`porder`)
200 CREATE TABLE `nucleus_plugin_event` (
201 `pid` int(11) NOT NULL default '0',
202 `event` varchar(40) default NULL,
206 CREATE TABLE `nucleus_plugin_option` (
207 `ovalue` text NOT NULL,
208 `oid` int(11) NOT NULL auto_increment,
209 `ocontextid` int(11) NOT NULL default '0',
210 PRIMARY KEY (`oid`, `ocontextid`)
213 CREATE TABLE `nucleus_plugin_option_desc` (
214 `oid` int(11) NOT NULL auto_increment,
215 `opid` int(11) NOT NULL default '0',
216 `oname` varchar(20) NOT NULL default '',
217 `ocontext` varchar(20) NOT NULL default '',
218 `odesc` varchar(255) default NULL,
219 `otype` varchar(20) default NULL,
222 PRIMARY KEY (`opid`, `oname`, `ocontext`),
223 UNIQUE KEY `oid` (`oid`)
226 CREATE TABLE `nucleus_skin` (
227 `sdesc` int(11) NOT NULL default '0',
228 `stype` varchar(20) NOT NULL default '',
229 `scontent` text NOT NULL,
230 PRIMARY KEY (`sdesc`,`stype`)
233 CREATE TABLE `nucleus_skin_desc` (
234 `sdnumber` int(11) NOT NULL auto_increment,
235 `sdname` varchar(20) NOT NULL default '',
236 `sddesc` varchar(200) default NULL,
237 `sdtype` varchar(40) NOT NULL default 'text/html',
238 `sdincmode` varchar(10) NOT NULL default 'normal',
239 `sdincpref` varchar(50) NOT NULL default '',
240 PRIMARY KEY (`sdnumber`),
241 UNIQUE KEY `sdname` (`sdname`)
244 CREATE TABLE `nucleus_team` (
245 `tmember` int(11) NOT NULL default '0',
246 `tblog` int(11) NOT NULL default '0',
247 `tadmin` tinyint(2) NOT NULL default '0',
248 PRIMARY KEY (`tmember`, `tblog`)
251 INSERT INTO `nucleus_team` VALUES (1, 1, 1);
253 CREATE TABLE `nucleus_template` (
254 `tdesc` int(11) NOT NULL default '0',
255 `tpartname` varchar(64) NOT NULL default '',
256 `tcontent` text NOT NULL,
257 PRIMARY KEY (`tdesc`, `tpartname`)
260 CREATE TABLE `nucleus_template_desc` (
261 `tdnumber` int(11) NOT NULL auto_increment,
262 `tdname` varchar(64) NOT NULL default '',
263 `tddesc` varchar(200) default NULL,
264 PRIMARY KEY (`tdnumber`),
265 UNIQUE KEY `tdname` (`tdname`)
268 CREATE TABLE `nucleus_tickets` (
269 `ticket` varchar(40) NOT NULL default '',
270 `ctime` datetime NOT NULL default '0000-00-00 00:00:00',
271 `member` int(11) NOT NULL default '0',
272 PRIMARY KEY (`ticket`,`member`)