CREATE TABLE nucleus_actionlog (
  timestamp datetime NOT NULL default '0000-00-00 00:00:00',
  message varchar(255) NOT NULL default '',
  PRIMARY KEY  (timestamp)
) TYPE=MyISAM;

CREATE TABLE nucleus_ban (
  iprange varchar(15) NOT NULL default '',
  reason varchar(255) NOT NULL default '',
  blogid int(11) NOT NULL default '0'
) TYPE=MyISAM;

CREATE TABLE nucleus_blog (
  bnumber int(11) NOT NULL auto_increment,
  bname varchar(60) NOT NULL default '',
  bshortname varchar(15) NOT NULL default '',
  bdesc varchar(200) default NULL,
  bcomments tinyint(2) NOT NULL default '1',
  bmaxcomments int(11) NOT NULL default '0',
  btimeoffset int(11) NOT NULL default '0',
  bnotify varchar(60) default NULL,
  burl varchar(100) default NULL,
  bupdate varchar(60) default NULL,
  bdefskin int(11) NOT NULL default '1',
  bpublic tinyint(2) NOT NULL default '1',
  bsendping tinyint(2) NOT NULL default '0',
  bconvertbreaks tinyint(2) NOT NULL default '1',
  bdefcat int(11) default NULL,
  bnotifytype int(11) NOT NULL default '15',
  PRIMARY KEY  (bnumber),
  UNIQUE KEY bnumber (bnumber),
  UNIQUE KEY bshortname (bshortname)
) TYPE=MyISAM;

INSERT INTO nucleus_blog VALUES (1, 'My Nucleus Weblog', 'myweblog', '', 1, 0, 0, '', 'http://localhost/release/', '', 1, 1, 0, 1, 1, 1);

CREATE TABLE nucleus_category (
  catid int(11) NOT NULL auto_increment,
  cblog int(11) NOT NULL default '0',
  cname varchar(40) default NULL,
  cdesc varchar(200) default NULL,
  PRIMARY KEY  (catid)
) TYPE=MyISAM;

INSERT INTO nucleus_category VALUES (1, 1, 'General', 'Items that do not fit in other categories');

CREATE TABLE nucleus_comment (
  cnumber int(11) NOT NULL auto_increment,
  cbody text NOT NULL,
  cuser varchar(40) default NULL,
  cmail varchar(40) default NULL,
  cmember int(11) default NULL,
  citem int(11) NOT NULL default '0',
  ctime datetime NOT NULL default '0000-00-00 00:00:00',
  chost varchar(60) default NULL,
  cip varchar(15) NOT NULL default '',
  cblog int(11) NOT NULL default '0',
  PRIMARY KEY  (cnumber),
  UNIQUE KEY cnumber (cnumber),
  KEY citem (citem)
) TYPE=MyISAM;

CREATE TABLE nucleus_config (
  name varchar(20) NOT NULL default '',
  value varchar(128) default NULL,
  PRIMARY KEY  (name)
) TYPE=MyISAM;

INSERT INTO nucleus_config VALUES ('DefaultBlog', '1');
INSERT INTO nucleus_config VALUES ('AdminEmail', 'you@yourprovider.com');
INSERT INTO nucleus_config VALUES ('IndexURL', 'http://localhost/release/');
INSERT INTO nucleus_config VALUES ('Language', 'english');
INSERT INTO nucleus_config VALUES ('SessionCookie', '0');
INSERT INTO nucleus_config VALUES ('AllowMemberCreate', '0');
INSERT INTO nucleus_config VALUES ('AllowMemberMail', '1');
INSERT INTO nucleus_config VALUES ('SiteName', 'My Nucleus Site');
INSERT INTO nucleus_config VALUES ('AdminURL', 'http://localhost/release/nucleus/');
INSERT INTO nucleus_config VALUES ('NewMemberCanLogon', '1');
INSERT INTO nucleus_config VALUES ('DisableSite', '0');
INSERT INTO nucleus_config VALUES ('DisableSiteURL', 'http://www.this-page-intentionally-left-blank.org/');
INSERT INTO nucleus_config VALUES ('LastVisit', '0');
INSERT INTO nucleus_config VALUES ('MediaURL', 'http://localhost/release/media/');
INSERT INTO nucleus_config VALUES ('AllowedTypes', 'jpg,jpeg,gif,mpg,mpeg,avi,mov,mp3,swf,png');
INSERT INTO nucleus_config VALUES ('AllowLoginEdit', '0');
INSERT INTO nucleus_config VALUES ('AllowUpload', '1');
INSERT INTO nucleus_config VALUES ('DisableJsTools', '0');
INSERT INTO nucleus_config VALUES ('CookiePath', '/');
INSERT INTO nucleus_config VALUES ('CookieDomain', '');
INSERT INTO nucleus_config VALUES ('CookieSecure', '0');
INSERT INTO nucleus_config VALUES ('MediaPrefix', '1');
INSERT INTO nucleus_config VALUES ('MaxUploadSize', '1048576');
INSERT INTO nucleus_config VALUES ('NonmemberMail', '0');
INSERT INTO nucleus_config VALUES ('PluginURL', 'http://localhost/release/nucleus/plugins/');
INSERT INTO nucleus_config VALUES ('ProtectMemNames', '1');

CREATE TABLE nucleus_item (
  inumber int(11) NOT NULL auto_increment,
  ititle varchar(160) default NULL,
  ibody text NOT NULL,
  imore text,
  iblog int(11) NOT NULL default '0',
  iauthor int(11) NOT NULL default '0',
  itime datetime NOT NULL default '0000-00-00 00:00:00',
  iclosed tinyint(2) NOT NULL default '0',
  idraft tinyint(2) NOT NULL default '0',
  ikarma int(11) NOT NULL default '0',
  icat int(11) default NULL,
  PRIMARY KEY  (inumber),
  UNIQUE KEY inumber (inumber),
  KEY itime (itime)
) TYPE=MyISAM;

INSERT INTO nucleus_item VALUES (1, 'First Item!', 'This is the first item in your weblog. Feel free to delete it.', '', 1, 1, '2001-09-04 14:47:39', 0, 0, 0, 1);

CREATE TABLE nucleus_karma (
  itemid int(11) NOT NULL default '0',
  ip char(15) NOT NULL default ''
) TYPE=MyISAM;

CREATE TABLE nucleus_member (
  mnumber int(11) NOT NULL auto_increment,
  mname varchar(16) NOT NULL default '',
  mrealname varchar(60) default NULL,
  mpassword varchar(40) NOT NULL default '',
  memail varchar(60) default NULL,
  murl varchar(100) default NULL,
  mnotes varchar(100) default NULL,
  madmin tinyint(2) NOT NULL default '0',
  mcanlogin tinyint(2) NOT NULL default '1',
  mcookiekey varchar(40) default NULL,
  deflang varchar(20) NOT NULL default '',
  PRIMARY KEY  (mnumber),
  UNIQUE KEY mnumber (mnumber),
  UNIQUE KEY mname (mname)
) TYPE=MyISAM;

INSERT INTO nucleus_member VALUES (1, 'God', 'God In Heaven', 'eb31870669f13fd8444c2bc918375f09', 'nucleus@demuynck.org', 'http://nucleuscms.org/', '', 1, 1, '0c21951a4820fa8ccb3f59ca5670b17c', '');

CREATE TABLE nucleus_plugin (
  pid int(11) NOT NULL auto_increment,
  pfile varchar(40) NOT NULL default '',
  porder int(11) NOT NULL default '0',
  PRIMARY KEY  (pid),
  KEY pid (pid),
  KEY porder (porder)
) TYPE=MyISAM;

CREATE TABLE nucleus_plugin_event (
  pid int(11) NOT NULL default '0',
  event varchar(40) default NULL,
  KEY pid (pid)
) TYPE=MyISAM;

CREATE TABLE nucleus_plugin_option (
  opid int(11) NOT NULL default '0',
  oname varchar(20) NOT NULL default '',
  ovalue varchar(128) NOT NULL default '',
  odesc varchar(255) default NULL,
  otype varchar(8) default NULL,
  PRIMARY KEY  (opid,oname)
) TYPE=MyISAM;

CREATE TABLE nucleus_skin (
  sdesc int(11) NOT NULL default '0',
  stype varchar(20) NOT NULL default '',
  scontent text NOT NULL,
  PRIMARY KEY  (sdesc,stype)
) TYPE=MyISAM;

INSERT INTO nucleus_skin VALUES (1, 'item', '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\r\n\r\n<html>\r\n<head>\r\n  <title><%blogsetting(name)%></title>\r\n\r\n  <!-- some meta information (search engines might read this) -->\r\n  <meta name="generator" content="<%version%>" />\r\n  <meta name="description" content="<%blogsetting(desc)%>" />\r\n\r\n  <!-- stylesheet definition (points to the place where colors -->\r\n  <!-- and layout is defined -->\r\n  <link rel="stylesheet" type="text/css" href="default.css" />\r\n\r\n  <!-- prevent caching (can be removed) -->\r\n  <meta http-equiv="Pragma" content="no-cache" />\r\n  <meta http-equiv="Cache-Control" content="no-cache, must-revalidate" />\r\n  <meta http-equiv="Expires" content="-1" />\r\n  \r\n  <!-- extra navigational links -->\r\n  <link rel="bookmark" title="Nucleus" href="http://www.nucleuscms.org/" />\r\n  <link rel="alternate" type="application/xml+rss" title="RSS" href="xml-rss.php" />\r\n  <link rel="archives" title="Archives" href="<%archivelink%>" />\r\n  <link rel="top" title="Today" href="<%sitevar(url)%>" />\r\n  <link rel="next" href="<%nextlink%>" title="Next Item" />\r\n  <link rel="prev" href="<%prevlink%>" title="Previous Item" />\r\n  <link rel="up" href="<%todaylink%>" title="Today" />\r\n\r\n</head>\r\n<body>\r\n\r\n<!-- here starts the code that will be displayed in your browser -->\r\n<div class="contents">\r\n\r\n <!-- page title -->\r\n <h1><%blogsetting(name)%></h1>\r\n\r\n <!-- this is a normally hidden link, included for accessibility reasons -->\r\n <a href="#navigation" class="skip">Jump to navigation</a>\r\n\r\n <!-- inserts the selected item using the template named \'detailed\' -->\r\n <%item(detailed)%>\r\n\r\n <!-- this tag inserts the comments on the selected item, also using the -->\r\n <!-- template with name \'detailed\'                                      -->\r\n <h2>Comments</h2>\r\n <%comments(detailed)%>\r\n\r\n <h2>Add Comments</h2>\r\n <%commentform%>\r\n\r\n</div><!-- end of the contents div -->\r\n\r\n<!-- definition of the logo left-top -->\r\n<div class="logo">\r\n <img src="atom.gif" width="150" height="150" alt="" /> \r\n</div>\r\n\r\n<!-- definition of the menu -->\r\n<div class="menu">\r\n\r\n <!-- accessibility anchor -->\r\n <a name="navigation" id="navigation" class="skip"></a>\r\n <h1 class="skip">Navigation</h1>\r\n\r\n <h2>Navigation</h2>\r\n <ul class="nobullets">\r\n  <li><a href="<%nextlink%>">Previous Item</a></li>\r\n  <li><a href="<%prevlink%>">Next Item</a></li>\r\n  <li><a href="<%todaylink%>">Today</a></li>\r\n  <li><a href="<%archivelink%>">Archives</a></li>\r\n  <li><a href="<%adminurl%>">Admin Area</a></li>\r\n </ul>\r\n\r\n <h2>Categories</h2>\r\n <%categorylist(default)%>\r\n\r\n <h2>Search</h2>\r\n <%searchform%>\r\n \r\n <h2>Login</h2>\r\n <%loginform%>\r\n\r\n <h2>powered by</h2>\r\n <%nucleusbutton(nucleus2.gif,46,43)%></div>\r\n\r\n</body>\r\n</html>');
INSERT INTO nucleus_skin VALUES (1, 'search', '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\r\n\r\n<html>\r\n<head>\r\n  <title><%blogsetting(name)%></title>\r\n\r\n  <!-- some meta information (search engines might read this) -->\r\n  <meta name="generator" content="<%version%>" />\r\n  <meta name="description" content="<%blogsetting(desc)%>" />\r\n\r\n  <!-- stylesheet definition (points to the place where colors -->\r\n  <!-- and layout is defined -->\r\n  <link rel="stylesheet" type="text/css" href="default.css" />\r\n  \r\n  <!-- prevent caching (can be removed) -->\r\n  <meta http-equiv="Pragma" content="no-cache" />\r\n  <meta http-equiv="Cache-Control" content="no-cache, must-revalidate" />\r\n  <meta http-equiv="Expires" content="-1" />\r\n  \r\n  <!-- extra navigational links -->\r\n  <link rel="bookmark" title="Nucleus" href="http://www.nucleuscms.org/" />\r\n  <link rel="alternate" type="application/xml+rss" title="RSS" href="xml-rss.php" />\r\n  <link rel="archives" title="Archives" href="<%archivelink%>" />\r\n  <link rel="top" title="Today" href="<%sitevar(url)%>" />\r\n  <link rel="up" href="<%todaylink%>" title="Today" />\r\n\r\n</head>\r\n<body>\r\n\r\n<!-- here starts the code that will be displayed in your browser -->\r\n<div class="contents">\r\n\r\n <!-- this is a normally hidden link, included for accessibility reasons -->\r\n <a href="#navigation" class="skip">Jump to navigation</a>\r\n\r\n <!-- a title -->\r\n <h1><%blogsetting(name)%></h1>\r\n\r\n <h2>Search</h2>\r\n <%searchform%>\r\n\r\n <h2>Search results</h2>\r\n <%searchresults(default)%>\r\n\r\n</div><!-- end of the contents div -->\r\n\r\n<!-- definition of the logo left-top -->\r\n<div class="logo">\r\n <img src="atom.gif" width="150" height="150" alt="" /> \r\n</div>\r\n\r\n<!-- definition of the menu -->\r\n<div class="menu">\r\n <!-- accessibility anchor -->\r\n <a name="navigation" id="navigation" class="skip"></a>\r\n <h1 class="skip">Navigation</h1>\r\n\r\n <h2>Navigation</h2>\r\n\r\n <ul class="nobullets">\r\n   <li><a href="<%todaylink%>">Today</a></li>\r\n   <li><a href="<%archivelink%>">Archives</a></li>\r\n   <li><a href="<%adminurl%>">Admin Area</a></li>\r\n </ul>\r\n\r\n <h2>Search</h2>\r\n <%searchform%>\r\n \r\n <h2>Login</h2>\r\n <%loginform%>\r\n\r\n <h2>powered by</h2>\r\n <%nucleusbutton(nucleus2.gif,46,43)%>\r\n</div>\r\n\r\n</body>\r\n</html>');
INSERT INTO nucleus_skin VALUES (3, 'index', '<?xml version="1.0" encoding="ISO-8859-1"?>\r\n\r\n<!DOCTYPE rss PUBLIC "-//Netscape Communications//DTD RSS 0.91//EN" "http://my.netscape.com/publish/formats/rss-0.91.dtd">\r\n\r\n<rss version="0.91">\r\n\r\n  <channel>\r\n    <title><%blogsetting(name)%></title>\r\n    <link><%blogsetting(url)%></link>\r\n    <description><%blogsetting(desc)%></description>\r\n    <docs>http://backend.userland.com/rss091</docs>\r\n    <language>en</language>\r\n    <image>\r\n      <url><%adminurl%>nucleus2.gif</url>\r\n      <title><%blogsetting(name)%></title>\r\n      <link><%todaylink%></link>\r\n    </image>\r\n\r\n<%blog(xmlrss,10)%>\r\n\r\n</channel>\r\n</rss>');
INSERT INTO nucleus_skin VALUES (1, 'archivelist', '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\r\n\r\n<html>\r\n<head>\r\n  <title><%blogsetting(name)%></title>\r\n\r\n  <!-- some meta information (search engines might read this) -->\r\n  <meta name="generator" content="<%version%>" />\r\n  <meta name="description" content="<%blogsetting(desc)%>" />\r\n\r\n  <!-- stylesheet definition (points to the place where colors -->\r\n  <!-- and layout is defined -->\r\n  <link rel="stylesheet" type="text/css" href="default.css" />\r\n\r\n  <!-- prevent caching (can be removed) -->\r\n  <meta http-equiv="Pragma" content="no-cache" />\r\n  <meta http-equiv="Cache-Control" content="no-cache, must-revalidate" />\r\n  <meta http-equiv="Expires" content="-1" />\r\n  \r\n  <!-- extra navigational links -->\r\n  <link rel="bookmark" title="Nucleus" href="http://www.nucleuscms.org/" />\r\n  <link rel="alternate" type="application/xml+rss" title="RSS" href="xml-rss.php" />\r\n  <link rel="archives" title="Archives" href="<%archivelink%>" />\r\n  <link rel="top" title="Today" href="<%sitevar(url)%>" />\r\n  <link rel="up" href="<%todaylink%>" title="Today" />\r\n\r\n</head>\r\n<body>\r\n\r\n<!-- here starts the code that will be displayed in your browser -->\r\n<div class="contents">\r\n\r\n<!-- a title -->\r\n<h1><%blogsetting(name)%></h1>\r\n\r\n <!-- this is a normally hidden link, included for accessibility reasons -->\r\n <a href="#navigation" class="skip">Jump to navigation</a>\r\n\r\n <h2>Archives</h2>\r\n <!-- This tag inserts the archivelist using the default template -->\r\n <%archivelist(default)%>\r\n\r\n</div><!-- end of the contents div -->\r\n\r\n<!-- definition of the logo left-top -->\r\n<div class="logo">\r\n <img src="atom.gif" width="150" height="150" alt="" /> \r\n</div>\r\n\r\n<!-- definition of the menu -->\r\n<div class="menu">\r\n <!-- accessibility anchor -->\r\n <a name="navigation" id="navigation" class="skip"></a>\r\n <h1 class="skip">Navigation</h1>\r\n\r\n <h2>Navigation</h2>\r\n <ul class="nobullets">\r\n   <li><a href="<%todaylink%>">Today</a></li>\r\n   <li><a href="<%archivelink%>">Archives</a></li>\r\n   <li><a href="<%adminurl%>">Admin Area</a></li>\r\n </ul>\r\n\r\n <h2>Categories</h2>\r\n <%categorylist(default)%>\r\n \r\n <h2>Search</h2>\r\n <%searchform%>\r\n \r\n <h2>Login</h2>\r\n <%loginform%>\r\n\r\n <h2>powered by</h2>\r\n <%nucleusbutton(nucleus2.gif,46,43)%>\r\n</div>\r\n\r\n</body>\r\n</html>');
INSERT INTO nucleus_skin VALUES (1, 'archive', '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\r\n\r\n<html>\r\n<head>\r\n  <title><%blogsetting(name)%></title>\r\n\r\n  <!-- some meta information (search engines might read this) -->\r\n  <meta name="generator" content="<%version%>" />\r\n  <meta name="description" content="<%blogsetting(desc)%>" />\r\n\r\n  <!-- stylesheet definition (points to the place where colors -->\r\n  <!-- and layout is defined -->\r\n  <link rel="stylesheet" type="text/css" href="default.css" />\r\n\r\n  <!-- prevent caching (can be removed) -->\r\n  <meta http-equiv="Pragma" content="no-cache" />\r\n  <meta http-equiv="Cache-Control" content="no-cache, must-revalidate" />\r\n  <meta http-equiv="Expires" content="-1" />\r\n  \r\n  <!-- extra navigational links -->\r\n  <link rel="bookmark" title="Nucleus" href="http://www.nucleuscms.org/" />\r\n  <link rel="alternate" type="application/xml+rss" title="RSS" href="xml-rss.php" />\r\n  <link rel="archives" title="Archives" href="<%archivelink%>" />\r\n  <link rel="top" title="Today" href="<%sitevar(url)%>" />\r\n  <link rel="up" href="<%todaylink%>" title="Today" />\r\n\r\n</head>\r\n<body>\r\n\r\n<!-- here starts the code that will be displayed in your browser -->\r\n<div class="contents">\r\n\r\n <!-- this is a normally hidden link, included for accessibility reasons -->\r\n <a href="#navigation" class="skip">Jump to navigation</a>\r\n\r\n <!-- a title -->\r\n <h1><%blogsetting(name)%></h1>\r\n\r\n <!-- This tag inserts the archive using the default template -->\r\n <%archive(default)%>\r\n\r\n</div><!-- end of the contents div -->\r\n\r\n<!-- definition of the logo left-top -->\r\n<div class="logo">\r\n <img src="atom.gif" width="150" height="150" alt="" /> \r\n</div>\r\n\r\n<!-- definition of the menu -->\r\n<div class="menu">\r\n <!-- accessibility anchor -->\r\n <a name="navigation" id="navigation" class="skip"></a>\r\n <h1 class="skip">Navigation</h1>\r\n\r\n <h2>Navigation</h2>\r\n\r\n <ul class="nobullets">\r\n   <li><a href="<%todaylink%>">Today</a></li>\r\n   <li><a href="<%archivelink%>">Archives</a></li>\r\n   <li><a href="<%adminurl%>">Admin Area</a></li>\r\n </ul>\r\n\r\n <h2>Categories</h2>\r\n <%categorylist(default)%>\r\n\r\n <h2>Search</h2>\r\n <%searchform%>\r\n \r\n <h2>Login</h2>\r\n <%loginform%>\r\n \r\n <h2>powered by</h2>\r\n <%nucleusbutton(nucleus2.gif,46,43)%>\r\n</div>\r\n\r\n</body>\r\n</html>');
INSERT INTO nucleus_skin VALUES (1, 'error', '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\r\n\r\n<html>\r\n<head>\r\n  <title><%sitevar(name)%></title>\r\n\r\n  <!-- some meta information (search engines might read this) -->\r\n  <meta name="generator" content="<%version%>" />\r\n\r\n  <!-- stylesheet definition (points to the place where colors -->\r\n  <!-- and layout is defined -->\r\n  <link rel="stylesheet" type="text/css" href="default.css" />\r\n\r\n  <!-- prevent caching (can be removed) -->\r\n  <meta http-equiv="Pragma" content="no-cache" />\r\n  <meta http-equiv="Cache-Control" content="no-cache, must-revalidate" />\r\n  <meta http-equiv="Expires" content="-1" />\r\n  \r\n  <!-- extra navigational links -->\r\n  <link rel="bookmark" title="Nucleus" href="http://www.nucleuscms.org/" />\r\n  <link rel="top" title="Today" href="<%todaylink%>" />\r\n  <link rel="up" href="<%todaylink%>" title="Today" />\r\n\r\n</head>\r\n<body>\r\n\r\n<!-- here starts the code that will be displayed in your browser -->\r\n<div class="contents">\r\n\r\n <!-- this is a normally hidden link, included for accessibility reasons -->\r\n <a href="#navigation" class="skip">Jump to navigation</a>\r\n\r\n <!-- a title -->\r\n <h1><%sitevar(name)%></h1>\r\n\r\n <h2>Error!</h2>\r\n\r\n <p><%errormessage%></p>\r\n\r\n <p><a href="javascript:history.go(-1);">Go back</a></p>\r\n\r\n</div><!-- end of the contents div -->\r\n\r\n<!-- definition of the logo left-top -->\r\n<div class="logo">\r\n <img src="atom.gif" width="150" height="150" alt="" /> \r\n</div>\r\n\r\n<!-- definition of the menu -->\r\n<div class="menu">\r\n <!-- accessibility anchor -->\r\n <a name="navigation" id="navigation" class="skip"></a>\r\n <h1 class="skip">Navigation</h1>\r\n\r\n <h2>Navigation</h2>\r\n\r\n <ul class="nobullets">\r\n  <li><a href="<%todaylink%>">Today</a></li>\r\n  <li><a href="<%adminurl%>">Admin Area</a></li>\r\n </ul>\r\n \r\n <h2>Login</h2>\r\n <%loginform%>\r\n\r\n <h2>powered by</h2>\r\n <%nucleusbutton(nucleus/nucleus2.gif,46,43)%>\r\n</div>\r\n\r\n</body>\r\n</html>');
INSERT INTO nucleus_skin VALUES (1, 'member', '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\r\n\r\n<html>\r\n<head>\r\n  <title><%sitevar(name)%></title>\r\n\r\n  <!-- some meta information (search engines might read this) -->\r\n  <meta name="generator" content="<%version%>" />\r\n\r\n  <!-- stylesheet definition (points to the place where colors -->\r\n  <!-- and layout is defined -->\r\n  <link rel="stylesheet" type="text/css" href="default.css" />\r\n\r\n  <!-- prevent caching (can be removed) -->\r\n  <meta http-equiv="Pragma" content="no-cache" />\r\n  <meta http-equiv="Cache-Control" content="no-cache, must-revalidate" />\r\n  <meta http-equiv="Expires" content="-1" />\r\n  \r\n  <!-- extra navigational links -->\r\n  <link rel="bookmark" title="Nucleus" href="http://www.nucleuscms.org/" />\r\n  <link rel="top" title="Today" href="<%todaylink%>" />\r\n  <link rel="up" href="<%todaylink%>" title="Today" />\r\n\r\n</head>\r\n<body>\r\n\r\n<!-- here starts the code that will be displayed in your browser -->\r\n<div class="contents">\r\n\r\n <!-- this is a normally hidden link, included for accessibility reasons -->\r\n <a href="#navigation" class="skip">Jump to navigation</a>\r\n\r\n <!-- a title -->\r\n <h1><%sitevar(name)%></h1>\r\n\r\n <h2>Info about <%member(name)%></h2>\r\n\r\n <ul>\r\n  <li>Real name: <%member(realname)%></li>\r\n  <li>Website: <a href="<%member(url)%>"><%member(url)%></a></li>\r\n </ul>\r\n\r\n <h2>Send Message</h2>\r\n <%membermailform%>\r\n\r\n</div><!-- end of the contents div -->\r\n\r\n<!-- definition of the logo left-top -->\r\n<div class="logo">\r\n <img src="atom.gif" width="150" height="150" alt="" /> \r\n</div>\r\n\r\n<!-- definition of the menu -->\r\n<div class="menu">\r\n <!-- accessibility anchor -->\r\n <a name="navigation" id="navigation" class="skip"></a>\r\n <h1 class="skip">Navigation</h1>\r\n\r\n <h2>Navigation</h2>\r\n\r\n <ul class="nobullets">\r\n  <li><a href="<%todaylink%>">Today</a></li>\r\n  <li><a href="<%adminurl%>">Admin Area</a></li>\r\n </ul>\r\n \r\n <h2>Login</h2>\r\n <%loginform%>\r\n\r\n <h2>powered by</h2>\r\n <%nucleusbutton(nucleus2.gif,46,43)%>\r\n</div>\r\n\r\n</body>\r\n</html>');
INSERT INTO nucleus_skin VALUES (1, 'imagepopup', '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\r\n<html>\r\n<head>\r\n  <title><%imagetext%></title>\r\n  <style type="text/css">\r\n   img { border: none; }\r\n   body { margin: 0px; }\r\n  </style>\r\n</head>\r\n<body onblur="window.close()">\r\n  <a href="javascript:window.close();"><%image%></a>\r\n</body>\r\n</html>');
INSERT INTO nucleus_skin VALUES (1, 'index', '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\r\n\r\n<html>\r\n<head>\r\n  <title><%blogsetting(name)%></title>\r\n\r\n  <!-- some meta information (search engines might read this) -->\r\n  <meta name="generator" content="<%version%>" />\r\n  <meta name="description" content="<%blogsetting(desc)%>" />\r\n\r\n  <!-- stylesheet definition (points to the place where colors -->\r\n  <!-- and layout is defined -->\r\n  <link rel="stylesheet" type="text/css" href="default.css" />\r\n\r\n  <!-- prevent caching (can be removed) -->\r\n  <meta http-equiv="Pragma" content="no-cache" />\r\n  <meta http-equiv="Cache-Control" content="no-cache, must-revalidate" />\r\n  <meta http-equiv="Expires" content="-1" />\r\n  \r\n  <!-- extra navigational links -->\r\n  <link rel="bookmark" title="Nucleus" href="http://www.nucleuscms.org/" />\r\n  <link rel="archives" title="Archives" href="<%archivelink%>" />\r\n  <link rel="top" title="Today" href="<%todaylink%>" />\r\n\r\n  <!-- link RSS as alternate version -->\r\n  <link rel="alternate" type="application/rss+xml" title="RSS" href="xmlrss.php" />\r\n\r\n</head>\r\n<body>\r\n\r\n<!-- here starts the code that will be displayed in your browser -->\r\n<div class="contents">\r\n\r\n <!-- page title -->\r\n <h1><%blogsetting(name)%></h1>\r\n\r\n <!-- this is a normally hidden link, included for accessibility reasons -->\r\n <a href="#navigation" class="skip">Jump to navigation</a>\r\n\r\n <!-- this tag inserts a weblog using the template named \'default\' and  -->\r\n <!-- showing 15 entries                                                -->\r\n <%blog(default,15)%>\r\n\r\n</div><!-- end of the contents div -->\r\n\r\n<!-- definition of the logo (left-top) -->\r\n<div class="logo">\r\n <img src="atom.gif" width="150" height="150" alt="" /> \r\n</div>\r\n\r\n<!-- definition of the menu -->\r\n<div class="menu">\r\n <!-- accessibility anchor -->\r\n <a name="navigation" id="navigation" class="skip"></a>\r\n <h1 class="skip">Navigation</h1>\r\n\r\n <h2>Navigation</h2>\r\n <ul class="nobullets">\r\n  <li><a href="<%todaylink%>">Today</a></li>\r\n  <li><a href="<%archivelink%>">Archives</a></li>\r\n  <li><a href="<%adminurl%>">Admin Area</a></li>\r\n </ul>\r\n\r\n <h2>Categories</h2>\r\n <%categorylist(default)%>\r\n\r\n <h2>Search</h2>\r\n <%searchform%>\r\n \r\n <h2>Login</h2>\r\n <%loginform%>\r\n\r\n <h2>My Links</h2>\r\n\r\n <ul class="nobullets">\r\n  <li><a href="http://www.nucleuscms.org/" title="This site is Nucleus-powered">Nucleus</a></li>\r\n  <li><a href="http://www.weblogs.com/" title="latest updates">Weblogs.com</a></li>\r\n  <li><a href="http://www.daypop.com/" title="Search news &amp; weblog sites">DayPop</a></li>\r\n  <li><a href="http://www.google.com/" title="Search the web">Google</a></li>\r\n </ul>\r\n\r\n <h2>powered by</h2>\r\n <%nucleusbutton(nucleus2.gif,46,43)%>\r\n</div>\r\n\r\n</body>\r\n</html>');

CREATE TABLE nucleus_skin_desc (
  sdnumber int(11) NOT NULL auto_increment,
  sdname varchar(20) NOT NULL default '',
  sddesc varchar(200) default NULL,
  sdtype varchar(40) NOT NULL default 'text/html',
  PRIMARY KEY  (sdnumber),
  UNIQUE KEY sdnumber (sdnumber),
  UNIQUE KEY sdname (sdname)
) TYPE=MyISAM;

INSERT INTO nucleus_skin_desc VALUES (1, 'default', 'Default skin to display your blog', 'text/html');
INSERT INTO nucleus_skin_desc VALUES (3, 'xmlrss', 'RSS syndication of weblogs', 'text/xml');

CREATE TABLE nucleus_team (
  tmember int(11) NOT NULL default '0',
  tblog int(11) NOT NULL default '0',
  tadmin tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (tmember,tblog)
) TYPE=MyISAM;

INSERT INTO nucleus_team VALUES (1, 1, 1);

CREATE TABLE nucleus_template (
  tdesc int(11) NOT NULL default '0',
  tpartname varchar(20) NOT NULL default '',
  tcontent text NOT NULL,
  PRIMARY KEY  (tdesc,tpartname)
) TYPE=MyISAM;

INSERT INTO nucleus_template VALUES (7, 'POPUP_CODE', '<%popuplink%>');
INSERT INTO nucleus_template VALUES (14, 'LOCALE', 'en');
INSERT INTO nucleus_template VALUES (14, 'FORMAT_TIME', '%X');
INSERT INTO nucleus_template VALUES (14, 'FORMAT_DATE', '%x');
INSERT INTO nucleus_template VALUES (14, 'COMMENTS_NONE', '<div class="comments">No comments yet</div>');
INSERT INTO nucleus_template VALUES (14, 'COMMENTS_ONE', 'comment');
INSERT INTO nucleus_template VALUES (14, 'COMMENTS_MANY', 'comments');
INSERT INTO nucleus_template VALUES (14, 'COMMENTS_BODY', '<h3 class="comment"><%userlink%> wrote:</h3>\r\n\r\n<div class="commentbody">\r\n  <%body%>\r\n</div>\r\n\r\n<div class="commentinfo">\r\n  <%date%> <%time%>\r\n</div>\r\n\r\n');
INSERT INTO nucleus_template VALUES (14, 'EDITLINK', '- <a href="<%editlink%>" onclick="<%editpopupcode%>">edit</a>');
INSERT INTO nucleus_template VALUES (7, 'SEARCH_NOTHINGFOUND', 'No search results found for <b><%query%></b>');
INSERT INTO nucleus_template VALUES (6, 'ITEM', '<item>\r\n <title><%syndicate_title%></title>\r\n <link><%itemlink%></link>\r\n <description><%syndicate_description%></description>\r\n</item>');
INSERT INTO nucleus_template VALUES (7, 'SEARCH_HIGHLIGHT', '<span class="highlight">\\0</span>');
INSERT INTO nucleus_template VALUES (7, 'FORMAT_TIME', '%X');
INSERT INTO nucleus_template VALUES (7, 'LOCALE', 'en');
INSERT INTO nucleus_template VALUES (7, 'FORMAT_DATE', '%x');
INSERT INTO nucleus_template VALUES (7, 'CATLIST_FOOTER', '</ul>');
INSERT INTO nucleus_template VALUES (7, 'DATE_HEADER', '<h2>%d %B</h2>\r\n');
INSERT INTO nucleus_template VALUES (7, 'ARCHIVELIST_FOOTER', '</ul>');
INSERT INTO nucleus_template VALUES (7, 'CATLIST_HEADER', '<ul class="nobullets">\r\n <li><a href="<%blogurl%>">All</a></li>');
INSERT INTO nucleus_template VALUES (7, 'CATLIST_LISTITEM', ' <li><a href="<%catlink%>"><%catname%></a></li>');
INSERT INTO nucleus_template VALUES (7, 'MORELINK', '<a href="<%itemlink%>">[Read More!]</a>');
INSERT INTO nucleus_template VALUES (7, 'EDITLINK', '<a href="<%editlink%>" onclick="<%editpopupcode%>">edit</a> -');
INSERT INTO nucleus_template VALUES (7, 'COMMENTS_TOOMUCH', '<a href="<%itemlink%>"><%commentcount%> <%commentword%></a>');
INSERT INTO nucleus_template VALUES (6, 'FORMAT_DATE', '%x');
INSERT INTO nucleus_template VALUES (7, 'ARCHIVELIST_LISTITEM', '<li><a href="<%archivelink%>">%B, %Y</a></li>');
INSERT INTO nucleus_template VALUES (6, 'FORMAT_TIME', '%X');
INSERT INTO nucleus_template VALUES (14, 'ITEM', '<h2><%title%></h2>\r\n\r\n<div class="itembody">\r\n  <%body%>\r\n  <br /><br />\r\n  <%more%>\r\n</div>\r\n\r\n<div class="iteminfo">\r\n  posted at <%time%> on <%date%>\r\n  by <a href="?memberid=<%authorid%>"><%author%></a> -\r\n  Category: <a href="<%categorylink%>"><%category%></a>\r\n  <%edit%>\r\n</div>\r\n');
INSERT INTO nucleus_template VALUES (7, 'IMAGE_CODE', '<%image%>');
INSERT INTO nucleus_template VALUES (7, 'COMMENTS_ONE', 'comment');
INSERT INTO nucleus_template VALUES (7, 'COMMENTS_MANY', 'comments');
INSERT INTO nucleus_template VALUES (7, 'COMMENTS_NONE', '<a href="<%itemlink%>">No <%commentword%></a>');
INSERT INTO nucleus_template VALUES (7, 'ARCHIVELIST_HEADER', '<ul>');
INSERT INTO nucleus_template VALUES (14, 'SEARCH_HIGHLIGHT', '<span class="highlight">\\0</span>');
INSERT INTO nucleus_template VALUES (14, 'POPUP_CODE', '<%popuplink%>');
INSERT INTO nucleus_template VALUES (14, 'MEDIA_CODE', '<%media%>');
INSERT INTO nucleus_template VALUES (14, 'IMAGE_CODE', '<%image%>');
INSERT INTO nucleus_template VALUES (7, 'MEDIA_CODE', '<%media%>');
INSERT INTO nucleus_template VALUES (7, 'ITEM', '<h3 class="item"><%title%></h3>\r\n\r\n<div class="itembody">\r\n  <%body%>\r\n  <%morelink%>\r\n</div>\r\n\r\n<div class="iteminfo">\r\n  <%time%> -\r\n  <a href="<%authorlink%>"><%author%></a> -\r\n  <%edit%>\r\n  <%comments%>\r\n</div>\r\n');

CREATE TABLE nucleus_template_desc (
  tdnumber int(11) NOT NULL auto_increment,
  tdname varchar(20) NOT NULL default '',
  tddesc varchar(200) default NULL,
  PRIMARY KEY  (tdnumber),
  UNIQUE KEY tdname (tdname),
  UNIQUE KEY tdnumber (tdnumber)
) TYPE=MyISAM;

INSERT INTO nucleus_template_desc VALUES (6, 'xmlrss', 'Used for RSS syndication of your blog');
INSERT INTO nucleus_template_desc VALUES (7, 'default', 'The default template that is used to display your Nucleus blog');
INSERT INTO nucleus_template_desc VALUES (14, 'detailed', 'Used for detailed item pages');