diff options
| author | Dries Buytaert <dries@buytaert.net> | 2003-09-09 18:18:43 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2003-09-09 18:18:43 +0000 |
| commit | 8e657f64efb3c3e12365d1c33e6ab89e40d9bfd5 (patch) | |
| tree | af96a46601a88e0be7089151a7bdb95afd54c310 /database | |
| parent | accebe358c1cb4b07e6dba7f9f7776fe3b09d242 (diff) | |
| download | brdo-8e657f64efb3c3e12365d1c33e6ab89e40d9bfd5.tar.gz brdo-8e657f64efb3c3e12365d1c33e6ab89e40d9bfd5.tar.bz2 | |
- Gerhard's uid 0 patches. These patches bring various performance
improvements. Requires a database update.
Diffstat (limited to 'database')
| -rw-r--r-- | database/database.mssql | 4 | ||||
| -rw-r--r-- | database/database.mysql | 3 | ||||
| -rw-r--r-- | database/database.pgsql | 3 |
3 files changed, 7 insertions, 3 deletions
diff --git a/database/database.mssql b/database/database.mssql index 16cb59fdf..091d3a021 100644 --- a/database/database.mssql +++ b/database/database.mssql @@ -332,7 +332,7 @@ CREATE TABLE [dbo].[term_synonym] ( GO CREATE TABLE [dbo].[users] ( - [uid] [bigint] IDENTITY (1, 1) NOT NULL , + [uid] [numeric](10, 0) NULL , [name] [varchar] (60) NOT NULL , [pass] [varchar] (32) NOT NULL , [mail] [varchar] (64) NULL , @@ -472,6 +472,8 @@ INSERT INTO system VALUES ('themes/marvin/marvin.theme','marvin','theme','Intern INSERT INTO variable(name,value) VALUES('update_start', 's:10:"2002-05-15";'); INSERT INTO variable(name,value) VALUES('theme_default','s:6:"marvin";'); +INSERT INTO users(uid,name,mail) VALUES(0,'Anonymous','root@localhost'); + INSERT INTO blocks(module,delta,status,custom,region,weight,path) VALUES('user', 0, 1, 0, 1, 0, ''); INSERT INTO blocks(module,delta,status,custom,region,weight,path) VALUES('user', 1, 1, 0, 1, 0, ''); diff --git a/database/database.mysql b/database/database.mysql index e9b5625a3..959f15c28 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -500,7 +500,7 @@ CREATE TABLE term_synonym ( -- CREATE TABLE users ( - uid int(10) unsigned NOT NULL auto_increment, + uid int(10) unsigned NOT NULL default '0', name varchar(60) NOT NULL default '', pass varchar(32) NOT NULL default '', mail varchar(64) default '', @@ -578,6 +578,7 @@ INSERT INTO system VALUES ('modules/page.module','page','module','',1); INSERT INTO system VALUES ('modules/story.module','story','module','',1); INSERT INTO system VALUES ('modules/taxonomy.module','taxonomy','module','',1); INSERT INTO system VALUES ('themes/marvin/marvin.theme','marvin','theme','Internet explorer, Netscape, Opera',1); +INSERT INTO users (uid, name, mail) VALUES ('0', 'Anonymous', 'root@localhost'); REPLACE variable SET name='update_start', value='s:10:"2003-04-19;"'; REPLACE variable SET name='theme_default', value='s:6:"marvin";'; diff --git a/database/database.pgsql b/database/database.pgsql index d98bfcdce..5bffed0c7 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -499,7 +499,7 @@ CREATE INDEX term_synonym_name_idx ON term_synonym(name); -- CREATE TABLE users ( - uid SERIAL, + uid integer NOT NULL default '0', name varchar(60) NOT NULL default '', pass varchar(32) NOT NULL default '', mail varchar(64) default '', @@ -580,6 +580,7 @@ INSERT INTO system VALUES ('themes/marvin/marvin.theme','marvin','theme','Intern INSERT INTO variable(name,value) VALUES('update_start', 's:10:"2003-04-19";'); INSERT INTO variable(name,value) VALUES('theme_default','s:6:"marvin";'); +INSERT INTO users(uid,name,mail) VALUES(0,'Anonymous','root@localhost'); INSERT INTO blocks(module,delta,status) VALUES('user', '0', '1'); INSERT INTO blocks(module,delta,status) VALUES('user', '1', '1'); |