aboutsummaryrefslogtreecommitdiff
path: root/src/test/resources/db/specific/mariadb/V1.999__data.sql
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2022-12-16 20:00:01 +0300
committerGravatar Vitaly Takmazov2022-12-16 20:00:01 +0300
commit546e013453ef449f0c0d3670cde4076eda8f7a5c (patch)
tree0e04c9aca008ec8b51883bb865a29cb7831c838a /src/test/resources/db/specific/mariadb/V1.999__data.sql
parent12d0e240115e8be3451c20ea899be80ad695f823 (diff)
Drop unused zero date column
Diffstat (limited to 'src/test/resources/db/specific/mariadb/V1.999__data.sql')
-rw-r--r--src/test/resources/db/specific/mariadb/V1.999__data.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/src/test/resources/db/specific/mariadb/V1.999__data.sql b/src/test/resources/db/specific/mariadb/V1.999__data.sql
new file mode 100644
index 00000000..a5db173a
--- /dev/null
+++ b/src/test/resources/db/specific/mariadb/V1.999__data.sql
@@ -0,0 +1,13 @@
+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');
+ALTER TABLE tags AUTO_INCREMENT = 10;
+ALTER TABLE users AUTO_INCREMENT = 10;
+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');