diff options
author | Sébastien Lesaint <sebastien.lesaint@sonarsource.com> | 2017-04-03 14:59:17 +0200 |
---|---|---|
committer | Sébastien Lesaint <sebastien.lesaint@sonarsource.com> | 2017-04-13 13:29:55 +0200 |
commit | 75199ada9ea789fee9532e3217c79282e35a9eca (patch) | |
tree | 3b045353b129a66de980202fa403b38183dc7e5d | |
parent | 139261bbc13192621ef795d6d45298e1d8e1b7f3 (diff) | |
download | sonarqube-75199ada9ea789fee9532e3217c79282e35a9eca.tar.gz sonarqube-75199ada9ea789fee9532e3217c79282e35a9eca.zip |
remove SCHEMA_MIGRATIONS insert from rows-h2
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 |