diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-02-11 13:11:36 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-02-11 13:11:36 +0000 |
| commit | 4c21aea0f31bc847a054fce62d3eb71619b38630 (patch) | |
| tree | bd7153df6460b6011dec57c4f57676b79a3f17d3 /phpBB/db | |
| parent | 1c145bf6bdfcb65340567409b75e66d1495b506f (diff) | |
| download | forums-4c21aea0f31bc847a054fce62d3eb71619b38630.tar forums-4c21aea0f31bc847a054fce62d3eb71619b38630.tar.gz forums-4c21aea0f31bc847a054fce62d3eb71619b38630.tar.bz2 forums-4c21aea0f31bc847a054fce62d3eb71619b38630.tar.xz forums-4c21aea0f31bc847a054fce62d3eb71619b38630.zip | |
Remove auto increment/IDENTITY/autonumber/sequence from forum_id in _forums, this is set by the admin_forums app itself.
git-svn-id: file:///svn/phpbb/trunk@2089 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/schemas/ms_access_primer.zip | bin | 100580 -> 99958 bytes | |||
| -rw-r--r-- | phpBB/db/schemas/mssql_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/db/schemas/mysql_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/db/schemas/postgres_schema.sql | 3 |
4 files changed, 3 insertions, 4 deletions
diff --git a/phpBB/db/schemas/ms_access_primer.zip b/phpBB/db/schemas/ms_access_primer.zip Binary files differindex cc6f39c44b..83dc62331c 100644 --- a/phpBB/db/schemas/ms_access_primer.zip +++ b/phpBB/db/schemas/ms_access_primer.zip diff --git a/phpBB/db/schemas/mssql_schema.sql b/phpBB/db/schemas/mssql_schema.sql index 9a58f2d18b..1e76eb855c 100644 --- a/phpBB/db/schemas/mssql_schema.sql +++ b/phpBB/db/schemas/mssql_schema.sql @@ -63,7 +63,7 @@ CREATE TABLE [phpbb_forum_prune] ( GO CREATE TABLE [phpbb_forums] ( - [forum_id] [int] IDENTITY (1, 1) NOT NULL , + [forum_id] [int] NOT NULL , [cat_id] [int] NOT NULL , [forum_name] [varchar] (100) NOT NULL , [forum_desc] [varchar] (255) NULL , diff --git a/phpBB/db/schemas/mysql_schema.sql b/phpBB/db/schemas/mysql_schema.sql index c9ca19e03c..8d0e08e545 100644 --- a/phpBB/db/schemas/mysql_schema.sql +++ b/phpBB/db/schemas/mysql_schema.sql @@ -121,7 +121,7 @@ CREATE TABLE phpbb_forum_prune ( # Table structure for table 'phpbb_forums' # CREATE TABLE phpbb_forums ( - forum_id smallint(5) UNSIGNED NOT NULL auto_increment, + forum_id smallint(5) UNSIGNED NOT NULL, cat_id mediumint(8) UNSIGNED NOT NULL, forum_name varchar(150), forum_desc text, diff --git a/phpBB/db/schemas/postgres_schema.sql b/phpBB/db/schemas/postgres_schema.sql index f322a333de..2ccd892d94 100644 --- a/phpBB/db/schemas/postgres_schema.sql +++ b/phpBB/db/schemas/postgres_schema.sql @@ -8,7 +8,6 @@ CREATE SEQUENCE phpbb_banlist_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; CREATE SEQUENCE phpbb_categories_id_seq start 2 increment 1 maxvalue 2147483647 minvalue 1 cache 1; CREATE SEQUENCE phpbb_disallow_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; -CREATE SEQUENCE phpbb_forums_id_seq start 2 increment 1 maxvalue 2147483647 minvalue 1 cache 1; CREATE SEQUENCE phpbb_posts_id_seq start 2 increment 1 maxvalue 2147483647 minvalue 1 cache 1; CREATE SEQUENCE phpbb_privmsgs_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1; CREATE SEQUENCE phpbb_ranks_id_seq start 2 increment 1 maxvalue 2147483647 minvalue 1 cache 1; @@ -106,7 +105,7 @@ CREATE TABLE phpbb_disallow ( Table structure for table phpbb_forums -------------------------------------------------------- */ CREATE TABLE phpbb_forums ( - forum_id int4 DEFAULT nextval('phpbb_forums_id_seq'::text) NOT NULL, + forum_id int4 DEFAULT '0' NOT NULL, cat_id int4, forum_name varchar(150), forum_desc text, |