From 451b564293dd9904b73d6d5b71eb3467be8f48a3 Mon Sep 17 00:00:00 2001 From: Boris Kolpackov Date: Sun, 24 Apr 2011 11:27:46 +0200 Subject: Provide proper QString to MySQL type mapping --- odb/qt/basic/mysql/default-mapping.hxx | 9 ++++----- 1 file changed, 4 insertions(+), 5 deletions(-) diff --git a/odb/qt/basic/mysql/default-mapping.hxx b/odb/qt/basic/mysql/default-mapping.hxx index de73007..8ffcafe 100644 --- a/odb/qt/basic/mysql/default-mapping.hxx +++ b/odb/qt/basic/mysql/default-mapping.hxx @@ -9,12 +9,11 @@ #include #include -// Map QString to MySQL VARCHAR (56) by default. +// 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. // -// @@ Temporary mapping until a solution for specifying primary key type -// has been implemented. -// -#pragma db value(QString) type("VARCHAR(56) NOT NULL") +#pragma db value(QString) type("TEXT NOT NULL") \ + id_type("VARCHAR(256) NOT NULL") // Map QByteArray to MySQL BLOB by default. Allow NULL values by default as // QByteArray provides a null representation. -- cgit v1.1