diff options
author | Dries Buytaert <dries@buytaert.net> | 2001-07-11 22:06:24 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2001-07-11 22:06:24 +0000 |
commit | d6d60de3ccac7b26ed3a14498279c8f16cdcefe7 (patch) | |
tree | d50339aa8c59aa34edb34c257fd854223024390c /database/database.mysql | |
parent | ee12d11165f867e8442d5e12e6325f0c4f2e6d0d (diff) | |
download | brdo-d6d60de3ccac7b26ed3a14498279c8f16cdcefe7.tar.gz brdo-d6d60de3ccac7b26ed3a14498279c8f16cdcefe7.tar.bz2 |
- 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
Diffstat (limited to 'database/database.mysql')
-rw-r--r-- | database/database.mysql | 27 |
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) ); |