com.jeneric.dao.User.createTable=CREATE TABLE  `jenanderic`.`user` (`id` int(11) NOT NULL AUTO_INCREMENT,`username` varchar(15) NOT NULL,`password` varchar(50) NOT NULL,`surname` varchar(30) NOT NULL,`firstname` varchar(50) NOT NULL,`middlename` varchar(30) NOT NULL,`sex` varchar(1) NOT NULL,`birthday` date NOT NULL,`email` varchar(50) NOT NULL,`landlinenumber` varchar(7) NOT NULL,`mobilenumber` varchar(11) NOT NULL,`address` varchar(150) NOT NULL,`zipcode` varchar(4) NOT NULL,`city` varchar(30) NOT NULL,`admin` tinyint(1) NOT NULL,`manager` tinyint(1) NOT NULL,`employee` tinyint(1) NOT NULL,`active` tinyint(1) NOT NULL,`datecreated` datetime NOT NULL,`dateupdated` datetime NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
com.jeneric.dao.User.deleteTable=DROP TABLE user;
com.jeneric.dao.User.insertUser=INSERT INTO user VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);
com.jeneric.dao.User.getUser=SELECT * FROM user WHERE username = ?;
com.jeneric.dao.User.editPersonalAccount=UPDATE user SET surname = ?, firstname = ?, middlename = ?, sex = ?, birthday = ?, landlinenumber = ?, mobilenumber = ?, address = ?, zipcode = ?, city = ?, dateupdated = ? WHERE username = ?;
com.jeneric.dao.User.editPassword=UPDATE user SET password = ?, dateupdated = ? WHERE username = ?;
com.jeneric.dao.User.editEmail=UPDATE user SET email = ?, dateupdated = ? WHERE username = ?;
com.jeneric.dao.Manufacturer.createTable=CREATE TABLE  `jenanderic`.`manufacturer` (`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(100) NOT NULL,`datecreated` datetime NOT NULL,`dateupdated` datetime NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;
com.jeneric.dao.Manufacturer.deleteTable=DROP TABLE manufacturer;
com.jeneric.dao.Manufacturer.insertManufacturer=INSERT INTO manufacturer VALUES (?,?,?,?);
com.jeneric.dao.Manufacturer.getAllManufacturer=SELECT * FROM manufacturer;
com.jeneric.dao.Manufacturer.getManufacturer=SELECT * FROM manufacturer WHERE id = ?;
com.jeneric.dao.Manufacturer.editManufacturer=UPDATE manufacturer SET name = ? dateupdated = ? WHERE id = ?;
com.jeneric.dao.Product.createTable=CREATE TABLE  `jenanderic`.`product` (`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(70) NOT NULL,`dosage` varchar(70) NOT NULL,`manufacturer` int(11) NOT NULL,`cost` float NOT NULL,`sellingprice` float NOT NULL,`datecreated` datetime NOT NULL,`dateupdated` datetime NOT NULL,`quantity` int(11) DEFAULT NULL,PRIMARY KEY (`id`),KEY `manufacturer` (`manufacturer`),CONSTRAINT `manufacturer` FOREIGN KEY (`manufacturer`) REFERENCES `manufacturer` (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;
com.jeneric.dao.Product.deleteTable=DROP TABLE product;
com.jeneric.dao.Product.insertProduct=INSERT INTO product VALUES (?,?,?,?,?,?,?,?,?);
com.jeneric.dao.Product.getAllProduct=SELECT * FROM product;
com.jeneric.dao.Product.getProduct=SELECT * FROM product WHERE id = ?;
com.jeneric.dao.Product.editProduct=UPDATE product SET name = ?, dosage = ?, manufacturer = ?, cost = ?, sellingprice = ?, dateupdated = ? WHERE id = ?;
com.jeneric.dao.Product.editProductQuantity=UPDATE product SET quantity = ? WHERE id = ?;
com.jeneric.dao.InventoryAudit.createTable=CREATE TABLE  `jenanderic`.`inventoryaudit` (`product` int(11) NOT NULL,`previousquantity` int(11) NOT NULL,`lastaction` varchar(10) NOT NULL,`transactionquantity` int(11) NOT NULL,`currentquantity` int(11) NOT NULL,`transactiondate` datetime NOT NULL,KEY `Product` (`product`),CONSTRAINT `Product` FOREIGN KEY (`product`) REFERENCES `product` (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Audit Trailing Purposes';
com.jeneric.dao.InventoryAudit.deleteTable=DROP TABLE inventoryaudit;
com.jeneric.dao.InventoryAudit.insertInventoryAudit=INSERT INTO inventoryaudit VALUES (?,?,?,?,?,?);
com.jeneric.dao.InventoryAudit.getInventoryAudit=SELECT * FROM inventoryaudit WHERE product = ?;
com.jeneric.dao.Sales.createTable=CREATE TABLE  `jenanderic`.`sales` (`product` int(11) NOT NULL,`previousquantity` int(11) NOT NULL,`lastaction` varchar(10) NOT NULL,`transactionquantity` int(11) NOT NULL,`currentquantity` int(11) NOT NULL,`transactiondate` datetime NOT NULL,KEY `Product` (`product`),CONSTRAINT `Product` FOREIGN KEY (`product`) REFERENCES `product` (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Audit Trailing Purposes';
com.jeneric.dao.Sales.deleteTable=DROP TABLE sales;
com.jeneric.dao.Sales.insertSales=INSERT INTO sales VALUES (?,?,?,?,?,?,?);
com.jeneric.dao.Sales.getSales=SELECT * FROM sales WHERE product = ?;
com.jeneric.dao.Sales.getSellingprice=SELECT sellingprice FROM product WHERE id = ?;