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 | CONSTRAINT USU_PK |
10 | PRIMARY KEY(USU_ID), |
11 | CONSTRAINT USU_CUE_UNQ |
12 | UNIQUE(USU_CUE) |
13 | )' |
14 | ); |
15 | $con->exec( |
16 | 'CREATE TABLE IF NOT EXISTS ROL ( |
17 | ROL_ID TEXT NOT NULL, |
18 | ROL_DESCRIPCION TEXT NOT NULL, |
19 | CONSTRAINT ROL_PK |
20 | PRIMARY KEY(ROL_ID), |
21 | CONSTRAINT ROL_DESCR_UNQ |
22 | UNIQUE(ROL_DESCRIPCION) |
23 | )' |
24 | ); |
25 | $con->exec( |
26 | 'CREATE TABLE IF NOT EXISTS USU_ROL ( |
27 | USU_ID INTEGER NOT NULL, |
28 | ROL_ID TEXT NOT NULL, |
29 | CONSTRAINT USU_ROL_PK |
30 | PRIMARY KEY(USU_ID, ROL_ID), |
31 | CONSTRAINT USU_ROL_USU_FK |
32 | FOREIGN KEY (USU_ID) REFERENCES USUARIO(USU_ID), |
33 | CONSTRAINT USU_ROL_ROL_FK |
34 | FOREIGN KEY (ROL_ID) REFERENCES ROL(ROL_ID) |
35 | )' |
36 | ); |
37 | } |
38 | |