API tools faq
paste
Advertisement
Guest User

GM database

a guest
Jun 10th, 2018
78
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 15.51 KB | None | 0 0
raw download clone embed print report
  1. --------------------------------------------------------
  2. -- Archivo creado  - domingo-junio-10-2018  
  3. --------------------------------------------------------
  4. --------------------------------------------------------
  5. --  DDL for Table LABOR
  6. --------------------------------------------------------
  7.  
  8.   CREATE TABLE "HZH8BN"."LABOR"
  9.    (    "PERSONID" VARCHAR2(20 BYTE),
  10.     "SHIFTNUM" VARCHAR2(20 BYTE)
  11.    ) SEGMENT CREATION IMMEDIATE
  12.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  13.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  14.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  15.   TABLESPACE "SYSTEM" ;
  16. --------------------------------------------------------
  17. --  DDL for Table PERSON
  18. --------------------------------------------------------
  19.  
  20.   CREATE TABLE "HZH8BN"."PERSON"
  21.    (    "PERSONID" VARCHAR2(20 BYTE),
  22.     "LOCATION" VARCHAR2(20 BYTE)
  23.    ) SEGMENT CREATION IMMEDIATE
  24.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  25.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  26.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  27.   TABLESPACE "SYSTEM" ;
  28. --------------------------------------------------------
  29. --  DDL for Table WORKORDER
  30. --------------------------------------------------------
  31.  
  32.   CREATE TABLE "HZH8BN"."WORKORDER"
  33.    (    "WONUM" VARCHAR2(20 BYTE),
  34.     "HISTORYFLAG" NUMBER,
  35.     "ISTASK" NUMBER,
  36.     "SITEID" VARCHAR2(20 BYTE),
  37.     "WOCLASS" VARCHAR2(20 BYTE),
  38.     "LOCATION" VARCHAR2(20 BYTE),
  39.     "WORKTYPE" VARCHAR2(20 BYTE),
  40.     "WOEQ8" VARCHAR2(20 BYTE),
  41.     "STATUS" VARCHAR2(20 BYTE),
  42.     "REPORTDATE" DATE
  43.    ) SEGMENT CREATION IMMEDIATE
  44.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  45.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  46.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  47.   TABLESPACE "SYSTEM" ;
  48. --------------------------------------------------------
  49. --  DDL for Table WORKPERIOD
  50. --------------------------------------------------------
  51.  
  52.   CREATE TABLE "HZH8BN"."WORKPERIOD"
  53.    (    "CALNUM" VARCHAR2(20 BYTE),
  54.     "ORGID" VARCHAR2(20 BYTE),
  55.     "SHIFTNUM" VARCHAR2(20 BYTE),
  56.     "WORKDATE" DATE,
  57.     "STARTTIME" DATE,
  58.     "ENDTIME" DATE
  59.    ) SEGMENT CREATION IMMEDIATE
  60.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  61.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  62.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  63.   TABLESPACE "SYSTEM" ;
  64. REM INSERTING INTO HZH8BN.LABOR
  65. SET DEFINE OFF;
  66. INSERT INTO HZH8BN.LABOR (PERSONID,SHIFTNUM) VALUES ('HZRTFT','AZUL');
  67. REM INSERTING INTO HZH8BN.PERSON
  68. SET DEFINE OFF;
  69. INSERT INTO HZH8BN.PERSON (PERSONID,LOCATION) VALUES ('HZRTFT','GA.TN1');
  70. REM INSERTING INTO HZH8BN.WORKORDER
  71. SET DEFINE OFF;
  72. INSERT INTO HZH8BN.WORKORDER (WONUM,HISTORYFLAG,ISTASK,SITEID,WOCLASS,LOCATION,WORKTYPE,WOEQ8,STATUS,REPORTDATE) VALUES ('WONUM1','0','0','6334','WORKORDER','GA','EM','TN1','PROG',TO_DATE('01/06/18','DD/MM/RR'));
  73. INSERT INTO HZH8BN.WORKORDER (WONUM,HISTORYFLAG,ISTASK,SITEID,WOCLASS,LOCATION,WORKTYPE,WOEQ8,STATUS,REPORTDATE) VALUES ('WONUM2','0','0','6334','WORKORDER','GA','EM','TN1','PROG',TO_DATE('01/06/18','DD/MM/RR'));
  74. INSERT INTO HZH8BN.WORKORDER (WONUM,HISTORYFLAG,ISTASK,SITEID,WOCLASS,LOCATION,WORKTYPE,WOEQ8,STATUS,REPORTDATE) VALUES ('WONUM3','0','0','6334','WORKORDER','GA','EM','TN1','PROG',TO_DATE('01/06/18','DD/MM/RR'));
  75. INSERT INTO HZH8BN.WORKORDER (WONUM,HISTORYFLAG,ISTASK,SITEID,WOCLASS,LOCATION,WORKTYPE,WOEQ8,STATUS,REPORTDATE) VALUES ('WONUM4','0','0','6334','WORKORDER','GA','EM','TN1','PROG',TO_DATE('01/06/18','DD/MM/RR'));
  76. INSERT INTO HZH8BN.WORKORDER (WONUM,HISTORYFLAG,ISTASK,SITEID,WOCLASS,LOCATION,WORKTYPE,WOEQ8,STATUS,REPORTDATE) VALUES ('WONUM5','0','0','6334','WORKORDER','GA','EM','TN1','PROG',TO_DATE('01/06/18','DD/MM/RR'));
  77. INSERT INTO HZH8BN.WORKORDER (WONUM,HISTORYFLAG,ISTASK,SITEID,WOCLASS,LOCATION,WORKTYPE,WOEQ8,STATUS,REPORTDATE) VALUES ('WONUM6','0','0','6334','WORKORDER','GA','EM','TN1','PROG',TO_DATE('01/06/18','DD/MM/RR'));
  78. INSERT INTO HZH8BN.WORKORDER (WONUM,HISTORYFLAG,ISTASK,SITEID,WOCLASS,LOCATION,WORKTYPE,WOEQ8,STATUS,REPORTDATE) VALUES ('WONUM7','0','0','6334','WORKORDER','GA','EM','TN1','PROG',TO_DATE('04/06/18','DD/MM/RR'));
  79. INSERT INTO HZH8BN.WORKORDER (WONUM,HISTORYFLAG,ISTASK,SITEID,WOCLASS,LOCATION,WORKTYPE,WOEQ8,STATUS,REPORTDATE) VALUES ('WONUM8','0','0','6334','WORKORDER','GA','EM','TN1','PROG',TO_DATE('04/06/18','DD/MM/RR'));
  80. INSERT INTO HZH8BN.WORKORDER (WONUM,HISTORYFLAG,ISTASK,SITEID,WOCLASS,LOCATION,WORKTYPE,WOEQ8,STATUS,REPORTDATE) VALUES ('WONUM9','0','0','6334','WORKORDER','GA','EM','TN1','PROG',TO_DATE('04/06/18','DD/MM/RR'));
  81. INSERT INTO HZH8BN.WORKORDER (WONUM,HISTORYFLAG,ISTASK,SITEID,WOCLASS,LOCATION,WORKTYPE,WOEQ8,STATUS,REPORTDATE) VALUES ('WONUM10','0','0','6334','WORKORDER','GA','EM','TN1','PROG',TO_DATE('04/06/18','DD/MM/RR'));
  82. INSERT INTO HZH8BN.WORKORDER (WONUM,HISTORYFLAG,ISTASK,SITEID,WOCLASS,LOCATION,WORKTYPE,WOEQ8,STATUS,REPORTDATE) VALUES ('WONUM11','0','0','6334','WORKORDER','GA','EM','TN1','PROG',TO_DATE('05/06/18','DD/MM/RR'));
  83. INSERT INTO HZH8BN.WORKORDER (WONUM,HISTORYFLAG,ISTASK,SITEID,WOCLASS,LOCATION,WORKTYPE,WOEQ8,STATUS,REPORTDATE) VALUES ('WONUM12','0','0','6334','WORKORDER','GA','EM','TN1','PROG',TO_DATE('05/06/18','DD/MM/RR'));
  84. REM INSERTING INTO HZH8BN.WORKPERIOD
  85. SET DEFINE OFF;
  86. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  87. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('04/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  88. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('05/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  89. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('06/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  90. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('07/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  91. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('08/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  92. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('09/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  93. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('11/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  94. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('12/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  95. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('13/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  96. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('14/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  97. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('15/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  98. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('18/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  99. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('19/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  100. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('20/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  101. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('21/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  102. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('22/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  103. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('25/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  104. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('26/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  105. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('27/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  106. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('28/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  107. INSERT INTO HZH8BN.WORKPERIOD (CALNUM,ORGID,SHIFTNUM,WORKDATE,STARTTIME,ENDTIME) VALUES ('ROSARIO','LAAS1002','AZUL',TO_DATE('29/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'),TO_DATE('01/06/18','DD/MM/RR'));
  108. --------------------------------------------------------
  109. --  DDL for Index WORKPERIOD_PK
  110. --------------------------------------------------------
  111.  
  112.   CREATE UNIQUE INDEX "HZH8BN"."WORKPERIOD_PK" ON "HZH8BN"."WORKPERIOD" ("SHIFTNUM", "WORKDATE", "CALNUM", "ORGID")
  113.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  114.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  115.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  116.   TABLESPACE "SYSTEM" ;
  117. --------------------------------------------------------
  118. --  DDL for Index LABOR_PK
  119. --------------------------------------------------------
  120.  
  121.   CREATE UNIQUE INDEX "HZH8BN"."LABOR_PK" ON "HZH8BN"."LABOR" ("PERSONID")
  122.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  123.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  124.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  125.   TABLESPACE "SYSTEM" ;
  126. --------------------------------------------------------
  127. --  DDL for Index PERSON_PK
  128. --------------------------------------------------------
  129.  
  130.   CREATE UNIQUE INDEX "HZH8BN"."PERSON_PK" ON "HZH8BN"."PERSON" ("PERSONID")
  131.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  132.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  133.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  134.   TABLESPACE "SYSTEM" ;
  135. --------------------------------------------------------
  136. --  DDL for Index WORKORDER_PK
  137. --------------------------------------------------------
  138.  
  139.   CREATE UNIQUE INDEX "HZH8BN"."WORKORDER_PK" ON "HZH8BN"."WORKORDER" ("WONUM")
  140.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  141.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  142.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  143.   TABLESPACE "SYSTEM" ;
  144. --------------------------------------------------------
  145. --  Constraints for Table PERSON
  146. --------------------------------------------------------
  147.  
  148.   ALTER TABLE "HZH8BN"."PERSON" ADD CONSTRAINT "PERSON_PK" PRIMARY KEY ("PERSONID")
  149.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  150.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  151.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  152.   TABLESPACE "SYSTEM"  ENABLE;
  153.   ALTER TABLE "HZH8BN"."PERSON" MODIFY ("PERSONID" NOT NULL ENABLE);
  154.   ALTER TABLE "HZH8BN"."PERSON" MODIFY ("LOCATION" NOT NULL ENABLE);
  155. --------------------------------------------------------
  156. --  Constraints for Table LABOR
  157. --------------------------------------------------------
  158.  
  159.   ALTER TABLE "HZH8BN"."LABOR" ADD CONSTRAINT "LABOR_PK" PRIMARY KEY ("PERSONID")
  160.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  161.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  162.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  163.   TABLESPACE "SYSTEM"  ENABLE;
  164.   ALTER TABLE "HZH8BN"."LABOR" MODIFY ("PERSONID" NOT NULL ENABLE);
  165. --------------------------------------------------------
  166. --  Constraints for Table WORKPERIOD
  167. --------------------------------------------------------
  168.  
  169.   ALTER TABLE "HZH8BN"."WORKPERIOD" ADD CONSTRAINT "WORKPERIOD_PK" PRIMARY KEY ("SHIFTNUM", "WORKDATE", "CALNUM", "ORGID")
  170.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  171.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  172.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  173.   TABLESPACE "SYSTEM"  ENABLE;
  174.   ALTER TABLE "HZH8BN"."WORKPERIOD" MODIFY ("ENDTIME" NOT NULL ENABLE);
  175.   ALTER TABLE "HZH8BN"."WORKPERIOD" MODIFY ("STARTTIME" NOT NULL ENABLE);
  176.   ALTER TABLE "HZH8BN"."WORKPERIOD" MODIFY ("WORKDATE" NOT NULL ENABLE);
  177.   ALTER TABLE "HZH8BN"."WORKPERIOD" MODIFY ("SHIFTNUM" NOT NULL ENABLE);
  178.   ALTER TABLE "HZH8BN"."WORKPERIOD" MODIFY ("ORGID" NOT NULL ENABLE);
  179.   ALTER TABLE "HZH8BN"."WORKPERIOD" MODIFY ("CALNUM" NOT NULL ENABLE);
  180. --------------------------------------------------------
  181. --  Constraints for Table WORKORDER
  182. --------------------------------------------------------
  183.  
  184.   ALTER TABLE "HZH8BN"."WORKORDER" ADD CONSTRAINT "WORKORDER_PK" PRIMARY KEY ("WONUM")
  185.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  186.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  187.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  188.   TABLESPACE "SYSTEM"  ENABLE;
  189.   ALTER TABLE "HZH8BN"."WORKORDER" MODIFY ("REPORTDATE" NOT NULL ENABLE);
  190.   ALTER TABLE "HZH8BN"."WORKORDER" MODIFY ("STATUS" NOT NULL ENABLE);
  191.   ALTER TABLE "HZH8BN"."WORKORDER" MODIFY ("WOEQ8" NOT NULL ENABLE);
  192.   ALTER TABLE "HZH8BN"."WORKORDER" MODIFY ("WORKTYPE" NOT NULL ENABLE);
  193.   ALTER TABLE "HZH8BN"."WORKORDER" MODIFY ("LOCATION" NOT NULL ENABLE);
  194.   ALTER TABLE "HZH8BN"."WORKORDER" MODIFY ("WOCLASS" NOT NULL ENABLE);
  195.   ALTER TABLE "HZH8BN"."WORKORDER" MODIFY ("SITEID" NOT NULL ENABLE);
  196.   ALTER TABLE "HZH8BN"."WORKORDER" MODIFY ("ISTASK" NOT NULL ENABLE);
  197.   ALTER TABLE "HZH8BN"."WORKORDER" MODIFY ("HISTORYFLAG" NOT NULL ENABLE);
  198.   ALTER TABLE "HZH8BN"."WORKORDER" MODIFY ("WONUM" NOT NULL ENABLE);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!