aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/oracle_schema.sql
diff options
context:
space:
mode:
authorDavid M <davidmj@users.sourceforge.net>2006-12-23 17:50:48 +0000
committerDavid M <davidmj@users.sourceforge.net>2006-12-23 17:50:48 +0000
commit6d0a00a446396ab72d8fb0475f4cd1c8ab9fa151 (patch)
treeb63ff460ba8ef1fec4ef5b5fae3a9dddf6d252e9 /phpBB/install/schemas/oracle_schema.sql
parent9b6e76a808ed7bc4c62ad98df596db45e8f5fabb (diff)
downloadforums-6d0a00a446396ab72d8fb0475f4cd1c8ab9fa151.tar
forums-6d0a00a446396ab72d8fb0475f4cd1c8ab9fa151.tar.gz
forums-6d0a00a446396ab72d8fb0475f4cd1c8ab9fa151.tar.bz2
forums-6d0a00a446396ab72d8fb0475f4cd1c8ab9fa151.tar.xz
forums-6d0a00a446396ab72d8fb0475f4cd1c8ab9fa151.zip
#6492
git-svn-id: file:///svn/phpbb/trunk@6793 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/oracle_schema.sql')
-rw-r--r--phpBB/install/schemas/oracle_schema.sql7
1 files changed, 2 insertions, 5 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index 7a5f05c274..f65d367356 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -1935,12 +1935,9 @@ CREATE TABLE phpbb_zebra (
user_id number(8) DEFAULT '0' NOT NULL,
zebra_id number(8) DEFAULT '0' NOT NULL,
friend number(1) DEFAULT '0' NOT NULL,
- foe number(1) DEFAULT '0' NOT NULL
+ foe number(1) DEFAULT '0' NOT NULL,
+ CONSTRAINT pk_phpbb_zebra PRIMARY KEY (user_id, zebra_id)
)
/
-CREATE INDEX phpbb_zebra_user_id ON phpbb_zebra (user_id)
-/
-CREATE INDEX phpbb_zebra_zebra_id ON phpbb_zebra (zebra_id)
-/