diff options
author | Vitaly Takmazov | 2023-01-27 19:43:42 +0300 |
---|---|---|
committer | Vitaly Takmazov | 2023-01-27 20:33:17 +0300 |
commit | c2fe259c1dc558945ea8beb82cdfe5891791564c (patch) | |
tree | 148273d483428d0d9caf03e83267cbcc7cbd653d /src/main/resources/data-sqlserver.sql | |
parent | 2db415ce42fb96059b6d7fce4cf4ce078a62680e (diff) |
db: initial SQL Server schema
* only schema is worked
Diffstat (limited to 'src/main/resources/data-sqlserver.sql')
-rw-r--r-- | src/main/resources/data-sqlserver.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/src/main/resources/data-sqlserver.sql b/src/main/resources/data-sqlserver.sql new file mode 100644 index 00000000..bb1203a4 --- /dev/null +++ b/src/main/resources/data-sqlserver.sql @@ -0,0 +1,11 @@ +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'); +INSERT INTO tags(tag_id, name) VALUES(2, 'juick'); +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'); +INSERT INTO reactions (like_id, description) VALUES (4, 'hmm'); +INSERT INTO reactions (like_id, description) VALUES (5, 'angry'); +INSERT INTO reactions (like_id, description) VALUES (6, 'uhblya'); +INSERT INTO reactions (like_id, description) VALUES (7, 'ugh'); |