--------------------------------------------------------
--  File created - Sunday-March-31-2019   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table ORDERITEM
--------------------------------------------------------

  CREATE TABLE "ORDERITEM" ("ORDERITEM_ID" NUMBER(10,0), "NAME" VARCHAR2(45), "PRICE" NUMBER(10,2), "QUANTITY" NUMBER(10,0), "CATEGORY_ID" NUMBER(10,0), "SUBCATEGORY_ID" NUMBER(10,0), "ORDER_ID" NUMBER(20,0), "PRODUCT_ID" NUMBER(10,0))
REM INSERTING into ORDERITEM
SET DEFINE OFF;
Insert into ORDERITEM (ORDERITEM_ID,NAME,PRICE,QUANTITY,CATEGORY_ID,SUBCATEGORY_ID,ORDER_ID,PRODUCT_ID) values (2019,'Immortals of Meluha - Secret of Nagas',135,1,1000126,1000101,12188842071573416,122);
Insert into ORDERITEM (ORDERITEM_ID,NAME,PRICE,QUANTITY,CATEGORY_ID,SUBCATEGORY_ID,ORDER_ID,PRODUCT_ID) values (2020,'Immortals of Meluha - Secret of Nagas',135,1,1000126,1000101,12188842074932864,122);
Insert into ORDERITEM (ORDERITEM_ID,NAME,PRICE,QUANTITY,CATEGORY_ID,SUBCATEGORY_ID,ORDER_ID,PRODUCT_ID) values (2021,'Immortals of Meluha - Secret of Nagas',135,1,1000126,1000101,12188842075308552,122);
Insert into ORDERITEM (ORDERITEM_ID,NAME,PRICE,QUANTITY,CATEGORY_ID,SUBCATEGORY_ID,ORDER_ID,PRODUCT_ID) values (2022,'World of Warcraft - Rise of the Horde',450,1,1000126,1000101,12188842077844144,124);
Insert into ORDERITEM (ORDERITEM_ID,NAME,PRICE,QUANTITY,CATEGORY_ID,SUBCATEGORY_ID,ORDER_ID,PRODUCT_ID) values (2023,'Sony Xperia M2 Silver',45000,1,1000125,1000115,12188842080499328,112);
Insert into ORDERITEM (ORDERITEM_ID,NAME,PRICE,QUANTITY,CATEGORY_ID,SUBCATEGORY_ID,ORDER_ID,PRODUCT_ID) values (2024,'Immortals of Meluha - Oath of Vayuputras',135,1,1000126,1000101,20180202122640,123);
Insert into ORDERITEM (ORDERITEM_ID,NAME,PRICE,QUANTITY,CATEGORY_ID,SUBCATEGORY_ID,ORDER_ID,PRODUCT_ID) values (2017,'iPhone 5 32GB',45000,1,1000125,1000100,12188841454681640,104);
Insert into ORDERITEM (ORDERITEM_ID,NAME,PRICE,QUANTITY,CATEGORY_ID,SUBCATEGORY_ID,ORDER_ID,PRODUCT_ID) values (2018,'iPhone 5 32GB',45000,1,1000125,1000100,12188841454934112,104);
Insert into ORDERITEM (ORDERITEM_ID,NAME,PRICE,QUANTITY,CATEGORY_ID,SUBCATEGORY_ID,ORDER_ID,PRODUCT_ID) values (2034,'Motorola Moto E',7000,3,1000125,1000101,12194943024703328,106);
Insert into ORDERITEM (ORDERITEM_ID,NAME,PRICE,QUANTITY,CATEGORY_ID,SUBCATEGORY_ID,ORDER_ID,PRODUCT_ID) values (2035,'Motorola Moto X2',35000,1,1000125,1000101,12194943024703328,110);
Insert into ORDERITEM (ORDERITEM_ID,NAME,PRICE,QUANTITY,CATEGORY_ID,SUBCATEGORY_ID,ORDER_ID,PRODUCT_ID) values (2036,'Sony Xperia Black',35000,1,1000125,1000115,12194943031467524,116);
Insert into ORDERITEM (ORDERITEM_ID,NAME,PRICE,QUANTITY,CATEGORY_ID,SUBCATEGORY_ID,ORDER_ID,PRODUCT_ID) values (2037,'iPhone 5 32GB',45000,2,1000125,1000100,12194943031467524,104);
Insert into ORDERITEM (ORDERITEM_ID,NAME,PRICE,QUANTITY,CATEGORY_ID,SUBCATEGORY_ID,ORDER_ID,PRODUCT_ID) values (2038,'Sony Xperia M2 Black',40000,3,1000125,1000115,12194943031467524,111);
--------------------------------------------------------
--  DDL for Index PK_ORDERITEMID
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_ORDERITEMID" ON "ORDERITEM" ("ORDERITEM_ID")
--------------------------------------------------------
--  Constraints for Table ORDERITEM
--------------------------------------------------------

  ALTER TABLE "ORDERITEM" MODIFY ("ORDERITEM_ID" NOT NULL ENABLE)
  ALTER TABLE "ORDERITEM" MODIFY ("NAME" NOT NULL ENABLE)
  ALTER TABLE "ORDERITEM" MODIFY ("PRICE" NOT NULL ENABLE)
  ALTER TABLE "ORDERITEM" MODIFY ("QUANTITY" NOT NULL ENABLE)
  ALTER TABLE "ORDERITEM" MODIFY ("CATEGORY_ID" NOT NULL ENABLE)
  ALTER TABLE "ORDERITEM" MODIFY ("SUBCATEGORY_ID" NOT NULL ENABLE)
  ALTER TABLE "ORDERITEM" MODIFY ("ORDER_ID" NOT NULL ENABLE)
  ALTER TABLE "ORDERITEM" MODIFY ("PRODUCT_ID" NOT NULL ENABLE)
  ALTER TABLE "ORDERITEM" ADD CONSTRAINT "PK_ORDERITEMID" PRIMARY KEY ("ORDERITEM_ID") ENABLE
