diff options
| author | the_systech <the_systech@users.sourceforge.net> | 2001-05-15 14:08:27 +0000 |
|---|---|---|
| committer | the_systech <the_systech@users.sourceforge.net> | 2001-05-15 14:08:27 +0000 |
| commit | 6dfe84827d7a2a62bc688741e0a961b652c4b536 (patch) | |
| tree | de5b7f62f3e7896c4b6ac62e1f951da4f1381d7a /phpBB/db/mysql_basic.sql | |
| parent | 078f63bc8a9fd6f7cf0795296aed4715ad75e05b (diff) | |
| download | forums-6dfe84827d7a2a62bc688741e0a961b652c4b536.tar forums-6dfe84827d7a2a62bc688741e0a961b652c4b536.tar.gz forums-6dfe84827d7a2a62bc688741e0a961b652c4b536.tar.bz2 forums-6dfe84827d7a2a62bc688741e0a961b652c4b536.tar.xz forums-6dfe84827d7a2a62bc688741e0a961b652c4b536.zip | |
Add post in demo forum
git-svn-id: file:///svn/phpbb/trunk@300 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db/mysql_basic.sql')
| -rw-r--r-- | phpBB/db/mysql_basic.sql | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/phpBB/db/mysql_basic.sql b/phpBB/db/mysql_basic.sql index 719642c88c..eb658eb259 100644 --- a/phpBB/db/mysql_basic.sql +++ b/phpBB/db/mysql_basic.sql @@ -10,7 +10,7 @@ INSERT INTO phpbb_config VALUES (1,1,'Test forum',1,1,1,1,1,0,10,50,25,'With reg INSERT INTO phpbb_categories VALUES (1,'Test category 1','1'); # -- Forums -INSERT INTO phpbb_forums VALUES (1,1,'Test Forum 1','This is just a test forum, nothing special here.',1,1,1,0,0,0); +INSERT INTO phpbb_forums VALUES (1,1,'Test Forum 1','This is just a test forum, nothing special here.',1,1,1,1,1,1); # -- Forum Mods INSERT INTO phpbb_forum_mods VALUES (1,1,0); @@ -19,6 +19,12 @@ INSERT INTO phpbb_forum_mods VALUES (1,1,0); INSERT INTO phpbb_users VALUES (1,1,'admin',NOW(),'','','','','-8','d M Y H:i','0','','4','admin@yourdomain.com','','','','','','This is just a stupid sig',1,1,'','','',0,1,0,0,0,'','',0); INSERT INTO phpbb_users VALUES (-1,1,'Anonymous',NOW(),'','','Default','','-8','d M Y H:i',0,'',1,'','','','','','','',0,1,'','','',0,0,0,0,0,'','',0); +# -- Demo Topic +INSERT INTO phpbb_topics VALUES(1,1,'Demo Topic', 1,NOW(), 0,0,0,0,1); +# -- Demo Post +INSERT INTO phpbb_posts VALUES(1,1,1,1,NOW(),'234234232', LEFT(MD5('42'),10)); +INSERT INTO phpbb_posts_text VALUES(1,'This is a demo post in the demo topic'); + # -- Themes INSERT INTO phpbb_themes (themes_id, themes_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, th_color1, th_color2, th_color3, td_color1, td_color2, td_color3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, img1, img2, img3, img4) VALUES ( '1', 'Default-Default', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'CCCCCC', 'DDDDDD', '', '', '', '', '0', '0', '0', '', '', '', '', '', '', ''); INSERT INTO phpbb_themes_name (themes_id, tr_color1_name, tr_color2_name, tr_color3_name, th_color1_name, th_color2_name, th_color3_name, td_color1_name, td_color2_name, td_color3_name, fontface1_name, fontface2_name, fontface3_name, fontsize1_name, fontsize2_name, fontsize3_name, fontcolor1_name, fontcolor2_name, fontcolor3_name, img1_name, img2_name, img3_name, img4_name) VALUES ( '1', '', '', '', '', '', '', '', 'Row Color 1', 'Row Color 2', '', '', '', '', '', '', '', '', '', '', '', '', ''); |