11762 use doctrine for schema creation and update
[tine20] / tine20 / Inventory / Setup / setup.xml
index e632650..3f0abe1 100644 (file)
@@ -2,158 +2,7 @@
 <application>
     <name>Inventory</name>
     <!-- gettext('Inventory') -->   
-    <version>9.0</version>
+    <version>10</version>
     <order>60</order>
     <status>enabled</status>
-    <tables>
-        <table>
-            <name>inventory_item</name>
-            <version>6</version>
-            <declaration>
-                <field>
-                    <name>id</name>
-                    <type>text</type>
-                    <length>40</length>
-                    <notnull>true</notnull>
-                </field>
-                <field>
-                    <name>container_id</name>
-                    <type>integer</type>
-                    <notnull>false</notnull>
-                </field>
-                <field>
-                    <name>name</name>
-                    <type>text</type>
-                    <length>250</length>
-                    <notnull>true</notnull>
-                </field>
-                <!-- keyfield 'status' -->
-                <field>
-                    <name>status</name>
-                    <type>text</type>
-                    <length>40</length>
-                </field>
-                <!-- add more fields here -->
-                <field>
-                    <name>inventory_id</name>
-                    <type>text</type>
-                    <length>100</length>
-                    <notnull>false</notnull>
-                </field>
-                <field>
-                    <name>description</name>
-                    <type>text</type>
-                    <notnull>false</notnull>
-                </field>
-                <field>
-                    <name>location</name>
-                    <type>text</type>
-                    <length>255</length>
-                </field>
-                <field>
-                    <name>total_number</name>
-                    <type>integer</type>
-                    <notnull>false</notnull>
-                </field>
-                <field>
-                    <name>active_number</name>
-                    <type>integer</type>
-                    <notnull>false</notnull>
-                </field>
-                <field>
-                    <name>invoice</name>
-                    <type>text</type>
-                    <length>255</length>
-                </field>
-                <field>
-                    <name>invoice_date</name>
-                    <type>datetime</type>
-                    <notnull>false</notnull>
-                </field>
-                <field>
-                    <name>price</name>
-                    <type>text</type>
-                    <length>50</length>
-                </field>
-                <field>
-                    <name>costcentre</name>
-                    <type>text</type>
-                    <length>255</length>
-                </field>
-                <field>
-                    <name>warranty</name>
-                    <type>datetime</type>
-                </field>
-                <field>
-                    <name>added_date</name>
-                    <type>datetime</type>
-                </field>
-                <field>
-                    <name>removed_date</name>
-                    <type>datetime</type>
-                </field>
-                <field>
-                    <name>depreciate_status</name>
-                    <type>boolean</type>
-                    <default>false</default>
-                </field>
-                <!-- defaults for tine system -->
-                <field>
-                    <name>created_by</name>
-                    <type>text</type>
-                    <length>40</length>
-                </field>
-                <field>
-                    <name>creation_time</name>
-                    <type>datetime</type>
-                </field> 
-                <field>
-                    <name>last_modified_by</name>
-                    <type>text</type>
-                    <length>40</length>
-                </field>
-                <field>
-                    <name>last_modified_time</name>
-                    <type>datetime</type>
-                </field>
-                <field>
-                    <name>is_deleted</name>
-                    <type>boolean</type>
-                    <default>false</default>
-                </field>
-                <field>
-                    <name>deleted_by</name>
-                    <type>text</type>
-                    <length>40</length>
-                </field>
-                <field>
-                    <name>deleted_time</name>
-                    <type>datetime</type>
-                </field>
-                <field>
-                    <name>seq</name>
-                    <type>integer</type>
-                    <notnull>true</notnull>
-                    <default>0</default>
-                </field>
-                <field>
-                    <name>adt_info</name>
-                    <type>text</type>
-                </field>
-                <index>
-                    <name>id</name>
-                    <primary>true</primary>
-                    <field>
-                        <name>id</name>
-                    </field>
-                </index>
-                <index>
-                    <name>container_id</name>
-                    <field>
-                        <name>container_id</name>
-                    </field>
-                </index>
-            </declaration>
-        </table>
-    </tables>
 </application>