Changeset c4ce769 in iPeer


Ignore:
Timestamp:
2012-12-06T13:19:21-08:00 (6 years ago)
Author:
Compass <pan.luo@…>
Branches:
3.1.x, dev, hotfix, master, pagodabox, ticket463
Children:
c7f6777
Parents:
7544ec1
Message:

fixed a typo of role id

File:
1 edited

Legend:

Unmodified
Added
Removed
  • app/config/sql/delta_5.sql

    r7544ec1 rc4ce769  
    449449INSERT INTO roles_users (role_id, user_id, created, modified) (SELECT 2, id, NOW(), NOW() FROM  `users` WHERE  `role` =  'A' AND id != 1);
    450450INSERT INTO roles_users (role_id, user_id, created, modified) (SELECT 3, id, NOW(), NOW() FROM  `users` WHERE  `role` =  'I');
    451 INSERT INTO roles_users (role_id, user_id, created, modified) (SELECT 4, id, NOW(), NOW() FROM  `users` WHERE  `role` =  'S');
     451INSERT INTO roles_users (role_id, user_id, created, modified) (SELECT 5, id, NOW(), NOW() FROM  `users` WHERE  `role` =  'S');
    452452UPDATE `users` SET `created`=NOW() WHERE `created` = '0000-00-00 00:00:00';
    453453ALTER TABLE `users` CHARACTER SET = utf8
Note: See TracChangeset for help on using the changeset viewer.