diff options
Diffstat (limited to 'install/index.php')
| -rw-r--r-- | install/index.php | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/install/index.php b/install/index.php index dbea375..d40959f 100644 --- a/install/index.php +++ b/install/index.php @@ -81,7 +81,8 @@ if (isset($_GET['create_tables'])) { `end_date` date NOT NULL, `invoice_date` date NOT NULL, `accepted` tinyint(1) unsigned NOT NULL DEFAULT '0', - `invoice_fileId` smallint(5) unsigned DEFAULT NULL, + `invoice_fileId` smallint(5) unsigned DEFAULT NULL, + `payment_key` varchar(63) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `invoice_fileId` (`invoice_fileId`), KEY `contactId` (`contactId`), @@ -93,6 +94,8 @@ if (isset($_GET['create_tables'])) { `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `offerId` smallint(5) unsigned NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `braintree_id` varchar(36) DEFAULT NULL, + `braintree_status` varchar(63) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"); @@ -116,6 +119,7 @@ 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("CREATE UNIQUE INDEX `payment_uniq_1` ON `".Constants::db_prefix."payment` (`offerId`);"); $_pdo->query("ALTER TABLE `payment` ADD CONSTRAINT `payment_ibfk_1` FOREIGN KEY (`offerId`) REFERENCES `offer` (`id`);"); |