d4e1e8a490e0bb397d3f5ec1ad63ae44ed6cbeef
[tine20] / tine20 / Tool / Application / templates / Setup / setup.xml
1 <?xml version="1.0" encoding="utf-8"?>
2 <application>
3     <name>ExampleApplication</name>
4     <!-- gettext('ExampleApplication') -->   
5     <version>0.1</version>
6     <order>60</order>
7     <status>disabled</status>
8     <tables>
9         <table>
10             <name>example_application_record</name>
11             <version>1</version>
12             <declaration>
13                 <field>
14                     <name>id</name>
15                     <type>text</type>
16                     <length>40</length>
17                     <notnull>true</notnull>
18                 </field>
19                 <field>
20                     <name>container_id</name>
21                     <type>integer</type>
22                     <notnull>false</notnull>
23                 </field>
24                 <field>
25                     <name>name</name>
26                     <type>text</type>
27                     <length>255</length>
28                     <notnull>true</notnull>
29                 </field>
30                 <!-- keyfield 'status' -->
31                 <field>
32                     <name>status</name>
33                     <type>text</type>
34                     <length>40</length>
35                     <default>IN-PROCESS</default>
36                     <notnull>true</notnull>
37                 </field>
38                 <!-- add more fields here -->
39                 <!-- defaults for tine system -->
40                 <field>
41                     <name>created_by</name>
42                     <type>text</type>
43                     <length>40</length>
44                 </field>
45                 <field>
46                     <name>creation_time</name>
47                     <type>datetime</type>
48                 </field> 
49                 <field>
50                     <name>last_modified_by</name>
51                     <type>text</type>
52                     <length>40</length>
53                 </field>
54                 <field>
55                     <name>last_modified_time</name>
56                     <type>datetime</type>
57                 </field>
58                 <field>
59                     <name>is_deleted</name>
60                     <type>boolean</type>
61                     <default>false</default>
62                 </field>
63                 <field>
64                     <name>deleted_by</name>
65                     <type>text</type>
66                     <length>40</length>
67                 </field>
68                 <field>
69                     <name>deleted_time</name>
70                     <type>datetime</type>
71                 </field>
72                 <field>
73                     <name>seq</name>
74                     <type>integer</type>
75                     <notnull>true</notnull>
76                     <default>0</default>
77                 </field>
78                 <index>
79                     <name>id</name>
80                     <primary>true</primary>
81                     <field>
82                         <name>id</name>
83                     </field>
84                 </index>
85                 <index>
86                     <name>container_id</name>
87                     <field>
88                         <name>container_id</name>
89                     </field>
90                 </index>
91             </declaration>
92         </table>
93     </tables>
94 </application>