From 7fedc71439f283acfb7c30614f02f7ed1ebf028a Mon Sep 17 00:00:00 2001 From: APTX Date: Wed, 3 Apr 2013 03:33:01 +0200 Subject: [PATCH] Add new columns to file_location, for future features --- localmylist/share/schema/schema.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/localmylist/share/schema/schema.sql b/localmylist/share/schema/schema.sql index aee175f..a61233a 100644 --- a/localmylist/share/schema/schema.sql +++ b/localmylist/share/schema/schema.sql @@ -129,8 +129,12 @@ CREATE TABLE file_location ( fid integer NOT NULL, host_id integer, path text, + rename_disabled bool NOT NULL DEFAULT false, + original_name text NOT NULL DEFAULT '', renamed timestamp without time zone, + rename_path text NOT NULL DEFAULT '', failed_rename boolean NOT NULL DEFAULT false, + rename_error text NOT NULL DEFAULT '', CONSTRAINT file_location_pk PRIMARY KEY (location_id ), CONSTRAINT file_location_unique_location UNIQUE (fid, host_id, path ) ); -- 2.52.0