diff options
Diffstat (limited to 'phpBB/install/schemas/sqlite_schema.sql')
-rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 3 |
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 |