X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;f=testdata.sql;h=bc00077b68fbd1a1682ad5dfa99daae3c6b8dbc1;hb=d26f8acaf7062bc6aa8b4c4cd8bde6dc8202801e;hp=5cf0565094409307ff8550391a01deae565c7edb;hpb=4623c9f2c2bd5309fcd57e9da2f2e18fe3dcdb45;p=gruntmaster-data.git diff --git a/testdata.sql b/testdata.sql index 5cf0565..bc00077 100644 --- a/testdata.sql +++ b/testdata.sql @@ -1,7 +1,9 @@ -CREATE FUNCTION tm() RETURNS BIGINT IMMUTABLE LANGUAGE SQL AS $$ +CREATE OR REPLACE FUNCTION tm() RETURNS BIGINT IMMUTABLE LANGUAGE SQL AS $$ SELECT EXTRACT(epoch FROM NOW())::bigint $$; +TRUNCATE users, contests, problems, jobs RESTART IDENTITY CASCADE; + -- USERS INSERT INTO users (id, admin) VALUES ('MGV', TRUE);