aboutsummaryrefslogtreecommitdiffstats
path: root/test/mysqlerl_readquery_SUITE_data/table-data.sql
blob: 410712fca4188eb9f979b55fb721e4b9eb02ab36 (plain)
1
2
3
4
5
6
7
8
9
10
11
DROP TABLE IF EXISTS user;

CREATE TABLE user (
       username VARCHAR(20) PRIMARY KEY NOT NULL,
       password VARCHAR(64)
);

INSERT INTO user (username, password)
       VALUES ('bjc', MD5('test'));
INSERT INTO user (username, password)
       VALUES ('siobain', MD5('test2'));