Changeset 46 for trunk/SQL

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:

• 40.sql (modified) (2 diffs)
• 46.sql (added)

trunk/SQL/Updates/40.sql

@@ -1 @@
-RENAME TABLE `Measure2` TO `Measure` 
+RENAME TABLE `measure` TO `Measure` 
 ALTER TABLE `Measure`  ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
 
@@ -89 +89 @@
 ALTER TABLE `MeasureGroup` CHANGE `Parent` `Parent` INT( 11 ) NULL ;
 
-ALTER TABLE `Measure` ADD `Group` INT NOT NULL AFTER `Id` ;
+ALTER TABLE `Measure` ADD `Group` INT NULL AFTER `Id` ;
 ALTER TABLE `Measure` ADD INDEX ( `Group` ) ;
 ALTER TABLE `Measure` ADD FOREIGN KEY ( `Group` ) REFERENCES `MeasureGroup` ( `Id` );
 ALTER TABLE `Measure` DROP `OldName` ;
-ALTER TABLE `Measure`   DROP `PermissionView`,   DROP `PermissionAdd`;
+ALTER TABLE `Measure` DROP `PermissionView`,   DROP `PermissionAdd`;
 
 ALTER TABLE `Measure` CHANGE `Name` `Name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,