diff options
| author | Camil Staps | 2016-07-27 14:52:49 +0200 |
|---|---|---|
| committer | Camil Staps | 2016-07-27 15:01:54 +0200 |
| commit | c67d248601031a0245dfe64b609fa6623868014b (patch) | |
| tree | 640b5e040b1c045c361824d1cd3d5af1e6ecf8ec /install/index.php | |
| parent | v0.4.1 (diff) | |
v0.4.2 moved payment_received to separate table/class payment(s)
Diffstat (limited to 'install/index.php')
| -rw-r--r-- | install/index.php | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/install/index.php b/install/index.php index 213eec7..f565696 100644 --- a/install/index.php +++ b/install/index.php @@ -82,13 +82,19 @@ if (isset($_GET['create_tables'])) { `invoice_date` date NOT NULL, `accepted` tinyint(1) unsigned NOT NULL DEFAULT '0', `invoice_fileId` smallint(5) unsigned DEFAULT NULL, - `payment_received` date DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `invoice_fileId` (`invoice_fileId`), KEY `contactId` (`contactId`), KEY `contactId_2` (`contactId`), KEY `invoice_fileId_2` (`invoice_fileId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1"); + + $_pdo->query("CREATE TABLE IF NOT EXISTS `payment` ( + `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `offerId` smallint(5) unsigned NOT NULL, + `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + PRIMARY KEY (`id`) + ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"); $_pdo->query("CREATE TABLE IF NOT EXISTS `".constants::db_prefix."user` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, @@ -110,6 +116,9 @@ if (isset($_GET['create_tables'])) { ADD CONSTRAINT `offer_ibfk_1` FOREIGN KEY (`invoice_fileId`) REFERENCES `".constants::db_prefix."file` (`id`), ADD CONSTRAINT `offer_ibfk_2` FOREIGN KEY (`contactId`) REFERENCES `".constants::db_prefix."contact` (`id`)"); + $_pdo->query("ALTER TABLE `payment` + ADD CONSTRAINT `payment_ibfk_1` FOREIGN KEY (`offerId`) REFERENCES `offer` (`id`);"); + echo "Succeeded creating the database tables."; } catch (PDOException $e) { |