/******************************************************
 * Table: Product
 *    create Product table into the database
 *
 ******************************************************/
CREATE TABLE Products (
	ProductId INTEGER 	NOT NULL AUTO_INCREMENT,
	ProductName		CHAR(100),
	Description		CHAR(200),
	Price			DOUBLE,
	
	PRIMARY KEY (ProductId)
);  	


/* insert some data into Products table */
INSERT INTO Products (ProductName, Price)
VALUES ('HP Desktop', 1000);

INSERT INTO Products (ProductName, Price)
VALUES ('Sony Laptop', 1800);

INSERT INTO Products (ProductName, Price)
VALUES ('Cisco Router', 200);

INSERT INTO Products (ProductName, Price)
VALUES ('ATI Video Card', 300);