[SOLVED] How to add new column?
Hello!
Any ideas how to add a new column to an existing table?
What I did so far:
Any ideas how to add a new column to an existing table?
What I did so far:
- Updated the schema to add a new column:
- Generated migration files, and it did create the correct SQL statement, but for some reason I don't understand, it is not applicable:```/*SQLite does not support "Set default to column" out of the box, we do not generate automatic migration for that, so it has to be done manuallyPlease refer to: https://www.techonthenet.com/sqlite/tables/alter_table.php https://www.sqlite.org/lang_altertable.html https://stackoverflow.com/questions/2083543/modify-a-columns-type-in-sqlite3Due to that we don't generate migration automatically and it has to be done manually*/--> statement-breakpointALTER TABLE sfdc_opportunities ADD `website` text;```
- Running the migration fails with:```RangeError: The supplied SQL string contains no statements at Database.prepare```I'm using `'@libsql/client'` connected to Turso.