DB Setup

<?php
//connect to the database
include("inc/db_connect.php");

//create table of links
$sql = "CREATE TABLE links (
    linkID int NOT NULL AUTO_INCREMENT,
    PRIMARY KEY(linkID),
    type int,
    timeCreated int,
    originalLinkID int,
    clumpLineageID
)";
mysql_query($sql);

//create table for normal link detailing
$sql = "CREATE TABLE normLinks (
    linkID int,
    PRIMARY KEY(linkID),
    url MEDIUMTEXT,
)";
mysql_query($sql);

//create table for pass link detailing
$sql = "CREATE TABLE passLinks (
    linkID int,
    PRIMARY KEY(linkID),
    url MEDIUMTEXT,
    hashword varchar(32),
    hint TINYTEXT,
)";
mysql_query($sql);

//create table for time link detailing
$sql = "CREATE TABLE timeLinks (
    linkID int,
    PRIMARY KEY(linkID),
    url MEDIUMTEXT,
    time int
)";
mysql_query($sql);

//create table for dice link detailing
$sql = "CREATE TABLE diceLinks (
    linkID int,
    PRIMARY KEY(linkID),
    url MEDIUMTEXT,
    weight int
)";
mysql_query($sql);

//create table for banned IP's
$sql = "CREATE TABLE banned (
    IP varchar(19),
    reason TINYTEXT
)";
mysql_query($sql);

//create table for user accounts
$sql = "CREATE TABLE users (
    ID int NOT NULL AUTO_INCREMENT,
    PRIMARY KEY(ID),
    username TINYTEXT,
    email TINYTEXT,
    hashword varchar(32),
    clumpLineageID
)";
mysql_query($sql);

//create table for owned links
$sql = "CREATE TABLE ownedLinks (
    ownerID int,
    linkID int,
)";
mysql_query($sql);

//create table for bundles
$sql = "CREATE TABLE bundles (
    ID int NOT NULL AUTO_INCREMENT,
    PRIMARY KEY(ID),
    ownerID int,
    descriptive MEDIUMTEXT,
    clumpLineageID
)";
mysql_query($sql);

//create table for bundleAssociations
$sql = "CREATE TABLE bundleAssociations (
    bundleID,
    linkID,
)";
mysql_query($sql);

//create table for visitClumps
$sql = "CREATE TABLE visitClumps (
    ID int NOT NULL AUTO_INCREMENT,
    PRIMARY KEY(ID),
    scope TINYINT,
    score int,
    delta int,
    deltaScale int,
    time int
)";
mysql_query($sql);

//create table for visitGeoClumps
$sql = "CREATE TABLE visitGeoClumps (
    owningClumpID,
    scope TINYINT,
    score int,
    delta int,
    deltaScale int,
    time int
)";
mysql_query($sql);

mysql_close();
?>