From 3eb4077bbff58acb271c6667576b41b029751400 Mon Sep 17 00:00:00 2001
From: Michael Wagner <michael@wagnertech.de>
Date: Mon, 6 Feb 2023 14:22:51 +0100
Subject: [PATCH] gitarre

---
 .../AWK/impl/data/build.properties            |  5 ++++
 .../AWK/impl/data/runtime-conf.xml            | 25 +++++++++++++++++++
 Mitgliederverwaltung/AWK/impl/data/schema.xml | 25 +++++++++++++++++++
 3 files changed, 55 insertions(+)
 create mode 100644 Mitgliederverwaltung/AWK/impl/data/build.properties
 create mode 100644 Mitgliederverwaltung/AWK/impl/data/runtime-conf.xml
 create mode 100644 Mitgliederverwaltung/AWK/impl/data/schema.xml

diff --git a/Mitgliederverwaltung/AWK/impl/data/build.properties b/Mitgliederverwaltung/AWK/impl/data/build.properties
new file mode 100644
index 0000000..82cc9ed
--- /dev/null
+++ b/Mitgliederverwaltung/AWK/impl/data/build.properties
@@ -0,0 +1,5 @@
+# Database driver
+propel.database = mysql
+
+# Project name
+propel.project = propel
diff --git a/Mitgliederverwaltung/AWK/impl/data/runtime-conf.xml b/Mitgliederverwaltung/AWK/impl/data/runtime-conf.xml
new file mode 100644
index 0000000..25eec8f
--- /dev/null
+++ b/Mitgliederverwaltung/AWK/impl/data/runtime-conf.xml
@@ -0,0 +1,25 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<config>
+  <!-- Uncomment this if you have PEAR Log installed -->
+  <!--log>
+    <type>file</type>
+    <name>/tmp/propel.log</name>
+    <ident>AlarmManagement</ident>
+    <level>7</level>
+  </log-->
+  <propel>
+    <datasources default="mkrimi">
+      <datasource id="mkrimi">
+        <adapter>mysql</adapter> <!-- sqlite, mysql, myssql, oracle, or pgsql -->
+        <connection>
+          <dsn>mysql:host=localhost;dbname=mkrimi</dsn>
+          <user>mkrimi</user>
+          <password>mkrimi</password>
+          <settings>
+            <setting id="charset">utf8</setting>
+          </settings>
+        </connection>
+      </datasource>
+    </datasources>
+  </propel>
+</config>
diff --git a/Mitgliederverwaltung/AWK/impl/data/schema.xml b/Mitgliederverwaltung/AWK/impl/data/schema.xml
new file mode 100644
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>
-- 
2.20.1