aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorSébastien Lesaint <sebastien.lesaint@sonarsource.com>2017-04-03 14:59:17 +0200
committerSébastien Lesaint <sebastien.lesaint@sonarsource.com>2017-04-13 13:29:55 +0200
commit75199ada9ea789fee9532e3217c79282e35a9eca (patch)
tree3b045353b129a66de980202fa403b38183dc7e5d
parent139261bbc13192621ef795d6d45298e1d8e1b7f3 (diff)
downloadsonarqube-75199ada9ea789fee9532e3217c79282e35a9eca.tar.gz
sonarqube-75199ada9ea789fee9532e3217c79282e35a9eca.zip
remove SCHEMA_MIGRATIONS insert from rows-h2
-rw-r--r--server/sonar-db-core/src/main/resources/org/sonar/db/version/rows-h2.sql561
-rw-r--r--server/sonar-db-core/src/test/java/org/sonar/db/DdlUtilsTest.java8
-rw-r--r--server/sonar-server/src/main/java/org/sonar/server/platform/db/migration/AutoDbMigration.java61
-rw-r--r--server/sonar-server/src/test/java/org/sonar/server/platform/db/migration/AutoDbMigrationTest.java6
4 files changed, 56 insertions, 580 deletions
diff --git a/server/sonar-db-core/src/main/resources/org/sonar/db/version/rows-h2.sql b/server/sonar-db-core/src/main/resources/org/sonar/db/version/rows-h2.sql
index c3ba8396b64..7f83bcc46d7 100644
--- a/server/sonar-db-core/src/main/resources/org/sonar/db/version/rows-h2.sql
+++ b/server/sonar-db-core/src/main/resources/org/sonar/db/version/rows-h2.sql
@@ -1,566 +1,5 @@
-- All the rows inserted during Rails migrations. Rows inserted during server startup tasks (Java) are excluded : rules, profiles, metrics, ...
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('2');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('10');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('11');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('14');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('35');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('48');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('49');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('53');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('54');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('59');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('61');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('62');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('79');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('80');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('86');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('87');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('88');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('93');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('95');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('111');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('115');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('118');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('119');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('120');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('131');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('132');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('133');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('134');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('135');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('136');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('137');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('138');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('139');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('140');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('141');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('142');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('151');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('160');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('162');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('163');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('165');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('166');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('167');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('168');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('169');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('170');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('180');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('190');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('191');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('200');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('201');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('202');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('203');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('210');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('211');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('212');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('213');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('214');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('215');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('216');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('217');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('220');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('221');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('222');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('230');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('231');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('232');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('233');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('234');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('235');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('236');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('237');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('238');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('239');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('240');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('241');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('250');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('251');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('252');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('254');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('255');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('256');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('257');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('258');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('259');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('260');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('261');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('262');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('263');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('280');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('281');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('282');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('283');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('284');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('285');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('286');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('287');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('300');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('301');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('302');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('303');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('304');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('305');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('306');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('320');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('321');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('330');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('331');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('332');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('333');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('334');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('335');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('350');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('351');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('352');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('353');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('354');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('355');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('356');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('358');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('359');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('360');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('361');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('362');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('363');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('370');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('379');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('380');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('381');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('382');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('383');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('387');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('388');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('391');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('392');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('394');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('397');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('398');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('399');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('400');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('401');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('402');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('403');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('404');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('405');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('406');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('410');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('411');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('412');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('413');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('414');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('415');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('416');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('417');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('418');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('419');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('430');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('431');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('432');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('433');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('434');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('440');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('441');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('442');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('443');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('444');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('460');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('461');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('462');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('463');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('464');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('465');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('466');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('467');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('480');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('481');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('482');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('483');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('484');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('485');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('486');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('488');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('489');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('490');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('492');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('493');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('494');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('495');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('496');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('497');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('498');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('510');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('511');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('512');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('513');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('514');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('515');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('516');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('517');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('518');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('519');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('520');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('521');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('522');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('523');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('524');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('525');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('526');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('530');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('531');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('532');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('533');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('534');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('535');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('536');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('537');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('539');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('540');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('541');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('542');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('544');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('545');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('546');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('547');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('548');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('549');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('551');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('552');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('553');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('554');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('555');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('556');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('580');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('581');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('582');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('583');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('584');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('600');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('601');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('603');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('604');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('605');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('702');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('703');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('704');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('705');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('706');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('707');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('708');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('709');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('710');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('711');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('712');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('713');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('714');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('715');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('716');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('717');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('718');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('719');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('720');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('721');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('750');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('752');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('753');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('754');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('755');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('756');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('757');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('758');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('759');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('760');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('761');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('762');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('763');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('764');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('765');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('766');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('768');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('769');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('770');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('771');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('772');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('773');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('775');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('776');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('777');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('778');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('779');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('780');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('781');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('782');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('783');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('784');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('786');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('787');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('788');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('789');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('790');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('791');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('792');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('793');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('794');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('795');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('796');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('900');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('901');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('902');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('903');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('904');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('905');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('906');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('907');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('908');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('912');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('913');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('915');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('916');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('917');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('918');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('919');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('920');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('921');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('922');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('923');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('924');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('925');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('926');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('927');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('929');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('930');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('931');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('932');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('933');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('934');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('935');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('936');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('937');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('938');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('939');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('940');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('941');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1000');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1001');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1003');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1004');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1005');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1006');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1007');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1008');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1009');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1010');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1011');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1012');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1013');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1014');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1015');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1017');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1100');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1101');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1102');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1103');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1104');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1105');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1106');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1107');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1108');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1109');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1110');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1111');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1112');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1113');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1114');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1115');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1116');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1117');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1118');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1119');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1120');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1121');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1122');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1123');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1124');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1125');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1150');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1151');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1152');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1153');
-
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1200');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1201');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1202');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1203');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1204');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1205');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1206');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1207');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1208');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1209');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1210');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1211');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1212');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1213');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1214');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1215');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1216');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1217');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1218');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1219');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1220');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1221');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1222');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1223');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1224');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1225');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1226');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1227');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1228');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1229');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1230');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1231');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1232');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1233');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1234');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1235');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1236');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1237');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1238');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1239');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1240');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1241');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1242');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1243');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1244');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1245');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1246');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1247');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1248');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1249');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1250');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1251');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1252');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1253');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1254');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1255');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1256');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1257');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1258');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1259');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1260');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1261');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1262');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1263');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1264');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1265');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1266');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1267');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1268');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1269');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1270');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1271');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1272');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1273');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1274');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1275');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1276');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1277');
-
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1300');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1301');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1302');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1303');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1304');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1306');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1307');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1309');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1310');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1311');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1312');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1313');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1314');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1315');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1316');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1317');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1318');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1319');
-
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1400');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1401');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1402');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1403');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1404');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1405');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1406');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1407');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1408');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1409');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1410');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1411');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1412');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1413');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1414');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1415');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1416');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1417');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1418');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1419');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1420');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1421');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1422');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1423');
-
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1500');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1501');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1502');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1503');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1504');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1505');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1506');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1507');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1508');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1509');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1510');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1511');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1512');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1513');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1514');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1515');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1516');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1517');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1518');
-
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1600');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1601');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1602');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1603');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1604');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1605');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1606');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1607');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1608');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1609');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1610');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1611');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1612');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1613');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1614');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1615');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1616');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1617');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1618');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1619');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1620');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1621');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1622');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1623');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1624');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1625');
-INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('1626');
-
INSERT INTO USERS(ID, LOGIN, NAME, EMAIL, EXTERNAL_IDENTITY, EXTERNAL_IDENTITY_PROVIDER, USER_LOCAL, CRYPTED_PASSWORD, SALT, IS_ROOT, CREATED_AT, UPDATED_AT) VALUES (1, 'admin', 'Administrator', '', 'admin', 'sonarqube', true, 'a373a0e667abb2604c1fd571eb4ad47fe8cc0878', '48bc4b0d93179b5103fd3885ea9119498e9d161b', false, '1418215735482', '1418215735482');
ALTER TABLE USERS ALTER COLUMN ID RESTART WITH 2;
diff --git a/server/sonar-db-core/src/test/java/org/sonar/db/DdlUtilsTest.java b/server/sonar-db-core/src/test/java/org/sonar/db/DdlUtilsTest.java
index 68f64dbf321..088b7386336 100644
--- a/server/sonar-db-core/src/test/java/org/sonar/db/DdlUtilsTest.java
+++ b/server/sonar-db-core/src/test/java/org/sonar/db/DdlUtilsTest.java
@@ -53,7 +53,7 @@ public class DdlUtilsTest {
int tableCount = countTables(connection);
assertThat(tableCount).isGreaterThan(30);
- verifySchemaMigrations(connection);
+ verifySchemaMigrationsNotPopulated(connection);
}
}
@@ -66,7 +66,7 @@ public class DdlUtilsTest {
}
DdlUtils.createSchema(connection, "h2", false);
- verifySchemaMigrations(connection);
+ verifySchemaMigrationsNotPopulated(connection);
}
}
@@ -80,11 +80,11 @@ public class DdlUtilsTest {
return count;
}
- private void verifySchemaMigrations(Connection connection) throws SQLException {
+ private void verifySchemaMigrationsNotPopulated(Connection connection) throws SQLException {
try (Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("select count(*) from schema_migrations")) {
assertThat(resultSet.next()).isTrue();
- assertThat(resultSet.getLong(1)).isGreaterThan(150);
+ assertThat(resultSet.getLong(1)).isEqualTo(0);
assertThat(resultSet.next()).isFalse();
}
}
diff --git a/server/sonar-server/src/main/java/org/sonar/server/platform/db/migration/AutoDbMigration.java b/server/sonar-server/src/main/java/org/sonar/server/platform/db/migration/AutoDbMigration.java
index 52641cdc6a1..4065e03abc9 100644
--- a/server/sonar-server/src/main/java/org/sonar/server/platform/db/migration/AutoDbMigration.java
+++ b/server/sonar-server/src/main/java/org/sonar/server/platform/db/migration/AutoDbMigration.java
@@ -33,6 +33,7 @@ import org.sonar.db.DdlUtils;
import org.sonar.db.dialect.Dialect;
import org.sonar.db.dialect.H2;
import org.sonar.server.platform.db.migration.engine.MigrationEngine;
+import org.sonar.server.platform.db.migration.step.MigrationSteps;
/**
* FIXME fix this class to remove use of DdlUtils.createSchema
@@ -41,11 +42,13 @@ public class AutoDbMigration implements Startable {
private final ServerUpgradeStatus serverUpgradeStatus;
private final DbClient dbClient;
private final MigrationEngine migrationEngine;
+ private final MigrationSteps migrationSteps;
- public AutoDbMigration(ServerUpgradeStatus serverUpgradeStatus, DbClient dbClient, MigrationEngine migrationEngine) {
+ public AutoDbMigration(ServerUpgradeStatus serverUpgradeStatus, DbClient dbClient, MigrationEngine migrationEngine, MigrationSteps migrationSteps) {
this.serverUpgradeStatus = serverUpgradeStatus;
this.dbClient = dbClient;
this.migrationEngine = migrationEngine;
+ this.migrationSteps = migrationSteps;
}
@Override
@@ -77,32 +80,64 @@ public class AutoDbMigration implements Startable {
@VisibleForTesting
protected void createH2Schema(Connection connection, String dialectId) {
DdlUtils.createSchema(connection, dialectId, false);
+ populateSchemaMigration(connection, migrationSteps.getMaxMigrationNumber());
hackFixForProjectMeasureTreeQueries(connection);
}
+ private static void populateSchemaMigration(Connection connection, long maxMigrationNumber) {
+ try (PreparedStatement preparedStatement = connection.prepareStatement("INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES (?)")) {
+ batchExecute(
+ 0, maxMigrationNumber + 1,
+ preparedStatement, connection,
+ (statement, counter) -> statement.setString(1, String.valueOf(counter)));
+ } catch (SQLException e) {
+ throw new RuntimeException("Failed to insert rows into table SCHEMA_MIGRATIONS", e);
+ }
+ }
+
/**
* see SONAR-8586
*/
private static void hackFixForProjectMeasureTreeQueries(Connection connection) {
int metricId = 1;
try (PreparedStatement preparedStatement = connection.prepareStatement("insert into PROJECT_MEASURES (METRIC_ID,COMPONENT_UUID,ANALYSIS_UUID) values (?,?,?);")) {
- for (int i = 1; i < 1000; i++) {
- preparedStatement.setInt(1, metricId);
- preparedStatement.setString(2, "foo_" + i);
- preparedStatement.setString(3, "bar_" + i);
- preparedStatement.addBatch();
- if (i % 250 == 0) {
- preparedStatement.executeBatch();
- connection.commit();
- }
- }
- preparedStatement.executeBatch();
- connection.commit();
+ batchExecute(
+ 1, 1000,
+ preparedStatement, connection,
+ (stmt, counter) -> {
+ preparedStatement.setInt(1, metricId);
+ preparedStatement.setString(2, "foo_" + counter);
+ preparedStatement.setString(3, "bar_" + counter);
+ });
} catch (SQLException e) {
throw new RuntimeException("Failed to insert fake rows into table PROJECT_MEASURES", e);
}
}
+ /**
+ * @param start included
+ * @param end excluded
+ */
+ private static void batchExecute(long start, long end,
+ PreparedStatement preparedStatement, Connection connection,
+ Preparer preparer) throws SQLException {
+ for (long i = start; i < end; i++) {
+ preparer.prepare(preparedStatement, i);
+ preparedStatement.addBatch();
+ if (i % 250 == 0) {
+ preparedStatement.executeBatch();
+ connection.commit();
+ }
+ }
+ preparedStatement.executeBatch();
+ connection.commit();
+ }
+
+ @FunctionalInterface
+ private interface Preparer {
+ void prepare(PreparedStatement statement, long counter) throws SQLException;
+ }
+
@Override
public void stop() {
// nothing to do
diff --git a/server/sonar-server/src/test/java/org/sonar/server/platform/db/migration/AutoDbMigrationTest.java b/server/sonar-server/src/test/java/org/sonar/server/platform/db/migration/AutoDbMigrationTest.java
index b8e24b0cf32..e195b331ae4 100644
--- a/server/sonar-server/src/test/java/org/sonar/server/platform/db/migration/AutoDbMigrationTest.java
+++ b/server/sonar-server/src/test/java/org/sonar/server/platform/db/migration/AutoDbMigrationTest.java
@@ -36,6 +36,7 @@ import org.sonar.db.dialect.MySql;
import org.sonar.db.dialect.Oracle;
import org.sonar.db.dialect.PostgreSql;
import org.sonar.server.platform.db.migration.engine.MigrationEngine;
+import org.sonar.server.platform.db.migration.step.MigrationSteps;
import static org.assertj.core.api.Assertions.assertThat;
import static org.mockito.Mockito.mock;
@@ -54,9 +55,10 @@ public class AutoDbMigrationTest {
private DbClient dbClient = mock(DbClient.class, Mockito.RETURNS_DEEP_STUBS);
private ServerUpgradeStatus serverUpgradeStatus = mock(ServerUpgradeStatus.class);
private MigrationEngine migrationEngine = mock(MigrationEngine.class);
- private AutoDbMigration underTest = new AutoDbMigration(serverUpgradeStatus, dbClient, migrationEngine);
+ private MigrationSteps migrationSteps = mock(MigrationSteps.class);
+ private AutoDbMigration underTest = new AutoDbMigration(serverUpgradeStatus, dbClient, migrationEngine, migrationSteps);
- private AutoDbMigration noRealH2Creation = spy(new AutoDbMigration(serverUpgradeStatus, dbClient, migrationEngine) {
+ private AutoDbMigration noRealH2Creation = spy(new AutoDbMigration(serverUpgradeStatus, dbClient, migrationEngine, migrationSteps) {
@Override
protected void createH2Schema(Connection connection, String dialectId) {
// do nothing