1 CREATE TABLE nucleus_actionlog (
\r
2 timestamp datetime NOT NULL default '0000-00-00 00:00:00',
\r
3 message varchar(255) NOT NULL default ''
\r
4 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r
6 CREATE TABLE nucleus_activation (
\r
7 vkey varchar(40) NOT NULL default '',
\r
8 vtime datetime NOT NULL default '0000-00-00 00:00:00',
\r
9 vmember int(11) NOT NULL default '0',
\r
10 vtype varchar(15) NOT NULL default '',
\r
11 vextra varchar(128) NOT NULL default '',
\r
13 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r
15 CREATE TABLE nucleus_ban (
\r
16 iprange varchar(15) NOT NULL default '',
\r
17 reason varchar(255) NOT NULL default '',
\r
18 blogid int(11) NOT NULL default '0'
\r
19 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r
21 CREATE TABLE nucleus_blog (
\r
22 bnumber int(11) NOT NULL auto_increment,
\r
23 bname varchar(60) NOT NULL default '',
\r
24 bshortname varchar(15) NOT NULL default '',
\r
25 bdesc varchar(200) default NULL,
\r
26 bcomments tinyint(2) NOT NULL default '1',
\r
27 bmaxcomments int(11) NOT NULL default '0',
\r
28 btimeoffset decimal(3,1) NOT NULL default '0.0',
\r
29 bnotify varchar(128) default NULL,
\r
30 burl varchar(100) default NULL,
\r
31 bupdate varchar(60) default NULL,
\r
32 bdefskin int(11) NOT NULL default '1',
\r
33 bpublic tinyint(2) NOT NULL default '1',
\r
34 bconvertbreaks tinyint(2) NOT NULL default '1',
\r
35 bdefcat int(11) default NULL,
\r
36 bnotifytype int(11) NOT NULL default '15',
\r
37 ballowpast tinyint(2) NOT NULL default '0',
\r
38 bincludesearch tinyint(2) NOT NULL default '0',
\r
39 breqemail TINYINT( 2 ) DEFAULT '0' NOT NULL,
\r
40 bfuturepost TINYINT(2) DEFAULT '0' NOT NULL,
\r
41 PRIMARY KEY (bnumber),
\r
42 -- UNIQUE KEY bnumber (bnumber),
\r
43 UNIQUE KEY bshortname (bshortname)
\r
44 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r
46 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
48 CREATE TABLE nucleus_category (
\r
49 catid int(11) NOT NULL auto_increment,
\r
50 cblog int(11) NOT NULL default '0',
\r
51 cname varchar(200) default NULL,
\r
52 cdesc varchar(200) default NULL,
\r
54 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r
56 INSERT INTO nucleus_category VALUES (1, 1, 'General', 'Items that do not fit in other categories');
\r
58 CREATE TABLE nucleus_comment (
\r
59 cnumber int(11) NOT NULL auto_increment,
\r
60 cbody text NOT NULL,
\r
61 cuser varchar(40) default NULL,
\r
62 cmail varchar(100) default NULL,
\r
63 cemail VARCHAR( 100 ),
\r
64 cmember int(11) default NULL,
\r
65 citem int(11) NOT NULL default '0',
\r
66 ctime datetime NOT NULL default '0000-00-00 00:00:00',
\r
67 chost varchar(60) default NULL,
\r
68 cip varchar(15) NOT NULL default '',
\r
69 cblog int(11) NOT NULL default '0',
\r
70 PRIMARY KEY (cnumber),
\r
71 -- UNIQUE KEY cnumber (cnumber),
\r
73 FULLTEXT KEY cbody (cbody),
\r
75 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r
77 CREATE TABLE nucleus_config (
\r
78 name varchar(20) NOT NULL default '',
\r
79 value varchar(128) default NULL,
\r
81 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r
83 INSERT INTO nucleus_config VALUES ('DefaultBlog', '1');
\r
84 INSERT INTO nucleus_config VALUES ('AdminEmail', 'example@example.org');
\r
85 INSERT INTO nucleus_config VALUES ('IndexURL', 'http://localhost:8080/nucleus/');
\r
86 INSERT INTO nucleus_config VALUES ('Locale', 'en_Latn_US');
\r
87 INSERT INTO nucleus_config VALUES ('SessionCookie', '');
\r
88 INSERT INTO nucleus_config VALUES ('AllowMemberCreate', '');
\r
89 INSERT INTO nucleus_config VALUES ('AllowMemberMail', '1');
\r
90 INSERT INTO nucleus_config VALUES ('SiteName', 'My Nucleus CMS');
\r
91 INSERT INTO nucleus_config VALUES ('AdminURL', 'http://localhost:8080/nucleus/nucleus/');
\r
92 INSERT INTO nucleus_config VALUES ('NewMemberCanLogon', '1');
\r
93 INSERT INTO nucleus_config VALUES ('DisableSite', '');
\r
94 INSERT INTO nucleus_config VALUES ('DisableSiteURL', 'http://www.this-page-intentionally-left-blank.org/');
\r
95 INSERT INTO nucleus_config VALUES ('LastVisit', '');
\r
96 INSERT INTO nucleus_config VALUES ('MediaURL', 'http://localhost:8080/nucleus/media/');
\r
97 INSERT INTO nucleus_config VALUES ('AllowedTypes', 'jpg,jpeg,gif,mpg,mpeg,avi,mov,mp3,swf,png');
\r
98 INSERT INTO nucleus_config VALUES ('AllowLoginEdit', '');
\r
99 INSERT INTO nucleus_config VALUES ('AllowUpload', '1');
\r
100 INSERT INTO nucleus_config VALUES ('DisableJsTools', '2');
\r
101 INSERT INTO nucleus_config VALUES ('CookiePath', '/');
\r
102 INSERT INTO nucleus_config VALUES ('CookieDomain', '');
\r
103 INSERT INTO nucleus_config VALUES ('CookieSecure', '');
\r
104 INSERT INTO nucleus_config VALUES ('CookiePrefix', '');
\r
105 INSERT INTO nucleus_config VALUES ('MediaPrefix', '1');
\r
106 INSERT INTO nucleus_config VALUES ('MaxUploadSize', '1048576');
\r
107 INSERT INTO nucleus_config VALUES ('NonmemberMail', '');
\r
108 INSERT INTO nucleus_config VALUES ('PluginURL', 'http://localhost:8080/nucleus/nucleus/plugins/');
\r
109 INSERT INTO nucleus_config VALUES ('ProtectMemNames', '1');
\r
110 INSERT INTO nucleus_config VALUES ('BaseSkin', '5');
\r
111 INSERT INTO nucleus_config VALUES ('SkinsURL', 'http://localhost:8080/nucleus/skins/');
\r
112 INSERT INTO nucleus_config VALUES ('ActionURL', 'http://localhost:8080/nucleus/action.php');
\r
113 INSERT INTO nucleus_config VALUES ('URLMode', 'normal');
\r
114 INSERT INTO nucleus_config VALUES ('DatabaseVersion', '350');
\r
115 INSERT INTO nucleus_config VALUES ('DebugVars', '0');
\r
116 INSERT INTO nucleus_config VALUES ('DefaultListSize', '10');
\r
117 INSERT INTO nucleus_config VALUES ('AdminCSS', 'original');
\r
118 INSERT INTO nucleus_config VALUES ('AdminSkin', '0');
\r
119 INSERT INTO nucleus_config VALUES ('BookmarkletSkin', '0');
\r
121 CREATE TABLE nucleus_item (
\r
122 inumber int(11) NOT NULL auto_increment,
\r
123 ititle varchar(160) default NULL,
\r
124 ibody text NOT NULL,
\r
126 iblog int(11) NOT NULL default '0',
\r
127 iauthor int(11) NOT NULL default '0',
\r
128 itime datetime NOT NULL default '0000-00-00 00:00:00',
\r
129 iclosed tinyint(2) NOT NULL default '0',
\r
130 idraft tinyint(2) NOT NULL default '0',
\r
131 ikarmapos int(11) NOT NULL default '0',
\r
132 icat int(11) default NULL,
\r
133 ikarmaneg int(11) NOT NULL default '0',
\r
134 iposted tinyint(2) NOT NULL default '1',
\r
135 PRIMARY KEY (inumber),
\r
136 -- UNIQUE KEY inumber (inumber),
\r
138 INDEX iblog (iblog),
\r
139 INDEX idraft (idraft),
\r
141 FULLTEXT KEY ibody (ibody,ititle,imore)
\r
142 ) ENGINE=MyISAM PACK_KEYS=0 DEFAULT CHARSET=utf8;
\r
144 CREATE TABLE nucleus_karma (
\r
145 itemid int(11) NOT NULL default '0',
\r
146 ip char(15) NOT NULL default ''
\r
147 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r
149 CREATE TABLE nucleus_member (
\r
150 mnumber int(11) NOT NULL auto_increment,
\r
151 mname varchar(32) NOT NULL default '',
\r
152 mrealname varchar(60) default NULL,
\r
153 mpassword varchar(40) NOT NULL default '',
\r
154 memail varchar(60) default NULL,
\r
155 murl varchar(100) default NULL,
\r
156 mnotes varchar(100) default NULL,
\r
157 madmin tinyint(2) NOT NULL default '0',
\r
158 mcanlogin tinyint(2) NOT NULL default '1',
\r
159 mcookiekey varchar(40) default NULL,
\r
160 mlocale varchar(20) NOT NULL default '',
\r
161 mautosave tinyint(2) NOT NULL default '1',
\r
162 madminskin tinyint(2) NOT NULL default '0',
\r
163 mbkmklt tinyint(2) NOT NULL default '0',
\r
164 PRIMARY KEY (mnumber),
\r
165 -- UNIQUE KEY mnumber (mnumber),
\r
166 UNIQUE KEY mname (mname)
\r
167 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r
169 INSERT INTO nucleus_member VALUES (1, 'example', 'example', '1a79a4d60de6718e8e5b326e338ae533', 'example@example.org', 'http://localhost:8080/nucleus/', '', 1, 1, 'd767aefc60415859570d64c649257f19', '', 1, 0);
\r
171 CREATE TABLE nucleus_plugin (
\r
172 pid int(11) NOT NULL auto_increment,
\r
173 pfile varchar(40) NOT NULL default '',
\r
174 porder int(11) NOT NULL default '0',
\r
177 KEY porder (porder)
\r
178 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r
180 CREATE TABLE nucleus_plugin_event (
\r
181 pid int(11) NOT NULL default '0',
\r
182 event varchar(40) default NULL,
\r
184 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r
186 CREATE TABLE nucleus_plugin_option (
\r
187 ovalue text NOT NULL,
\r
188 oid int(11) NOT NULL auto_increment,
\r
189 ocontextid int(11) NOT NULL default '0',
\r
190 PRIMARY KEY (oid,ocontextid)
\r
191 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r
193 CREATE TABLE nucleus_plugin_option_desc (
\r
194 oid int(11) NOT NULL auto_increment,
\r
195 opid int(11) NOT NULL default '0',
\r
196 oname varchar(20) NOT NULL default '',
\r
197 ocontext varchar(20) NOT NULL default '',
\r
198 odesc varchar(255) default NULL,
\r
199 otype varchar(20) default NULL,
\r
202 PRIMARY KEY (opid,oname,ocontext),
\r
203 UNIQUE KEY oid (oid)
\r
204 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r
206 CREATE TABLE nucleus_skin (
\r
207 sdesc int(11) NOT NULL default '0',
\r
208 stype varchar(20) NOT NULL default '',
\r
209 scontent text NOT NULL,
\r
210 PRIMARY KEY (sdesc,stype)
\r
211 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r
213 -- 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
214 -- 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
215 -- 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
217 CREATE TABLE nucleus_skin_desc (
\r
218 sdnumber int(11) NOT NULL auto_increment,
\r
219 sdname varchar(20) NOT NULL default '',
\r
220 sddesc varchar(200) default NULL,
\r
221 sdtype varchar(40) NOT NULL default 'text/html',
\r
222 sdincmode varchar(10) NOT NULL default 'normal',
\r
223 sdincpref varchar(50) NOT NULL default '',
\r
224 PRIMARY KEY (sdnumber),
\r
225 -- UNIQUE KEY sdnumber (sdnumber),
\r
226 UNIQUE KEY sdname (sdname)
\r
227 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r
229 -- INSERT INTO nucleus_skin_desc VALUES (2, 'feeds/atom', 'Atom 1.0 weblog syndication', 'application/atom+xml', 'normal', '');
\r
230 -- INSERT INTO nucleus_skin_desc VALUES (3, 'feeds/rss20', 'RSS 2.0 syndication of weblogs', 'text/xml', 'normal', '');
\r
231 -- INSERT INTO nucleus_skin_desc VALUES (4, 'xml/rsd', 'RSD (Really Simple Discovery) information for weblog clients', 'text/xml', 'normal', '');
\r
232 -- INSERT INTO nucleus_skin_desc VALUES (5, 'default', 'Nucleus CMS default skin', 'text/html', 'skindir', 'default/');
\r
234 CREATE TABLE nucleus_team (
\r
235 tmember int(11) NOT NULL default '0',
\r
236 tblog int(11) NOT NULL default '0',
\r
237 tadmin tinyint(2) NOT NULL default '0',
\r
238 PRIMARY KEY (tmember,tblog)
\r
239 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r
241 INSERT INTO nucleus_team VALUES (1, 1, 1);
\r
243 CREATE TABLE nucleus_template (
\r
244 tdesc int(11) NOT NULL default '0',
\r
245 tpartname varchar(64) NOT NULL default '',
\r
246 tcontent text NOT NULL,
\r
247 PRIMARY KEY (tdesc,tpartname)
\r
248 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r
250 -- 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
251 -- INSERT INTO nucleus_template VALUES (3, 'EDITLINK', '<a href="<%editlink%>" onclick="<%editpopupcode%>">edit</a>');
\r
252 -- INSERT INTO nucleus_template VALUES (3, 'FORMAT_DATE', '%x');
\r
253 -- INSERT INTO nucleus_template VALUES (3, 'FORMAT_TIME', '%X');
\r
254 -- INSERT INTO nucleus_template VALUES (4, 'ITEM', '<%date(utc)%>');
\r
255 -- 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
256 -- INSERT INTO nucleus_template VALUES (5, 'POPUP_CODE', '<%media%>');
\r
257 -- INSERT INTO nucleus_template VALUES (5, 'IMAGE_CODE', '<%image%>');
\r
258 -- INSERT INTO nucleus_template VALUES (5, 'MEDIA_CODE', '<%media%>');
\r
259 -- INSERT INTO nucleus_template VALUES (3, 'POPUP_CODE', '<%image%>');
\r
260 -- INSERT INTO nucleus_template VALUES (3, 'MEDIA_CODE', '<%media%>');
\r
261 -- INSERT INTO nucleus_template VALUES (3, 'IMAGE_CODE', '<%media%>');
\r
263 CREATE TABLE nucleus_template_desc (
\r
264 tdnumber int(11) NOT NULL auto_increment,
\r
265 tdname varchar(64) NOT NULL default '',
\r
266 tddesc varchar(200) default NULL,
\r
267 PRIMARY KEY (tdnumber),
\r
268 -- UNIQUE KEY tdnumber (tdnumber),
\r
269 UNIQUE KEY tdname (tdname)
\r
270 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r
272 -- INSERT INTO nucleus_template_desc VALUES (4, 'feeds/atom/modified', 'Atom feeds: Inserts last modification date');
\r
273 -- INSERT INTO nucleus_template_desc VALUES (5, 'feeds/atom/entries', 'Atom feeds: Feed items');
\r
274 -- INSERT INTO nucleus_template_desc VALUES (3, 'feeds/rss20', 'Used for RSS 2.0 syndication of your blog');
\r
275 -- INSERT INTO nucleus_template_desc VALUES (8, 'default/index', 'Nucleus CMS default index template');
\r
276 -- INSERT INTO nucleus_template_desc VALUES (9, 'default/item', 'Nucleus CMS default item template');
\r
278 CREATE TABLE nucleus_tickets (
\r
279 ticket varchar(40) NOT NULL default '',
\r
280 ctime datetime NOT NULL default '0000-00-00 00:00:00',
\r
281 member int(11) NOT NULL default '0',
\r
282 PRIMARY KEY (ticket,member)
\r
283 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\r