Changeset 81f2a2d in iPeer


Ignore:
Timestamp:
2012-12-27T16:07:34-08:00 (5 years ago)
Author:
Compass <pan.luo@…>
Branches:
3.1.x, dev, hotfix, master, pagodabox, ticket463
Children:
3c06fda
Parents:
0013e91
Message:

Update delta file for missing db updates

File:
1 edited

Legend:

Unmodified
Added
Removed
  • app/config/sql/delta_5.sql

    r0013e91 r81f2a2d  
    200200ALTER TABLE  `event_template_types` CHANGE  `created`  `created` DATETIME NULL DEFAULT NULL, CHANGE  `modified`  `modified` DATETIME NULL DEFAULT NULL ;
    201201ALTER TABLE `event_template_types` CHARACTER SET = utf8 ;
     202UPDATE `event_template_types` SET  `display_for_selection` =  '1' WHERE  `event_template_types`.`id` =3;
    202203
    203204ALTER TABLE  `events` CHANGE  `created`  `created` DATETIME NULL DEFAULT NULL, CHANGE  `modified`  `modified` DATETIME NULL DEFAULT NULL ;
     
    371372
    372373ALTER TABLE `survey_inputs` CHARACTER SET = utf8 , ADD COLUMN `chkbx_id` INT(11) NULL DEFAULT NULL  AFTER `sub_id` ;
     374ALTER TABLE `survey_inputs` CHANGE  `survey_id`  `event_id` INT( 11 ) NOT NULL DEFAULT  '0';
    373375
    374376ALTER TABLE `survey_questions` CHARACTER SET = utf8 , CHANGE COLUMN `number` `number` INT(11) NOT NULL DEFAULT '9999'  ;
    375377
    376 ALTER TABLE  `surveys` CHANGE  `created`  `created` DATETIME NULL DEFAULT NULL, CHANGE  `modified`  `modified` DATETIME NULL DEFAULT NULL ;
     378ALTER TABLE `surveys` CHANGE  `created`  `created` DATETIME NULL DEFAULT NULL, CHANGE  `modified`  `modified` DATETIME NULL DEFAULT NULL ;
    377379ALTER TABLE `surveys` CHARACTER SET = utf8 , CHANGE COLUMN `name` `name` VARCHAR(255) NOT NULL  ;
     380ALTER TABLE `surveys` ADD  `availability` VARCHAR( 10 ) NOT NULL DEFAULT  'public' AFTER  `name`;
    378381
    379382ALTER TABLE  `sys_parameters` CHARACTER SET = utf8,  CHANGE  `created`  `created` DATETIME NULL DEFAULT NULL, CHANGE  `modified`  `modified` DATETIME NULL DEFAULT NULL ;
Note: See TracChangeset for help on using the changeset viewer.