4 up: function(queryInterface, Sequelize) {
7 queryInterface.addColumn('report_tdial', 'preview_peer', {
8 type: Sequelize.STRING,
13 queryInterface.changeColumn('report_tdial', 'channel_date', {
14 type: Sequelize.DATEONLY,
18 queryInterface.changeColumn('report_tdial', 'channel_time', {
23 queryInterface.changeColumn('report_tdial', 'dialed_date', {
24 type: Sequelize.DATEONLY,
28 queryInterface.changeColumn('report_tdial', 'dialed_time', {
33 queryInterface.changeColumn('report_tdial', 'hangup_date', {
34 type: Sequelize.DATEONLY,
38 queryInterface.changeColumn('report_tdial', 'hangup_time', {
43 queryInterface.changeColumn('report_tdial', 'insert_list_date', {
44 type: Sequelize.DATEONLY,
48 queryInterface.changeColumn('report_tdial', 'insert_list_time', {
53 queryInterface.changeColumn('report_tdial', 'linked_connect_date', {
54 type: Sequelize.DATEONLY,
58 queryInterface.changeColumn('report_tdial', 'linked_connect_time', {
63 queryInterface.changeColumn('report_tdial', 'linked_date', {
64 type: Sequelize.DATEONLY,
68 queryInterface.changeColumn('report_tdial', 'linked_time', {
73 queryInterface.changeColumn('report_tdial', 'queue_joined_date', {
74 type: Sequelize.DATEONLY,
78 queryInterface.changeColumn('report_tdial', 'queue_joined_time', {
83 //defaultValue wrong - STRING
84 queryInterface.changeColumn('report_tdial', 'channel', {
85 type: Sequelize.STRING,
90 queryInterface.changeColumn('report_tdial', 'channel_callerid_name', {
91 type: Sequelize.STRING,
96 queryInterface.changeColumn('report_tdial', 'channel_callerid_num', {
97 type: Sequelize.STRING,
102 queryInterface.changeColumn('report_tdial', 'device', {
103 type: Sequelize.STRING,
108 queryInterface.changeColumn('report_tdial', 'dialed_callerid_name', {
109 type: Sequelize.STRING,
114 queryInterface.changeColumn('report_tdial', 'dialed_channel', {
115 type: Sequelize.STRING,
120 queryInterface.changeColumn('report_tdial', 'linked_callerid_name', {
121 type: Sequelize.STRING,
126 queryInterface.changeColumn('report_tdial', 'linked_channel', {
127 type: Sequelize.STRING,
132 queryInterface.changeColumn('report_tdial', 'linkedid', {
133 type: Sequelize.STRING,
138 queryInterface.changeColumn('report_tdial', 'list_name', {
139 type: Sequelize.STRING,
144 queryInterface.changeColumn('report_tdial', 'number', {
145 type: Sequelize.STRING,
150 queryInterface.changeColumn('report_tdial', 'process_name', {
151 type: Sequelize.STRING,
156 queryInterface.changeColumn('report_tdial', 'queue', {
157 type: Sequelize.STRING,
162 queryInterface.changeColumn('report_tdial', 'rtdtm', {
163 type: Sequelize.STRING,
168 queryInterface.changeColumn('report_tdial', 'rttime', {
169 type: Sequelize.STRING,
174 queryInterface.changeColumn('report_tdial', 'source', {
175 type: Sequelize.STRING,
180 queryInterface.changeColumn('report_tdial', 'spooler_name', {
181 type: Sequelize.STRING,
186 queryInterface.changeColumn('report_tdial', 'uniqueid', {
187 type: Sequelize.STRING,
192 //defaultValue wrong - INT
193 queryInterface.changeColumn('report_tdial', 'channel_event', {
194 type: Sequelize.INTEGER(11),
199 queryInterface.changeColumn('report_tdial', 'dialed_event', {
200 type: Sequelize.INTEGER(11),
205 queryInterface.changeColumn('report_tdial', 'id_list', {
206 type: Sequelize.BIGINT,
211 queryInterface.changeColumn('report_tdial', 'id_process', {
212 type: Sequelize.BIGINT,
217 queryInterface.changeColumn('report_tdial', 'id_source', {
218 type: Sequelize.BIGINT,
223 queryInterface.changeColumn('report_tdial', 'id_spooler', {
224 type: Sequelize.BIGINT,
229 queryInterface.changeColumn('report_tdial', 'linked_event', {
230 type: Sequelize.INTEGER(11),
235 queryInterface.changeColumn('report_tdial', 'preview_event', {
236 type: Sequelize.INTEGER(11),
241 queryInterface.changeColumn('report_tdial', 'queue_entry_event', {
242 type: Sequelize.INTEGER(11),
247 queryInterface.changeColumn('report_tdial', 'queue_position', {
248 type: Sequelize.INTEGER(11),
255 down: function(queryInterface, Sequelize) {
257 queryInterface.removeColumn('report_tdial', 'preview_peer');
260 queryInterface.changeColumn('report_tdial', 'channel_date', {
261 type: Sequelize.DATE,
265 queryInterface.changeColumn('report_tdial', 'channel_time', {
266 type: Sequelize.DATE,
270 queryInterface.changeColumn('report_tdial', 'dialed_date', {
271 type: Sequelize.DATE,
275 queryInterface.changeColumn('report_tdial', 'dialed_time', {
276 type: Sequelize.DATE,
280 queryInterface.changeColumn('report_tdial', 'hangup_date', {
281 type: Sequelize.DATE,
285 queryInterface.changeColumn('report_tdial', 'hangup_time', {
286 type: Sequelize.DATE,
290 queryInterface.changeColumn('report_tdial', 'insert_list_date', {
291 type: Sequelize.DATE,
295 queryInterface.changeColumn('report_tdial', 'insert_list_time', {
296 type: Sequelize.DATE,
300 queryInterface.changeColumn('report_tdial', 'linked_connect_date', {
301 type: Sequelize.DATE,
305 queryInterface.changeColumn('report_tdial', 'linked_connect_time', {
306 type: Sequelize.DATE,
310 queryInterface.changeColumn('report_tdial', 'linked_date', {
311 type: Sequelize.DATE,
315 queryInterface.changeColumn('report_tdial', 'linked_time', {
316 type: Sequelize.DATE,
320 queryInterface.changeColumn('report_tdial', 'queue_joined_date', {
321 type: Sequelize.DATE,
325 queryInterface.changeColumn('report_tdial', 'queue_joined_time', {
326 type: Sequelize.DATE,
330 //defaultValue wrong - STRING
331 queryInterface.changeColumn('report_tdial', 'channel', {
332 type: Sequelize.STRING,
336 queryInterface.changeColumn('report_tdial', 'channel_callerid_name', {
337 type: Sequelize.STRING,
341 queryInterface.changeColumn('report_tdial', 'channel_callerid_num', {
342 type: Sequelize.STRING,
346 queryInterface.changeColumn('report_tdial', 'device', {
347 type: Sequelize.STRING,
351 queryInterface.changeColumn('report_tdial', 'dialed_callerid_name', {
352 type: Sequelize.STRING,
356 queryInterface.changeColumn('report_tdial', 'dialed_channel', {
357 type: Sequelize.STRING,
361 queryInterface.changeColumn('report_tdial', 'linked_callerid_name', {
362 type: Sequelize.STRING,
366 queryInterface.changeColumn('report_tdial', 'linked_channel', {
367 type: Sequelize.STRING,
371 queryInterface.changeColumn('report_tdial', 'linkedid', {
372 type: Sequelize.STRING,
376 queryInterface.changeColumn('report_tdial', 'list_name', {
377 type: Sequelize.STRING,
381 queryInterface.changeColumn('report_tdial', 'number', {
382 type: Sequelize.STRING,
386 queryInterface.changeColumn('report_tdial', 'process_name', {
387 type: Sequelize.STRING,
391 queryInterface.changeColumn('report_tdial', 'queue', {
392 type: Sequelize.STRING,
396 queryInterface.changeColumn('report_tdial', 'rtdtm', {
397 type: Sequelize.STRING,
401 queryInterface.changeColumn('report_tdial', 'rttime', {
402 type: Sequelize.STRING,
406 queryInterface.changeColumn('report_tdial', 'source', {
407 type: Sequelize.STRING,
411 queryInterface.changeColumn('report_tdial', 'spooler_name', {
412 type: Sequelize.STRING,
416 queryInterface.changeColumn('report_tdial', 'uniqueid', {
417 type: Sequelize.STRING,
421 //defaultValue wrong - INT
422 queryInterface.changeColumn('report_tdial', 'channel_event', {
423 type: Sequelize.INTEGER(11),
427 queryInterface.changeColumn('report_tdial', 'dialed_event', {
428 type: Sequelize.INTEGER(11),
432 queryInterface.changeColumn('report_tdial', 'id_list', {
433 type: Sequelize.BIGINT,
437 queryInterface.changeColumn('report_tdial', 'id_process', {
438 type: Sequelize.BIGINT,
442 queryInterface.changeColumn('report_tdial', 'id_source', {
443 type: Sequelize.BIGINT,
447 queryInterface.changeColumn('report_tdial', 'id_spooler', {
448 type: Sequelize.BIGINT,
452 queryInterface.changeColumn('report_tdial', 'linked_event', {
453 type: Sequelize.INTEGER(11),
457 queryInterface.changeColumn('report_tdial', 'preview_event', {
458 type: Sequelize.INTEGER(11),
462 queryInterface.changeColumn('report_tdial', 'queue_entry_event', {
463 type: Sequelize.INTEGER(11),
467 queryInterface.changeColumn('report_tdial', 'queue_position', {
468 type: Sequelize.INTEGER(11),