5 add external_files table for security
7 @contact: Debian FTP Master <ftpmaster@debian.org>
8 @copyright: 2012 Gergely Nagy <algernon@debian.org>
9 @license: GNU General Public License version 2 or later
12 # This program is free software; you can redistribute it and/or modify
13 # it under the terms of the GNU General Public License as published by
14 # the Free Software Foundation; either version 2 of the License, or
15 # (at your option) any later version.
17 # This program is distributed in the hope that it will be useful,
18 # but WITHOUT ANY WARRANTY; without even the implied warranty of
19 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
20 # GNU General Public License for more details.
22 # You should have received a copy of the GNU General Public License
23 # along with this program; if not, write to the Free Software
24 # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
26 ################################################################################
29 from daklib.dak_exceptions import DBUpdateError
30 from daklib.config import Config
34 CREATE TABLE external_files (
36 filename text NOT NULL,
39 last_used timestamp with time zone,
42 created timestamp with time zone DEFAULT now() NOT NULL,
43 modified timestamp with time zone DEFAULT now() NOT NULL
47 INSERT INTO config(name, value) VALUES ('use_extfiles', 0);
51 ################################################################################
59 for stmt in statements:
62 c.execute("UPDATE config SET value = '87' WHERE name = 'db_revision'")
65 except psycopg2.ProgrammingError as msg:
67 raise DBUpdateError('Unable to apply sick update 87, rollback issued. Error message: {0}'.format(msg))