diff options
Diffstat (limited to 'database')
-rw-r--r-- | database/database.mysql | 4 | ||||
-rw-r--r-- | database/database.pgsql | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/database/database.mysql b/database/database.mysql index 74e550018..5515af7b2 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -594,7 +594,6 @@ CREATE TABLE users ( picture varchar(255) NOT NULL DEFAULT '', init varchar(64) default '', data longtext, - rid int(10) unsigned NOT NULL default '0', PRIMARY KEY (uid), UNIQUE KEY name (name), KEY changed (changed) @@ -667,7 +666,8 @@ INSERT INTO system VALUES ('modules/page.module','page','module','',1,0,0); INSERT INTO system VALUES ('modules/story.module','story','module','',1,0,0); INSERT INTO system VALUES ('modules/taxonomy.module','taxonomy','module','',1,0,0); INSERT INTO system VALUES ('themes/xtemplate/xtemplate.theme','xtemplate','theme','Internet explorer, Netscape, Opera',1,0,0); -INSERT INTO users (uid, name, mail, rid) VALUES ('0', '', '', '1'); +INSERT INTO users (uid, name, mail) VALUES ('0', '', ''); +INSERT INTO users_roles (uid, rid) VALUES (0, 1); INSERT INTO role (rid, name) VALUES (1, 'anonymous user'); INSERT INTO permission VALUES (1,'access content',0); diff --git a/database/database.pgsql b/database/database.pgsql index 35331592e..3b7812599 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -587,7 +587,6 @@ CREATE TABLE users ( picture varchar(255) NOT NULL DEFAULT '', init varchar(64) default '', data text default '', - rid integer NOT NULL default '0', PRIMARY KEY (uid), UNIQUE (name) ); @@ -665,7 +664,8 @@ INSERT INTO system VALUES ('themes/xtemplate/xtemplate.theme','xtemplate','theme INSERT INTO variable(name,value) VALUES('update_start', 's:10:"2004-02-21";'); INSERT INTO variable(name,value) VALUES('theme_default','s:9:"xtemplate";'); -INSERT INTO users(uid,name,mail,rid) VALUES(0,'','', '1'); +INSERT INTO users(uid,name,mail) VALUES(0,'',''); +INSERT INTO users_roles(uid,rid) VALUES(0, 1); INSERT INTO role (rid, name) VALUES (1, 'anonymous user'); INSERT INTO permission VALUES (1,'access content',0); |