test/mysqlerl_readquery_SUITE_data/table-data.sql


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'));