Database changes

[Thomas Wood <thos gnome org>]

Benjamin Berg has been doing some work to clean up the database field 
names, etc, in art-web. For anyone currently working on the code from 
CVS, I've attached the SQL script needed to convert from the old names 
to the new ones. I'll create a new schema soon for creating an initial 
set up.

-Thomas

ALTER TABLE `theme` CHANGE `theme_name` `name` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE `background` CHANGE `background_name` `name` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE `contest` CHANGE `name` `name` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE `screenshot` CHANGE `name` `name` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE `incoming_background` CHANGE `background_name` `name` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE `incoming_theme` CHANGE `theme_name` `name` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;

ALTER TABLE `theme` CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE `background` CHANGE `background_description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE `contest` CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE `screenshot` CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE `incoming_theme` CHANGE `theme_description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE `incoming_background` CHANGE `background_description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;

ALTER TABLE `theme` CHANGE `thumbnail_filename` `preview_filename` VARCHAR( 50 ) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ;
ALTER TABLE `theme` CHANGE `small_thumbnail_filename` `thumbnail_filename` VARCHAR( 50 ) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ;
ALTER TABLE `contest` CHANGE `thumbnail_filename` `preview_filename` VARCHAR( 50 ) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ;
ALTER TABLE `contest` CHANGE `small_thumbnail_filename` `thumbnail_filename` VARCHAR( 50 ) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ;
ALTER TABLE `background` CHANGE `thumbnail_filename` `thumbnail_filename` VARCHAR( 50 ) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ;
ALTER TABLE `screenshot` CHANGE `thumbnail_filename` `thumbnail_filename` VARCHAR( 50 ) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ;

ALTER TABLE `contest` CHANGE `contest` `category` VARCHAR ( 30 ) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ;
ALTER TABLE `screenshot` CHANGE `category` `category` VARCHAR ( 30 ) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ;
ALTER TABLE `background` CHANGE `category` `category` VARCHAR ( 30 ) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ;
ALTER TABLE `theme` CHANGE `category` `category` VARCHAR ( 30 ) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ;