v2tYN26X

1create database if not exists santosepulcro character set utf8 collate utf8_general_ci;
2use santosepulcro;
3
4CREATE TABLE IF NOT EXISTS usuario(
5    idUsuario INT UNSIGNED AUTO_INCREMENT NOT NULL,
6    nomb1 VARCHAR(20) DEFAULT NULL,
7    nomb2 VARCHAR(20) DEFAULT NULL,
8    apell1 VARCHAR(20) DEFAULT NULL,
9    apell2 VARCHAR(20) DEFAULT NULL,
10    dni VARCHAR(20) DEFAULT NULL,
11    actv INT(1) UNSIGNED DEFAULT 0 NOT NULL,
12    clave VARCHAR(100) NOT NULL,
13    claveTemp VARCHAR(100),
14    claveVenc VARCHAR(100),
15    idPais INT UNSIGNED,
16    idRol INT UNSIGNED NOT NULL,
17    PRIMARY KEY (idUsuario),
18    CONSTRAINT FK_Pais FOREIGN KEY (idPais) REFERENCES pais(idPais),
19    CONSTRAINT FK_Rol FOREIGN KEY (idRol) REFERENCES rol(idRol)
20);
21CREATE TABLE IF NOT EXISTS rol(
22    idRol INT UNSIGNED AUTO_INCREMENT NOT NULL,
23    rol VARCHAR(15) NOT NULL,
24    PRIMARY KEY (idRol)
25);
26CREATE TABLE IF NOT EXISTS pais(
27    idPais INT UNSIGNED AUTO_INCREMENT NOT NULL,
28    pais VARCHAR(20) NOT NULL,
29    PRIMARY KEY (idPais)
30); 
31     
32CREATE TABLE IF NOT EXISTS rol(
33    idRol INT UNSIGNED AUTO_INCREMENT NOT NULL,
34    rol VARCHAR(15) NOT NULL,
35    PRIMARY KEY (idRol)
36);
37CREATE TABLE IF NOT EXISTS pais(
38    idPais INT UNSIGNED AUTO_INCREMENT NOT NULL,
39    pais VARCHAR(20) NOT NULL,
40    PRIMARY KEY (idPais)
41);
42CREATE TABLE IF NOT EXISTS usuario(
43    idUsuario INT UNSIGNED AUTO_INCREMENT NOT NULL,
44    nomb1 VARCHAR(20) DEFAULT NULL,
45    nomb2 VARCHAR(20) DEFAULT NULL,
46    apell1 VARCHAR(20) DEFAULT NULL,
47    apell2 VARCHAR(20) DEFAULT NULL,
48    dni VARCHAR(20) DEFAULT NULL,
49    actv INT(1) UNSIGNED DEFAULT 0 NOT NULL,
50    clave VARCHAR(100) NOT NULL,
51    claveTemp VARCHAR(100),
52    claveVenc VARCHAR(100),
53    idPais INT UNSIGNED,
54    idRol INT UNSIGNED NOT NULL,
55    PRIMARY KEY (idUsuario),
56    CONSTRAINT FK_Pais FOREIGN KEY (idPais) REFERENCES pais(idPais),
57    CONSTRAINT FK_Rol FOREIGN KEY (idRol) REFERENCES rol(idRol)
58);