Schema difference incoming.account_transaction (table) sql = CREATE TABLE "account_transaction" (
id TEXT PRIMARY KEY DEFAULT ( printf('%x', julianday('now')*86400000) || '-' || lower(hex(randomblob(10))) ),
created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
posted TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
account_id TEXT,
amount INTEGER,
memo TEXT,
fi_id TEXT,
general_cat TEXT DEFAULT '', notes TEXT DEFAULT '', cleared TINYINT DEFAULT 0,
FOREIGN KEY(account_id) REFERENCES account(id)
)
Schema difference main.account_transaction (table) sql = CREATE TABLE "account_transaction" (
id TEXT PRIMARY KEY DEFAULT ( printf('%x', julianday('now')*86400000) || '-' || lower(hex(randomblob(10))) ),
created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
posted TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
account_id TEXT,
amount INTEGER,
memo TEXT,
fi_id TEXT,
general_cat TEXT DEFAULT '', notes TEXT DEFAULT '', cleared TINYINT DEFAULT 0,
FOREIGN KEY(account_id) REFERENCES account(id)
)
