Subversion-Projekte lars-tiefland.php_share

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1
connection:           propel
2
defaultIdMethod:      none
3
package:              lib.model
4
propel_behaviors:
5
  timestampable:
6
    boolean:       true
7
    create_column: create_date
8
 
9
classes:
10
  Group:
11
    tableName:        ab_group
12
    package:          foo.bar.lib.model
13
    columns:
14
      id:
15
      name:           varchar(50)
16
      type:           varchar(50)
17
    inheritance:
18
      column:         type
19
      classes:
20
        tight:        Group_Tight
21
        loose:        { phpName: Group_Loose, package: some.other.package }
22
 
23
  User:
24
    tableName:        cd_user
25
    isI18N:           true
26
    i18nTable:        cd_user_i18n
27
    columns:
28
      first_name:     { type: varchar, size: 255, default: "Anonymous" }
29
      last_name:      varchar(50)
30
      age:            { type: integer, required: true, index: true }
31
      ab_group_id:
32
      created_at:
33
 
34
  CdUserI18n:
35
    tableName:        cd_user_i18n
36
    columns:
37
      description:    longvarchar
38
 
39
  EfArticle:
40
    tableName:       ef_article
41
    columns:
42
      title:          { type: longvarchar, required: true, index: unique }
43
      stripped_title: { type: longvarchar, required: true, primaryKey: true, sequence: my_custom_sequence_name }
44
      user_id:
45
      my_group:       { type: integer, foreignTable: ab_group, foreignReference: id, onDelete: setnull }
46
      my_other_group: { type: integer, foreignTable: ab_group, foreignReference: id, onDelete: setnull, phpName: MyOtherGroupPhpName, fkPhpName: MyOtherGroupFkPhpName, fkRefPhpName: MyOtherGroupFkRefPhpName }
47
      created_at:     timestamp
48
      updated_at:
49
 
50
  Article:
51
    tableName:        ij_article
52
    columns:
53
      title:          varchar(50)
54
      user_id:        { type: integer }
55
      created_at:
56
    foreignKeys:
57
      -
58
        foreignTable: cd_user
59
        onDelete:     cascade
60
        phpName:      SomePhpName
61
        refPhpName:   SomeRefPhpName
62
        references:
63
          - { local: user_id, foreign: id }
64
    indexes:
65
      my_index:       [title(10), user_id]
66
    uniques:
67
      my_other_index: [created_at(10)]
68
    behaviors:
69
      paranoid: { column: deleted_at }
70
      act_as_nested_set:
71
    propel_behaviors:
72
      paranoid: { column: deleted_at }
73
      act_as_nested_set:
74
 
75
  KlArticle:
76
    tableName:        kl_article
77
    columns:
78
      title:          varchar(50)
79
      user_id:        { type: integer, phpName: AuthorId }
80
    foreignKeys:
81
      -
82
        foreignClass: User
83
        phpName: Author
84
        references:
85
          -  { local: user_id, foreign: id }
86
 
87
  AbGroupI18n:
88
    tableName:        ab_group_i18n
89
    columns:
90
      motto:          longvarchar
91
 
92
  History:
93
    tableName:      history
94
    columns:
95
      id:
96
      type:         { type: varchar(64) }
97
    inheritance:
98
      column:       type
99
      classes:
100
        new_user:   History_NewUser
101
        new_page:   History_NewPage
102
 
103
  myNestedSetNode:
104
    tableName: my_nested_sets
105
    columns:
106
      id:
107
      lft: { type: integer, required: true }
108
      rgt: { type: integer, required: true }
109
      scope: { type: integer, required: true }
110
    nestedSet:
111
      left: lft
112
      right: rgt
113
      scope: scope