INSERT OR IGNORE INTO miasto VALUES (1, "Wrocław", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (2, "Rybnik", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (3, "Kraków", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (4, "Opole", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (5, "Warszawa", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (6, "ZTM w Katowicach", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (7, "Gdańsk", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (8, "Białystok", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (9, "Toruń", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (10, "Łódź", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (11, "Częstochowa", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (12, "Szczecin", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (13, "Poznań", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (14, "Lublin", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (15, "Radom", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (16, "Tychy", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (17, "Bydgoszcz", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (18, "Jaworzno", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (19, "Tczew", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (20, "Zielona Góra", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (21, "Rzeszów", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (22, "Kielce", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (23, "Olsztyn", 1, 0);
INSERT OR IGNORE INTO miasto VALUES (24, "Zamość", 1, 0);

UPDATE miasto SET available = 9 WHERE _id = 1;
UPDATE miasto SET available = 5 WHERE _id = 2;
UPDATE miasto SET available = 1007010055 WHERE _id = 3;
UPDATE miasto SET available = 1 WHERE _id = 4;
UPDATE miasto SET available = 6 WHERE _id = 5;
UPDATE miasto SET available = 5 WHERE _id = 6;
UPDATE miasto SET available = 1007010052 WHERE _id = 7;
UPDATE miasto SET available = 6 WHERE _id = 8;
UPDATE miasto SET available = 7 WHERE _id = 9;
UPDATE miasto SET available = 3 WHERE _id = 10;
UPDATE miasto SET available = 2 WHERE _id = 11;
UPDATE miasto SET available = 3 WHERE _id = 12;
UPDATE miasto SET available = 3 WHERE _id = 13;
UPDATE miasto SET available = 1 WHERE _id = 14;
UPDATE miasto SET available = 2 WHERE _id = 15;
UPDATE miasto SET available = 4 WHERE _id = 16;
UPDATE miasto SET available = 1 WHERE _id = 17;
UPDATE miasto SET available = 1007010058 WHERE _id = 18;
UPDATE miasto SET available = 1 WHERE _id = 19;
UPDATE miasto SET available = 1 WHERE _id = 20;
UPDATE miasto SET available = 1 WHERE _id = 21;
UPDATE miasto SET available = 1 WHERE _id = 22;
UPDATE miasto SET available = 1 WHERE _id = 23;
UPDATE miasto SET available = 1 WHERE _id = 24;

CREATE TABLE IF NOT EXISTS preferences(key TEXT, value TEXT);
DELETE FROM preferences WHERE key = "marketversion";
INSERT OR REPLACE INTO preferences VALUES ("marketversion", "31");
