Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 1561b7f3

Von Moritz Bunkus vor mehr als 10 Jahren hinzugefügt

  • ID 1561b7f3d98390ba97bd5a81945f16e82d96915b
  • Vorgänger 55e399ab
  • Nachfolger 0ce8f2d4

Rose-Setup Pflichtenhefte/Projekte an Umstellung setup()/initialize() angepasst

Unterschiede anzeigen:

SL/DB/MetaSetup/Default.pm
66 66
  profit_determination                          => { type => 'text' },
67 67
  purchase_delivery_order_show_delete           => { type => 'boolean', default => 'true' },
68 68
  purchase_order_show_delete                    => { type => 'boolean', default => 'true' },
69
  requirement_spec_section_number_format        => { type => 'text', default => 'A00', not_null => 1 },
70 69
  requirement_spec_function_block_number_format => { type => 'text', default => 'FB000', not_null => 1 },
70
  requirement_spec_section_number_format        => { type => 'text', default => 'A00', not_null => 1 },
71 71
  revtrans                                      => { type => 'boolean', default => 'false' },
72 72
  rfqnumber                                     => { type => 'text' },
73 73
  rmanumber                                     => { type => 'text' },
SL/DB/MetaSetup/Project.pm
25 25
  projectnumber        => { type => 'text' },
26 26
  start_date           => { type => 'date' },
27 27
  timeframe            => { type => 'boolean', default => 'false', not_null => 1 },
28
  type                 => { type => 'text' },
29 28
  valid                => { type => 'boolean', default => 'true' },
30 29
);
31 30

  
......
36 35
__PACKAGE__->meta->allow_inline_column_values(1);
37 36

  
38 37
__PACKAGE__->meta->foreign_keys(
39
  customer => {
40
    class       => 'SL::DB::Customer',
41
    key_columns => { customer_id => 'id' },
42
  },
43

  
44
  project_type => {
45
    class       => 'SL::DB::ProjectType',
46
    key_columns => { project_type_id => 'id' },
47
  },
48

  
49 38
  billable_customer => {
50 39
    class       => 'SL::DB::Customer',
51 40
    key_columns => { billable_customer_id => 'id' },
SL/DB/MetaSetup/ProjectParticipant.pm
6 6

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

  
9
__PACKAGE__->meta->setup(
10
  table   => 'project_participants',
11

  
12
  columns => [
13
    id              => { type => 'serial', not_null => 1 },
14
    project_id      => { type => 'integer', not_null => 1 },
15
    employee_id     => { type => 'integer', not_null => 1 },
16
    project_role_id => { type => 'integer', not_null => 1 },
17
    minutes         => { type => 'integer', default => '0', not_null => 1 },
18
    cost_per_hour   => { type => 'numeric', precision => 5, scale => 15 },
19
    itime           => { type => 'timestamp', default => '06.05.2013 14:26:18.81159' },
20
    mtime           => { type => 'timestamp' },
21
  ],
22

  
23
  primary_key_columns => [ 'id' ],
24

  
25
  foreign_keys => [
26
    employee => {
27
      class       => 'SL::DB::Employee',
28
      key_columns => { employee_id => 'id' },
29
    },
30

  
31
    project => {
32
      class       => 'SL::DB::Project',
33
      key_columns => { project_id => 'id' },
34
    },
35

  
36
    project_role => {
37
      class       => 'SL::DB::ProjectRole',
38
      key_columns => { project_role_id => 'id' },
39
    },
40
  ],
9
__PACKAGE__->meta->table('project_participants');
10

  
11
__PACKAGE__->meta->columns(
12
  cost_per_hour   => { type => 'numeric', precision => 5, scale => 15 },
13
  employee_id     => { type => 'integer', not_null => 1 },
14
  id              => { type => 'serial', not_null => 1 },
15
  itime           => { type => 'timestamp', default => '2013-05-08 09:11:09.704126' },
16
  minutes         => { type => 'integer', default => '0', not_null => 1 },
17
  mtime           => { type => 'timestamp' },
18
  project_id      => { type => 'integer', not_null => 1 },
19
  project_role_id => { type => 'integer', not_null => 1 },
20
);
21

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

  
24
__PACKAGE__->meta->foreign_keys(
25
  employee => {
26
    class       => 'SL::DB::Employee',
27
    key_columns => { employee_id => 'id' },
28
  },
29

  
30
  project => {
31
    class       => 'SL::DB::Project',
32
    key_columns => { project_id => 'id' },
33
  },
34

  
35
  project_role => {
36
    class       => 'SL::DB::ProjectRole',
37
    key_columns => { project_role_id => 'id' },
38
  },
41 39
);
42 40

  
43 41
1;
SL/DB/MetaSetup/ProjectPhase.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::ProjectPhase;
4

  
5
use strict;
6

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

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

  
11
__PACKAGE__->meta->columns(
12
  budget_cost           => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 },
13
  budget_minutes        => { type => 'integer', default => '0', not_null => 1 },
14
  description           => { type => 'text', not_null => 1 },
15
  end_date              => { type => 'date' },
16
  general_cost_per_hour => { type => 'numeric', default => '0', not_null => 1, precision => 5, scale => 15 },
17
  general_minutes       => { type => 'integer', default => '0', not_null => 1 },
18
  id                    => { type => 'serial', not_null => 1 },
19
  itime                 => { type => 'timestamp', default => '2013-05-08 09:11:09.704126' },
20
  mtime                 => { type => 'timestamp' },
21
  name                  => { type => 'text', not_null => 1 },
22
  project_id            => { type => 'integer' },
23
  start_date            => { type => 'date' },
24
);
25

  
26
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
27

  
28
__PACKAGE__->meta->foreign_keys(
29
  project => {
30
    class       => 'SL::DB::Project',
31
    key_columns => { project_id => 'id' },
32
  },
33
);
34

  
35
__PACKAGE__->meta->relationships(
36
  project_phase_participants => {
37
    class      => 'SL::DB::ProjectPhaseParticipant',
38
    column_map => { id => 'project_phase_id' },
39
    type       => 'one to many',
40
  },
41
);
42

  
43
1;
44
;
SL/DB/MetaSetup/ProjectPhaseParticipant.pm
6 6

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

  
9
__PACKAGE__->meta->setup(
10
  table   => 'project_phase_participants',
11

  
12
  columns => [
13
    id               => { type => 'serial', not_null => 1 },
14
    project_phase_id => { type => 'integer', not_null => 1 },
15
    employee_id      => { type => 'integer', not_null => 1 },
16
    project_role_id  => { type => 'integer', not_null => 1 },
17
    minutes          => { type => 'integer', default => '0', not_null => 1 },
18
    cost_per_hour    => { type => 'numeric', precision => 5, scale => 15 },
19
    itime            => { type => 'timestamp', default => '06.05.2013 14:26:18.81159' },
20
    mtime            => { type => 'timestamp' },
21
  ],
22

  
23
  primary_key_columns => [ 'id' ],
24

  
25
  foreign_keys => [
26
    employee => {
27
      class       => 'SL::DB::Employee',
28
      key_columns => { employee_id => 'id' },
29
    },
30

  
31
    project_role => {
32
      class       => 'SL::DB::ProjectRole',
33
      key_columns => { project_role_id => 'id' },
34
    },
35
  ],
9
__PACKAGE__->meta->table('project_phase_participants');
10

  
11
__PACKAGE__->meta->columns(
12
  cost_per_hour    => { type => 'numeric', precision => 5, scale => 15 },
13
  employee_id      => { type => 'integer', not_null => 1 },
14
  id               => { type => 'serial', not_null => 1 },
15
  itime            => { type => 'timestamp', default => '2013-05-08 09:11:09.704126' },
16
  minutes          => { type => 'integer', default => '0', not_null => 1 },
17
  mtime            => { type => 'timestamp' },
18
  project_phase_id => { type => 'integer', not_null => 1 },
19
  project_role_id  => { type => 'integer', not_null => 1 },
20
);
21

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

  
24
__PACKAGE__->meta->foreign_keys(
25
  employee => {
26
    class       => 'SL::DB::Employee',
27
    key_columns => { employee_id => 'id' },
28
  },
29

  
30
  project_role => {
31
    class       => 'SL::DB::ProjectRole',
32
    key_columns => { project_role_id => 'id' },
33
  },
36 34
);
37 35

  
38 36
1;
SL/DB/MetaSetup/ProjectRole.pm
6 6

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

  
9
__PACKAGE__->meta->setup(
10
  table   => 'project_roles',
9
__PACKAGE__->meta->table('project_roles');
11 10

  
12
  columns => [
13
    id          => { type => 'serial', not_null => 1 },
14
    name        => { type => 'text', not_null => 1 },
15
    description => { type => 'text', not_null => 1 },
16
    position    => { type => 'integer', not_null => 1 },
17
    itime       => { type => 'timestamp', default => '06.05.2013 14:26:18.81159' },
18
    mtime       => { type => 'timestamp' },
19
  ],
20

  
21
  primary_key_columns => [ 'id' ],
11
__PACKAGE__->meta->columns(
12
  description => { type => 'text', not_null => 1 },
13
  id          => { type => 'serial', not_null => 1 },
14
  itime       => { type => 'timestamp', default => '2013-05-08 09:11:09.704126' },
15
  mtime       => { type => 'timestamp' },
16
  name        => { type => 'text', not_null => 1 },
17
  position    => { type => 'integer', not_null => 1 },
22 18
);
23 19

  
20
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
21

  
24 22
1;
25 23
;
SL/DB/MetaSetup/ProjectStatus.pm
6 6

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

  
9
__PACKAGE__->meta->setup(
10
  table   => 'project_status',
9
__PACKAGE__->meta->table('project_status');
11 10

  
12
  columns => [
13
    id          => { type => 'serial', not_null => 1 },
14
    name        => { type => 'text', not_null => 1 },
15
    description => { type => 'text', not_null => 1 },
16
    position    => { type => 'integer', not_null => 1 },
17
    itime       => { type => 'timestamp', default => '06.05.2013 14:26:18.81159' },
18
    mtime       => { type => 'timestamp' },
19
  ],
20

  
21
  primary_key_columns => [ 'id' ],
11
__PACKAGE__->meta->columns(
12
  description => { type => 'text', not_null => 1 },
13
  id          => { type => 'serial', not_null => 1 },
14
  itime       => { type => 'timestamp', default => '2013-05-08 09:11:09.704126' },
15
  mtime       => { type => 'timestamp' },
16
  name        => { type => 'text', not_null => 1 },
17
  position    => { type => 'integer', not_null => 1 },
22 18
);
23 19

  
20
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
21

  
24 22
1;
25 23
;
SL/DB/MetaSetup/RequirementSpec.pm
6 6

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

  
9
__PACKAGE__->meta->setup(
10
  table   => 'requirement_specs',
9
__PACKAGE__->meta->table('requirement_specs');
11 10

  
12
  columns => [
13
    id                      => { type => 'serial', not_null => 1 },
14
    type_id                 => { type => 'integer' },
15
    status_id               => { type => 'integer' },
16
    version_id              => { type => 'integer' },
17
    customer_id             => { type => 'integer' },
18
    project_id              => { type => 'integer' },
19
    title                   => { type => 'text', not_null => 1 },
20
    hourly_rate             => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 8 },
21
    net_sum                 => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 12 },
22
    working_copy_id         => { type => 'integer' },
23
    previous_section_number => { type => 'integer', not_null => 1 },
24
    previous_fb_number      => { type => 'integer', not_null => 1 },
25
    is_template             => { type => 'boolean', default => 'false' },
26
    itime                   => { type => 'timestamp', default => 'now()' },
27
    mtime                   => { type => 'timestamp' },
28
  ],
11
__PACKAGE__->meta->columns(
12
  customer_id             => { type => 'integer' },
13
  hourly_rate             => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 8 },
14
  id                      => { type => 'serial', not_null => 1 },
15
  is_template             => { type => 'boolean', default => 'false' },
16
  itime                   => { type => 'timestamp', default => 'now()' },
17
  mtime                   => { type => 'timestamp' },
18
  net_sum                 => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 12 },
19
  previous_fb_number      => { type => 'integer', not_null => 1 },
20
  previous_section_number => { type => 'integer', not_null => 1 },
21
  project_id              => { type => 'integer' },
22
  status_id               => { type => 'integer' },
23
  title                   => { type => 'text', not_null => 1 },
24
  type_id                 => { type => 'integer' },
25
  version_id              => { type => 'integer' },
26
  working_copy_id         => { type => 'integer' },
27
);
29 28

  
30
  primary_key_columns => [ 'id' ],
29
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
31 30

  
32
  allow_inline_column_values => 1,
31
__PACKAGE__->meta->allow_inline_column_values(1);
33 32

  
34
  foreign_keys => [
35
    customer => {
36
      class       => 'SL::DB::Customer',
37
      key_columns => { customer_id => 'id' },
38
    },
33
__PACKAGE__->meta->foreign_keys(
34
  customer => {
35
    class       => 'SL::DB::Customer',
36
    key_columns => { customer_id => 'id' },
37
  },
39 38

  
40
    project => {
41
      class       => 'SL::DB::Project',
42
      key_columns => { project_id => 'id' },
43
    },
39
  project => {
40
    class       => 'SL::DB::Project',
41
    key_columns => { project_id => 'id' },
42
  },
44 43

  
45
    status => {
46
      class       => 'SL::DB::RequirementSpecStatus',
47
      key_columns => { status_id => 'id' },
48
    },
44
  status => {
45
    class       => 'SL::DB::RequirementSpecStatus',
46
    key_columns => { status_id => 'id' },
47
  },
49 48

  
50
    type => {
51
      class       => 'SL::DB::RequirementSpecType',
52
      key_columns => { type_id => 'id' },
53
    },
49
  type => {
50
    class       => 'SL::DB::RequirementSpecType',
51
    key_columns => { type_id => 'id' },
52
  },
54 53

  
55
    version => {
56
      class       => 'SL::DB::RequirementSpecVersion',
57
      key_columns => { version_id => 'id' },
58
    },
54
  version => {
55
    class       => 'SL::DB::RequirementSpecVersion',
56
    key_columns => { version_id => 'id' },
57
  },
59 58

  
60
    working_copy => {
61
      class       => 'SL::DB::RequirementSpec',
62
      key_columns => { working_copy_id => 'id' },
63
    },
64
  ],
59
  working_copy => {
60
    class       => 'SL::DB::RequirementSpec',
61
    key_columns => { working_copy_id => 'id' },
62
  },
65 63
);
66 64

  
67 65
1;
SL/DB/MetaSetup/RequirementSpecAcceptanceStatus.pm
6 6

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

  
9
__PACKAGE__->meta->setup(
10
  table   => 'requirement_spec_acceptance_statuses',
11

  
12
  columns => [
13
    id          => { type => 'serial', not_null => 1 },
14
    name        => { type => 'text', not_null => 1 },
15
    description => { type => 'text' },
16
    position    => { type => 'integer', not_null => 1 },
17
    itime       => { type => 'timestamp', default => 'now()' },
18
    mtime       => { type => 'timestamp' },
19
  ],
9
__PACKAGE__->meta->table('requirement_spec_acceptance_statuses');
10

  
11
__PACKAGE__->meta->columns(
12
  description => { type => 'text' },
13
  id          => { type => 'serial', not_null => 1 },
14
  itime       => { type => 'timestamp', default => 'now()' },
15
  mtime       => { type => 'timestamp' },
16
  name        => { type => 'text', not_null => 1 },
17
  position    => { type => 'integer', not_null => 1 },
18
);
20 19

  
21
  primary_key_columns => [ 'id' ],
20
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
22 21

  
23
  unique_key => [ 'name', 'description' ],
22
__PACKAGE__->meta->unique_keys([ 'name', 'description' ]);
24 23

  
25
  allow_inline_column_values => 1,
26
);
24
__PACKAGE__->meta->allow_inline_column_values(1);
27 25

  
28 26
1;
29 27
;
SL/DB/MetaSetup/RequirementSpecComplexity.pm
6 6

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

  
9
__PACKAGE__->meta->setup(
10
  table   => 'requirement_spec_complexities',
11

  
12
  columns => [
13
    id          => { type => 'serial', not_null => 1 },
14
    description => { type => 'text', not_null => 1 },
15
    position    => { type => 'integer', not_null => 1 },
16
    itime       => { type => 'timestamp', default => 'now()' },
17
    mtime       => { type => 'timestamp' },
18
  ],
9
__PACKAGE__->meta->table('requirement_spec_complexities');
10

  
11
__PACKAGE__->meta->columns(
12
  description => { type => 'text', not_null => 1 },
13
  id          => { type => 'serial', not_null => 1 },
14
  itime       => { type => 'timestamp', default => 'now()' },
15
  mtime       => { type => 'timestamp' },
16
  position    => { type => 'integer', not_null => 1 },
17
);
19 18

  
20
  primary_key_columns => [ 'id' ],
19
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
21 20

  
22
  unique_key => [ 'description' ],
21
__PACKAGE__->meta->unique_keys([ 'description' ]);
23 22

  
24
  allow_inline_column_values => 1,
25
);
23
__PACKAGE__->meta->allow_inline_column_values(1);
26 24

  
27 25
1;
28 26
;
SL/DB/MetaSetup/RequirementSpecDependency.pm
6 6

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

  
9
__PACKAGE__->meta->setup(
10
  table   => 'requirement_spec_item_dependencies',
11

  
12
  columns => [
13
    depending_item_id => { type => 'integer', not_null => 1 },
14
    depended_item_id  => { type => 'integer', not_null => 1 },
15
  ],
16

  
17
  primary_key_columns => [ 'depending_item_id', 'depended_item_id' ],
18

  
19
  foreign_keys => [
20
    depended_item => {
21
      class       => 'SL::DB::RequirementSpecItem',
22
      key_columns => { depended_item_id => 'id' },
23
    },
24

  
25
    depending_item => {
26
      class       => 'SL::DB::RequirementSpecItem',
27
      key_columns => { depending_item_id => 'id' },
28
    },
29
  ],
9
__PACKAGE__->meta->table('requirement_spec_item_dependencies');
10

  
11
__PACKAGE__->meta->columns(
12
  depended_item_id  => { type => 'integer', not_null => 1 },
13
  depending_item_id => { type => 'integer', not_null => 1 },
14
);
15

  
16
__PACKAGE__->meta->primary_key_columns([ 'depending_item_id', 'depended_item_id' ]);
17

  
18
__PACKAGE__->meta->foreign_keys(
19
  depended_item => {
20
    class       => 'SL::DB::RequirementSpecItem',
21
    key_columns => { depended_item_id => 'id' },
22
  },
23

  
24
  depending_item => {
25
    class       => 'SL::DB::RequirementSpecItem',
26
    key_columns => { depending_item_id => 'id' },
27
  },
30 28
);
31 29

  
32 30
1;
SL/DB/MetaSetup/RequirementSpecItem.pm
6 6

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

  
9
__PACKAGE__->meta->setup(
10
  table   => 'requirement_spec_items',
11

  
12
  columns => [
13
    id                   => { type => 'serial', not_null => 1 },
14
    requirement_spec_id  => { type => 'integer', not_null => 1 },
15
    item_type            => { type => 'text', not_null => 1 },
16
    parent_id            => { type => 'integer' },
17
    position             => { type => 'integer', not_null => 1 },
18
    fb_number            => { type => 'text', not_null => 1 },
19
    title                => { type => 'text' },
20
    description          => { type => 'text' },
21
    complexity_id        => { type => 'integer' },
22
    risk_id              => { type => 'integer' },
23
    time_estimation      => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 12 },
24
    net_sum              => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 12 },
25
    is_flagged           => { type => 'boolean', default => 'false', not_null => 1 },
26
    acceptance_status_id => { type => 'integer' },
27
    acceptance_text      => { type => 'text' },
28
    itime                => { type => 'timestamp', default => 'now()', not_null => 1 },
29
    mtime                => { type => 'timestamp' },
30
  ],
9
__PACKAGE__->meta->table('requirement_spec_items');
10

  
11
__PACKAGE__->meta->columns(
12
  acceptance_status_id => { type => 'integer' },
13
  acceptance_text      => { type => 'text' },
14
  complexity_id        => { type => 'integer' },
15
  description          => { type => 'text' },
16
  fb_number            => { type => 'text', not_null => 1 },
17
  id                   => { type => 'serial', not_null => 1 },
18
  is_flagged           => { type => 'boolean', default => 'false', not_null => 1 },
19
  item_type            => { type => 'text', not_null => 1 },
20
  itime                => { type => 'timestamp', default => 'now()', not_null => 1 },
21
  mtime                => { type => 'timestamp' },
22
  net_sum              => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 12 },
23
  parent_id            => { type => 'integer' },
24
  position             => { type => 'integer', not_null => 1 },
25
  requirement_spec_id  => { type => 'integer', not_null => 1 },
26
  risk_id              => { type => 'integer' },
27
  time_estimation      => { type => 'numeric', default => '0', not_null => 1, precision => 2, scale => 12 },
28
  title                => { type => 'text' },
29
);
31 30

  
32
  primary_key_columns => [ 'id' ],
31
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
33 32

  
34
  allow_inline_column_values => 1,
33
__PACKAGE__->meta->allow_inline_column_values(1);
35 34

  
36
  foreign_keys => [
37
    acceptance_status => {
38
      class       => 'SL::DB::RequirementSpecAcceptanceStatus',
39
      key_columns => { acceptance_status_id => 'id' },
40
    },
35
__PACKAGE__->meta->foreign_keys(
36
  acceptance_status => {
37
    class       => 'SL::DB::RequirementSpecAcceptanceStatus',
38
    key_columns => { acceptance_status_id => 'id' },
39
  },
41 40

  
42
    complexity => {
43
      class       => 'SL::DB::RequirementSpecComplexity',
44
      key_columns => { complexity_id => 'id' },
45
    },
41
  complexity => {
42
    class       => 'SL::DB::RequirementSpecComplexity',
43
    key_columns => { complexity_id => 'id' },
44
  },
46 45

  
47
    parent => {
48
      class       => 'SL::DB::RequirementSpecItem',
49
      key_columns => { parent_id => 'id' },
50
    },
46
  parent => {
47
    class       => 'SL::DB::RequirementSpecItem',
48
    key_columns => { parent_id => 'id' },
49
  },
51 50

  
52
    requirement_spec => {
53
      class       => 'SL::DB::RequirementSpec',
54
      key_columns => { requirement_spec_id => 'id' },
55
    },
51
  requirement_spec => {
52
    class       => 'SL::DB::RequirementSpec',
53
    key_columns => { requirement_spec_id => 'id' },
54
  },
56 55

  
57
    risk => {
58
      class       => 'SL::DB::RequirementSpecRisk',
59
      key_columns => { risk_id => 'id' },
60
    },
61
  ],
56
  risk => {
57
    class       => 'SL::DB::RequirementSpecRisk',
58
    key_columns => { risk_id => 'id' },
59
  },
62 60
);
63 61

  
64 62
1;
SL/DB/MetaSetup/RequirementSpecPredefinedText.pm
6 6

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

  
9
__PACKAGE__->meta->setup(
10
  table   => 'requirement_spec_predefined_texts',
11

  
12
  columns => [
13
    id          => { type => 'serial', not_null => 1 },
14
    description => { type => 'text', not_null => 1 },
15
    title       => { type => 'text', not_null => 1 },
16
    text        => { type => 'text', not_null => 1 },
17
    position    => { type => 'integer', not_null => 1 },
18
    itime       => { type => 'timestamp', default => 'now()' },
19
    mtime       => { type => 'timestamp' },
20
  ],
9
__PACKAGE__->meta->table('requirement_spec_predefined_texts');
10

  
11
__PACKAGE__->meta->columns(
12
  description => { type => 'text', not_null => 1 },
13
  id          => { type => 'serial', not_null => 1 },
14
  itime       => { type => 'timestamp', default => 'now()' },
15
  mtime       => { type => 'timestamp' },
16
  position    => { type => 'integer', not_null => 1 },
17
  text        => { type => 'text', not_null => 1 },
18
  title       => { type => 'text', not_null => 1 },
19
);
21 20

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

  
24
  unique_key => [ 'description' ],
23
__PACKAGE__->meta->unique_keys([ 'description' ]);
25 24

  
26
  allow_inline_column_values => 1,
27
);
25
__PACKAGE__->meta->allow_inline_column_values(1);
28 26

  
29 27
1;
30 28
;
SL/DB/MetaSetup/RequirementSpecRisk.pm
6 6

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

  
9
__PACKAGE__->meta->setup(
10
  table   => 'requirement_spec_risks',
11

  
12
  columns => [
13
    id          => { type => 'serial', not_null => 1 },
14
    description => { type => 'text', not_null => 1 },
15
    position    => { type => 'integer', not_null => 1 },
16
    itime       => { type => 'timestamp', default => 'now()' },
17
    mtime       => { type => 'timestamp' },
18
  ],
9
__PACKAGE__->meta->table('requirement_spec_risks');
10

  
11
__PACKAGE__->meta->columns(
12
  description => { type => 'text', not_null => 1 },
13
  id          => { type => 'serial', not_null => 1 },
14
  itime       => { type => 'timestamp', default => 'now()' },
15
  mtime       => { type => 'timestamp' },
16
  position    => { type => 'integer', not_null => 1 },
17
);
19 18

  
20
  primary_key_columns => [ 'id' ],
19
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
21 20

  
22
  unique_key => [ 'description' ],
21
__PACKAGE__->meta->unique_keys([ 'description' ]);
23 22

  
24
  allow_inline_column_values => 1,
25
);
23
__PACKAGE__->meta->allow_inline_column_values(1);
26 24

  
27 25
1;
28 26
;
SL/DB/MetaSetup/RequirementSpecStatus.pm
6 6

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

  
9
__PACKAGE__->meta->setup(
10
  table   => 'requirement_spec_statuses',
11

  
12
  columns => [
13
    id          => { type => 'serial', not_null => 1 },
14
    name        => { type => 'text', not_null => 1 },
15
    description => { type => 'text', not_null => 1 },
16
    position    => { type => 'integer', not_null => 1 },
17
    itime       => { type => 'timestamp', default => 'now()' },
18
    mtime       => { type => 'timestamp' },
19
  ],
9
__PACKAGE__->meta->table('requirement_spec_statuses');
10

  
11
__PACKAGE__->meta->columns(
12
  description => { type => 'text', not_null => 1 },
13
  id          => { type => 'serial', not_null => 1 },
14
  itime       => { type => 'timestamp', default => 'now()' },
15
  mtime       => { type => 'timestamp' },
16
  name        => { type => 'text', not_null => 1 },
17
  position    => { type => 'integer', not_null => 1 },
18
);
20 19

  
21
  primary_key_columns => [ 'id' ],
20
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
22 21

  
23
  unique_key => [ 'name', 'description' ],
22
__PACKAGE__->meta->unique_keys([ 'name', 'description' ]);
24 23

  
25
  allow_inline_column_values => 1,
26
);
24
__PACKAGE__->meta->allow_inline_column_values(1);
27 25

  
28 26
1;
29 27
;
SL/DB/MetaSetup/RequirementSpecTextBlock.pm
6 6

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

  
9
__PACKAGE__->meta->setup(
10
  table   => 'requirement_spec_text_blocks',
11

  
12
  columns => [
13
    id                  => { type => 'serial', not_null => 1 },
14
    requirement_spec_id => { type => 'integer', not_null => 1 },
15
    title               => { type => 'text', not_null => 1 },
16
    text                => { type => 'text' },
17
    position            => { type => 'integer', not_null => 1 },
18
    output_position     => { type => 'integer', default => 1, not_null => 1 },
19
    itime               => { type => 'timestamp', default => 'now()', not_null => 1 },
20
    mtime               => { type => 'timestamp' },
21
    is_flagged          => { type => 'boolean', default => 'false', not_null => 1 },
22
  ],
23

  
24
  primary_key_columns => [ 'id' ],
25

  
26
  allow_inline_column_values => 1,
27

  
28
  foreign_keys => [
29
    requirement_spec => {
30
      class       => 'SL::DB::RequirementSpec',
31
      key_columns => { requirement_spec_id => 'id' },
32
    },
33
  ],
9
__PACKAGE__->meta->table('requirement_spec_text_blocks');
10

  
11
__PACKAGE__->meta->columns(
12
  id                  => { type => 'serial', not_null => 1 },
13
  is_flagged          => { type => 'boolean', default => 'false', not_null => 1 },
14
  itime               => { type => 'timestamp', default => 'now()', not_null => 1 },
15
  mtime               => { type => 'timestamp' },
16
  output_position     => { type => 'integer', default => 1, not_null => 1 },
17
  position            => { type => 'integer', not_null => 1 },
18
  requirement_spec_id => { type => 'integer', not_null => 1 },
19
  text                => { type => 'text' },
20
  title               => { type => 'text', not_null => 1 },
21
);
22

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

  
25
__PACKAGE__->meta->allow_inline_column_values(1);
26

  
27
__PACKAGE__->meta->foreign_keys(
28
  requirement_spec => {
29
    class       => 'SL::DB::RequirementSpec',
30
    key_columns => { requirement_spec_id => 'id' },
31
  },
34 32
);
35 33

  
36 34
1;
SL/DB/MetaSetup/RequirementSpecType.pm
6 6

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

  
9
__PACKAGE__->meta->setup(
10
  table   => 'requirement_spec_types',
11

  
12
  columns => [
13
    id          => { type => 'serial', not_null => 1 },
14
    description => { type => 'text', not_null => 1 },
15
    position    => { type => 'integer', not_null => 1 },
16
    itime       => { type => 'timestamp', default => 'now()' },
17
    mtime       => { type => 'timestamp' },
18
  ],
9
__PACKAGE__->meta->table('requirement_spec_types');
10

  
11
__PACKAGE__->meta->columns(
12
  description => { type => 'text', not_null => 1 },
13
  id          => { type => 'serial', not_null => 1 },
14
  itime       => { type => 'timestamp', default => 'now()' },
15
  mtime       => { type => 'timestamp' },
16
  position    => { type => 'integer', not_null => 1 },
17
);
19 18

  
20
  primary_key_columns => [ 'id' ],
19
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
21 20

  
22
  unique_key => [ 'description' ],
21
__PACKAGE__->meta->unique_keys([ 'description' ]);
23 22

  
24
  allow_inline_column_values => 1,
25
);
23
__PACKAGE__->meta->allow_inline_column_values(1);
26 24

  
27 25
1;
28 26
;
SL/DB/MetaSetup/RequirementSpecVersion.pm
6 6

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

  
9
__PACKAGE__->meta->setup(
10
  table   => 'requirement_spec_versions',
11

  
12
  columns => [
13
    id             => { type => 'serial', not_null => 1 },
14
    version_number => { type => 'integer' },
15
    description    => { type => 'text', not_null => 1 },
16
    comment        => { type => 'text' },
17
    order_date     => { type => 'date' },
18
    order_number   => { type => 'text' },
19
    order_id       => { type => 'integer' },
20
    itime          => { type => 'timestamp', default => 'now()' },
21
    mtime          => { type => 'timestamp' },
22
  ],
23

  
24
  primary_key_columns => [ 'id' ],
25

  
26
  allow_inline_column_values => 1,
27

  
28
  foreign_keys => [
29
    order => {
30
      class       => 'SL::DB::Order',
31
      key_columns => { order_id => 'id' },
32
    },
33
  ],
9
__PACKAGE__->meta->table('requirement_spec_versions');
10

  
11
__PACKAGE__->meta->columns(
12
  comment        => { type => 'text' },
13
  description    => { type => 'text', not_null => 1 },
14
  id             => { type => 'serial', not_null => 1 },
15
  itime          => { type => 'timestamp', default => 'now()' },
16
  mtime          => { type => 'timestamp' },
17
  order_date     => { type => 'date' },
18
  order_id       => { type => 'integer' },
19
  order_number   => { type => 'text' },
20
  version_number => { type => 'integer' },
21
);
22

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

  
25
__PACKAGE__->meta->allow_inline_column_values(1);
26

  
27
__PACKAGE__->meta->foreign_keys(
28
  order => {
29
    class       => 'SL::DB::Order',
30
    key_columns => { order_id => 'id' },
31
  },
34 32
);
35 33

  
36 34
1;
SL/DB/ProjectParticipant.pm
7 7

  
8 8
use SL::DB::MetaSetup::ProjectParticipant;
9 9

  
10
__PACKAGE__->meta->initialize;
11

  
10 12
# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.
11 13
__PACKAGE__->meta->make_manager_class;
12 14

  
SL/DB/ProjectPhase.pm
1
# This file has been auto-generated only because it didn't exist.
2
# Feel free to modify it at will; it will not be overwritten automatically.
3

  
4
package SL::DB::ProjectPhase;
5

  
6
use strict;
7

  
8
use SL::DB::MetaSetup::ProjectPhase;
9

  
10
__PACKAGE__->meta->initialize;
11

  
12
# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.
13
__PACKAGE__->meta->make_manager_class;
14

  
15
1;
SL/DB/ProjectPhaseParticipant.pm
7 7

  
8 8
use SL::DB::MetaSetup::ProjectPhaseParticipant;
9 9

  
10
__PACKAGE__->meta->initialize;
11

  
10 12
# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.
11 13
__PACKAGE__->meta->make_manager_class;
12 14

  
SL/DB/ProjectRole.pm
7 7

  
8 8
use SL::DB::MetaSetup::ProjectRole;
9 9

  
10
__PACKAGE__->meta->initialize;
11

  
10 12
# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.
11 13
__PACKAGE__->meta->make_manager_class;
12 14

  
SL/DB/RequirementSpecAcceptanceStatus.pm
9 9
use SL::DB::Helper::ActsAsList;
10 10
use SL::Locale::String;
11 11

  
12
__PACKAGE__->meta->initialize;
13

  
12 14
our @valid_names = qw(accepted accepted_with_defects accepted_with_defects_to_be_fixed not_accepted);
13 15

  
14 16
sub validate {
SL/DB/RequirementSpecComplexity.pm
7 7
use SL::DB::Helper::ActsAsList;
8 8
use SL::Locale::String;
9 9

  
10
__PACKAGE__->meta->initialize;
11

  
10 12
sub validate {
11 13
  my ($self) = @_;
12 14

  
SL/DB/RequirementSpecDependency.pm
7 7

  
8 8
use SL::DB::MetaSetup::RequirementSpecDependency;
9 9

  
10
__PACKAGE__->meta->initialize;
11

  
10 12
# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.
11 13
__PACKAGE__->meta->make_manager_class;
12 14

  
SL/DB/RequirementSpecPredefinedText.pm
7 7
use SL::DB::Helper::ActsAsList;
8 8
use SL::Locale::String;
9 9

  
10
__PACKAGE__->meta->initialize;
11

  
10 12
sub validate {
11 13
  my ($self) = @_;
12 14

  
SL/DB/RequirementSpecRisk.pm
7 7
use SL::DB::Helper::ActsAsList;
8 8
use SL::Locale::String;
9 9

  
10
__PACKAGE__->meta->initialize;
11

  
10 12
sub validate {
11 13
  my ($self) = @_;
12 14

  
SL/DB/RequirementSpecStatus.pm
9 9
use SL::DB::Helper::ActsAsList;
10 10
use SL::Locale::String;
11 11

  
12
__PACKAGE__->meta->initialize;
13

  
12 14
our @valid_names = qw(planning running done);
13 15

  
14 16
sub validate {
SL/DB/RequirementSpecType.pm
7 7
use SL::DB::Helper::ActsAsList;
8 8
use SL::Locale::String;
9 9

  
10
__PACKAGE__->meta->initialize;
11

  
10 12
sub validate {
11 13
  my ($self) = @_;
12 14

  
SL/DB/RequirementSpecVersion.pm
5 5
use SL::DB::MetaSetup::RequirementSpecVersion;
6 6
use SL::Locale::String;
7 7

  
8
__PACKAGE__->meta->initialize;
9

  
8 10
# Creates get_all, get_all_count, get_all_iterator, delete_all and update_all.
9 11
__PACKAGE__->meta->make_manager_class;
10 12

  

Auch abrufbar als: Unified diff