Sistema de Alarma

[valealeiaef]

Copio la estructura de las tablas

Tabla usuarios:

CREATE TABLE `Usuarios` (
`userID` bigint(11) unsigned NOT NULL,
`userEstado` enum('A','B','P') COLLATE latin1_spanish_ci NOT NULL DEFAULT 'P',
`userNombre` varchar(40) COLLATE latin1_spanish_ci NOT NULL,
`userApellido` varchar(40) COLLATE latin1_spanish_ci NOT NULL,
`userPassword` varchar(32) COLLATE latin1_spanish_ci NOT NULL,
`userEmail` varchar(50) COLLATE latin1_spanish_ci NOT NULL,
`userDomicilio` varchar(60) COLLATE latin1_spanish_ci NOT NULL,
`userTelefono` varchar(25) COLLATE latin1_spanish_ci NOT NULL,
`userCelular` varchar(25) COLLATE latin1_spanish_ci DEFAULT NULL,
`pciaID` smallint(2) unsigned NOT NULL,
`usermail2` varchar(100) COLLATE latin1_spanish_ci DEFAULT NULL,
`usercel2` varchar(100) COLLATE latin1_spanish_ci DEFAULT NULL,
`userFecAlt` date NOT NULL,
`userFecMod` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`userFecBaj` date DEFAULT NULL,
PRIMARY KEY (`userID`),
KEY `userEstado` (`userEstado`),
KEY `userNombre` (`userNombre`),
KEY `userApellido` (`userApellido`),
KEY `pciaID` (`carID`),
CONSTRAINT `Usuarios_ibfk_1` FOREIGN KEY (`pciaID`) REFERENCES `Provincias` (`pciaID`) ON UPDATE CASCADE
)


Tabla Clasificación

CREATE TABLE `Clasificacion` (
`clasID` int(8) NOT NULL AUTO_INCREMENT,
`userID` bigint(11) unsigned NOT NULL,
`clasEstado` enum('A','B') COLLATE latin1_spanish_ci NOT NULL DEFAULT 'A',
`finicio` date DEFAULT '0000-00-00',
`general` varchar(50) COLLATE latin1_spanish_ci DEFAULT NULL,
`gastronomia` varchar(50) COLLATE latin1_spanish_ci DEFAULT NULL,
`politica` varchar(50) COLLATE latin1_spanish_ci DEFAULT NULL,
`finanzas` varchar(50) COLLATE latin1_spanish_ci DEFAULT NULL,
`negocios` varchar(50) COLLATE latin1_spanish_ci DEFAULT NULL,
`oportunidad` varchar(50) COLLATE latin1_spanish_ci DEFAULT NULL,
`estado` varchar(50) COLLATE latin1_spanish_ci DEFAULT NULL,

PRIMARY KEY (`clasID`),
KEY `profID` (`userID`),
CONSTRAINT `Clasificacion_ibfk_1` FOREIGN KEY (`userID`) REFERENCES `Usuarios` (`userID`)
)

Tabla Noticias

CREATE TABLE `Noticias` (
`notID` int(8) NOT NULL AUTO_INCREMENT,
`notEstado` enum('A','B','P','M') COLLATE latin1_spanish_ci NOT NULL DEFAULT 'P',
`general` varchar(50) COLLATE latin1_spanish_ci DEFAULT NULL,
`gastronomia` varchar(50) COLLATE latin1_spanish_ci DEFAULT NULL,
`politica` varchar(50) COLLATE latin1_spanish_ci DEFAULT NULL,
`finanzas` varchar(50) COLLATE latin1_spanish_ci DEFAULT NULL,
`negocios` varchar(50) COLLATE latin1_spanish_ci DEFAULT NULL,
`oportunidad` varchar(50) COLLATE latin1_spanish_ci DEFAULT NULL,
`estado` varchar(50) COLLATE latin1_spanish_ci DEFAULT NULL,
`titulo` varchar(50) COLLATE latin1_spanish_ci DEFAULT NULL,
`descripcion` varchar(50) COLLATE latin1_spanish_ci DEFAULT NULL,
`notfile` varchar(200) COLLATE latin1_spanish_ci DEFAULT NULL,
`finicio` date DEFAULT '0000-00-00',
PRIMARY KEY (`notID`))