X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=init_pool.sql;h=51ac90e9f8cad2cf12096ad20eefb20969a8e592;hb=f92156d5ec5ea4aa65035a6835ec1b9e8c466230;hp=0730d8fa5102b868df6b44b098274c4d6e800652;hpb=336e084aeebe6c6c6f07b8c9172a7fe8fb93487f;p=dak.git diff --git a/init_pool.sql b/init_pool.sql index 0730d8fa..51ac90e9 100644 --- a/init_pool.sql +++ b/init_pool.sql @@ -1,5 +1,5 @@ DROP DATABASE projectb; -CREATE DATABASE projectb; +CREATE DATABASE projectb WITH ENCODING = 'SQL_ASCII'; \c projectb @@ -142,7 +142,8 @@ CREATE TABLE override ( unique (suite, component, package, type) ); -CREATE TABLE unstable_accepted ( +CREATE TABLE accepted_autobuild ( + suite INT4 NOT NULL, -- references suite filename TEXT NOT NULL, in_accepted BOOLEAN NOT NULL, last_used TIMESTAMP