From 02ce1ea0a8bc4941d0fb9389252b273f7553f6ff Mon Sep 17 00:00:00 2001 From: gamesguru Date: Tue, 6 Oct 2020 06:09:23 -0400 Subject: [PATCH] remove sync data, rda trigger.. not used --- sql/tables.sql | 22 ---------------------- 1 file changed, 22 deletions(-) diff --git a/sql/tables.sql b/sql/tables.sql index c545bbf..a8afd35 100644 --- a/sql/tables.sql +++ b/sql/tables.sql @@ -177,25 +177,3 @@ CREATE TABLE rda ( FOREIGN KEY (profile_id) REFERENCES profiles (id) ON UPDATE CASCADE ); -CREATE TRIGGER rda_sync - AFTER UPDATE OF rda ON rda -BEGIN - UPDATE rda SET synced = 0 -WHERE - NEW.profile_id = profile_id AND NEW.nutr_id = nutr_id; - -END; - --- --------------------------------- --- Custom RDAs --------------------------------- - -CREATE TABLE sync_data ( - id integer PRIMARY KEY AUTOINCREMENT, - tablename text NOT NULL, - guid text, - `constraint` text, -- e.g. "(a, b)" in "UNIQUE (a, b)" or "ON CONFLICT (a, b) DO ..." - action text NOT NULL -- insert, delete, update -); - -- 2.52.0