Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE [dbo].[DatabaseVersion]
- (
- [MajorVersionNumber] [int] NOT NULL,
- [MinorVersionNumber] [int] NOT NULL,
- [RevisionNumber] [int] NOT NULL
- )
- GO
- Insert DataBaseVersion (MajorVersionNumber, MinorVersionNumber, RevisionNumber) values (0, 0, 0)
- GO
- CREATE TRIGGER DataBaseVersion_Prevent_Delete
- ON DataBaseVersion INSTEAD OF DELETE
- AS
- BEGIN
- RAISERROR ('DatabaseVersion must always have one Row. (source = INSTEAD OF DELETE)', 16, 1)
- END
- GO
- CREATE TRIGGER DataBaseVersion_Prevent_Insert
- ON DataBaseVersion INSTEAD OF INSERT
- AS
- BEGIN
- RAISERROR ('DatabaseVersion must always have one Row. (source = INSTEAD OF INSERT)', 16, 1)
- END
- GO
- CREATE TABLE Settings (Key nvarchar(max), Value nvarchar(max))
- CREATE UNIQUE INDEX SettingsIDX ON Settings (Key)
- INSERT INTO Settings (Key, Value) VALUES ('Version','1');
- SELECT v.version FROM version v ORDER by v.date DESC LIMIT 1;
Add Comment
Please, Sign In to add comment