From 84323cd317a650ec7742af9dabac4c033ec8c00d Mon Sep 17 00:00:00 2001 From: Horus3 Date: Mon, 17 Mar 2014 01:17:30 +0100 Subject: Remove the duplicated entry. --- blob/database_schema | 2 -- 1 file changed, 2 deletions(-) (limited to 'blob/database_schema') diff --git a/blob/database_schema b/blob/database_schema index 9736649..f413e22 100755 --- a/blob/database_schema +++ b/blob/database_schema @@ -7,5 +7,3 @@ CREATE TABLE IF NOT EXISTS files (id INTEGER PRIMARY KEY, parent INTEGER, owner CREATE TABLE IF NOT EXISTS log (id INTEGER PRIMARY KEY, user INTEGER, login TEXT, FOREIGN KEY(user) REFERENCES user(id)); CREATE TRIGGER IF NOT EXISTS delete_files AFTER DELETE ON user FOR EACH ROW BEGIN DELETE FROM files WHERE owner=OLD.id; END; - -CREATE TRIGGER IF NOT EXISTS delete_files AFTER DELETE ON user FOR EACH ROW BEGIN DELETE FROM files WHERE owner=OLD.id; END; -- cgit v1.2.3