 CREATE TABLE IF NOT EXISTS `ica`.`sources` (
   `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
   `jointsource_id` INT UNSIGNED NOT NULL,
+  `title_id` INT UNSIGNED NOT NULL,
   `content_id` INT UNSIGNED NOT NULL,
   `author_id` INT UNSIGNED NOT NULL,
   `type` TINYINT UNSIGNED NOT NULL,

-- -----------------------------------------------------
-- Placeholder table for view `ica`.`sources_summary`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ica`.`sources_summary` (`source_id` INT, `jointsource_id` INT, `source_type` INT, `state_id` INT, `state` INT, `content_id` INT);

-- -----------------------------------------------------
-- Placeholder table for view `ica`.`contents_langs_summary`

  INDEX `fk_sources_consts_sourcetypes1_idx` (`type` ASC),
  INDEX `fk_sources_jointsources1_idx` (`jointsource_id` ASC),
  INDEX `fk_sources_contents1_idx` (`content_id` ASC),
  INDEX `fk_sources_contents2_idx` (`title_id` ASC),
  CONSTRAINT `fk_sources_accounts1`
    FOREIGN KEY (`author_id`)
    REFERENCES `ica`.`accounts` (`id`)
