-- MySQL dump 9.07
--
-- Host: localhost    Database: pysocks
---------------------------------------------------------
-- Server version	4.0.12-log

--
-- Table structure for table 'auth'
--

CREATE TABLE auth (
  auth_id int(11) NOT NULL auto_increment,
  the_time datetime default NULL,
  user_id int(11) default NULL,
  status int(11) default NULL,
  PRIMARY KEY  (auth_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'auth'
--


--
-- Table structure for table 'page_data_simple'
--

CREATE TABLE page_data_simple (
  page_id int(11) default NULL,
  auth_level int(11) default NULL,
  item_name varchar(80) default NULL,
  item_data mediumtext
) TYPE=MyISAM;

--
-- Dumping data for table 'page_data_simple'
--

INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (1,0,'head_block','hi there');
INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (1,0,'footer_block','hi there --');
INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (2,0,'login','./index.cgi?page=200');
INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (2,0,'logout','./index.cgi?page=300');
INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (2,0,'search','./index.cgi?page=10');
INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (2,0,'accept','url-link');
INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (2,0,'add new','url-link');
INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (3,0,'main_text','lots of new stuff --\nPosted by michael on Sunday May 04, @06:51PM\n from the have-your-device-call-my-device-and-we\'ll-do-lunch dept.\n  markbaard writes \"Intel is developing a wireless, pocket-sized personal server that may replace laptops and PDAs altogether. The \'personal server,\' which is being developed at Intel Research by ubiquitous computing wizard Roy Want, is the size of a deck of cards, half the weight of an iPaq, and has no i/o, no screen, and no peripherals. The device never leaves its user\'s pocket or handbag. Pictures of the personal server and the story are at baard.com.\" ');
INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (10,0,'head_block','search');
INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (10,0,'footer_block','search footer');
INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (12,0,'main_text','<form method=\"post\" action=\"./index.cgi\">\n    <input type=\"hidden\" name=\"page\" value=\"10\">\n    <table>\n\n    <tr>\n        <td>Keywords</td>\n        <td><input type=\"text\" name=\"keywords\" value=\"\"></td>\n    </tr>\n\n    <tr>\n        <td>authors</td>\n        <td><input type=\"text\" name=\"authors\" value=\"\"></td>\n    </tr>\n\n    <tr>\n        <td>research group</td>\n        <td><input type=\"text\" name=\"department\" value=\"\"></td>\n    </tr>\n\n    <tr>\n        <td><input type=\"submit\" value=\"submit\"></td>\n    </tr>\n    </table>\n</form>');

INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (300,0,'main_text','you are now logged out! ');
--
-- Table structure for table 'page_templates'
--

CREATE TABLE page_templates (
  template_id int(11) default NULL,
  template_name varchar(255) default NULL,
  template mediumtext
) TYPE=MyISAM;

--
-- Dumping data for table 'page_templates'
--

INSERT INTO page_templates (template_id, template_name, template) VALUES (1,'top level page','<html>\n<head><title>main</title><head>\n<body>\n<table width=\"100%%\" border=\"1\"><tr><td colspan=\"2\" align=\"center\">%(head_block)s</td></tr>\n<tr>\n<td>%(left_bar)s</td>\n<td>%(main_text)s</td>\n</tr>\n<tr><td colspan=\"2\" align=\"center\">%(footer_block)s</td></tr>\n</table>\n</body>\n</html>');
INSERT INTO page_templates (template_id, template_name, template) VALUES (3,'main_text','%(main_text)s');
INSERT INTO page_templates (template_id, template_name, template) VALUES (4,'menu_bar','<a href=\"%s\">%s</a>');

--
-- Table structure for table 'pages'
--

CREATE TABLE pages (
  page_id int(11) default NULL,
  page_type int(11) default NULL,
  has_subparts int(11) default NULL,
  parent int(11) default NULL,
  template_id int(11) default NULL,
  auth_level int(11) default NULL,
  name char(80) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table 'pages'
--

INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name) VALUES (1,1,1,-1,1,0,'top_page');
INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name) VALUES (2,2,1,1,4,0,'menu_bar');
INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name) VALUES (3,1,0,1,3,0,'main_text');
INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name) VALUES (10,1,1,-1,1,0,'top_page');
INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name) VALUES (2,2,1,10,4,0,'menu_bar');
INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name) VALUES (12,1,0,10,3,0,'main_text');

INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name) VALUES (300,1,1,-1,1,0,'logout_page');
INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name) VALUES (2,2,1,300,4,0,'menu_bar');
INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name) VALUES (302,1,0,300,3,0,'main_text');
