diff options
| author | Dries Buytaert <dries@buytaert.net> | 2002-11-30 15:21:36 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2002-11-30 15:21:36 +0000 |
| commit | f42bfcac31d692943a31eab7f5fc9458430606f8 (patch) | |
| tree | 17bbde96de3abcb00fdaf6a6f0f014815067377f /database | |
| parent | 060810841b9e5ddde50a722076cb51219b5b84f9 (diff) | |
| download | brdo-f42bfcac31d692943a31eab7f5fc9458430606f8.tar.gz brdo-f42bfcac31d692943a31eab7f5fc9458430606f8.tar.bz2 | |
- Fixed small glitch in the database schemes; the block table has changed but
the queries that insert some default block values were not updated.
Diffstat (limited to 'database')
| -rw-r--r-- | database/database.mysql | 4 | ||||
| -rw-r--r-- | database/database.pgsql | 12 |
2 files changed, 5 insertions, 11 deletions
diff --git a/database/database.mysql b/database/database.mysql index bf205ca08..b487177ee 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -596,6 +596,6 @@ INSERT INTO system VALUES ('tracker.module','tracker','module','',1); REPLACE variable SET name='update_start', value='s:10:"2002-10-17;"'; REPLACE variable SET name='theme_default', value='s:6:"marvin";'; -REPLACE blocks SET name = 'User information', module = 'user', delta = '0', status = '1'; -REPLACE blocks SET name = 'Log in', module = 'user', delta = '1', status = '1'; +REPLACE blocks SET module = 'user', delta = '0', status = '1'; +REPLACE blocks SET module = 'user', delta = '1', status = '1'; diff --git a/database/database.pgsql b/database/database.pgsql index f9cf97682..d90ab27be 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -297,7 +297,7 @@ CREATE TABLE page ( nid integer NOT NULL default '0', link varchar(128) NOT NULL default '', format smallint NOT NULL default '0', - description varchar(128) NOT NULL default '', + description varchar(128) NOT NULL default '', PRIMARY KEY (nid) ); CREATE INDEX page_nid_idx ON page(nid); @@ -594,17 +594,11 @@ INSERT INTO system VALUES ('themes/marvin/marvin.theme','marvin','theme','Intern INSERT INTO system VALUES ('themes/unconed/unconed.theme','unconed','theme','Internet explorer, Netscape, Opera',1); INSERT INTO system VALUES ('tracker.module','tracker','module','',1); -DELETE FROM variable WHERE name='update_start'; INSERT INTO variable(name,value) VALUES('update_start', '2002-05-15'); - -DELETE FROM variable WHERE name='theme_default'; INSERT INTO variable(name,value) VALUES('theme_default','s:6:"marvin";'); -DELETE FROM blocks WHERE name='User information'; -INSERT INTO blocks(name,module,delta,status) VALUES('User information', 'user', '0', '1'); - -DELETE FROM blocks WHERE name='Log in'; -INSERT INTO blocks(name,module,delta,status) VALUES('Log in', 'user', '1', '1'); +INSERT INTO blocks(module,delta,status) VALUES('user', '0', '1'); +INSERT INTO blocks(module,delta,status) VALUES('user', '1', '1'); --- --- Functions |