-- 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');
