aboutsummaryrefslogtreecommitdiff
path: root/install/index.php
diff options
context:
space:
mode:
Diffstat (limited to 'install/index.php')
-rw-r--r--install/index.php113
1 files changed, 57 insertions, 56 deletions
diff --git a/install/index.php b/install/index.php
index d40959f..519e3c5 100644
--- a/install/index.php
+++ b/install/index.php
@@ -22,72 +22,73 @@ require('../conf.php');
if (isset($_GET['create_tables'])) {
try {
$_pdo->query("CREATE TABLE IF NOT EXISTS `".Constants::db_prefix."assignment` (
- `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
- `offerId` smallint(5) unsigned NOT NULL,
- `title` tinytext NOT NULL,
- `description` text NOT NULL,
- `hours` float NOT NULL,
- `price_per_hour` float NOT NULL,
- `VAT_percentage` float NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `offerId - title` (`offerId`,`title`(255)),
- KEY `offerId` (`offerId`)
+ `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `offerId` smallint(5) unsigned NOT NULL,
+ `title` tinytext NOT NULL,
+ `description` text NOT NULL,
+ `hours` float NOT NULL,
+ `price_per_hour` float NOT NULL,
+ `VAT_percentage` float NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `offerId - title` (`offerId`,`title`(255)),
+ KEY `offerId` (`offerId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1");
$_pdo->query("CREATE TABLE IF NOT EXISTS `".Constants::db_prefix."client` (
- `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
- `name` tinytext NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `name` (`name`(255))
+ `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `name` tinytext NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `name` (`name`(255))
) ENGINE=InnoDB DEFAULT CHARSET=latin1");
$_pdo->query("CREATE TABLE IF NOT EXISTS `".Constants::db_prefix."contact` (
- `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
- `clientId` smallint(5) unsigned NOT NULL,
- `name` tinytext NOT NULL,
- `email` varchar(680) NOT NULL,
- `address` tinytext NOT NULL,
- `address_2` tinytext,
- `postal_code` varchar(7) NOT NULL,
- `city` tinytext NOT NULL,
- `country` tinytext NOT NULL,
- `language` varchar(3) NOT NULL DEFAULT 'en',
- PRIMARY KEY (`id`),
- UNIQUE KEY `clientId-name` (`clientId`,`name`(255)),
- KEY `clientId` (`clientId`)
+ `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `clientId` smallint(5) unsigned NOT NULL,
+ `name` tinytext NOT NULL,
+ `email` varchar(680) NOT NULL,
+ `address` tinytext NOT NULL,
+ `address_2` tinytext,
+ `postal_code` varchar(7) NOT NULL,
+ `city` tinytext NOT NULL,
+ `country` tinytext NOT NULL,
+ `language` varchar(3) NOT NULL DEFAULT 'en',
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `clientId-name` (`clientId`,`name`(255)),
+ 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,
+ `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,
- PRIMARY KEY (`id`),
- UNIQUE KEY `filename` (`filename`)
+ `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `filename` varchar(100) NOT NULL,
+ `secret_key` varchar(63) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `filename` (`filename`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1");
$_pdo->query("CREATE TABLE IF NOT EXISTS `".Constants::db_prefix."offer` (
- `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
- `contactId` smallint(5) unsigned NOT NULL,
- `start_date` date NOT NULL,
- `end_date` date NOT NULL,
- `invoice_date` date NOT NULL,
- `accepted` tinyint(1) unsigned NOT NULL DEFAULT '0',
+ `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `contactId` smallint(5) unsigned NOT NULL,
+ `start_date` date NOT NULL,
+ `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,
`payment_key` varchar(63) DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `invoice_fileId` (`invoice_fileId`),
- KEY `contactId` (`contactId`),
- KEY `contactId_2` (`contactId`),
- KEY `invoice_fileId_2` (`invoice_fileId`)
+ 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` (
@@ -100,24 +101,24 @@ if (isset($_GET['create_tables'])) {
) ENGINE=InnoDB DEFAULT CHARSET=latin1;");
$_pdo->query("CREATE TABLE IF NOT EXISTS `".Constants::db_prefix."user` (
- `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(24) NOT NULL,
`password` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) 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`)");
+ $_pdo->query("ALTER LE `".Constants::db_prefix."contact`
+ 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 LE `".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`),
- ADD CONSTRAINT `offer_ibfk_2` FOREIGN KEY (`contactId`) REFERENCES `".Constants::db_prefix."contact` (`id`)");
+ $_pdo->query("ALTER LE `".Constants::db_prefix."offer`
+ 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`
generated by cgit v1.2.3 (git 2.39.1) at 2025-03-13 19:18:07 +0000