itf/migrations/sqldiff250712.sql

drop table itfprofiles_production;
drop table itfprofiles_theatregroup;
drop table itfprofiles_play;

CREATE TABLE `itfprofiles_person_languages` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `person_id` integer NOT NULL,
    `language_id` integer NOT NULL,
    UNIQUE (`person_id`, `language_id`)
)
;

BEGIN;
-- Application: itfprofiles
-- Model: Location
ALTER TABLE `itfprofiles_location`
	ADD `content_type_id` integer;
ALTER TABLE `itfprofiles_location`
	ADD `object_id` integer UNSIGNED;
CREATE INDEX `itfprofiles_location_content_type_id_idx`
	ON `itfprofiles_location` (`content_type_id`);
COMMIT;