Advertisement
Guest User

Untitled

a guest
Aug 24th, 2016
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.06 KB | None | 0 0
  1. RENAME TABLE `josPrefix2_users` TO `josPrefix2_bak_users`;
  2.  
  3. RENAME TABLE `josPrefix2_session` TO `josPrefix2_bak_session`;
  4.  
  5. RENAME TABLE `josPrefix2_usergroups` TO `josPrefix2_bak_usergroups`;
  6.  
  7. RENAME TABLE `josPrefix2_user_notes` TO `josPrefix2_bak_user_notes`;
  8.  
  9. RENAME TABLE `josPrefix2_user_profiles` TO `josPrefix2_bak_user_profiles`;
  10.  
  11. RENAME TABLE `josPrefix2_user_usergroup_map` TO `josPrefix2_bak_user_usergroup_map`;
  12.  
  13. RENAME TABLE `josPrefix2_viewlevels` TO `josPrefix2_bak_viewlevels`;
  14.  
  15. CREATE VIEW josPrefix2_users AS SELECT * FROM dbSite1.josPrefix1_users;
  16.  
  17. CREATE VIEW josPrefix2_session AS SELECT * FROM dbSite1.josPrefix1_session;
  18.  
  19. CREATE VIEW josPrefix2_usergroups AS SELECT * FROM dbSite1.josPrefix1_usergroups;
  20.  
  21. CREATE VIEW josPrefix2_user_notes AS SELECT * FROM dbSite1.josPrefix1_user_notes;
  22.  
  23. CREATE VIEW josPrefix2_user_profiles AS SELECT * FROM dbSite1.josPrefix1_user_profiles;
  24.  
  25. CREATE VIEW josPrefix2_user_usergroup_map AS SELECT * FROM dbSite1.josPrefix1_user_usergroup_map;
  26.  
  27. CREATE VIEW josPrefix2_viewlevels AS SELECT * FROM dbSite1.josPrefix1_viewlevels;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement