CREATE TABLE DWMA08.AUTHOR
(AU_SSN CHAR(09) NOT
NULL,
AU_LNAME VARCHAR(40) NOT
NULL,
AU_FNAME VARCHAR(20) NOT
NULL,
PHONE CHAR(12) NOT
NULL,
ADDRESS VARCHAR(12),
CITY VARCHAR(20),
STATE CHAR(02),
COUNTRY VARCHAR(12),
POSTALCODE CHAR(14),
BIRTHDATE DATE,
NUM_UPDATES SMALLINT,
ORIG_INSERT TIMESTAMP,
LAST_UPDATE TIMESTAMP
IN DATABASE DWMDBAS;
COMMIT;