| 1 | <?php |
| 2 | |
| 3 | function bdCrea(PDO $con) |
| 4 | { |
| 5 | $con->exec( |
| 6 | 'CREATE TABLE IF NOT EXISTS PASATIEMPO ( |
| 7 | PAS_ID INTEGER, |
| 8 | PAS_NOMBRE TEXT NOT NULL, |
| 9 | CONSTRAINT PAS_PK |
| 10 | PRIMARY KEY(PAS_ID), |
| 11 | CONSTRAINT PAS_NOM_UNQ |
| 12 | UNIQUE(PAS_NOMBRE) |
| 13 | )' |
| 14 | ); |
| 15 | $con->exec( |
| 16 | 'CREATE TABLE IF NOT EXISTS AMIGO ( |
| 17 | AMI_ID INTEGER, |
| 18 | AMI_NOMBRE TEXT NOT NULL, |
| 19 | PAS_ID INTEGER, |
| 20 | CONSTRAINT AMI_PK |
| 21 | PRIMARY KEY(AMI_ID), |
| 22 | CONSTRAINT AMI_NOM_UNQ |
| 23 | UNIQUE(AMI_NOMBRE) |
| 24 | CONSTRAINT AMI_PAS_FK |
| 25 | FOREIGN KEY (PAS_ID) REFERENCES PASATIEMPO(PAS_ID) |
| 26 | )' |
| 27 | ); |
| 28 | } |
| 29 | |