-- 02_recommended_schema.sql
CREATE TABLE IF NOT EXISTS `db_projetos` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `sis_usuario` INT UNSIGNED NULL,
  `sis_idioma` CHAR(2) NOT NULL DEFAULT 'br',
  `sis_data` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `sis_controle` TINYINT(1) NOT NULL DEFAULT 0,
  `sis_url` VARCHAR(255) NULL,
  `tipo` VARCHAR(100) NOT NULL DEFAULT 'projeto',
  `nome_projeto` VARCHAR(255) NOT NULL,
  `data1` DATE NOT NULL,
  `data2` DATE NOT NULL,
  `hora1` TIME NOT NULL DEFAULT '09:00:00',
  `hora2` TIME NOT NULL DEFAULT '18:00:00',
  `texto` TEXT NULL,
  `concluido` TINYINT UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  INDEX (`data1`), INDEX (`data2`), INDEX (`tipo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
