ABCDEFGHIJKLMNOPQRSTUV
1
Use the following queries to rename existing phpwcms table names for being able to host an updated installation inside the same database.
2
Copy and paste the result of the query into column A starting at line 5. Proof twice!!! >>>SHOW TABLES;
3
4
Table NameSuche nachErsetzen mit(New) PrefixSQL (copy all lines by selecting E5…En and run the query on your old DB)
5
phpwcms_addressv201812_v2024RENAME TABLE `phpwcms_address` TO `v2024_phpwcms_address`;
6
phpwcms_ads_campaignv201812_v2024RENAME TABLE `phpwcms_ads_campaign` TO `v2024_phpwcms_ads_campaign`;
7
phpwcms_ads_formatsv201812_v2024RENAME TABLE `phpwcms_ads_formats` TO `v2024_phpwcms_ads_formats`;
8
phpwcms_ads_placev201812_v2024RENAME TABLE `phpwcms_ads_place` TO `v2024_phpwcms_ads_place`;
9
phpwcms_ads_trackingv201812_v2024RENAME TABLE `phpwcms_ads_tracking` TO `v2024_phpwcms_ads_tracking`;
10
phpwcms_articlev201812_v2024RENAME TABLE `phpwcms_article` TO `v2024_phpwcms_article`;
11
phpwcms_articlecatv201812_v2024RENAME TABLE `phpwcms_articlecat` TO `v2024_phpwcms_articlecat`;
12
phpwcms_articlecontentv201812_v2024RENAME TABLE `phpwcms_articlecontent` TO `v2024_phpwcms_articlecontent`;
13
phpwcms_cachev201812_v2024RENAME TABLE `phpwcms_cache` TO `v2024_phpwcms_cache`;
14
phpwcms_calendarv201812_v2024RENAME TABLE `phpwcms_calendar` TO `v2024_phpwcms_calendar`;
15
phpwcms_categoriesv201812_v2024RENAME TABLE `phpwcms_categories` TO `v2024_phpwcms_categories`;
16
phpwcms_chatv201812_v2024RENAME TABLE `phpwcms_chat` TO `v2024_phpwcms_chat`;
17
phpwcms_contentv201812_v2024RENAME TABLE `phpwcms_content` TO `v2024_phpwcms_content`;
18
phpwcms_countryv201812_v2024RENAME TABLE `phpwcms_country` TO `v2024_phpwcms_country`;
19
phpwcms_crossreferencev201812_v2024RENAME TABLE `phpwcms_crossreference` TO `v2024_phpwcms_crossreference`;
20
phpwcms_filev201812_v2024RENAME TABLE `phpwcms_file` TO `v2024_phpwcms_file`;
21
phpwcms_filecatv201812_v2024RENAME TABLE `phpwcms_filecat` TO `v2024_phpwcms_filecat`;
22
phpwcms_filekeyv201812_v2024RENAME TABLE `phpwcms_filekey` TO `v2024_phpwcms_filekey`;
23
phpwcms_formresultv201812_v2024RENAME TABLE `phpwcms_formresult` TO `v2024_phpwcms_formresult`;
24
phpwcms_formtrackingv201812_v2024RENAME TABLE `phpwcms_formtracking` TO `v2024_phpwcms_formtracking`;
25
phpwcms_glossaryv201812_v2024RENAME TABLE `phpwcms_glossary` TO `v2024_phpwcms_glossary`;
26
phpwcms_guestbookv201812_v2024RENAME TABLE `phpwcms_guestbook` TO `v2024_phpwcms_guestbook`;
27
phpwcms_keywordv201812_v2024RENAME TABLE `phpwcms_keyword` TO `v2024_phpwcms_keyword`;
28
phpwcms_languagev201812_v2024RENAME TABLE `phpwcms_language` TO `v2024_phpwcms_language`;
29
phpwcms_logv201812_v2024RENAME TABLE `phpwcms_log` TO `v2024_phpwcms_log`;
30
phpwcms_log_seov201812_v2024RENAME TABLE `phpwcms_log_seo` TO `v2024_phpwcms_log_seo`;
31
phpwcms_mapv201812_v2024RENAME TABLE `phpwcms_map` TO `v2024_phpwcms_map`;
32
phpwcms_messagev201812_v2024RENAME TABLE `phpwcms_message` TO `v2024_phpwcms_message`;
33
phpwcms_newsletterv201812_v2024RENAME TABLE `phpwcms_newsletter` TO `v2024_phpwcms_newsletter`;
34
phpwcms_newsletterqueuev201812_v2024RENAME TABLE `phpwcms_newsletterqueue` TO `v2024_phpwcms_newsletterqueue`;
35
phpwcms_pagelayoutv201812_v2024RENAME TABLE `phpwcms_pagelayout` TO `v2024_phpwcms_pagelayout`;
36
phpwcms_professionv201812_v2024RENAME TABLE `phpwcms_profession` TO `v2024_phpwcms_profession`;
37
phpwcms_redirectv201812_v2024RENAME TABLE `phpwcms_redirect` TO `v2024_phpwcms_redirect`;
38
phpwcms_shop_ordersv201812_v2024RENAME TABLE `phpwcms_shop_orders` TO `v2024_phpwcms_shop_orders`;
39
phpwcms_shop_productsv201812_v2024RENAME TABLE `phpwcms_shop_products` TO `v2024_phpwcms_shop_products`;
40
phpwcms_subscriptionv201812_v2024RENAME TABLE `phpwcms_subscription` TO `v2024_phpwcms_subscription`;
41
phpwcms_sysvaluev201812_v2024RENAME TABLE `phpwcms_sysvalue` TO `v2024_phpwcms_sysvalue`;
42
phpwcms_templatev201812_v2024RENAME TABLE `phpwcms_template` TO `v2024_phpwcms_template`;
43
phpwcms_userv201812_v2024RENAME TABLE `phpwcms_user` TO `v2024_phpwcms_user`;
44
phpwcms_userdetailv201812_v2024RENAME TABLE `phpwcms_userdetail` TO `v2024_phpwcms_userdetail`;
45
phpwcms_usergroupv201812_v2024RENAME TABLE `phpwcms_usergroup` TO `v2024_phpwcms_usergroup`;
46
phpwcms_userlogv201812_v2024RENAME TABLE `phpwcms_userlog` TO `v2024_phpwcms_userlog`;
47
v201812_v2024RENAME TABLE `` TO `v2024_`;
48
v201812_v2024RENAME TABLE `` TO `v2024_`;
49
v201812_v2024RENAME TABLE `` TO `v2024_`;
50
v201812_v2024RENAME TABLE `` TO `v2024_`;
51
v201812_v2024RENAME TABLE `` TO `v2024_`;
52
v201812_v2024RENAME TABLE `` TO `v2024_`;
53
v201812_v2024RENAME TABLE `` TO `v2024_`;
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94