- Updated database.mysql

1 files changed, 28 insertions, 5 deletions

diff --git a/database/database.mysql b/database/database.mysql
index e458cc987..404eb587f 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -31,15 +31,15 @@ CREATE TABLE book (
 );
 
 CREATE TABLE boxes (
-  id tinyint(4) DEFAULT '0' NOT NULL auto_increment,
-  subject varchar(64) DEFAULT '' NOT NULL,
-  content text,
+  bid tinyint(4) DEFAULT '0' NOT NULL auto_increment,
+  title varchar(64) DEFAULT '' NOT NULL,
+  body text,
   info varchar(128) DEFAULT '' NOT NULL,
   link varchar(128) DEFAULT '' NOT NULL,
   type tinyint(2) DEFAULT '0' NOT NULL,
-  UNIQUE subject (subject),
+  UNIQUE subject (title),
   UNIQUE info (info),
-  PRIMARY KEY (id)
+  PRIMARY KEY (bid)
 );
 
 CREATE TABLE bundle (
@@ -50,6 +50,13 @@ CREATE TABLE bundle (
   PRIMARY KEY (bid)
 );
 
+CREATE TABLE cache (
+  url varchar(255) DEFAULT '' NOT NULL,
+  data text NOT NULL,
+  timestamp int(11) DEFAULT '0' NOT NULL,
+  PRIMARY KEY (url)
+);
+
 CREATE TABLE category (
   cid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
   name varchar(32) DEFAULT '' NOT NULL,
@@ -262,6 +269,11 @@ CREATE TABLE rating (
   PRIMARY KEY (user)
 );
 
+CREATE TABLE referer (
+  url varchar(255) DEFAULT '' NOT NULL,
+  timestamp int(11) DEFAULT '0' NOT NULL
+);
+
 CREATE TABLE role (
   rid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
   name varchar(32) DEFAULT '' NOT NULL,
@@ -270,6 +282,17 @@ CREATE TABLE role (
   PRIMARY KEY (rid)
 );
 
+CREATE TABLE site (
+  sid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
+  title varchar(128) DEFAULT '' NOT NULL,
+  url varchar(255) DEFAULT '' NOT NULL,
+  size text NOT NULL,
+  timestamp int(11) DEFAULT '0' NOT NULL,
+  UNIQUE title (title),
+  UNIQUE url (url),
+  PRIMARY KEY (sid)
+);
+
 CREATE TABLE story (
   lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
   nid int(10) unsigned DEFAULT '0' NOT NULL,