| CREATE TABLE trafodion.sales.parts |
| ( partnum NUMERIC (4) UNSIGNED NO DEFAULT NOT NULL |
| , partdesc CHARACTER (18) NO DEFAULT NOT NULL |
| , price NUMERIC (8, 2) NO DEFAULT NOT NULL |
| , qty_available NUMERIC (5) DEFAULT 0 NOT NULL |
| , PRIMARY KEY ( partnum ) |
| ) ; |
| |
| CREATE INDEX xpartdes ON parts |
| ( partdesc |
| ) ; |
| |
| INSERT INTO trafodion.sales.parts VALUES |
| ( 186, '186 MegaByte Disk', 186186.86, 186 ) |
| , ( 212, 'PC SILVER, 20 MB', 2500.00, 3525 ) |
| , ( 244, 'PC GOLD, 30 MB', 3000.00, 4426 ) |
| , ( 255, 'PC DIAMOND, 60 MB', 4000.00, 3321 ) |
| , ( 2001, 'GRAPHIC PRINTER,M1', 1100.00, 2100 ) |
| , ( 2002, 'GRAPHIC PRINTER,M2', 1500.00, 3220 ) |
| , ( 2003, 'GRAPHIC PRINTER,M3', 2000.00, 2200 ) |
| , ( 2402, 'DAISY PRINTER,T1', 350.00, 4425 ) |
| , ( 2403, 'DAISY PRINTER,T2', 650.00, 3312 ) |
| , ( 2405, 'DAISY PRINTER, T3', 795.00, 2712 ) |
| , ( 3103, 'LASER PRINTER, X1', 4200.00, 3300 ) |
| , ( 3201, 'HARD DISK 20 MB', 525.00, 4436 ) |
| , ( 3205, 'HARD DISK 30 MB', 625.00, 2209 ) |
| , ( 3210, 'HARD DISK 40 MB', 715.00, 3314 ) |
| , ( 4102, 'DISKETTE HD, BOX', 28.00, 6540 ) |
| , ( 5100, 'MONITOR BW, TYPE 1', 150.00, 3237 ) |
| , ( 5101, 'MONITOR BW, TYPE 2', 200.00, 2400 ) |
| , ( 5103, 'MONITOR COLOR, M1', 400.00, 3328 ) |
| , ( 5110, 'MONITOR COLOR, M2', 525.00, 3236 ) |
| , ( 5504, 'MEMORY CARD, 512KB', 165.00, 2630 ) |
| , ( 5505, 'MEMORY CARD, 1 MB', 315.00, 3830 ) |
| , ( 6201, 'GRAPHIC CARD, LR', 195.00, 2306 ) |
| , ( 6301, 'GRAPHIC CARD, HR', 245.00, 2331 ) |
| , ( 6400, 'STREAMING TAPE,M20', 550.00, 1268 ) |
| , ( 6401, 'STREAMING TAPE,M60', 725.00, 1308 ) |
| , ( 6500, 'DISK CONTROLLER', 95.00, 2532 ) |
| , ( 6603, 'PRINTER CONTROLLER', 45.00, 430 ) |
| , ( 7102, 'SMART MODEM, 1200', 275.00, 2200 ) |
| , ( 7301, 'SMART MODEM, 2400', 425.00, 2332 ) |
| ; |
| |
| UPDATE STATISTICS FOR TABLE trafodion.sales.parts ON EVERY COLUMN ; |