Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » Automatic Upgrade MySQL schema
Automatic Upgrade MySQL schema [message #37368] Fri, 28 September 2012 04:48 Go to previous message
sergeynikitin is currently offline  sergeynikitin
Messages: 748
Registered: January 2008
Location: Moscow, Russia
Contributor

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 );
}
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: XmlNode and text
Next Topic: List DSN in ODBC
Goto Forum:
  


Current Time: Thu May 16 19:12:17 CEST 2024

Total time taken to generate the page: 0.02985 seconds