Skip to content
Snippets Groups Projects
Select Git revision
  • 6de8088673455b2044197afca352204514da2026
  • devel default
  • master
  • fo
  • jirka/typing
  • fo-base
  • mj/submit-images
  • jk/issue-96
  • jk/issue-196
  • honza/add-contestant
  • honza/mr7
  • honza/mrf
  • honza/mrd
  • honza/mra
  • honza/mr6
  • honza/submit-images
  • honza/kolo-vs-soutez
  • jh-stress-test-wip
  • shorten-schools
19 results

org_score.py

Blame
  • upgrade-20210701.sql 589 B
    SET ROLE 'mo_osmo';
    
    ALTER TYPE job_type ADD VALUE 'create_protocols';
    ALTER TYPE job_type ADD VALUE 'process_scans';
    
    ALTER TYPE job_state ADD VALUE 'preparing';
    
    CREATE TABLE scan_pages (
    	job_id		int		NOT NULL REFERENCES jobs(job_id) ON DELETE CASCADE,
    	file_nr		int		NOT NULL,					-- co to je za stránku
    	page_nr		int		NOT NULL,
    	user_id		int		DEFAULT NULL REFERENCES users(user_id),		-- přiřazení účastníkovi a úloze
    	task_id		int		DEFAULT NULL REFERENCES tasks(task_id),
    	seq_id		int		NOT NULL,					-- pořadové číslo v rámci úlohy
    	UNIQUE (job_id, file_nr, page_nr)
    );