xQbPSM3L

1public class DatabaseManager {
2    public static String url = "jdbc:mysql://localhost:3306?createDatabaseIfNotExist=FALSE&useTimezone=TRUE&serverTimezone=GMT"; //Asia/Jerusalem
3    public static String username = "root";
4    public static String password = "";
5
6    private static final String CREATE_DB = "CREATE DATABASE coupon_master";
7    private static final String DROP_DB = "DROP DATABASE coupon_master";
8
9    public static final String CREATE_TABLE_CATEGORIES = "CREATE TABLE IF NOT EXISTS `coupon_master`.`categories` (`ID` int(11) NOT NULL AUTO_INCREMENT,`NAME` varchar(50) NOT NULL, PRIMARY KEY (`ID`))";
10    public static final String DROP_TABLE_CATEGORIES = "DROP TABLE IF EXISTS `coupon_master`.`categories`";
11
12    public static final String CREATE_TABLE_COMPANIES = "CREATE TABLE IF NOT EXISTS `coupon_master`.`companies` (`ID` int(11) NOT NULL AUTO_INCREMENT, `NAME` varchar(50) NOT NULL, `EMAIL` varchar(50) NOT NULL, " +
13            "`PASSWORD` varchar(50) NOT NULL, PRIMARY KEY (`ID`))";
14    public static final String DROP_TABLE_COMPANIES = "DROP TABLE IF EXISTS `coupon_master`.`companies`";
15
16    public static final String CREATE_TABLE_COUPONS = "CREATE TABLE IF NOT EXISTS `coupon_master`.`coupons` (`ID` int(11) NOT NULL AUTO_INCREMENT, `COMPANY_ID` int(11) DEFAULT NULL, `CATEGORY_ID` int(11) NOT NULL, " +
17            "`TITLE` varchar(50) NOT NULL, `DESCRIPTION` varchar(200) NOT NULL, `START_DATE` date NOT NULL, `END_DATE` date NOT NULL, " +
18            "`AMOUNT` int(11) NOT NULL,`PRICE` double NOT NULL, `IMAGE` varchar(200) NOT NULL, PRIMARY KEY (`ID`), " +
19            " FOREIGN KEY (`COMPANY_ID`) REFERENCES `companies` (`ID`) ON DELETE CASCADE, FOREIGN KEY (`CATEGORY_ID`) REFERENCES `categories` (`ID`))";
20    public static final String DROP_TABLE_COUPONS = "DROP TABLE IF EXISTS `coupon_master`.`coupons`";
21
22    public static final String CREATE_TABLE_CUSTOMERS = "CREATE TABLE IF NOT EXISTS  `coupon_master`.`customers` (`ID` int(11) NOT NULL AUTO_INCREMENT, `FIRST_NAME` varchar(50) NOT NULL,`LAST_NAME` varchar(50) NOT NULL, " +
23            "`EMAIL` varchar(50) NOT NULL, `PASSWORD` varchar(50) NOT NULL, PRIMARY KEY (`ID`))";
24    public static final String DROP_TABLE_CUSTOMERS = "DROP TABLE IF EXISTS `coupon_master`.`customers` IF EXISTS";
25
26    public static final String CREATE_TABLE_CUSTOMERS_VS_COUPONS = "CREATE TABLE IF NOT EXISTS `coupon_master`.`customers_vs_coupons` (`CUSTOMER_ID` int(11) NOT NULL, `COUPON_ID` int(11) NOT NULL, " +
27            "PRIMARY KEY (`CUSTOMER_ID`,`COUPON_ID`), FOREIGN KEY (`CUSTOMER_ID`) REFERENCES `customers` (`ID`) ON DELETE CASCADE, FOREIGN KEY (`COUPON_ID`) REFERENCES `coupons` (`ID`) ON DELETE CASCADE)";
28    public static final String DROP_TABLE_CUSTOMERS_VS_COUPONS = "DROP TABLE IF EXISTS `coupon_master`.`customers_vs_coupons`";