verleihnix/Verleihnix/impl/data/schema.xml

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <database name="mkrimi" defaultIdMethod="native">
   3         <table name="medium">
   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"/>
  12         </table>
  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"/>
  20         </table>
  21 </database>