View file framework/cli/views/webapp/protected/data/schema.mysql.sql

File size: 2.2Kb
CREATE TABLE tbl_user (
    id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(128) NOT NULL,
    password VARCHAR(128) NOT NULL,
    email VARCHAR(128) NOT NULL
);

INSERT INTO tbl_user (username, password, email) VALUES ('test1', 'pass1', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test2', 'pass2', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test3', 'pass3', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test4', 'pass4', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test5', 'pass5', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test6', 'pass6', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test7', 'pass7', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test8', 'pass8', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test9', 'pass9', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test10', 'pass10', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test11', 'pass11', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test12', 'pass12', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test13', 'pass13', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test14', 'pass14', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test15', 'pass15', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test16', 'pass16', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test17', 'pass17', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test18', 'pass18', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test19', 'pass19', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test20', 'pass20', '[email protected]');
INSERT INTO tbl_user (username, password, email) VALUES ('test21', 'pass21', '[email protected]');