TODO-deploy.txt

ALTER TABLE user ADD COLUMN credit int NOT NULL DEFAULT 0;
ALTER TABLE process ADD COLUMN api_version varchar(8) default 'v1';

CREATE TABLE correction (
    id INTEGER NOT NULL,
    created_at DATETIME NOT NULL,
    updated_at DATETIME NOT NULL,
    content TEXT,
    version INTEGER,
    file_id INTEGER NOT NULL,
    format VARCHAR(5),
    PRIMARY KEY (id),
    FOREIGN KEY(file_id) REFERENCES media_file (id)
);

CREATE INDEX ix_correction_format ON correction (format);

==================
Adding multi-model
==================


CREATE TABLE asr_model (
	id INTEGER NOT NULL, 
	created_at DATETIME NOT NULL, 
	updated_at DATETIME NOT NULL, 
	name VARCHAR(80), 
	description VARCHAR(255), 
	PRIMARY KEY (id), 
	UNIQUE (name)
);
INSERT INTO "asr_model" VALUES(1,'2016-05-10 12:14:24.395763','2016-05-10 12:14:24.395768','french.studio.fr_FR','Français - Générique');
INSERT INTO "asr_model" VALUES(2,'2016-05-10 12:14:24.397586','2016-05-10 12:14:24.397590','english.studio','Anglais - Générique');
INSERT INTO "asr_model" VALUES(3,'2016-05-10 12:14:24.395763','2016-05-10 12:14:24.395768','french.phone.fr_FR','Français - Téléphone - Générique');
INSERT INTO "asr_model" VALUES(4,'2016-05-10 12:14:24.395763','2016-05-10 12:14:24.395768','french.lep.sarko.studio.fr_FR','Français - LEP Sarkozy');

INSERT INTO "asr_model" VALUES(6,'2017-03-14 12:14:24.395763','2017-03-14 12:14:24.395768','french.phone.fr_FR.spb','Phone - SPB');

INSERT INTO "asr_model" VALUES(7,'2017-03-31 12:14:24.395763','2017-03-31 12:14:24.395768','french.phone.fr_FR.spb2','Phone - SPB2');

INSERT INTO "asr_model" VALUES(8,'2017-03-31 12:14:24.395763','2017-03-31 12:14:24.395768','french.phone.fr_FR.vp3','Phone - Voyage Privé 3g 30%');

CREATE TABLE asr_models_users (
	asr_model_id INTEGER, 
	user_id INTEGER, 
	FOREIGN KEY(asr_model_id) REFERENCES asr_model (id), 
	FOREIGN KEY(user_id) REFERENCES user (id)
);
INSERT INTO "asr_models_users" VALUES(1,1);
INSERT INTO "asr_models_users" VALUES(2,1);
INSERT INTO "asr_models_users" VALUES(4,1);

INSERT INTO "asr_models_users" VALUES(1,2);
INSERT INTO "asr_models_users" VALUES(2,2);


INSERT INTO "asr_models_users" VALUES(1,3);
INSERT INTO "asr_models_users" VALUES(2,3);

INSERT INTO "asr_models_users" VALUES(1,4);
INSERT INTO "asr_models_users" VALUES(2,4);


INSERT INTO "asr_models_users" VALUES(1,5);
INSERT INTO "asr_models_users" VALUES(2,5);


INSERT INTO "asr_models_users" VALUES(1,6);
INSERT INTO "asr_models_users" VALUES(2,6);

INSERT INTO "asr_models_users" VALUES(1,7);
INSERT INTO "asr_models_users" VALUES(2,7);

INSERT INTO "asr_models_users" VALUES(1,8);
INSERT INTO "asr_models_users" VALUES(2,8);

INSERT INTO "asr_models_users" VALUES(1,9);
INSERT INTO "asr_models_users" VALUES(2,9);

INSERT INTO "asr_models_users" VALUES(1,10);
INSERT INTO "asr_models_users" VALUES(2,10);

INSERT INTO "asr_models_users" VALUES(1,11);
INSERT INTO "asr_models_users" VALUES(2,11);


INSERT INTO "asr_models_users" VALUES(7,4);
INSERT INTO "asr_models_users" VALUES(7,1);

INSERT INTO "asr_models_users" VALUES(8,4);
INSERT INTO "asr_models_users" VALUES(8,1);


ALTER TABLE process ADD COLUMN asr_model_id INTEGER REFERENCES asr_model(id);