#Sql120640_2 CREATE TABLE forum_postext ( post_id int(10) NOT NULL default '0', post_text text, PRIMARY KEY (post_id) ) TYPE=MyISAM; CREATE TABLE forum_smile ( id int(10) default NULL auto_increment, code varchar(50) default NULL, smile_url varchar(100) default NULL, emotion varchar(75) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; INSERT INTO forum_smile VALUES (1, ':D', 'icon_biggrin.gif', 'Very Happy'); INSERT INTO forum_smile VALUES (2, ':-D', 'icon_biggrin.gif', 'Very Happy'); INSERT INTO forum_smile VALUES (3, ':grin:', 'icon_biggrin.gif', 'Very Happy'); INSERT INTO forum_smile VALUES (4, ':)', 'icon_smile.gif', 'Smile'); INSERT INTO forum_smile VALUES (5, ':-)', 'icon_smile.gif', 'Smile'); INSERT INTO forum_smile VALUES (6, ':smile:', 'icon_smile.gif', 'Smile'); INSERT INTO forum_smile VALUES (7, ':(', 'icon_frown.gif', 'Sad'); INSERT INTO forum_smile VALUES (8, ':-(', 'icon_frown.gif', 'Sad'); INSERT INTO forum_smile VALUES (9, ':sad:', 'icon_frown.gif', 'Sad'); INSERT INTO forum_smile VALUES (10, ':o', 'icon_eek.gif', 'Surprised'); INSERT INTO forum_smile VALUES (11, ':-o', 'icon_eek.gif', 'Surprised'); INSERT INTO forum_smile VALUES (12, ':eek:', 'icon_eek.gif', 'Suprised'); INSERT INTO forum_smile VALUES (13, ':-?', 'icon_confused.gif', 'Confused'); INSERT INTO forum_smile VALUES (14, ':???:', 'icon_confused.gif', 'Confused'); INSERT INTO forum_smile VALUES (15, '8)', 'icon_cool.gif', 'Cool'); INSERT INTO forum_smile VALUES (16, '8-)', 'icon_cool.gif', 'Cool'); INSERT INTO forum_smile VALUES (17, ':cool:', 'icon_cool.gif', 'Cool'); INSERT INTO forum_smile VALUES (18, ':lol:', 'icon_lol.gif', 'Laughing'); INSERT INTO forum_smile VALUES (19, ':x', 'icon_mad.gif', 'Mad'); INSERT INTO forum_smile VALUES (20, ':-x', 'icon_mad.gif', 'Mad'); INSERT INTO forum_smile VALUES (21, ':mad:', 'icon_mad.gif', 'Mad'); INSERT INTO forum_smile VALUES (22, ':P', 'icon_razz.gif', 'Razz'); INSERT INTO forum_smile VALUES (23, ':-P', 'icon_razz.gif', 'Razz'); INSERT INTO forum_smile VALUES (24, ':razz:', 'icon_razz.gif', 'Razz'); INSERT INTO forum_smile VALUES (25, ':oops:', 'icon_redface.gif', 'Embaressed'); INSERT INTO forum_smile VALUES (26, ':cry:', 'icon_cry.gif', 'Crying (very sad)'); INSERT INTO forum_smile VALUES (27, ':evil:', 'icon_evil.gif', 'Evil or Very Mad'); INSERT INTO forum_smile VALUES (28, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes'); INSERT INTO forum_smile VALUES (29, ':wink:', 'icon_wink.gif', 'Wink'); INSERT INTO forum_smile VALUES (30, ';)', 'icon_wink.gif', 'Wink'); INSERT INTO forum_smile VALUES (31, ';-)', 'icon_wink.gif', 'Wink'); CREATE TABLE forum_topic ( topic_id int(10) default NULL auto_increment, topic_title varchar(100) default NULL, topic_poster varchar(50) NOT NULL default '', topic_time varchar(20) default NULL, topic_views int(10) NOT NULL default '0', topic_replies int(10) NOT NULL default '0', topic_last_post_id int(10) NOT NULL default '0', PRIMARY KEY (topic_id), KEY topic_id(topic_id), KEY topic_last_post_id(topic_last_post_id) ) TYPE=MyISAM;