From 2ad25548c67149ac5d1911438ea08f418f23e91c Mon Sep 17 00:00:00 2001 From: moodler Date: Wed, 9 Aug 2006 14:01:14 +0000 Subject: [PATCH] Fixed some typos. Thanks Tim! --- lib/db/postgres7.php | 50 +++++++++---------- lib/db/postgres7.sql | 114 +++++++++++++++++++++---------------------- 2 files changed, 82 insertions(+), 82 deletions(-) diff --git a/lib/db/postgres7.php b/lib/db/postgres7.php index 349438719a..d5cbecebfb 100644 --- a/lib/db/postgres7.php +++ b/lib/db/postgres7.php @@ -1635,26 +1635,26 @@ function main_upgrade($oldversion=0) { modify_database('', "CREATE TABLE prefix_role_assignments ( id SERIAL PRIMARY KEY, - roleid interger NOT NULL default 0, - contextid interger NOT NULL default 0, - userid interger NOT NULL default 0, - hidden interger NOT NULL default 0, - timestart interger NOT NULL default 0, - timeend interger NOT NULL default 0, - timemodified interger NOT NULL default 0, - modifierid interger NOT NULL default 0, + roleid integer NOT NULL default 0, + contextid integer NOT NULL default 0, + userid integer NOT NULL default 0, + hidden integer NOT NULL default 0, + timestart integer NOT NULL default 0, + timeend integer NOT NULL default 0, + timemodified integer NOT NULL default 0, + modifierid integer NOT NULL default 0, enrol varchar(20) NOT NULL default '', - sortorder integer NOT NULL default '0' + sortorder integer NOT NULL default '0' );"); modify_database('', "CREATE TABLE prefix_role_capabilities ( id SERIAL PRIMARY KEY, - contextid interger NOT NULL default 0, - roleid interger NOT NULL default 0, + contextid integer NOT NULL default 0, + roleid integer NOT NULL default 0, capability varchar(255) NOT NULL default '', permission integer NOT NULL default 0, - timemodified interger NOT NULL default 0, - modifierid interger NOT NULL default 0 + timemodified integer NOT NULL default 0, + modifierid integer NOT NULL default 0 );"); modify_database('', "CREATE TABLE prefix_role_deny_grant ( @@ -1664,19 +1664,19 @@ function main_upgrade($oldversion=0) { );"); modify_database('', "CREATE TABLE prefix_capabilities ( - id SERIAL PRIMARY KEY, - name varchar(150) NOT NULL default '', - captype varchar(50) NOT NULL default '', - contextlevel integer NOT NULL default 0, - component varchar(100) NOT NULL default '' + id SERIAL PRIMARY KEY, + name varchar(150) NOT NULL default '', + captype varchar(50) NOT NULL default '', + contextlevel integer NOT NULL default 0, + component varchar(100) NOT NULL default '' );"); - - modify_database('', "CREATE TABLE prefix_role_names ( - id SERIAL PRIMARY KEY, - roleid integer NOT NULL default 0, - contextid integer NOT NULL default 0, - text text NOT NULL default '' - );"); + + modify_database('', "CREATE TABLE prefix_role_names ( + id SERIAL PRIMARY KEY, + roleid integer NOT NULL default 0, + contextid integer NOT NULL default 0, + text text NOT NULL default '' + );"); } return $result; diff --git a/lib/db/postgres7.sql b/lib/db/postgres7.sql index ac2c75fcad..89fbab8bb6 100644 --- a/lib/db/postgres7.sql +++ b/lib/db/postgres7.sql @@ -670,63 +670,63 @@ CREATE TABLE prefix_blog_tag_instance ( CREATE INDEX prefix_bti_entryid_idx ON prefix_blog_tag_instance (entryid); CREATE INDEX prefix_bti_tagid_idx ON prefix_blog_tag_instance (tagid); -# Roles tables -CREATE TABLE prefix_role ( - id SERIAL PRIMARY KEY, - name varchar(255) NOT NULL default '', - description text NOT NULL default '', - sortorder integer NOT NULL default '0' -); - -CREATE TABLE prefix_context ( - id SERIAL PRIMARY KEY, - level integer NOT NULL default 0, - instanceid integer NOT NULL default 0 -); - -CREATE TABLE prefix_role_assignments ( - id SERIAL PRIMARY KEY, - roleid interger NOT NULL default 0, - contextid interger NOT NULL default 0, - userid interger NOT NULL default 0, - hidden interger NOT NULL default 0, - timestart interger NOT NULL default 0, - timeend interger NOT NULL default 0, - timemodified interger NOT NULL default 0, - modifierid interger NOT NULL default 0, - enrol varchar(20) NOT NULL default '', - sortorder integer NOT NULL default '0' -); - -CREATE TABLE prefix_role_capabilities ( - id SERIAL PRIMARY KEY, - contextid interger NOT NULL default 0, - roleid interger NOT NULL default 0, - capability varchar(255) NOT NULL default '', - permission integer NOT NULL default 0, - timemodified interger NOT NULL default 0, - modifierid interger NOT NULL default 0 -); - -CREATE TABLE prefix_role_deny_grant ( - id SERIAL PRIMARY KEY, - roleid integer NOT NULL default '0', - unviewableroleid integer NOT NULL default '0' -); - -CREATE TABLE prefix_capabilities ( - id SERIAL PRIMARY KEY, - name varchar(150) NOT NULL default '', - captype varchar(50) NOT NULL default '', - contextlevel integer NOT NULL default 0, - component varchar(100) NOT NULL default '' -); - -CREATE TABLE prefix_role_names ( - id SERIAL PRIMARY KEY, - roleid integer NOT NULL default 0, - contextid integer NOT NULL default 0, - text text NOT NULL default '' +# Roles tables +CREATE TABLE prefix_role ( + id SERIAL PRIMARY KEY, + name varchar(255) NOT NULL default '', + description text NOT NULL default '', + sortorder integer NOT NULL default '0' +); + +CREATE TABLE prefix_context ( + id SERIAL PRIMARY KEY, + level integer NOT NULL default 0, + instanceid integer NOT NULL default 0 +); + +CREATE TABLE prefix_role_assignments ( + id SERIAL PRIMARY KEY, + roleid integer NOT NULL default 0, + contextid integer NOT NULL default 0, + userid integer NOT NULL default 0, + hidden integer NOT NULL default 0, + timestart integer NOT NULL default 0, + timeend integer NOT NULL default 0, + timemodified integer NOT NULL default 0, + modifierid integer NOT NULL default 0, + enrol varchar(20) NOT NULL default '', + sortorder integer NOT NULL default '0' +); + +CREATE TABLE prefix_role_capabilities ( + id SERIAL PRIMARY KEY, + contextid integer NOT NULL default 0, + roleid integer NOT NULL default 0, + capability varchar(255) NOT NULL default '', + permission integer NOT NULL default 0, + timemodified integer NOT NULL default 0, + modifierid integer NOT NULL default 0 +); + +CREATE TABLE prefix_role_deny_grant ( + id SERIAL PRIMARY KEY, + roleid integer NOT NULL default '0', + unviewableroleid integer NOT NULL default '0' +); + +CREATE TABLE prefix_capabilities ( + id SERIAL PRIMARY KEY, + name varchar(150) NOT NULL default '', + captype varchar(50) NOT NULL default '', + contextlevel integer NOT NULL default 0, + component varchar(100) NOT NULL default '' +); + +CREATE TABLE prefix_role_names ( + id SERIAL PRIMARY KEY, + roleid integer NOT NULL default 0, + contextid integer NOT NULL default 0, + text text NOT NULL default '' ); INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('user', 'view', 'user', 'firstname||\' \'||lastname'); -- 2.39.5