Commit info for scoop/struct: Modified Files: scoop.sql Log Message: Oops, forgot to update scoop.sql -janra Index: scoop.sql =================================================================== RCS file: /cvs/scoop/scoop/struct/scoop.sql,v retrieving revision 1.193 retrieving revision 1.194 diff -r1.193 -r1.194 1,9c1,9 < -- MySQL dump 9.10 < -- < -- Host: localhost Database: scoop < -- ------------------------------------------------------ < -- Server version 4.0.17-log < < -- < -- Table structure for table `ad_info` < -- --- > # MySQL dump 8.14 > # > # Host: localhost Database: scoopdev > #-------------------------------------------------------- > # Server version 3.23.39-log > > # > # Table structure for table 'ad_info' > # 42c42 < ); --- > ) TYPE=MyISAM; 44,46c44,46 < -- < -- Dumping data for table `ad_info` < -- --- > # > # Dumping data for table 'ad_info' > # 48c48 < INSERT INTO ad_info VALUES (1,'text_ad_template','7981192.png','http://scoop.kuro5hin.org','The swiss army chainsaw of Content Management',NULL,NULL,NULL,NULL,NULL,1,NULL,1,'Scoop','2001-12-21 09:39:12',0,1,0,NULL,0,0,"0.00",NULL,NULL,NULL,1,NULL); --- > INSERT INTO ad_info VALUES (1,'text_ad_template','7981192.png','http://scoop.kuro5hin.org','The swiss army chainsaw of Content Management',NULL,NULL,NULL,NULL,NULL,1,NULL,1,'Scoop','2001-12-21 09:39:12',0,1,0,NULL,0,0,0.00,NULL,NULL,NULL,1,NULL); 50,52c50,52 < -- < -- Table structure for table `ad_log` < -- --- > # > # Table structure for table 'ad_log' > # 62c62 < ); --- > ) TYPE=MyISAM; 64,66c64,66 < -- < -- Dumping data for table `ad_log` < -- --- > # > # Dumping data for table 'ad_log' > # 69,71c69,71 < -- < -- Table structure for table `ad_payments` < -- --- > # > # Table structure for table 'ad_payments' > # 82c82 < ); --- > ) TYPE=MyISAM; 84,86c84,86 < -- < -- Dumping data for table `ad_payments` < -- --- > # > # Dumping data for table 'ad_payments' > # 89,91c89,91 < -- < -- Table structure for table `ad_types` < -- --- > # > # Table structure for table 'ad_types' > # 109c109 < ); --- > ) TYPE=MyISAM; 111,113c111,113 < -- < -- Dumping data for table `ad_types` < -- --- > # > # Dumping data for table 'ad_types' > # 115c115 < INSERT INTO ad_types VALUES ('text_ad_template','Simple Text Ad','This is a simple text advertisement that allows a title, some text, and a link to your site.','Put in your title, text, and where you want to link to below.',NULL,50,NULL,20,"2.50",1,1000,1000000,1,0); --- > INSERT INTO ad_types VALUES ('text_ad_template','Simple Text Ad','This is a simple text advertisement that allows a title, some text, and a link to your site.','Put in your title, text, and where you want to link to below.',NULL,50,NULL,20,2.50,1,1000,1000000,1,0); 117,119c117,119 < -- < -- Table structure for table `admin_tools` < -- --- > # > # Table structure for table 'admin_tools' > # 130c130 < ); --- > ) TYPE=MyISAM; 132,134c132,134 < -- < -- Dumping data for table `admin_tools` < -- --- > # > # Dumping data for table 'admin_tools' > # 158,160c158,160 < -- < -- Table structure for table `advertisers` < -- --- > # > # Table structure for table 'advertisers' > # 169c169 < ); --- > ) TYPE=MyISAM; 171,173c171,173 < -- < -- Dumping data for table `advertisers` < -- --- > # > # Dumping data for table 'advertisers' > # 176,178c176,178 < -- < -- Table structure for table `blocks` < -- --- > # > # Table structure for table 'blocks' > # 189c189 < ); --- > ) TYPE=MyISAM; 191,193c191,193 < -- < -- Dumping data for table `blocks` < -- --- > # > # Dumping data for table 'blocks' > # 207,208c207,208 < INSERT INTO blocks VALUES ('error_font','<FONT COLOR=\"#FF0000\">','1','','display','default','en'); < INSERT INTO blocks VALUES ('error_font_end','</FONT>','1','','display','default','en'); --- > INSERT INTO blocks VALUES ('error_font','<FONT COLOR=\"#FF0000\">','1','','Fonts','default','en'); > INSERT INTO blocks VALUES ('error_font_end','</FONT>','1','','Fonts','default','en'); 298,300c298,300 < INSERT INTO blocks VALUES ('edit_macro','<form name=\"editmacros\" action=\"%%rootdir%%/admin/macros/\" method=\"post\">\r\n<input type=\"hidden\" name=\"cat\" value=\"%%category%%\" />\r\n\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n<tr><td bgcolor=\"%%title_bgcolor%%\">%%title_font%%Macros: %%category%%%%title_font_end%%</td></tr>\r\n<tr><td>%%norm_font%%%%update_msg%%%%norm_font_end%%</td></tr>\r\n<tr><td> </td></tr>\r\n<tr><td>%%norm_font%%Choose a category to edit:%%norm_font_end%%</td></tr>\r\n<tr><td>\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"2\" width=\"100%\">%%catlist%%</table>\r\n</td></tr>\r\n<tr><td>%%norm_font%%<input type=\"submit\" name=\"save\" value=\"Save\" /> <input type=\"submit\" name=\"edit\" value=\"Get\" />%%norm_font_end%%</td></tr>\r\n<tr><td><table border=\"0\" cellpadding=\"2\" cellspacing=\"0\" width=\"100%\">%%form_body%%</table></td></tr>\r\n<tr><td>%%norm_font%%<input type=\"submit\" name=\"sa! ve\" value=\"Save\" /> <input type=\"submit\" name=\"edit\" value=\"Get\" />%%norm_font_end%%</td></tr>\r\n</table>\r\n</form>\r\n',NULL,'The main edit macro page. The special var \"form_body\" is either the single-var edit form, or the category table, depending on which view you\'re using.','admin_pages','default','en'); < INSERT INTO blocks VALUES ('edit_one_macro','<tr><td>%%norm_font%%Or edit a macro directly:%%norm_font_end%%</td></tr>\r\n<tr><td><table cellspacing=\"2\" cellpadding=\"0\" width=\"100%\">\r\n <tr>\r\n <td colspan=\"2\">%%norm_font%%<b>Delete:</b><input type=\"checkbox\" name=\"delete\" value=\"1\" />%%norm_font_end%%</td>\r\n </tr>\r\n <tr>\r\n <td>%%norm_font%%<b>Select Macro:</b>%%norm_font_end%%</td>\r\n <td>%%macroselect%%</td>\r\n <tr>\r\n <td>%%norm_font%%<b>Select Categories:</b>%%norm_font_end%%</td>\r\n <td>%%catselect%%</td>\r\n </tr>\r\n <tr>\r\n <td>%%norm_font%%<b>Name:</b>%%norm_font_end%%</td>\r\n <td><input type=\"text\" size=\"60\" name=\"name\" value=\"%%name%%\" /></td>\r\n </tr>\r\n <tr>\r\n <td>%%norm_font%%<b>New Category:</b>%%norm_font_end%%</td>\r\n <td><input type=\"text\" size=\"60\" name=\"category\" value=\"\"><br />\r\n %%norm_font%%<i>(seperate multiple categories with commas)</i>%%norm_font_end%%\r\n </td>\r\n </tr>\r\n <tr>\r\n! <td colspan=\"2\">\r\n %%norm_font%%<b>Value:</b>%%norm_font_end%%<br />\r\n <textarea cols=\"60\" rows=\"6\" name=\"value\" wrap=\"soft\">%%value%%</textarea>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td colspan=\"2\">\r\n %%norm_font%%<b>Description:</b>%%norm_font_end%%<br />\r\n <textarea cols=\"60\" rows=\"3\" name=\"description\" wrap=\"soft\">%%description%%</textarea>\r\n </td>\r\n </tr>\r\n</table></td></tr>\r\n',NULL,'','admin_pages','default','en'); < INSERT INTO blocks VALUES ('macro_category_list','<tr>\r\n <td>%%norm_font%%<a href=\"%%rootdir%%/admin/macros/%%item_url%%\">%%item%%</a>%%norm_font_end%%</td>\r\n <td>%%norm_font%%<a href=\"%%rootdir%%/admin/macros/%%item_url%%\">%%item%%</a>%%norm_font_end%%</td>\r\n <td>%%norm_font%%<a href=\"%%rootdir%%/admin/macros/%%item_url%%\">%%item%%</a>%%norm_font_end%%</td>\r\n</tr>\r\n',NULL,'One line of the macro category list. Usually one table row.','admin_pages','default','en'); --- > INSERT INTO blocks VALUES ('edit_macro','<form name=\"editmacros\" action=\"%%rootdir%%/admin/macros/\" method=\"post\">\r\n<input type=\"hidden\" name=\"cat\" value=\"%%category%%\" />\r\n\r\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n<tr><td bgcolor=\"%%title_bgcolor%%\">%%title_font%%Macros: %%category%%%%title_font_end%%</td></tr>\r\n<tr><td>%%norm_font%%%%update_msg%%%%norm_font_end%%</td></tr>\r\n<tr><td> </td></tr>\r\n<tr><td>%%norm_font%%Choose a category to edit:%%norm_font_end%%</td></tr>\r\n<tr><td>\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"2\" width=\"100%\">%%catlist%%</table>\r\n</td></tr>\r\n<tr><td>%%norm_font%%<input type=\"submit\" name=\"save\" value=\"Save\" /> <input type=\"submit\" name=\"edit\" value=\"Get\" />%%norm_font_end%%</td></tr>\r\n<tr><td><table border=\"0\" cellpadding=\"2\" cellspacing=\"0\" width=\"100%\">%%form_body%%</table></td></tr>\r\n<tr><td>%%norm_font%%<input type=\"submit\" name=\"sa! ve\" value=\"Save\" /> <input type=\"submit\" name=\"edit\" value=\"Get\" />%%norm_font_end%%</td></tr>\r\n</table>\r\n</form>\r\n',NULL,'The main edit macro page. The special var \"form_body\" is either the single-var edit form, or the category table, depending on which view you\'re using.','Admin Pages','default','en'); > INSERT INTO blocks VALUES ('edit_one_macro','<tr><td>%%norm_font%%Or edit a macro directly:%%norm_font_end%%</td></tr>\r\n<tr><td><table cellspacing=\"2\" cellpadding=\"0\" width=\"100%\">\r\n <tr>\r\n <td colspan=\"2\">%%norm_font%%<b>Delete:</b><input type=\"checkbox\" name=\"delete\" value=\"1\" />%%norm_font_end%%</td>\r\n </tr>\r\n <tr>\r\n <td>%%norm_font%%<b>Select Macro:</b>%%norm_font_end%%</td>\r\n <td>%%macroselect%%</td>\r\n <tr>\r\n <td>%%norm_font%%<b>Select Categories:</b>%%norm_font_end%%</td>\r\n <td>%%catselect%%</td>\r\n </tr>\r\n <tr>\r\n <td>%%norm_font%%<b>Name:</b>%%norm_font_end%%</td>\r\n <td><input type=\"text\" size=\"60\" name=\"name\" value=\"%%name%%\" /></td>\r\n </tr>\r\n <tr>\r\n <td>%%norm_font%%<b>New Category:</b>%%norm_font_end%%</td>\r\n <td><input type=\"text\" size=\"60\" name=\"category\" value=\"\"><br />\r\n %%norm_font%%<i>(seperate multiple categories with commas)</i>%%norm_font_end%%\r\n </td>\r\n </tr>\r\n <tr>\r\n! <td colspan=\"2\">\r\n %%norm_font%%<b>Value:</b>%%norm_font_end%%<br />\r\n <textarea cols=\"60\" rows=\"6\" name=\"value\" wrap=\"soft\">%%value%%</textarea>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td colspan=\"2\">\r\n %%norm_font%%<b>Description:</b>%%norm_font_end%%<br />\r\n <textarea cols=\"60\" rows=\"3\" name=\"description\" wrap=\"soft\">%%description%%</textarea>\r\n </td>\r\n </tr>\r\n</table></td></tr>\r\n',NULL,'','Admin Pages','default','en'); > INSERT INTO blocks VALUES ('macro_category_list','<tr>\r\n <td>%%norm_font%%<a href=\"%%rootdir%%/admin/macros/%%item_url%%\">%%item%%</a>%%norm_font_end%%</td>\r\n <td>%%norm_font%%<a href=\"%%rootdir%%/admin/macros/%%item_url%%\">%%item%%</a>%%norm_font_end%%</td>\r\n <td>%%norm_font%%<a href=\"%%rootdir%%/admin/macros/%%item_url%%\">%%item%%</a>%%norm_font_end%%</td>\r\n</tr>\r\n',NULL,'One line of the macro category list. Usually one table row.','Admin Pages','default','en'); 355,359c355,359 < INSERT INTO blocks VALUES ('ad_submitted_message','<p> Now that you\'ve submitted your ad, it has to be approved. Our crack team of site maintainers who pore over all of the ad submissions daily will notice yours has arrived, and approve it so that it can be displayed on the site. If for some reason they don\'t see fit to approve it, you will get an email sent to your real_email address explaining why.</p>\r\n%%AD_CC_PAY%%\r\n%%AD_PAYPAL_PAY%%\r\n%%AD_FREE_MESSAGE%%','1','This message is displayed when an advert has gone through all the stages of submission, apart from payment, and is waiting to be approved. If the advert needs paying for, then some more message will be displayed at the same time.\r\nIf the total cost of the advert is nothing, then |AD_FREE_MESSAGE| will be replaced by the contents of the block, ad_free_msg. AD_CC_PAY and AD_PAYPAL_PAY will be ignored.\r\nIf the site control ads_use_cc is enabled, then |AD_CC_PAY| will be replaced with the contents of th! e block ad_pay_cc_msg.\r\nIf the site control ads_use_paypal is enable, then |AD_PAYPAL_PAY| will be replaced with the contents of the block ad_pay_paypal_msg.\r\n','advertising','default','en'); < INSERT INTO blocks VALUES ('ad_renewed_message','<p>Thank you for renewing your advertisement. As it\'s already been approved, you don\'t have to wait. As soon as it\'s paid for, it will appear.</p>\r\n%%AD_CC_PAY%%\r\n%%AD_PAYPAL_PAY%%\r\n%%AD_FREE_MESSAGE%%','1','This message is displayed when an advert has gone through all the stages of renewal, apart from payment. As renewals don\'t need approving, the advert will appear as soon as it is paid for. If the advert needs paying for, then some more messages will be displayed at the same time.\r\nIf the total cost of the advert is nothing, then |AD_FREE_MESSAGE| will be replaced by the contents of the block, ad_free_msg. AD_CC_PAY and AD_PAYPAL_PAY will be ignored.\r\nIf the site control ads_use_cc is enabled, then |AD_CC_PAY| will be replaced with the contents of the block ad_pay_cc_msg.\r\nIf the site control ads_use_paypal is enable, then |AD_PAYPAL_PAY| will be replaced with the contents of the block ad_pay_paypal_msg.\! r\n','advertising','default','en'); < INSERT INTO blocks VALUES ('ad_pay_cc_msg','<p>%%norm_font%%<a\r\nhref=\"%%secure_site_url%%%%rootdir%%/special/adpay?type=cc%%payment_args%%\"><img\r\nsrc=\"%%imagedir%%/cclogos.gif\" width=\"87\" height=\"27\"\r\nborder=0 ALT=\"%%sitename%% accepts Visa and MasterCard\">\r\n<br>Pay with Visa or Mastercard</a>%%norm_font_end%%</p>','1','This message is displayed as part of the advert submission process. See the block ad_submitted_message for more information on where it will appear.\r\nThere are three special variables concerned with this. |num_impressions| will be replaced by the number of impressions ordered.\r\n|price| will be replace by the total cost of the order.\r\n|payment_args| must be present somewhere in the link url to correctly pass arguments to the payment method.','advertising','default','en'); < INSERT INTO blocks VALUES ('ad_pay_paypal_msg','<p>%%norm_font%%<a\r\nhref=\"%%secure_site_url%%%%rootdir%%/special/adpay?type=paypal%%payment_args%%\"><img\r\nsrc=\"%%imagedir%%/paypal.gif\" width=\"87\" height=\"27\"\r\nborder=0 ALT=\"Pay with Paypal\">\r\n<br>Pay with Paypal</a>%%norm_font_end%%</p>','1','This message is displayed as part of the advert submission process. See the block ad_submitted_message for more information on where it will appear.\r\nThere are three special variables concerned with this. |num_impressions| will be replaced by the number of impressions ordered.\r\n|price| will be replace by the total cost of the order.\r\n|payment_args| must be present somewhere in the link url to correctly pass arguments to the payment method.','advertising','default','en'); < INSERT INTO blocks VALUES ('ad_free_msg','<p>This ad is free, you don\'t have to pay for it.','1','This message is displayed as part of the advert submission process. See the block ad_submitted_message for more information on where it will appear.\r\nThere are two special variables concerned with this. |num_impressions| will be replaced by the number of impressions ordered.\r\n|price| will be replace by the total cost of the order.','advertising','default','en'); --- > INSERT INTO blocks VALUES ('ad_submitted_message','<p> Now that you\'ve submitted your ad, it has to be approved. Our crack team of site maintainers who pore over all of the ad submissions daily will notice yours has arrived, and approve it so that it can be displayed on the site. If for some reason they don\'t see fit to approve it, you will get an email sent to your real_email address explaining why.</p>\r\n%%AD_CC_PAY%%\r\n%%AD_PAYPAL_PAY%%\r\n%%AD_FREE_MESSAGE%%','1','This message is displayed when an advert has gone through all the stages of submission, apart from payment, and is waiting to be approved. If the advert needs paying for, then some more message will be displayed at the same time.\r\nIf the total cost of the advert is nothing, then |AD_FREE_MESSAGE| will be replaced by the contents of the block, ad_free_msg. AD_CC_PAY and AD_PAYPAL_PAY will be ignored.\r\nIf the site control ads_use_cc is enabled, then |AD_CC_PAY| will be replaced with the contents of th! e block ad_pay_cc_msg.\r\nIf the site control ads_use_paypal is enable, then |AD_PAYPAL_PAY| will be replaced with the contents of the block ad_pay_paypal_msg.\r\n','Ads','default','en'); > INSERT INTO blocks VALUES ('ad_renewed_message','<p>Thank you for renewing your advertisement. As it\'s already been approved, you don\'t have to wait. As soon as it\'s paid for, it will appear.</p>\r\n%%AD_CC_PAY%%\r\n%%AD_PAYPAL_PAY%%\r\n%%AD_FREE_MESSAGE%%','1','This message is displayed when an advert has gone through all the stages of renewal, apart from payment. As renewals don\'t need approving, the advert will appear as soon as it is paid for. If the advert needs paying for, then some more messages will be displayed at the same time.\r\nIf the total cost of the advert is nothing, then |AD_FREE_MESSAGE| will be replaced by the contents of the block, ad_free_msg. AD_CC_PAY and AD_PAYPAL_PAY will be ignored.\r\nIf the site control ads_use_cc is enabled, then |AD_CC_PAY| will be replaced with the contents of the block ad_pay_cc_msg.\r\nIf the site control ads_use_paypal is enable, then |AD_PAYPAL_PAY| will be replaced with the contents of the block ad_pay_paypal_msg.\! r\n','Ads','default','en'); > INSERT INTO blocks VALUES ('ad_pay_cc_msg','<p>%%norm_font%%<a\r\nhref=\"%%secure_site_url%%%%rootdir%%/special/adpay?type=cc%%payment_args%%\"><img\r\nsrc=\"%%imagedir%%/cclogos.gif\" width=\"87\" height=\"27\"\r\nborder=0 ALT=\"%%sitename%% accepts Visa and MasterCard\">\r\n<br>Pay with Visa or Mastercard</a>%%norm_font_end%%</p>','1','This message is displayed as part of the advert submission process. See the block ad_submitted_message for more information on where it will appear.\r\nThere are three special variables concerned with this. |num_impressions| will be replaced by the number of impressions ordered.\r\n|price| will be replace by the total cost of the order.\r\n|payment_args| must be present somewhere in the link url to correctly pass arguments to the payment method.','Ads','default','en'); > INSERT INTO blocks VALUES ('ad_pay_paypal_msg','<p>%%norm_font%%<a\r\nhref=\"%%secure_site_url%%%%rootdir%%/special/adpay?type=paypal%%payment_args%%\"><img\r\nsrc=\"%%imagedir%%/paypal.gif\" width=\"87\" height=\"27\"\r\nborder=0 ALT=\"Pay with Paypal\">\r\n<br>Pay with Paypal</a>%%norm_font_end%%</p>','1','This message is displayed as part of the advert submission process. See the block ad_submitted_message for more information on where it will appear.\r\nThere are three special variables concerned with this. |num_impressions| will be replaced by the number of impressions ordered.\r\n|price| will be replace by the total cost of the order.\r\n|payment_args| must be present somewhere in the link url to correctly pass arguments to the payment method.','Ads','default','en'); > INSERT INTO blocks VALUES ('ad_free_msg','<p>This ad is free, you don\'t have to pay for it.','1','This message is displayed as part of the advert submission process. See the block ad_submitted_message for more information on where it will appear.\r\nThere are two special variables concerned with this. |num_impressions| will be replaced by the number of impressions ordered.\r\n|price| will be replace by the total cost of the order.','Ads','default','en'); 361c361 < INSERT INTO blocks VALUES ('sub_paypal_finished','Thank you, your PayPal payment has been recieved.',NULL,'Message displayed in the body of the page after a user returns from making a paypal payment.','advertising,subscriptions','default','en'); --- > INSERT INTO blocks VALUES ('sub_paypal_finished','Thank you, your PayPal payment has been recieved.',NULL,'Message displayed in the body of the page after a user returns from making a paypal payment.','Ads,Subscriptions','default','en'); 369,371c369,371 < -- < -- Table structure for table `box` < -- --- > # > # Table structure for table 'box' > # 382c382 < ); --- > ) TYPE=MyISAM; 384,386c384,386 < -- < -- Dumping data for table `box` < -- --- > # > # Dumping data for table 'box' > # 433,435c433,435 < -- < -- Table structure for table `cache_time` < -- --- > # > # Table structure for table 'cache_time' > # 441c441 < ); --- > ) TYPE=MyISAM; 443,445c443,445 < -- < -- Dumping data for table `cache_time` < -- --- > # > # Dumping data for table 'cache_time' > # 447c447 < INSERT INTO cache_time VALUES ('refresh_all',1080447879); --- > INSERT INTO cache_time VALUES ('refresh_all',1087408229); 452c452 < INSERT INTO cache_time VALUES ('macros',1078970419); --- > INSERT INTO cache_time VALUES ('macros',1087408229); 463,466c463,472 < < -- < -- Table structure for table `commentcodes` < -- --- > INSERT INTO cache_time VALUES ('2004/1/30/11733/7275_comments',1087408195); > INSERT INTO cache_time VALUES ('2004/1/30/11244/4143_comments',1087408195); > INSERT INTO cache_time VALUES ('2004/1/16/1046/59617_comments',1087408195); > INSERT INTO cache_time VALUES ('2004/1/15/152751/014_comments',1087408195); > INSERT INTO cache_time VALUES ('2004/1/15/152446/828_comments',1087408195); > INSERT INTO cache_time VALUES ('2004/1/15/152416/551_comments',1087408195); > > # > # Table structure for table 'commentcodes' > # 472c478 < ); --- > ) TYPE=MyISAM; 474,476c480,482 < -- < -- Dumping data for table `commentcodes` < -- --- > # > # Dumping data for table 'commentcodes' > # 482,484c488,490 < -- < -- Table structure for table `commentratings` < -- --- > # > # Table structure for table 'commentratings' > # 494c500 < ); --- > ) TYPE=MyISAM; 496,498c502,504 < -- < -- Dumping data for table `commentratings` < -- --- > # > # Dumping data for table 'commentratings' > # 501,503c507,509 < -- < -- Table structure for table `comments` < -- --- > # > # Table structure for table 'comments' > # 524c530 < ); --- > ) TYPE=MyISAM; 526,528c532,534 < -- < -- Dumping data for table `comments` < -- --- > # > # Dumping data for table 'comments' > # 531,533c537,539 < -- < -- Table structure for table `cron` < -- --- > # > # Table structure for table 'cron' > # 543c549 < ); --- > ) TYPE=MyISAM; 545,547c551,553 < -- < -- Dumping data for table `cron` < -- --- > # > # Dumping data for table 'cron' > # 561,563c567,569 < -- < -- Table structure for table `displaycodes` < -- --- > # > # Table structure for table 'displaycodes' > # 569c575 < ); --- > ) TYPE=MyISAM; 571,573c577,579 < -- < -- Dumping data for table `displaycodes` < -- --- > # > # Dumping data for table 'displaycodes' > # 581,583c587,589 < -- < -- Table structure for table `editcategorycodes` < -- --- > # > # Table structure for table 'editcategorycodes' > # 590c596 < ); --- > ) TYPE=MyISAM; 592,594c598,600 < -- < -- Dumping data for table `editcategorycodes` < -- --- > # > # Dumping data for table 'editcategorycodes' > # 599,601c605,607 < -- < -- Table structure for table `hooks` < -- --- > # > # Table structure for table 'hooks' > # 609c615 < ); --- > ) TYPE=MyISAM; 611,613c617,619 < -- < -- Dumping data for table `hooks` < -- --- > # > # Dumping data for table 'hooks' > # 620,622c626,628 < -- < -- Table structure for table `log_info` < -- --- > # > # Table structure for table 'log_info' > # 634c640 < ); --- > ) TYPE=MyISAM; 636,638c642,644 < -- < -- Dumping data for table `log_info` < -- --- > # > # Dumping data for table 'log_info' > # 641,643c647,649 < -- < -- Table structure for table `log_info_extended` < -- --- > # > # Table structure for table 'log_info_extended' > # 649c655 < ); --- > ) TYPE=MyISAM; 651,653c657,659 < -- < -- Dumping data for table `log_info_extended` < -- --- > # > # Dumping data for table 'log_info_extended' > # 656,658c662,664 < -- < -- Table structure for table `macros` < -- --- > # > # Table structure for table 'macros' > # 666c672 < ); --- > ) TYPE=MyISAM; 668,670c674,676 < -- < -- Dumping data for table `macros` < -- --- > # > # Dumping data for table 'macros' > # 674,676c680,682 < -- < -- Table structure for table `ops` < -- --- > # > # Table structure for table 'ops' > # 689c695 < ); --- > ) TYPE=MyISAM; 691,693c697,699 < -- < -- Dumping data for table `ops` < -- --- > # > # Dumping data for table 'ops' > # 700c706 < INSERT INTO ops VALUES ('admin','admin_template','admin_main',0,1,'','','element.1=blocks:/tool/mode/theme/item/,\r\nelement.1=story:/tool/sid{5}/,\r\nelement.1=editpoll:/tool/editqid/option/,\r\nelement.1=vars:/tool/mode/item/,\r\nelement.1=topics:/tool/tid/,\r\nelement.1=sections:/tool/section/,\r\nelement.1=special:/tool/id/,\r\nelement.1=boxes:/tool/id,\r\nelement.1=optemplates:/tool/opcode,\r\nelement.1=groups:/tool/perm_group_id/,\r\nelement.1=rdf:/tool/action/,\r\nelement.1=cron:/tool/action/which/,\r\nelement.1=ads:/tool/type/which,\r\nelement.1=ops:/tool/opcode/,\r\nelement.1=macros:/tool/item,\r\nelement.1=storylist:/tool/,\r\nelement.1=archivelist:/tool/,\r\nelement.1=hooks:/tool/,\r\nelement.1=listpolls:/tool/,\r\nelement.1=log:/tool/log_type/page/log_id/,\r\n/tool/','Entry point to the various admin tools.'); --- > INSERT INTO ops VALUES ('admin','admin_template','admin_main',0,1,'','','element.1=blocks:/tool/mode/theme/item/,\r\nelement.1=story:/tool/sid{5}/,\r\nelement.1=editpoll:/tool/editqid/option/,\r\nelement.1=vars:/tool/mode/item/,\r\nelement.1=topics:/tool/tid/,\r\nelement.1=sections:/tool/section/,\r\nelement.1=special:/tool/id/,\r\nelement.1=boxes:/tool/id,\r\nelement.1=optemplates:/tool/opcode,\r\nelement.1=groups:/tool/perm_group_id/,\r\nelement.1=rdf:/tool/action/,\r\nelement.1=cron:/tool/action/which/,\r\nelement.1=ads:/tool/type/which,\r\nelement.1=ops:/tool/opcode/,\r\nelement.1=macros:/tool/mode/item/item,\r\nelement.1=storylist:/tool/,\r\nelement.1=archivelist:/tool/,\r\nelement.1=hooks:/tool/,\r\nelement.1=listpolls:/tool/,\r\nelement.1=log:/tool/log_type/page/log_id/,\r\n/tool/','Entry point to the various admin tools.'); 730,732c736,738 < -- < -- Table structure for table `patches` < -- --- > # > # Table structure for table 'patches' > # 740c746 < ); --- > ) TYPE=MyISAM; 742,744c748,750 < -- < -- Dumping data for table `patches` < -- --- > # > # Dumping data for table 'patches' > # 875a882,883 > INSERT INTO patches VALUES ('1_0-dev',37,'Cleanup','sql'); > INSERT INTO patches VALUES ('1_0-dev',37,NULL,'post'); 877,879c885,887 < -- < -- Table structure for table `perm_groups` < -- --- > # > # Table structure for table 'perm_groups' > # 887c895 < ); --- > ) TYPE=MyISAM; 889,891c897,899 < -- < -- Dumping data for table `perm_groups` < -- --- > # > # Dumping data for table 'perm_groups' > # 900,902c908,910 < -- < -- Table structure for table `pollanswers` < -- --- > # > # Table structure for table 'pollanswers' > # 910c918 < ); --- > ) TYPE=MyISAM; 912,914c920,922 < -- < -- Dumping data for table `pollanswers` < -- --- > # > # Dumping data for table 'pollanswers' > # 925,927c933,935 < -- < -- Table structure for table `pollquestions` < -- --- > # > # Table structure for table 'pollquestions' > # 936c944 < ); --- > ) TYPE=MyISAM; 938,940c946,948 < -- < -- Dumping data for table `pollquestions` < -- --- > # > # Dumping data for table 'pollquestions' > # 945,947c953,955 < -- < -- Table structure for table `pollvoters` < -- --- > # > # Table structure for table 'pollvoters' > # 956c964 < ); --- > ) TYPE=MyISAM; 958,960c966,968 < -- < -- Dumping data for table `pollvoters` < -- --- > # > # Dumping data for table 'pollvoters' > # 965,967c973,975 < -- < -- Table structure for table `post_throttle` < -- --- > # > # Table structure for table 'post_throttle' > # 975c983 < ); --- > ) TYPE=MyISAM; 977,979c985,987 < -- < -- Dumping data for table `post_throttle` < -- --- > # > # Dumping data for table 'post_throttle' > # 982,984c990,992 < -- < -- Table structure for table `rdf_channels` < -- --- > # > # Table structure for table 'rdf_channels' > # 1003c1011 < ); --- > ) TYPE=MyISAM; 1005,1007c1013,1015 < -- < -- Dumping data for table `rdf_channels` < -- --- > # > # Dumping data for table 'rdf_channels' > # 1013,1015c1021,1023 < -- < -- Table structure for table `rdf_items` < -- --- > # > # Table structure for table 'rdf_items' > # 1024c1032 < ); --- > ) TYPE=MyISAM; 1026,1028c1034,1036 < -- < -- Dumping data for table `rdf_items` < -- --- > # > # Dumping data for table 'rdf_items' > # 1061,1063c1069,1071 < -- < -- Table structure for table `section_perms` < -- --- > # > # Table structure for table 'section_perms' > # 1071c1079 < ); --- > ) TYPE=MyISAM; 1073,1075c1081,1083 < -- < -- Dumping data for table `section_perms` < -- --- > # > # Dumping data for table 'section_perms' > # 1096,1098c1104,1106 < -- < -- Table structure for table `sections` < -- --- > # > # Table structure for table 'sections' > # 1106c1114 < ); --- > ) TYPE=MyISAM; 1108,1110c1116,1118 < -- < -- Dumping data for table `sections` < -- --- > # > # Dumping data for table 'sections' > # 1116,1118c1124,1126 < -- < -- Table structure for table `sessions` < -- --- > # > # Table structure for table 'sessions' > # 1126c1134,1139 < ); --- > ) TYPE=MyISAM; > > # > # Dumping data for table 'sessions' > # > 1128,1138c1141,1143 < -- < -- Dumping data for table `sessions` < -- < < INSERT INTO sessions VALUES (20040310230057,'9360b79fd2a39561ee1d8666c2bc5539',NULL,'\0\0\0\0\0\0\0\0\0\n89360b79fd2a39561ee1d8666c2bc5539:64.180.125.197:UzhRrIyv @P\n \0\0\0\n89360b79fd2a39561ee1d8666c2bc5539:64.180.125.197:jhPfcLho @OÈ=\0\0\0formkeys @P©\0\0\0TIME\n1\0\0\0UID\n 9360b79fd2a39561ee1d8666c2bc5539\0\0\0 _session_id'); < INSERT INTO sessions VALUES (20040313185101,'39b7bce59f5087bd6976f0abd99bd156',NULL,'\0\0\0\0\0\0\0\0\0\n839b7bce59f5087bd6976f0abd99bd156:64.180.125.197:oUqLqxAe @SÈŠ\0\0\0\n839b7bce59f5087bd6976f0abd99bd156:64.180.125.197:xjhNzZZC @SÈ€\0\0\0\n839b7bce59f5087bd6976f0abd99bd156:64.180.125.197:ySLvbfnn @R¤m\0\0\0\n839b7bce59f5087bd6976f0abd99bd156:64.180.125.197:dAQWyFMT @R¤\0\0\0\n839b7bce59f5087bd6976f0abd99bd156:64.180.125.197:hLFPcJPb @R’ü\0\0\0formkeys @SÈ•\0\0\0TIME\n1\0\0\0UID\n 39b7bce59f5087bd6976f0abd99bd156\0\0\0 _session_id'); < INSERT INTO sessions VALUES (20040312225257,'199b3b1ad26cd3896fbdfdd88b5f63fd',NULL,'\0\0\0\0\0\0\0\0\0\n8199b3b1ad26cd3896fbdfdd88b5f63fd:64.180.125.198:StPeSrNR @Rk\0\0\0\n:64.180.125.198:GHBxLDwR @RS\0\0\0formkeys @R¯É\0\0\0TIME\n 199b3b1ad26cd3896fbdfdd88b5f63fd\0\0\0 _session_id'); < < -- < -- Table structure for table `special` < -- --- > # > # Table structure for table 'special' > # 1146c1151 < ); --- > ) TYPE=MyISAM; 1148,1150c1153,1155 < -- < -- Dumping data for table `special` < -- --- > # > # Dumping data for table 'special' > # 1163,1165c1168,1170 < -- < -- Table structure for table `statuscodes` < -- --- > # > # Table structure for table 'statuscodes' > # 1171c1176 < ); --- > ) TYPE=MyISAM; 1173,1175c1178,1180 < -- < -- Dumping data for table `statuscodes` < -- --- > # > # Dumping data for table 'statuscodes' > # 1181,1183c1186,1188 < -- < -- Table structure for table `stories` < -- --- > # > # Table structure for table 'stories' > # 1209c1214 < ); --- > ) TYPE=MyISAM; 1211,1213c1216,1218 < -- < -- Dumping data for table `stories` < -- --- > # > # Dumping data for table 'stories' > # 1217,1219c1222,1224 < -- < -- Table structure for table `storymoderate` < -- --- > # > # Table structure for table 'storymoderate' > # 1228c1233 < ); --- > ) TYPE=MyISAM; 1230,1232c1235,1237 < -- < -- Dumping data for table `storymoderate` < -- --- > # > # Dumping data for table 'storymoderate' > # 1235,1237c1240,1242 < -- < -- Table structure for table `subscription_info` < -- --- > # > # Table structure for table 'subscription_info' > # 1248c1253 < ); --- > ) TYPE=MyISAM; 1250,1252c1255,1257 < -- < -- Dumping data for table `subscription_info` < -- --- > # > # Dumping data for table 'subscription_info' > # 1255,1257c1260,1262 < -- < -- Table structure for table `subscription_payments` < -- --- > # > # Table structure for table 'subscription_payments' > # 1269c1274 < ); --- > ) TYPE=MyISAM; 1271,1273c1276,1278 < -- < -- Dumping data for table `subscription_payments` < -- --- > # > # Dumping data for table 'subscription_payments' > # 1276,1278c1281,1283 < -- < -- Table structure for table `subscription_types` < -- --- > # > # Table structure for table 'subscription_types' > # 1287c1292 < ); --- > ) TYPE=MyISAM; 1289,1291c1294,1296 < -- < -- Dumping data for table `subscription_types` < -- --- > # > # Dumping data for table 'subscription_types' > # 1294,1296c1299,1301 < -- < -- Table structure for table `subsections` < -- --- > # > # Table structure for table 'subsections' > # 1305c1310 < ); --- > ) TYPE=MyISAM; 1307,1309c1312,1314 < -- < -- Dumping data for table `subsections` < -- --- > # > # Dumping data for table 'subsections' > # 1312,1314c1317,1319 < -- < -- Table structure for table `topics` < -- --- > # > # Table structure for table 'topics' > # 1323c1328 < ); --- > ) TYPE=MyISAM; 1325,1327c1330,1332 < -- < -- Dumping data for table `topics` < -- --- > # > # Dumping data for table 'topics' > # 1333,1335c1338,1340 < -- < -- Table structure for table `userprefs` < -- --- > # > # Table structure for table 'userprefs' > # 1342c1347 < ); --- > ) TYPE=MyISAM; 1344,1346c1349,1351 < -- < -- Dumping data for table `userprefs` < -- --- > # > # Dumping data for table 'userprefs' > # 1349,1351c1354,1356 < -- < -- Table structure for table `users` < -- --- > # > # Table structure for table 'users' > # 1384c1389 < ); --- > ) TYPE=MyISAM; 1386,1388c1391,1393 < -- < -- Dumping data for table `users` < -- --- > # > # Dumping data for table 'users' > # 1392,1394c1397,1399 < -- < -- Table structure for table `vars` < -- --- > # > # Table structure for table 'vars' > # 1403c1408 < ); --- > ) TYPE=MyISAM; 1405,1407c1410,1412 < -- < -- Dumping data for table `vars` < -- --- > # > # Dumping data for table 'vars' > # 1610,1612c1615,1617 < -- < -- Table structure for table `viewed_stories` < -- --- > # > # Table structure for table 'viewed_stories' > # 1622c1627 < ); --- > ) TYPE=MyISAM; 1624,1626c1629,1631 < -- < -- Dumping data for table `viewed_stories` < -- --- > # > # Dumping data for table 'viewed_stories' > # 1630,1632c1635,1637 < -- < -- Table structure for table `whos_online` < -- --- > # > # Table structure for table 'whos_online' > # 1639c1644 < ); --- > ) TYPE=MyISAM; 1641,1643c1646,1648 < -- < -- Dumping data for table `whos_online` < -- --- > # > # Dumping data for table 'whos_online' > #