diff options
Diffstat (limited to 'install/index.php')
| -rw-r--r-- | install/index.php | 19 |
1 files changed, 16 insertions, 3 deletions
diff --git a/install/index.php b/install/index.php index 8a3d0b0..6c57769 100644 --- a/install/index.php +++ b/install/index.php @@ -57,6 +57,16 @@ if (isset($_GET['create_tables'])) { KEY `clientId` (`clientId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1"); + $_pdo->query("CREATE TABLE IF NOT EXISTS `".constants::db_prefix."discount` ( + `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `offerId` smallint(5) unsigned NOT NULL, + `title` tinytext NOT NULL, + `description` text NOT NULL, + `value` float unsigned NOT NULL, + `VAT_percentage` float NOT NULL, + PRIMARY KEY (`id`) + ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"); + $_pdo->query("CREATE TABLE IF NOT EXISTS `".constants::db_prefix."file` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `filename` varchar(100) NOT NULL, @@ -81,10 +91,13 @@ if (isset($_GET['create_tables'])) { ) ENGINE=InnoDB DEFAULT CHARSET=latin1"); $_pdo->query("ALTER TABLE `".constants::db_prefix."assignment` - ADD CONSTRAINT `assignment_ibfk_1` FOREIGN KEY (`offerId`) REFERENCES `".constants::db_prefix."offer` (`id`)"); + ADD CONSTRAINT `assignment_ibfk_1` FOREIGN KEY (`offerId`) REFERENCES `".constants::db_prefix."offer` (`id`)"); $_pdo->query("ALTER TABLE `".constants::db_prefix."contact` - ADD CONSTRAINT `contact_ibfk_1` FOREIGN KEY (`clientId`) REFERENCES `".constants::db_prefix."client` (`id`)"); + ADD CONSTRAINT `contact_ibfk_1` FOREIGN KEY (`clientId`) REFERENCES `".constants::db_prefix."client` (`id`)"); + + $_pdo->query("ALTER TABLE `".constants::db_prefix."discount` + ADD CONSTRAINT `discount_ibfk_1` FOREIGN KEY (`offerId`) REFERENCES `".constants::db_prefix."offer` (`id`);"); $_pdo->query("ALTER TABLE `".constants::db_prefix."offer` ADD CONSTRAINT `offer_ibfk_1` FOREIGN KEY (`invoice_fileId`) REFERENCES `".constants::db_prefix."file` (`id`), @@ -118,4 +131,4 @@ if (isset($_GET['create_folders'])) { <li><a href="?create_folders">Create folders</a></li> </ol> -<p>When you're done, it would be the neatest to remove the /install folder (even though this whole control panel should not be accessible for the public).</p>
\ No newline at end of file +<p>When you're done, it would be the neatest to remove the /install folder (even though this whole control panel should not be accessible for the public).</p> |