From c67d248601031a0245dfe64b609fa6623868014b Mon Sep 17 00:00:00 2001
From: Camil Staps
Date: Wed, 27 Jul 2016 14:52:49 +0200
Subject: v0.4.2 moved payment_received to separate table/class payment(s)

---
 install/index.php | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)

(limited to 'install/index.php')

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) {
-- 
cgit v1.2.3