Open chunhoong opened 8 years ago
Create 'location_logs' table to store location record when new location is inserted into 'locations' table, by using trigger.
Then we can cleanup 'locations' table from time to time, while having all the location data in 'location_logs' table
Create 'location_logs' table to store location record when new location is inserted into 'locations' table, by using trigger.
Then we can cleanup 'locations' table from time to time, while having all the location data in 'location_logs' table