X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=inline;f=dbinstall.php;h=00b9c382d5954716493e2b696615f4d8ff4179c7;hb=3d3375d59d89359453c6bd42e6b07f7d0354b448;hp=2b0d896ca3fccf2f4e80a6113fca7af4e3bfb130;hpb=cd4a4543cf8dd3d0534cf7e51032aea1605d0304;p=timetracker.git
diff --git a/dbinstall.php b/dbinstall.php
index 2b0d896c..00b9c382 100755
--- a/dbinstall.php
+++ b/dbinstall.php
@@ -600,53 +600,6 @@ if ($_POST) {
setChange("ALTER TABLE tt_invoices DROP end_date");
}
- if ($_POST["convert1600to11300"]) {
- setChange("DROP TABLE IF EXISTS tt_invoice_headers");
- setChange("ALTER TABLE tt_fav_reports ADD COLUMN `client_id` int(11) default NULL");
- setChange("ALTER TABLE tt_fav_reports ADD COLUMN `cf_1_option_id` int(11) default NULL");
- setChange("ALTER TABLE tt_fav_reports ADD COLUMN `show_client` tinyint(4) NOT NULL default '0'");
- setChange("ALTER TABLE tt_fav_reports ADD COLUMN `show_invoice` tinyint(4) NOT NULL default '0'");
- setChange("ALTER TABLE tt_fav_reports ADD COLUMN `group_by` varchar(20) default NULL");
- setChange("CREATE TABLE `tt_expense_items` (`id` bigint NOT NULL auto_increment, `date` date NOT NULL, `user_id` int(11) NOT NULL, `client_id` int(11) default NULL, `project_id` int(11) default NULL, `name` varchar(255) NOT NULL, `cost` decimal(10,2) default '0.00', `invoice_id` int(11) default NULL, PRIMARY KEY (`id`))");
- setChange("create index date_idx on tt_expense_items(date)");
- setChange("create index user_idx on tt_expense_items(user_id)");
- setChange("create index client_idx on tt_expense_items(client_id)");
- setChange("create index project_idx on tt_expense_items(project_id)");
- setChange("create index invoice_idx on tt_expense_items(invoice_id)");
- setChange("ALTER TABLE tt_fav_reports DROP sort_by");
- setChange("ALTER TABLE tt_fav_reports DROP show_empty_days");
- setChange("ALTER TABLE tt_invoices DROP discount");
- setChange("ALTER TABLE tt_users ADD COLUMN `client_id` int(11) default NULL");
- setChange("ALTER TABLE tt_teams ADD COLUMN `decimal_mark` char(1) NOT NULL default '.'");
- setChange("ALTER TABLE tt_fav_reports ADD COLUMN `invoice` tinyint(4) default NULL");
- setChange("CREATE TABLE `tt_cron` (`id` int(11) NOT NULL auto_increment, `cron_spec` varchar(255) NOT NULL, `last` int(11) default NULL, `next` int(11) default NULL, `report_id` int(11) default NULL, `email` varchar(100) default NULL, `status` tinyint(4) default '1', PRIMARY KEY (`id`))");
- setChange("ALTER TABLE tt_cron ADD COLUMN `team_id` int(11) NOT NULL");
- setChange("create index client_idx on tt_client_project_binds(client_id)");
- setChange("create index project_idx on tt_client_project_binds(project_id)");
- setChange("ALTER TABLE tt_log ADD COLUMN status tinyint(4) default '1'");
- setChange("ALTER TABLE tt_custom_field_log ADD COLUMN status tinyint(4) default '1'");
- setChange("ALTER TABLE tt_expense_items ADD COLUMN status tinyint(4) default '1'");
- setChange("ALTER TABLE tt_invoices ADD COLUMN status tinyint(4) default '1'");
- setChange("DROP INDEX name_idx on tt_invoices");
- setChange("create unique index name_idx on tt_invoices(team_id, name, status)");
- setChange("ALTER TABLE tt_teams ADD COLUMN lock_spec varchar(255) default NULL");
- setChange("ALTER TABLE tt_teams DROP locktime");
- setChange("CREATE TABLE `tt_monthly_quota` (`team_id` int(11) NOT NULL, `year` smallint(5) UNSIGNED NOT NULL, `month` tinyint(3) UNSIGNED NOT NULL, `quota` smallint(5) UNSIGNED NOT NULL, PRIMARY KEY (`year`,`month`,`team_id`))");
- setChange("ALTER TABLE `tt_monthly_quota` ADD CONSTRAINT `FK_TT_TEAM_CONSTRAING` FOREIGN KEY (`team_id`) REFERENCES `tt_teams` (`id`) ON DELETE CASCADE ON UPDATE CASCADE");
- setChange("ALTER TABLE `tt_teams` ADD `workday_hours` SMALLINT NULL DEFAULT '8' AFTER `lock_spec`");
- setChange("RENAME TABLE tt_monthly_quota TO tt_monthly_quotas");
- setChange("ALTER TABLE tt_expense_items modify `name` text NOT NULL");
- setChange("ALTER TABLE `tt_teams` ADD `uncompleted_indicators` SMALLINT(2) NOT NULL DEFAULT '0' AFTER `record_type`");
- setChange("CREATE TABLE `tt_predefined_expenses` (`id` int(11) NOT NULL auto_increment, `team_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `cost` decimal(10,2) default '0.00', PRIMARY KEY (`id`))");
- setChange("ALTER TABLE `tt_teams` ADD `task_required` smallint(2) NOT NULL DEFAULT '0' AFTER `tracking_mode`");
- setChange("ALTER TABLE `tt_teams` ADD `project_required` smallint(2) NOT NULL DEFAULT '0' AFTER `tracking_mode`");
- setChange("ALTER TABLE `tt_cron` ADD `report_condition` varchar(255) default NULL AFTER `email`");
- setChange("ALTER TABLE `tt_fav_reports` ADD `status` tinyint(4) default '1'");
- setChange("ALTER TABLE `tt_teams` ADD `bcc_email` varchar(100) default NULL AFTER `uncompleted_indicators`");
- setChange("ALTER TABLE `tt_cron` ADD `cc` varchar(100) default NULL AFTER `email`");
- setChange("ALTER TABLE `tt_cron` ADD `subject` varchar(100) default NULL AFTER `cc`");
- }
-
// The update_clients function updates projects field in tt_clients table.
if ($_POST["update_clients"]) {
$mdb2 = getConnection();
@@ -708,6 +661,64 @@ if ($_POST) {
print "Updated $affected teams...
\n";
}
+ if ($_POST["convert1600to11400"]) {
+ setChange("DROP TABLE IF EXISTS tt_invoice_headers");
+ setChange("ALTER TABLE tt_fav_reports ADD COLUMN `client_id` int(11) default NULL");
+ setChange("ALTER TABLE tt_fav_reports ADD COLUMN `cf_1_option_id` int(11) default NULL");
+ setChange("ALTER TABLE tt_fav_reports ADD COLUMN `show_client` tinyint(4) NOT NULL default '0'");
+ setChange("ALTER TABLE tt_fav_reports ADD COLUMN `show_invoice` tinyint(4) NOT NULL default '0'");
+ setChange("ALTER TABLE tt_fav_reports ADD COLUMN `group_by` varchar(20) default NULL");
+ setChange("CREATE TABLE `tt_expense_items` (`id` bigint NOT NULL auto_increment, `date` date NOT NULL, `user_id` int(11) NOT NULL, `client_id` int(11) default NULL, `project_id` int(11) default NULL, `name` varchar(255) NOT NULL, `cost` decimal(10,2) default '0.00', `invoice_id` int(11) default NULL, PRIMARY KEY (`id`))");
+ setChange("create index date_idx on tt_expense_items(date)");
+ setChange("create index user_idx on tt_expense_items(user_id)");
+ setChange("create index client_idx on tt_expense_items(client_id)");
+ setChange("create index project_idx on tt_expense_items(project_id)");
+ setChange("create index invoice_idx on tt_expense_items(invoice_id)");
+ setChange("ALTER TABLE tt_fav_reports DROP sort_by");
+ setChange("ALTER TABLE tt_fav_reports DROP show_empty_days");
+ setChange("ALTER TABLE tt_invoices DROP discount");
+ setChange("ALTER TABLE tt_users ADD COLUMN `client_id` int(11) default NULL");
+ setChange("ALTER TABLE tt_teams ADD COLUMN `decimal_mark` char(1) NOT NULL default '.'");
+ setChange("ALTER TABLE tt_fav_reports ADD COLUMN `invoice` tinyint(4) default NULL");
+ setChange("CREATE TABLE `tt_cron` (`id` int(11) NOT NULL auto_increment, `cron_spec` varchar(255) NOT NULL, `last` int(11) default NULL, `next` int(11) default NULL, `report_id` int(11) default NULL, `email` varchar(100) default NULL, `status` tinyint(4) default '1', PRIMARY KEY (`id`))");
+ setChange("ALTER TABLE tt_cron ADD COLUMN `team_id` int(11) NOT NULL");
+ setChange("create index client_idx on tt_client_project_binds(client_id)");
+ setChange("create index project_idx on tt_client_project_binds(project_id)");
+ setChange("ALTER TABLE tt_log ADD COLUMN status tinyint(4) default '1'");
+ setChange("ALTER TABLE tt_custom_field_log ADD COLUMN status tinyint(4) default '1'");
+ setChange("ALTER TABLE tt_expense_items ADD COLUMN status tinyint(4) default '1'");
+ setChange("ALTER TABLE tt_invoices ADD COLUMN status tinyint(4) default '1'");
+ setChange("DROP INDEX name_idx on tt_invoices");
+ setChange("create unique index name_idx on tt_invoices(team_id, name, status)");
+ setChange("ALTER TABLE tt_teams ADD COLUMN lock_spec varchar(255) default NULL");
+ setChange("ALTER TABLE tt_teams DROP locktime");
+ setChange("CREATE TABLE `tt_monthly_quota` (`team_id` int(11) NOT NULL, `year` smallint(5) UNSIGNED NOT NULL, `month` tinyint(3) UNSIGNED NOT NULL, `quota` smallint(5) UNSIGNED NOT NULL, PRIMARY KEY (`year`,`month`,`team_id`))");
+ setChange("ALTER TABLE `tt_monthly_quota` ADD CONSTRAINT `FK_TT_TEAM_CONSTRAING` FOREIGN KEY (`team_id`) REFERENCES `tt_teams` (`id`) ON DELETE CASCADE ON UPDATE CASCADE");
+ setChange("ALTER TABLE `tt_teams` ADD `workday_hours` SMALLINT NULL DEFAULT '8' AFTER `lock_spec`");
+ setChange("RENAME TABLE tt_monthly_quota TO tt_monthly_quotas");
+ setChange("ALTER TABLE tt_expense_items modify `name` text NOT NULL");
+ setChange("ALTER TABLE `tt_teams` ADD `uncompleted_indicators` SMALLINT(2) NOT NULL DEFAULT '0' AFTER `record_type`");
+ setChange("CREATE TABLE `tt_predefined_expenses` (`id` int(11) NOT NULL auto_increment, `team_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `cost` decimal(10,2) default '0.00', PRIMARY KEY (`id`))");
+ setChange("ALTER TABLE `tt_teams` ADD `task_required` smallint(2) NOT NULL DEFAULT '0' AFTER `tracking_mode`");
+ setChange("ALTER TABLE `tt_teams` ADD `project_required` smallint(2) NOT NULL DEFAULT '0' AFTER `tracking_mode`");
+ setChange("ALTER TABLE `tt_cron` ADD `report_condition` varchar(255) default NULL AFTER `email`");
+ setChange("ALTER TABLE `tt_fav_reports` ADD `status` tinyint(4) default '1'");
+ setChange("ALTER TABLE `tt_teams` ADD `bcc_email` varchar(100) default NULL AFTER `uncompleted_indicators`");
+ setChange("ALTER TABLE `tt_cron` ADD `cc` varchar(100) default NULL AFTER `email`");
+ setChange("ALTER TABLE `tt_cron` ADD `subject` varchar(100) default NULL AFTER `cc`");
+ setChange("ALTER TABLE `tt_log` ADD `paid` tinyint(4) NULL default '0' AFTER `billable`");
+ }
+
+ if ($_POST["convert11400to11710"]) {
+ setChange("ALTER TABLE `tt_teams` DROP `address`");
+ setChange("ALTER TABLE `tt_fav_reports` ADD `report_spec` text default NULL AFTER `user_id`");
+ setChange("ALTER TABLE `tt_fav_reports` ADD `paid_status` tinyint(4) default NULL AFTER `invoice`");
+ setChange("ALTER TABLE `tt_fav_reports` ADD `show_paid` tinyint(4) NOT NULL DEFAULT '0' AFTER `show_invoice`");
+ setChange("ALTER TABLE `tt_expense_items` ADD `paid` tinyint(4) NULL default '0' AFTER `invoice_id`");
+ setChange("ALTER TABLE `tt_monthly_quotas` MODIFY `quota` decimal(5,2) NOT NULL");
+ setChange("ALTER TABLE `tt_teams` MODIFY `workday_hours` decimal(5,2) DEFAULT '8.00'");
+ }
+
if ($_POST["cleanup"]) {
$mdb2 = getConnection();
@@ -750,7 +761,7 @@ if ($_POST) {
Create database structure (v1.13.0) + | Create database structure (v1.17.10)
(applies only to new installations, do not execute when updating) |