| 1 | <?php |
| 2 | |
| 3 | function bdCrea(PDO $con) |
| 4 | { |
| 5 | $con->exec( |
| 6 | 'CREATE TABLE IF NOT EXISTS VENTA ( |
| 7 | VENT_ID INTEGER, |
| 8 | VENT_EN_CAPTURA INTEGER NOT NULL, |
| 9 | CONSTRAINT VENT_PK |
| 10 | PRIMARY KEY(VENT_ID) |
| 11 | )' |
| 12 | ); |
| 13 | $con->exec( |
| 14 | 'CREATE TABLE IF NOT EXISTS PRODUCTO ( |
| 15 | PROD_ID INTEGER, |
| 16 | PROD_NOMBRE TEXT NOT NULL, |
| 17 | PROD_EXISTENCIAS REAL NOT NULL, |
| 18 | PROD_PRECIO REAL NOT NULL, |
| 19 | CONSTRAINT PROD_PK |
| 20 | PRIMARY KEY(PROD_ID), |
| 21 | CONSTRAINT PROD_NOM_UNQ |
| 22 | UNIQUE(PROD_NOMBRE) |
| 23 | )' |
| 24 | ); |
| 25 | $con->exec( |
| 26 | 'CREATE TABLE IF NOT EXISTS DET_VENTA ( |
| 27 | VENT_ID INTEGER NOT NULL, |
| 28 | PROD_ID INTEGER NOT NULL, |
| 29 | DTV_CANTIDAD REAL NOT NULL, |
| 30 | DTV_PRECIO REAL NOT NULL, |
| 31 | CONSTRAINT DTV_PK |
| 32 | PRIMARY KEY (VENT_ID, PROD_ID), |
| 33 | CONSTRAINT DTV_VENT_FK |
| 34 | FOREIGN KEY (VENT_ID) REFERENCES VENTA(VENT_ID), |
| 35 | CONSTRAINT DTV_PROD_FK |
| 36 | FOREIGN KEY (PROD_ID) REFERENCES PRODUCTO(PROD_ID) |
| 37 | )' |
| 38 | ); |
| 39 | } |
| 40 | |