# --------------------------------------------------------

#
# Table structure for table `person`
#

CREATE TABLE `person` (
  `person_id` int(15) NOT NULL auto_increment,
  `person_title` varchar(255) default NULL,
  `person_pref` varchar(14) default NULL,
  `person_name` varchar(255) default NULL,
  `person_status` varchar(5) default NULL,
  `person_mode` varchar(15) default NULL,
  `person_password` varchar(255) NOT NULL default '',
  `person_midm` varchar(255) default NULL,
  `person_description` text,
  `person_email` varchar(255) default NULL,
  `person_eformat` varchar(10) default 'htm',
  `person_html` varchar(255) default NULL,
  `person_weblog` varchar(255) default NULL,
  `person_photo` varchar(255) default NULL,
  `person_xml` varchar(255) default NULL,
  `person_foaf` varchar(255) default NULL,
  `person_street` varchar(255) default NULL,
  `person_city` varchar(40) default NULL,
  `person_province` varchar(40) default NULL,
  `person_country` varchar(20) default NULL,
  `person_home_phone` varchar(15) default NULL,
  `person_work_phone` varchar(20) default NULL,
  `person_fax_phone` varchar(15) default NULL,
  `person_organization` varchar(255) default NULL,
  `person_remember` varchar(5) default 'yes',
  `person_showreal` varchar(5) default 'yes',
  `person_showemail` varchar(5) default 'yes',
  `person_showuser` varchar(5) default 'yes',
  `person_showpage` varchar(5) default 'yes',
  `person_crdate` int(15) default NULL,
  `show_pref` varchar(4) default 'show',
  `show_name` varchar(4) default 'show',
  `show_html` varchar(4) default 'show',
  `show_weblog` varchar(4) default 'show',
  `show_photo` varchar(4) default 'show',
  `show_email` varchar(4) default 'hide',
  PRIMARY KEY  (`person_id`)
) AUTO_INCREMENT=1 ;

#
# Dumping data for table `person`
#

INSERT INTO `person` VALUES (1, 'Admin', 'Mr', 'Administrator', 'admin', 'admin', 'admin', NULL, NULL, 'stephen@downes.ca', 'htm', 'http://www.downes.ca', 'http://www.downes.ca/news/OLDaily.htm', 'http://www.downes.ca/photos/toronto/me_harbor.jpg', NULL, 'http://www.downes.ca/foaf.rdf', NULL, 's', 's', 's', NULL, NULL, NULL, 'Stanford', 'yes', NULL, NULL, NULL, NULL, 993586617, 'show', 'show', 'show', 'show', 'show', 'show');
INSERT INTO `person` VALUES (2, 'anymouse', NULL, 'Anymouse', NULL, NULL, 'anymouse', NULL, NULL, 'any@mouse.org', 'txt', NULL, NULL, NULL, NULL, NULL, NULL, 's', 's', 's', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 993586618, 'show', 'show', 'show', 'show', 'show', 'hide');

# --------------------------------------------------------

#
# Table structure for table `subscription`
#

CREATE TABLE `subscription` (
  `subscription_id` int(15) NOT NULL auto_increment,
  `subscription_title` varchar(128) default NULL,
  `subscription_box` int(15) default NULL,
  `subscription_person` int(15) default NULL,
  `subscription_format` varchar(16) default NULL,
  `subscription_order` int(3) default NULL,
  `subscription_misc` varchar(16) default NULL,
  `subscription_crdate` varchar(24) default NULL,
  PRIMARY KEY  (`subscription_id`)
) AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `box`
#

CREATE TABLE `box` (
  `box_id` int(15) NOT NULL auto_increment,
  `box_title` varchar(255) default NULL,
  `box_description` varchar(255) default NULL,
  `box_content` text,
  `box_sub` varchar(5) default NULL,
  `box_format` varchar(10) default NULL,
  `box_day` varchar(12) default NULL,
  `box_creator` varchar(255) default NULL,
  `box_crdate` varchar(255) default NULL,
  `box_txt_version` int(5) default NULL,
  PRIMARY KEY  (`box_id`)
) AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `template`
#

CREATE TABLE `template` (
  `template_id` int(15) NOT NULL auto_increment,
  `template_title` varchar(255) default NULL,
  `template_description` text,
  `template_creator` varchar(64) default NULL,
  `template_crdate` int(15) default NULL,
  PRIMARY KEY  (`template_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

#

INSERT INTO `template` VALUES (1, 'top', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0\r\nTransitional//EN" "DTD/xhtml1-transitional.dtd">\r\n<html><head><title>Stephen\'s Web ~ by Stephen Downes ~ <PAGE_TITLE></title>\r\n<link rel="alternate" type="application/rss+xml"\r\ntitle="RSS" href="http://www.downes.ca/news/OLDaily.xml" />\r\n<script type="text/javascript" src="http://www.downes.ca/cgi-bin/mytheme.cgi"></script>\r\n\r\n</head>\r\n<body>\r\n<!-- Begin Banner -->\r\n<div id="banner">\r\n\r\n<!-- Site Title -->\r\n	<a href="http://www.downes.ca" class="home">Stephen\'s\r\nWeb</a>\r\n</div>\r\n<!-- End Banner -->\r\n\r\n<!-- Begin Page Content -->\r\n<div id="pagecontent">\r\n\r\n<!-- Page Top Nav -->\r\n<div class="page_nav">\r\n[<a href="http://www.downes.ca/news/OLDaily.htm">OLDaily</a>]\r\n</div>\r\n', NULL, 1112987815);

INSERT INTO `template` VALUES (2, 'left', '</div>\r\n\r\n<!-- Begin Left Column -->\r\n<div id="leftcontent">\r\n</div>\r\n<!-- End Left Column -->\r\n\r\n</body>\r\n</html>', NULL, 1112990056);