INSERT INTO CATEGORIES (NAME,DESCRIPTION) VALUES ('TIVI','ALL TELEVISION TYPE');
INSERT INTO CATEGORIES (NAME,DESCRIPTION) VALUES ('RADIO','ALL RADIO TYPE');
INSERT INTO CATEGORIES (NAME,DESCRIPTION) VALUES ('MOBIPHONE','ALL MOBIPHONE TYPE');
INSERT INTO CATEGORIES (NAME,DESCRIPTION) VALUES ('COMPUTER','ALL COMPUTER TYPE');
INSERT INTO CATEGORIES (NAME,DESCRIPTION) VALUES ('LAPTOP','ALL LAPTOP TYPE');

INSERT INTO PRODUCTS (NAME, PRICE,CATID,ISHOT) VALUES ('SONY BRAVIA',10000000,1,0);
INSERT INTO PRODUCTS (NAME, PRICE,CATID,ISHOT) VALUES ('SAMSUNG TV',12000000,1,0);
INSERT INTO PRODUCTS (NAME, PRICE,CATID,ISHOT) VALUES ('SONY',5000000,2,0);
INSERT INTO PRODUCTS (NAME, PRICE,CATID,ISHOT) VALUES ('HITACHI',5000000,2,0);
INSERT INTO PRODUCTS (NAME, PRICE,CATID,ISHOT) VALUES ('APPLE IPHONE',20000000,3,0);
INSERT INTO PRODUCTS (NAME, PRICE,CATID,ISHOT) VALUES ('SAMSUNG GALAXY NOTE',20000000,3,0);
INSERT INTO PRODUCTS (NAME, PRICE,CATID,ISHOT) VALUES ('DELL PRESARIO',25000000,4,0);
INSERT INTO PRODUCTS (NAME, PRICE,CATID,ISHOT) VALUES ('APPLE IMAC PRO',50000000,4,0);
INSERT INTO PRODUCTS (NAME, PRICE,CATID,ISHOT) VALUES ('APPLE MACBOOK PRO',40000000,5,0);
INSERT INTO PRODUCTS (NAME, PRICE,CATID,ISHOT) VALUES ('ASUS ZENBOOK',25000000,5,0);

INSERT INTO CUSTOMERS (NAME, PHONE, ADDRESS, CREATEDAT) VALUES ('CUSTOMER 1', '0966554433', '11 TRÀNG TIỀN', '1/4/2023')
INSERT INTO CUSTOMERS (NAME, PHONE, ADDRESS, CREATEDAT) VALUES ('CUSTOMER 2', '0966554433', '22 TRÀNG TIỀN', '1/5/2023')
INSERT INTO CUSTOMERS (NAME, PHONE, ADDRESS, CREATEDAT) VALUES ('CUSTOMER 3', '0966554433', '33 TRÀNG TIỀN', '1/6/2023')
INSERT INTO CUSTOMERS (NAME, PHONE, ADDRESS, CREATEDAT) VALUES ('CUSTOMER 4', '0966554433', '44 TRÀNG TIỀN', '1/6/2023')
INSERT INTO CUSTOMERS (NAME, PHONE, ADDRESS, CREATEDAT) VALUES ('CUSTOMER 5', '0966554433', '55 TRÀNG TIỀN', '1/6/2023')
INSERT INTO CUSTOMERS (NAME, PHONE, ADDRESS, CREATEDAT) VALUES ('CUSTOMER 6', '0966554433', '66 TRÀNG TIỀN', '1/6/2023')
INSERT INTO CUSTOMERS (NAME, PHONE, ADDRESS, CREATEDAT) VALUES ('CUSTOMER 7', '0966554433', '77 TRÀNG TIỀN', '1/6/2023')
INSERT INTO CUSTOMERS (NAME, PHONE, ADDRESS, CREATEDAT) VALUES ('CUSTOMER 8', '0966554433', '88 TRÀNG TIỀN', '1/6/2023')
INSERT INTO CUSTOMERS (NAME, PHONE, ADDRESS, CREATEDAT) VALUES ('CUSTOMER 9', '0966554433', '99 TRÀNG TIỀN', '1/6/2023')
INSERT INTO CUSTOMERS (NAME, PHONE, ADDRESS, CREATEDAT) VALUES ('CUSTOMER 10', '0966554433', '10 TRÀNG TIỀN', '1/6/2023')
INSERT INTO CUSTOMERS (NAME, PHONE, ADDRESS, CREATEDAT) VALUES ('CUSTOMER 11', '0966554433', '11 TRÀNG TIỀN', '1/6/2023')
INSERT INTO CUSTOMERS (NAME, PHONE, ADDRESS, CREATEDAT) VALUES ('CUSTOMER 12', '0966554433', '12 TRÀNG TIỀN', '1/6/2023')
INSERT INTO CUSTOMERS (NAME, PHONE, ADDRESS, CREATEDAT) VALUES ('CUSTOMER 13', '0966554433', '13 TRÀNG TIỀN', '1/6/2023')
INSERT INTO CUSTOMERS (NAME, PHONE, ADDRESS, CREATEDAT) VALUES ('CUSTOMER 14', '0966554431', '14 TRÀNG TIỀN', '1/6/2023')

INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (1, 50000000, 1, '1/4/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (1, 45000000, 1, '1/4/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (2, 50000000, 1, '6/1/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (2, 45000000, 1, '6/15/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (3, 50000000, 1, '6/1/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (3, 45000000, 1, '6/15/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (4, 50000000, 1, '6/1/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (4, 45000000, 1, '6/15/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (5, 50000000, 1, '6/1/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (5, 45000000, 1, '6/15/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (6, 50000000, 1, '6/1/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (6, 45000000, 1, '6/15/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (7, 50000000, 1, '6/1/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (7, 45000000, 1, '6/15/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (8, 50000000, 1, '6/1/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (8, 45000000, 1, '6/15/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (9, 50000000, 1, '6/1/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (9, 45000000, 1, '6/15/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (10, 50000000, 1, '6/1/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (10, 45000000, 1, '6/15/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (11, 50000000, 1, '6/1/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (11, 45000000, 1, '6/15/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (12, 50000000, 1, '6/1/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (12, 45000000, 1, '6/15/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (13, 50000000, 1, '6/1/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (13, 45000000, 1, '6/15/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (14, 50000000, 1, '6/1/2023')
INSERT INTO ORDERS (CUSID, AMOUNT, STATUS, CREATEDAT) VALUES (14, 45000000, 1, '6/15/2023')

INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (1, 1, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (2, 2, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (3, 3, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (4, 4, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (5, 5, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (6, 6, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (7, 7, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (8, 8, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (9, 9, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (10, 10, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (11, 1, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (12, 2, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (13, 3, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (14, 4, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (15, 5, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (16, 6, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (17, 7, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (18, 8, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (19, 9, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (20, 10, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (21, 1, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (22, 2, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (23, 3, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (24, 4, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (25, 5, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (26, 6, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (27, 7, 1, 10000000, 50)
INSERT INTO ORDERS_DETAIL (ORDERID, PROID, QUANTITY, PRICE, DISCOUNT) VALUES (28, 8, 1, 10000000, 50)