| 1 | <?php |
| 2 | |
| 3 | function bdCrea(PDO $con) |
| 4 | { |
| 5 | $con->exec( |
| 6 | 'CREATE TABLE IF NOT EXISTS ARCHIVO ( |
| 7 | ARCH_ID INTEGER, |
| 8 | ARCH_BYTES BLOB NOT NULL, |
| 9 | CONSTRAINT ARCH_PK |
| 10 | PRIMARY KEY(ARCH_ID) |
| 11 | )' |
| 12 | ); |
| 13 | $con->exec( |
| 14 | 'CREATE TABLE IF NOT EXISTS PRODUCTO ( |
| 15 | PROD_ID INTEGER, |
| 16 | PROD_NOMBRE TEXT NOT NULL, |
| 17 | ARCH_ID INTEGER NOT NULL, |
| 18 | CONSTRAINT PROD_PK |
| 19 | PRIMARY KEY(PROD_ID), |
| 20 | CONSTRAINT PROD_NOM_UNQ |
| 21 | UNIQUE(PROD_NOMBRE) |
| 22 | CONSTRAINT PROD_ARCH_FK |
| 23 | FOREIGN KEY (ARCH_ID) REFERENCES ARCHIVO(ARCH_ID) |
| 24 | )' |
| 25 | ); |
| 26 | } |
| 27 | |