SET FOREIGN_KEY_CHECKS=0;

CREATE DATABASE IF NOT EXISTS control_usuario;

USE control_usuario;

DROP TABLE IF EXISTS comentarios;

CREATE TABLE `comentarios` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `telefono` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comenatrio` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO comentarios VALUES("1","Alex Marin","2@gmail.com","5544333","HOALALLALALAANHABHB HBHBHVGVVYVYVYVVVVVVVVVVVVVVVVV");



DROP TABLE IF EXISTS invitados;

CREATE TABLE `invitados` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ape` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `telefono` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
  `estado` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ciudad` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `especialidad` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hospital` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO invitados VALUES("1","Alex ","Matinez","alex@gmail.com","5577662233","De Mexico","Mexico","---","---");
INSERT INTO invitados VALUES("2","Ricardo Mls","Matinez","rik@gmail.com","5544336677","De Mexico","Mexico","---","---");
INSERT INTO invitados VALUES("3","Jorge Milos","Lopez","jmilos@gmail.com","55446677","De Mexico","Mexico","---","---");
INSERT INTO invitados VALUES("4","Alexis Marin","Lopez","Alex@gmail.com","565544522","De Mexico","Mexico","---","---");
INSERT INTO invitados VALUES("5","Alexis","Lopez","RH@frmedical.com.mx","558445199344","CDMX","De mexico","1","1");
INSERT INTO invitados VALUES("6","Itzel","Lopez","RH@frmedical.com.mx","558445222","Chiapas","De mexico","1","1");
INSERT INTO invitados VALUES("7","Itzel","Lopez","rdj1@frmedical.com.mx","5655334422","CDMX","De mexico","1","1");
INSERT INTO invitados VALUES("8","Itzel","Jimenez","rd11@frmedical.com.mx","1122222","Baja California","De mexico","1","1");
INSERT INTO invitados VALUES("9","Miguel","Martinez","m@frmedical.com.mx","5677554420","Michoacán","De mexico","1","1");



DROP TABLE IF EXISTS privilegio;

CREATE TABLE `privilegio` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contraseña` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO privilegio VALUES("1","admin","admin");



DROP TABLE IF EXISTS usuarios;

CREATE TABLE `usuarios` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `usuario` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contraseña` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `telefono` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
  `extension` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `categoria` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `area` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `puesto` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sede` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO usuarios VALUES("1","Alexis","soporteti","soporteti@frmedical.com.mx","medical123","5584451993","52","1","Sistemas","SoporteTI","Satelite");
INSERT INTO usuarios VALUES("6","Diana","ventas","diana@frmedical.com.mx","frmedical","5566442211","52","1","Ventas","Ventas","Satelite");



SET FOREIGN_KEY_CHECKS=1;