diff options
| author | Dries Buytaert <dries@buytaert.net> | 2001-01-03 21:23:58 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2001-01-03 21:23:58 +0000 |
| commit | 4572760eb3bd2a9454660bf187d17c7258e04bfd (patch) | |
| tree | 6c73bb27ddb2c8afb5cf4dfd5ab8038ab75356da /database/database.mysql | |
| parent | c85a0ee005d67a3104954ad7b637b7d22f9109b4 (diff) | |
| download | brdo-4572760eb3bd2a9454660bf187d17c7258e04bfd.tar.gz brdo-4572760eb3bd2a9454660bf187d17c7258e04bfd.tar.bz2 | |
A batch of preparations for release candidate 2:
- expanded documentation
(written by Jeroen)
- fixed bug in includes/module.inc
- fixed bug in modules/backend.class
- renamed some of the SQL tables (!)
- started making the diary.module truly modular (not finished yet)
- renamed "admin_blocks" to "boxes"
- added new functionality to "boxes": apart from PHP boxes, you
can now create ASCII boxes as well as HTML boxes for those who
are not confident with PHP.
(requested by stalor)
- added drupal-site module to keep track of known drupal sites
- added small Perl script to generate encrypted CVS passwords
Diffstat (limited to 'database/database.mysql')
| -rw-r--r-- | database/database.mysql | 29 |
1 files changed, 21 insertions, 8 deletions
diff --git a/database/database.mysql b/database/database.mysql index cecc968f7..14e8325ba 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -1,11 +1,3 @@ -CREATE TABLE admin_blocks ( - id tinyint(4) DEFAULT '0' NOT NULL auto_increment, - subject varchar(64) DEFAULT '' NOT NULL, - content text, - info varchar(128) DEFAULT '' NOT NULL, - link varchar(128) DEFAULT '' NOT NULL, - PRIMARY KEY (id) -); CREATE TABLE affiliates ( id int(11) DEFAULT '0' NOT NULL auto_increment, @@ -16,6 +8,18 @@ CREATE TABLE affiliates ( PRIMARY KEY (id) ); +CREATE TABLE boxes ( + id tinyint(4) DEFAULT '0' NOT NULL auto_increment, + subject varchar(64) DEFAULT '' NOT NULL, + content text, + info varchar(128) DEFAULT '' NOT NULL, + link varchar(128) DEFAULT '' NOT NULL, + type tinyint(2) DEFAULT '0' NOT NULL, + UNIQUE subject (subject), + UNIQUE info (info), + PRIMARY KEY (id) +); + CREATE TABLE bans ( id tinyint(4) DEFAULT '0' NOT NULL auto_increment, mask varchar(255) DEFAULT '' NOT NULL, @@ -76,6 +80,15 @@ CREATE TABLE diaries ( PRIMARY KEY (id) ); +CREATE TABLE drupals ( + id int(11) DEFAULT '0' NOT NULL auto_increment, + link varchar(255) DEFAULT '' NOT NULL, + name varchar(255) DEFAULT '' NOT NULL, + contact varchar(255) DEFAULT '' NOT NULL, + UNIQUE link (link), + PRIMARY KEY (id) +); + CREATE TABLE headlines ( id int(11) DEFAULT '0' NOT NULL, title varchar(255) DEFAULT '' NOT NULL, |