summaryrefslogtreecommitdiff
path: root/database/database.mysql
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2001-07-11 22:06:24 +0000
committerDries Buytaert <dries@buytaert.net>2001-07-11 22:06:24 +0000
commitd6d60de3ccac7b26ed3a14498279c8f16cdcefe7 (patch)
treed50339aa8c59aa34edb34c257fd854223024390c /database/database.mysql
parentee12d11165f867e8442d5e12e6325f0c4f2e6d0d (diff)
downloadbrdo-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.mysql27
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)
);