Changeset 495 for trunk/sql

Timestamp:

Jan 27, 2013, 7:42:05 PM (11 years ago)

Author:

chronos

Message:

• Opraveno: Zamezit registraci více stejných jmen s různě velkými písmeny.
• Opraveno: Kódování znaků v tabulce User znemožňovalo přihlašování kvůli kódování.

Location:

trunk/sql/updates

Files:

• 483.sql (modified) (1 diff)
• 487.sql (modified) (1 diff)
• 488.sql (modified) (1 diff)
• 495.sql (added)

trunk/sql/updates/483.sql

@@ +1 @@
+ALTER TABLE  `DbVersion` CHANGE  `Require_476`  `Require_483` INT( 255 ) NULL DEFAULT NULL;
+UPDATE  `DbVersion` SET  `Version` =  'Rev. 483' WHERE  `DbVersion`.`Id` =1;
+
 ALTER TABLE `Referrer` ADD `Hits` INT NOT NULL ;
 ALTER TABLE `Referrer` ADD `Parent` INT NOT NULL ;

trunk/sql/updates/487.sql

@@ +1 @@
+ALTER TABLE  `DbVersion` CHANGE  `Require_483`  `Require_487` INT( 255 ) NULL DEFAULT NULL;
+UPDATE  `DbVersion` SET  `Version` =  'Rev. 487' WHERE  `DbVersion`.`Id` =1;
+
 ALTER TABLE `Referrer` ADD INDEX ( `DateLast` );
 ALTER TABLE `Referrer` ADD INDEX ( `Parent` );

trunk/sql/updates/488.sql

@@ +1 @@
+ALTER TABLE  `DbVersion` CHANGE  `Require_487`  `Require_488` INT( 255 ) NULL DEFAULT NULL;
+UPDATE  `DbVersion` SET  `Version` =  'Rev. 488' WHERE  `DbVersion`.`Id` =1;
 
 INSERT INTO `GroupItemDBC` (`Id`, `ClientVersion`, `GroupItem`, `ColumnIndex`) VALUES