db.migration.V1__create-tables.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of burger-promo Show documentation

Burger promotion backend apis

The newest version!

CREATE TABLE IF NOT EXISTS promo(
    id VARCHAR(255) PRIMARY KEY,
    allowed_claims_total INT,
    allowed_claims_per_account INT,
    claims INT
) ENGINE=InnoDB;

CREATE TABLE IF NOT EXISTS account(
   	id VARCHAR(255) PRIMARY KEY
) ENGINE=InnoDB;

CREATE TABLE IF NOT EXISTS promo_claim(
   	claim_number int PRIMARY KEY AUTO_INCREMENT,
   	promo_id VARCHAR(255),
	FOREIGN KEY(promo_id)
        REFERENCES promo(id)
        ON DELETE CASCADE
) ENGINE=InnoDB;

CREATE INDEX promo_claim_promo_id_index ON promo_claim(promo_id);

CREATE TABLE IF NOT EXISTS account_claim(
   	promo_id VARCHAR(255),
   	account_id VARCHAR(255),
	claims INT,
	PRIMARY KEY(promo_id, account_id),
	FOREIGN KEY(promo_id)
        REFERENCES promo(id)
        ON DELETE CASCADE,
	FOREIGN KEY(account_id)
        REFERENCES account(id)
        ON DELETE CASCADE
) ENGINE=InnoDB;