1 <?xml version="1.0" encoding="UTF-8"?>
2 <database name="mkrimi" defaultIdMethod="native">
4 <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
5 <column name="mod" type="integer" required="true"/>
6 <column name="autor" type="varchar" size="100" required="true"/>
7 <column name="titel" type="varchar" size="100" required="true"/>
8 <column name="eigentumer" type="varchar" size="100" required="true"/>
9 <column name="zz_bei" type="varchar" size="100" required="true"/>
10 <column name="kommentar" type="varchar" size="100" required="true"/>
11 <column name="class_key" type="integer" required="true" inheritance="single">
12 <inheritance key="1" class="Krimi" extends="Medium"/>
13 <inheritance key="2" class="Horbuch" extends="Medium"/>
14 <inheritance key="3" class="Roman" extends="Medium"/>
17 <table name="werkzeug">
18 <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
19 <column name="mod" type="integer" required="true"/>
20 <column name="typ" type="varchar" size="100" required="true"/>
21 <column name="beschreibung" type="varchar" size="100" required="true"/>
22 <column name="eigentumer" type="varchar" size="100" required="true"/>
23 <column name="zz_bei" type="varchar" size="100" required="true"/>