Coverage for dak/dakdb/update87.py: 100%

1""" 

2add external_files table for security 

3 

4@contact: Debian FTP Master <ftpmaster@debian.org> 

5@copyright: 2012 Gergely Nagy <algernon@debian.org> 

6@license: GNU General Public License version 2 or later 

7""" 

8 

9# This program is free software; you can redistribute it and/or modify 

10# it under the terms of the GNU General Public License as published by 

11# the Free Software Foundation; either version 2 of the License, or 

12# (at your option) any later version. 

13 

14# This program is distributed in the hope that it will be useful, 

15# but WITHOUT ANY WARRANTY; without even the implied warranty of 

16# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 

17# GNU General Public License for more details. 

18 

19# You should have received a copy of the GNU General Public License 

20# along with this program; if not, write to the Free Software 

21# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA 

22 

23################################################################################ 

24 

25statements = [ 

26 """ 

27CREATE TABLE external_files ( 

28 id integer, 

29 filename text NOT NULL, 

30 size bigint NOT NULL, 

31 md5sum text NOT NULL, 

32 last_used timestamp with time zone, 

33 sha1sum text, 

34 sha256sum text, 

35 created timestamp with time zone DEFAULT now() NOT NULL, 

36 modified timestamp with time zone DEFAULT now() NOT NULL 

37); 

38""", 

39 """ 

40INSERT INTO config(name, value) VALUES ('use_extfiles', 0); 

41""", 

42]