CREATE TABLE ubbt_links_links
(
lid int(11) NOT NULL auto_increment,
cat_id int(11) default NULL,
approved tinyint(4) NOT NULL default '1',
title varchar(100) NOT NULL default '',
url varchar(100) NOT NULL default '',
description text NOT NULL,
date_added int(11) unsigned NOT NULL default '0',
name varchar(100) NOT NULL default '',
email varchar(100) NOT NULL default '',
hits int(11) NOT NULL default '0',
user_number int( 11 ) NOT NULL default '0',
member char(2) NOT NULL default '',
linkratingsummary double(6,4) NOT NULL default '0.0000',
totalvotes int(11) NOT NULL default '0',
PRIMARY KEY (lid)
)
CREATE TABLE ubbt_links_categories
(
cat_id int(11) NOT NULL auto_increment,
parent_id int(11) default NULL,
title varchar(50) NOT NULL default '',
cat_desc varchar(60) default NULL,
cat_order tinyint(10) NOT NULL default '0',
PRIMARY KEY (cat_id)
)
CREATE TABLE ubbt_links_favorites
(
num int(9) unsigned NOT NULL auto_increment,
lid int(9) unsigned NOT NULL default '0',
uid int(9) unsigned NOT NULL default '0',
PRIMARY KEY (num),
KEY FAV_indx1 (uid)
)