Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision e214accc

Von Jan Büren vor fast 11 Jahren hinzugefügt

  • ID e214accccd89a9c8fcbaec4390c383135683438b
  • Vorgänger 377b7053
  • Nachfolger 5be8f312

Kleinere DB-Details (Fremdschlüssel und verwaiste Tabelle)
- audittrails wird nicht mehr benutzt

Unterschiede anzeigen:

SL/DB/Helper/Mappings.pm
84 84
my %kivitendo_package_names = (
85 85
  # TABLE                           # MODEL (given in C style)
86 86
  acc_trans                      => 'acc_transaction',
87
  audittrail                     => 'audit_trail',
88 87
  'auth.clients'                 => 'auth_client',
89 88
  'auth.clients_users'           => 'auth_client_user',
90 89
  'auth.clients_groups'          => 'auth_client_group',
SL/DB/MetaSetup/AuditTrail.pm
1
# This file has been auto-generated. Do not modify it; it will be overwritten
2
# by rose_auto_create_model.pl automatically.
3
package SL::DB::AuditTrail;
4

  
5
use strict;
6

  
7
use base qw(SL::DB::Object);
8

  
9
__PACKAGE__->meta->table('audittrail');
10

  
11
__PACKAGE__->meta->columns(
12
  action      => { type => 'text' },
13
  employee_id => { type => 'integer' },
14
  formname    => { type => 'text' },
15
  id          => { type => 'serial', not_null => 1 },
16
  reference   => { type => 'text' },
17
  tablename   => { type => 'text' },
18
  trans_id    => { type => 'integer' },
19
  transdate   => { type => 'timestamp', default => 'now' },
20
);
21

  
22
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
23

  
24
1;
25
;
SL/DB/MetaSetup/Default.pm
18 18
  ar_show_mark_as_paid                    => { type => 'boolean', default => 'true' },
19 19
  articlenumber                           => { type => 'text' },
20 20
  assemblynumber                          => { type => 'text' },
21
  audittrail                              => { type => 'boolean', default => 'false' },
22 21
  bin_id                                  => { type => 'integer' },
23 22
  bin_id_ignore_onhand                    => { type => 'integer' },
24 23
  businessnumber                          => { type => 'text' },
sql/Pg-upgrade2/drop_audittrail.sql
1
-- @tag: drop_audittrail
2
-- @description: Tabelle audittrail wird nicht mehr benutzt
3
-- @depends: release_3_0_0
4
-- @ignore: 0
5
ALTER TABLE defaults DROP COLUMN audittrail;
6
DROP TABLE audittrail;

Auch abrufbar als: Unified diff