EeXAyKNA

1DROP TABLE IF EXISTS ${site}_post;
2CREATE TABLE ${site}_post (
3  id int(11) NOT NULL AUTO_INCREMENT,
4  post_id int(11) NOT NULL,
5  user_id int(11) NOT NULL,
6  created datetime NOT NULL,
7  category int(11) NOT NULL,
8  comments_count int(11) NOT NULL,
9  favorites_count int(11) NOT NULL,
10  deleted int(11) NOT NULL,
11  reason varchar(255) NOT NULL,
12  title varchar(255) NOT NULL,
13  PRIMARY KEY (id),
14  KEY user_id (user_id),
15  KEY post_id (post_id)
16) ENGINE=MyISAM DEFAULT CHARSET=latin1;
17
18LOAD DATA LOCAL INFILE 'postdata_${site}.txt' REPLACE INTO TABLE ${site}_post
19LINES TERMINATED BY '\r\n' IGNORE 2 LINES (
20  post_id,user_id,created,category,comments_count,favorites_count,deleted,reason
21);
22
23DROP TABLE IF EXISTS title;
24CREATE TABLE title (
25  id int(11) NOT NULL AUTO_INCREMENT,
26  post_id int(11) NOT NULL,
27  title varchar(255) NOT NULL,
28  PRIMARY KEY (id)
29) ENGINE=MyISAM DEFAULT CHARSET=latin1;
30
31LOAD DATA LOCAL INFILE 'posttitles_${site}.txt' REPLACE INTO TABLE title 
32LINES TERMINATED BY '\r\n' IGNORE 2 LINES (
33  post_id,title
34);
35
36UPDATE ${site}_post p, title t SET p.title = t.title WHERE p.post_id = t.post_id;
37UPDATE ${site}_post SET title = CONCAT('(',post_id,')') WHERE title = '';
38UPDATE ${site}_post SET reason = '' WHERE reason = '[NULL]';
39DROP TABLE title;
40
41DROP TABLE IF EXISTS ${site}_comment;
42CREATE TABLE ${site}_comment (
43  id int(11) NOT NULL AUTO_INCREMENT,
44  best int(11) NOT NULL,
45  comment_id int(11) NOT NULL,
46  created datetime NOT NULL,
47  post_id int(11) NOT NULL,
48  user_id int(11) NOT NULL,
49  favorites_count int(11) NOT NULL,
50  length int(11) NOT NULL,
51  PRIMARY KEY (id),
52  KEY comment_id (comment_id),
53  KEY post_id (post_id),
54  KEY user_id (user_id)
55) ENGINE=MyISAM DEFAULT CHARSET=latin1;
56
57LOAD DATA LOCAL INFILE 'commentdata_${site}.txt' REPLACE INTO TABLE ${site}_comment
58LINES TERMINATED BY '\r\n' IGNORE 2 LINES (
59  comment_id,post_id,user_id,created,favorites_count,best
60);
61
62DROP TABLE IF EXISTS length;
63CREATE TABLE length (
64  id int(11) NOT NULL AUTO_INCREMENT,
65  comment_id int(11) NOT NULL,
66  length int(11) NOT NULL,
67  PRIMARY KEY (id)
68) ENGINE=MyISAM DEFAULT CHARSET=latin1;
69
70LOAD DATA LOCAL INFILE 'commentlength_${site}.txt' REPLACE INTO TABLE length
71LINES TERMINATED BY '\r\n' IGNORE 2 LINES (
72  comment_id,length
73);
74
75UPDATE ${site}_comment c, length l SET c.length = l.length WHERE c.comment_id = l.comment_id;
76DROP TABLE length;
77
78DROP TABLE IF EXISTS ${site}_tag;
79CREATE TABLE ${site}_tag (
80  id int(11) NOT NULL AUTO_INCREMENT,
81  post_id int(11) NOT NULL,
82  created datetime NOT NULL,
83  name varchar(255) NOT NULL,
84  PRIMARY KEY (id),
85  KEY post_id (post_id),
86  KEY name (name)
87) ENGINE=MyISAM DEFAULT CHARSET=latin1;
88
89LOAD DATA LOCAL INFILE 'tagdata_${site}.txt' REPLACE INTO TABLE ${site}_tag
90LINES TERMINATED BY '\r\n' IGNORE 2 LINES (
91  id,post_id,created,name
92);