summaryrefslogtreecommitdiff
path: root/database/database.pgsql
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2003-09-09 18:18:43 +0000
committerDries Buytaert <dries@buytaert.net>2003-09-09 18:18:43 +0000
commit8e657f64efb3c3e12365d1c33e6ab89e40d9bfd5 (patch)
treeaf96a46601a88e0be7089151a7bdb95afd54c310 /database/database.pgsql
parentaccebe358c1cb4b07e6dba7f9f7776fe3b09d242 (diff)
downloadbrdo-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/database.pgsql')
-rw-r--r--database/database.pgsql3
1 files changed, 2 insertions, 1 deletions
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');