CREATE DATABASE IF NOT EXISTS `Database_1`;

USE `Database_1`;

CREATE TABLE `centros_costos` (
  `codigo` varchar(15) NOT NULL,
  `key_` varchar(10) NOT NULL,
  `parent` varchar(10) NOT NULL,
  `text` varchar(60) NOT NULL,
  `image` varchar(12) NOT NULL,
  `nivel_1` char(3) NOT NULL,
  `IDcos` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `cr_expedi` varchar(10) NOT NULL,
  `cr_provei` varchar(10) NOT NULL,
  `siglas` varchar(54) NOT NULL,
  PRIMARY KEY(`codigo`),
  INDEX `IDcos`(`IDcos`)
)
ENGINE=INNODB
COMMENT = 'InnoDB free: 249856 kB';

CREATE TABLE `centros_nivel_1` (
  `codigo` char(3) NOT NULL,
  `descripcion` varchar(60),
  PRIMARY KEY(`codigo`)
)
ENGINE=INNODB
COMMENT = 'InnoDB free: 249856 kB';

CREATE TABLE `dbaccion` (
  `codigo` char(2) NOT NULL,
  `descripcion` varchar(35) NOT NULL,
  `plazos` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY(`codigo`)
)
ENGINE=INNODB
COMMENT = 'InnoDB free: 249856 kB';

CREATE TABLE `dbdocdig` (
  `descripcion_documento` varchar(60) NOT NULL,
  `cent_cost_origen` varchar(15) NOT NULL,
  `fch_hor_reg_documento` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `documento_textual` text NOT NULL,
  `usuario_sistema` varchar(10) NOT NULL,
  `Id_Row` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY(`descripcion_documento`),
  INDEX `Id_Row`(`Id_Row`),
  FULLTEXT INDEX `IDX_dbdocdig_DescripcionDocumento_DocumentoTextual`(`descripcion_documento`, `documento_textual`)
)
ENGINE=MYISAM
ROW_FORMAT=dynamic;

CREATE TABLE `dbopcmen` (
  `id_row` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `prompt` varchar(60) NOT NULL,
  `levelname` varchar(10) NOT NULL,
  `itemnum` char(3) NOT NULL,
  PRIMARY KEY(`id_row`)
)
ENGINE=INNODB
COMMENT = 'InnoDB free: 249856 kB';

CREATE TABLE `dbtipdoc` (
  `codigo` char(2) NOT NULL,
  `descri` char(20) NOT NULL,
  PRIMARY KEY(`codigo`)
)
ENGINE=INNODB
COMMENT = 'InnoDB free: 249856 kB';

CREATE TABLE `dbtiptra` (
  `tracod` char(3) NOT NULL,
  `trades` varchar(60) NOT NULL,
  `traplz` int(3) NOT NULL DEFAULT '0',
  PRIMARY KEY(`tracod`)
)
ENGINE=INNODB
COMMENT = 'InnoDB free: 249856 kB';

CREATE TABLE `nstdversion` (
  `tipo_obj` char(3) NOT NULL,
  `version` varchar(5),
  PRIMARY KEY(`tipo_obj`)
)
ENGINE=INNODB
COMMENT = 'InnoDB free: 249856 kB';

CREATE TABLE `repositorio` (
  `mesa_de_partes` varchar(15) NOT NULL,
  `mp_docdsc` varchar(60) NOT NULL,
  `mp_origcd` varchar(15) NOT NULL,
  `mp_destcd` varchar(15) NOT NULL,
  `mp_doctip` char(2) NOT NULL,
  `mp_docnro` varchar(4) NOT NULL,
  `mp_docsgl` varchar(54) NOT NULL,
  `mp_docfch` date NOT NULL DEFAULT '0000-00-00',
  `mp_asunto` text NOT NULL,
  `mp_folios` int(10) NOT NULL DEFAULT '0',
  `mp_accion` char(2) NOT NULL,
  `fecha_hora_envio` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `usuario_envio` varchar(10) NOT NULL,
  `fecha_hora_recepcion` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `usuario_recepcion` varchar(10) NOT NULL,
  `flujo_documentario` text NOT NULL,
  `status_envio` char(1) NOT NULL,
  `Id_Row` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY(`mesa_de_partes`, `mp_docdsc`, `mp_origcd`, `mp_destcd`),
  INDEX `FK_repositorio_Centros_Costos_3`(`mp_destcd`),
  INDEX `FK_repositorio_Centros_Costos_1`(`mp_origcd`),
  INDEX `FK_repositorio_accion`(`mp_accion`),
  INDEX `FK_repositorio_dbtipdoc_codigo`(`mp_doctip`),
  INDEX `Id_Row`(`Id_Row`),
  CONSTRAINT `FK_repositorio_accion` FOREIGN KEY (`mp_accion`)
    REFERENCES `dbaccion`(`codigo`)
    ON DELETE RESTRICT
    ON UPDATE CASCADE,
  CONSTRAINT `FK_repositorio_Centros_Costos_1` FOREIGN KEY (`mp_origcd`)
    REFERENCES `centros_costos`(`codigo`)
    ON DELETE RESTRICT
    ON UPDATE CASCADE,
  CONSTRAINT `FK_repositorio_Centros_Costos_2` FOREIGN KEY (`mesa_de_partes`)
    REFERENCES `centros_costos`(`codigo`)
    ON DELETE RESTRICT
    ON UPDATE CASCADE,
  CONSTRAINT `FK_repositorio_Centros_Costos_3` FOREIGN KEY (`mp_destcd`)
    REFERENCES `centros_costos`(`codigo`)
    ON DELETE RESTRICT
    ON UPDATE CASCADE,
  CONSTRAINT `FK_repositorio_dbtipdoc_codigo` FOREIGN KEY (`mp_doctip`)
    REFERENCES `dbtipdoc`(`codigo`)
    ON DELETE RESTRICT
    ON UPDATE CASCADE
)
ENGINE=INNODB
COMMENT = 'InnoDB free: 249856 kB; (`mp_accion`) REFER `tcentral/dbaccion`(`codigo`) ON UPDATE CASCADE; (`mp_origcd`) REFER `tcentral/centros_costos`(`codigo`) ON UPDATE CASCADE; (`mesa_de_partes`) REFER `tcentral/centros_costos`(`codigo`) ON UPDATE CASCADE; (`mp_destcd`) REFER `tcentral/centros_costos`(`codigo`) ON UPDATE CASCADE; (`mp_doctip`) REFER `tcentral/dbtipdoc`(`codigo`) ON UPDATE CASCADE';

CREATE TABLE `serverodcs` (
  `Id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `Server_odc` varchar(40) NOT NULL,
  `DataBase_odc` varchar(20) NOT NULL,
  `User_odc` varchar(20) NOT NULL,
  `Password_odc` varchar(20) NOT NULL,
  `Odc` varchar(50) NOT NULL,
  `Responsable` varchar(50) NOT NULL,
  `Estado` varchar(20) NOT NULL,
  `Flg` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY(`Id`)
)
ENGINE=INNODB
COMMENT = 'InnoDB free: 249856 kB';

CREATE TABLE `usuario_app` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `usr_acceso` varchar(20) NOT NULL,
  `pwd_acceso` varchar(20) NOT NULL,
  `usr_aplicacion` varchar(20) NOT NULL,
  `pwd_aplicacion` varchar(20) NOT NULL,
  `usr_ftp` varchar(20) NOT NULL,
  `pwd_ftp` varchar(20) NOT NULL,
  `server_ftp` varchar(40) NOT NULL,
  `path_ftp` varchar(50) NOT NULL,
  `web_ftp` varchar(50) NOT NULL,
  PRIMARY KEY(`id`)
)
ENGINE=INNODB
COMMENT = 'InnoDB free: 249856 kB';