Newer
Older
Digital_Repository / Old / pysocks / latest.sql
nstanger on 12 Nov 2005 27 KB - Second attempt at importing!
-- MySQL dump 9.08
--
-- Host: localhost    Database: pysocks
---------------------------------------------------------
-- Server version	4.0.13-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'
--

INSERT INTO auth VALUES (12,NULL,NULL,0);
INSERT INTO auth VALUES (13,NULL,NULL,0);
INSERT INTO auth VALUES (14,NULL,NULL,0);
INSERT INTO auth VALUES (15,NULL,NULL,0);
INSERT INTO auth VALUES (16,NULL,NULL,0);
INSERT INTO auth VALUES (17,NULL,NULL,0);
INSERT INTO auth VALUES (18,NULL,NULL,0);
INSERT INTO auth VALUES (19,NULL,NULL,0);
INSERT INTO auth VALUES (20,NULL,NULL,0);
INSERT INTO auth VALUES (21,NULL,NULL,0);
INSERT INTO auth VALUES (22,NULL,NULL,0);
INSERT INTO auth VALUES (23,NULL,NULL,0);
INSERT INTO auth VALUES (24,NULL,NULL,0);
INSERT INTO auth VALUES (25,NULL,NULL,0);
INSERT INTO auth VALUES (26,NULL,NULL,0);
INSERT INTO auth VALUES (27,NULL,NULL,0);
INSERT INTO auth VALUES (28,NULL,NULL,0);
INSERT INTO auth VALUES (29,NULL,NULL,0);
INSERT INTO auth VALUES (30,NULL,NULL,0);
INSERT INTO auth VALUES (31,NULL,NULL,0);
INSERT INTO auth VALUES (32,NULL,NULL,0);
INSERT INTO auth VALUES (33,NULL,NULL,0);
INSERT INTO auth VALUES (34,NULL,NULL,0);
INSERT INTO auth VALUES (35,NULL,NULL,0);
INSERT INTO auth VALUES (36,NULL,NULL,0);
INSERT INTO auth VALUES (37,NULL,NULL,0);
INSERT INTO auth VALUES (38,NULL,NULL,0);
INSERT INTO auth VALUES (39,NULL,NULL,0);
INSERT INTO auth VALUES (40,NULL,NULL,0);
INSERT INTO auth VALUES (41,NULL,NULL,0);
INSERT INTO auth VALUES (42,NULL,NULL,0);
INSERT INTO auth VALUES (43,NULL,NULL,0);
INSERT INTO auth VALUES (44,NULL,NULL,0);
INSERT INTO auth VALUES (45,NULL,NULL,0);
INSERT INTO auth VALUES (46,NULL,NULL,0);
INSERT INTO auth VALUES (47,NULL,NULL,0);
INSERT INTO auth VALUES (48,NULL,NULL,0);
INSERT INTO auth VALUES (49,NULL,NULL,0);
INSERT INTO auth VALUES (50,NULL,NULL,0);
INSERT INTO auth VALUES (51,NULL,NULL,0);
INSERT INTO auth VALUES (52,NULL,NULL,0);
INSERT INTO auth VALUES (53,NULL,NULL,0);
INSERT INTO auth VALUES (54,NULL,NULL,0);
INSERT INTO auth VALUES (55,NULL,NULL,0);
INSERT INTO auth VALUES (56,NULL,NULL,0);
INSERT INTO auth VALUES (57,NULL,NULL,0);
INSERT INTO auth VALUES (58,NULL,NULL,0);
INSERT INTO auth VALUES (59,NULL,NULL,0);
INSERT INTO auth VALUES (60,NULL,NULL,0);

--
-- Table structure for table 'doc_auth'
--

CREATE TABLE doc_auth (
  author_id int(11) default NULL,
  document_id int(11) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table 'doc_auth'
--

INSERT INTO doc_auth VALUES (1,1);
INSERT INTO doc_auth VALUES (2,2);
INSERT INTO doc_auth VALUES (0,0);
INSERT INTO doc_auth VALUES (0,0);
INSERT INTO doc_auth VALUES (0,0);
INSERT INTO doc_auth VALUES (0,0);
INSERT INTO doc_auth VALUES (0,0);
INSERT INTO doc_auth VALUES (0,0);
INSERT INTO doc_auth VALUES (0,0);
INSERT INTO doc_auth VALUES (0,0);
INSERT INTO doc_auth VALUES (0,4);
INSERT INTO doc_auth VALUES (2,5);
INSERT INTO doc_auth VALUES (2,6);
INSERT INTO doc_auth VALUES (2,7);
INSERT INTO doc_auth VALUES (2,8);
INSERT INTO doc_auth VALUES (2,9);
INSERT INTO doc_auth VALUES (2,10);
INSERT INTO doc_auth VALUES (2,11);
INSERT INTO doc_auth VALUES (2,12);
INSERT INTO doc_auth VALUES (2,13);

--
-- Table structure for table 'document_authors'
--

CREATE TABLE document_authors (
  author_id int(11) NOT NULL auto_increment,
  name varchar(255) default NULL,
  is_local int(11) default NULL,
  email_address varchar(255) default NULL,
  department_id int(11) default NULL,
  notes text,
  PRIMARY KEY  (author_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'document_authors'
--

INSERT INTO document_authors VALUES (1,'Nigel Stanger',1,'nigel@whatever',1,'some strange guy who does things with databases');
INSERT INTO document_authors VALUES (2,'Joe Skinner',0,'crypt@here',0,'some strange guy who does things with databases');
INSERT INTO document_authors VALUES (3,'Someone Else',0,'elsewhere@there',0,'this is another person to show that we can have 3');

--
-- Table structure for table 'document_data'
--

CREATE TABLE document_data (
  doc_id int(11) default NULL,
  the_doc mediumtext,
  filename varchar(80) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table 'document_data'
--

INSERT INTO document_data VALUES (1,'this is my document','fodo');
INSERT INTO document_data VALUES (0,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
INSERT INTO document_data VALUES (0,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
INSERT INTO document_data VALUES (0,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
INSERT INTO document_data VALUES (0,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
INSERT INTO document_data VALUES (0,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
INSERT INTO document_data VALUES (0,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
INSERT INTO document_data VALUES (0,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
INSERT INTO document_data VALUES (0,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
INSERT INTO document_data VALUES (4,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
INSERT INTO document_data VALUES (5,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
INSERT INTO document_data VALUES (6,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
INSERT INTO document_data VALUES (7,'#! /usr/bin/python\n\n#------------------------------------------------------------------------\n# name:\n# author: 		J Skinner\n# Date Written:	\n# Purpose:\n# Notes\n#------------------------------------------------------------------------\n\n\n\n#------------------------   GLOBALS  ------------------------------------\n\nDEBUG_MAIN = 0\nDEBUG = 0\nIS_CGI = 1\nIS_DB = 1\n\n#------------------------   IMPORTS  ------------------------------------\n\nimport string\nimport os\nimport sys\n\nimport cgi\nimport traceback\n\nimport MySQLdb\nimport access\n\n\n#------------------------    CODE    ------------------------------------\n#WEBALIZER=/usr/bin/webalizer\n#cd /var/www\n#for SITE in $(ls -1) ; do \n#    if [ -d \"$SITE/admin/logs\" ] ; then\n#            $WEBALIZER -n $SITE -r $SITE -o \\\n#            /var/www/$SITE/admin/logs /var/www/$SITE/admin/logs/access.log\n#    fi\n#done\n\nBASE_PATHS =[(\'/var/www\', 2) (\'/var/Clients\', 3)]\n\ndef run_webalizer(base_info):\n    base_dir, offset = base_info\n    status, paths = commands.getstatusoutput(\n        \"find %(base_dir)s -type d -regex \'.*/admin/logs\'\'\")\n    for i in paths:\n        site = i.split(\'/\')[offset]\n        commands.getstatusoutput(\'webalizer -n %(site)s -r %(site) \'\\\n            \'-o %(the_dir)s %(the_dir)s/access.log\'%\n                {\'site\':site, \'the_dir\':i})\ndef main():\n    for i in BASE_PATHS:\n        run_webalizer(i)\n\n\n#------------------------------------------------------------------------\n\nif (DEBUG_MAIN):\n    try:\n        main()\n    except SystemExit:\n        pass\n    except:\n        # errMessage(\"an unkown error has occurred program terminating\")\n        sys.stderr = sys.stdout\n        print \'\\n\\n<PRE>\'\n        traceback.print_exc()\nelse:\n    main()\n\n#------------------------     END    ------------------------------------\n','Null');
INSERT INTO document_data VALUES (8,'','');
INSERT INTO document_data VALUES (9,'#! /usr/bin/python\n\n#------------------------------------------------------------------------\n# name:\n# author: 		J Skinner\n# Date Written:	\n# Purpose:\n# Notes\n#------------------------------------------------------------------------\n\n\n\n#------------------------   GLOBALS  ------------------------------------\n\nDEBUG_MAIN = 0\nDEBUG = 0\nIS_CGI = 1\nIS_DB = 1\n\n#------------------------   IMPORTS  ------------------------------------\n\nimport string\nimport os\nimport sys\n\nimport cgi\nimport traceback\n\nimport MySQLdb\nimport access\n\n\n#------------------------    CODE    ------------------------------------\n#WEBALIZER=/usr/bin/webalizer\n#cd /var/www\n#for SITE in $(ls -1) ; do \n#    if [ -d \"$SITE/admin/logs\" ] ; then\n#            $WEBALIZER -n $SITE -r $SITE -o \\\n#            /var/www/$SITE/admin/logs /var/www/$SITE/admin/logs/access.log\n#    fi\n#done\n\nBASE_PATHS =[(\'/var/www\', 2) (\'/var/Clients\', 3)]\n\ndef run_webalizer(base_info):\n    base_dir, offset = base_info\n    status, paths = commands.getstatusoutput(\n        \"find %(base_dir)s -type d -regex \'.*/admin/logs\'\'\")\n    for i in paths:\n        site = i.split(\'/\')[offset]\n        commands.getstatusoutput(\'webalizer -n %(site)s -r %(site) \'\\\n            \'-o %(the_dir)s %(the_dir)s/access.log\'%\n                {\'site\':site, \'the_dir\':i})\ndef main():\n    for i in BASE_PATHS:\n        run_webalizer(i)\n\n\n#------------------------------------------------------------------------\n\nif (DEBUG_MAIN):\n    try:\n        main()\n    except SystemExit:\n        pass\n    except:\n        # errMessage(\"an unkown error has occurred program terminating\")\n        sys.stderr = sys.stdout\n        print \'\\n\\n<PRE>\'\n        traceback.print_exc()\nelse:\n    main()\n\n#------------------------     END    ------------------------------------\n\nNone\nvisted [\'setup: environ check\', \'setup: cookie key\', \'setup: 60\'] <br>\nauth_level 0 <br>\nuser_id 60 <br>\ncookie Set-Cookie: pysocks_id=\"L60L\\012.\"; <br>\nauth_id 60 <br>\nset_cookie None <br>\n\nlogged_in None <br>\n-- END OF PAGE --\n','Null');
INSERT INTO document_data VALUES (10,'#! /usr/bin/python\n\n#------------------------------------------------------------------------\n# name:\n# author: 		J Skinner\n# Date Written:	\n# Purpose:\n# Notes\n#------------------------------------------------------------------------\n\n\n\n#------------------------   GLOBALS  ------------------------------------\n\nDEBUG_MAIN = 0\nDEBUG = 0\nIS_CGI = 1\nIS_DB = 1\n\n#------------------------   IMPORTS  ------------------------------------\n\nimport string\nimport os\nimport sys\n\nimport cgi\nimport traceback\n\nimport MySQLdb\nimport access\n\n\n#------------------------    CODE    ------------------------------------\n#WEBALIZER=/usr/bin/webalizer\n#cd /var/www\n#for SITE in $(ls -1) ; do \n#    if [ -d \"$SITE/admin/logs\" ] ; then\n#            $WEBALIZER -n $SITE -r $SITE -o \\\n#            /var/www/$SITE/admin/logs /var/www/$SITE/admin/logs/access.log\n#    fi\n#done\n\nBASE_PATHS =[(\'/var/www\', 2) (\'/var/Clients\', 3)]\n\ndef run_webalizer(base_info):\n    base_dir, offset = base_info\n    status, paths = commands.getstatusoutput(\n        \"find %(base_dir)s -type d -regex \'.*/admin/logs\'\'\")\n    for i in paths:\n        site = i.split(\'/\')[offset]\n        commands.getstatusoutput(\'webalizer -n %(site)s -r %(site) \'\\\n            \'-o %(the_dir)s %(the_dir)s/access.log\'%\n                {\'site\':site, \'the_dir\':i})\ndef main():\n    for i in BASE_PATHS:\n        run_webalizer(i)\n\n\n#------------------------------------------------------------------------\n\nif (DEBUG_MAIN):\n    try:\n        main()\n    except SystemExit:\n        pass\n    except:\n        # errMessage(\"an unkown error has occurred program terminating\")\n        sys.stderr = sys.stdout\n        print \'\\n\\n<PRE>\'\n        traceback.print_exc()\nelse:\n    main()\n\n#------------------------     END    ------------------------------------\n\nNone\nvisted [\'setup: environ check\', \'setup: cookie key\', \'setup: 60\'] <br>\nauth_level 0 <br>\nuser_id 60 <br>\ncookie Set-Cookie: pysocks_id=\"L60L\\012.\"; <br>\nauth_id 60 <br>\nset_cookie None <br>\n\nlogged_in None <br>\n-- END OF PAGE --\n','Null');
INSERT INTO document_data VALUES (11,'#! /usr/bin/python\n\n#------------------------------------------------------------------------\n# name:\n# author: 		J Skinner\n# Date Written:	\n# Purpose:\n# Notes\n#------------------------------------------------------------------------\n\n\n\n#------------------------   GLOBALS  ------------------------------------\n\nDEBUG_MAIN = 0\nDEBUG = 0\nIS_CGI = 1\nIS_DB = 1\n\n#------------------------   IMPORTS  ------------------------------------\n\nimport string\nimport os\nimport sys\n\nimport cgi\nimport traceback\n\nimport MySQLdb\nimport access\n\n\n#------------------------    CODE    ------------------------------------\n#WEBALIZER=/usr/bin/webalizer\n#cd /var/www\n#for SITE in $(ls -1) ; do \n#    if [ -d \"$SITE/admin/logs\" ] ; then\n#            $WEBALIZER -n $SITE -r $SITE -o \\\n#            /var/www/$SITE/admin/logs /var/www/$SITE/admin/logs/access.log\n#    fi\n#done\n\nBASE_PATHS =[(\'/var/www\', 2) (\'/var/Clients\', 3)]\n\ndef run_webalizer(base_info):\n    base_dir, offset = base_info\n    status, paths = commands.getstatusoutput(\n        \"find %(base_dir)s -type d -regex \'.*/admin/logs\'\'\")\n    for i in paths:\n        site = i.split(\'/\')[offset]\n        commands.getstatusoutput(\'webalizer -n %(site)s -r %(site) \'\\\n            \'-o %(the_dir)s %(the_dir)s/access.log\'%\n                {\'site\':site, \'the_dir\':i})\ndef main():\n    for i in BASE_PATHS:\n        run_webalizer(i)\n\n\n#------------------------------------------------------------------------\n\nif (DEBUG_MAIN):\n    try:\n        main()\n    except SystemExit:\n        pass\n    except:\n        # errMessage(\"an unkown error has occurred program terminating\")\n        sys.stderr = sys.stdout\n        print \'\\n\\n<PRE>\'\n        traceback.print_exc()\nelse:\n    main()\n\n#------------------------     END    ------------------------------------\n','temp.py');
INSERT INTO document_data VALUES (12,'#! /usr/bin/python\n\n#------------------------------------------------------------------------\n# name:\n# author: 		J Skinner\n# Date Written:	\n# Purpose:\n# Notes\n#------------------------------------------------------------------------\n\n\n\n#------------------------   GLOBALS  ------------------------------------\n\nDEBUG_MAIN = 0\nDEBUG = 0\nIS_CGI = 1\nIS_DB = 1\n\n#------------------------   IMPORTS  ------------------------------------\n\nimport string\nimport os\nimport sys\n\nimport cgi\nimport traceback\n\nimport MySQLdb\nimport access\n\n\n#------------------------    CODE    ------------------------------------\n#WEBALIZER=/usr/bin/webalizer\n#cd /var/www\n#for SITE in $(ls -1) ; do \n#    if [ -d \"$SITE/admin/logs\" ] ; then\n#            $WEBALIZER -n $SITE -r $SITE -o \\\n#            /var/www/$SITE/admin/logs /var/www/$SITE/admin/logs/access.log\n#    fi\n#done\n\nBASE_PATHS =[(\'/var/www\', 2) (\'/var/Clients\', 3)]\n\ndef run_webalizer(base_info):\n    base_dir, offset = base_info\n    status, paths = commands.getstatusoutput(\n        \"find %(base_dir)s -type d -regex \'.*/admin/logs\'\'\")\n    for i in paths:\n        site = i.split(\'/\')[offset]\n        commands.getstatusoutput(\'webalizer -n %(site)s -r %(site) \'\\\n            \'-o %(the_dir)s %(the_dir)s/access.log\'%\n                {\'site\':site, \'the_dir\':i})\ndef main():\n    for i in BASE_PATHS:\n        run_webalizer(i)\n\n\n#------------------------------------------------------------------------\n\nif (DEBUG_MAIN):\n    try:\n        main()\n    except SystemExit:\n        pass\n    except:\n        # errMessage(\"an unkown error has occurred program terminating\")\n        sys.stderr = sys.stdout\n        print \'\\n\\n<PRE>\'\n        traceback.print_exc()\nelse:\n    main()\n\n#------------------------     END    ------------------------------------\n','temp.py');
INSERT INTO document_data VALUES (13,'#! /usr/bin/python\n\n#------------------------------------------------------------------------\n# name:\n# author: 		J Skinner\n# Date Written:	\n# Purpose:\n# Notes\n#------------------------------------------------------------------------\n\n\n\n#------------------------   GLOBALS  ------------------------------------\n\nDEBUG_MAIN = 0\nDEBUG = 0\nIS_CGI = 1\nIS_DB = 1\n\n#------------------------   IMPORTS  ------------------------------------\n\nimport string\nimport os\nimport sys\n\nimport cgi\nimport traceback\n\nimport MySQLdb\nimport access\n\n\n#------------------------    CODE    ------------------------------------\n#WEBALIZER=/usr/bin/webalizer\n#cd /var/www\n#for SITE in $(ls -1) ; do \n#    if [ -d \"$SITE/admin/logs\" ] ; then\n#            $WEBALIZER -n $SITE -r $SITE -o \\\n#            /var/www/$SITE/admin/logs /var/www/$SITE/admin/logs/access.log\n#    fi\n#done\n\nBASE_PATHS =[(\'/var/www\', 2) (\'/var/Clients\', 3)]\n\ndef run_webalizer(base_info):\n    base_dir, offset = base_info\n    status, paths = commands.getstatusoutput(\n        \"find %(base_dir)s -type d -regex \'.*/admin/logs\'\'\")\n    for i in paths:\n        site = i.split(\'/\')[offset]\n        commands.getstatusoutput(\'webalizer -n %(site)s -r %(site) \'\\\n            \'-o %(the_dir)s %(the_dir)s/access.log\'%\n                {\'site\':site, \'the_dir\':i})\ndef main():\n    for i in BASE_PATHS:\n        run_webalizer(i)\n\n\n#------------------------------------------------------------------------\n\nif (DEBUG_MAIN):\n    try:\n        main()\n    except SystemExit:\n        pass\n    except:\n        # errMessage(\"an unkown error has occurred program terminating\")\n        sys.stderr = sys.stdout\n        print \'\\n\\n<PRE>\'\n        traceback.print_exc()\nelse:\n    main()\n\n#------------------------     END    ------------------------------------\n','temp.py');

--
-- Table structure for table 'document_info'
--

CREATE TABLE document_info (
  doc_id int(11) NOT NULL auto_increment,
  author_id int(11) default NULL,
  pub_date date default NULL,
  has_blob int(11) default NULL,
  is_active int(11) default NULL,
  title varchar(255) default NULL,
  short_desc varchar(255) default NULL,
  long_desc text,
  PRIMARY KEY  (doc_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'document_info'
--

INSERT INTO document_info VALUES (1,1,'2003-05-17',1,1,'once upon a time - a story about computers','blah blah blah','the same but longer');
INSERT INTO document_info VALUES (2,2,'2003-05-17',0,1,'some interesting article','how to break a db','lots of details on the best way to break your favorite db system');
INSERT INTO document_info VALUES (3,NULL,'2003-06-26',1,NULL,'dfasd','kkkkkkkkkkkkkkkkk','dfgsdfgsdff');
INSERT INTO document_info VALUES (4,NULL,'2003-06-26',1,NULL,'stress','dsafsd','sdfkjasdf');
INSERT INTO document_info VALUES (5,NULL,'2003-06-26',1,NULL,'less stress','sdfasd','dsfsda');
INSERT INTO document_info VALUES (6,NULL,'2003-06-26',1,NULL,'less stress','sdfasd','dsfsda');
INSERT INTO document_info VALUES (7,NULL,'2003-06-26',1,NULL,'less stress','sdfasd','dsfsda');
INSERT INTO document_info VALUES (8,NULL,'2003-06-26',0,NULL,'seeing the light','dfads','dfasdf');
INSERT INTO document_info VALUES (9,NULL,'2003-06-26',1,NULL,'seeing the light - 2','dfads','dfasdf');
INSERT INTO document_info VALUES (10,NULL,'2003-06-26',1,NULL,'seeing the light - 2','dfads','dfasdf');
INSERT INTO document_info VALUES (11,NULL,'2003-06-26',1,NULL,'less stress','sdfasd','dsfsda');
INSERT INTO document_info VALUES (12,NULL,'2003-06-26',1,NULL,'less stress','sdfasd','dsfsda');
INSERT INTO document_info VALUES (13,NULL,'2003-06-26',1,NULL,'less stress','sdfasd','dsfsda');

--
-- Table structure for table 'keywords'
--

CREATE TABLE keywords (
  keyword_id int(11) default NULL,
  keyword char(255) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table 'keywords'
--

INSERT INTO keywords VALUES (1,'bad');
INSERT INTO keywords VALUES (2,'worse');

--
-- Table structure for table 'kw_doc'
--

CREATE TABLE kw_doc (
  keyword_id int(11) default NULL,
  doc_id int(11) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table 'kw_doc'
--

INSERT INTO kw_doc VALUES (1,1);
INSERT INTO kw_doc VALUES (1,2);
INSERT INTO kw_doc VALUES (2,2);

--
-- 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 VALUES (1,0,'head_block','hi there');
INSERT INTO page_data_simple VALUES (1,0,'footer_block','hi there --');
INSERT INTO page_data_simple VALUES (2,0,'search','./index.cgi?page=400');
INSERT INTO page_data_simple VALUES (2,5,'accept','./index.cgi?page=700');
INSERT INTO page_data_simple VALUES (2,0,'add new','./index.cgi?page=700');
INSERT INTO page_data_simple VALUES (1,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 VALUES (400,0,'head_block','search');
INSERT INTO page_data_simple VALUES (400,0,'footer_block','search footer');
INSERT INTO page_data_simple VALUES (400,0,'main_text','<form method=\"post\" action=\"./index.cgi\">\n    <input type=\"hidden\" name=\"page\" value=\"500\">\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 VALUES (300,0,'main_text','you are now logged out! ');
INSERT INTO page_data_simple VALUES (2,0,'list items','./index.cgi?page=500');
INSERT INTO page_data_simple VALUES (500,0,'head_block','results header');
INSERT INTO page_data_simple VALUES (500,0,'footer_block','results footer');
INSERT INTO page_data_simple VALUES (600,0,'head_block','details header');
INSERT INTO page_data_simple VALUES (600,0,'footer_block','details footer');
INSERT INTO page_data_simple VALUES (700,0,'head_block','entry header');
INSERT INTO page_data_simple VALUES (700,0,'footer_block','entry footer');
INSERT INTO page_data_simple VALUES (750,0,'footer_block','success footer');
INSERT INTO page_data_simple VALUES (750,0,'head_block','success header');
INSERT INTO page_data_simple VALUES (750,0,'main_text','file successfully uploaded');
INSERT INTO page_data_simple VALUES (800,0,'head_block','author information');
INSERT INTO page_data_simple VALUES (800,0,'footer_block','author information');

--
-- 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 VALUES (1,'top level page','<html>\n<head><title>main</title><head>\n<body>\n<table width=\"100%%\" border=\"1\">\n<tr><td colspan=\"2\" align=\"right\">%(login_status)s</td></tr>\n<tr><td colspan=\"2\" align=\"center\">%(head_block)s</td></tr>\n<tr>\n\n<tr>\n<td>%(left_bar)s</td>\n<td>%(main_text)s</td>\n</tr>\n\n<tr><td colspan=\"2\" align=\"center\">%(footer_block)s</td></tr>\n</table>\n</body>\n</html>');
INSERT INTO page_templates VALUES (3,'main_text','%(main_text)s');
INSERT INTO page_templates VALUES (4,'menu_bar','<a href=\"%s\">%s</a>');
INSERT INTO page_templates VALUES (501,'search_template_line','<a href=\"./index.cgi?page=600&item_id=%s\">%s</a><br>');
INSERT INTO page_templates VALUES (502,'search_template_body','%s');
INSERT INTO page_templates VALUES (600,'results_template_body','%(doc_id)s\n<BR>\nPublication Date: %(pub_date)s\n<BR> \nTitle: %(title)s\n<BR> \nShort Description: %(short_desc)s\n<BR> \n Long Description: %(long_desc)s\n<BR>Authors: %(the_authors)s<BR>%(download)s');
INSERT INTO page_templates VALUES (700,'entry_template_body','\n<form ENCTYPE=\"multipart/form-data\" action=\"./index.cgi\" method=\"post\">\n<input type=\"hidden\" name=\"page\" value=\"upload\">\n<input type=\"hidden\" name=\"action\" value=\"upload\">\n<table>\n\n\n<tr><td>Publication Date</td><td> <input type=\"text\" size=\"64\"name=\"pub_date\"></td></tr>\n    <tr><td>Title</td><td> <input type=\"text\" size=\"64\" name=\"title\"></td></tr>\n    <tr><td>Short Description</td><td> <input type=\"text\" size=\"64\" name=\"short_desc\"></td></tr>\n    <tr><td>Long Decription</td><td>\n    <textarea name=\"long_desc\" rows=\"8\" cols=\"64\"></textarea></td></tr>\n    <tr><td>Authors</td><td> <select name=\"authors\" multiple size=\"10\">\n        %(author_list)s\n        </select>\n        </td></tr>\n\n    <tr><td>File</td><td><input type=\"file\" name=\"filename\"></td></tr>\n\n<tr><td><input type=\"submit\" value=\"Submit\"></td></tr>\n</table>\n\n</form>');
INSERT INTO page_templates VALUES (800,'author_template_body','<table>\n    <tr><td>Name</td><td> %(name)s</td></tr>\n    <tr><td>Email</td><td> %(email_address)s</td></tr>\n    <tr><td>Notes</td><td> %(notes)s</td></tr>\n</table>\n');

--
-- 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,
  sub_type int(11) default NULL
) TYPE=MyISAM;

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

INSERT INTO pages VALUES (1,1,1,-1,1,0,'top_page',1);
INSERT INTO pages VALUES (2,2,1,1,4,0,'menu_bar',NULL);
INSERT INTO pages VALUES (3,1,0,1,3,0,'main_text',NULL);
INSERT INTO pages VALUES (10,1,1,-1,1,0,'top_page',NULL);
INSERT INTO pages VALUES (2,2,1,10,4,0,'menu_bar',NULL);
INSERT INTO pages VALUES (12,1,0,10,3,0,'main_text',NULL);
INSERT INTO pages VALUES (300,1,1,-1,1,0,'logout_page',NULL);
INSERT INTO pages VALUES (2,2,1,300,4,0,'menu_bar',NULL);
INSERT INTO pages VALUES (302,1,0,300,3,0,'main_text',NULL);
INSERT INTO pages VALUES (400,1,0,400,1,0,'main_text',NULL);
INSERT INTO pages VALUES (500,2,0,500,2,0,'main_text',NULL);
INSERT INTO pages VALUES (600,3,0,600,2,0,'main_text',NULL);
INSERT INTO pages VALUES (700,4,0,700,2,0,'main_text',0);
INSERT INTO pages VALUES (750,1,0,250,1,0,'main_text',0);
INSERT INTO pages VALUES (800,5,0,250,1,0,'main_text',0);

--
-- Table structure for table 'research_groups'
--

CREATE TABLE research_groups (
  group_id int(11) default NULL,
  group_name varchar(255) default NULL,
  notes text
) TYPE=MyISAM;

--
-- Dumping data for table 'research_groups'
--


--
-- Table structure for table 'users'
--

CREATE TABLE users (
  username char(20) default NULL,
  passwd char(20) default NULL,
  user_id int(11) NOT NULL auto_increment,
  auth_level int(11) default NULL,
  PRIMARY KEY  (user_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'users'
--

INSERT INTO users VALUES ('foo','bar',1,1);
INSERT INTO users VALUES ('nigel','stanger',2,10);