top | item 46902725 (no title) Akronymus | 24 days ago So you have to drop and re-add a column when adding foreign keys? discuss order hn newest lun3x|24 days ago The SQLite docs have a section about it, the idea is: 1. Create new table with foreign key constraint 2. Copy data from old to new 3. Drop old table 4. Rename new table to old name
lun3x|24 days ago The SQLite docs have a section about it, the idea is: 1. Create new table with foreign key constraint 2. Copy data from old to new 3. Drop old table 4. Rename new table to old name
lun3x|24 days ago