aboutsummaryrefslogtreecommitdiff
path: root/backend/fixtures.sql
diff options
context:
space:
mode:
Diffstat (limited to 'backend/fixtures.sql')
-rw-r--r--backend/fixtures.sql17
1 files changed, 17 insertions, 0 deletions
diff --git a/backend/fixtures.sql b/backend/fixtures.sql
new file mode 100644
index 0000000..0a2dedb
--- /dev/null
+++ b/backend/fixtures.sql
@@ -0,0 +1,17 @@
+INSERT INTO
+ users(email, name, password_hash)
+VALUES
+ ('john@mail.com', 'John', '$2b$10$Qy8lqrTqHdzwLZwsqvO09eMwehA.vti.AGwPVj/pZYL94Ni6zozT2'),
+ ('lisa@mail.com', 'Lisa', '$2b$10$Qy8lqrTqHdzwLZwsqvO09eMwehA.vti.AGwPVj/pZYL94Ni6zozT2');
+
+INSERT INTO
+ maps(id, name)
+VALUES
+ ('SZj90bEkbSmjEDv7l6BD-', 'France');
+
+INSERT INTO
+ markers(id, map_id, name, lat, lng, color)
+VALUES
+ ('k3OcuT_7PwNyIxW7etb4Z', 'SZj90bEkbSmjEDv7l6BD-', 'Paris', 48.857487002645485, 2.3510742187500004, '#3584e4'),
+ ('ilaX_3aVFfgFTc-sRO4F7', 'SZj90bEkbSmjEDv7l6BD-', 'Bordeaux', 44.855868807357275, -0.5932617187500001, '#3584e4'),
+ ('Ciob_GpDrhlFmFnV2KkMh', 'SZj90bEkbSmjEDv7l6BD-', 'Marseille', 43.30119623257966, 5.394287109375, '#3584e4');