1、 function description
- The newly- built database has only half a year of tables. Create tables before August and create them forward. It is suitable for the migration server to restore data for one year.
2、 operating instructions
- Execute the following SQL
CALL Proc_CreateVehicleTtsLogMonthTable(12, 0, 1);
call Proc_CreateGpsMonthTable(4, 12, 0, 1);
call Proc_CreateAlarmMonthTable(12, 0, 1, 'default');
call Proc_CreateAlarmMonthTable(12, 0, 1, 'speed');
call Proc_CreateAlarmMonthTable(12, 0, 1, 'run');
call Proc_CreateAlarmMonthTable(12, 0, 1, 'video');
call Proc_CreateAlarmMonthTable(12, 0, 1, 'adas');
call Proc_CreateAlarmMonthTable(12, 0, 1, 'data');
call Proc_CreateAlarmMonthTable(12, 0, 1, 'custom');
CALL Proc_CreateRunLogMonthTable(12, 0, 1);
call Proc_CreateMediaMonthTable(12, 0, 1);
call Proc_CreateTaxiOperationMonthTable(1, 12, 0, 7);
CALL Proc_CreateCBClientLoginMonthTable(12, 0, 7);
CALL Proc_CreateCBVehicleCheckLogMonthTable(12, 0, 7);
- The first parameter is a monthly table indicating how many months to create, starting from the current month (including the current month), and 12 means 12 months;
- The second parameter, 0 means before creation and 1 means after creation;
- The third parameter, with the default
