Instruction file imported from andreburto/copilot_collaginator (.github/instructions/sqlite.instructions.md). Copyright stays with the author.

SQLite Initialization Instructions

Create init.sql file with the following SQL commands to set up the database schema and initial data.

COLLAGE TABLE

Create a table named collage with the following columns:

• id: A varchar column that serves as the primary key.
• date_created: A datetime column that cannot be null.

IMAGE TABLE

Create a table named image with the following columns:

• id: A varchar column that serves as the primary key.
• collage_id: A varchar column that cannot be null and references the id column in the collage table.
• image_url: A varchar column that cannot be null.
• position: An varchar column that cannot be null.
• rotation: An integer column that cannot be null.
• date_created: A datetime column that cannot be null.

SQLite File Rules

• Ensure that foreign key constraints are properly set between the image and collage tables.
• Use appropriate data types for each column as specified. "thumbnailUrl": "https://example.com/path/to/thumbnail.jpg"
• Create indexes on foreign key columns to optimize query performance.
• Script should create the database file in a data directory at the project root if it does not already exist.
• Name the database file according to the DATABASE_FILE environment variable, defaulting to /app/data/database.sqlite if not specified.