diff options
author | Meik Sievertsen <acydburn@phpbb.com> | 2007-05-07 13:19:59 +0000 |
---|---|---|
committer | Meik Sievertsen <acydburn@phpbb.com> | 2007-05-07 13:19:59 +0000 |
commit | 5de26540b4f0348719ec93e760ed987f92a60075 (patch) | |
tree | c3404563a65d5ed2699257ee82d723fb39b28cfe /phpBB/install/schemas/firebird_schema.sql | |
parent | 8678ad0b0b2f83ce91047f06fb73474105a70d7c (diff) | |
download | forums-5de26540b4f0348719ec93e760ed987f92a60075.tar forums-5de26540b4f0348719ec93e760ed987f92a60075.tar.gz forums-5de26540b4f0348719ec93e760ed987f92a60075.tar.bz2 forums-5de26540b4f0348719ec93e760ed987f92a60075.tar.xz forums-5de26540b4f0348719ec93e760ed987f92a60075.zip |
fixing some bugs
changed the way we are handling bookmarks. No order_id required, really! Order by last post time as suggested by BartVB.
git-svn-id: file:///svn/phpbb/trunk@7497 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/firebird_schema.sql')
-rw-r--r-- | phpBB/install/schemas/firebird_schema.sql | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql index 50a59d9c98..f815449d19 100644 --- a/phpBB/install/schemas/firebird_schema.sql +++ b/phpBB/install/schemas/firebird_schema.sql @@ -179,12 +179,11 @@ CREATE INDEX phpbb_bbcodes_display_on_post ON phpbb_bbcodes(display_on_posting); # Table: 'phpbb_bookmarks' CREATE TABLE phpbb_bookmarks ( topic_id INTEGER DEFAULT 0 NOT NULL, - user_id INTEGER DEFAULT 0 NOT NULL, - order_id INTEGER DEFAULT 0 NOT NULL + user_id INTEGER DEFAULT 0 NOT NULL );; -CREATE INDEX phpbb_bookmarks_order_id ON phpbb_bookmarks(order_id);; -CREATE INDEX phpbb_bookmarks_topic_user_id ON phpbb_bookmarks(topic_id, user_id);; +ALTER TABLE phpbb_bookmarks ADD PRIMARY KEY (topic_id, user_id);; + # Table: 'phpbb_bots' CREATE TABLE phpbb_bots ( |