|
From: Joe S. <joe...@us...> - 2004-10-19 21:41:30
|
Update of /cvsroot/phpslash/phpslash-dev/tables/0.8 In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv31546/phpslash-dev/tables/0.8 Added Files: psl_core.sql psl_example.sql Log Message: split slash-all.sql into psl_core and psl_example --- NEW FILE: psl_core.sql --- -- MySQL dump 9.07 -- -- Host: localhost Database: modules --------------------------------------------------------- -- Server version 4.0.12-log -- -- Table structure for table 'CACHEDATA' -- CREATE TABLE CACHEDATA ( CACHEKEY varchar(255) NOT NULL default '', CACHEEXPIRATION int(11) NOT NULL default '0', GZDATA blob, DATASIZE int(11) default NULL, DATACRC int(11) default NULL, PRIMARY KEY (CACHEKEY) ) TYPE=MyISAM; [...995 lines suppressed...] lut_id int(10) unsigned NOT NULL default '0', topic_id int(10) unsigned NOT NULL default '0', story_id int(10) unsigned NOT NULL default '0', PRIMARY KEY (lut_id) ) TYPE=MyISAM; -- -- Table structure for table 'psl_variable' -- CREATE TABLE psl_variable ( variable_id int(10) unsigned NOT NULL default '0', variable_name varchar(32) NOT NULL default '', value varchar(127) default NULL, description varchar(127) default NULL, variable_group varchar(20) default NULL, UNIQUE KEY variable_name (variable_name), KEY variable_id (variable_id) ) TYPE=MyISAM; --- NEW FILE: psl_example.sql --- -- MySQL dump 9.07 -- -- Host: localhost Database: modules --------------------------------------------------------- -- Server version 4.0.12-log -- -- Dumping data for table 'psl_block' -- INSERT INTO psl_block (id, type, title, expire_length, location, source_url, cache_data, block_options, ordernum, date_issued) VALUES (131,5,'PHPSlash Poll',1200,'','','','a:2:{s:5:\"width\";s:3:\"160\";s:6:\"column\";s:5:\"right\";}',20,1052418103); INSERT INTO psl_block (id, type, title, expire_length, location, source_url, cache_data, block_options, ordernum, date_issued) VALUES (139,7,'Sections',3600,'','','','a:2:{s:6:\"column\";s:5:\"right\";s:5:\"width\";s:3:\"160\";}',90,1056484625); INSERT INTO psl_block (id, type, title, expire_length, location, source_url, cache_data, block_options, ordernum, date_issued) VALUES (130,4,'%%',3600,'','','','a:2:{s:6:\"column\";s:5:\"right\";s:5:\"width\";s:3:\"160\";}',89,1052418103); INSERT INTO psl_block (id, type, title, expire_length, location, source_url, cache_data, block_options, ordernum, date_issued) VALUES (140,8,'Interview Topics',3600,'','section=interviews','','a:3:{s:6:\"column\";s:5:\"right\";s:5:\"width\";s:3:\"160\";s:0:\"\";s:0:\"\";}',90,975030554); INSERT INTO psl_block (id, type, title, expire_length, location, source_url, cache_data, block_options, ordernum, date_issued) VALUES (141,8,'Feature Topics',3600,'','section=features','','a:3:{s:5:\"width\";s:3:\"160\";s:6:\"column\";s:5:\"right\";s:0:\"\";s:0:\"\";}',90,1051637874); INSERT INTO psl_block (id, type, title, expire_length, location, source_url, cache_data, block_options, ordernum, date_issued) VALUES (142,8,'Topics',3600,'','section=Home','','a:2:{s:6:\"column\";s:5:\"right\";s:5:\"width\";s:3:\"160\";}',90,1053009559); INSERT INTO psl_block (id, type, title, expire_length, location, source_url, cache_data, block_options, ordernum, date_issued) VALUES (143,6,'Got Foo?',3600,'','query=foo','','a:3:{s:6:\"column\";s:5:\"right\";s:5:\"width\";s:3:\"160\";s:0:\"\";s:0:\"\";}',50,990019226); INSERT INTO psl_block (id, type, title, expire_length, location, source_url, cache_data, block_options, ordernum, date_issued) VALUES (144,6,'Most Popular Stories',3600,'','order=hits','','a:2:{s:6:\"column\";s:5:\"right\";s:5:\"width\";s:3:\"160\";}',60,1053009560); INSERT INTO psl_block (id, type, title, expire_length, location, source_url, cache_data, block_options, ordernum, date_issued) VALUES (145,6,'Older Stories',3600,'','start=5&max=5','','a:2:{s:6:\"column\";s:5:\"right\";s:5:\"width\";s:3:\"160\";}',30,990019227); INSERT INTO psl_block (id, type, title, expire_length, location, source_url, cache_data, block_options, ordernum, date_issued) VALUES (148,18,'Administration',0,'','','<p>A bunch of cool things like latest site activity and stats should go here. </p>\r\n <p>But until they do, just pick something from the NavBar and go about your duties...</p>\r\n','a:4:{s:6:\"column\";s:6:\"center\";s:5:\"width\";s:0:\"\";s:5:\"perms\";s:4:\"user\";s:6:\"module\";s:5:\"Admin\";}',92,NULL); -- -- Dumping data for table 'psl_commentcount' -- INSERT INTO psl_commentcount (count_id, count) VALUES (19,''); INSERT INTO psl_commentcount (count_id, count) VALUES (11,''); INSERT INTO psl_commentcount (count_id, count) VALUES (18,''); # -------------------------------------------------------- -- -- Dumping data for table 'psl_glossary' -- INSERT INTO psl_glossary (id, term, def) VALUES (1,'PHPSlash','A port of the popular Slashdot code to PHP.'); -- -- Dumping data for table 'psl_poll_answer' -- INSERT INTO psl_poll_answer (question_id, answer_id, answer_text, votes) VALUES (18,'2','PHP Sucks.',0); INSERT INTO psl_poll_answer (question_id, answer_id, answer_text, votes) VALUES (18,'1','No.',0); INSERT INTO psl_poll_answer (question_id, answer_id, answer_text, votes) VALUES (18,'0','Yes.',1); -- -- Dumping data for table 'psl_poll_question' -- INSERT INTO psl_poll_question (question_id, question_text, question_total_votes, current, date_created) VALUES (18,'Do you like phpSlash?',1,1,975968140); -- -- Dumping data for table 'psl_poll_voter' -- INSERT INTO psl_poll_voter (question_id, voter_id, user_id, date_created) VALUES (18,'127.0.0.1',0,989449131); -- -- Dumping data for table 'psl_quote' -- INSERT INTO psl_quote (quote, author) VALUES ('I\'d rather be no one then someone with no one.','Stone Roses'); INSERT INTO psl_quote (quote, author) VALUES ('Oh Manchester, so much to answer for.','Smiths'); -- -- Dumping data for table 'psl_section_block_lut' -- INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (242,131,3); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (234,130,3); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (263,141,5); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (278,139,4); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (277,139,3); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (276,139,5); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (261,140,4); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (268,142,3); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (279,139,7); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (239,144,4); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (238,144,3); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (244,147,8); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (1,148,8); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (413,144,5); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (414,144,10); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (415,144,11); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (416,144,12); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (417,144,13); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (418,144,14); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (419,144,15); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (420,142,10); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (421,142,11); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (422,142,12); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (423,142,13); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (424,142,14); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (425,142,15); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (426,139,10); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (427,139,11); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (428,139,12); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (429,139,13); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (430,139,14); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (431,139,15); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (450,139,16); INSERT INTO psl_section_block_lut (lut_id, block_id, section_id) VALUES (451,131,16); -- -- Dumping data for table 'psl_section_lut' -- INSERT INTO psl_section_lut (lut_id, story_id, section_id) VALUES (243,19,3); # -------------------------------------------------------- -- -- Dumping data for table 'psl_section_submission_lut' -- INSERT INTO psl_section_submission_lut (lut_id, story_id, section_id) VALUES (13,11,3); -- -- Dumping data for table 'psl_story' -- INSERT INTO psl_story (story_id, user_id, order_no, title, dept, intro_text, body_text, hits, topic_cache, story_options, date_available) VALUES (19,1,'','Congratulations! It Works!','new-stuff-is-cool','Welcome to phpslash!\r<br>\n\r<br>\nNow, login to the Admin Section with the default username of \'god\' and password of \'password\' and delete this story!\r<br>\n\r<br>\nThen, add yourself as an author (remember to give yourself all Security permissions) and logout / login again. ','',1,'','',975968996); # -------------------------------------------------------- -- -- Dumping data for table 'psl_submission' -- INSERT INTO psl_submission (story_id, user_id, title, dept, intro_text, body_text, hits, email, name, topic_cache, date_created) VALUES (11,0,'Delete This',NULL,'Hey,\r<br>\n\r<br>\nThis is a test submission, when people send you stuff, it'll pop up here. You should delete this so you don't actually post it by mistake! ',NULL,NULL,'http://www.php-slash.org/','The phpSLash Team',NULL,975968376); -- -- Dumping data for table 'psl_topic' -- INSERT INTO psl_topic (topic_id, topic_name, image, alt_text, width, height, onlinkbar) VALUES (14,'News','topicnews.gif','News',34,44,2); INSERT INTO psl_topic (topic_id, topic_name, image, alt_text, width, height, onlinkbar) VALUES (12,'FreeBSD','topicfreebsd.gif','FreeBSD',64,72,0); INSERT INTO psl_topic (topic_id, topic_name, image, alt_text, width, height, onlinkbar) VALUES (17,'Humor','topichumor.gif','It\'s Funny, Laugh dammit!',58,39,4); INSERT INTO psl_topic (topic_id, topic_name, image, alt_text, width, height, onlinkbar) VALUES (16,'Hardware','topichardware.gif','Hardware',64,63,3); INSERT INTO psl_topic (topic_id, topic_name, image, alt_text, width, height, onlinkbar) VALUES (15,'Games','topicgames.jpg','Games',80,56,1); INSERT INTO psl_topic (topic_id, topic_name, image, alt_text, width, height, onlinkbar) VALUES (11,'Apple','topicapple.gif','Apple',60,64,0); INSERT INTO psl_topic (topic_id, topic_name, image, alt_text, width, height, onlinkbar) VALUES (10,'American Online','topicaol.jpg','America Online',60,48,0); INSERT INTO psl_topic (topic_id, topic_name, image, alt_text, width, height, onlinkbar) VALUES (18,'PHPSlash','topicphpslash.gif','The wonderful PHPSlash',100,40,0); INSERT INTO psl_topic (topic_id, topic_name, image, alt_text, width, height, onlinkbar) VALUES (9,'Amiga','topicamiga.gif','Amiga',64,64,5); -- -- Dumping data for table 'psl_topic_lut' -- INSERT INTO psl_topic_lut (lut_id, topic_id, story_id) VALUES (70,18,19); # -------------------------------------------------------- -- -- Dumping data for table 'psl_topic_submission_lut' -- INSERT INTO psl_topic_submission_lut (lut_id, topic_id, story_id) VALUES (21,18,11); -- -- Dumping data for table 'psl_variable' -- INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES (3,'poll_currentquestionid','18','The Current Question on the homepage pollbooth',''); INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES (57,'article_nextprevlinks','','Adds next/prev links when viewing an article, but also requires a FULL TABLE SCAN.',''); INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES (40,'site_name','PHPSlash','This is the name of the website',''); INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES (41,'site_title','PHPSlash: Another title','Title for the website',''); INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES (43,'site_slogan','News for nerds in templates that matter!','Web Site Slogan',''); INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES (49,'site_logosmall','','small logo',''); INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES (50,'site_owner','web...@ph...','email address of the siteowner',''); INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES (60,'article_updatehits','1','If you want to keep track of the number of hits on an article, set this to true. REQUIRES AN UPDATE FOR EACH ARTICLE VIEW',''); INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES (59,'block_optioncount','4','the number of options for the block.',''); INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES (58,'search_maxresults','20','The maximum number of search results in the search page.',''); INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES (55,'comment_defaultmode','nested','The default mode for displaying comments (flat, thread, nested, index)',''); INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES (61,'submission_autodelete','','Deletes the submission *instantly* after clicking on the',''); INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES (62,'site_homesection','Home','this section\r\n appears on the main index page.',''); INSERT INTO psl_variable (variable_id, variable_name, value, description, variable_group) VALUES (63,'mailinglist_subject','Slash list','The Subject for the mailing list newsletters',''); |
