DROP TABLE IF EXISTS convenios;
CREATE TABLE convenios(
	id INT AUTO_INCREMENT PRIMARY KEY,
	clave VARCHAR(10) UNIQUE NOT NULL,
	predio INT NOT NULL,
	inicio DATE NOT NULL,
	fin DATE NOT NULL,
	valor DECIMAL(8,2) NOT NULL,
	nota TEXT NULL,
	estado INT DEFAULT(11),
	registro DATETIME DEFAULT(NOW())
);
