7Wc4BYKA

1DROP TABLE IF EXISTS user;
2CREATE TABLE user (
3  id int(11) NOT NULL AUTO_INCREMENT,
4  joined datetime NOT NULL,
5  name varchar(255) NOT NULL,
6  PRIMARY KEY (id),
7  KEY name (name)
8) ENGINE=MyISAM DEFAULT CHARSET=latin1;
9
10LOAD DATA LOCAL INFILE 'usernames.txt' REPLACE INTO TABLE user
11LINES TERMINATED BY '\r\n' IGNORE 2 LINES (
12  id,joined,name
13);