From e214accccd89a9c8fcbaec4390c383135683438b Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Mon, 20 Jan 2014 09:17:39 +0100 Subject: [PATCH] =?utf8?q?Kleinere=20DB-Details=20(Fremdschl=C3=BCssel=20u?= =?utf8?q?nd=20verwaiste=20Tabelle)=20=20=20=20=20=20=20=20=20=20-=20audit?= =?utf8?q?trails=20wird=20nicht=20mehr=20benutzt?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/DB/Helper/Mappings.pm | 1 - SL/DB/MetaSetup/AuditTrail.pm | 25 ------------------------- SL/DB/MetaSetup/Default.pm | 1 - sql/Pg-upgrade2/drop_audittrail.sql | 6 ++++++ 4 files changed, 6 insertions(+), 27 deletions(-) delete mode 100644 SL/DB/MetaSetup/AuditTrail.pm create mode 100644 sql/Pg-upgrade2/drop_audittrail.sql diff --git a/SL/DB/Helper/Mappings.pm b/SL/DB/Helper/Mappings.pm index 633a06793..022894c16 100644 --- a/SL/DB/Helper/Mappings.pm +++ b/SL/DB/Helper/Mappings.pm @@ -84,7 +84,6 @@ my @kivitendo_blacklist = (@kivitendo_blacklist_permanent, @kivitendo_blacklist_ my %kivitendo_package_names = ( # TABLE # MODEL (given in C style) acc_trans => 'acc_transaction', - audittrail => 'audit_trail', 'auth.clients' => 'auth_client', 'auth.clients_users' => 'auth_client_user', 'auth.clients_groups' => 'auth_client_group', diff --git a/SL/DB/MetaSetup/AuditTrail.pm b/SL/DB/MetaSetup/AuditTrail.pm deleted file mode 100644 index fd8add028..000000000 --- a/SL/DB/MetaSetup/AuditTrail.pm +++ /dev/null @@ -1,25 +0,0 @@ -# This file has been auto-generated. Do not modify it; it will be overwritten -# by rose_auto_create_model.pl automatically. -package SL::DB::AuditTrail; - -use strict; - -use base qw(SL::DB::Object); - -__PACKAGE__->meta->table('audittrail'); - -__PACKAGE__->meta->columns( - action => { type => 'text' }, - employee_id => { type => 'integer' }, - formname => { type => 'text' }, - id => { type => 'serial', not_null => 1 }, - reference => { type => 'text' }, - tablename => { type => 'text' }, - trans_id => { type => 'integer' }, - transdate => { type => 'timestamp', default => 'now' }, -); - -__PACKAGE__->meta->primary_key_columns([ 'id' ]); - -1; -; diff --git a/SL/DB/MetaSetup/Default.pm b/SL/DB/MetaSetup/Default.pm index 48551285c..8c0319cc3 100644 --- a/SL/DB/MetaSetup/Default.pm +++ b/SL/DB/MetaSetup/Default.pm @@ -18,7 +18,6 @@ __PACKAGE__->meta->columns( ar_show_mark_as_paid => { type => 'boolean', default => 'true' }, articlenumber => { type => 'text' }, assemblynumber => { type => 'text' }, - audittrail => { type => 'boolean', default => 'false' }, bin_id => { type => 'integer' }, bin_id_ignore_onhand => { type => 'integer' }, businessnumber => { type => 'text' }, diff --git a/sql/Pg-upgrade2/drop_audittrail.sql b/sql/Pg-upgrade2/drop_audittrail.sql new file mode 100644 index 000000000..b998dc690 --- /dev/null +++ b/sql/Pg-upgrade2/drop_audittrail.sql @@ -0,0 +1,6 @@ +-- @tag: drop_audittrail +-- @description: Tabelle audittrail wird nicht mehr benutzt +-- @depends: release_3_0_0 +-- @ignore: 0 +ALTER TABLE defaults DROP COLUMN audittrail; +DROP TABLE audittrail; -- 2.20.1