team_table_query - MukeshKumar101/IPL_Auction GitHub Wiki

CREATE TABLE team ( id BINARY(16) NOT NULL, user_id BINARY(16) NOT NULL, name VARCHAR(50) NOT NULL, sponser VARCHAR(50) NOT NULL, jersey VARCHAR(50) NOT NULL, state VARCHAR(50) NOT NULL, logo VARCHAR(50) NOT NULL, squad_size INT(10) NOT NULL, purse BIGINT(10) NOT NULL DEFAULT '850000000', 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', update_on DATETIME NULL DEFAULT 'CURRENT_TIMESTAMP', PRIMARY KEY (id), INDEX user_id (user_id), CONSTRAINT FK_team_user FOREIGN KEY (user_id) REFERENCES PRt0QyNtiw.user (id) ON UPDATE NO ACTION ON DELETE NO ACTION );