dZFYYm9H

1CREATE TABLE IF NOT EXISTS `links` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `subject` varchar(500) NOT NULL,
4  `link` varchar(1000) NOT NULL,
5  `clicks` int(11) NOT NULL,
6  `date` date NOT NULL,
7  PRIMARY KEY (`id`)
8) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
9
10CREATE TABLE IF NOT EXISTS `linkscomments` (
11  `id` int(11) NOT NULL AUTO_INCREMENT,
12  `linkid` int(11) NOT NULL,
13  `name` varchar(200) NOT NULL,
14  `text` varchar(1000) NOT NULL,
15  `date` datetime NOT NULL,
16  PRIMARY KEY (`id`)
17) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
18
19CREATE TABLE IF NOT EXISTS `tips` (
20  `id` int(11) NOT NULL AUTO_INCREMENT,
21  `subject` varchar(500) NOT NULL,
22  `link` varchar(1000) NOT NULL,
23  `date` date NOT NULL,
24  PRIMARY KEY (`id`)
25) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;