medalibs / testclient Goto Github PK

; Configuration

[DB]
dsn = 'mysql:host=localhost;dbname=test0'
login = root
pwd = root

CREATE TABLE user (
  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(30) NOT NULL UNIQUE,
  pwd VARCHAR(30) NOT NULL,
  is_connected boolean not null default 0
);

CREATE TABLE message (
  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  content VARCHAR(255) ,
  from_id INT(6) NOT NULL,
  to_id INT(6) NOT NULL
);