summaryrefslogtreecommitdiff
path: root/database
diff options
context:
space:
mode:
Diffstat (limited to 'database')
-rw-r--r--database/database.mssql4
-rw-r--r--database/database.mysql3
-rw-r--r--database/database.pgsql3
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');