--------------------------------------------------------
--  File created - Monday-February-05-2018   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table SUBCATEGORY
--------------------------------------------------------

  CREATE TABLE "SYSTEM"."SUBCATEGORY" 
   (	"SUBCATEGORY_ID" NUMBER(10,0), 
	"CATEGORY_ID" NUMBER(10,0), 
	"NAME" VARCHAR2(45 BYTE)
   ) 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 "SYSTEM" ;
REM INSERTING into SYSTEM.SUBCATEGORY
SET DEFINE OFF;
Insert into SYSTEM.SUBCATEGORY (SUBCATEGORY_ID,CATEGORY_ID,NAME) values (1000100,1000125,'Apple');
Insert into SYSTEM.SUBCATEGORY (SUBCATEGORY_ID,CATEGORY_ID,NAME) values (1000101,1000125,'Motorola');
Insert into SYSTEM.SUBCATEGORY (SUBCATEGORY_ID,CATEGORY_ID,NAME) values (1000102,1000126,'Novels');
Insert into SYSTEM.SUBCATEGORY (SUBCATEGORY_ID,CATEGORY_ID,NAME) values (1000103,1000126,'Literature');
Insert into SYSTEM.SUBCATEGORY (SUBCATEGORY_ID,CATEGORY_ID,NAME) values (1000104,1000126,'Academics');
Insert into SYSTEM.SUBCATEGORY (SUBCATEGORY_ID,CATEGORY_ID,NAME) values (1000105,1000126,'Biography');
Insert into SYSTEM.SUBCATEGORY (SUBCATEGORY_ID,CATEGORY_ID,NAME) values (1000106,1000125,'Blackberry');
Insert into SYSTEM.SUBCATEGORY (SUBCATEGORY_ID,CATEGORY_ID,NAME) values (1000107,1000127,'Action');
Insert into SYSTEM.SUBCATEGORY (SUBCATEGORY_ID,CATEGORY_ID,NAME) values (1000108,1000127,'Comedy');
Insert into SYSTEM.SUBCATEGORY (SUBCATEGORY_ID,CATEGORY_ID,NAME) values (1000109,1000127,'Thriller');
Insert into SYSTEM.SUBCATEGORY (SUBCATEGORY_ID,CATEGORY_ID,NAME) values (1000110,1000127,'Sci-Fi');
Insert into SYSTEM.SUBCATEGORY (SUBCATEGORY_ID,CATEGORY_ID,NAME) values (1000111,1000128,'Arcade');
Insert into SYSTEM.SUBCATEGORY (SUBCATEGORY_ID,CATEGORY_ID,NAME) values (1000112,1000128,'Sports');
Insert into SYSTEM.SUBCATEGORY (SUBCATEGORY_ID,CATEGORY_ID,NAME) values (1000113,1000128,'RPG');
Insert into SYSTEM.SUBCATEGORY (SUBCATEGORY_ID,CATEGORY_ID,NAME) values (1000114,1000128,'Adventure');
Insert into SYSTEM.SUBCATEGORY (SUBCATEGORY_ID,CATEGORY_ID,NAME) values (1000115,1000125,'Sony');
--------------------------------------------------------
--  DDL for Index PK_SUBID
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYSTEM"."PK_SUBID" ON "SYSTEM"."SUBCATEGORY" ("SUBCATEGORY_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 "SYSTEM" ;
--------------------------------------------------------
--  Constraints for Table SUBCATEGORY
--------------------------------------------------------

  ALTER TABLE "SYSTEM"."SUBCATEGORY" ADD CONSTRAINT "PK_SUBID" PRIMARY KEY ("SUBCATEGORY_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 "SYSTEM"  ENABLE;
  ALTER TABLE "SYSTEM"."SUBCATEGORY" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "SYSTEM"."SUBCATEGORY" MODIFY ("CATEGORY_ID" NOT NULL ENABLE);
  ALTER TABLE "SYSTEM"."SUBCATEGORY" MODIFY ("SUBCATEGORY_ID" NOT NULL ENABLE);
