#
# Table structure for table `phpbb_link_categories`
#
CREATE TABLE phpbb_link_categories (
cat_id mediumint(8) unsigned NOT NULL auto_increment,
cat_title varchar(100) NOT NULL default '',
cat_order mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (cat_id),
KEY cat_order (cat_order)
) TYPE=MyISAM;
#
# Dumping data for table `phpbb_link_categories`
#
INSERT INTO phpbb_link_categories VALUES (1, '藝術文化', 1);
INSERT INTO phpbb_link_categories VALUES (2, '商業金融', 2);
INSERT INTO phpbb_link_categories VALUES (3, '生活資訊', 3);
INSERT INTO phpbb_link_categories VALUES (4, '電腦通訊', 4);
INSERT INTO phpbb_link_categories VALUES (5, '視聽休閒', 5);
INSERT INTO phpbb_link_categories VALUES (6, '醫療保健', 6);
INSERT INTO phpbb_link_categories VALUES (7, '運動體育', 7);
INSERT INTO phpbb_link_categories VALUES (8, '教育學習', 8);
INSERT INTO phpbb_link_categories VALUES (9, '其他類型', 9);
#(Note. The back-end of category manage wasn't done yet, so you have to manually insert or edit the category)
#
# Table structure for table `phpbb_links`
#
CREATE TABLE phpbb_links (
link_id mediumint(8) unsigned NOT NULL auto_increment,
link_title varchar(100) NOT NULL default '',
link_desc varchar(255) default NULL,
link_category mediumint(8) unsigned NOT NULL default '0',
link_url varchar(100) NOT NULL default '',
link_logo_src varchar(120) default NULL,
link_joined int(11) NOT NULL default '0',
link_active tinyint(1) NOT NULL default '0',
link_hits int(10) unsigned NOT NULL default '0',
user_id mediumint(8) NOT NULL default '0',
user_ip varchar(8) NOT NULL default '',
last_user_ip varchar(8) NOT NULL default '',
PRIMARY KEY (link_id)
) TYPE=MyISAM;
#
# Dumping data for table `phpbb_links`
#
INSERT INTO phpbb_links VALUES (1, 'phpBB Official Website', 'Official phpBB Website', 4, '
http://www.phpbb.com/', 'images/links/phpBB_88a.gif', 1019910254, 1, 0, 2, '', '');
INSERT INTO phpbb_links VALUES (2, 'phpbb-tw.net', 'Unofficial phpBB Chinese Support Centre', 4, '
http://phpbb-tw.net', 'images/links/phpbb-tw_logo88a.gif', 1019910254, 1, 0, 2, '', '');
