Guest User

Untitled

a guest
May 22nd, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.68 KB | None | 0 0
  1. diff --git a/data/upgrade/2/sql/message.sql b/data/upgrade/2/sql/message.sql
  2. index 3c38919..3328aa3 100644
  3. --- a/data/upgrade/2/sql/message.sql
  4. +++ b/data/upgrade/2/sql/message.sql
  5. @@ -1,8 +1,11 @@
  6. -INSERT INTO message (id, member_id, subject, body, is_deleted, is_send, thread_message_id, return_message_id, message_type_id, foreign_id, created_at, updated_at) (SELECT c_message_id, c_member_id_from, subject, body, is_kanzen_sakujo_from, is_send, NULL, hensinmoto_c_message_id, 1, NULL, r_datetime, r_datetime FROM c_message);
  7. -INSERT INTO message_send_list (id, member_id, message_id, is_read, is_deleted, created_at, updated_at) (SELECT c_message_id, c_member_id_to, c_message_id, is_read, is_kanzen_sakujo_to, r_datetime, r_datetime FROM c_message);
  8. +INSERT INTO message (id, member_id, subject, body, is_deleted, is_send, thread_message_id, return_message_id, message_type_id, foreign_id, created_at, updated_at) (SELECT c_message_id, c_member_id_from, subject, body, is_deleted_from, is_send, NULL, hensinmoto_c_message_id, 1, NULL, r_datetime, r_datetime FROM c_message);
  9. +UPDATE message SET is_deleted = 1 WHERE id IN (SELECT c_message_id FROM c_message WHERE is_kanzen_sakujo_from = 1);
  10.  
  11. -INSERT INTO deleted_message (id, member_id, message_id, message_send_list_id, is_deleted, created_at, updated_at) (SELECT NULL, c_member_id_from, c_message_id, NULL, 1, NOW(), NOW() FROM c_message WHERE is_deleted_from = 1);
  12. -INSERT INTO deleted_message (id, member_id, message_id, message_send_list_id, is_deleted, created_at, updated_at) (SELECT NULL, c_member_id_to, NULL, c_message_id, 1, NOW(), NOW() FROM c_message WHERE is_deleted_to = 1);
  13. +INSERT INTO message_send_list (id, member_id, message_id, is_read, is_deleted, created_at, updated_at) (SELECT c_message_id, c_member_id_to, c_message_id, is_read, is_deleted_to, r_datetime, r_datetime FROM c_message);
  14. +UPDATE message_send_list SET is_deleted = 1 WHERE id IN (SELECT c_message_id FROM c_message WHERE is_kanzen_sakujo_to = 1);
  15. +
  16. +INSERT INTO deleted_message (id, member_id, message_id, message_send_list_id, is_deleted, created_at, updated_at) (SELECT NULL, c_member_id_from, c_message_id, NULL, is_kanzen_sakujo_from, NOW(), NOW() FROM c_message WHERE is_deleted_from = 1 OR is_kanzen_sakujo_from = 1);
  17. +INSERT INTO deleted_message (id, member_id, message_id, message_send_list_id, is_deleted, created_at, updated_at) (SELECT NULL, c_member_id_to, NULL, c_message_id, is_kanzen_sakujo_to, NOW(), NOW() FROM c_message WHERE is_deleted_to = 1 OR is_kanzen_sakujo_to = 1);
  18.  
  19. <?php foreach (array('image_filename_1', 'image_filename_2', 'image_filename_3') as $v): ?>
  20. ALTER TABLE c_message CHANGE <?php echo $v ?> <?php echo $v ?> text CHARACTER SET utf8 COLLATE utf8_unicode_ci;
Add Comment
Please, Sign In to add comment