diff --git a/GMap.NET.WindowsMobile/Properties/Resources.resx b/GMap.NET.WindowsMobile/Properties/Resources.resx deleted file mode 100644 --- a/GMap.NET.WindowsMobile/Properties/Resources.resx +++ /dev/null @@ -1,162 +0,0 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 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