install.sql

-- add links in user table
ALTER TABLE wcf1_user ADD linklistLinks INT(10) NOT NULL DEFAULT 0;
ALTER TABLE wcf1_user ADD INDEX linklistLinks (linklistLinks);

--links
DROP TABLE IF EXISTS linklist1_link;
CREATE TABLE linklist1_link (
linkID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
categoryID INT(10),
userID	INT(10),
username	VARCHAR(255),
subject	VARCHAR(255) NOT NULL,
message	TEXT,
url	VARCHAR(255),
image	VARCHAR(255) DEFAULT NULL,
time INT(10) NOT NULL,
languageID INT(10),
attachments INT(10) NOT NULL DEFAULT 0,
isActive	TINYINT(1) NOT NULL DEFAULT 0,
isDeleted	TINYINT(1) NOT NULL DEFAULT 0,
isOnline	TINYINT(1) NOT NULL DEFAULT 1,
visits	INT(20)	NOT NULL DEFAULT 0,
deleteTime INT(10) NULL,
lastChangeTime	INT(10),
enableSmilies TINYINT(1) NOT NULL DEFAULT 1,
enableHtml TINYINT(1) NOT NULL DEFAULT 0,
enableBBCodes	TINYINT(1) NOT NULL DEFAULT 1,
ipAddress VARCHAR(39) NOT NULL DEFAULT '',
cumulativeLikes MEDIUMINT(7) NOT NULL DEFAULT 0,
hasLabels INT(10) NOT NULL DEFAULT 0;
);

--stats
DROP TABLE IF EXISTS linklist1_category_stats;
CREATE TABLE linklist1_category_stats(
categoryID INT(10),
links INT(10) DEFAULT 0,
visits INT(10) DEFAULT 0
);

--foreigns
ALTER TABLE linklist1_category_stats ADD FOREIGN KEY (categoryID) REFERENCES wcf1_category (categoryID) ON DELETE CASCADE;
ALTER TABLE linklist1_link ADD FOREIGN KEY (categoryID) REFERENCES wcf1_category (categoryID) ON DELETE CASCADE;
ALTER TABLE linklist1_link ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
ALTER TABLE linklist1_link ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE SET NULL;