dépôts
/
lhc
/
web
/
wiklou.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
MCR: replace slot_inherited with slot_origin
[lhc/web/wiklou.git]
/
maintenance
/
oracle
/
archives
/
patch-slots.sql
diff --git
a/maintenance/oracle/archives/patch-slots.sql
b/maintenance/oracle/archives/patch-slots.sql
index
094ab68
..
fde35d5
100644
(file)
--- a/
maintenance/oracle/archives/patch-slots.sql
+++ b/
maintenance/oracle/archives/patch-slots.sql
@@
-2,9
+2,9
@@
CREATE TABLE &mw_prefix.slots (
slot_revision_id NUMBER NOT NULL,
slot_role_id NUMBER NOT NULL,
slot_content_id NUMBER NOT NULL,
slot_revision_id NUMBER NOT NULL,
slot_role_id NUMBER NOT NULL,
slot_content_id NUMBER NOT NULL,
- slot_
inherited CHAR(1) DEFAULT '0'
NOT NULL
+ slot_
origin NUMBER
NOT NULL
);
ALTER TABLE &mw_prefix.slots ADD CONSTRAINT &mw_prefix.slots_pk PRIMARY KEY (slot_revision_id, slot_role_id);
);
ALTER TABLE &mw_prefix.slots ADD CONSTRAINT &mw_prefix.slots_pk PRIMARY KEY (slot_revision_id, slot_role_id);
-CREATE INDEX &mw_prefix.slot_role_inherited ON &mw_prefix.slots (slot_revision_id, slot_role_id, slot_inherited);
\ No newline at end of file
+CREATE INDEX &mw_prefix.slot_revision_origin_role ON &mw_prefix.slots (slot_revision_id, slot_origin, slot_role_id);