Repository navigation
Expand file tree
/
Copy pathdemo_ddl.sql
More file actions
110 lines (102 loc) · 3.77 KB
/
Copy pathdemo_ddl.sql
File metadata and controls
110 lines (102 loc) · 3.77 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
CREATE TABLE "DEMO"."UXI_DATA_SRC_LU"
( "ID" NUMBER NOT NULL ENABLE,
"SOURCE" VARCHAR2(255) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"POSSIBLE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'Y' NOT NULL ENABLE,
CONSTRAINT "UXI_DATA_SRC_LU_PK" PRIMARY KEY ("ID")
USING INDEX ENABLE
) DEFAULT COLLATION "USING_NLS_COMP"
/
CREATE TABLE "DEMO"."UXI_ORDERS_LU"
( "ORDER_ID" NUMBER NOT NULL ENABLE,
"CUSTOMER_ID" NUMBER NOT NULL ENABLE,
"ORDER_TOTAL" NUMBER(8,2),
"ORDER_TIMESTAMP" TIMESTAMP (6),
"USER_NAME" VARCHAR2(100) COLLATE "USING_NLS_COMP",
"TAGS" VARCHAR2(4000) COLLATE "USING_NLS_COMP",
CONSTRAINT "UXI_ORDER_PK" PRIMARY KEY ("ORDER_ID")
USING INDEX ENABLE
) DEFAULT COLLATION "USING_NLS_COMP"
/
CREATE TABLE "DEMO"."CONTACT_US"
( "ID" NUMBER,
"FIRST_NAME" VARCHAR2(255) COLLATE "USING_NLS_COMP",
"LAST_NAME" VARCHAR2(255) COLLATE "USING_NLS_COMP",
"EMAIL_ADDRESS" VARCHAR2(400) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"COMMENTS" VARCHAR2(4000) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
CONSTRAINT "CONTACT_US_PK" PRIMARY KEY ("ID")
USING INDEX ENABLE
) DEFAULT COLLATION "USING_NLS_COMP"
/
CREATE TABLE "DEMO"."UXI_AUTHN_METHODS_LU"
( "ID" NUMBER NOT NULL ENABLE,
"METHOD" VARCHAR2(255) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"DESCRIPTION" VARCHAR2(4000) COLLATE "USING_NLS_COMP",
CONSTRAINT "AUTHN_METHODS_PK" PRIMARY KEY ("ID")
USING INDEX ENABLE
) DEFAULT COLLATION "USING_NLS_COMP"
/
CREATE TABLE "DEMO"."UXI_FEATURE_CARDS_LU"
( "CARD_TEXT" VARCHAR2(255) COLLATE "USING_NLS_COMP",
"CARD_IMAGE" VARCHAR2(255) COLLATE "USING_NLS_COMP",
"CARD_CATEGORY" VARCHAR2(255) COLLATE "USING_NLS_COMP",
"CARD_SUBTEXT" VARCHAR2(255) COLLATE "USING_NLS_COMP",
"CARD_ORDER" NUMBER
) DEFAULT COLLATION "USING_NLS_COMP"
/
/
/
/
/
/
ALTER TABLE "DEMO"."UXI_DATA_SRC_LU" ADD CONSTRAINT "UXI_DATA_SRC_LU_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "DATA" ENABLE
/
ALTER TABLE "DEMO"."UXI_ORDERS_LU" ADD CONSTRAINT "UXI_ORDER_PK" PRIMARY KEY ("ORDER_ID")
USING INDEX PCTFREE 10 INITRANS 20 MAXTRANS 255
TABLESPACE "DATA" ENABLE
/
ALTER TABLE "DEMO"."CONTACT_US" ADD CONSTRAINT "CONTACT_US_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 20 MAXTRANS 255
TABLESPACE "DATA" ENABLE
/
ALTER TABLE "DEMO"."UXI_AUTHN_METHODS_LU" ADD CONSTRAINT "AUTHN_METHODS_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "DATA" ENABLE
/
CREATE OR REPLACE EDITIONABLE TRIGGER "DEMO"."UXI_BI_AUTHN_METHODS_LU"
before insert on "UXI_AUTHN_METHODS_LU"
for each row
begin
if :NEW."ID" is null then
select "UXI_AUTHN_METHODS_LU_SEQ".nextval into :NEW."ID" from sys.dual;
end if;
end;
ALTER TRIGGER "DEMO"."UXI_BI_AUTHN_METHODS_LU" ENABLE
/
CREATE OR REPLACE EDITIONABLE TRIGGER "DEMO"."BI_CONTACT_US"
before insert on "CONTACT_US"
for each row
begin
if :NEW."ID" is null then
select "CONTACT_US_SEQ".nextval into :NEW."ID" from sys.dual;
end if;
end;
ALTER TRIGGER "DEMO"."BI_CONTACT_US" ENABLE
/
CREATE OR REPLACE EDITIONABLE TRIGGER "DEMO"."UXI_BI_DATA_SRC_LU"
before insert on "UXI_DATA_SRC_LU"
for each row
begin
if :NEW."ID" is null then
select "UXI_DATA_SRC_LU_SEQ".nextval into :NEW."ID" from sys.dual;
end if;
end;
ALTER TRIGGER "DEMO"."UXI_BI_DATA_SRC_LU" ENABLE
/