zeke (owner)

Revisions

gist: 210268 Download_button fork
public
Public Clone URL: git://gist.github.com/210268.git
Embed All Files: show embed
fa member photos.sql #
raw 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

# Dump of table flickr_users
# ------------------------------------------------------------
 
CREATE TABLE `flickr_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `nsid` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=209 DEFAULT CHARSET=latin1;
 
 
 
# Dump of table photos
# ------------------------------------------------------------
 
CREATE TABLE `photos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `flickr_user_id` varchar(255) DEFAULT NULL,
  `photo_id` varchar(255) DEFAULT NULL,
  `farm` varchar(255) DEFAULT NULL,
  `server` varchar(255) DEFAULT NULL,
  `secret` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `favorite` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26060 DEFAULT CHARSET=latin1;