gitarre

[SVBaL.git] / Mitgliederverwaltung / AWK / impl / data / schema.xml

diff --git a/Mitgliederverwaltung/AWK/impl/data/schema.xml b/Mitgliederverwaltung/AWK/impl/data/schema.xml
new file mode 100644 (file)
index 0000000..8053f2e
--- /dev/null
+++ b/Mitgliederverwaltung/AWK/impl/data/schema.xml
@@ -0,0 +1,25 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<database name="mkrimi" defaultIdMethod="native">
+       <table name="medium">
+               <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
+               <column name="mod" type="integer" required="true"/>
+               <column name="autor" type="varchar" size="100" required="true"/>
+               <column name="titel" type="varchar" size="100" required="true"/>
+               <column name="eigentumer" type="varchar" size="100" required="true"/>
+               <column name="zz_bei" type="varchar" size="100" required="true"/>
+               <column name="kommentar" type="varchar" size="100" required="true"/>
+               <column name="class_key" type="integer" required="true" inheritance="single">
+                       <inheritance key="1" class="Krimi" extends="Medium"/>
+                       <inheritance key="2" class="Horbuch" extends="Medium"/>
+                       <inheritance key="3" class="Roman" extends="Medium"/>
+               </column>
+       </table>
+       <table name="werkzeug">
+               <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
+               <column name="mod" type="integer" required="true"/>
+               <column name="typ" type="varchar" size="100" required="true"/>
+               <column name="beschreibung" type="varchar" size="100" required="true"/>
+               <column name="eigentumer" type="varchar" size="100" required="true"/>
+               <column name="zz_bei" type="varchar" size="100" required="true"/>
+       </table>
+</database>