From d6d60de3ccac7b26ed3a14498279c8f16cdcefe7 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Wed, 11 Jul 2001 22:06:24 +0000 Subject: - Added blog.module to replace diary.module (contrubeted by Julian): + feedback wanted - Added updated import.module (contributed by Julian): + user page do browse the headlines by feed and bundle, to display the item descriptions, etc. - Fixed small bug in common.inc. - Updated database.mysql --- database/database.mysql | 27 +++++++++++++++++++++++++-- 1 file changed, 25 insertions(+), 2 deletions(-) (limited to 'database/database.mysql') 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) ); -- cgit v1.2.3