diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2005-10-04 21:26:04 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2005-10-04 21:26:04 +0000 |
| commit | 95ff1f3b64fdbf7d72fa86a94cf606a0369aa6bd (patch) | |
| tree | f620dc91729ec604947f1a5e8223a1aab36a1b7d /phpBB/install/schemas/sqlite_schema.sql | |
| parent | 5082f5eb7303ad52c5d440f1cf1466d886e9feef (diff) | |
| download | forums-95ff1f3b64fdbf7d72fa86a94cf606a0369aa6bd.tar forums-95ff1f3b64fdbf7d72fa86a94cf606a0369aa6bd.tar.gz forums-95ff1f3b64fdbf7d72fa86a94cf606a0369aa6bd.tar.bz2 forums-95ff1f3b64fdbf7d72fa86a94cf606a0369aa6bd.tar.xz forums-95ff1f3b64fdbf7d72fa86a94cf606a0369aa6bd.zip | |
- the schema/data changes needed for the new module class
git-svn-id: file:///svn/phpbb/trunk@5253 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/sqlite_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 21 |
1 files changed, 12 insertions, 9 deletions
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql index 88e1ed05ba..906e934646 100644 --- a/phpBB/install/schemas/sqlite_schema.sql +++ b/phpBB/install/schemas/sqlite_schema.sql @@ -334,16 +334,19 @@ CREATE INDEX forum_id_phpbb_moderator_cache on phpbb_moderator_cache (forum_id); # Table: phpbb_modules CREATE TABLE phpbb_modules ( module_id INTEGER PRIMARY KEY NOT NULL, - module_type char(3) NOT NULL DEFAULT '', - module_title varchar(50) NOT NULL DEFAULT '', - module_filename varchar(50) NOT NULL DEFAULT '', - module_order mediumint(4) NOT NULL DEFAULT '0', module_enabled tinyint(1) NOT NULL DEFAULT '1', - module_subs text(65535) NOT NULL, - module_acl varchar(255) NOT NULL DEFAULT '' -); - -CREATE INDEX module_type_phpbb_modules on phpbb_modules (module_type, module_enabled); + module_name varchar(20) NOT NULL DEFAULT '', + module_class varchar(4) NOT NULL DEFAULT '', + parent_id smallint(5) NOT NULL DEFAULT '0', + left_id smallint(5) NOT NULL DEFAULT '0', + right_id smallint(5) NOT NULL DEFAULT '0', + module_langname varchar(50) NOT NULL DEFAULT '', + module_mode varchar(255) NOT NULL DEFAULT '', + module_auth varchar(255) NOT NULL DEFAULT '' +); + +CREATE INDEX module_enabled_phpbb_modules on phpbb_modules (module_enabled); +CREATE INDEX left_id_phpbb_modules on phpbb_modules (left_id); # Table: phpbb_poll_results CREATE TABLE phpbb_poll_results ( |