-- News
ALTER TABLE  `qs_News`
  ADD  `alias` VARCHAR( 255 ) NULL DEFAULT NULL AFTER  `title` ,
  ADD UNIQUE (`alias`);

UPDATE `qs_News` SET `alias` = REPLACE(REPLACE(REPLACE(LOWER(title), ' ', '-'), '!', ''), '.', '')  WHERE 1;

ALTER TABLE `qs_News`
  CHANGE  `alias`  `alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;

-- Our Team
ALTER TABLE  `qs_People`
  ADD  `alias` VARCHAR( 255 ) NULL DEFAULT NULL AFTER  `name` ,
  ADD UNIQUE (`alias`);

UPDATE `qs_People` SET `alias` = REPLACE(REPLACE(REPLACE(LOWER(name), ' ', '-'), '!', ''), '.', '')  WHERE 1;

ALTER TABLE  `qs_People`
  CHANGE  `alias`  `alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;

ALTER TABLE  `qs_People`
  ADD  `metaKeywords` TEXT NOT NULL AFTER  `metaTitle` ,
  ADD  `metaDescription` TEXT NOT NULL AFTER  `metaKeywords` ;


-- Faq Category
ALTER TABLE  `qs_FaqCategory`
  ADD  `alias` VARCHAR( 255 ) NULL DEFAULT NULL AFTER  `title` ,
  ADD  `metaTitle` VARCHAR( 255 ) NOT NULL AFTER  `alias` ,
  ADD  `metaKeywords` TEXT NOT NULL AFTER  `metaTitle` ,
  ADD  `metaDescription` TEXT NOT NULL AFTER  `metaKeywords` ,
  ADD UNIQUE (`alias`);

UPDATE `qs_FaqCategory` SET `alias` = REPLACE(REPLACE(REPLACE(LOWER(title), ' ', '-'), '!', ''), '.', '')  WHERE 1;

ALTER TABLE  `qs_FaqCategory`
  CHANGE  `alias`  `alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;

-- Gallery
ALTER TABLE  `qs_Gallery`
  ADD  `alias` VARCHAR( 255 ) NULL DEFAULT NULL AFTER  `title` ,
  ADD UNIQUE (`alias`);

UPDATE `qs_Gallery` SET `alias` = REPLACE(REPLACE(REPLACE(LOWER(title), ' ', '-'), '!', ''), '.', '')  WHERE 1;

ALTER TABLE  `qs_Gallery`
  CHANGE  `alias`  `alias` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;

ALTER TABLE  `qs_Gallery`
  ADD  `metaKeywords` TEXT NOT NULL AFTER  `metaTitle` ,
  ADD  `metaDescription` TEXT NOT NULL AFTER  `metaKeywords` ;

ALTER TABLE  `qs_Gallery` CHANGE  `show`  `enabled` ENUM(  'y',  'n' ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  'y';
ALTER TABLE  `qs_GalleryImage` CHANGE  `show`  `enabled` ENUM(  'y',  'n' ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  'y';
