www.pudn.com > dangdang.zip > dangdang.sql, change:2011-07-05,size:3599b


create table lxc_product1( 
    id integer primary key,  
    product_no varchar2(12), 
    product_name varchar2(12), 
    product_price  number(12,2),  
    product_d_price  number(12,2), 
    prodcut_desc varchar2(12), 
    prodcut_date  date, 
    product_validate char(1) default 'y',  
    product_amount integer, 
    product_author varchar2(12), 
    product_publish varchar2(12), 
    product_isbn varchar2(12), 
    product_pic varchar2(12), 
    is_recommde char(1) default 'y', 
    product_buy_count integer 
); 
 
 
insert into lxc_product1( id,product_no,product_name,product_price,product_d_price,prodcut_desc,prodcut_date,product_amount,product_author,product_publish,product_isbn,product_pic,product_buy_count) 
values (1,'20010','corejava',15.5,12.5,'goodbook',sysdate,10,'suns','chinapub','1112233','1.jpg',20); 
insert into lxc_product1( id,product_no,product_name,product_price,product_d_price,prodcut_desc,prodcut_date,product_amount,product_author,product_publish,product_isbn,product_pic,product_buy_count) 
values (2,'20011','spring',14.2,13.0,'sobad',to_date('2011-6-30','yyyy-mm-dd'),20,'xiaohei','chinapub','1112333','10.jpg',19); 
insert into lxc_product1( id,product_no,product_name,product_price,product_d_price,prodcut_desc,prodcut_date,product_amount,product_author,product_publish,product_isbn,product_pic,product_buy_count) 
values (3,'20012','hibernate',16.5,15.5,'esaybook',to_date('2011-6-29','yyyy-mm-dd'),10,'dd','chinapub','1112255','11.jpg',18); 
insert into lxc_product1( id,product_no,product_name,product_price,product_d_price,prodcut_desc,prodcut_date,product_amount,product_author,product_publish,product_isbn,product_pic,product_buy_count) 
values (4,'20013','ejb',15.5,12.5,'books',to_date('2011-6-28','yyyy-mm-dd'),10,'xx','chinapub','1112323','12.jpg',17); 
insert into lxc_product1( id,product_no,product_name,product_price,product_d_price,prodcut_desc,prodcut_date,product_amount,product_author,product_publish,product_isbn,product_pic,product_buy_count) 
values (5,'20014','uml',15.5,12.5,'goodbook',to_date('2011-6-27','yyyy-mm-dd'),10,'suns','chinapub','1112233','13.jpg',16); 
insert into lxc_product1( id,product_no,product_name,product_price,product_d_price,prodcut_desc,prodcut_date,product_amount,product_author,product_publish,product_isbn,product_pic,product_buy_count) 
values (6,'20015','C#',15.5,12.5,'goodbook',to_date('2011-6-26','yyyy-mm-dd'),10,'suns','chinapub','1112233','14.jpg',15); 
insert into lxc_product1( id,product_no,product_name,product_price,product_d_price,prodcut_desc,prodcut_date,product_amount,product_author,product_publish,product_isbn,product_pic,product_buy_count) 
values (7,'20016','jsp',15.5,12.5,'goodbook',to_date('2011-6-25','yyyy-mm-dd'),10,'suns','chinapub','1112233','15.jpg',14); 
insert into lxc_product1( id,product_no,product_name,product_price,product_d_price,prodcut_desc,prodcut_date,product_amount,product_author,product_publish,product_isbn,product_pic,product_buy_count) 
values (8,'20017','asp',15.5,12.5,'goodbook',to_date('2011-6-24','yyyy-mm-dd'),10,'suns','chinapub','1112233','16.jpg',13); 
insert into lxc_product1( id,product_no,product_name,product_price,product_d_price,prodcut_desc,prodcut_date,product_amount,product_author,product_publish,product_isbn,product_pic,product_buy_count) 
values (9,'20018','php',15.5,12.5,'goodbook',to_date('2011-6-23','yyyy-mm-dd'),10,'suns','chinapub','1112233','17.jpg',14); 
 
create table lxc_order_item1( 
  id integer primary key, 
  product_id integer references lxc_product(id), 
  amount integer, 
  price number(12,2) 
);