aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--odb/qt/basic/mysql/default-mapping.hxx5
-rw-r--r--odb/qt/basic/sqlite/default-mapping.hxx4
-rw-r--r--odb/qt/date-time/mysql/default-mapping.hxx6
-rw-r--r--odb/qt/date-time/sqlite/default-mapping.hxx6
4 files changed, 10 insertions, 11 deletions
diff --git a/odb/qt/basic/mysql/default-mapping.hxx b/odb/qt/basic/mysql/default-mapping.hxx
index d111a08..e26e73e 100644
--- a/odb/qt/basic/mysql/default-mapping.hxx
+++ b/odb/qt/basic/mysql/default-mapping.hxx
@@ -12,12 +12,11 @@
// By default, map QString to MySQL TEXT for non-id and to VARCHAR(256) for
// id members. MySQL cannot have primary keys of the TEXT type.
//
-#pragma db value(QString) type("TEXT NOT NULL") \
- id_type("VARCHAR(256) NOT NULL")
+#pragma db value(QString) type("TEXT") id_type("VARCHAR(256)")
// Map QByteArray to MySQL BLOB by default. Allow NULL values by default as
// QByteArray provides a null representation.
//
-#pragma db value(QByteArray) type("BLOB")
+#pragma db value(QByteArray) type("BLOB") null
#endif // ODB_QT_BASIC_MYSQL_DEFAULT_MAPPING_HXX
diff --git a/odb/qt/basic/sqlite/default-mapping.hxx b/odb/qt/basic/sqlite/default-mapping.hxx
index cc04ddd..2526121 100644
--- a/odb/qt/basic/sqlite/default-mapping.hxx
+++ b/odb/qt/basic/sqlite/default-mapping.hxx
@@ -12,11 +12,11 @@
// Map QString to SQLite TEXT by default. Allow NULL values by default as
// QString provides a null representation.
//
-#pragma db value(QString) type("TEXT")
+#pragma db value(QString) type("TEXT") null
// Map QByteArray to SQLite BLOB by default. Allow NULL values by default as
// QByteArray provides a null representation.
//
-#pragma db value(QByteArray) type("BLOB")
+#pragma db value(QByteArray) type("BLOB") null
#endif // ODB_QT_BASIC_SQLITE_DEFAULT_MAPPING_HXX
diff --git a/odb/qt/date-time/mysql/default-mapping.hxx b/odb/qt/date-time/mysql/default-mapping.hxx
index 250d668..ba94108 100644
--- a/odb/qt/date-time/mysql/default-mapping.hxx
+++ b/odb/qt/date-time/mysql/default-mapping.hxx
@@ -13,16 +13,16 @@
// Map QDate to MySQL DATE by default. QDate provides a null
// representation so allow NULL values by default.
//
-#pragma db value(QDate) type("DATE")
+#pragma db value(QDate) type("DATE") null
// Map QTime to MySQL TIME by default. QTime provides a null
// representation so allow NULL values by default.
//
-#pragma db value(QTime) type("TIME")
+#pragma db value(QTime) type("TIME") null
// Map QDateTime to MySQL DATETIME by default. QDateTime provides a null
// representation so allow NULL values by default.
//
-#pragma db value(QDateTime) type("DATETIME")
+#pragma db value(QDateTime) type("DATETIME") null
#endif // ODB_QT_DATE_TIME_MYSQL_DEFAULT_MAPPING_HXX
diff --git a/odb/qt/date-time/sqlite/default-mapping.hxx b/odb/qt/date-time/sqlite/default-mapping.hxx
index e497e96..fa10996 100644
--- a/odb/qt/date-time/sqlite/default-mapping.hxx
+++ b/odb/qt/date-time/sqlite/default-mapping.hxx
@@ -13,16 +13,16 @@
// Map QDate to SQLite TEXT by default. QDate provides a null representation
// so allow NULL values by default.
//
-#pragma db value(QDate) type("TEXT")
+#pragma db value(QDate) type("TEXT") null
// Map QTime to SQLite TEXT by default. QTime provides a null representation
// so allow NULL values by default.
//
-#pragma db value(QTime) type("TEXT")
+#pragma db value(QTime) type("TEXT") null
// Map QDateTime to SQLite TEXT by default. QDateTime provides a null
// representation so allow NULL values by default.
//
-#pragma db value(QDateTime) type("TEXT")
+#pragma db value(QDateTime) type("TEXT") null
#endif // ODB_QT_DATE_TIME_SQLITE_DEFAULT_MAPPING_HXX