The Subversion trunk is getting hot today. Because one of the longest required functionality is ready for testing now — full ALTER TABLE is working there.
And one more important fix follows: some Sqliteman-1.0.1 rpm packages for Fedora Core contains a installation bug which prevents displaying of icons, help files and translations. It’s fixed now. The glory and six Tuborg beers go to Eugene Pivnev.
That’s the way I like worldwide cooperation.
Now back to the trunk. Maybe it doesn’t sound interesting to you… You should know then than Sqlite3 doesn’t support dropping columns from the existing table. And it could be done easily in Sqliteman directly. There are various operations hidden under one click in the GUI — creating temporary table, insert-selecting, data moving, indexes and triggers recreation.