· 10 years ago · Mar 17, 2016, 03:12 AM
1 CREATE TABLE IF NOT EXISTS authme (id INTEGER AUTO_INCREMENT,username VARCHAR(255) NOT NULL UNIQUE,password VARCHAR(255) NOT NULL,ip VARCHAR(40) NOT NULL,lastlogin BIGINT,x smallint(6) DEFAULT '0',y smallint(6) DEFAULT '0',z smallint(6) DEFAULT '0',email VARCHAR(255) NOT NULL,CONSTRAINT table_const_prim PRIMARY KEY (id));
2INSERT INTO authme VALUES (1, 'stawesomeness', '$SHA$7e35e601c1adf6e6$cfde6d3874a14ad1763d95d1cfaafa7d7289dbb53f401414b62c9e8f96a75b5f', '69.30.212.170', 1453454091592, 0, 0, 0, 'your@email.com');
3INSERT INTO authme VALUES (2, 'molecularpretzl', '$SHA$83764266b41f5200$67db6d5604bda47c54619538ef317fe5cebb44a32bd02fa5bba9768a37d90d48', '69.30.212.170', 1453454091930, 0, 0, 0, 'your@email.com');
4INSERT INTO authme VALUES (3, 'xxjustin15xx', '$SHA$b94822c4e5a766fd$51e2c75f9e43cad8bb3ab79b1a4d75de68412348e3ff07129ff1f3f862e29c0b', '69.30.212.170', 1453454093232, 0, 0, 0, 'your@email.com');