customers.sql

来自「此程序都是企业级 的数据库开发程序 全面揭示了JAVA对数据库的操作」· SQL 代码 · 共 30 行

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','[e-mail]','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','[e-mail]','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','[e-mail]','javaqueen','my nickname from Jim');