Public feed #598495

Fegis

public sql v1 · immutable
Raw Edit
·published 2007-07-01 11:58 UTC
rendered paste body
CREATE TABLE `attendants` (  `users_id` INT UNSIGNED NOT NULL ,  `conferences_id` INT UNSIGNED NOT NULL ,  `status` ENUM( 'invited', 'declined', 'accepted' ) NOT NULL ,  PRIMARY KEY ( `users_id` , `conferences_id` ),   FOREIGN KEY ( `conferences_id` ) REFERENCES `conferences` ( `id` ) ON UPDATE CASCADE ON DELETE CASCADE,  FOREIGN KEY ( `users_id` ) REFERENCES `users` ( `id` ) ON UPDATE CASCADE ON DELETE CASCADE) ENGINE = innodb;#1005 - Can't create table '.\vc\attendants.frm' (errno: 150)