nigel.stanger / Digital_Repository
Transfer to URL with SHA Find file
Newer
Older
Digital_Repository / Old / pysocks / latest.sql
nstanger on 12 Nov 2005 27 KB - Second attempt at importing!
Raw Blame History 
  1. -- MySQL dump 9.08
  2. --
  3. -- Host: localhost    Database: pysocks
  4. ---------------------------------------------------------
  5. -- Server version	4.0.13-log
  6.  
  7. --
  8. -- Table structure for table 'auth'
  9. --
  10.  
  11. CREATE TABLE auth (
  12.   auth_id int(11) NOT NULL auto_increment,
  13.   the_time datetime default NULL,
  14.   user_id int(11) default NULL,
  15.   status int(11) default NULL,
  16.   PRIMARY KEY  (auth_id)
  17. ) TYPE=MyISAM;
  18.  
  19. --
  20. -- Dumping data for table 'auth'
  21. --
  22.  
  23. INSERT INTO auth VALUES (12,NULL,NULL,0);
  24. INSERT INTO auth VALUES (13,NULL,NULL,0);
  25. INSERT INTO auth VALUES (14,NULL,NULL,0);
  26. INSERT INTO auth VALUES (15,NULL,NULL,0);
  27. INSERT INTO auth VALUES (16,NULL,NULL,0);
  28. INSERT INTO auth VALUES (17,NULL,NULL,0);
  29. INSERT INTO auth VALUES (18,NULL,NULL,0);
  30. INSERT INTO auth VALUES (19,NULL,NULL,0);
  31. INSERT INTO auth VALUES (20,NULL,NULL,0);
  32. INSERT INTO auth VALUES (21,NULL,NULL,0);
  33. INSERT INTO auth VALUES (22,NULL,NULL,0);
  34. INSERT INTO auth VALUES (23,NULL,NULL,0);
  35. INSERT INTO auth VALUES (24,NULL,NULL,0);
  36. INSERT INTO auth VALUES (25,NULL,NULL,0);
  37. INSERT INTO auth VALUES (26,NULL,NULL,0);
  38. INSERT INTO auth VALUES (27,NULL,NULL,0);
  39. INSERT INTO auth VALUES (28,NULL,NULL,0);
  40. INSERT INTO auth VALUES (29,NULL,NULL,0);
  41. INSERT INTO auth VALUES (30,NULL,NULL,0);
  42. INSERT INTO auth VALUES (31,NULL,NULL,0);
  43. INSERT INTO auth VALUES (32,NULL,NULL,0);
  44. INSERT INTO auth VALUES (33,NULL,NULL,0);
  45. INSERT INTO auth VALUES (34,NULL,NULL,0);
  46. INSERT INTO auth VALUES (35,NULL,NULL,0);
  47. INSERT INTO auth VALUES (36,NULL,NULL,0);
  48. INSERT INTO auth VALUES (37,NULL,NULL,0);
  49. INSERT INTO auth VALUES (38,NULL,NULL,0);
  50. INSERT INTO auth VALUES (39,NULL,NULL,0);
  51. INSERT INTO auth VALUES (40,NULL,NULL,0);
  52. INSERT INTO auth VALUES (41,NULL,NULL,0);
  53. INSERT INTO auth VALUES (42,NULL,NULL,0);
  54. INSERT INTO auth VALUES (43,NULL,NULL,0);
  55. INSERT INTO auth VALUES (44,NULL,NULL,0);
  56. INSERT INTO auth VALUES (45,NULL,NULL,0);
  57. INSERT INTO auth VALUES (46,NULL,NULL,0);
  58. INSERT INTO auth VALUES (47,NULL,NULL,0);
  59. INSERT INTO auth VALUES (48,NULL,NULL,0);
  60. INSERT INTO auth VALUES (49,NULL,NULL,0);
  61. INSERT INTO auth VALUES (50,NULL,NULL,0);
  62. INSERT INTO auth VALUES (51,NULL,NULL,0);
  63. INSERT INTO auth VALUES (52,NULL,NULL,0);
  64. INSERT INTO auth VALUES (53,NULL,NULL,0);
  65. INSERT INTO auth VALUES (54,NULL,NULL,0);
  66. INSERT INTO auth VALUES (55,NULL,NULL,0);
  67. INSERT INTO auth VALUES (56,NULL,NULL,0);
  68. INSERT INTO auth VALUES (57,NULL,NULL,0);
  69. INSERT INTO auth VALUES (58,NULL,NULL,0);
  70. INSERT INTO auth VALUES (59,NULL,NULL,0);
  71. INSERT INTO auth VALUES (60,NULL,NULL,0);
  72.  
  73. --
  74. -- Table structure for table 'doc_auth'
  75. --
  76.  
  77. CREATE TABLE doc_auth (
  78.   author_id int(11) default NULL,
  79.   document_id int(11) default NULL
  80. ) TYPE=MyISAM;
  81.  
  82. --
  83. -- Dumping data for table 'doc_auth'
  84. --
  85.  
  86. INSERT INTO doc_auth VALUES (1,1);
  87. INSERT INTO doc_auth VALUES (2,2);
  88. INSERT INTO doc_auth VALUES (0,0);
  89. INSERT INTO doc_auth VALUES (0,0);
  90. INSERT INTO doc_auth VALUES (0,0);
  91. INSERT INTO doc_auth VALUES (0,0);
  92. INSERT INTO doc_auth VALUES (0,0);
  93. INSERT INTO doc_auth VALUES (0,0);
  94. INSERT INTO doc_auth VALUES (0,0);
  95. INSERT INTO doc_auth VALUES (0,0);
  96. INSERT INTO doc_auth VALUES (0,4);
  97. INSERT INTO doc_auth VALUES (2,5);
  98. INSERT INTO doc_auth VALUES (2,6);
  99. INSERT INTO doc_auth VALUES (2,7);
  100. INSERT INTO doc_auth VALUES (2,8);
  101. INSERT INTO doc_auth VALUES (2,9);
  102. INSERT INTO doc_auth VALUES (2,10);
  103. INSERT INTO doc_auth VALUES (2,11);
  104. INSERT INTO doc_auth VALUES (2,12);
  105. INSERT INTO doc_auth VALUES (2,13);
  106.  
  107. --
  108. -- Table structure for table 'document_authors'
  109. --
  110.  
  111. CREATE TABLE document_authors (
  112.   author_id int(11) NOT NULL auto_increment,
  113.   name varchar(255) default NULL,
  114.   is_local int(11) default NULL,
  115.   email_address varchar(255) default NULL,
  116.   department_id int(11) default NULL,
  117.   notes text,
  118.   PRIMARY KEY  (author_id)
  119. ) TYPE=MyISAM;
  120.  
  121. --
  122. -- Dumping data for table 'document_authors'
  123. --
  124.  
  125. INSERT INTO document_authors VALUES (1,'Nigel Stanger',1,'nigel@whatever',1,'some strange guy who does things with databases');
  126. INSERT INTO document_authors VALUES (2,'Joe Skinner',0,'crypt@here',0,'some strange guy who does things with databases');
  127. INSERT INTO document_authors VALUES (3,'Someone Else',0,'elsewhere@there',0,'this is another person to show that we can have 3');
  128.  
  129. --
  130. -- Table structure for table 'document_data'
  131. --
  132.  
  133. CREATE TABLE document_data (
  134.   doc_id int(11) default NULL,
  135.   the_doc mediumtext,
  136.   filename varchar(80) default NULL
  137. ) TYPE=MyISAM;
  138.  
  139. --
  140. -- Dumping data for table 'document_data'
  141. --
  142.  
  143. INSERT INTO document_data VALUES (1,'this is my document','fodo');
  144. INSERT INTO document_data VALUES (0,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
  145. INSERT INTO document_data VALUES (0,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
  146. INSERT INTO document_data VALUES (0,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
  147. INSERT INTO document_data VALUES (0,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
  148. INSERT INTO document_data VALUES (0,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
  149. INSERT INTO document_data VALUES (0,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
  150. INSERT INTO document_data VALUES (0,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
  151. INSERT INTO document_data VALUES (0,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
  152. INSERT INTO document_data VALUES (4,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
  153. INSERT INTO document_data VALUES (5,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
  154. INSERT INTO document_data VALUES (6,'Null','#! /usr/bin/python\n\n#-----------------------------------------------------------');
  155. 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');
  156. INSERT INTO document_data VALUES (8,'','');
  157. 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');
  158. 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');
  159. 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');
  160. 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');
  161. 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');
  162.  
  163. --
  164. -- Table structure for table 'document_info'
  165. --
  166.  
  167. CREATE TABLE document_info (
  168.   doc_id int(11) NOT NULL auto_increment,
  169.   author_id int(11) default NULL,
  170.   pub_date date default NULL,
  171.   has_blob int(11) default NULL,
  172.   is_active int(11) default NULL,
  173.   title varchar(255) default NULL,
  174.   short_desc varchar(255) default NULL,
  175.   long_desc text,
  176.   PRIMARY KEY  (doc_id)
  177. ) TYPE=MyISAM;
  178.  
  179. --
  180. -- Dumping data for table 'document_info'
  181. --
  182.  
  183. 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');
  184. 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');
  185. INSERT INTO document_info VALUES (3,NULL,'2003-06-26',1,NULL,'dfasd','kkkkkkkkkkkkkkkkk','dfgsdfgsdff');
  186. INSERT INTO document_info VALUES (4,NULL,'2003-06-26',1,NULL,'stress','dsafsd','sdfkjasdf');
  187. INSERT INTO document_info VALUES (5,NULL,'2003-06-26',1,NULL,'less stress','sdfasd','dsfsda');
  188. INSERT INTO document_info VALUES (6,NULL,'2003-06-26',1,NULL,'less stress','sdfasd','dsfsda');
  189. INSERT INTO document_info VALUES (7,NULL,'2003-06-26',1,NULL,'less stress','sdfasd','dsfsda');
  190. INSERT INTO document_info VALUES (8,NULL,'2003-06-26',0,NULL,'seeing the light','dfads','dfasdf');
  191. INSERT INTO document_info VALUES (9,NULL,'2003-06-26',1,NULL,'seeing the light - 2','dfads','dfasdf');
  192. INSERT INTO document_info VALUES (10,NULL,'2003-06-26',1,NULL,'seeing the light - 2','dfads','dfasdf');
  193. INSERT INTO document_info VALUES (11,NULL,'2003-06-26',1,NULL,'less stress','sdfasd','dsfsda');
  194. INSERT INTO document_info VALUES (12,NULL,'2003-06-26',1,NULL,'less stress','sdfasd','dsfsda');
  195. INSERT INTO document_info VALUES (13,NULL,'2003-06-26',1,NULL,'less stress','sdfasd','dsfsda');
  196.  
  197. --
  198. -- Table structure for table 'keywords'
  199. --
  200.  
  201. CREATE TABLE keywords (
  202.   keyword_id int(11) default NULL,
  203.   keyword char(255) default NULL
  204. ) TYPE=MyISAM;
  205.  
  206. --
  207. -- Dumping data for table 'keywords'
  208. --
  209.  
  210. INSERT INTO keywords VALUES (1,'bad');
  211. INSERT INTO keywords VALUES (2,'worse');
  212.  
  213. --
  214. -- Table structure for table 'kw_doc'
  215. --
  216.  
  217. CREATE TABLE kw_doc (
  218.   keyword_id int(11) default NULL,
  219.   doc_id int(11) default NULL
  220. ) TYPE=MyISAM;
  221.  
  222. --
  223. -- Dumping data for table 'kw_doc'
  224. --
  225.  
  226. INSERT INTO kw_doc VALUES (1,1);
  227. INSERT INTO kw_doc VALUES (1,2);
  228. INSERT INTO kw_doc VALUES (2,2);
  229.  
  230. --
  231. -- Table structure for table 'page_data_simple'
  232. --
  233.  
  234. CREATE TABLE page_data_simple (
  235.   page_id int(11) default NULL,
  236.   auth_level int(11) default NULL,
  237.   item_name varchar(80) default NULL,
  238.   item_data mediumtext
  239. ) TYPE=MyISAM;
  240.  
  241. --
  242. -- Dumping data for table 'page_data_simple'
  243. --
  244.  
  245. INSERT INTO page_data_simple VALUES (1,0,'head_block','hi there');
  246. INSERT INTO page_data_simple VALUES (1,0,'footer_block','hi there --');
  247. INSERT INTO page_data_simple VALUES (2,0,'search','./index.cgi?page=400');
  248. INSERT INTO page_data_simple VALUES (2,5,'accept','./index.cgi?page=700');
  249. INSERT INTO page_data_simple VALUES (2,0,'add new','./index.cgi?page=700');
  250. 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.\" ');
  251. INSERT INTO page_data_simple VALUES (400,0,'head_block','search');
  252. INSERT INTO page_data_simple VALUES (400,0,'footer_block','search footer');
  253. 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>');
  254. INSERT INTO page_data_simple VALUES (300,0,'main_text','you are now logged out! ');
  255. INSERT INTO page_data_simple VALUES (2,0,'list items','./index.cgi?page=500');
  256. INSERT INTO page_data_simple VALUES (500,0,'head_block','results header');
  257. INSERT INTO page_data_simple VALUES (500,0,'footer_block','results footer');
  258. INSERT INTO page_data_simple VALUES (600,0,'head_block','details header');
  259. INSERT INTO page_data_simple VALUES (600,0,'footer_block','details footer');
  260. INSERT INTO page_data_simple VALUES (700,0,'head_block','entry header');
  261. INSERT INTO page_data_simple VALUES (700,0,'footer_block','entry footer');
  262. INSERT INTO page_data_simple VALUES (750,0,'footer_block','success footer');
  263. INSERT INTO page_data_simple VALUES (750,0,'head_block','success header');
  264. INSERT INTO page_data_simple VALUES (750,0,'main_text','file successfully uploaded');
  265. INSERT INTO page_data_simple VALUES (800,0,'head_block','author information');
  266. INSERT INTO page_data_simple VALUES (800,0,'footer_block','author information');
  267.  
  268. --
  269. -- Table structure for table 'page_templates'
  270. --
  271.  
  272. CREATE TABLE page_templates (
  273.   template_id int(11) default NULL,
  274.   template_name varchar(255) default NULL,
  275.   template mediumtext
  276. ) TYPE=MyISAM;
  277.  
  278. --
  279. -- Dumping data for table 'page_templates'
  280. --
  281.  
  282. 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>');
  283. INSERT INTO page_templates VALUES (3,'main_text','%(main_text)s');
  284. INSERT INTO page_templates VALUES (4,'menu_bar','<a href=\"%s\">%s</a>');
  285. INSERT INTO page_templates VALUES (501,'search_template_line','<a href=\"./index.cgi?page=600&item_id=%s\">%s</a><br>');
  286. INSERT INTO page_templates VALUES (502,'search_template_body','%s');
  287. 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');
  288. 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>');
  289. 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');
  290.  
  291. --
  292. -- Table structure for table 'pages'
  293. --
  294.  
  295. CREATE TABLE pages (
  296.   page_id int(11) default NULL,
  297.   page_type int(11) default NULL,
  298.   has_subparts int(11) default NULL,
  299.   parent int(11) default NULL,
  300.   template_id int(11) default NULL,
  301.   auth_level int(11) default NULL,
  302.   name char(80) default NULL,
  303.   sub_type int(11) default NULL
  304. ) TYPE=MyISAM;
  305.  
  306. --
  307. -- Dumping data for table 'pages'
  308. --
  309.  
  310. INSERT INTO pages VALUES (1,1,1,-1,1,0,'top_page',1);
  311. INSERT INTO pages VALUES (2,2,1,1,4,0,'menu_bar',NULL);
  312. INSERT INTO pages VALUES (3,1,0,1,3,0,'main_text',NULL);
  313. INSERT INTO pages VALUES (10,1,1,-1,1,0,'top_page',NULL);
  314. INSERT INTO pages VALUES (2,2,1,10,4,0,'menu_bar',NULL);
  315. INSERT INTO pages VALUES (12,1,0,10,3,0,'main_text',NULL);
  316. INSERT INTO pages VALUES (300,1,1,-1,1,0,'logout_page',NULL);
  317. INSERT INTO pages VALUES (2,2,1,300,4,0,'menu_bar',NULL);
  318. INSERT INTO pages VALUES (302,1,0,300,3,0,'main_text',NULL);
  319. INSERT INTO pages VALUES (400,1,0,400,1,0,'main_text',NULL);
  320. INSERT INTO pages VALUES (500,2,0,500,2,0,'main_text',NULL);
  321. INSERT INTO pages VALUES (600,3,0,600,2,0,'main_text',NULL);
  322. INSERT INTO pages VALUES (700,4,0,700,2,0,'main_text',0);
  323. INSERT INTO pages VALUES (750,1,0,250,1,0,'main_text',0);
  324. INSERT INTO pages VALUES (800,5,0,250,1,0,'main_text',0);
  325.  
  326. --
  327. -- Table structure for table 'research_groups'
  328. --
  329.  
  330. CREATE TABLE research_groups (
  331.   group_id int(11) default NULL,
  332.   group_name varchar(255) default NULL,
  333.   notes text
  334. ) TYPE=MyISAM;
  335.  
  336. --
  337. -- Dumping data for table 'research_groups'
  338. --
  339.  
  340.  
  341. --
  342. -- Table structure for table 'users'
  343. --
  344.  
  345. CREATE TABLE users (
  346.   username char(20) default NULL,
  347.   passwd char(20) default NULL,
  348.   user_id int(11) NOT NULL auto_increment,
  349.   auth_level int(11) default NULL,
  350.   PRIMARY KEY  (user_id)
  351. ) TYPE=MyISAM;
  352.  
  353. --
  354. -- Dumping data for table 'users'
  355. --
  356.  
  357. INSERT INTO users VALUES ('foo','bar',1,1);
  358. INSERT INTO users VALUES ('nigel','stanger',2,10);
  359.