diff options
Diffstat (limited to 'src/main/resources/data-sqlserver.sql')
| -rw-r--r-- | src/main/resources/data-sqlserver.sql | 4 |
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'); |