nigel.stanger / Digital_Repository
Transfer to URL with SHA Find file
Newer
Older
Digital_Repository / Old / pysocks / pysocks.current.dump
nstanger on 12 Nov 2005 10 KB - Second attempt at importing!
Raw Blame History 
  1. -- MySQL dump 9.07
  2. --
  3. -- Host: localhost    Database: pysocks
  4. ---------------------------------------------------------
  5. -- Server version	4.0.12-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.  
  24. --
  25. -- Table structure for table 'doc_auth'
  26. --
  27.  
  28. CREATE TABLE doc_auth (
  29.   author_id int(11) default NULL,
  30.   document_id int(11) default NULL
  31. ) TYPE=MyISAM;
  32.  
  33. --
  34. -- Dumping data for table 'doc_auth'
  35. --
  36.  
  37. INSERT INTO doc_auth (author_id, document_id) VALUES (1,1);
  38. INSERT INTO doc_auth (author_id, document_id) VALUES (2,2);
  39.  
  40. --
  41. -- Table structure for table 'document_authors'
  42. --
  43.  
  44. CREATE TABLE document_authors (
  45.   author_id int(11) NOT NULL auto_increment,
  46.   name varchar(255) default NULL,
  47.   is_local int(11) default NULL,
  48.   email_address varchar(255) default NULL,
  49.   department_id int(11) default NULL,
  50.   notes text,
  51.   PRIMARY KEY  (author_id)
  52. ) TYPE=MyISAM;
  53.  
  54. --
  55. -- Dumping data for table 'document_authors'
  56. --
  57.  
  58. INSERT INTO document_authors (author_id, name, is_local, email_address, department_id, notes) VALUES (1,'Nigel Stanger',1,'nigel@whatever',1,'some strange guy who does things with databases');
  59. INSERT INTO document_authors (author_id, name, is_local, email_address, department_id, notes) VALUES (2,'Joe Skinner',0,'crypt@here',0,'some strange guy who does things with databases');
  60.  
  61. --
  62. -- Table structure for table 'document_data'
  63. --
  64.  
  65. CREATE TABLE document_data (
  66.   doc_id int(11) default NULL,
  67.   the_doc mediumtext
  68. ) TYPE=MyISAM;
  69.  
  70. --
  71. -- Dumping data for table 'document_data'
  72. --
  73.  
  74.  
  75. --
  76. -- Table structure for table 'document_info'
  77. --
  78.  
  79. CREATE TABLE document_info (
  80.   doc_id int(11) default NULL,
  81.   author_id int(11) default NULL,
  82.   pub_date date default NULL,
  83.   has_blob int(11) default NULL,
  84.   is_active int(11) default NULL,
  85.   title varchar(255) default NULL,
  86.   short_desc varchar(255) default NULL,
  87.   long_desc text
  88. ) TYPE=MyISAM;
  89.  
  90. --
  91. -- Dumping data for table 'document_info'
  92. --
  93.  
  94. INSERT INTO document_info (doc_id, author_id, pub_date, has_blob, is_active, title, short_desc, long_desc) VALUES (1,1,'2003-05-17',0,1,'once upon a time - a story about computers','blah blah blah','the same but longer');
  95. INSERT INTO document_info (doc_id, author_id, pub_date, has_blob, is_active, title, short_desc, long_desc) 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');
  96.  
  97. --
  98. -- Table structure for table 'keywords'
  99. --
  100.  
  101. CREATE TABLE keywords (
  102.   keyword_id int(11) default NULL,
  103.   keyword char(255) default NULL
  104. ) TYPE=MyISAM;
  105.  
  106. --
  107. -- Dumping data for table 'keywords'
  108. --
  109.  
  110. INSERT INTO keywords (keyword_id, keyword) VALUES (1,'bad');
  111.  
  112. --
  113. -- Table structure for table 'kw_doc'
  114. --
  115.  
  116. CREATE TABLE kw_doc (
  117.   keyword_id int(11) default NULL,
  118.   doc_id int(11) default NULL
  119. ) TYPE=MyISAM;
  120.  
  121. --
  122. -- Dumping data for table 'kw_doc'
  123. --
  124.  
  125. INSERT INTO kw_doc (keyword_id, doc_id) VALUES (1,1);
  126. INSERT INTO kw_doc (keyword_id, doc_id) VALUES (1,2);
  127.  
  128. --
  129. -- Table structure for table 'page_data_simple'
  130. --
  131.  
  132. CREATE TABLE page_data_simple (
  133.   page_id int(11) default NULL,
  134.   auth_level int(11) default NULL,
  135.   item_name varchar(80) default NULL,
  136.   item_data mediumtext
  137. ) TYPE=MyISAM;
  138.  
  139. --
  140. -- Dumping data for table 'page_data_simple'
  141. --
  142.  
  143. INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (1,0,'head_block','hi there');
  144. INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (1,0,'footer_block','hi there --');
  145. INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (2,0,'login','./index.cgi?page=200');
  146. INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (2,0,'logout','./index.cgi?page=300');
  147. INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (2,0,'search','./index.cgi?page=400');
  148. INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (2,0,'accept','url-link');
  149. INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (2,0,'add new','url-link');
  150. INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) 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.\" ');
  151. INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (400,0,'head_block','search');
  152. INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (400,0,'footer_block','search footer');
  153. INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) 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>');
  154. INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (300,0,'main_text','you are now logged out! ');
  155. INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (2,0,'list items','./index.cgi?page=500');
  156. INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (500,0,'head_block','results header');
  157. INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (500,0,'footer_block','results footer');
  158. INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (600,0,'head_block','details header');
  159. INSERT INTO page_data_simple (page_id, auth_level, item_name, item_data) VALUES (600,0,'footer_block','details footer');
  160.  
  161. --
  162. -- Table structure for table 'page_templates'
  163. --
  164.  
  165. CREATE TABLE page_templates (
  166.   template_id int(11) default NULL,
  167.   template_name varchar(255) default NULL,
  168.   template mediumtext
  169. ) TYPE=MyISAM;
  170.  
  171. --
  172. -- Dumping data for table 'page_templates'
  173. --
  174.  
  175. 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\">
  176. <tr><td colspan=\"2\" align=\"right\">%(login_status)s</td></tr>
  177. <tr><td colspan=\"2\" align=\"center\">%(head_block)s</td></tr>\n<tr>
  178. \n<tr>\n<td>%(left_bar)s</td>\n<td>%(main_text)s</td>\n</tr>\n
  179. <tr><td colspan=\"2\" align=\"center\">%(footer_block)s</td></tr>\n</table>\n</body>\n</html>');
  180. INSERT INTO page_templates (template_id, template_name, template) VALUES (3,'main_text','%(main_text)s');
  181. INSERT INTO page_templates (template_id, template_name, template) VALUES (4,'menu_bar','<a href=\"%s\">%s</a>');
  182. INSERT INTO page_templates (template_id, template_name, template) VALUES (501,'search_template_line','<a href=\"./index.cgi?page=600&item_id=%s\">%s</a><br>');
  183. INSERT INTO page_templates (template_id, template_name, template) VALUES (502,'search_template_body','%s');
  184. INSERT INTO page_templates (template_id, template_name, template) 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>');
  185.  
  186. --
  187. -- Table structure for table 'pages'
  188. --
  189.  
  190. CREATE TABLE pages (
  191.   page_id int(11) default NULL,
  192.   page_type int(11) default NULL,
  193.   has_subparts int(11) default NULL,
  194.   parent int(11) default NULL,
  195.   template_id int(11) default NULL,
  196.   auth_level int(11) default NULL,
  197.   name char(80) default NULL,
  198.   sub_type int(11) default NULL
  199. ) TYPE=MyISAM;
  200.  
  201. --
  202. -- Dumping data for table 'pages'
  203. --
  204.  
  205. INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name, sub_type) VALUES (1,1,1,-1,1,0,'top_page',1);
  206. INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name, sub_type) VALUES (2,2,1,1,4,0,'menu_bar',NULL);
  207. INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name, sub_type) VALUES (3,1,0,1,3,0,'main_text',NULL);
  208. INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name, sub_type) VALUES (10,1,1,-1,1,0,'top_page',NULL);
  209. INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name, sub_type) VALUES (2,2,1,10,4,0,'menu_bar',NULL);
  210. INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name, sub_type) VALUES (12,1,0,10,3,0,'main_text',NULL);
  211. INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name, sub_type) VALUES (300,1,1,-1,1,0,'logout_page',NULL);
  212. INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name, sub_type) VALUES (2,2,1,300,4,0,'menu_bar',NULL);
  213. INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name, sub_type) VALUES (302,1,0,300,3,0,'main_text',NULL);
  214. INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name, sub_type) VALUES (400,1,0,400,1,0,'main_text',NULL);
  215. INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name, sub_type) VALUES (500,2,0,500,2,0,'main_text',NULL);
  216. INSERT INTO pages (page_id, page_type, has_subparts, parent, template_id, auth_level, name, sub_type) VALUES (600,3,0,600,2,0,'main_text',NULL);
  217.  
  218. --
  219. -- Table structure for table 'research_groups'
  220. --
  221.  
  222. CREATE TABLE research_groups (
  223.   group_id int(11) default NULL,
  224.   group_name varchar(255) default NULL,
  225.   notes text
  226. ) TYPE=MyISAM;
  227.  
  228. --
  229. -- Dumping data for table 'research_groups'
  230. --
  231.  
  232.