home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Delphi Programming Unleashed
/
Delphi_Programming_Unleashed_SAMS_Publishing_1995.iso
/
chap18
/
sample1.sql
Wrap
Text File
|
1995-03-20
|
2KB
|
69 lines
/* CREATE DATABASE "nellie:c:\data\sample1.gdb" PAGE_SIZE 1024 */
/* Table: CUSTOMER, Owner: SYSDBA */
CREATE TABLE CUSTOMER (CUST_NUMBER INTEGER NOT NULL,
FIRST_NAME CHAR(20),
LAST_NAME CHAR(20),
ADDRESS CHAR(40),
CITY CHAR(20),
STATE CHAR(2),
ZIP CHAR(9),
PHONE CHAR(10),
PRIMARY KEY (CUST_NUMBER));
/* Table: DETAIL, Owner: SYSDBA */
CREATE TABLE DETAIL (ORDER_NUMBER INTEGER NOT NULL,
CUST_NUMBER INTEGER NOT NULL,
ITEM_NUMBER INTEGER NOT NULL,
WH_NUMBER INTEGER NOT NULL,
QTY INTEGER,
PRIMARY KEY (ORDER_NUMBER, CUST_NUMBER,
ITEM_NUMBER, WH_NUMBER));
/* Table: ITEMS, Owner: SYSDBA */
CREATE TABLE ITEMS (ITEM_NUMBER INTEGER NOT NULL,
WH_NUMBER INTEGER NOT NULL,
ITEM_DESCRIPTION CHAR(50),
ITEM_PRICE FLOAT,
PRIMARY KEY (ITEM_NUMBER, WH_NUMBER));
/* Table: ORDERS, Owner: SYSDBA */
CREATE TABLE ORDERS (ORDER_NUMBER INTEGER NOT NULL,
CUST_NUMBER INTEGER NOT NULL,
ORDER_DATE DATE,
ORDER_TIME INTEGER,
PRIMARY KEY (ORDER_NUMBER, CUST_NUMBER));
/* Table: TAX, Owner: SYSDBA */
CREATE TABLE TAX (STATE_CODE CHAR(2) NOT NULL,
TAX_RATE FLOAT,
PRIMARY KEY (STATE_CODE));
/* Table: WAREHOUSE, Owner: SYSDBA */
CREATE TABLE WAREHOUSE (WH_NUMBER INTEGER NOT NULL,
WH_DESCRIPTION CHAR(80),
WH_LOCATION CHAR(15),
PRIMARY KEY (WH_NUMBER));
ALTER TABLE DETAIL ADD FOREIGN KEY (ITEM_NUMBER,
WH_NUMBER) REFERENCES ITEMS(ITEM_NUMBER,
WH_NUMBER);
ALTER TABLE DETAIL ADD FOREIGN KEY (ORDER_NUMBER,
CUST_NUMBER) REFERENCES ORDERS(ORDER_NUMBER,
CUST_NUMBER);
/* Grant permissions for this database */
GRANT DELETE, INSERT, SELECT,
UPDATE ON CUSTOMER TO PUBLIC;
GRANT DELETE, INSERT, SELECT,
UPDATE ON DETAIL TO PUBLIC;
GRANT DELETE, INSERT, SELECT,
UPDATE ON ITEMS TO PUBLIC;
GRANT DELETE, INSERT, SELECT,
UPDATE ON ORDERS TO PUBLIC;
GRANT DELETE, INSERT, SELECT,
UPDATE ON TAX TO PUBLIC;
GRANT DELETE, INSERT, SELECT,
UPDATE ON WAREHOUSE TO PUBLIC;