cfp.sql

CREATE TABLE biography (id INT AUTO_INCREMENT NOT NULL, owner_id INT DEFAULT NULL, description VARCHAR(50) NOT NULL, biography LONGTEXT NOT NULL, path VARCHAR(255) DEFAULT NULL, dt_added DATETIME NOT NULL, dt_updated DATETIME NOT NULL, joindin_url VARCHAR(250) NOT NULL, slideshare_url VARCHAR(250) NOT NULL, blog_url VARCHAR(250) NOT NULL, homepage_url VARCHAR(250) NOT NULL, INDEX IDX_E3B3665C7E3C61F9 (owner_id), PRIMARY KEY(id)) ENGINE = InnoDB;
CREATE TABLE fos_user (id INT AUTO_INCREMENT NOT NULL, username VARCHAR(255) NOT NULL, username_canonical VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, email_canonical VARCHAR(255) NOT NULL, enabled TINYINT(1) NOT NULL, salt VARCHAR(255) NOT NULL, password VARCHAR(255) NOT NULL, last_login DATETIME DEFAULT NULL, locked TINYINT(1) NOT NULL, expired TINYINT(1) NOT NULL, expires_at DATETIME DEFAULT NULL, confirmation_token VARCHAR(255) DEFAULT NULL, password_requested_at DATETIME DEFAULT NULL, roles LONGTEXT NOT NULL COMMENT '(DC2Type:array)', credentials_expired TINYINT(1) NOT NULL, credentials_expire_at DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_957A647992FC23A8 (username_canonical), UNIQUE INDEX UNIQ_957A6479A0D96FBF (email_canonical), PRIMARY KEY(id)) ENGINE = InnoDB;
CREATE TABLE talk (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(100) NOT NULL, abstract LONGTEXT NOT NULL, type VARCHAR(50) NOT NULL, remark LONGTEXT NOT NULL, slides_url VARCHAR(250) NOT NULL, joindin_url VARCHAR(250) NOT NULL, PRIMARY KEY(id)) ENGINE = InnoDB;
CREATE TABLE talk_owners (talk_id INT NOT NULL, user_id INT NOT NULL, INDEX IDX_AA29B896F0601D5 (talk_id), INDEX IDX_AA29B89A76ED395 (user_id), PRIMARY KEY(talk_id, user_id)) ENGINE = InnoDB;
CREATE TABLE conference (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(50) NOT NULL, tag VARCHAR(25) NOT NULL, dt_created DATETIME NOT NULL, dt_start DATETIME NOT NULL, dt_end DATETIME NOT NULL, cfp_start DATETIME NOT NULL, cfp_end DATETIME NOT NULL, description LONGTEXT NOT NULL, geo_long NUMERIC(18, 12) NOT NULL, geo_lat NUMERIC(18, 12) NOT NULL, PRIMARY KEY(id)) ENGINE = InnoDB;
CREATE TABLE conference_hosts (conference_id INT NOT NULL, user_id INT NOT NULL, INDEX IDX_D2D9A1C0604B8382 (conference_id), INDEX IDX_D2D9A1C0A76ED395 (user_id), PRIMARY KEY(conference_id, user_id)) ENGINE = InnoDB;
CREATE TABLE conference_admins (conference_id INT NOT NULL, user_id INT NOT NULL, INDEX IDX_8B33C850604B8382 (conference_id), INDEX IDX_8B33C850A76ED395 (user_id), PRIMARY KEY(conference_id, user_id)) ENGINE = InnoDB;
CREATE TABLE vote (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, submission_id INT DEFAULT NULL, dt_created DATETIME NOT NULL, vote INT NOT NULL, remark LONGTEXT NOT NULL, INDEX IDX_5A108564A76ED395 (user_id), INDEX IDX_5A108564E1FD4933 (submission_id), PRIMARY KEY(id)) ENGINE = InnoDB;
CREATE TABLE submission (id INT AUTO_INCREMENT NOT NULL, registration_id INT DEFAULT NULL, talk_id INT DEFAULT NULL, remarks TEXT NOT NULL, dt_created DATETIME NOT NULL, INDEX IDX_DB055AF3833D8F43 (registration_id), INDEX IDX_DB055AF36F0601D5 (talk_id), PRIMARY KEY(id)) ENGINE = InnoDB;
CREATE TABLE registration (id INT AUTO_INCREMENT NOT NULL, conference_id INT DEFAULT NULL, user_id INT DEFAULT NULL, biography_id INT DEFAULT NULL, remarks TEXT NOT NULL, dt_created DATETIME NOT NULL, INDEX IDX_62A8A7A7604B8382 (conference_id), INDEX IDX_62A8A7A7A76ED395 (user_id), INDEX IDX_62A8A7A762283C10 (biography_id), PRIMARY KEY(id)) ENGINE = InnoDB;
ALTER TABLE biography ADD CONSTRAINT FK_E3B3665C7E3C61F9 FOREIGN KEY (owner_id) REFERENCES fos_user(id);
ALTER TABLE talk_owners ADD CONSTRAINT FK_AA29B896F0601D5 FOREIGN KEY (talk_id) REFERENCES talk(id) ON DELETE CASCADE;
ALTER TABLE talk_owners ADD CONSTRAINT FK_AA29B89A76ED395 FOREIGN KEY (user_id) REFERENCES fos_user(id) ON DELETE CASCADE;
ALTER TABLE conference_hosts ADD CONSTRAINT FK_D2D9A1C0604B8382 FOREIGN KEY (conference_id) REFERENCES conference(id) ON DELETE CASCADE;
ALTER TABLE conference_hosts ADD CONSTRAINT FK_D2D9A1C0A76ED395 FOREIGN KEY (user_id) REFERENCES fos_user(id) ON DELETE CASCADE;
ALTER TABLE conference_admins ADD CONSTRAINT FK_8B33C850604B8382 FOREIGN KEY (conference_id) REFERENCES conference(id) ON DELETE CASCADE;
ALTER TABLE conference_admins ADD CONSTRAINT FK_8B33C850A76ED395 FOREIGN KEY (user_id) REFERENCES fos_user(id) ON DELETE CASCADE;
ALTER TABLE vote ADD CONSTRAINT FK_5A108564A76ED395 FOREIGN KEY (user_id) REFERENCES fos_user(id);
ALTER TABLE vote ADD CONSTRAINT FK_5A108564E1FD4933 FOREIGN KEY (submission_id) REFERENCES submission(id);
ALTER TABLE submission ADD CONSTRAINT FK_DB055AF3833D8F43 FOREIGN KEY (registration_id) REFERENCES registration(id);
ALTER TABLE submission ADD CONSTRAINT FK_DB055AF36F0601D5 FOREIGN KEY (talk_id) REFERENCES talk(id);
ALTER TABLE registration ADD CONSTRAINT FK_62A8A7A7604B8382 FOREIGN KEY (conference_id) REFERENCES conference(id);
ALTER TABLE registration ADD CONSTRAINT FK_62A8A7A7A76ED395 FOREIGN KEY (user_id) REFERENCES fos_user(id);
ALTER TABLE registration ADD CONSTRAINT FK_62A8A7A762283C10 FOREIGN KEY (biography_id) REFERENCES biography(id)