Tim Stallmann timstallmann
andrewxhill
/ change_log.sql
Last active
August 29, 2015 14:23
Create a table to store changes from any of your tables in a log table.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- | |
| -- Create a table in your CartoDB editor called 'version_control' | |
| -- Run the following SQL in your editor to create the needed columns | |
| -- | |
| ALTER TABLE version_control ADD COLUMN data json; | |
| ALTER TABLE version_control ADD COLUMN source_id integer; | |
| ALTER TABLE version_control ADD COLUMN table_name text; | |
| ALTER TABLE version_control ADD COLUMN tg_op text; |