# phpMyAdmin MySQL-Dump

DROP TABLE IF EXISTS phpbb_links_cat;
DROP TABLE IF EXISTS phpbb_links_url;
DROP TABLE IF EXISTS phpbb_urlincat;
#
# Tabellenstruktur für Tabelle `links_cat`
#

CREATE TABLE phpbb_links_cat (
  id bigint(20) NOT NULL auto_increment,
  name text NOT NULL,
  hidden tinyint(2) NOT NULL default '1',
  owner mediumint(10) NOT NULL default '0',
  UNIQUE KEY id (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `links_url`
#

CREATE TABLE phpbb_links_url (
  id bigint(20) NOT NULL auto_increment,
  url text NOT NULL,
  name text NOT NULL,
  description text NOT NULL,
  added int(11) default NULL,
  owner mediumint(8) NOT NULL default '0',
  clickcounter int(12) NOT NULL default '0',
  lastclickid mediumint(8) NOT NULL default '0',
  lastclicktime int(11) NOT NULL default '0',
  bbcode_uid varchar(10) NOT NULL default '',
  enable_bbcode tinyint(1) NOT NULL default '1',
  UNIQUE KEY id (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `links_urlincat`
#

CREATE TABLE phpbb_links_urlincat (
  id bigint(20) NOT NULL auto_increment,
  url_id bigint(20) NOT NULL default '0',
  cat_id bigint(20) NOT NULL default '0',
  pos mediumint(10) NOT NULL default '9999',
  UNIQUE KEY id (id)
) TYPE=MyISAM;

INSERT INTO phpbb_links_cat VALUES (1,'Default','','');
INSERT INTO phpbb_links_url VALUES (1,'www.handykoelsch.de','Handykoelsch','Kölns größtes Mobiltrunkforum. Definitely worth a visit ;)',1021659072,0,0,0,0,0,0);
INSERT INTO phpbb_links_urlincat VALUES (1,1,1,9999);