DROP TABLE CUSTOMERS;
CREATE TABLE CUSTOMERS
(
CUSTOMERID NUMBER(10) NOT NULL,
CUSTOMERTYPEID NUMBER(10) NOT NULL ,
CUSTOMERFIRSTNAME VARCHAR(25),
CUSTOMERLASTNAME VARCHAR(30),
CUSTOMERTITLEID NUMBER(10),
CUSTOMERADDRESS1 VARCHAR(50),
CUSTOMERADDRESS2 VARCHAR(50),
CUSTOMERCITY VARCHAR(30),
CUSTOMERPOSTALCODE VARCHAR(12),
PAYMENTTERMSID NUMBER(10) NOT NULL ,
CREDITLIMIT NUMBER(10,2),
CREDITCARDHOLDER VARCHAR(50),
CREDITCARDNUMBER VARCHAR(20),
CREDITCARTYPEID NUMBER(10),
CREDITCARDEXPIRYMONTH NUMBER(10),
CREDITCARDEXPIRYYEAR NUMBER(10),
EMAILADDRESS VARCHAR(50),
PASSWORD VARCHAR(15),
PASSWORDREMINDERTEXT VARCHAR(25)
);
INSERT INTO CUSTOMERS VALUES('1000','1','Catherine','Crean','3','1509 Michigan Avenu','Waukesha','Shelton','90232','1','0.0',null,null,null,null,null,null,null,null);
INSERT INTO CUSTOMERS VALUES('1001','1','Steve','Davis','1','567 Captains Bluff','Unit 4C','West Haven','10022','1','0.0','STEPHEN DAVIS','3299-87-9887','1','10','2003','sdavis@somecorp.com','rabbit','bunny');
INSERT INTO CUSTOMERS VALUES('1002','2','Villiage DJ',null,null,'125 Stanford Road','5345','Trumbull','92121','2','500.0','VILLIAGE DJ LLC','5664-655-987-87','2','12','2002','villiagedj@mail.com','werock','what we do');
INSERT INTO CUSTOMERS VALUES('1003','1','Diane ','Asmus','3','324 White Street','','Shelton','06602','1','0.0','DIANE ASMUS','3299-54-5442','1','2','2002','ladyfingers@fem.com','javaqueen','my nickname from Jim');
