· 6 years ago · Sep 25, 2019, 02:34 PM
1CREATE TABLE IF NOT EXISTS `Salary` (
2 `Employee_ID` VARCHAR NOT NULL ,
3 `Main_Salary` INT ,
4 `Accommodation_Expenditure` INT ,
5 `Consumption_Expenditure` INT ,
6 `Bonus` INT ,
7 `Wage_Cut` INT ,
8 PRIMARY KEY (`Employee_ID`) )
9ENGINE = InnoDB;