pointbase.createproducts.sql

来自「为大家提供了《精通EJB》（第三版)一书的源代码」· SQL 代码 · 共 19 行

drop table PRODUCTS;

create table PRODUCTS (
        productId varchar(64), 
        name varchar(64), 
        basePrice numeric(18), 
        description varchar(64),
        CONSTRAINT PK_PRODUCTS PRIMARY KEY (productId)
);


insert into PRODUCTS values ('1', 'Pentium III', 2000, 'Intel brand, 256k Level2 cache');
insert into PRODUCTS values ('2', 'Celeron', 800, 'Low-end mainstream machine');
insert into PRODUCTS values ('3', 'Pentium I', 500, 'Refurbished machine');
insert into PRODUCTS values ('4', 'Mac', 2500, 'Color iMac');
insert into PRODUCTS values ('5', 'Pentium II', 500, 'Mid-level machine');
insert into PRODUCTS values ('6', 'Athlon', 3500, 'AMD Flagship');