EXPORT:V07.01.04 UORDERDAT RUSERS 1024 0 Tue Mar 18 16:22:42 1997 CREATE SEQUENCE "ITEM_NUMBERS" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 500 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "ORDER_ITEM_NUMBERS" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 500 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "ORDER_NUMBERS" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 500 CACHE 20 NOORDER NOCYCLE TABLE "COLORS" CREATE TABLE "COLORS" ("COLOR_ID" NUMBER(3, 0) NOT NULL, "DESCRIPTION" CHAR(100)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USER_DATA" INSERT INTO "COLORS" ("COLOR_ID", "DESCRIPTION") VALUES (:1, :2) `ddRed dBlue dGreen dWhite dBlack dPurple dYellow  dTan  dTaupe  dPlaid ALTER TABLE "COLORS" ADD PRIMARY KEY ("COLOR_ID") USING INDEX STORAGE (INITIAL 20480 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 ) TABLESPACE "USER_DATA" TABLE "CUSTOMERS" CREATE TABLE "CUSTOMERS" ("CUSTOMER_NAME" CHAR(40) NOT NULL, "ADDRESS1" CHAR(40), "ADDRESS2" CHAR(40), "CITY" CHAR(20), "STATE" CHAR(2), "ZIP" CHAR(10), "TELEPHONE" CHAR(12), "CREDIT_LIMIT" FLOAT(23)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USER_DATA" INSERT INTO "CUSTOMERS" ("CUSTOMER_NAME", "ADDRESS1", "ADDRESS2", "CITY", "STATE", "ZIP", "TELEPHONE", "CREDIT_LIMIT") VALUES (:1, :2, :3, :4, :5, :6, :7, :8) `(`(`(``` ` (Acme Traders (111 Main Street Albuquerque NM 87101 505-555-1212(Bailey Boating (222 Second Street (Suite 23 Bozeman MT 59715 406-555-1212(Copelands Restaurant (33 St. Charles New Orleans LA 70112 504-555-1212(Denny Diamonds (4444 Avenue of The Americas New York NY 10007 212-555-1212(Evanston Liquors (253 Orrington Evanston IL 60201 847-555-1212 TABLE "DISCOUNTS" CREATE TABLE "DISCOUNTS" ("LOW" NUMBER(10, 0), "HIGH" CHAR(6), "DISCOUNT" NUMBER(2, 2), "ITEM_NUMBER" NUMBER(5, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USER_DATA" INSERT INTO "DISCOUNTS" ("LOW", "HIGH", "DISCOUNT", "ITEM_NUMBER") VALUES (:1, :2, :3, :4) `24 48 290  \120 99999936  &72   J999999 12  24  36  &48  260  >72  J999999 100 200  300 999999999999 TABLE "ITEMS" CREATE TABLE "ITEMS" ("ITEM_NUMBER" NUMBER(5, 0) NOT NULL, "DESCRIPTION" CHAR(40), "PRICE" NUMBER(6, 2) NOT NULL, "CATALOG_DESCRIPTION" CHAR(240), "ITEM_WEIGHT_LBS" NUMBER(7, 2)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USER_DATA" INSERT INTO "ITEMS" ("ITEM_NUMBER", "DESCRIPTION", "PRICE", "CATALOG_DESCRIPTION", "ITEM_WEIGHT_LBS") VALUES (:1, :2, :3, :4, :5) `(`(Original Berribou The one, the only - our original product. Others may copy, but none will duplicate!  (Chromed Malidrome For the elegant you - a fully functional malidrome highlighted with shiny chrome. Perfect for Dads!  (Troisonne Not one, not two, but three positions for the Troisonne. Like nothing you've ever seen! (Kowlicky Ly A natural herb from the Orient, guaranteed to thrill and amaze you and your friends. (Saturated Niops High power in a familiar niop package. ALTER TABLE "ITEMS" ADD PRIMARY KEY ("ITEM_NUMBER") USING INDEX STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 ) TABLESPACE "USER_DATA" TABLE "ITEM_COLORS" CREATE TABLE "ITEM_COLORS" ("ITEM_NUMBER" NUMBER(5, 0) NOT NULL, "COLOR_ID" NUMBER(3, 0) NOT NULL) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USER_DATA" INSERT INTO "ITEM_COLORS" ("ITEM_NUMBER", "COLOR_ID") VALUES (:1, :2)              TABLE "ITEM_PICTURES" CREATE TABLE "ITEM_PICTURES" ("ITEM_NUMBER" NUMBER(5, 0), "PICTURE" LONG RAW) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 92160 NEXT 36864 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USER_DATA" INSERT INTO "ITEM_PICTURES" ("ITEM_NUMBER", "PICTURE") VALUES (:1, :2) nBMj6(~jʦ        6BM6(O@ʦ !BM6(_Mʦ                              ZKBM$G6(t$Gʦ                          ALTER TABLE "ITEM_PICTURES" ADD PRIMARY KEY ("ITEM_NUMBER") USING INDEX STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 ) TABLESPACE "USER_DATA" TABLE "ITEM_STOCK" CREATE TABLE "ITEM_STOCK" ("ITEM_NUMBER" NUMBER(5, 0), "IN_STOCK" NUMBER(10, 0), "LOCATION" CHAR(20)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USER_DATA" INSERT INTO "ITEM_STOCK" ("ITEM_NUMBER", "IN_STOCK", "LOCATION") VALUES (:1, :2, :3) `Main Main Main Main Main TABLE "ORDERS" CREATE TABLE "ORDERS" ("ORDER_NUMBER" NUMBER(5, 0) NOT NULL, "CUSTOMER_NAME" CHAR(40) NOT NULL, "ADDRESS1" CHAR(40), "ADDRESS2" CHAR(40), "CITY" CHAR(20), "STATE" CHAR(2), "ZIP" CHAR(10), "TELEPHONE" CHAR(12), "SHIP_NAME" CHAR(40), "ORDER_STATUS" CHAR(1), "CARRIER_TYPE" NUMBER(3, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USER_DATA" INSERT INTO "ORDERS" ("ORDER_NUMBER", "CUSTOMER_NAME", "ADDRESS1", "ADDRESS2", "CITY", "STATE", "ZIP", "TELEPHONE", "SHIP_NAME", "ORDER_STATUS", "CARRIER_TYPE") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11) `(`(`(``` ` `(`(Acme Traders (111 Main Street Albuquerque NM 87101 505-555-1212(Bailey Boating (222 Second Street (Suite 23 Bozeman MT 59715 406-555-1212(Phil Dog (Copelands Restaurant (33 St. Charles New Orleans LA 70112 504-555-1212(Denny Diamonds (4444 Avenue of The Americas New York NY 10007 212-555-1212 ALTER TABLE "ORDERS" ADD PRIMARY KEY ("ORDER_NUMBER") USING INDEX STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 ) TABLESPACE "USER_DATA" TABLE "ORDER_ITEMS" CREATE TABLE "ORDER_ITEMS" ("ORDER_ITEM_ID" NUMBER(5, 0) NOT NULL, "ORDER_NUMBER" NUMBER(5, 0) NOT NULL, "ORDER_ITEM" NUMBER(5, 0), "DISCOUNT" NUMBER(2, 2), "QUANTITY" NUMBER(5, 0), "COLORS" CHAR(100)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USER_DATA" INSERT INTO "ORDER_ITEMS" ("ORDER_ITEM_ID", "ORDER_NUMBER", "ORDER_ITEM", "DISCOUNT", "QUANTITY", "COLORS") VALUES (:1, :2, :3, :4, :5, :6) `d    TABLE "ORDER_ITEM_COLORS" CREATE TABLE "ORDER_ITEM_COLORS" ("ORDER_NUMBER" NUMBER(5, 0) NOT NULL, "ORDER_ITEM_ID" NUMBER(5, 0) NOT NULL, "COLOR_ID" NUMBER(3, 0) NOT NULL, "QUANTITY" NUMBER(5, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "USER_DATA" INSERT INTO "ORDER_ITEM_COLORS" ("ORDER_NUMBER", "ORDER_ITEM_ID", "COLOR_ID", "QUANTITY") VALUES (:1, :2, :3, :4)           ENDTABLE ENDTABLE ENDTABLE EXIT