auction_table_query - MukeshKumar101/IPL_Auction GitHub Wiki

CREATE TABLE auction ( id BINARY(16) NOT NULL, team_id BINARY(16) NOT NULL, player_id BINARY(16) NOT NULL, price BIGINT(10) NOT NULL, completed TINYINT(2) NOT NULL DEFAULT '0', active TINYINT(2) NOT NULL DEFAULT '1', created_by BINARY(16) NULL DEFAULT NULL, updated_by BINARY(16) NULL DEFAULT NULL, created_on DATETIME NULL DEFAULT 'CURRENT_TIMESTAMP', updated_on DATETIME NULL DEFAULT 'CURRENT_TIMESTAMP', PRIMARY KEY (id), INDEX team_id (team_id), INDEX player_id (player_id), CONSTRAINT FK__player FOREIGN KEY (player_id) REFERENCES PRt0QyNtiw.player (id) ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT FK__team FOREIGN KEY (team_id) REFERENCES PRt0QyNtiw.team (id) ON UPDATE NO ACTION ON DELETE NO ACTION );