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="buch_typ" type="integer" required="true"/>
13 <table name="werkzeug">
14 <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
15 <column name="mod" type="integer" required="true"/>
16 <column name="typ" type="varchar" size="100" required="true"/>
17 <column name="beschreibung" type="varchar" size="100" required="true"/>
18 <column name="eigentumer" type="varchar" size="100" required="true"/>
19 <column name="zz_bei" type="varchar" size="100" required="true"/>