CREATE TABLE `contract_document_statuses_$mid` (
  `id` INTEGER  NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(128)  NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `contract_document_types_$mid` (
  `id` INTEGER  NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(128)  NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `contract_document_journal_$mid` (
  `id` INTEGER  NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(255)  NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `contract_document_$mid` (
  `id` INTEGER  NOT NULL AUTO_INCREMENT,
  `cid` INTEGER  NOT NULL,
  `journal_id` INTEGER  NOT NULL,
  `type` INTEGER  NOT NULL,
  `title` VARCHAR(255) NOT NULL,
  `date` TIMESTAMP  NOT NULL,
  `user` INTEGER  NOT NULL,
  `comment` TEXT  NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `contract_document_status_list_$mid` (
  `id` INTEGER  NOT NULL AUTO_INCREMENT,
  `id_document` INTEGER  NOT NULL,
  `date` TIMESTAMP  NOT NULL,
  `status` INTEGER  NOT NULL,
  `user` INTEGER  NOT NULL,
  `comment` TEXT  NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `filestorage_files_list_$mid` (
  `id` INTEGER  NOT NULL AUTO_INCREMENT,
  `id_owner` INTEGER  NOT NULL,
  `title` VARCHAR(255)  NOT NULL,
  `size` INTEGER  NOT NULL,
  `date` TIMESTAMP  NOT NULL,
  `user` INTEGER  NOT NULL,
  `comment` TEXT  NOT NULL,
  PRIMARY KEY (`id`)
);

ALTER TABLE `contract_document_$mid` ADD `journal_id` INTEGER  NOT NULL;