DROP TABLE COMPOSITE_CUSTOMER;

create table "COMPOSITE_CUSTOMER"
(
	"FIRST_NAME" VARCHAR(30) not nulL,
	"LAST_NAME" VARCHAR(30) not null,
	"ADDR_LN1" VARCHAR(30) default 'NULL',
	"ADDR_LN2" VARCHAR(30) default 'NULL',
	"CITY" VARCHAR(25) default 'NULL',
	"STATE" CHAR(2) default 'NULL',
	"ZIP" VARCHAR(10) not null,
	"PHONE" CHAR(12) default 'NULL',
	"FAX" CHAR(12) default 'NULL',
	"EMAIL" VARCHAR(40) default 'NULL',
        CONSTRAINT FK_DISCOUNT_CODE1 PRIMARY KEY (FIRST_NAME, LAST_NAME)
);

INSERT INTO COMPOSITE_CUSTOMER VALUES (
'Brian',    'Leonard',	'490 Rivera Drive',	'Suite 678',	'Miami',    'FL',   '33015', '305-777-4632',    '305-777-4635',	'supercom@aol.com');
INSERT INTO COMPOSITE_CUSTOMER VALUES (
'Gregg',    'Sporar',	'9754 Main Street',	'P.O. Box 567',	'Miami',    'FL',   '33055', '305-456-8888',	'305-456-8889',	'www.tsoftt.com');
INSERT INTO COMPOSITE_CUSTOMER VALUES (
'Tim',      'Bourdrea',	'8989 Qume Drive',	'Suite 9897',	'Dallas',   'TX',   '75200', '214-999-1234',	'214-999-5432',	'www.oakc.com');