Database

[fellipesg]

Hello, this is a great job. I was researching chatrooms and I found your project on github and realized that the configuration database sql is missing. Could you publish it?

[omerzubair1]

great job buddy but database could not be attach... please send the database....

[marcferna]

Sorry guys but this project is not maintained anymore. I'll check if I have the database file but I don't think so...

[amolbhandari52]

hey guys i have made it working . i am attaching the db structure

CREATE TABLE messages (
id int(16) NOT NULL,
user varchar(255) NOT NULL,
message text NOT NULL,
room_id int(16) NOT NULL,
created_formatted datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
created datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE rooms (
id int(16) NOT NULL,
name varchar(255) NOT NULL,
created datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[amolbhandari52]

you will have some erros with php syntax in views

[Yakubina]

Thanks to marcferna for the plugin and amolbhandari52 for the configuration of DB! Works great :)