X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=init_pool.sql;h=51ac90e9f8cad2cf12096ad20eefb20969a8e592;hb=e3eb07cfeab870907e965b916048c373afeb6d46;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