Home » U++ Library support » U++ SQL » Automatic Upgrade MySQL schema
Automatic Upgrade MySQL schema [message #37368] |
Fri, 28 September 2012 04:48 |
|
I discover,that MySQL automatic schema upgrade is not work normally on Mysql server ver 5.5.
I propose this change to Package Sql, file SqlSchema.cpp
(added Rows 25-28)
if(dialect == MSSQL) {
Upgrade() << Expand("alter table @t add ") << cn << ";\n";
Upgrade() << Expand("alter table @t alter column ") << cd << ";\n";
}
else if(dialect == MY_SQL) //Added
Upgrade() << Expand("alter table @t add ") << cn << ";\n"; //Added
Upgrade() << Expand("alter table @t modify ") << cd << ";\n"; //Added
} //Added
else if (dialect == SQLITE3)
Upgrade() << Expand("alter table @t add ") << cd << ";\n";
SergeyNikitin<U++>( linux, wine )
{
under( Ubuntu || Debian || Raspbian );
}
|
|
|
Goto Forum:
Current Time: Thu May 16 19:12:17 CEST 2024
Total time taken to generate the page: 0.02985 seconds
|