Public feed #888398

Something

public text v1 · immutable
Raw Edit
·published 2008-02-02 02:09 UTC
rendered paste body
CREATE TABLE IF NOT EXISTS `expenses_places` (
`id` bigint( 20 ) NOT NULL AUTO_INCREMENT ,
`expense_id` bigint( 20 ) NOT NULL ,
`place_id` bigint( 20 ) NOT NULL ,
PRIMARY KEY ( `id` ) ,
KEY `expense_id` ( `expense_id` ) ,
KEY `place_id` ( `place_id` )
) ENGINE = InnoDB;# MySQL returned an empty result set (i.e. zero rows).
ALTER TABLE `expenses_places` ADD FOREIGN KEY ( `expense_id` ) REFERENCES `expenses` ( `id` ) ,
ADD FOREIGN KEY ( `place_id` ) REFERENCES `places` ( `id` ) ;# MySQL returned an empty result set (i.e. zero rows).