id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
7272	Installation / update trac.db does not work with sqlite	hju	coling	"The Update-process ´do_db_upgrade´ (api.py) is not running with sqlite 
{{{
            if self.db_installed_version < 6:
                print 'Updating clients table (v6)'
                cursor.execute('ALTER TABLE client '
                               'CHANGE COLUMN default_rate default_rate DECIMAL(10,2)')
}}}
The ALTER TABLE statement in SQLITE does not understand CHANGE COLUMN.
The update-process indicates no error. The error is only found in trag.log
{{{
 * Upgrading db
Creating client table
Updating clients table (v3)
Updating clients table (v4)
Updating clients table (v5)
Updating clients table (v6)
 * Upgrading reports
Done Upgrading
Upgrade done.
}}}

I managed the installation by creating the table clients with the column `default_rate` in format 10.2 and setting `clients_plugin_version` to 6 manualy"	defect	closed	normal	ClientsPlugin	normal	fixed			0.11