Konstigt.
Kod: Markera allt
CREATE TABLE phpbb_link_categories (
cat_id int(10) NOT NULL auto_increment,
cat_name text,
cat_parent int(50) default NULL,
parents_data text NOT NULL,
cat_order int(50) default NULL,
cat_links mediumint(8) NOT NULL default '-1',
PRIMARY KEY (cat_id),
KEY cat_order (cat_order));
CREATE TABLE phpbb_links (
link_id mediumint(8) unsigned NOT NULL auto_increment,
link_name text,
link_longdesc text,
link_catid mediumint(8) unsigned NOT NULL default '0',
link_url varchar(100) NOT NULL default '',
link_logo_src varchar(120) default NULL,
link_time int(25) default '0',
link_pin int(2) default '0',
link_approved tinyint(1) NOT NULL default '0',
link_hits int(10) unsigned NOT NULL default '0',
user_id mediumint(8) NOT NULL default '0',
poster_ip varchar(8) NOT NULL default '',
last_user_ip varchar(8) NOT NULL default '',
post_username varchar(25) default NULL,
PRIMARY KEY (link_id));
INSERT INTO phpbb_link_categories VALUES (1,'PHP',0,'',1,1);
INSERT INTO phpbb_link_categories VALUES (2,'Bulletin Board',1,'',2,-1);
INSERT INTO phpbb_links VALUES (1, 'phpBB Official Website', 'Official phpBB Website', 2, 'http://www.phpbb.com/', 'linkdb/images/phpBB_88a.gif', '', 1, 1, 0, 2, '', '', '');
CREATE TABLE phpbb_link_config (
config_name varchar(255) NOT NULL default '',
config_value varchar(255) NOT NULL default ''
);
INSERT INTO phpbb_link_config VALUES ('site_logo', 'http://www.riktigtkaffe.se/linkdb/images/web_logo88a.gif');
INSERT INTO phpbb_link_config VALUES ('site_url', 'http://www.riktigtkaffe.se');
INSERT INTO phpbb_link_config VALUES ('width', '88');
INSERT INTO phpbb_link_config VALUES ('height', '31');
INSERT INTO phpbb_link_config VALUES ('settings_link_page', '10');
INSERT INTO phpbb_link_config VALUES ('display_interval', '6000');
INSERT INTO phpbb_link_config VALUES ('display_logo_num', '10');
INSERT INTO phpbb_link_config VALUES ('display_links_logo', '1');
INSERT INTO phpbb_link_config VALUES ('email_notify', '0');
INSERT INTO phpbb_link_config VALUES ('pm_notify ', '1');
INSERT INTO phpbb_link_config VALUES ('lock_submit_site', '0');
INSERT INTO phpbb_link_config VALUES ('allow_no_logo', '0');
INSERT INTO phpbb_link_config VALUES ('cat_col', '2');
INSERT INTO phpbb_link_config VALUES ('sort_method', 'link_time');
INSERT INTO phpbb_link_config VALUES ('sort_order', 'DESC');
INSERT INTO phpbb_link_config VALUES ('allow_guest_submit_site', '0');
INSERT INTO phpbb_link_config VALUES ('split_links', '1');
INSERT INTO phpbb_link_config VALUES ('allow_vote', '1');
INSERT INTO phpbb_link_config VALUES ('linkdb_versions', '0.0.9');
INSERT INTO phpbb_link_config VALUES ('allow_edit_link', '1');
INSERT INTO phpbb_link_config VALUES ('allow_delete_link', '0');
INSERT INTO phpbb_link_config VALUES ('allow_comment', '1');
INSERT INTO phpbb_link_config VALUES ('max_comment_chars', '5000');
INSERT INTO phpbb_link_config VALUES ('need_validation', '1');
INSERT INTO phpbb_link_config VALUES ('url_validation', '1');
INSERT INTO phpbb_link_config VALUES ('url_validation_setting', 's?:H?:S?:E-:F-:u?:P?:a+:I?:p?:f?:q?:r?');
CREATE TABLE phpbb_link_votes (
user_id mediumint(8) NOT NULL default '0',
votes_ip varchar(50) NOT NULL default '0',
votes_link int(10) NOT NULL default '0',
rate_point tinyint(3) unsigned NOT NULL default '0',
KEY user_id (user_id));
CREATE TABLE phpbb_link_comments (
comments_id int(10) NOT NULL auto_increment,
link_id int(10) NOT NULL default '0',
comments_text text NOT NULL,
comments_title text NOT NULL,
comments_time int(50) NOT NULL default '0',
comment_bbcode_uid varchar(10) default NULL,
poster_id mediumint(8) NOT NULL default '0',
PRIMARY KEY (comments_id),
KEY comments_id (comments_id),
FULLTEXT KEY comment_bbcode_uid (comment_bbcode_uid));
CREATE TABLE phpbb_link_custom (
custom_id int(50) NOT NULL auto_increment,
custom_name text NOT NULL,
custom_description text NOT NULL,
data text NOT NULL,
field_order int(20) NOT NULL default '0',
field_type tinyint(2) NOT NULL default '0',
regex varchar(255) NOT NULL default '',
PRIMARY KEY (custom_id));
CREATE TABLE phpbb_link_customdata (
customdata_file int(50) NOT NULL default '0',
customdata_custom int(50) NOT NULL default '0',
data text NOT NULL);