repos / pico

commit

2023f81

parent

3e5777a

author

Eric Bower

date

2024-02-19 02:10:02 +0000 UTC

fix: pico+ sql

 1@@ -5,7 +5,7 @@ SELECT id FROM app_users WHERE name = '{user}';
 2 -- amount should be multiplied by 1 million and then later divded by the same
 3 -- https://stackoverflow.com/a/51238749
 4 INSERT INTO payment_history (user_id, payment_type, amount, data)
 5-VALUES ('', 'stripe', 20 * 1000000, '{"notes": ""}'::jsonb) RETURNING id;
 6+VALUES ('', 'stripe', 20 * 1000000, '{"notes": "", "tx_id":""}'::jsonb) RETURNING id;
 7 
 8 -- enable pico+ features
 9 
10@@ -24,7 +24,7 @@ VALUES ('', 'imgs', '{"storage_max":2000000000}'::jsonb, now() + '1 year'::inter
11 -- storage max is 1gb
12 -- file max is 50mb
13 INSERT INTO feature_flags (user_id, name, data, expires_at)
14-VALUES ('', 'pgs', '{"storage_max":2000000000, "file_max":50000000}'::jsonb, now() + '1 year'::interval);
15+VALUES ('', 'prose', '{"storage_max":1000000000, "file_max":50000000}'::jsonb, now() + '1 year'::interval);
16 
17 -- tuns
18 INSERT INTO feature_flags (user_id, name, expires_at)