gistfile1.txt

CREATE TABLE 'AcademicSubjectAssociation' (
  'login' char(40) NOT NULL default '',
  'subject' char(7) NOT NULL default '',
  'year' int(11) NOT NULL default '2000',
  'semester' char(10) NOT NULL default 'autumn', /* enum('autumn','winter','spring','summer') NOT NULL default 'autumn', */
  'association' char(10) NOT NULL default 'tutor', /*enum('coordinator','assessor','lecturer','tutor','liaison','marker','admin','markedit','other','listowner','proposer','propadmin') NOT NULL default 'tutor',*/
  UNIQUE ('login','subject','year','semester','association')
);
CREATE INDEX 'asa_login2' ON 'AcademicSubjectAssociation' ('login','subject','year','semester');
CREATE INDEX 'asa_login3' ON 'AcademicSubjectAssociation' ('login','subject');