diff --git a/GMap.NET.WindowsMobile/Properties/Resources.resx b/GMap.NET.WindowsMobile/Properties/Resources.resx new file mode 100644 --- /dev/null +++ b/GMap.NET.WindowsMobile/Properties/Resources.resx @@ -0,0 +1,162 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + text/microsoft-resx + + + 2.0 + + + System.Resources.ResXResourceReader, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + + System.Resources.ResXResourceWriter, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 + + + + ..\Resources\bigMarkerGreen.png;System.Drawing.Bitmap, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a + + + CREATE TABLE IF NOT EXISTS Tiles (id INTEGER NOT NULL PRIMARY KEY, X INTEGER NOT NULL, Y INTEGER NOT NULL, Zoom INTEGER NOT NULL, Type INTEGER NOT NULL, CacheTime DATETIME); +CREATE INDEX IF NOT EXISTS IndexOfTiles ON Tiles (X, Y, Zoom, Type); + +CREATE TABLE IF NOT EXISTS TilesData (id INTEGER NOT NULL PRIMARY KEY CONSTRAINT fk_Tiles_id REFERENCES Tiles(id) ON DELETE CASCADE, Tile BLOB NULL); + +-- Foreign Key Preventing insert +CREATE TRIGGER fki_TilesData_id_Tiles_id +BEFORE INSERT ON [TilesData] +FOR EACH ROW BEGIN + SELECT RAISE(ROLLBACK, 'insert on table "TilesData" violates foreign key constraint "fki_TilesData_id_Tiles_id"') + WHERE (SELECT id FROM Tiles WHERE id = NEW.id) IS NULL; +END; + +-- Foreign key preventing update +CREATE TRIGGER fku_TilesData_id_Tiles_id +BEFORE UPDATE ON [TilesData] +FOR EACH ROW BEGIN + SELECT RAISE(ROLLBACK, 'update on table "TilesData" violates foreign key constraint "fku_TilesData_id_Tiles_id"') + WHERE (SELECT id FROM Tiles WHERE id = NEW.id) IS NULL; +END; + +-- Cascading Delete +CREATE TRIGGER fkdc_TilesData_id_Tiles_id +BEFORE DELETE ON Tiles +FOR EACH ROW BEGIN + DELETE FROM TilesData WHERE TilesData.id = OLD.id; +END; + + + ..\Resources\drag_cross_67_16.png;System.Drawing.Bitmap, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a + + + ..\Resources\marker.png;System.Drawing.Bitmap, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a + + + ..\Resources\shadow50.png;System.Drawing.Bitmap, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a + + \ No newline at end of file