X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/projects.git/blobdiff_plain/44eb47b422753bc1aa790741beb17912933c07cd..b7dc2b69d6f7d354ddd82fc3f64fed711ceb317d:/verleihnix/Verleihnix/impl/data/build/sql/schema.sql

diff --git a/verleihnix/Verleihnix/impl/data/build/sql/schema.sql b/verleihnix/Verleihnix/impl/data/build/sql/schema.sql
new file mode 100644
index 0000000..34d1c8e
--- /dev/null
+++ b/verleihnix/Verleihnix/impl/data/build/sql/schema.sql
@@ -0,0 +1,43 @@
+
+# This is a fix for InnoDB in MySQL >= 4.1.x
+# It "suspends judgement" for fkey relationships until are tables are set.
+SET FOREIGN_KEY_CHECKS = 0;
+
+-- ---------------------------------------------------------------------
+-- medium
+-- ---------------------------------------------------------------------
+
+DROP TABLE IF EXISTS `medium`;
+
+CREATE TABLE `medium`
+(
+    `id` INTEGER NOT NULL AUTO_INCREMENT,
+    `mod` INTEGER NOT NULL,
+    `autor` VARCHAR(100) NOT NULL,
+    `titel` VARCHAR(100) NOT NULL,
+    `eigentumer` VARCHAR(100) NOT NULL,
+    `zz_bei` VARCHAR(100) NOT NULL,
+    `kommentar` VARCHAR(100) NOT NULL,
+    `class_key` INTEGER NOT NULL,
+    PRIMARY KEY (`id`)
+) ENGINE=MyISAM;
+
+-- ---------------------------------------------------------------------
+-- werkzeug
+-- ---------------------------------------------------------------------
+
+DROP TABLE IF EXISTS `werkzeug`;
+
+CREATE TABLE `werkzeug`
+(
+    `id` INTEGER NOT NULL AUTO_INCREMENT,
+    `mod` INTEGER NOT NULL,
+    `typ` VARCHAR(100) NOT NULL,
+    `beschreibung` VARCHAR(100) NOT NULL,
+    `eigentumer` VARCHAR(100) NOT NULL,
+    `zz_bei` VARCHAR(100) NOT NULL,
+    PRIMARY KEY (`id`)
+) ENGINE=MyISAM;
+
+# This restores the fkey checks, after having unset them earlier
+SET FOREIGN_KEY_CHECKS = 1;