MANUAL TESTS TO VERIFY deltasql INTEGRITY You can run these tests manually, if you install deltasql with the option "Test System (with Test Data)" in http://localhost/install.php. You then have a set of 14 scripts included in the module "deltasql-test-module" and two branches which are named DELTA_1 and DELTA_2. You should verify that exactly the scripts depicted below are present in the synchronization script generated by deltasql, if you use the "Synchronize database schema option". The rows below are in the form "from version -> scripts contained in output script". The project used in these tests is named "deltasql-test-project". 17__________________ DELTA_2 _______13_____/__________________ HEAD \________________________ DELTA_1 1. Test: HEAD -> HEAD 11 -> 12, 13, 14, 15, 17, 18, 19, 21, 22, 24 12 -> 13, 14, 15, 17, 18, 19, 21, 22, 24 13 -> 14, 15, 17, 18, 19, 21, 22, 24 14 -> 15, 17, 18, 19, 21, 22, 24 15 -> 17, 18, 19, 21, 22, 24 16 -> 17, 18, 19, 21, 22, 24 17 -> 18, 19, 21, 22, 24 18 -> 19, 21, 22, 24 19 -> 21, 22, 24 20 -> 21, 22, 24 21 -> 22, 24 22 -> 24 23 -> 24 24 -> 2. Test: DELTA_1 -> DELTA_1 13 -> 15, 16, 21, 22, 23 14 -> 15, 16, 21, 22, 23 15 -> 16, 21, 22, 23 16 -> 21, 22, 23 17 -> 21, 22, 23 18 -> 21, 22, 23 19 -> 21, 22, 23 20 -> 21, 22, 23 21 -> 22, 23 22 -> 23 23 -> 3. Test: DELTA_2 -> DELTA_2 17 -> 19, 20, 21 18 -> 19, 20, 21 19 -> 20, 21 20 -> 21 21 -> 4. Test: HEAD -> DELTA_1 11 -> 12, 13, 15, 16, 21, 22, 23 12 -> 13, 15, 16, 21, 22, 23 13 -> 15, 16, 21, 22, 23 14 -> 15, 16, 21, 22, 23 15 -> 16, 21, 22, 23 16 -> 21, 22, 23 17 -> 21, 22, 23 18 -> 21, 22, 23 19 -> 21, 22, 23 20 -> 21, 22, 23 21 -> 22, 23 22 -> 23 23 -> 5. Test: HEAD -> DELTA_2 11 -> 12, 13, 14, 15, 17, 19, 20 ,21 12 -> 13, 14, 15, 17, 19, 20, 21 13 -> 14, 15, 17, 19, 20, 21 14 -> 15, 17, 19, 20, 21 15 -> 17, 19, 20, 21 16 -> 17, 19, 20, 21 17 -> 19, 20, 21 18 -> 19, 20, 21 19 -> 20, 21 20 -> 21 21 -> 6. Test: DELTA_1 -> HEAD 13 -> 14, 15, 17, 18, 19, 21, 22, 24 14 -> 14, 15, 17, 18, 19, 21, 22, 24 15 -> 14, 17, 18, 19, 21, 22, 24 16 -> 14, 17, 18, 19, 21, 22, 24 17 -> 14, 17, 18, 19, 21, 22, 24 18 -> 14, 17, 18, 19, 21, 22, 24 19 -> 14, 17, 18, 19, 21, 22, 24 20 -> 14, 17, 18, 19, 21, 22, 24 21 -> 14, 17, 18, 19, 22, 24 22 -> 14, 17, 18, 19, 24 23 -> 14, 17, 18, 19, 24 24 -> 14, 17, 18, 19, 24 7. Test: DELTA_2 -> HEAD 17 -> 18, 19, 21, 22, 24 18 -> 18, 19, 21, 22, 24 19 -> 18, 21, 22, 24 20 -> 18, 21, 22, 24 21 -> 18, 22, 24 22 -> 18, 22, 24 23 -> 18, 22, 24 24 -> 18, 22, 24 8. Test: DELTA_1 -> DELTA_2 not implemented yet!!! 9. Test: DELTA_2 -> DELTA_1 not possible for any version