projects
/
mir.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
099e20c
)
added 2 missing indexes to uploaded_media
author
zapata
<zapata>
Sat, 14 Jun 2003 14:58:24 +0000
(14:58 +0000)
committer
zapata
<zapata>
Sat, 14 Jun 2003 14:58:24 +0000
(14:58 +0000)
dbscripts/create_pg.sql
patch
|
blob
|
history
diff --git
a/dbscripts/create_pg.sql
b/dbscripts/create_pg.sql
index
f10b4a6
..
6b3501e
100755
(executable)
--- a/
dbscripts/create_pg.sql
+++ b/
dbscripts/create_pg.sql
@@
-315,6
+315,9
@@
CREATE TABLE "other_media" (
)
INHERITS ("uploaded_media");
+CREATE INDEX "idx_othermedia_is_published_produced" on "other_media" using btree ( "is_published" "bool_ops", "is_produced" "bool_ops" );
+CREATE UNIQUE INDEX "idx_othermedia_id" on "other_media" using btree ( "id" "int4_ops" );
+
--
-- content
--