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

1"""list of external signature requests

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

4@copyright: 2018, Ansgar Burchardt <ansgar@debian.org>

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

6"""

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

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

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

11# (at your option) any later version.

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

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

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

16# GNU General Public License for more details.

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

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

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

22################################################################################

24statements = [

25 """

26CREATE TABLE external_signature_requests (

27 association_id INTEGER NOT NULL REFERENCES bin_associations(id) ON DELETE CASCADE,

28 suite_id INTEGER NOT NULL REFERENCES suite(id) ON DELETE CASCADE,

29 PRIMARY KEY (association_id, suite_id)

31"""