Ignore:
Timestamp:
Oct 13, 2012, 1:02:07 PM (12 years ago)
Author:
chronos
Message:
  • Upraveno: Obsluha chyb obnovena a převedena na modul.
File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/sql/updates/436.sql

    r436 r437  
    66ALTER TABLE `News` ADD FOREIGN KEY ( `User` ) REFERENCES `User` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
    77
     8ALTER TABLE `User` ADD `Salt` VARCHAR( 255 ) NOT NULL AFTER `Password` ;
     9UPDATE `User` SET `Salt` = SHA1(RAND());
     10UPDATE `User` SET `Password`=SHA1(CONCAT(`Password`, `Salt`));
    811
    9 ALTER TABLE `User`
    10 ADD `TimeCreate` DATETIME NULL ,
    11 ADD `UserCreate` INT NULL ,
    12 ADD `TimeModify` DATETIME NULL ,
    13 ADD `UserModify` INT NULL ,
    14 ADD `TimeDelete` DATETIME NULL ,
    15 ADD `UserDelete` INT NULL;
    16 UPDATE `User` SET TimeCreate=NOW(), UserCreate=1;
    17 ALTER TABLE `User` ADD INDEX ( `UserCreate` ) ;
    18 ALTER TABLE `User` ADD INDEX ( `UserModify` ) ;
    19 ALTER TABLE `User` ADD INDEX ( `UserDelete` ) ;
    20 ALTER TABLE `User` ADD FOREIGN KEY ( `UserCreate` ) REFERENCES `User` (`Id`) ON DELETE SET NULL ON UPDATE SET NULL ;
    21 ALTER TABLE `User` ADD FOREIGN KEY ( `UserModify` ) REFERENCES `User` (`Id`) ON DELETE SET NULL ON UPDATE SET NULL ;
    22 ALTER TABLE `User` ADD FOREIGN KEY ( `UserDelete` ) REFERENCES `User` (`Id`) ON DELETE SET NULL ON UPDATE SET NULL ;
    23 
    24 ALTER TABLE `Subject`
    25 ADD `TimeCreate` DATETIME NULL ,
    26 ADD `UserCreate` INT NULL ,
    27 ADD `TimeModify` DATETIME NULL ,
    28 ADD `UserModify` INT NULL ,
    29 ADD `TimeDelete` DATETIME NULL ,
    30 ADD `UserDelete` INT NULL;
    31 UPDATE `Subject` SET TimeCreate=NOW(), UserCreate=1;
    32 ALTER TABLE `Subject` ADD INDEX ( `UserCreate` ) ;
    33 ALTER TABLE `Subject` ADD INDEX ( `UserModify` ) ;
    34 ALTER TABLE `Subject` ADD INDEX ( `UserDelete` ) ;
    35 ALTER TABLE `Subject` ADD FOREIGN KEY ( `UserCreate` ) REFERENCES `User` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
    36 ALTER TABLE `Subject` ADD FOREIGN KEY ( `UserModify` ) REFERENCES `User` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
    37 ALTER TABLE `Subject` ADD FOREIGN KEY ( `UserDelete` ) REFERENCES `User` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
    38 
    39 ALTER TABLE `Member`
    40 ADD `TimeCreate` DATETIME NULL ,
    41 ADD `UserCreate` INT NULL ,
    42 ADD `TimeModify` DATETIME NULL ,
    43 ADD `UserModify` INT NULL ,
    44 ADD `TimeDelete` DATETIME NULL ,
    45 ADD `UserDelete` INT NULL;
    46 UPDATE `Member` SET TimeCreate=NOW(), UserCreate=1;
    47 ALTER TABLE `Member` ADD INDEX ( `UserCreate` ) ;
    48 ALTER TABLE `Member` ADD INDEX ( `UserModify` ) ;
    49 ALTER TABLE `Member` ADD INDEX ( `UserDelete` ) ;
    50 ALTER TABLE `Member` ADD FOREIGN KEY ( `UserCreate` ) REFERENCES `User` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
    51 ALTER TABLE `Member` ADD FOREIGN KEY ( `UserModify` ) REFERENCES `User` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
    52 ALTER TABLE `Member` ADD FOREIGN KEY ( `UserDelete` ) REFERENCES `User` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
    53 
    54 ALTER TABLE `Country`
    55 ADD `TimeCreate` DATETIME NULL ,
    56 ADD `UserCreate` INT NULL ,
    57 ADD `TimeModify` DATETIME NULL ,
    58 ADD `UserModify` INT NULL ,
    59 ADD `TimeDelete` DATETIME NULL ,
    60 ADD `UserDelete` INT NULL;
    61 UPDATE `Country` SET TimeCreate=NOW(), UserCreate=1;
    62 ALTER TABLE `Country` ADD INDEX ( `UserCreate` ) ;
    63 ALTER TABLE `Country` ADD INDEX ( `UserModify` ) ;
    64 ALTER TABLE `Country` ADD INDEX ( `UserDelete` ) ;
    65 ALTER TABLE `Country` ADD FOREIGN KEY ( `UserCreate` ) REFERENCES `User` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
    66 ALTER TABLE `Country` ADD FOREIGN KEY ( `UserModify` ) REFERENCES `User` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
    67 ALTER TABLE `Country` ADD FOREIGN KEY ( `UserDelete` ) REFERENCES `User` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
    68 
     12ALTER TABLE `Log` CHANGE `Value` `Value` TEXT CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL DEFAULT '';
Note: See TracChangeset for help on using the changeset viewer.