Skip to content

Instantly share code, notes, and snippets.

@AngelCruzL

AngelCruzL/usuarios.sql

Created January 10, 2023 03:05
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save AngelCruzL/3788e8f5b4542f1041eb442acfd943f8 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save AngelCruzL/3788e8f5b4542f1041eb442acfd943f8 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. AngelCruzL created this gist Jan 10, 2023.
    15 changes: 15 additions & 0 deletions usuarios.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,15 @@
    CREATE TABLE UsuariosSicah (
    ID INT PRIMARY KEY IDENTITY,
    CORREO VARCHAR(60) UNIQUE,
    CONTRASENA CHAR(60) DEFAULT '$2y$10$Pjr8/W5acqok1MsaPcusR.cNQu9yDU/pWYXBjgsdP3H1XjGi8X7pa',
    NOMBRE VARCHAR(60),
    ESTATUS BIT DEFAULT 1,
    TIPO_USUARIO TINYINT DEFAULT 1,
    RESET BIT DEFAULT 1
    );

    INSERT INTO UsuariosSicah (CORREO, NOMBRE)
    VALUES ('[email protected]', 'LUIS LARA');

    INSERT INTO UsuariosSicah (CORREO, NOMBRE, RESET)
    VALUES ('[email protected]', 'Angel Cruz', 0);