create table product_tbl(INT(25) ID AUTO_INCREMENT, VARCHAR(25) pCODE DEFAULT "NONE", VARCHAR(25) pDesc DEFAULT 'NONE'
, DOUBLE(11,2) price DEFAULT 0.00, ENUM status('ACTIVE','INACTIVE'),DATE expiration DEFAULT 0000-00-00);


create table product_tbl(pID INT(25) NOT NULL AUTO_INCREMENT PRIMARY KEY, pCode VARCHAR(25) DEFAULT '0xNONE',
pDesc VARCHAR(25) DEFAULT '0xNONE',price DOUBLE(11,2) DEFAULT 0.00, status ENUM('ACTIVE','INACTIVE') DEFAULT 'ACTIVE',expiration DATE DEFAULT '0000-00-00');

create table tbl_user(uID INT(25) NOT NULL AUTO_INCREMENT PRIMARY KEY, fName VARCHAR(25) DEFAULT '0xNONE',
lName VARCHAR(25) DEFAULT '0xNONE',email VARCHAR(50) DEFAULT '0xNONE', birthday DATE DEFAULT '0000-00-00',uLevel INT(4) DEFAULT 0, status ENUM('ACTIVE','INACTIVE') DEFAULT 'ACTIVE');