forked from Subscribie/subscribie
-
Notifications
You must be signed in to change notification settings - Fork 0
/
seed.sql
44 lines (34 loc) · 1.41 KB
/
seed.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
INSERT INTO user (id, email, password) VALUES
(1, 'admin@example.com', 'pbkdf2:sha256:150000$w0mLxLJU$e6f21a4b45a0d10286766f33057834949148eb2b3ecc4ec1a136d619f82034d0');
INSERT INTO company (id, created_at, name, slogan) VALUES
(1, datetime(), "Soap Subscription", "Sqeaky clean!");
INSERT INTO item
(id, created_at, archived, uuid, title, monthly_price, sell_price, days_before_first_charge)
VALUES(1, datetime(), 0, '840500cb-c663-43e6-a632-d8521bb14c42', 'Hair Gel', 599, 100, 0);
INSERT INTO item
(id, created_at, archived, uuid, title, monthly_price, sell_price, days_before_first_charge)
VALUES(2, datetime(), 0, '91547595-6dac-40ab-b789-924656f28c94', 'Bath Soaps', 1099, 500, 0);
INSERT INTO item_requirements (
id, created_at, item_id, instant_payment,
subscription)
VALUES
(1, datetime(), 1, 1, 1),
(2, datetime(), 2, 1, 1);
INSERT INTO item_selling_points (
id, created_at, point, item_id
)
VALUES
( 1, datetime(), "Homemade", 1),
( 2, datetime(), "High Quality", 1),
( 3, datetime(), "Smooth", 1),
( 4, datetime(), "Pack of 5", 2),
( 5, datetime(), "Luxury soaps", 2),
( 6, datetime(), "Assorted scents", 2);
INSERT INTO integration (
tawk_active, tawk_property_id)
VALUES (0, 'example');
INSERT INTO module (
name, src
)
VALUES ('module_seo_page_title', 'https://github.com/Subscribie/module-seo-page-title.git');
INSERT INTO module (name, src) VALUES ('module_pages', 'https://github.com/Subscribie/module-pages.git');