connect 'jdbc:derby:testdb;create=false';

CREATE TABLE timeFromZipCode (
  zipcode int,
  minutesToUnil int,
  minutesToCenter int
);

CREATE INDEX index_timeFromZipCode_zipcode_asc  ON timeFromZipCode (zipcode ASC);
CREATE INDEX index_timeFromZipCode_zipcode_desc ON timeFromZipCode (zipcode DESC);
CREATE INDEX index_timeFromZipCode_minutesToUnil_asc  ON timeFromZipCode (minutesToUnil ASC);
CREATE INDEX index_timeFromZipCode_minutesToUnil_desc ON timeFromZipCode (minutesToUnil DESC);
CREATE INDEX index_timeFromZipCode_minutesToCenter_asc  ON timeFromZipCode (minutesToCenter ASC);
CREATE INDEX index_timeFromZipCode_minutesToCenter_desc ON timeFromZipCode (minutesToCenter DESC);


INSERT INTO timeFromZipCode VALUES (1000,19,19),(1001,19,19),(1002,19,19),(1003,11,0),(1004,9,8),(1005,14,3),(1006,13,3),(1007,12,6),(1008,9,7),(1009,21,8),(1010,16,8),(1011,19,5),(1012,18,6),(1013,19,19),(1014,19,19),(1015,19,19),(1016,19,19),(1017,19,19),(1018,14,8),(1019,19,19),(1020,7,5),(1021,19,19),(1022,5,7),(1023,10,12),(1024,6,9),(1025,5,6),(1026,8,13),(1027,19,19),(1028,19,13),(1029,19,19),(1030,9,13),(1031,19,19),(1032,19,19),(1033,19,19),(1034,19,19),(1035,19,19),(1036,14,14),(1037,19,19),(1038,19,19),(1039,19,19),(1040,19,19),(1041,19,19),(1042,19,19),(1043,19,19),(1044,19,19),(1045,19,19),(1046,19,19),(1047,19,19),(1048,19,19),(1049,19,19),(1050,19,19),(1051,19,19),(1052,18,16),(1053,23,20),(1054,19,19),(1055,19,19),(1056,19,19),(1057,19,19),(1058,19,19),(1059,19,19),(1060,19,19),(1061,19,19),(1062,19,19),(1063,19,19),(1064,19,19),(1065,19,19),(1066,21,15),(1067,19,19),(1068,19,19),(1069,19,19),(1070,19,19),(1071,19,19),(1072,19,19),(1073,19,19),(1074,19,19),(1075,19,19),(1076,19,19),(1077,19,19),(1078,19,19),(1079,19,19),(1080,19,19),(1081,19,19),(1082,19,19),(1083,19,19),(1084,19,19),(1085,19,19),(1086,19,19),(1087,19,19),(1088,19,23),(1089,19,19),(1090,19,19),(1091,19,19),(1092,19,19),(1093,19,19),(1094,22,9),(1095,19,19),(1096,19,19),(1097,19,19),(1098,19,19),(1099,19,19),(1100,19,19),(1101,19,19),(1102,19,19),(1103,19,19),(1104,19,19),(1105,19,19),(1106,19,19),(1107,19,19),(1108,19,19),(1109,19,19),(1110,12,14),(1111,19,19),(1112,19,19),(1113,19,19),(1114,19,19),(1115,19,19),(1116,19,19),(1117,19,19),(1118,19,19),(1119,19,19),(1120,19,19),(1121,19,19),(1122,19,19),(1123,19,19),(1124,19,19),(1125,19,19),(1126,19,19),(1127,21,21),(1128,19,19),(1129,19,19),(1130,19,19),(1131,19,19),(1132,19,19),(1133,19,19),(1134,19,19),(1135,19,19),(1136,21,19),(1137,19,19),(1138,19,19),(1139,19,19),(1140,19,19),(1141,19,19),(1142,19,19),(1143,19,19),(1144,19,19),(1145,19,19),(1146,19,19),(1147,19,19),(1148,19,19),(1149,19,19),(1150,19,19),(1151,19,19),(1152,19,19),(1153,19,19),(1154,19,19),(1155,19,19),(1156,19,19),(1157,19,19),(1158,19,19),(1159,19,19),(1160,19,19),(1161,19,19),(1162,19,19),(1163,22,22),(1164,19,19),(1165,19,19),(1166,19,19),(1167,19,19),(1168,19,19),(1169,19,19),(1170,19,19),(1171,19,19),(1172,19,19),(1173,19,19),(1174,19,19),(1175,19,19),(1176,19,19),(1177,19,19),(1178,19,19),(1179,19,19),(1180,19,19),(1181,19,19),(1182,19,19),(1183,19,19),(1184,19,19),(1185,19,19),(1186,19,19),(1187,19,19),(1188,19,19),(1189,19,19),(1190,19,19),(1191,19,19),(1192,19,19),(1193,19,19),(1194,19,19),(1195,19,19),(1196,19,19),(1197,19,19),(1198,19,19),(1199,19,19),(1200,42,42),(1201,39,39),(1202,39,39),(1203,39,39),(1204,39,39),(1205,39,39),(1206,39,39),(1207,39,39),(1208,39,39),(1209,39,39),(1210,39,39),(1211,39,39),(1212,39,39),(1213,39,39),(1214,39,39),(1215,39,39),(1216,39,39),(1217,39,39),(1218,39,39),(1219,39,39),(1220,39,39),(1221,39,39),(1222,39,39),(1223,39,39),(1224,39,39),(1225,39,39),(1226,39,39),(1227,39,39),(1228,39,39),(1229,39,39),(1230,39,39),(1231,39,39),(1232,39,39),(1233,39,39),(1234,39,39),(1235,39,39),(1236,39,39),(1237,39,39),(1238,39,39),(1239,39,39),(1240,39,39),(1241,39,39),(1242,39,39),(1243,39,39),(1244,39,39),(1245,39,39),(1246,39,39),(1247,39,39),(1248,39,39),(1249,39,39),(1250,39,39),(1251,39,39),(1252,39,39),(1253,39,39),(1254,39,39),(1255,39,39),(1256,39,39),(1257,39,39),(1258,39,39),(1259,39,39),(1260,39,39),(1261,39,39),(1262,39,39),(1263,39,39),(1264,39,39),(1265,39,39),(1266,39,39),(1267,39,39),(1268,39,39),(1269,39,39),(1270,39,39),(1271,39,39),(1272,39,39),(1273,39,39),(1274,39,39),(1275,39,39),(1276,39,39),(1277,39,39),(1278,39,39),(1279,39,39),(1280,39,39),(1281,39,39),(1282,39,39),(1283,39,39),(1284,39,39),(1285,39,39),(1286,39,39),(1287,39,39),(1288,39,39),(1289,39,39),(1290,39,39),(1291,39,39),(1292,39,39),(1293,39,39),(1294,39,39),(1295,39,39),(1296,39,39),(1297,39,39),(1298,39,39),(1299,39,39),(1300,39,39),(1301,39,39),(1302,39,39),(1303,39,39),(1304,39,39),(1305,39,39),(1306,39,39),(1307,39,39),(1308,39,39),(1309,39,39),(1310,39,39),(1311,39,39),(1312,39,39),(1313,39,39),(1314,39,39),(1315,39,39),(1316,39,39),(1317,39,39),(1318,39,39),(1319,39,39),(1320,39,39),(1321,39,39),(1322,32,32),(1323,39,39),(1324,39,39),(1325,39,39),(1326,39,39),(1327,39,39),(1328,39,39),(1329,39,39),(1330,39,39),(1331,39,39),(1332,39,39),(1333,39,39),(1334,39,39),(1335,39,39),(1336,39,39),(1337,39,39),(1338,39,39),(1339,39,39),(1340,39,39),(1341,39,39),(1342,39,39),(1343,39,39),(1344,39,39),(1345,39,39),(1346,39,39),(1347,39,39),(1348,39,39),(1349,39,39),(1350,39,39),(1351,39,39),(1352,39,39),(1353,39,39),(1354,39,39),(1355,39,39),(1356,39,39),(1357,39,39),(1358,39,39),(1359,39,39),(1360,39,39),(1361,39,39),(1362,39,39),(1363,39,39),(1364,39,39),(1365,39,39),(1366,39,39),(1367,39,39),(1368,39,39),(1369,39,39),(1370,39,39),(1371,39,39),(1372,39,39),(1373,39,39),(1374,39,39),(1375,39,39),(1376,39,39),(1377,39,39),(1378,39,39),(1379,39,39),(1380,39,39),(1381,39,39),(1382,39,39),(1383,39,39),(1384,39,39),(1385,39,39),(1386,39,39),(1387,39,39),(1388,39,39),(1389,39,39),(1390,39,39),(1391,39,39),(1392,39,39),(1393,39,39),(1394,39,39),(1395,39,39),(1396,39,39),(1397,39,39),(1398,39,39),(1399,39,39),(1400,39,39),(1401,39,39),(1402,39,39),(1403,39,39),(1404,39,39),(1405,39,39),(1406,39,39),(1407,39,39),(1408,39,39),(1409,39,39),(1410,43,43),(1411,39,39),(1412,39,39),(1413,39,39),(1414,39,39),(1415,39,39),(1416,39,39),(1417,39,39),(1418,39,39),(1419,39,39),(1420,39,39),(1421,39,39),(1422,39,39),(1423,39,39),(1424,39,39),(1425,39,39),(1426,39,39),(1427,39,39),(1428,39,39),(1429,39,39),(1430,39,39),(1431,39,39),(1432,39,39),(1433,39,39),(1434,39,39),(1435,39,39),(1436,39,39),(1437,39,39),(1438,39,39),(1439,39,39),(1440,39,39),(1441,39,39),(1442,39,39),(1443,39,39),(1444,39,39),(1445,39,39),(1446,39,39),(1447,39,39),(1448,39,39),(1449,39,39),(1450,39,39),(1451,39,39),(1452,39,39),(1453,39,39),(1454,39,39),(1455,39,39),(1456,39,39),(1457,39,39),(1458,39,39),(1459,39,39),(1460,39,39),(1461,39,39),(1462,39,39),(1463,39,39),(1464,39,39),(1465,39,39),(1466,39,39),(1467,39,39),(1468,39,39),(1469,39,39),(1470,39,39),(1471,39,39),(1472,39,39),(1473,39,39),(1474,39,39),(1475,39,39),(1476,39,39),(1477,39,39),(1478,39,39),(1479,39,39),(1480,39,39),(1481,39,39),(1482,39,39),(1483,39,39),(1484,39,39),(1485,39,39),(1486,39,39),(1487,39,39),(1488,39,39),(1489,39,39),(1490,39,39),(1491,39,39),(1492,39,39),(1493,39,39),(1494,39,39),(1495,39,39),(1496,39,39),(1497,39,39),(1498,39,39),(1499,39,39),(1500,39,39),(1501,39,39),(1502,39,39),(1503,39,39),(1504,39,39),(1505,39,39),(1506,39,39),(1507,39,39),(1508,39,39),(1509,39,39),(1510,39,39),(1511,39,39),(1512,39,39),(1513,39,39),(1514,39,39),(1515,39,39),(1516,39,39),(1517,39,39),(1518,39,39),(1519,39,39),(1520,39,39),(1521,39,39),(1522,39,39),(1523,39,39),(1524,39,39),(1525,39,39),(1526,39,39),(1527,39,39),(1528,39,39),(1529,39,39),(1530,39,39),(1531,39,39),(1532,39,39),(1533,39,39),(1534,39,39),(1535,39,39),(1536,39,39),(1537,39,39),(1538,39,39),(1539,39,39),(1540,39,39),(1541,39,39),(1542,39,39),(1543,39,39),(1544,39,39),(1545,39,39),(1546,39,39),(1547,39,39),(1548,39,39),(1549,39,39),(1550,39,39),(1551,39,39),(1552,39,39),(1553,39,39),(1554,39,39),(1555,39,39),(1556,39,39),(1557,39,39),(1558,39,39),(1559,39,39),(1560,39,39),(1561,39,39),(1562,39,39),(1563,39,39),(1564,39,39),(1565,39,39),(1566,39,39),(1567,39,39),(1568,39,39),(1569,39,39),(1570,39,39),(1571,39,39),(1572,39,39),(1573,39,39),(1574,39,39),(1575,39,39),(1576,39,39),(1577,39,39),(1578,39,39),(1579,39,39),(1580,39,39),(1581,39,39),(1582,39,39),(1583,39,39),(1584,39,39),(1585,39,39),(1586,39,39),(1587,39,39),(1588,39,39),(1589,39,39),(1590,39,39),(1591,39,39),(1592,39,39),(1593,39,39),(1594,39,39),(1595,39,39),(1596,39,39),(1597,39,39),(1598,39,39),(1599,39,39),(1600,39,39),(1601,39,39),(1602,39,39),(1603,39,39),(1604,39,39),(1605,39,39),(1606,39,39),(1607,39,39),(1608,39,39),(1609,39,39),(1610,39,39),(1611,39,39),(1612,39,39),(1613,39,39),(1614,39,39),(1615,39,39),(1616,39,39),(1617,39,39),(1618,39,39),(1619,39,39),(1620,39,39),(1621,39,39),(1622,39,39),(1623,39,39),(1624,39,39),(1625,39,39),(1626,39,39),(1627,39,39),(1628,39,39),(1629,39,39),(1630,39,39),(1631,39,39),(1632,39,39),(1633,39,39),(1634,39,39),(1635,39,39),(1636,39,39),(1637,39,39),(1638,39,39),(1639,39,39),(1640,39,39),(1641,39,39),(1642,39,39),(1643,39,39),(1644,39,39),(1645,39,39),(1646,39,39),(1647,39,39),(1648,39,39),(1649,39,39),(1650,39,39),(1651,39,39),(1652,39,39),(1653,39,39),(1654,39,39),(1655,39,39),(1656,39,39),(1657,39,39),(1658,39,39),(1659,39,39),(1660,39,39),(1661,39,39),(1662,39,39),(1663,39,39),(1664,39,39),(1665,39,39),(1666,39,39),(1667,39,39),(1668,39,39),(1669,39,39),(1670,39,39),(1671,39,39),(1672,39,39),(1673,39,39),(1674,39,39),(1675,39,39),(1676,39,39),(1677,39,39),(1678,39,39),(1679,39,39),(1680,39,39),(1681,39,39),(1682,39,39),(1683,39,39),(1684,39,39),(1685,39,39),(1686,39,39),(1687,39,39),(1688,39,39),(1689,39,39),(1690,39,39),(1691,39,39),(1692,39,39),(1693,39,39),(1694,39,39),(1695,39,39),(1696,39,39),(1697,39,39),(1698,39,39),(1699,39,39),(1700,70,70),(1701,69,69),(1702,69,69),(1703,69,69),(1704,69,69),(1705,69,69),(1706,69,69),(1707,69,69),(1708,69,69),(1709,69,69),(1710,69,69),(1711,69,69),(1712,69,69),(1713,69,69),(1714,69,69),(1715,69,69),(1716,69,69),(1717,69,69),(1718,69,69),(1719,69,69),(1720,69,69),(1721,69,69),(1722,69,69),(1723,69,69),(1724,69,69),(1725,69,69),(1726,69,69),(1727,69,69),(1728,69,69),(1729,69,69),(1730,69,69),(1731,69,69),(1732,69,69),(1733,69,69),(1734,69,69),(1735,69,69),(1736,69,69),(1737,69,69),(1738,69,69),(1739,69,69),(1740,69,69),(1741,69,69),(1742,69,69),(1743,69,69),(1744,69,69),(1745,69,69),(1746,69,69),(1747,69,69),(1748,69,69),(1749,69,69),(1750,69,69),(1751,69,69),(1752,69,69),(1753,69,69),(1754,69,69),(1755,69,69),(1756,69,69),(1757,69,69),(1758,69,69),(1759,69,69),(1760,69,69),(1761,69,69),(1762,69,69),(1763,69,69),(1764,69,69),(1765,69,69),(1766,69,69),(1767,69,69),(1768,69,69),(1769,69,69),(1770,69,69),(1771,69,69),(1772,69,69),(1773,69,69),(1774,69,69),(1775,69,69),(1776,69,69),(1777,69,69),(1778,69,69),(1779,69,69),(1780,69,69),(1781,69,69),(1782,69,69),(1783,69,69),(1784,69,69),(1785,69,69),(1786,69,69),(1787,69,69),(1788,69,69),(1789,69,69),(1790,69,69),(1791,69,69),(1792,69,69),(1793,69,69),(1794,69,69),(1795,69,69),(1796,69,69),(1797,69,69),(1798,69,69),(1799,69,69),(1800,39,39),(1801,49,49),(1802,49,49),(1803,49,49),(1804,49,49),(1805,49,49),(1806,49,49),(1807,49,49),(1808,49,49),(1809,49,49),(1810,49,49),(1811,49,49),(1812,49,49),(1813,49,49),(1814,36,36),(1815,49,49),(1816,49,49),(1817,49,49),(1818,49,49),(1819,49,49),(1820,46,46),(1821,49,49),(1822,49,49),(1823,49,49),(1824,49,49),(1825,49,49),(1826,49,49),(1827,49,49),(1828,49,49),(1829,49,49),(1830,49,49),(1831,49,49),(1832,49,49),(1833,49,49),(1834,49,49),(1835,49,49),(1836,49,49),(1837,49,49),(1838,49,49),(1839,49,49),(1840,49,49),(1841,49,49),(1842,49,49),(1843,49,49),(1844,49,49),(1845,49,49),(1846,49,49),(1847,49,49),(1848,49,49),(1849,49,49),(1850,49,49),(1851,49,49),(1852,49,49),(1853,49,49),(1854,49,49),(1855,49,49),(1856,49,49),(1857,49,49),(1858,49,49),(1859,49,49),(1860,49,49),(1861,49,49),(1862,49,49),(1863,49,49),(1864,49,49),(1865,49,49),(1866,49,49),(1867,49,49),(1868,49,49),(1869,49,49),(1870,49,49),(1871,49,49),(1872,49,49),(1873,49,49),(1874,49,49),(1875,49,49),(1876,49,49),(1877,49,49),(1878,49,49),(1879,49,49),(1880,49,49),(1881,49,49),(1882,49,49),(1883,49,49),(1884,49,49),(1885,49,49),(1886,49,49),(1887,49,49),(1888,49,49),(1889,49,49),(1890,49,49),(1891,49,49),(1892,49,49),(1893,49,49),(1894,49,49),(1895,49,49),(1896,49,49),(1897,49,49),(1898,49,49),(1899,49,49),(1900,49,49),(1901,49,49),(1902,49,49),(1903,49,49),(1904,49,49),(1905,49,49),(1906,49,49),(1907,49,49),(1908,49,49),(1909,49,49),(1910,49,49),(1911,49,49),(1912,49,49),(1913,49,49),(1914,49,49),(1915,49,49),(1916,49,49),(1917,49,49),(1918,49,49),(1919,49,49),(1920,49,49),(1921,49,49),(1922,49,49),(1923,49,49),(1924,49,49),(1925,49,49),(1926,49,49),(1927,49,49),(1928,49,49),(1929,49,49),(1930,49,49),(1931,49,49),(1932,49,49),(1933,49,49),(1934,49,49),(1935,49,49),(1936,49,49),(1937,49,49),(1938,49,49),(1939,49,49),(1940,49,49),(1941,49,49),(1942,49,49),(1943,49,49),(1944,49,49),(1945,49,49),(1946,49,49),(1947,49,49),(1948,49,49),(1949,49,49),(1950,49,49),(1951,49,49),(1952,49,49),(1953,49,49),(1954,49,49),(1955,49,49),(1956,49,49),(1957,49,49),(1958,49,49),(1959,49,49),(1960,49,49),(1961,49,49),(1962,49,49),(1963,49,49),(1964,49,49),(1965,49,49),(1966,49,49),(1967,49,49),(1968,49,49),(1969,49,49),(1970,49,49),(1971,49,49),(1972,49,49),(1973,49,49),(1974,49,49),(1975,49,49),(1976,49,49),(1977,49,49),(1978,49,49),(1979,49,49),(1980,49,49),(1981,49,49),(1982,49,49),(1983,49,49),(1984,49,49),(1985,49,49),(1986,49,49),(1987,49,49),(1988,49,49),(1989,49,49),(1990,49,49),(1991,49,49),(1992,49,49),(1993,49,49),(1994,49,49),(1995,49,49),(1996,49,49),(1997,49,49),(1998,49,49),(1999,49,49);