yTPwHJjG

1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2DROP TABLE IF EXISTS emails;
3CREATE TABLE IF NOT EXISTS emails (
4  id int(10) NOT NULL AUTO_INCREMENT,
5  email varchar(255) NOT NULL,
6  PRIMARY KEY (id),
7  UNIQUE KEY email (email)
8) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=529 ;
9
10DROP TABLE IF EXISTS follower;
11CREATE TABLE IF NOT EXISTS follower (
12  id int(11) NOT NULL,
13  url char(140) DEFAULT NULL,
14  location varchar(30) DEFAULT NULL,
15  userImage binary(1) NOT NULL,
16  userName varchar(30) NOT NULL,
17  userScreenName varchar(30) NOT NULL,
18  followers_count int(10) DEFAULT NULL,
19  UNIQUE KEY id (id)
20) ENGINE=MyISAM DEFAULT CHARSET=latin1;
21
22DROP TABLE IF EXISTS logs;
23CREATE TABLE IF NOT EXISTS `logs` (
24  id int(11) NOT NULL AUTO_INCREMENT,
25  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
26  message varchar(255) NOT NULL,
27  PRIMARY KEY (id)
28) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11740 ;
29
30DROP TABLE IF EXISTS reports;
31CREATE TABLE IF NOT EXISTS reports (
32  id int(11) NOT NULL AUTO_INCREMENT,
33  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
34  message varchar(255) NOT NULL,
35  PRIMARY KEY (id)
36) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3065 ;
37
38DROP TABLE IF EXISTS tweets;
39CREATE TABLE IF NOT EXISTS tweets (
40  id int(11) NOT NULL AUTO_INCREMENT,
41  tweet char(140) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
42  tags varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
43  PRIMARY KEY (id),
44  UNIQUE KEY tweet (tweet)
45) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=158 ;
46
47DROP TABLE IF EXISTS votes;
48CREATE TABLE IF NOT EXISTS votes (
49  id int(11) NOT NULL,
50  memid int(11) NOT NULL,
51  votes_up int(11) NOT NULL,
52  votes_down int(11) NOT NULL,
53  PRIMARY KEY (id),
54  UNIQUE KEY memid (memid)
55) ENGINE=MyISAM DEFAULT CHARSET=latin1;