Table - pratishmahajan26/opendcp-1 GitHub Wiki

CREATE TABLE converter_details ( id int(30) NOT NULL AUTO_INCREMENT, user_id int(20) NOT NULL, file_path varchar(300) DEFAULT NULL, file_type varchar(10) DEFAULT NULL, duration smallint(4) DEFAULT NULL, actual_duration float DEFAULT NULL, ctype smallint(2) DEFAULT NULL, cstatus smallint(2) DEFAULT NULL, dcp_path varchar(300) DEFAULT NULL, j2k_type smallint(2) DEFAULT NULL, image_resolution varchar(20) DEFAULT NULL, video_resoltion varchar(20) DEFAULT NULL, dcp_resolution varchar(20) DEFAULT NULL, cinema varchar(50) DEFAULT NULL, is_download smallint(3) DEFAULT NULL, img_to_vid_path varchar(300) DEFAULT NULL, jpeg_path varchar(300) DEFAULT NULL, mpeg_path varchar(300) DEFAULT NULL, mxf_video_path varchar(300) DEFAULT NULL, mxf_audio_path varchar(300) DEFAULT NULL, ad_id int(20) NOT NULL, PRIMARY KEY (id), KEY user_id (user_id), KEY ad_id (ad_id), CONSTRAINT converter_details_ibfk_1 FOREIGN KEY (user_id) REFERENCES user (id), CONSTRAINT converter_details_ibfk_2 FOREIGN KEY (ad_id) REFERENCES ad (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE user ( id int NOT NULL AUTO_INCREMENT, email varchar(100) NOT NULL, password varchar(100) DEFAULT NULL, mobile int DEFAULT NULL, country_code int DEFAULT NULL, address varchar(300) DEFAULT NULL, created_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, f_name varchar(100) NOT NULL, l_name varchar(100) NOT NULL, PRIMARY KEY (id), UNIQUE KEY email (email) ) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE ad ( id int(20) NOT NULL AUTO_INCREMENT, user_id int(20) NOT NULL, name varchar(100) NOT NULL, file_path varchar(300) NOT NULL, cinema varchar(300) NOT NULL, state varchar(300) DEFAULT NULL, city varchar(300) DEFAULT NULL, advertiser_address varchar(300) DEFAULT NULL, advertiser_name varchar(100) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;