qwert

--
-- Estructura de tabla para la tabla `account`
--

CREATE TABLE `account` (
  `correo` varchar(45) NOT NULL,
  `password` varchar(45) NOT NULL,
  `salt` varchar(45) NOT NULL,
  PRIMARY KEY  (`correo`),
  KEY `fk_correo_idx` (`correo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcar la base de datos para la tabla `account`
--

INSERT INTO `account` VALUES ('drigox90rih@gmail.com', '1805c7c0378e17f857a3d3f1d616aa4e38928750', '2PR3JU4TRZ');
INSERT INTO `account` VALUES ('prueba@test.cl', '7c222fb2927d828af22f592134e8932480637c0d', 'WU9AA1X95N');
INSERT INTO `account` VALUES ('rifacodemakers2015@gmail.com', 'ac1ab23d6288711be64a25bf13432baf1e60b2bd', '1NTKPO6NGW');
INSERT INTO `account` VALUES ('rodiaz@openmailbox.org', '4551b2d552b0795735b70411d13d6b5ad82d6b8c', '4I72ZDPDBJ');
INSERT INTO `account` VALUES ('rodrigo.ediaz.f@gmail.com', '7c222fb2927d828af22f592134e8932480637c0d', 'XQU2TYWX0W');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `user`
--

CREATE TABLE `user` (
  `iduser` int(11) unsigned NOT NULL auto_increment,
  `correo` varchar(45) NOT NULL,
  `rut` varchar(45) NOT NULL,
  `nombres` varchar(45) NOT NULL,
  `fecha_nacimiento` date NOT NULL,
  `apellido_paterno` varchar(45) NOT NULL,
  `apellido_materno` varchar(45) NOT NULL,
  `telefono_personal` varchar(12) default NULL,
  `ciudad` varchar(45) NOT NULL,
  PRIMARY KEY  (`iduser`),
  UNIQUE KEY `rut_UNIQUE` (`rut`),
  UNIQUE KEY `correo_UNIQUE` (`correo`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

--
-- Volcar la base de datos para la tabla `user`
--

INSERT INTO `user` VALUES (1, 'rodiaz@openmailbox.org', '11111111-1', 'Estevan Rodrick', '1996-01-20', 'Dias', 'Flors', '4443241', 'Osorno');
INSERT INTO `user` VALUES (2, 'drigox90rih@gmail.com', '17693225-2', 'Rodrigo Esteban', '1990-09-13', 'Díaz', 'Flores', '42055572', 'Valdivia');
INSERT INTO `user` VALUES (3, 'rifacodemakers2015@gmail.com', '23478743-3', 'Mega', '1995-03-06', 'Gran', 'Rifa', '2345634', 'Puerto Montt');
INSERT INTO `user` VALUES (11, 'rodrigo.ediaz.f@gmail.com', '17232322-2', 'Rodada', '1991-07-10', 'PApasla', 'EWAds', '1234567543', 'Vasldas');
INSERT INTO `user` VALUES (12, 'prueba@test.cl', '1111111-1', 'Prueba', '2015-03-18', 'DeRut', 'FechaTel', '03-1234567', 'TestCity');

--
-- Filtros para las tablas descargadas (dump)
--

--
-- Filtros para la tabla `account`
--
ALTER TABLE `account`
  ADD CONSTRAINT `account_ibfk_1` FOREIGN KEY (`correo`) REFERENCES `user` (`correo`) ON DELETE CASCADE ON UPDATE CASCADE;