home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The C Users' Group Library 1994 August
/
wc-cdrom-cusersgrouplibrary-1994-08.iso
/
listings
/
v_02_09
/
2n09058b
< prev
next >
Wrap
Text File
|
1991-08-01
|
348b
|
17 lines
CREATE TABLE UpdateList
(reg# INTEGER NOT NULL,
outlet# INTEGER NOT NULL,
name CHAR (20) NOT NULL,
street CHAR (20) NOT NULL,
city CHAR (10) NOT NULL,
state CHAR (2) NOT NULL,
zip CHAR (5) NOT NULL,
action CHAR (1) CHECK (action IN ("A", "D", "B", "C"))
UNIQUE (reg#, outlet#, name, street, city, state, zip,
action));