aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/data-sqlserver.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/resources/data-sqlserver.sql')
-rw-r--r--src/main/resources/data-sqlserver.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/src/main/resources/data-sqlserver.sql b/src/main/resources/data-sqlserver.sql
index bb1203a4..f5844a52 100644
--- a/src/main/resources/data-sqlserver.sql
+++ b/src/main/resources/data-sqlserver.sql
@@ -1,7 +1,11 @@
+set identity_insert users ON;
INSERT INTO users(id, nick, passw) VALUES(0, 'Anonymous', 'password');
INSERT INTO users(id, nick, passw) VALUES(2, 'juick', 'password');
INSERT INTO users(id, nick, passw) VALUES(5, 'archive', 'password');
+set identity_insert users OFF;
+set identity_insert tags ON;
INSERT INTO tags(tag_id, name) VALUES(2, 'juick');
+set identity_insert tags OFF;
INSERT INTO reactions (like_id, description) VALUES (1, 'like');
INSERT INTO reactions (like_id, description) VALUES (2, 'love');
INSERT INTO reactions (like_id, description) VALUES (3, 'lol');