aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/sqlite_schema.sql
diff options
context:
space:
mode:
authorMeik Sievertsen <acydburn@phpbb.com>2006-04-17 22:36:43 +0000
committerMeik Sievertsen <acydburn@phpbb.com>2006-04-17 22:36:43 +0000
commit8d456a0fd7c5b5acb298ae5fe8618a1640bd259f (patch)
tree9602f2f527748eb696927d3570d4c1329ef5e3c9 /phpBB/install/schemas/sqlite_schema.sql
parenta0f8e1323a0fb50e6a4b7449f93b493377eddd2c (diff)
downloadforums-8d456a0fd7c5b5acb298ae5fe8618a1640bd259f.tar
forums-8d456a0fd7c5b5acb298ae5fe8618a1640bd259f.tar.gz
forums-8d456a0fd7c5b5acb298ae5fe8618a1640bd259f.tar.bz2
forums-8d456a0fd7c5b5acb298ae5fe8618a1640bd259f.tar.xz
forums-8d456a0fd7c5b5acb298ae5fe8618a1640bd259f.zip
say hello to role descriptions, role ordering and tooltips on role selects
git-svn-id: file:///svn/phpbb/trunk@5791 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/sqlite_schema.sql')
-rw-r--r--phpBB/install/schemas/sqlite_schema.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index 482299e0ae..291e5f7be5 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -61,11 +61,14 @@ CREATE INDEX phpbb_auth_options_auth_option on phpbb_auth_options (auth_option);
CREATE TABLE phpbb_auth_roles (
role_id INTEGER PRIMARY KEY NOT NULL,
role_name varchar(50) NOT NULL DEFAULT '',
+ role_description text(65535),
role_type varchar(10) NOT NULL DEFAULT '',
+ role_order mediumint(8) NOT NULL DEFAULT '0',
role_group_ids varchar(255) NOT NULL DEFAULT ''
);
CREATE INDEX phpbb_auth_roles_role_type on phpbb_auth_roles (role_type);
+CREATE INDEX phpbb_auth_roles_role_order on phpbb_auth_roles (role_order);
# Table: phpbb_auth_roles_data