Provide database schemas and policies for app

[senpl]

Is your feature request related to a problem? Please describe.
This app will not work with default policies. Policies has to be set up for insert, update and selects. As intro it would be nice to gives user that information.

Describe the solution you'd like
Provide policies and schemas for database.

Describe alternatives you've considered
Description what and how to set up policies would also be nice.

Additional context
using upsert requires update policy, which is not set up by default and users get RLS Errors.

[hieuwu]

Hey @senpl , thank you so much for raising this. I am working on updating database schema along with script to generate dummy data for easier setup. I'll update soon
If you are discover the repository, feel free to let know if there's anything went wrong. Many thanks 👍

[hieuwu]

Hi @senpl , I have updated new database schema, with script to set up and create. Please check it out in my latest update in readme. I'm working on guideline to disable policy to make things work

[senpl]

Looks nice. Still some users my prefere exported tables in text form as rewriting from picture is error prone. In Supabase on table 3 dots and export and this could be for example in wiki.

[hieuwu]

Hi @senpl , in case you might miss this, by running the script at https://github.com/hieuwu/android-groceries-store/blob/main/supabase/postgrest/step_1_all_tables_setup.sql , all tables will be created with constraints.

If you need a text-base structure, I just added a page for that in Wiki too. Let me know if there's anything can be improved. Check it out at Database Schema Overview