taskAndDiv: 2016车友会分表.sql

File 2016车友会分表.sql, 6.5 KB (added by fangxirui, 10 years ago)
Line 
1create table `ac_dyna_info_2016` like `ac_dyna_info_2015`;
2
3create table `ac_bbs_action_log_201601` like `ac_bbs_action_log_201512`;
4create table `ac_bbs_action_log_201602` like `ac_bbs_action_log_201512`;
5create table `ac_bbs_action_log_201603` like `ac_bbs_action_log_201512`;
6create table `ac_bbs_action_log_201604` like `ac_bbs_action_log_201512`;
7create table `ac_bbs_action_log_201605` like `ac_bbs_action_log_201512`;
8create table `ac_bbs_action_log_201606` like `ac_bbs_action_log_201512`;
9create table `ac_bbs_action_log_201607` like `ac_bbs_action_log_201512`;
10create table `ac_bbs_action_log_201608` like `ac_bbs_action_log_201512`;
11create table `ac_bbs_action_log_201609` like `ac_bbs_action_log_201512`;
12create table `ac_bbs_action_log_201610` like `ac_bbs_action_log_201512`;
13create table `ac_bbs_action_log_201611` like `ac_bbs_action_log_201512`;
14create table `ac_bbs_action_log_201612` like `ac_bbs_action_log_201512`;
15
16create table `ac_club_petrol_log_201601` like `ac_club_petrol_log_201512`;
17create table `ac_club_petrol_log_201602` like `ac_club_petrol_log_201512`;
18create table `ac_club_petrol_log_201603` like `ac_club_petrol_log_201512`;
19create table `ac_club_petrol_log_201604` like `ac_club_petrol_log_201512`;
20create table `ac_club_petrol_log_201605` like `ac_club_petrol_log_201512`;
21create table `ac_club_petrol_log_201606` like `ac_club_petrol_log_201512`;
22create table `ac_club_petrol_log_201607` like `ac_club_petrol_log_201512`;
23create table `ac_club_petrol_log_201608` like `ac_club_petrol_log_201512`;
24create table `ac_club_petrol_log_201609` like `ac_club_petrol_log_201512`;
25create table `ac_club_petrol_log_201610` like `ac_club_petrol_log_201512`;
26create table `ac_club_petrol_log_201611` like `ac_club_petrol_log_201512`;
27create table `ac_club_petrol_log_201612` like `ac_club_petrol_log_201512`;
28
29create table `ac_member_checkin_record_201601` like `ac_member_checkin_record_201512`;
30create table `ac_member_checkin_record_201602` like `ac_member_checkin_record_201512`;
31create table `ac_member_checkin_record_201603` like `ac_member_checkin_record_201512`;
32create table `ac_member_checkin_record_201604` like `ac_member_checkin_record_201512`;
33create table `ac_member_checkin_record_201605` like `ac_member_checkin_record_201512`;
34create table `ac_member_checkin_record_201606` like `ac_member_checkin_record_201512`;
35create table `ac_member_checkin_record_201607` like `ac_member_checkin_record_201512`;
36create table `ac_member_checkin_record_201608` like `ac_member_checkin_record_201512`;
37create table `ac_member_checkin_record_201609` like `ac_member_checkin_record_201512`;
38create table `ac_member_checkin_record_201610` like `ac_member_checkin_record_201512`;
39create table `ac_member_checkin_record_201611` like `ac_member_checkin_record_201512`;
40create table `ac_member_checkin_record_201612` like `ac_member_checkin_record_201512`;
41
42create table `ac_member_petrol_detail_201601` like `ac_member_petrol_detail_201512`;
43create table `ac_member_petrol_detail_201602` like `ac_member_petrol_detail_201512`;
44create table `ac_member_petrol_detail_201603` like `ac_member_petrol_detail_201512`;
45create table `ac_member_petrol_detail_201604` like `ac_member_petrol_detail_201512`;
46create table `ac_member_petrol_detail_201605` like `ac_member_petrol_detail_201512`;
47create table `ac_member_petrol_detail_201606` like `ac_member_petrol_detail_201512`;
48create table `ac_member_petrol_detail_201607` like `ac_member_petrol_detail_201512`;
49create table `ac_member_petrol_detail_201608` like `ac_member_petrol_detail_201512`;
50create table `ac_member_petrol_detail_201609` like `ac_member_petrol_detail_201512`;
51create table `ac_member_petrol_detail_201610` like `ac_member_petrol_detail_201512`;
52create table `ac_member_petrol_detail_201611` like `ac_member_petrol_detail_201512`;
53create table `ac_member_petrol_detail_201612` like `ac_member_petrol_detail_201512`;
54
55create table `ac_member_petrol_log_201601` like `ac_member_petrol_log_201512`;
56create table `ac_member_petrol_log_201602` like `ac_member_petrol_log_201512`;
57create table `ac_member_petrol_log_201603` like `ac_member_petrol_log_201512`;
58create table `ac_member_petrol_log_201604` like `ac_member_petrol_log_201512`;
59create table `ac_member_petrol_log_201605` like `ac_member_petrol_log_201512`;
60create table `ac_member_petrol_log_201606` like `ac_member_petrol_log_201512`;
61create table `ac_member_petrol_log_201607` like `ac_member_petrol_log_201512`;
62create table `ac_member_petrol_log_201608` like `ac_member_petrol_log_201512`;
63create table `ac_member_petrol_log_201609` like `ac_member_petrol_log_201512`;
64create table `ac_member_petrol_log_201610` like `ac_member_petrol_log_201512`;
65create table `ac_member_petrol_log_201611` like `ac_member_petrol_log_201512`;
66create table `ac_member_petrol_log_201612` like `ac_member_petrol_log_201512`;
67
68create table `ac_mq_message_log_201601` like `ac_mq_message_log_201512`;
69create table `ac_mq_message_log_201602` like `ac_mq_message_log_201512`;
70create table `ac_mq_message_log_201603` like `ac_mq_message_log_201512`;
71create table `ac_mq_message_log_201604` like `ac_mq_message_log_201512`;
72create table `ac_mq_message_log_201605` like `ac_mq_message_log_201512`;
73create table `ac_mq_message_log_201606` like `ac_mq_message_log_201512`;
74create table `ac_mq_message_log_201607` like `ac_mq_message_log_201512`;
75create table `ac_mq_message_log_201608` like `ac_mq_message_log_201512`;
76create table `ac_mq_message_log_201609` like `ac_mq_message_log_201512`;
77create table `ac_mq_message_log_201610` like `ac_mq_message_log_201512`;
78create table `ac_mq_message_log_201611` like `ac_mq_message_log_201512`;
79create table `ac_mq_message_log_201612` like `ac_mq_message_log_201512`;
80
81create table `ac_operate_log_201601` like `ac_operate_log_201512`;
82create table `ac_operate_log_201602` like `ac_operate_log_201512`;
83create table `ac_operate_log_201603` like `ac_operate_log_201512`;
84create table `ac_operate_log_201604` like `ac_operate_log_201512`;
85create table `ac_operate_log_201605` like `ac_operate_log_201512`;
86create table `ac_operate_log_201606` like `ac_operate_log_201512`;
87create table `ac_operate_log_201607` like `ac_operate_log_201512`;
88create table `ac_operate_log_201608` like `ac_operate_log_201512`;
89create table `ac_operate_log_201609` like `ac_operate_log_201512`;
90create table `ac_operate_log_201610` like `ac_operate_log_201512`;
91create table `ac_operate_log_201611` like `ac_operate_log_201512`;
92create table `ac_operate_log_201612` like `ac_operate_log_201512`;