[Summary view] [Print] [Text view]

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