Subversion Repositories instagram

[/] [sql/] [mysql/] [instagram.sql] - Blame information for rev 2

Details | Compare with Previous | View Log

Line No. Rev Author Line
1 2 ffruehstueck
 
2
CREATE TABLE IF NOT EXISTS `ezig` (
3
  `id` int(11) NOT NULL AUTO_INCREMENT,
4
  `accessToken` varchar(255) NOT NULL,
5
  `ig_username` varchar(255) NOT NULL,
6
  `ig_profile_picture` varchar(255) NOT NULL,
7
  `ig_full_name` varchar(255) NOT NULL,
8
  `ig_id` int(11) NOT NULL,
9
  PRIMARY KEY (`id`)
10
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
11
 
12
-- --------------------------------------------------------
13
 
14
CREATE TABLE IF NOT EXISTS `ezig_photos` (
15
  `created_time` int(11) NOT NULL,
16
  `link` varchar(255) NOT NULL,
17
  `likes_count` int(11) NOT NULL,
18
  `images` text NOT NULL,
19
  `id` varchar(255) NOT NULL,
20
  `caption` varchar(255) NOT NULL,
21
  `tags` text NOT NULL,
22
  `user_id` int(11) NOT NULL,
23
  `contentobject_id` int(11) NOT NULL DEFAULT '0'
24
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
25
 
26
-- --------------------------------------------------------
27