Database changes
- From: Thomas Wood <thos gnome org>
- To: artweb-list gnome org
- Subject: Database changes
- Date: Sat, 06 May 2006 16:34:08 +0100
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 ;
[Date Prev][
Date Next] [Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]