- setChange("RENAME TABLE invoice_header TO tt_invoice_headers");
- setChange("ALTER TABLE tt_invoice_headers CHANGE ih_user_id user_id int(11) NOT NULL");
- setChange("ALTER TABLE tt_invoice_headers CHANGE ih_number number varchar(20) default NULL");
- setChange("ALTER TABLE tt_invoice_headers DROP ih_addr_your");
- setChange("ALTER TABLE tt_invoice_headers DROP ih_addr_cust");
- setChange("ALTER TABLE tt_invoice_headers CHANGE ih_comment comment varchar(255) default NULL");
- setChange("ALTER TABLE tt_invoice_headers CHANGE ih_tax tax float(6,2) default '0.00'");
- setChange("ALTER TABLE tt_invoice_headers CHANGE ih_discount discount float(6,2) default '0.00'");
- setChange("ALTER TABLE tt_invoice_headers CHANGE ih_fsubtotals subtotals tinyint(4) NOT NULL default '0'");
- setChange("ALTER TABLE tt_users DROP u_comanager");
- setChange("ALTER TABLE tt_tasks DROP a_manager_id");
- setChange("ALTER TABLE tt_projects DROP p_manager_id");
- setChange("ALTER TABLE tt_users DROP u_manager_id");
- setChange("ALTER TABLE activity_bind DROP ab_id");
- setChange("RENAME TABLE activity_bind TO tt_project_task_binds");
- setChange("ALTER TABLE tt_project_task_binds CHANGE ab_id_p project_id int(11) NOT NULL");
- setChange("ALTER TABLE tt_project_task_binds CHANGE ab_id_a task_id int(11) NOT NULL");
- setChange("RENAME TABLE user_bind TO tt_user_project_binds");
- setChange("ALTER TABLE tt_user_project_binds CHANGE ub_rate rate float(6,2) NOT NULL default '0.00'");
- setChange("ALTER TABLE tt_user_project_binds CHANGE ub_id_p project_id int(11) NOT NULL");
- setChange("ALTER TABLE tt_user_project_binds CHANGE ub_id_u user_id int(11) NOT NULL");
- setChange("ALTER TABLE tt_user_project_binds CHANGE ub_id id int(11) NOT NULL auto_increment");
- setChange("CREATE TABLE `tt_client_project_binds` (`client_id` int(11) NOT NULL, `project_id` int(11) NOT NULL)");
- setChange("ALTER TABLE tt_user_project_binds MODIFY rate float(6,2) default '0.00'");
- setChange("ALTER TABLE tt_clients MODIFY tax float(6,2) default '0.00'");
- setChange("RENAME TABLE activity_log TO tt_log");
- setChange("ALTER TABLE tt_log CHANGE al_timestamp timestamp timestamp NOT NULL");
- setChange("ALTER TABLE tt_log CHANGE al_user_id user_id int(11) NOT NULL");
- setChange("ALTER TABLE tt_log CHANGE al_date date date NOT NULL");
- setChange("drop index al_date_idx on tt_log");
- setChange("create index date_idx on tt_log(date)");
- setChange("ALTER TABLE tt_log CHANGE al_from start time default NULL");
- setChange("ALTER TABLE tt_log CHANGE al_duration duration time default NULL");
- setChange("ALTER TABLE tt_log CHANGE al_project_id project_id int(11) NOT NULL");
- setChange("ALTER TABLE tt_log MODIFY project_id int(11) default NULL");
- setChange("ALTER TABLE tt_log CHANGE al_activity_id task_id int(11) default NULL");
- setChange("ALTER TABLE tt_log CHANGE al_comment comment blob");
- setChange("ALTER TABLE tt_log CHANGE al_billable billable tinyint(4) default '0'");
- setChange("drop index al_user_id_idx on tt_log");
- setChange("drop index al_project_id_idx on tt_log");
- setChange("drop index al_activity_id_idx on tt_log");
- setChange("create index user_idx on tt_log(user_id)");
- setChange("create index project_idx on tt_log(project_id)");
- setChange("create index task_idx on tt_log(task_id)");
- setChange("ALTER TABLE tt_custom_field_log CHANGE al_id log_id bigint NOT NULL");
- setChange("RENAME TABLE sysconfig TO tt_config");
- setChange("ALTER TABLE tt_config DROP sysc_id");
- setChange("ALTER TABLE tt_config CHANGE sysc_id_u user_id int(11) NOT NULL");
- setChange("ALTER TABLE tt_config CHANGE sysc_name param_name varchar(32) NOT NULL");
- setChange("ALTER TABLE tt_config CHANGE sysc_value param_value varchar(80) default NULL");
- setChange("create unique index param_idx on tt_config(user_id, param_name)");
- setChange("ALTER TABLE tt_log ADD COLUMN invoice_id int(11) default NULL");
- setChange("ALTER TABLE tt_projects ADD COLUMN description varchar(255) default NULL");
+ setChange("RENAME TABLE invoice_header TO tt_invoice_headers");
+ setChange("ALTER TABLE tt_invoice_headers CHANGE ih_user_id user_id int(11) NOT NULL");
+ setChange("ALTER TABLE tt_invoice_headers CHANGE ih_number number varchar(20) default NULL");
+ setChange("ALTER TABLE tt_invoice_headers DROP ih_addr_your");
+ setChange("ALTER TABLE tt_invoice_headers DROP ih_addr_cust");
+ setChange("ALTER TABLE tt_invoice_headers CHANGE ih_comment comment varchar(255) default NULL");
+ setChange("ALTER TABLE tt_invoice_headers CHANGE ih_tax tax float(6,2) default '0.00'");
+ setChange("ALTER TABLE tt_invoice_headers CHANGE ih_discount discount float(6,2) default '0.00'");
+ setChange("ALTER TABLE tt_invoice_headers CHANGE ih_fsubtotals subtotals tinyint(4) NOT NULL default '0'");
+ setChange("ALTER TABLE tt_users DROP u_comanager");
+ setChange("ALTER TABLE tt_tasks DROP a_manager_id");
+ setChange("ALTER TABLE tt_projects DROP p_manager_id");
+ setChange("ALTER TABLE tt_users DROP u_manager_id");
+ setChange("ALTER TABLE activity_bind DROP ab_id");
+ setChange("RENAME TABLE activity_bind TO tt_project_task_binds");
+ setChange("ALTER TABLE tt_project_task_binds CHANGE ab_id_p project_id int(11) NOT NULL");
+ setChange("ALTER TABLE tt_project_task_binds CHANGE ab_id_a task_id int(11) NOT NULL");
+ setChange("RENAME TABLE user_bind TO tt_user_project_binds");
+ setChange("ALTER TABLE tt_user_project_binds CHANGE ub_rate rate float(6,2) NOT NULL default '0.00'");
+ setChange("ALTER TABLE tt_user_project_binds CHANGE ub_id_p project_id int(11) NOT NULL");
+ setChange("ALTER TABLE tt_user_project_binds CHANGE ub_id_u user_id int(11) NOT NULL");
+ setChange("ALTER TABLE tt_user_project_binds CHANGE ub_id id int(11) NOT NULL auto_increment");
+ setChange("CREATE TABLE `tt_client_project_binds` (`client_id` int(11) NOT NULL, `project_id` int(11) NOT NULL)");
+ setChange("ALTER TABLE tt_user_project_binds MODIFY rate float(6,2) default '0.00'");
+ setChange("ALTER TABLE tt_clients MODIFY tax float(6,2) default '0.00'");
+ setChange("RENAME TABLE activity_log TO tt_log");
+ setChange("ALTER TABLE tt_log CHANGE al_timestamp timestamp timestamp NOT NULL");
+ setChange("ALTER TABLE tt_log CHANGE al_user_id user_id int(11) NOT NULL");
+ setChange("ALTER TABLE tt_log CHANGE al_date date date NOT NULL");
+ setChange("drop index al_date_idx on tt_log");
+ setChange("create index date_idx on tt_log(date)");
+ setChange("ALTER TABLE tt_log CHANGE al_from start time default NULL");
+ setChange("ALTER TABLE tt_log CHANGE al_duration duration time default NULL");
+ setChange("ALTER TABLE tt_log CHANGE al_project_id project_id int(11) NOT NULL");
+ setChange("ALTER TABLE tt_log MODIFY project_id int(11) default NULL");
+ setChange("ALTER TABLE tt_log CHANGE al_activity_id task_id int(11) default NULL");
+ setChange("ALTER TABLE tt_log CHANGE al_comment comment blob");
+ setChange("ALTER TABLE tt_log CHANGE al_billable billable tinyint(4) default '0'");
+ setChange("drop index al_user_id_idx on tt_log");
+ setChange("drop index al_project_id_idx on tt_log");
+ setChange("drop index al_activity_id_idx on tt_log");
+ setChange("create index user_idx on tt_log(user_id)");
+ setChange("create index project_idx on tt_log(project_id)");
+ setChange("create index task_idx on tt_log(task_id)");
+ setChange("ALTER TABLE tt_custom_field_log CHANGE al_id log_id bigint NOT NULL");
+ setChange("RENAME TABLE sysconfig TO tt_config");
+ setChange("ALTER TABLE tt_config DROP sysc_id");
+ setChange("ALTER TABLE tt_config CHANGE sysc_id_u user_id int(11) NOT NULL");
+ setChange("ALTER TABLE tt_config CHANGE sysc_name param_name varchar(32) NOT NULL");
+ setChange("ALTER TABLE tt_config CHANGE sysc_value param_value varchar(80) default NULL");
+ setChange("create unique index param_idx on tt_config(user_id, param_name)");
+ setChange("ALTER TABLE tt_log ADD COLUMN invoice_id int(11) default NULL");
+ setChange("ALTER TABLE tt_projects ADD COLUMN description varchar(255) default NULL");