- commit
- e42f99b
- parent
- bd272f7
- author
- Eric Bower
- date
- 2024-02-18 17:13:04 +0000 UTC
chore: update pico+ sql
1 files changed,
+9,
-4
R sql/pro_user.sql =>
sql/pico_plus_user.sql
+9,
-4
1@@ -7,19 +7,24 @@ SELECT id FROM app_users WHERE name = '{user}';
2 INSERT INTO payment_history (user_id, payment_type, amount, data)
3 VALUES ('', 'stripe', 20 * 1000000, '{"notes": ""}'::jsonb) RETURNING id;
4
5--- enable pro features
6+-- enable pico+ features
7
8 -- pgs
9 -- storage max is 10gb
10 -- file max is 50mb
11 INSERT INTO feature_flags (user_id, name, data, expires_at)
12-VALUES ('', 'pgs', '{"storage_max":10737418240, "file_max":52428800}'::jsonb, now() + '1 year'::interval);
13+VALUES ('', 'pgs', '{"storage_max":10000000000, "file_max":50000000}'::jsonb, now() + '1 year'::interval);
14
15 -- imgs
16--- storage max is 10gb
17+-- storage max is 2gb
18+INSERT INTO feature_flags (user_id, name, data, expires_at)
19+VALUES ('', 'imgs', '{"storage_max":2000000000}'::jsonb, now() + '1 year'::interval);
20+
21+-- prose
22+-- storage max is 1gb
23 -- file max is 50mb
24 INSERT INTO feature_flags (user_id, name, data, expires_at)
25-VALUES ('', 'imgs', '{"storage_max":10737418240, "file_max":52428800}'::jsonb, now() + '1 year'::interval);
26+VALUES ('', 'pgs', '{"storage_max":2000000000, "file_max":50000000}'::jsonb, now() + '1 year'::interval);
27
28 -- tuns
29 INSERT INTO feature_flags (user_id, name, expires_at)