home *** CD-ROM | disk | FTP | other *** search
/ Piper's Pit BBS/FTP: ibm 0040 - 0049 / ibm0040-0049 / ibm0040.tar / ibm0040 / WINBASE2.ZIP / EXAMPLES.EXE / SORRENTO / SORRENTO.SQL < prev    next >
Encoding:
Text File  |  1991-07-10  |  6.0 KB  |  102 lines
  1. CREATE TABLE ADMIN(EMPLOYEE_NUM CHAR(10),FNAME CHAR(20),MNAME
  2.  CHAR(20),LNAME CHAR(20), DEPT CHAR(20), ADDRESS CHAR(25),
  3. CITY CHAR(20), STATE CHAR(5),ZIP CHAR(10),PHONE CHAR(15),
  4. SSNO INT,SALARY MONEY,HOURLY_PAY MONEY);
  5. INSERT INTO ADMIN(EMPLOYEE_NUM,FNAME,MNAME,LNAME,DEPT,ADDRESS,CITY,STATE,ZIP,PHONE,SSNO,
  6. SALARY,HOURLY_PAY)
  7. VALUES('2401','JAMES','L.','SMITH','SALES','2349 MARKET ST.','SAN DIEGO','CA','92113','6191234567',
  8. 587529854,45000,0);
  9. INSERT INTO ADMIN(EMPLOYEE_NUM,FNAME,MNAME,LNAME,DEPT,ADDRESS,CITY,STATE,ZIP,PHONE,SSNO,
  10. SALARY,HOURLY_PAY)
  11. VALUES('2402','KELLY','H.','BACH','SECRETARY','127 H. ST.','LOAGAN HEIGHTS','CA','92340',
  12. '6195551234',129239871,18000,0);
  13. INSERT INTO ADMIN(EMPLOYEE_NUM,FNAME,MNAME,LNAME,DEPT,ADDRESS,CITY,STATE,ZIP,PHONE,SSNO,
  14. SALARY,HOURLY_PAY)
  15. VALUES('2403','JOHN','J.','BRADY','SALES','94 1ST. STREET','LAGUNA','CA','92004',
  16. '6194520000',452393847,35000,0);
  17. INSERT INTO ADMIN(EMPLOYEE_NUM,FNAME,MNAME,LNAME,DEPT,ADDRESS,CITY,STATE,ZIP,PHONE,SSNO,
  18. SALARY,HOURLY_PAY)
  19. VALUES('2404','ALLAN','F.','CONSTANT','WAREHOUSE','4095 HIGHLAND','EL CAJON','CA','92880',
  20. '6195552345',557234590,0,12);
  21. INSERT INTO ADMIN(EMPLOYEE_NUM,FNAME,MNAME,LNAME,DEPT,ADDRESS,CITY,STATE,ZIP,PHONE,SSNO,
  22. SALARY,HOURLY_PAY)
  23. VALUES('2405','HOWARD','B.','JONES','PROD. MANAGER','34 EIGHTH ST.','CORONADO','CA','92105',
  24. '6193406900',235612341,60000,0);
  25. INSERT INTO ADMIN(EMPLOYEE_NUM,FNAME,MNAME,LNAME,DEPT,ADDRESS,CITY,STATE,ZIP,PHONE,SSNO,
  26. SALARY,HOURLY_PAY)
  27. VALUES('2406','LEE','D.','GRANT','PRESIDENT','6055 FEDERAL ST.','LA JOLLA','CA','92103',
  28. '6195559900',557123934,85000,0);
  29. INSERT INTO ADMIN(EMPLOYEE_NUM,FNAME,MNAME,LNAME,DEPT,ADDRESS,CITY,STATE,ZIP,PHONE,SSNO,
  30. SALARY,HOURLY_PAY)
  31. VALUES('2407','HELLAN','R.','TERRY','OFFICE MANAGER','1150 MORAGA','SAN DIEGO','CA','92001',
  32. '6195552310',355559047,28000,0);
  33. INSERT INTO ADMIN(EMPLOYEE_NUM,FNAME,MNAME,LNAME,DEPT,ADDRESS,CITY,STATE,ZIP,PHONE,SSNO,
  34. SALARY,HOURLY_PAY)
  35. VALUES('2408','HOGAN','B.','HOFFMAN','MARKETING','1229 SATURN','BONSAL','CA','92556',
  36. '6195553399',555551111,35000,0);
  37. INSERT INTO ADMIN(EMPLOYEE_NUM,FNAME,MNAME,LNAME,DEPT,ADDRESS,CITY,STATE,ZIP,PHONE,SSNO,
  38. SALARY,HOURLY_PAY)
  39. VALUES('2409','RICHARD','E.','BENN','SALES','6924 PEACH','LA MESA','CA','92119',
  40. '6195558876',123248889,15000,0);
  41. INSERT INTO ADMIN(EMPLOYEE_NUM,FNAME,MNAME,LNAME,DEPT,ADDRESS,CITY,STATE,ZIP,PHONE,SSNO,
  42. SALARY,HOURLY_PAY)
  43. VALUES('2410','RENEE','A.','HOPKINS','MARKETING','2438 APPLE','FALLBROOK','CA','92000',
  44. '6195551122',333227891,25000,0);
  45.  
  46. CREATE TABLE CUSTOMER(COMPANY CHAR(25),ADDR1 CHAR(25),CITY CHAR(16),STATE CHAR(5),
  47. ZIP CHAR(10),PHONE CHAR(14),FNAME CHAR(15),LNAME CHAR(15),CUST_ID CHAR(10));
  48. INSERT INTO CUSTOMER (COMPANY,ADDR1,CITY,STATE,ZIP,PHONE,FNAME,LNAME,CUST_ID)
  49. VALUES('SUNSHINE INC.','3490 STATE ST.','SAN DIEGO','CA','92185','6194593911','SALLY',
  50. 'SMITH','10');
  51. INSERT INTO CUSTOMER (COMPANY,ADDR1,CITY,STATE,ZIP,PHONE,FNAME,LNAME,CUST_ID)
  52. VALUES('RITTER GLASS','3490 COLUMBIA ST.','FALLBROOK','CA','95655','6198329045','JOHN',
  53. 'ALBERTO','20');
  54. INSERT INTO CUSTOMER (COMPANY,ADDR1,CITY,STATE,ZIP,PHONE,FNAME,LNAME,CUST_ID)
  55. VALUES('JC OFFICE SUPPLY','3089 GOVERNOR','SAN DIEGO','CA','94001','6195552256','NOEL',
  56. 'MARTINEZ','30');
  57. INSERT INTO CUSTOMER (COMPANY,ADDR1,CITY,STATE,ZIP,PHONE,FNAME,LNAME,CUST_ID)
  58. VALUES('MCR CONSTRUCTION','107 GAMMA','SEATTLE','WA','45923','4135557812','MARK',
  59. 'ROBERTS','40');
  60. INSERT INTO CUSTOMER (COMPANY,ADDR1,CITY,STATE,ZIP,PHONE,FNAME,LNAME,CUST_ID)
  61. VALUES('KEIL FLORISTS','20 FRONT ST.','YUMA','AZ','86230','3134595555','KEIL',
  62. 'McVEE','50');
  63. INSERT INTO CUSTOMER (COMPANY,ADDR1,CITY,STATE,ZIP,PHONE,FNAME,LNAME,CUST_ID)
  64. VALUES('SASAKI INC.','45 PROSPECT','NEW YORK','NY','03488','4142003333','BRIAN',
  65. 'LEARY','60');
  66. INSERT INTO CUSTOMER (COMPANY,ADDR1,CITY,STATE,ZIP,PHONE,FNAME,LNAME,CUST_ID)
  67. VALUES('LEE ENTERPRISES','6734 JAMES','DETROIT','MI','34991','5125551239','HARVEY',
  68. 'LEE','70');
  69. INSERT INTO CUSTOMER (COMPANY,ADDR1,CITY,STATE,ZIP,PHONE,FNAME,LNAME,CUST_ID)
  70. VALUES('FLY INC.','100 AIRPLANE','LONG BEACH','CA','90451','2135601212','PAUL',
  71. 'OLSON','80');
  72.  
  73. CREATE TABLE TRANSACT(DATES DATE,PERIOD SMALLINT,QTY INT,U_PRICE INT,U_COST INT,
  74. COMMISSIONS INT,NOTE VARCHAR(250),PROD_ID CHAR(20),SP_ID CHAR(20),CUST_ID CHAR(20),
  75. ORDER_NUM CHAR(20));
  76.  
  77. CREATE TABLE INVENTORY(PART_NUM CHAR(10),PROD_NAME CHAR(25),PROD_DESC CHAR(25),
  78. U_PRICE MONEY,U_COST MONEY,FULL_DESC VARCHAR(250),INVENTORY SMALLINT);
  79. INSERT INTO INVENTORY(PART_NUM,PROD_NAME,PROD_DESC,U_PRICE,U_COST,FULL_DESC,INVENTORY)
  80. VALUES('H3400','HAYDEN','2400 MODEM',250.00,195.00,'2400 BAUD MODEM IN GOLD CASE',320);
  81. INSERT INTO INVENTORY(PART_NUM,PROD_NAME,PROD_DESC,U_PRICE,U_COST,FULL_DESC,INVENTORY)
  82. VALUES('H3401','SASEN','40 M HD',380,250,'40M MFM FULL HEIGHT HD',20);
  83. INSERT INTO INVENTORY(PART_NUM,PROD_NAME,PROD_DESC,U_PRICE,U_COST,FULL_DESC,INVENTORY)
  84. VALUES('H3402','MAXIMUM','120 M HD',820,650,'120M SCSI HALF HEIGHT HD',112);
  85. INSERT INTO INVENTORY(PART_NUM,PROD_NAME,PROD_DESC,U_PRICE,U_COST,FULL_DESC,INVENTORY)
  86. VALUES('F4501','OLSON','DESK',350,285,'OAK 48"x 72" DESK',278);
  87. INSERT INTO INVENTORY(PART_NUM,PROD_NAME,PROD_DESC,U_PRICE,U_COST,FULL_DESC,INVENTORY)
  88. VALUES('S2200','ACTION SOFTWARE','ACCOUNTING',450,325,'BEGINNER ACCOUNTING PKG.',90);
  89. INSERT INTO INVENTORY(PART_NUM,PROD_NAME,PROD_DESC,U_PRICE,U_COST,FULL_DESC,INVENTORY)
  90. VALUES('S2201','FAST SOFTWARE','SILVER UTILITIES',50,23,'UTILITIES FOR ALL HARD DRIVES',55);
  91. INSERT INTO INVENTORY(PART_NUM,PROD_NAME,PROD_DESC,U_PRICE,U_COST,FULL_DESC,INVENTORY)
  92. VALUES('H3403','MEMALL','RAM BOARD',305,210,'MEMEORY EXPANSION CARD FOR XT',96);
  93. INSERT INTO INVENTORY(PART_NUM,PROD_NAME,PROD_DESC,U_PRICE,U_COST,FULL_DESC,INVENTORY)
  94. VALUES('M5500','ROVER INC.','POWER STRIP',35,12,'5 OUTLET SURGE PROTECTOR',300);
  95. INSERT INTO INVENTORY(PART_NUM,PROD_NAME,PROD_DESC,U_PRICE,U_COST,FULL_DESC,INVENTORY)
  96. VALUES('M5501','SASAKI','CLOCK',68,55,'CLOCK THAT LOOKS LIKE A COMPUTER',25);
  97. INSERT INTO INVENTORY(PART_NUM,PROD_NAME,PROD_DESC,U_PRICE,U_COST,FULL_DESC,INVENTORY)
  98. VALUES('F4502','HANOVER','PRINTER STAND',82,45,'METAL PRINTER STAND',65);
  99.  
  100.  
  101.  
  102.