     body TEXT NOT NULL,
     title TEXT NOT NULL,
     language TEXT NOT NULL, /* two-letter IANA language subtag */
-    case_id INTEGER REFERENCES cases(id)
+    case_id INTEGER REFERENCES cases(id),
+    CONSTRAINT case_id_language PRIMARY KEY(case_id, language)
 );
 
 /* all methods referenced by a case */

    body TEXT,
    title TEXT NOT NULL,
    language TEXT NOT NULL, /* two-letter IANA language subtag */
    organization_id INTEGER REFERENCES organizations(id)
);

/* Keep track of each day and time someone edits */

\include 'migrations/migration_003.sql'
\include 'migrations/migration_004.sql'
\include 'migrations/migration_005.sql'
\include 'migrations/migration_006.sql'
