-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtransmissions.sql
35 lines (32 loc) · 1.7 KB
/
transmissions.sql
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
-- copyright 2016 Steve Harville
CREATE TABLE "STEVEHARVILLE"."TRANSMISSIONS"
( "TRANS_ID" NUMBER,
"TRANS_NAME" VARCHAR2(60 BYTE),
"TTYPE" VARCHAR2(60 BYTE),
"SPEEDS" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
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 "USERS" ;
CREATE UNIQUE INDEX "STEVEHARVILLE"."TRANSMISSIONS_PK" ON "STEVEHARVILLE"."TRANSMISSIONS" ("TRANS_ID")
PCTFREE 10 INITRANS 2 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 "USERS" ;
--------------------------------------------------------
-- Constraints for Table TRANSMISSIONS
--------------------------------------------------------
ALTER TABLE "STEVEHARVILLE"."TRANSMISSIONS" MODIFY ("TRANS_ID" NOT NULL ENABLE);
ALTER TABLE "STEVEHARVILLE"."TRANSMISSIONS" MODIFY ("TRANS_NAME" NOT NULL ENABLE);
ALTER TABLE "STEVEHARVILLE"."TRANSMISSIONS" MODIFY ("TTYPE" NOT NULL ENABLE);
ALTER TABLE "STEVEHARVILLE"."TRANSMISSIONS" MODIFY ("SPEEDS" NOT NULL ENABLE);
ALTER TABLE "STEVEHARVILLE"."TRANSMISSIONS" ADD CONSTRAINT "TRANSMISSIONS_PK" PRIMARY KEY ("TRANS_ID")
USING INDEX PCTFREE 10 INITRANS 2 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 "USERS" ENABLE;