mirror of
https://bitbucket.org/theswgsource/src-1.2.git
synced 2026-07-14 00:01:30 -04:00
10 lines
457 B
SQL
10 lines
457 B
SQL
CREATE TABLE "ACCOUNT_MAP"
|
|
(
|
|
"PARENT_ID" NUMBER(38,0) NOT NULL ENABLE,
|
|
"CHILD_ID" NUMBER(38,0) NOT NULL ENABLE,
|
|
CONSTRAINT "ACCOUNT_MAP_UK1" UNIQUE ("CHILD_ID", "PARENT_ID") USING INDEX (CREATE INDEX "ACCOUNT_MAP_INDEX2" ON "ACCOUNT_MAP" ("CHILD_ID","PARENT_ID")),
|
|
CONSTRAINT "ACCOUNT_MAP_UK2" UNIQUE ("CHILD_ID") USING INDEX (CREATE INDEX "ACCOUNT_MAP_INDEX1" ON "ACCOUNT_MAP" ("CHILD_ID"))
|
|
);
|
|
|
|
grant select on account_map to public;
|