Changeset 46 for trunk/SQL


Ignore:
Timestamp:
Jul 27, 2014, 9:05:14 PM (10 years ago)
Author:
chronos
Message:
  • Opraveno: SQL aktualizace 40 plus chybějící tabulka MeasureMethod.
  • Opraveno: Neplatné ukázkové konfigurační soubory.
Location:
trunk/SQL/Updates
Files:
1 added
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/SQL/Updates/40.sql

    r40 r46  
    1 RENAME TABLE `Measure2` TO `Measure`
     1RENAME TABLE `measure` TO `Measure`
    22ALTER TABLE `Measure`  ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    33
     
    8989ALTER TABLE `MeasureGroup` CHANGE `Parent` `Parent` INT( 11 ) NULL ;
    9090
    91 ALTER TABLE `Measure` ADD `Group` INT NOT NULL AFTER `Id` ;
     91ALTER TABLE `Measure` ADD `Group` INT NULL AFTER `Id` ;
    9292ALTER TABLE `Measure` ADD INDEX ( `Group` ) ;
    9393ALTER TABLE `Measure` ADD FOREIGN KEY ( `Group` ) REFERENCES `MeasureGroup` ( `Id` );
    9494ALTER TABLE `Measure` DROP `OldName` ;
    95 ALTER TABLE `Measure`   DROP `PermissionView`,   DROP `PermissionAdd`;
     95ALTER TABLE `Measure` DROP `PermissionView`,   DROP `PermissionAdd`;
    9696
    9797ALTER TABLE `Measure` CHANGE `Name` `Name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
Note: See TracChangeset for help on using the changeset viewer.