· 7 years ago · Sep 20, 2018, 11:00 AM
1CREATE TABLE IF NOT EXISTS `photos` (
2 `id` int(11) NOT NULL auto_increment,
3 `author` bigint(20) NOT NULL COMMENT 'The user''s Facebook ID.',
4 `filename` varchar(255) NOT NULL,
5 `post_date` timestamp NOT NULL default CURRENT_TIMESTAMP,
6 `year` smallint(6) NOT NULL COMMENT 'Approximate year when costume was worn.',
7 `theme` smallint(6) NOT NULL,
8 `description` varchar(140) NOT NULL,
9 PRIMARY KEY (`id`)
10) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;