[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    `bsendping` tinyint(2) NOT NULL default '0',
  35    `bconvertbreaks` tinyint(2) NOT NULL default '1',
  36    `bdefcat` int(11) default NULL,
  37    `bnotifytype` int(11) NOT NULL default '15',
  38    `ballowpast` tinyint(2) NOT NULL default '0',
  39    `bincludesearch` tinyint(2) NOT NULL default '0',
  40    `breqemail` TINYINT( 2 ) DEFAULT '0' NOT NULL,
  41    `bfuturepost` TINYINT(2) DEFAULT '0' NOT NULL,
  42    PRIMARY KEY  (`bnumber`),
  43    UNIQUE KEY `bnumber` (`bnumber`),
  44    UNIQUE KEY `bshortname` (`bshortname`)
  45  ) TYPE=MyISAM;
  46  
  47  INSERT INTO `nucleus_blog` VALUES (1, 'My Nucleus CMS', 'mynucleuscms', '', 1, 0, 0.0, '', 'http://localhost:8080/nucleus/', '', 5, 1, 0, 1, 1, 1, 1, 0, 0, 0);
  48  
  49  CREATE TABLE `nucleus_category` (
  50    `catid` int(11) NOT NULL auto_increment,
  51    `cblog` int(11) NOT NULL default '0',
  52    `cname` varchar(200) default NULL,
  53    `cdesc` varchar(200) default NULL,
  54    PRIMARY KEY  (`catid`)
  55  ) TYPE=MyISAM;
  56  
  57  INSERT INTO `nucleus_category` VALUES (1, 1, 'General', 'Items that do not fit in other categories');
  58  
  59  CREATE TABLE `nucleus_comment` (
  60    `cnumber` int(11) NOT NULL auto_increment,
  61    `cbody` text NOT NULL,
  62    `cuser` varchar(40) default NULL,
  63    `cmail` varchar(100) default NULL,
  64    `cemail` VARCHAR( 100 ),
  65    `cmember` int(11) default NULL,
  66    `citem` int(11) NOT NULL default '0',
  67    `ctime` datetime NOT NULL default '0000-00-00 00:00:00',
  68    `chost` varchar(60) default NULL,
  69    `cip` varchar(15) NOT NULL default '',
  70    `cblog` int(11) NOT NULL default '0',
  71    PRIMARY KEY  (`cnumber`),
  72    UNIQUE KEY `cnumber` (`cnumber`),
  73    KEY `citem` (`citem`),
  74    FULLTEXT KEY `cbody` (`cbody`)
  75  ) TYPE=MyISAM;
  76  
  77  CREATE TABLE `nucleus_config` (
  78    `name` varchar(20) NOT NULL default '',
  79    `value` varchar(128) default NULL,
  80    PRIMARY KEY  (`name`)
  81  ) TYPE=MyISAM;
  82  
  83  INSERT INTO `nucleus_config` VALUES ('DefaultBlog', '1');
  84  INSERT INTO `nucleus_config` VALUES ('AdminEmail', 'example@example.org');
  85  INSERT INTO `nucleus_config` VALUES ('IndexURL', 'http://localhost:8080/nucleus/');
  86  INSERT INTO `nucleus_config` VALUES ('Language', 'english');
  87  INSERT INTO `nucleus_config` VALUES ('SessionCookie', '');
  88  INSERT INTO `nucleus_config` VALUES ('AllowMemberCreate', '');
  89  INSERT INTO `nucleus_config` VALUES ('AllowMemberMail', '1');
  90  INSERT INTO `nucleus_config` VALUES ('SiteName', 'My Nucleus CMS');
  91  INSERT INTO `nucleus_config` VALUES ('AdminURL', 'http://localhost:8080/nucleus/nucleus/');
  92  INSERT INTO `nucleus_config` VALUES ('NewMemberCanLogon', '1');
  93  INSERT INTO `nucleus_config` VALUES ('DisableSite', '');
  94  INSERT INTO `nucleus_config` VALUES ('DisableSiteURL', 'http://www.this-page-intentionally-left-blank.org/');
  95  INSERT INTO `nucleus_config` VALUES ('LastVisit', '');
  96  INSERT INTO `nucleus_config` VALUES ('MediaURL', 'http://localhost:8080/nucleus/media/');
  97  INSERT INTO `nucleus_config` VALUES ('AllowedTypes', 'jpg,jpeg,gif,mpg,mpeg,avi,mov,mp3,swf,png');
  98  INSERT INTO `nucleus_config` VALUES ('AllowLoginEdit', '');
  99  INSERT INTO `nucleus_config` VALUES ('AllowUpload', '1');
 100  INSERT INTO `nucleus_config` VALUES ('DisableJsTools', '2');
 101  INSERT INTO `nucleus_config` VALUES ('CookiePath', '/');
 102  INSERT INTO `nucleus_config` VALUES ('CookieDomain', '');
 103  INSERT INTO `nucleus_config` VALUES ('CookieSecure', '');
 104  INSERT INTO `nucleus_config` VALUES ('CookiePrefix', '');
 105  INSERT INTO `nucleus_config` VALUES ('MediaPrefix', '1');
 106  INSERT INTO `nucleus_config` VALUES ('MaxUploadSize', '1048576');
 107  INSERT INTO `nucleus_config` VALUES ('NonmemberMail', '');
 108  INSERT INTO `nucleus_config` VALUES ('PluginURL', 'http://localhost:8080/nucleus/nucleus/plugins/');
 109  INSERT INTO `nucleus_config` VALUES ('ProtectMemNames', '1');
 110  INSERT INTO `nucleus_config` VALUES ('BaseSkin', '5');
 111  INSERT INTO `nucleus_config` VALUES ('SkinsURL', 'http://localhost:8080/nucleus/skins/');
 112  INSERT INTO `nucleus_config` VALUES ('ActionURL', 'http://localhost:8080/nucleus/action.php');
 113  INSERT INTO `nucleus_config` VALUES ('URLMode', 'normal');
 114  INSERT INTO `nucleus_config` VALUES ('DatabaseVersion', '330');
 115  
 116  CREATE TABLE `nucleus_item` (
 117    `inumber` int(11) NOT NULL auto_increment,
 118    `ititle` varchar(160) default NULL,
 119    `ibody` text NOT NULL,
 120    `imore` text,
 121    `iblog` int(11) NOT NULL default '0',
 122    `iauthor` int(11) NOT NULL default '0',
 123    `itime` datetime NOT NULL default '0000-00-00 00:00:00',
 124    `iclosed` tinyint(2) NOT NULL default '0',
 125    `idraft` tinyint(2) NOT NULL default '0',
 126    `ikarmapos` int(11) NOT NULL default '0',
 127    `icat` int(11) default NULL,
 128    `ikarmaneg` int(11) NOT NULL default '0',
 129    `iposted` tinyint(2) NOT NULL default '1',
 130    PRIMARY KEY  (`inumber`),
 131    UNIQUE KEY `inumber` (`inumber`),
 132    KEY `itime` (`itime`),
 133    FULLTEXT KEY `ibody` (`ibody`,`ititle`,`imore`)
 134  ) TYPE=MyISAM PACK_KEYS=0;
 135  
 136  INSERT INTO `nucleus_item` VALUES (1, 'Welcome to Nucleus CMS v3.3', 'This is the first post on your Nucleus CMS. Nucleus offers you the building blocks you need to create a web presence. Whether you want to create a personal blog, a family page, or an online business site, Nucleus CMS can help you achieve your goals.<br />
 137  <br />
 138  We\'ve loaded this first entry with links and information to get you started. Though you can delete this entry, it will eventually scroll off the main page as you add content to your site. Add your comments while you learn to work with Nucleus CMS, or bookmark this page so you can come back to it when you need to.', '<b>Home - <a href=\"http://nucleuscms.org/\" title=\"Nucleus CMS home\">nucleuscms.org</a></b><br />
 139  Welcome to the world of Nucleus CMS. In 2001 a set of PHP scripts were let loose on the open Internet. Those scripts, which took user-generated data and used it to dynamically create html pages, contained the ideas and the algorithms that are the core of today’s Nucleus CMS. Though Nucleus CMS 3.3 is far more flexible and powerful than the scripts from which it emerged, it still expresses the values that guided its birth: flexibility, security, and computational elegance.<br />
 140  <br />
 141  Thanks to an international community of sophisticated developers and designers, Nucleus CMS remains simple enough for anyone to learn, and expandable enough to allow you to build almost any website you can imagine. Nucleus CMS lets you integrate text, images, and user comments in a seamless package that will make your web presence as serious, professional, personal, or fun as you want it to be. We hope you enjoy its power.<br />
 142  <br />
 143  <b>Documentation - <a href=\"http://docs.nucleuscms.org/\" title=\"Nucleus CMS Documentation\">docs.nucleuscms.org</a></b><br />
 144  The install process places a <a href=\"nucleus/documentation/\">user</a> and a <a href=\"nucleus/documentation/devdocs/\">developer</a> documentation on your web server. Pop-up <a href=\"/nucleus/documentation/help.html\">help</a> is available throughout the administration area to assist you in maintaining and customizing your site. When in the Nucleus CMS admin area, click on this symbol <img src=\"nucleus/documentation/icon-help.gif\" width=\"15\" height=\"15\" alt=\"help icon\" /> for context-sensitive help. You can also read this documentation online under <a href=\"http://docs.nucleuscms.org/\" title=\"Nucleus CMS Documentation\">docs.nucleuscms.org</a>.<br />
 145  <br />
 146  <b>Frequently Asked Questions - <a nicetitle=\"Nucleus CMS FAQ\" href=\"http://faq.nucleuscms.org/\">faq.nucleuscms.org</a></b><br />
 147  If you need more information about managing, extending or troubleshooting your Nucleus CMS the Nucleus FAQ is the first place to search information. Over 170 frequently asked questions are answered from experienced Nucleus users.<br />
 148  <br />
 149  <b>Support - <a href=\"http://forum.nucleuscms.org/\" title=\"Nucleus CMS Support Forum\">forum.nucleuscms.org</a></b><br />
 150  Should you require assistance, please don\'t hesitate to <a href=\"http://forum.nucleuscms.org/faq.php\">join</a> the 6,800+ registered users on our forums. With its built-in search capability of the 73,000+ posted articles, your answers are just a few clicks away. Remember: almost any question you think of has already been asked on the forums, and almost anything you want to do with Nucleus has been tried and explained there. Be sure to check them out.<br />
 151  <br />
 152  <b>Demonstration - <a href=\"http://demo.nucleuscms.org/\" title=\"Nucleus CMS Demonstration\">demo.nucleuscms.org</a></b><br />
 153  Want to play around, test changes or tell a friend or relative about Nucleus CMS? Visit our live <a href=\"http://demo.nucleuscms.org/\">demo site</a>.<br />
 154  <br />
 155  <b>Skins - <a href=\"http://skins.nucleuscms.org/\" title=\"Nucleus CMS Skins\">skins.nucleuscms.org</a></b><br />
 156  The combination of multi-weblogs and skins/templates make for a powerful duo in personalizing your site or designing one for a friend, relative or business client. Import new skins to change the look of your website, or create your own skins and share them with the Nucleus community! Help designing or modifying skins is only a few clicks away in the Nucleus forums.<br />
 157  <br />
 158  <b>Plugins - <a href=\"http://plugins.nucleuscms.org/\" title=\"Nucleus plugins\">plugins.nucleuscms.org</a></b><br />
 159  Looking to add some extra functionality to the base Nucleus CMS package? Our <a href=\"http://wiki.nucleuscms.org/plugin\">plugin repository</a> gives you plenty of ways to extend and expand what Nucleus CMS can do; your imagination and creativity are the only limit on how Nucleus CMS can work for you.<br />
 160  <br />
 161  <b>Development - <a href=\"http://dev.nucleuscms.org/\" title=\"Nucleus Development\">dev.nucleuscms.org</a></b><br />
 162  If you need more information about the Nucleus development you can find Informations in the developer documents at <a href=\"http://dev.nucleuscms.org/\" title=\"Nucleus Development\">dev.nucleuscms.org</a> or in the <a href=\"http://forum.nucleuscms.org/\">Support Forum</a>. Sourceforge.net graciously hosts our <a href=\"http://sourceforge.net/projects/nucleuscms/\">Open Source project page</a> which contains our software downloads and CVS repository.<br />
 163  <br />
 164  <b>Donators</b><br />
 165  We would like to thank these <a href=\"http://nucleuscms.org/donators.php\">nice people</a> for their <a href=\"http://nucleuscms.org/donate.php\">support</a>. <em>Thanks all!</em><br />
 166  <br />
 167  <b>Vote for Nucleus CMS</b><br />
 168  Like Nucleus CMS? Vote for us at <a href=\"http://www.hotscripts.com/Detailed/13368.html?RID=nucleus@demuynck.org\">HotScripts</a> and <a href=\"http://www.opensourcecms.com/index.php?option=content&task=view&id=145\">opensourceCMS</a>.<br />
 169  <br />
 170  <b>License</b><br />
 171  When we speak of free software, we are referring to freedom, not price. Our <a href=\"http://www.gnu.org/licenses/gpl.html\">General Public Licenses</a> are designed to make sure that you have the freedom to distribute copies of free software (and charge for this service if you wish), that you receive source code or can get it if you want it, that you can change the software or use pieces of it in new free programs; and that you know you can do these things.', 1, 1, '2005-08-15 11:04:26', 0, 0, 0, 1, 0, 1);
 172  
 173  CREATE TABLE `nucleus_karma` (
 174    `itemid` int(11) NOT NULL default '0',
 175    `ip` char(15) NOT NULL default ''
 176  ) TYPE=MyISAM;
 177  
 178  CREATE TABLE `nucleus_member` (
 179    `mnumber` int(11) NOT NULL auto_increment,
 180    `mname` varchar(16) NOT NULL default '',
 181    `mrealname` varchar(60) default NULL,
 182    `mpassword` varchar(40) NOT NULL default '',
 183    `memail` varchar(60) default NULL,
 184    `murl` varchar(100) default NULL,
 185    `mnotes` varchar(100) default NULL,
 186    `madmin` tinyint(2) NOT NULL default '0',
 187    `mcanlogin` tinyint(2) NOT NULL default '1',
 188    `mcookiekey` varchar(40) default NULL,
 189    `deflang` varchar(20) NOT NULL default '',
 190    PRIMARY KEY  (`mnumber`),
 191    UNIQUE KEY `mname` (`mname`),
 192    UNIQUE KEY `mnumber` (`mnumber`)
 193  ) TYPE=MyISAM;
 194  
 195  INSERT INTO `nucleus_member` VALUES (1, 'example', 'example', '1a79a4d60de6718e8e5b326e338ae533', 'example@example.org', 'http://localhost:8080/nucleus/', '', 1, 1, 'd767aefc60415859570d64c649257f19', '');
 196  
 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',
 201    PRIMARY KEY  (`pid`),
 202    KEY `pid` (`pid`),
 203    KEY `porder` (`porder`)
 204  ) TYPE=MyISAM;
 205  
 206  CREATE TABLE `nucleus_plugin_event` (
 207    `pid` int(11) NOT NULL default '0',
 208    `event` varchar(40) default NULL,
 209    KEY `pid` (`pid`)
 210  ) TYPE=MyISAM;
 211  
 212  CREATE TABLE `nucleus_plugin_option` (
 213    `ovalue` text NOT NULL,
 214    `oid` int(11) NOT NULL auto_increment,
 215    `ocontextid` int(11) NOT NULL default '0',
 216    PRIMARY KEY  (`oid`,`ocontextid`)
 217  ) TYPE=MyISAM;
 218  
 219  CREATE TABLE `nucleus_plugin_option_desc` (
 220    `oid` int(11) NOT NULL auto_increment,
 221    `opid` int(11) NOT NULL default '0',
 222    `oname` varchar(20) NOT NULL default '',
 223    `ocontext` varchar(20) NOT NULL default '',
 224    `odesc` varchar(255) default NULL,
 225    `otype` varchar(20) default NULL,
 226    `odef` text,
 227    `oextra` text,
 228    PRIMARY KEY  (`opid`,`oname`,`ocontext`),
 229    UNIQUE KEY `oid` (`oid`)
 230  ) TYPE=MyISAM;
 231  
 232  CREATE TABLE `nucleus_skin` (
 233    `sdesc` int(11) NOT NULL default '0',
 234    `stype` varchar(20) NOT NULL default '',
 235    `scontent` text NOT NULL,
 236    PRIMARY KEY  (`sdesc`,`stype`)
 237  ) TYPE=MyISAM;
 238  
 239  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>');
 240  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>');
 241  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>');
 242  
 243  CREATE TABLE `nucleus_skin_desc` (
 244    `sdnumber` int(11) NOT NULL auto_increment,
 245    `sdname` varchar(20) NOT NULL default '',
 246    `sddesc` varchar(200) default NULL,
 247    `sdtype` varchar(40) NOT NULL default 'text/html',
 248    `sdincmode` varchar(10) NOT NULL default 'normal',
 249    `sdincpref` varchar(50) NOT NULL default '',
 250    PRIMARY KEY  (`sdnumber`),
 251    UNIQUE KEY `sdname` (`sdname`),
 252    UNIQUE KEY `sdnumber` (`sdnumber`)
 253  ) TYPE=MyISAM;
 254  
 255  INSERT INTO `nucleus_skin_desc` VALUES (2, 'feeds/atom', 'Atom 1.0 weblog syndication', 'application/atom+xml', 'normal', '');
 256  INSERT INTO `nucleus_skin_desc` VALUES (3, 'feeds/rss20', 'RSS 2.0 syndication of weblogs', 'text/xml', 'normal', '');
 257  INSERT INTO `nucleus_skin_desc` VALUES (4, 'xml/rsd', 'RSD (Really Simple Discovery) information for weblog clients', 'text/xml', 'normal', '');
 258  INSERT INTO `nucleus_skin_desc` VALUES (5, 'default', 'Nucleus CMS default skin', 'text/html', 'skindir', 'default/');
 259  
 260  CREATE TABLE `nucleus_team` (
 261    `tmember` int(11) NOT NULL default '0',
 262    `tblog` int(11) NOT NULL default '0',
 263    `tadmin` tinyint(2) NOT NULL default '0',
 264    PRIMARY KEY  (`tmember`,`tblog`)
 265  ) TYPE=MyISAM;
 266  
 267  INSERT INTO `nucleus_team` VALUES (1, 1, 1);
 268  
 269  CREATE TABLE `nucleus_template` (
 270    `tdesc` int(11) NOT NULL default '0',
 271    `tpartname` varchar(20) NOT NULL default '',
 272    `tcontent` text NOT NULL,
 273    PRIMARY KEY  (`tdesc`,`tpartname`)
 274  ) TYPE=MyISAM;
 275  
 276  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>');
 277  INSERT INTO `nucleus_template` VALUES (3, 'EDITLINK', '<a href="<%editlink%>" onclick="<%editpopupcode%>">edit</a>');
 278  INSERT INTO `nucleus_template` VALUES (3, 'FORMAT_DATE', '%x');
 279  INSERT INTO `nucleus_template` VALUES (3, 'FORMAT_TIME', '%X');
 280  INSERT INTO `nucleus_template` VALUES (4, 'ITEM', '<%date(utc)%>');
 281  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>');
 282  INSERT INTO `nucleus_template` VALUES (5, 'POPUP_CODE', '<%media%>');
 283  INSERT INTO `nucleus_template` VALUES (5, 'IMAGE_CODE', '<%image%>');
 284  INSERT INTO `nucleus_template` VALUES (5, 'MEDIA_CODE', '<%media%>');
 285  INSERT INTO `nucleus_template` VALUES (3, 'POPUP_CODE', '<%image%>');
 286  INSERT INTO `nucleus_template` VALUES (3, 'MEDIA_CODE', '<%media%>');
 287  INSERT INTO `nucleus_template` VALUES (3, 'IMAGE_CODE', '<%media%>');
 288  
 289  CREATE TABLE `nucleus_template_desc` (
 290    `tdnumber` int(11) NOT NULL auto_increment,
 291    `tdname` varchar(20) NOT NULL default '',
 292    `tddesc` varchar(200) default NULL,
 293    PRIMARY KEY  (`tdnumber`),
 294    UNIQUE KEY `tdnumber` (`tdnumber`),
 295    UNIQUE KEY `tdname` (`tdname`)
 296  ) TYPE=MyISAM;
 297  
 298  INSERT INTO `nucleus_template_desc` VALUES (4, 'feeds/atom/modified', 'Atom feeds: Inserts last modification date');
 299  INSERT INTO `nucleus_template_desc` VALUES (5, 'feeds/atom/entries', 'Atom feeds: Feed items');
 300  INSERT INTO `nucleus_template_desc` VALUES (3, 'feeds/rss20', 'Used for RSS 2.0 syndication of your blog');
 301  INSERT INTO `nucleus_template_desc` VALUES (8, 'default/index', 'Nucleus CMS default index template');
 302  INSERT INTO `nucleus_template_desc` VALUES (9, 'default/item', 'Nucleus CMS default item template');
 303  
 304  CREATE TABLE `nucleus_tickets` (
 305    `ticket` varchar(40) NOT NULL default '',
 306    `ctime` datetime NOT NULL default '0000-00-00 00:00:00',
 307    `member` int(11) NOT NULL default '0',
 308    PRIMARY KEY  (`ticket`,`member`)
 309  ) TYPE=MyISAM;