1 | <?php |
2 | |
3 | function bdCrea(PDO $con) |
4 | { |
5 | $con->exec( |
6 | 'CREATE TABLE IF NOT EXISTS USUARIO ( |
7 | USU_ID INTEGER, |
8 | USU_CUE TEXT NOT NULL, |
9 | USU_MATCH TEXT NOT NULL, |
10 | CONSTRAINT USU_PK |
11 | PRIMARY KEY(USU_ID), |
12 | CONSTRAINT USU_CUE_UNQ |
13 | UNIQUE(USU_CUE) |
14 | )' |
15 | ); |
16 | $con->exec( |
17 | 'CREATE TABLE IF NOT EXISTS ROL ( |
18 | ROL_ID TEXT, |
19 | ROL_DESCRIPCION TEXT NOT NULL, |
20 | CONSTRAINT ROL_PK |
21 | PRIMARY KEY(ROL_ID), |
22 | CONSTRAINT ROL_DESCR_UNQ |
23 | UNIQUE(ROL_DESCRIPCION) |
24 | )' |
25 | ); |
26 | $con->exec( |
27 | 'CREATE TABLE IF NOT EXISTS USU_ROL ( |
28 | USU_ID INTEGER NOT NULL, |
29 | ROL_ID TEXT NOT NULL, |
30 | CONSTRAINT USU_ROL_PK |
31 | PRIMARY KEY(USU_ID, ROL_ID), |
32 | CONSTRAINT USU_ROL_USU_FK |
33 | FOREIGN KEY (USU_ID) REFERENCES USUARIO(USU_ID), |
34 | CONSTRAINT USU_ROL_ROL_FK |
35 | FOREIGN KEY (ROL_ID) REFERENCES ROL(ROL_ID) |
36 | )' |
37 | ); |
38 | } |
39 | |