insert into online.Member
   (MID, PID, NAME, BIRTHDAY, PHONE, ADDRESS, EMAIL)
 Values
   ('b0922468', 'R100200300', 'Jackson', '1980-03-30', '06-3210321', '台南縣中華路600號', 'jack99@ms9.hinet.net');
Insert into online.Member
   (MID, PID, NAME, BIRTHDAY, PHONE, ADDRESS, EMAIL)
 Values
   ('b0905555', 'C200456789', 'Jennifer', '1974-03-04', '07-2221111', '高雄市五福三路300號', 'jen33@ms3.hinet.net');
Insert into online.Member
   (MID, PID, NAME, BIRTHDAY, PHONE, ADDRESS, EMAIL, INTRODUCER)
 Values
   ('a0910001', 'A220123456', 'Jenny', '1979-01-01', '02-2222001', '台北市中山北路100號', 'jenny@ms1.hinet.net', 'b0905555');
Insert into online.Member
   (MID, PID, NAME, BIRTHDAY, PHONE, ADDRESS, EMAIL, INTRODUCER)
 Values
   ('c0927777', 'B123123123', 'Su', '1982-06-06', '07-2345678', '高雄市蓮海路70號', 'su88@ms2.hinet.net', 'b0905555');
Insert into online.Member
   (MID, PID, NAME, BIRTHDAY, PHONE, ADDRESS, EMAIL, INTRODUCER)
 Values
   ('a0911234', 'A12255888', 'Tony', '1980-12-12', '02-2288009', '台北市羅斯福路200號', 'tony@ms1.hinet.net', 'a0910001');
Insert into online.Member
   (MID, PID, NAME, BIRTHDAY, PHONE, ADDRESS, EMAIL, INTRODUCER)
 Values
   ('a0921111', 'A100999777', 'David', '1975-11-22', '04-2468888', '台中市中港路200號', 'david@ms1.hinet.net', 'a0911234');

Insert into online.Product
   (PNO, PNAME, UNITPRICE, CATALOG)
 Values
   ('v00111', '英雄', 400, 'VCD');
Insert into online.Product
   (PNO, PNAME, UNITPRICE, CATALOG)
 Values
   ('b51111', '電子商務理論與實務', 700, 'Book');
Insert into online.Product
   (PNO, PNAME, UNITPRICE, CATALOG)
 Values
   ('d03333', '5566專輯', 450, 'CD');
Insert into online.Product
   (PNO, PNAME, UNITPRICE, CATALOG)
 Values
   ('v01888', '哈利波特-消失的密室', 450, 'VCD');
Insert into online.Product
   (PNO, PNAME, UNITPRICE, CATALOG)
 Values
   ('d20777', '蔡依林專輯二', 350, 'CD');
Insert into online.Product
   (PNO, PNAME, UNITPRICE, CATALOG)
 Values
   ('b40555', '系統分析理論與實務', 550, 'Book');
Insert into online.Product
   (PNO, PNAME, UNITPRICE, CATALOG)
 Values
   ('b10234', 'MIS', 600, 'Book');
Insert into online.Product
   (PNO, PNAME, UNITPRICE, CATALOG)
 Values
   ('b20666', 'SQL_OLAP', 500, 'Book');
Insert into online.Product
   (PNO, PNAME, UNITPRICE, CATALOG)
 Values
   ('d11222', '任賢齊專輯三', 300, 'CD');
Insert into online.Product
   (PNO, PNAME, UNITPRICE)
 Values
   ('b30999', '資料庫理論與實務', 500);

Insert into online.Author
   (PNO, NAME)
 Values
   ('b30999', 'Hwang');
Insert into online.Author
   (PNO, NAME)
 Values
   ('b10234', 'Lin');
Insert into online.Author
   (PNO, NAME)
 Values
   ('d11222', 'William');
Insert into online.Author
   (PNO, NAME)
 Values
   ('b20666', 'Sandra');
Insert into online.Author
   (PNO, NAME)
 Values
   ('b40555', 'Wu');
Insert into online.Author
   (PNO, NAME)
 Values
   ('d20777', 'Jolin');
Insert into online.Author
   (PNO, NAME)
 Values
   ('v01888', 'J.K.');
Insert into online.Author
   (PNO, NAME)
 Values
   ('b51111', 'Lai');
Insert into online.Author
   (PNO, NAME)
 Values
   ('b51111', 'Hwang');
Insert into online.Author
   (PNO, NAME)
 Values
   ('b51111', 'Lin');
Insert into online.Author
   (PNO, NAME)
 Values
   ('d03333', 'Jackey');
Insert into online.Author
   (PNO, NAME)
 Values
   ('d03333', 'David');
Insert into online.Author
   (PNO, NAME)
 Values
   ('d03333', 'Tom');
Insert into online.Author
   (PNO, NAME)
 Values
   ('d03333', 'Eric');
Insert into online.Author
   (PNO, NAME)
 Values
   ('v00111', 'Lee');

Insert into online.Browse
   (MID, PNO, BrowseTIME)
 Values
   ('a0910001', 'b40555', '2005-09-09-10.00.00.000000');
Insert into online.Browse
   (MID, PNO, BrowseTIME)
 Values
   ('b0922468', 'b40555', '2005-11-10-12.00.30.000000');
Insert into online.Browse
   (MID, PNO, BrowseTIME)
 Values
   ('b0922468', 'b10234', '2005-11-01-22.00.00.000000');
Insert into online.Browse
   (MID, PNO, BrowseTIME)
 Values
   ('c0927777', 'v00111', '2005-10-10-21.50.00.000000');
Insert into online.Browse
   (MID, PNO, BrowseTIME)
 Values
   ('c0927777', 'd20777', '2005-10-10-21.40.00.000000');;
Insert into online.Browse
   (MID, PNO, BrowseTIME)
 Values
   ('c0927777', 'd11222', '2005-10-10-21.30.30.000000');
Insert into online.Browse
   (MID, PNO, BrowseTIME)
 Values
   ('b0905555', 'v01888', '2005-05-05-11.40.30.000000');
Insert into online.Browse
   (MID, PNO, BrowseTIME)
 Values
   ('a0911234', 'b20666', '2005-02-02-17.50.00.000000');
Insert into online.Browse
   (MID, PNO, BrowseTIME)
 Values
   ('a0911234', 'b30999', '2005-02-02-17.30.00.000000');

Insert into online.Cart
   (MID, CARTTIME)
 Values
   ('a0910001', '2005-09-09-10.00.10.000000');
Insert into online.Cart
   (MID, CARTTIME, TNO)
 Values
   ('b0922468', '2005-11-11-09.00.30.000000', '92555');
Insert into online.Cart
   (MID, CARTTIME, TNO)
 Values
   ('a0911234', '2005-02-02-18.00.30.000000', '91100');
Insert into online.Cart
   (MID, CARTTIME, TNO)
 Values
   ('b0905555', '2005-05-05-12.00.00.000000', '90111');
Insert into online.Cart
   (MID, CARTTIME, TNO)
 Values
   ('c0927777', '2005-10-10-22.00.00.000000', '92666');

Insert into online.Transaction
   (TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
 Values
   ('91100', 'a0911234', '2005-02-02-18.30.00.000000','cart', '010', 'tb', 'visa', '987654321', '2005-01-01');
Insert into online.Transaction
   (TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
 Values
   ('92666', 'c0927777', '2003-10-10-22.10.30.000000', 'cart', '020', 'fb', 'visa', '123456789', '2006-12-31');
Insert into online.Transaction
   (TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
 Values
   ('91888', 'a0910001', '2005-09-10-10.10.00.000000', 'fax', '040', 'cb', 'master', '777788888', '2007-10-10');
Insert into online.Transaction
   (TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
 Values
   ('92333', 'c0927777', '2005-10-15-09.00.00.000000', 'email',' 070', 'sb', 'visa', '111122222', '2007-12-31');
Insert into online.Transaction
   (TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
 Values
   ('90111', 'b0905555', '2005-05-05-12.30.30.000000', 'cart', '020', 'fb', 'master', '444455555', '2006-01-01');
Insert into online.Transaction
   (TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
 Values
   ('92555', 'b0922468', '2005-11-11-09.10.00.000000', 'cart', '010', 'tb', 'visa', '333300000', '2007-01-01');

Insert into online.order
   (PNO, MID, CARTTIME, AMOUNT)
 Values
   ('d11222', 'a0910001', '2005-09-09-10.00.10.000000', 1);
Insert into online.order
   (PNO, MID, CARTTIME, AMOUNT)
 Values
   ('b40555', 'b0922468', '2005-11-11-09.00.30.000000', 10);
Insert into online.order
   (PNO, MID, CARTTIME, AMOUNT)
 Values
   ('b10234', 'b0922468', '2005-11-11-09.00.30.000000', 5);
Insert into online.order
   (PNO, MID, CARTTIME, AMOUNT)
 Values
   ('v00111', 'c0927777', '2005-10-10-22.00.00.000000', 2);
Insert into online.order
   (PNO, MID, CARTTIME, AMOUNT)
 Values
   ('d20777', 'c0927777', '2005-10-10-22.00.00.000000', 1);
Insert into online.order
   (PNO, MID, CARTTIME, AMOUNT)
 Values
   ('d11222', 'c0927777', '2005-10-10-22.00.00.000000', 1);
Insert into online.order
   (PNO, MID, CARTTIME, AMOUNT)
 Values
   ('v01888', 'b0905555', '2005-05-05-12.00.00.000000', 3);
Insert into online.order
   (PNO, MID, CARTTIME, AMOUNT)
 Values
   ('b30999', 'a0911234', '2005-02-02-18.00.30.000000', 1);

Insert into online.Record
   (TNO, PNO, SALEPRICE, AMOUNT)
 Values
   ('92333', 'b51111', 700, 1);
Insert into online.Record
   (TNO, PNO, SALEPRICE, AMOUNT)
 Values
   ('92666', 'v00111', 800, 2);
Insert into online.Record
   (TNO, PNO, SALEPRICE, AMOUNT)
 Values
   ('92666', 'd20777', 350, 1);
Insert into online.Record
   (TNO, PNO, SALEPRICE, AMOUNT)
 Values
   ('92666', 'd11222', 300, 1);
Insert into online.Record
   (TNO, PNO, SALEPRICE, AMOUNT)
 Values
   ('91888', 'd03333', 850, 2);
Insert into online.Record
   (TNO, PNO, SALEPRICE, AMOUNT)
 Values
   ('91888', 'b40555', 1650, 3);
Insert into online.Record
   (TNO, PNO, SALEPRICE, AMOUNT)
 Values
   ('92555', 'b40555', 5000, 10);
Insert into online.Record
   (TNO, PNO, SALEPRICE, AMOUNT)
 Values
   ('92555', 'b10234', 3000, 5);
Insert into online.Record
   (TNO, PNO, SALEPRICE, AMOUNT)
 Values
   ('90111', 'v01888', 1350, 3);
Insert into online.Record
   (TNO, PNO, SALEPRICE, AMOUNT)
 Values
   ('91100', 'b30999', 450, 1);
COMMIT;