DJ0C86iK

1DROP TABLE IF EXISTS `xikki`.`photo_album`;
2CREATE TABLE  `xikki`.`photo_album` (
3  `id` bigint(20) NOT NULL auto_increment,
4  `family_id` bigint(20) default NULL,
5  `name` varchar(64) default NULL,
6  `description` varchar(255) default NULL,
7  `date` date default NULL,
8  `created_at` datetime NOT NULL,
9  `updated_at` datetime NOT NULL,
10  PRIMARY KEY  (`id`),
11  KEY `photo_album_family_id_idx` (`family_id`),
12  CONSTRAINT `photo_album_family_id_family_id` FOREIGN KEY (`family_id`) REFERENCES `family` (`id`)
13) ENGINE=InnoDB DEFAULT CHARSET=utf8;