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', '350'),
135 ('DefaultListSize', '10'),
136 ('AdminCSS', 'original');
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 FULLTEXT KEY `ibody` (`ibody`, `ititle`, `imore`)
155 ) TYPE=MyISAM PACK_KEYS=0;
157 CREATE TABLE `nucleus_karma` (
158 `itemid` int(11) NOT NULL default '0',
159 `ip` char(15) NOT NULL default ''
162 CREATE TABLE `nucleus_member` (
163 `mnumber` int(11) NOT NULL auto_increment,
164 `mname` varchar(32) NOT NULL default '',
165 `mrealname` varchar(60) default NULL,
166 `mpassword` varchar(40) NOT NULL default '',
167 `memail` varchar(60) default NULL,
168 `murl` varchar(100) default NULL,
169 `mnotes` varchar(100) default NULL,
170 `madmin` tinyint(2) NOT NULL default '0',
171 `mcanlogin` tinyint(2) NOT NULL default '1',
172 `mcookiekey` varchar(40) default NULL,
173 `deflang` varchar(20) NOT NULL default '',
174 `mautosave` tinyint(2) NOT NULL default '1',
175 PRIMARY KEY (`mnumber`),
176 UNIQUE KEY `mname` (`mname`)
179 INSERT INTO `nucleus_member` VALUES (
181 'example', /* mname */
182 'example', /* mrealname */
183 '1a79a4d60de6718e8e5b326e338ae533', /* mpassword */
184 'example@example.org', /* memail */
185 'http://localhost:8080/nucleus/', /* murl */
189 'd767aefc60415859570d64c649257f19', /* mcookiekey */
194 CREATE TABLE `nucleus_plugin` (
195 `pid` int(11) NOT NULL auto_increment,
196 `pfile` varchar(40) NOT NULL default '',
197 `porder` int(11) NOT NULL default '0',
199 KEY `porder` (`porder`)
202 CREATE TABLE `nucleus_plugin_event` (
203 `pid` int(11) NOT NULL default '0',
204 `event` varchar(40) default NULL,
208 CREATE TABLE `nucleus_plugin_option` (
209 `ovalue` text NOT NULL,
210 `oid` int(11) NOT NULL auto_increment,
211 `ocontextid` int(11) NOT NULL default '0',
212 PRIMARY KEY (`oid`, `ocontextid`)
215 CREATE TABLE `nucleus_plugin_option_desc` (
216 `oid` int(11) NOT NULL auto_increment,
217 `opid` int(11) NOT NULL default '0',
218 `oname` varchar(20) NOT NULL default '',
219 `ocontext` varchar(20) NOT NULL default '',
220 `odesc` varchar(255) default NULL,
221 `otype` varchar(20) default NULL,
224 PRIMARY KEY (`opid`, `oname`, `ocontext`),
225 UNIQUE KEY `oid` (`oid`)
228 CREATE TABLE `nucleus_skin` (
229 `sdesc` int(11) NOT NULL default '0',
230 `stype` varchar(20) NOT NULL default '',
231 `scontent` text NOT NULL,
232 PRIMARY KEY (`sdesc`,`stype`)
235 CREATE TABLE `nucleus_skin_desc` (
236 `sdnumber` int(11) NOT NULL auto_increment,
237 `sdname` varchar(20) NOT NULL default '',
238 `sddesc` varchar(200) default NULL,
239 `sdtype` varchar(40) NOT NULL default 'text/html',
240 `sdincmode` varchar(10) NOT NULL default 'normal',
241 `sdincpref` varchar(50) NOT NULL default '',
242 PRIMARY KEY (`sdnumber`),
243 UNIQUE KEY `sdname` (`sdname`)
246 CREATE TABLE `nucleus_team` (
247 `tmember` int(11) NOT NULL default '0',
248 `tblog` int(11) NOT NULL default '0',
249 `tadmin` tinyint(2) NOT NULL default '0',
250 PRIMARY KEY (`tmember`, `tblog`)
253 INSERT INTO `nucleus_team` VALUES (1, 1, 1);
255 CREATE TABLE `nucleus_template` (
256 `tdesc` int(11) NOT NULL default '0',
257 `tpartname` varchar(64) NOT NULL default '',
258 `tcontent` text NOT NULL,
259 PRIMARY KEY (`tdesc`, `tpartname`)
262 CREATE TABLE `nucleus_template_desc` (
263 `tdnumber` int(11) NOT NULL auto_increment,
264 `tdname` varchar(64) NOT NULL default '',
265 `tddesc` varchar(200) default NULL,
266 PRIMARY KEY (`tdnumber`),
267 UNIQUE KEY `tdname` (`tdname`)
270 CREATE TABLE `nucleus_tickets` (
271 `ticket` varchar(40) NOT NULL default '',
272 `ctime` datetime NOT NULL default '0000-00-00 00:00:00',
273 `member` int(11) NOT NULL default '0',
274 PRIMARY KEY (`ticket`,`member`)