rendered paste body| weatherdatalayout | CREATE TABLE `weatherdatalayout` (
`location` varchar(64) NOT NULL,
`dataitem` varchar(64) NOT NULL,
`weatherscreens_screen_id` int(10) unsigned NOT NULL,
`weathersourcesettings_sourceid` int(10) unsigned NOT NULL,
PRIMARY KEY (`location`,`dataitem`,`weatherscreens_screen_id`,`weathersourcesettings_sourceid`),
KEY `weatherdatalayout_FKIndex1` (`weatherscreens_screen_id`),
KEY `weatherdatalayout_FKIndex2` (`weathersourcesettings_sourceid`),
CONSTRAINT `weatherdatalayout_ibfk_1` FOREIGN KEY (`weatherscreens_screen_id`) REFERENCES `weatherscreens` (`screen_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `weatherdatalayout_ibfk_2` FOREIGN KEY (`weathersourcesettings_sourceid`) REFERENCES `weathersourcesettings` (`sourceid`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |