· 7 years ago · Nov 29, 2018, 08:06 PM
1<?php
2
3 $tables = array('clients' => 0, 'new_daily_users' => 0, 'random_group' => 0, 'statistics' => 0, 'visitors' => 0, 'vip_channels' => 0, 'yt_channels' => 0, 'actions' => 0);
4
5 function create_table($table_name)
6 {
7 switch($table_name)
8 {
9 case 'clients':
10 $res = "CREATE TABLE IF NOT EXISTS `clients` (
11 `client_dbid` int(255) NOT NULL,
12 `client_clid` int(11) NOT NULL,
13 `client_nick` text COLLATE utf8mb4_general_ci NOT NULL,
14 `last_nicks` longtext COLLATE utf8mb4_general_ci NOT NULL,
15 `client_uid` text CHARACTER SET latin1 NOT NULL,
16 `server_groups` longtext COLLATE utf8mb4_general_ci NOT NULL,
17 `connections` int(11) NOT NULL,
18 `connected_time` int(11) NOT NULL,
19 `connected_time_record` bigint(255) NOT NULL,
20 `idle_time_record` bigint(255) NOT NULL,
21 `time_spent` bigint(255) NOT NULL,
22 `idle_time_spent` bigint(255) NOT NULL,
23 `week_start` int(11) NOT NULL,
24 `week_start_time` int(255) NOT NULL
25) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; || ALTER TABLE `clients`
26 ADD PRIMARY KEY (`client_dbid`);";
27 break;
28
29 case 'new_daily_users':
30 $res = "CREATE TABLE IF NOT EXISTS `new_daily_users` (
31 `client_dbid` int(255) NOT NULL,
32 `client_clid` int(11) NOT NULL,
33 `client_nick` text COLLATE utf8mb4_general_ci NOT NULL,
34 `client_uid` text CHARACTER SET latin1 NOT NULL,
35 `day` text CHARACTER SET latin1 NOT NULL
36) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; || ALTER TABLE `new_daily_users`
37 ADD PRIMARY KEY (`client_dbid`);";
38 break;
39
40 case 'random_group':
41 $res = "CREATE TABLE IF NOT EXISTS `random_group` (
42 `client_dbid` int(11) NOT NULL,
43 `sgid` int(11) NOT NULL,
44 `date` varchar(16) COLLATE utf8mb4_general_ci NOT NULL,
45 `time` int(11) NOT NULL,
46 `deleted` int(11) NOT NULL
47) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; || ALTER TABLE `random_group`
48 ADD PRIMARY KEY (`date`);";
49 break;
50
51 case 'statistics':
52 $res = "CREATE TABLE IF NOT EXISTS `statistics` (
53 `dbid` int(10) NOT NULL,
54 `groups_day_start` text COLLATE utf8mb4_general_ci NOT NULL,
55 `groups_day_normal` int(11) NOT NULL DEFAULT '0',
56 `groups_day_reg` int(11) NOT NULL DEFAULT '0',
57 `groups_week_start` text COLLATE utf8mb4_general_ci NOT NULL,
58 `groups_week_normal` int(11) NOT NULL DEFAULT '0',
59 `groups_week_reg` int(11) NOT NULL DEFAULT '0',
60 `groups_month_start` text COLLATE utf8mb4_general_ci NOT NULL,
61 `groups_month_normal` int(11) NOT NULL DEFAULT '0',
62 `groups_month_reg` int(11) NOT NULL DEFAULT '0',
63 `groups_total_normal` int(11) NOT NULL DEFAULT '0',
64 `groups_total_reg` int(11) NOT NULL DEFAULT '0',
65 `time_day_start` text COLLATE utf8mb4_general_ci NOT NULL,
66 `time_day_time` bigint(20) NOT NULL DEFAULT '0',
67 `time_day_offline` bigint(20) NOT NULL DEFAULT '0',
68 `time_week_start` text COLLATE utf8mb4_general_ci NOT NULL,
69 `time_week_time` bigint(20) NOT NULL DEFAULT '0',
70 `time_week_offline` bigint(20) NOT NULL DEFAULT '0',
71 `time_month_start` text COLLATE utf8mb4_general_ci NOT NULL,
72 `time_month_time` bigint(20) NOT NULL DEFAULT '0',
73 `time_month_offline` bigint(11) NOT NULL DEFAULT '0',
74 `time_total_time` bigint(20) NOT NULL DEFAULT '0',
75 `time_total_offline` bigint(20) NOT NULL DEFAULT '0',
76 `help_day_start` text COLLATE utf8_polish_ci NOT NULL,
77 `help_day_time` int(11) NOT NULL DEFAULT '0',
78 `help_day_count` int(11) NOT NULL DEFAULT '0',
79 `help_week_start` text COLLATE utf8_polish_ci NOT NULL,
80 `help_week_time` int(11) NOT NULL DEFAULT '0',
81 `help_week_count` int(11) NOT NULL DEFAULT '0',
82 `help_month_start` text COLLATE utf8_polish_ci NOT NULL,
83 `help_month_time` int(11) NOT NULL DEFAULT '0',
84 `help_month_count` int(11) NOT NULL DEFAULT '0',
85 `help_total_time` int(11) NOT NULL DEFAULT '0',
86 `help_total_count` int(11) NOT NULL DEFAULT '0'
87) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; || ALTER TABLE `statistics`
88 ADD PRIMARY KEY (`dbid`);
89";
90 break;
91
92 case 'visitors':
93 $res = "CREATE TABLE IF NOT EXISTS `visitors` (
94 `client_dbid` int(255) NOT NULL,
95 `day` text COLLATE utf8mb4_general_ci NOT NULL
96) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; || ALTER TABLE `visitors`
97 ADD PRIMARY KEY (`client_dbid`);";
98 break;
99 case 'vip_channels':
100 $res = "CREATE TABLE IF NOT EXISTS `vip_channels` (
101`id` int(11) NOT NULL,
102 `type_id` text COLLATE utf8mb4_general_ci NOT NULL,
103 `channel_num` int(11) NOT NULL,
104 `channel_cid` text COLLATE utf8mb4_general_ci NOT NULL,
105 `spacer_cid` int(11) NOT NULL,
106 `online_from` int(11) NOT NULL,
107 `get_group` int(11) NOT NULL,
108 `owner_dbid` int(11) NOT NULL,
109 `group_id` int(11) NOT NULL,
110 `created` int(11) NOT NULL
111) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; || ALTER TABLE `vip_channels`
112 ADD PRIMARY KEY (`id`); || ALTER TABLE `vip_channels`
113MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;";
114 break;
115 case 'yt_channels':
116 $res = "CREATE TABLE IF NOT EXISTS `yt_channels` (
117`id` int(11) NOT NULL,
118 `channel_num` int(11) NOT NULL,
119 `channel_cid` int(11) NOT NULL,
120 `spacer_cid` int(11) NOT NULL,
121 `main_info` int(11) NOT NULL,
122 `videos_count` int(11) NOT NULL,
123 `views_count` int(11) NOT NULL,
124 `owner_dbid` int(11) NOT NULL,
125 `created` int(11) NOT NULL
126) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; || ALTER TABLE `yt_channels`
127 ADD PRIMARY KEY (`id`); || ALTER TABLE `yt_channels`
128MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;";
129 break;
130
131 case 'actions':
132 $res = "CREATE TABLE IF NOT EXISTS `actions` (
133`id` int(11) NOT NULL,
134 `date` int(11) NOT NULL,
135 `name` longtext COLLATE utf8mb4_general_ci NOT NULL,
136 `text` longtext COLLATE utf8mb4_general_ci NOT NULL,
137 `instance_id` int(11) NOT NULL
138) ENGINE=InnoDB AUTO_INCREMENT=334 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; || ALTER TABLE `actions`
139 ADD PRIMARY KEY (`id`); || ALTER TABLE `actions`
140MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;";
141 break;
142
143 default:
144 $res = "ERROR";
145 break;
146 }
147
148 return $res;
149 }
150
151
152 $new_columns = array
153 (
154 'clients' => array
155 (
156 'idle_time_spent' => 'bigint(255) NOT NULL',
157 'week_start' => 'int(11) NOT NULL',
158 'week_start_time' => 'int(255) NOT NULL',
159 'last_nicks' => 'longtext COLLATE utf8mb4_general_ci NOT NULL',
160 'connected_time' => 'int(11) NOT NULL',
161 ),
162 'vip_channels' => array
163 (
164 'type_id' => 'text COLLATE utf8mb4_general_ci NOT NULL',
165 ),
166 'statistics' => array
167 (
168 'help_day_start' => "text COLLATE utf8_polish_ci NOT NULL",
169 'help_day_time' => "int(11) NOT NULL DEFAULT '0'",
170 'help_day_count' => "int(11) NOT NULL DEFAULT '0'",
171 'help_week_start' => "text COLLATE utf8_polish_ci NOT NULL",
172 'help_week_time' => "int(11) NOT NULL DEFAULT '0'",
173 'help_week_count' => "int(11) NOT NULL DEFAULT '0'",
174 'help_month_start' => "text COLLATE utf8_polish_ci NOT NULL",
175 'help_month_time' => "int(11) NOT NULL DEFAULT '0'",
176 'help_month_count' => "int(11) NOT NULL DEFAULT '0'",
177 'help_total_time' => "int(11) NOT NULL DEFAULT '0'",
178 'help_total_count' => "int(11) NOT NULL DEFAULT '0'",
179 ),
180 );
181
182 $edits = array
183 (
184 'vip_channels' => array
185 (
186 'channel_cid' => array('from' => 'int(11)', 'to' => 'text COLLATE utf8mb4_general_ci NOT NULL'),
187 ),
188 );
189
190?>