#drop table urls;
#drop table documents;
#drop table servers;
#drop table urlLog;

#drop table links;
#drop table linkLog;

#drop table url2key;
#drop table keywords;
#--------------------

CREATE TABLE urls(
urlId INT AUTO_INCREMENT PRIMARY KEY,
url CHAR(255) NOT NULL,
host CHAR(64) NOT NULL,
size INT,
mimeType CHAR(32),
protocol CHAR(8),		
httpStatus CHAR(3),
lastUpdate DATETIME,                #
lastAccess DATETIME,						#
INDEX url (url(32)) );

CREATE TABLE documents(
urlId INT NOT NULL,
title VARCHAR(255),
author VARCHAR(255),
description VARCHAR(255),
keywords VARCHAR(255),
language CHAR(2),
body MEDIUMTEXT,
thumbnail BLOB,
rating TINYINT,
bookmark CHAR(1),
annotation TEXT, 
INDEX urlId (urlId));

CREATE TABLE servers(           
host CHAR(64) PRIMARY KEY,
title VARCHAR(255),
description VARCHAR(255),
delay INT,
httpStatus CHAR(3),
lastTest DATETIME,
INDEX host (host(16)) );       

CREATE TABLE urlLog(
urlId INT NOT NULL,
topUrlId INT,			
frameName CHAR(100),		
visit DATETIME NOT NULL,
stay INT,
userId CHAR(8),
groupId CHAR(8),
INDEX urlId (urlId));

CREATE TABLE links(
linkId INT AUTO_INCREMENT PRIMARY KEY,
fromUrlId INT NOT NULL,
toUrlId INT NOT NULL,
reference CHAR(30) NOT NULL,        #
target CHAR(20) NOT NULL,           #
rev CHAR(20),							   #
rel CHAR(20),								#
title CHAR(100),
action CHAR(30),
INDEX fromUrlId (fromUrlId),   
INDEX toUrlId (toUrlId),       
INDEX reference (reference(15)) );

CREATE TABLE linkLog(
linkId INT NOT NULL, 
action DATETIME NOT NULL,
userId CHAR(8),
groupId CHAR(8),
INDEX linkId (linkId),
INDEX action (action));

CREATE TABLE keywords(     #
keywordId INT AUTO_INCREMENT PRIMARY KEY,
keyword CHAR(30) NOT NULL,
INDEX keyword (keyword));

CREATE TABLE url2key(      #
urlId INT NOT NULL,
keywordId INT NOT NULL,
INDEX urlIds (urlId),
INDEX keywordId (keywordId));

#create table transclusions {
# fromId int,
# toId int,
# target char(32),
# type char(16),
# rel char(16)};