Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- RENAME TABLE `josPrefix2_users` TO `josPrefix2_bak_users`;
- RENAME TABLE `josPrefix2_session` TO `josPrefix2_bak_session`;
- RENAME TABLE `josPrefix2_usergroups` TO `josPrefix2_bak_usergroups`;
- RENAME TABLE `josPrefix2_user_notes` TO `josPrefix2_bak_user_notes`;
- RENAME TABLE `josPrefix2_user_profiles` TO `josPrefix2_bak_user_profiles`;
- RENAME TABLE `josPrefix2_user_usergroup_map` TO `josPrefix2_bak_user_usergroup_map`;
- RENAME TABLE `josPrefix2_viewlevels` TO `josPrefix2_bak_viewlevels`;
- CREATE VIEW josPrefix2_users AS SELECT * FROM dbSite1.josPrefix1_users;
- CREATE VIEW josPrefix2_session AS SELECT * FROM dbSite1.josPrefix1_session;
- CREATE VIEW josPrefix2_usergroups AS SELECT * FROM dbSite1.josPrefix1_usergroups;
- CREATE VIEW josPrefix2_user_notes AS SELECT * FROM dbSite1.josPrefix1_user_notes;
- CREATE VIEW josPrefix2_user_profiles AS SELECT * FROM dbSite1.josPrefix1_user_profiles;
- CREATE VIEW josPrefix2_user_usergroup_map AS SELECT * FROM dbSite1.josPrefix1_user_usergroup_map;
- CREATE VIEW josPrefix2_viewlevels AS SELECT * FROM dbSite1.josPrefix1_viewlevels;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement