File indexing completed on 2024-04-21 06:00:36
0001 #Create Table member_password_types 0002 CREATE TABLE `member_password_types` 0003 ( 0004 `password_type_id` INT(10) UNSIGNED NOT NULL, 0005 `name` VARCHAR(50) NOT NULL, 0006 `description` VARCHAR(255) NOT NULL, 0007 PRIMARY KEY (`password_type_id`) 0008 ) 0009 ENGINE = InnoDB; 0010 0011 INSERT INTO `member_password_types` (`password_type_id`, `name`, `description`) 0012 VALUES (0, 'MD5', 'Default OCS Password Hash'); 0013 INSERT INTO `member_password_types` (`password_type_id`, `name`, `description`) 0014 VALUES (1, 'SHA', 'Hive Password Hash'); 0015 0016 #Add field in table member 0017 ALTER TABLE `member` 0018 ADD COLUMN `password_type` INT(1) NOT NULL DEFAULT '0' 0019 COMMENT 'Type: 0 = MD5 (OCS), 1 = SHA (Hive)' 0020 AFTER `password`; 0021 0022 #Update Hive-Members 0023 UPDATE `member` `m` 0024 SET `m`.`password_type` = 1 0025 WHERE `m`.`source_id` = 1; 0026 0027