Guest User

Untitled

a guest
Jun 19th, 2018
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. //CREANDO BASE
  2.  
  3. CREATE TABLE `proyectosymfony`.`Datos_Formulario` () ENGINE = MyISAM;
  4.  
  5.  
  6. // CREANDO TABLA PARA EL FORMULARIO
  7. CREATE TABLE `proyectosymfony`.`Datos_Formulario` ( `Id_Proceso` INT NOT NULLAUTO_INCREMENT , `Descripcion` TEXT CHARACTER SET utf8mb4 COLLATEutf8mb4_spanish_ci NULL DEFAULT NULL , `Fecha` TIMESTAMP on updateCURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `Sede` TEXT CHARACTERSET utf8mb4 COLLATE utf8mb4_spanish_ci NULL DEFAULT NULL , `Presupuesto`DECIMAL NULL DEFAULT NULL , PRIMARY KEY (`Id_Proceso`)) ENGINE = MyISAM;
  8.  
  9. // CREANDO TABLA PARA REGISTRO DE USUARIOS
  10. CREATE TABLE `proyectosymfony`.`registro_usuario` () ENGINE = MyISAM;
  11.  
  12. CREATE TABLE `proyectosymfony`.`registro_usuario` ( `Id_Usuario` INT NOT NULLAUTO_INCREMENT , `Nombre` VARCHAR(100) CHARACTER SET utf8mb4 COLLATEutf8mb4_spanish_ci NULL DEFAULT NULL , `Clave` VARCHAR(15) CHARACTER SETutf8mb4 COLLATE utf8mb4_spanish_ci NULL DEFAULT NULL , `Correo` VARCHAR(100)CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NULL DEFAULT NULL , PRIMARYKEY (`Id_Usuario`)) ENGINE = MyISAM;
Add Comment
Please, Sign In to add comment