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, 0 insertions, 157 deletions

diff --git a/common/schema/test.hxx b/common/schema/test.hxx
deleted file mode 100644
index 5e30518..0000000
--- a/common/schema/test.hxx
+++ /dev/null
@@ -1,157 +0,0 @@
-// file      : common/schema/test.hxx
-// copyright : Copyright (c) 2009-2012 Code Synthesis Tools CC
-// license   : GNU GPL v2; see accompanying LICENSE file
-
-#ifndef TEST_HXX
-#define TEST_HXX
-
-#include <string>
-#include <vector>
-
-#include <odb/core.hxx>
-
-// Table names.
-//
-#pragma db object table("TABLE_EXPLICIT")
-struct table_explicit
-{
-  #pragma db id
-  unsigned long id_;
-};
-
-#pragma db object
-struct table_implicit
-{
-  #pragma db id
-  unsigned long id_;
-};
-
-// Column names.
-//
-#pragma db object
-struct column
-{
-  #pragma db id
-  int m1;
-
-  #pragma db column("foo")
-  int m2;
-
-  int m_m3;
-  int _m4;
-  int m5_;
-  int m_;
-  int m__;
-};
-
-// Column types.
-//
-#pragma db object
-struct type
-{
-  #pragma db id
-  std::string id;
-
-  // Test default C++ to DB type mapping.
-  //
-  bool b;
-  char c;
-  signed char sc;
-  unsigned char uc;
-  short s;
-  unsigned short us;
-  int i;
-  unsigned int ui;
-  long l;
-  unsigned long ul;
-  long long ll;
-  unsigned long long ull;
-  float f;
-  double d;
-  std::string str;
-
-  #pragma db type("INTEGER")
-  bool m1;
-
-  #pragma db transient
-  char* m2;
-};
-
-// Test database schema (aka database namespace).
-//
-#ifdef ODB_COMPILER
-#if defined (ODB_DATABASE_MYSQL)
-//#  define DB_SCHEMA "odb_test"
-#  define DB_SCHEMA ""
-#elif defined (ODB_DATABASE_SQLITE)
-#  define DB_SCHEMA "main"
-#elif defined (ODB_DATABASE_PGSQL)
-#  define DB_SCHEMA "public"
-#elif defined (ODB_DATABASE_ORACLE)
-//#  define DB_SCHEMA "ODB_TEST"
-#  define DB_SCHEMA ""
-#elif defined(ODB_DATABASE_MSSQL)
-#  define DB_SCHEMA "dbo"
-#else
-#  error unknown database
-#endif
-#endif
-
-namespace ns {typedef int my_int;} // Original.
-
-#pragma db object table(DB_SCHEMA."object_1")
-struct object1
-{
-  #pragma db id auto
-  unsigned long id;
-
-  #pragma db column("str")
-  std::string str;
-};
-
-inline bool
-operator== (const object1& x, const object1& y)
-{
-  return x.id == y.id && x.str == y.str;
-}
-
-#pragma db namespace schema(DB_SCHEMA)
-namespace ns // Extension.
-{
-  #pragma db object
-  struct object2
-  {
-    object2 (): obj1 (0) {}
-    ~object2 () {delete obj1;}
-
-    #pragma db id
-    std::string id;
-
-    std::vector<unsigned int> nums;
-    object1* obj1;
-  };
-
-  inline bool
-  operator== (const object2& x, const object2& y)
-  {
-    return x.id == y.id && x.nums == y.nums && *x.obj1 == *y.obj1;
-  }
-}
-
-#pragma db view object(object1) object(ns::object2)
-struct object_view
-{
-  #pragma db column(ns::object2::id)
-  std::string id2;
-
-  std::string str;
-};
-
-#pragma db view table(DB_SCHEMA."schema_object_1")
-struct table_view
-{
-  #pragma db column(DB_SCHEMA."schema_object_1"."str")
-  std::string str;
-};
-
-#endif // TEST_HXX