posaune

diff --git a/Mitgliederverwaltung/AWK/impl/data/schema.xml b/Mitgliederverwaltung/AWK/impl/data/schema.xml
index 48b7a8cbb7a4af8cd7439c17ee56fa2617bd8ee3..62162b7d0d6968bd7186c80d4fbdf8ca19cdabbf 100644 (file)
--- a/Mitgliederverwaltung/AWK/impl/data/schema.xml
+++ b/Mitgliederverwaltung/AWK/impl/data/schema.xml
@@ -11,7 +11,15 @@
                <column name="zahlweise" type="integer" required="true"/>
                <column name="iban" type="char" size="20" required="true"/>
                <column name="bic" type="char" size="10" required="true"/>
                <column name="zahlweise" type="integer" required="true"/>
                <column name="iban" type="char" size="20" required="true"/>
                <column name="bic" type="char" size="10" required="true"/>

+       </table>
+       <table name="stamm_kommentar">
+               <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
+               <column name="erstellt_am" type="integer" required="true"/>

                <column name="kommentar" type="varchar" size="1000" required="true"/>
                <column name="kommentar" type="varchar" size="1000" required="true"/>

+               <column name="stamm_id" type="integer" required="true"/>
+               <foreign-key foreignTable="stamm" refPhpName="Grundstuck">
+                       <reference local="stamm_id" foreign="id"/>
+               </foreign-key>

        </table>
        <table name="grundstuck">
                <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
        </table>
        <table name="grundstuck">
                <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>