Forgot that the vi edits while in psql didn't get into the buffer,
minor changes to address. corrected script below.
jeff smith
create table address (
addressid SERIAL,
firstline VARCHAR(25),
SecondLine VARCHAR(25),
City VARCHAR(25),
STATE CHAR(2),
Zip5 DECIMAL(5,0),
Zip4 DECIMAL(4,0))
\g
create table person (
PersonID SERIAL,
FName VARCHAR(25),
MInitial CHAR(1),
LName VARCHAR(25),
Email VARCHAR(30),
Company INTEGER)
\g
create table company (
CompanyID SERIAL,
Name VARCHAR(30),
Address INTEGER,
Contact INTEGER)
\g
create table comments (
commentid SERIAL,
commentdate DATE,
person INTEGER NOT NULL,
comment TEXT)
\g
create table used_langs (
usedlangsid SERIAL,
c_cpp BOOLEAN,
java BOOLEAN,
sql BOOLEAN,
vb BOOLEAN,
html BOOLEAN)
\e
create table used_opsys (
usedopsysid SERIAL,
person INTEGER NOT NULL,
commentdate DATE,
win95 BOOLEAN,
winnt BOOLEAN,
mac BOOLEAN,
netware BOOLEAN,
linux BOOLEAN)
\g
create table attraction (
attractionid SERIAL,
person INTEGER NOT NULL,
commentdate DATE,
cost BOOLEAN,
stability BOOLEAN,
security BOOLEAN,
performance BOOLEAN,
managecosts BOOLEAN,
interop BOOLEAN,
source BOOLEAN)
\g
create table interest (
interestid SERIAL,
person INTEGER NOT NULL,
commentdate DATE,
wordproc CHAR(1)
xsheet CHAR(1),
dbfront CHAR(1),
account CHAR(1),
desktop CHAR(1),
lanserver CHAR(1),
inetserver CHAR(1),
email CHAR(1),
groupware CHAR(1),
dbserver CHAR(1),
inetproxy CHAR(1)
sdplatform CHAR(1),
target CHAR(1),
embed CHAR(1))
\g
