1 files changed, 25 insertions, 2 deletions
diff --git a/database/database.mysql b/database/database.mysql
index 404eb587f..ba13a912d 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -18,6 +18,13 @@ CREATE TABLE blocks (
   PRIMARY KEY (name)
 );
 
+CREATE TABLE blog (
+  lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
+  nid int(10) unsigned DEFAULT '0' NOT NULL,
+  body text NOT NULL,
+  PRIMARY KEY (lid)
+);
+
 CREATE TABLE book (
   lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
   nid int(10) unsigned DEFAULT '0' NOT NULL,
@@ -84,6 +91,20 @@ CREATE TABLE channel (
   PRIMARY KEY (id)
 );
 
+CREATE TABLE chatevents (
+  id int(11) DEFAULT '0' NOT NULL auto_increment,
+  body varchar(255) DEFAULT '' NOT NULL,
+  timestamp int(11) DEFAULT '0' NOT NULL,
+  PRIMARY KEY (id)
+);
+
+CREATE TABLE chatmembers (
+  id int(11) DEFAULT '0' NOT NULL auto_increment,
+  nick varchar(32) DEFAULT '' NOT NULL,
+  timestamp int(11) DEFAULT '0' NOT NULL,
+  PRIMARY KEY (id)
+);
+
 CREATE TABLE collection (
   cid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
   name varchar(32) DEFAULT '' NOT NULL,
@@ -144,13 +165,15 @@ CREATE TABLE entry (
 CREATE TABLE feed (
   fid int(11) DEFAULT '0' NOT NULL auto_increment,
   title varchar(255) DEFAULT '' NOT NULL,
-  link varchar(255) DEFAULT '' NOT NULL,
+  url varchar(255) DEFAULT '' NOT NULL,
   refresh int(11),
   uncache int(11),
   timestamp int(11),
   attributes varchar(255) DEFAULT '' NOT NULL,
+  link varchar(255) DEFAULT '' NOT NULL,
+  description text NOT NULL,
   UNIQUE title (title),
-  UNIQUE link (link),
+  UNIQUE link (url),
   PRIMARY KEY (fid)
 );