# Linea21 DB patch - UTF-8 format
# patch v1.2.x To v1.3


# ************** Warning **************
# If you use linea version < 1.2 apply first, patch_1.2.mysql.xx.sql !!!
#

# For Windows default config only
SET SESSION sql_mode='';

ALTER TABLE `project` ADD `project_theme_id` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `project_scale_id` ;
ALTER TABLE `project` ADD `project_workshop_id` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `project_end_date`;


CREATE TABLE `j_project_sdi` (
  `jps_project_id` int(11) NOT NULL default '0',
  `jps_sdi_id` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
