-
Notifications
You must be signed in to change notification settings - Fork 4
/
120_populate_flyway_schema_history_table.sql
49 lines (47 loc) · 6.36 KB
/
120_populate_flyway_schema_history_table.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
INSERT INTO webapi.flyway_schema_history( installed_rank, version, description, type, script, checksum, installed_by, installed_on, execution_time, success)
VALUES
(0,null,'<< Flyway Schema Creation >>','SCHEMA','webapi',null,'postgres','2019-07-27 18:56:38.142421',0,true),
(1,'1.0.0.1','schema-create spring batch','SQL','V1.0.0.1__schema-create_spring_batch.sql',1751010277,'postgres','2019-07-27 18:56:38.20597',55,true),
(2,'1.0.0.2','schema-create jpa','SQL','V1.0.0.2__schema-create_jpa.sql',239472271,'postgres','2019-07-27 18:56:38.285391',7,true),
(3,'1.0.0.3','cohort definition persistence','SQL','V1.0.0.3__cohort_definition_persistence.sql',-237750892,'postgres','2019-07-27 18:56:38.307417',20,true),
(4,'1.0.0.3.1','cohort generation','SQL','V1.0.0.3.1__cohort_generation.sql',-1395295375,'postgres','2019-07-27 18:56:38.337365',9,true),
(5,'1.0.0.3.2','alter foreign keys','SQL','V1.0.0.3.2__alter_foreign_keys.sql',-1649653433,'postgres','2019-07-27 18:56:38.373754',6,true),
(6,'1.0.0.4','cohort analysis results','SQL','V1.0.0.4__cohort_analysis_results.sql',-200839803,'postgres','2019-07-27 18:56:38.389166',45,true),
(7,'1.0.0.4.1','heracles heel','SQL','V1.0.0.4.1__heracles_heel.sql',-84006752,'postgres','2019-07-27 18:56:38.438262',1,true),
(8,'1.0.0.4.2','measurement types','SQL','V1.0.0.4.2__measurement_types.sql',-413512902,'postgres','2019-07-27 18:56:38.4434',3,true),
(9,'1.0.0.4.3','heracles index','SQL','V1.0.0.4.3__heracles_index.sql',1375932065,'postgres','2019-07-27 18:56:38.45782',40,true),
(10,'1.0.0.5','feasability tables','SQL','V1.0.0.5__feasability_tables.sql',-1837563185,'postgres','2019-07-27 18:56:38.508751',24,true),
(11,'1.0.0.5.1','alter foreign keys','SQL','V1.0.0.5.1__alter_foreign_keys.sql',2031606332,'postgres','2019-07-27 18:56:38.541007',3,true),
(12,'1.0.0.6.1','schema-create laertes','SQL','V1.0.0.6.1__schema-create_laertes.sql',-1349717416,'postgres','2019-07-27 18:56:38.551423',57,true),
(13,'1.0.0.6.2','schema-create laertes','SQL','V1.0.0.6.2__schema-create_laertes.sql',1368157866,'postgres','2019-07-27 18:56:38.621552',3,true),
(14,'1.0.0.6.3','schema-create laertes','SQL','V1.0.0.6.3__schema-create_laertes.sql',-491150481,'postgres','2019-07-27 18:56:38.630302',2,true),
(15,'1.0.0.6.4','schema-create laertes','SQL','V1.0.0.6.4__schema-create_laertes.sql',1823854031,'postgres','2019-07-27 18:56:38.644661',3,true),
(16,'1.0.0.6.5','schema-create penelope laertes','SQL','V1.0.0.6.5__schema-create_penelope_laertes.sql',1957278056,'postgres','2019-07-27 18:56:38.652039',10,true),
(17,'1.0.0.7.0','sources.sql','SQL','V1.0.0.7.0__sources.sql.sql',-760001807,'postgres','2019-07-27 18:56:38.669626',11,true),
(18,'1.0.0.7.1','cohort multihomed support','SQL','V1.0.0.7.1__cohort_multihomed_support.sql',1336099437,'postgres','2019-07-27 18:56:38.686751',7,true),
(19,'1.0.0.7.2','feasability multihomed support.sql','SQL','V1.0.0.7.2__feasability_multihomed_support.sql.sql',148960385,'postgres','2019-07-27 18:56:38.707191',12,true),
(20,'1.0.0.8','heracles data','SQL','V1.0.0.8__heracles_data.sql',-1681329183,'postgres','2019-07-27 18:56:38.726654',20,true),
(21,'1.0.0.9','shiro security','SQL','V1.0.0.9__shiro_security.sql',2079932389,'postgres','2019-07-27 18:56:38.750675',42,true),
(22,'1.0.0.9.1','shiro security-initial values','SQL','V1.0.0.9.1__shiro_security-initial_values.sql',-1366664772,'postgres','2019-07-27 18:56:38.797355',13,true),
(23,'1.0.1.0','conceptsets','SQL','V1.0.1.0__conceptsets.sql',-38971961,'postgres','2019-07-27 18:56:38.816276',4,true),
(24,'1.0.1.1','penelope','SQL','V1.0.1.1__penelope.sql',-325000768,'postgres','2019-07-27 18:56:38.823914',17,true),
(25,'1.0.1.1.1','penelope data','SQL','V1.0.1.1.1__penelope_data.sql',-1999170430,'postgres','2019-07-27 18:56:38.84555',724,true),
(26,'1.0.1.2','conceptset negative controls','SQL','V1.0.1.2__conceptset_negative_controls.sql',683362142,'postgres','2019-07-27 18:56:39.574751',13,true),
(27,'1.0.1.3','conceptset generation info','SQL','V1.0.1.3__conceptset_generation_info.sql',1447776410,'postgres','2019-07-27 18:56:39.594901',8,true),
(28,'1.0.2.0','cohort feasiblity','SQL','V1.0.2.0__cohort_feasiblity.sql',-1967149411,'postgres','2019-07-27 18:56:39.611469',15,true),
(29,'1.0.3.1','comparative cohort analysis','SQL','V1.0.3.1__comparative_cohort_analysis.sql',-193775271,'postgres','2019-07-27 18:56:39.630352',12,true),
(30,'1.0.4.0','ir analysis','SQL','V1.0.4.0__ir_analysis.sql',-1741305750,'postgres','2019-07-27 18:56:39.646497',25,true),
(31,'1.0.4.1','ir dist','SQL','V1.0.4.1__ir_dist.sql',-1158399278,'postgres','2019-07-27 18:56:39.676728',3,true),
(32,'1.0.5.0','rename system user to anonymous','SQL','V1.0.5.0__rename_system_user_to_anonymous.sql',-1876461335,'postgres','2019-07-27 18:56:39.683455',2,true),
(33,'1.0.6.0','schema-create-plp','SQL','V1.0.6.0__schema-create-plp.sql',-1231203247,'postgres','2019-07-27 18:56:39.689083',6,true),
(34,'1.0.6.0.1','schema-add-analysis execution password','SQL','V1.0.6.0.1__schema-add-analysis_execution_password.sql',-2076532894,'postgres','2019-07-27 18:56:39.707751',33,true),
(35,'1.0.7.0','alter cohort generation info','SQL','V1.0.7.0__alter_cohort_generation_info.sql',1167339897,'postgres','2019-07-27 18:56:39.760894',14,true),
(36,'1.0.8.0','cohort features results','SQL','V1.0.8.0__cohort_features_results.sql',-1414878237,'postgres','2019-07-27 18:56:39.778865',8,true),
(37,'1.0.9.0','data-permissions','SQL','V1.0.9.0__data-permissions.sql',546084773,'postgres','2019-07-27 18:56:39.791089',18,true),
(38,'1.0.10.0','data-atlas-user','SQL','V1.0.10.0__data-atlas-user.sql',1968979022,'postgres','2019-07-27 18:56:39.813548',9,true),
(39,'1.0.11.0','data-cohortanalysis-permission','SQL','V1.0.11.0__data-cohortanalysis-permission.sql',-1191542342,'postgres','2019-11-13 19:15:46.444698',12,true),
(40,'1.0.11.1','schema-executions','SQL','V1.0.11.1__schema-executions.sql',-447359366,'postgres','2019-11-13 19:15:46.49227',39,true),
(41,'2.2.0.20180202143000','delete-unnecessary-admin-permissions','SQL','V2.2.0.20180202143000__delete-unnecessary-admin-permissions.sql',476938479,'postgres','2019-11-13 19:15:46.549896',3,true),
(42,'2.2.0.20180215143000','remove password','SQL','V2.2.0.20180215143000__remove_password.sql',1545313171,'postgres','2019-11-13 19:15:46.567184',2,true),
(43,'2.2.5.20180212152023','concept-sets-author','SQL','V2.2.5.20180212152023__concept-sets-author.sql',-1364865017,'postgres','2019-11-13 19:15:46.59294',14,true)
;