Spaces:

Catalna
/

ginchiee-bot

Running on Zero

ginchiee-bot / database /migrations /0002_identity_by_default.sql

feat: switch to Postgres, add intent router and a warmer persona

1fcc069 29 days ago

740 Bytes

-- 0002_identity_by_default.sql
--
-- GENERATED ALWAYS AS IDENTITY rejects explicit id values, which the SQLite
-- data migration requires (it preserves the original row ids so conversation
-- ordering and foreign keys stay intact).
--
-- GENERATED BY DEFAULT keeps auto-generation for normal inserts while still
-- allowing an explicit id, which is what a restore/seeding workflow needs.

ALTER TABLE diet_profiles   ALTER COLUMN id SET GENERATED BY DEFAULT;
ALTER TABLE meal_schedules  ALTER COLUMN id SET GENERATED BY DEFAULT;
ALTER TABLE food_logs       ALTER COLUMN id SET GENERATED BY DEFAULT;
ALTER TABLE conversations   ALTER COLUMN id SET GENERATED BY DEFAULT;
ALTER TABLE user_activities ALTER COLUMN id SET GENERATED BY DEFAULT;

	-- 0002_identity_by_default.sql
	--
	-- GENERATED ALWAYS AS IDENTITY rejects explicit id values, which the SQLite
	-- data migration requires (it preserves the original row ids so conversation
	-- ordering and foreign keys stay intact).
	--
	-- GENERATED BY DEFAULT keeps auto-generation for normal inserts while still
	-- allowing an explicit id, which is what a restore/seeding workflow needs.

	ALTER TABLE diet_profiles ALTER COLUMN id SET GENERATED BY DEFAULT;
	ALTER TABLE meal_schedules ALTER COLUMN id SET GENERATED BY DEFAULT;
	ALTER TABLE food_logs ALTER COLUMN id SET GENERATED BY DEFAULT;
	ALTER TABLE conversations ALTER COLUMN id SET GENERATED BY DEFAULT;
	ALTER TABLE user_activities ALTER COLUMN id SET GENERATED BY DEFAULT;