Use multi-pass table creation in MySQL

This deals with table creation order and circular dependencies.
Unfortunately, there doesn't seem to be a way in MySQL to drop
a foreign key only if it exists without resorting to stored
procedures.

1 files changed, 24 insertions, 0 deletions

diff --git a/common/schema/embedded/order/test1.hxx b/common/schema/embedded/order/test1.hxx
new file mode 100644
index 0000000..d7e0622
--- /dev/null
+++ b/common/schema/embedded/order/test1.hxx
@@ -0,0 +1,24 @@
+// file      : common/schema/embedded/order/test1.hxx
+// copyright : Copyright (c) 2009-2012 Code Synthesis Tools CC
+// license   : GNU GPL v2; see accompanying LICENSE file
+
+#ifndef TEST1_HXX
+#define TEST1_HXX
+
+#include <string>
+
+#include <odb/core.hxx>
+
+#pragma db object polymorphic
+struct base
+{
+  virtual
+  ~base () {}
+
+  #pragma db auto id
+  unsigned long id;
+
+  std::string str;
+};
+
+#endif // TEST1_HXX