Installation

We made it super easy for you to push the pre-defined database schema to Supabase. Just follow these steps starting with connecting Supabase with our local development project:

1. Install the Supbase CLI by following this Setup Guide
2. In your IDE's terminal, run npx supabase login. It will say "Hello from Supabase! Press Enter to open browser and login automatically.". So, press enter. A browser window will log you in.
3. Next, run npx supabase link and choose the project you created. It will ask you for your database password which you created acouple minutes ago (and hopefully remembered).
4. Next, run npx supabase db push --linked --include-seed. It will ask you: "Do you want to push these migrations to the remote database? • 20240701155049_initial_structure.sql" Answer Y. This will setup your database structure from the migration file we created for you.
5. Check here if your tables are existing: Table Editor
6. Check here if your buckets are existing: Storage Buckets
7. While you are in the storage buckets, drag and drop your default blog post images to blog_images. The default blog images are located in public/img/blog/. Per default, there are 4 images (breaking-news, industry-news, og_1200x630 and placeholder.png). Upload your photos via the Upload files button or drag & drop them from your local folder (NOT from VS Code - this will not work.)

If the Tables or the Storage Buckets are not there and you have not received an error message, you can also just copy & paste the content of the files 20240701155049_initial_structure.sql AND seed.sql, both in the /supabase folder, into the SQL Editor