From ae4e87df37ed8904de92c7cf2f3a11128cda2a21 Mon Sep 17 00:00:00 2001 From: Paul Buetow Date: Sat, 6 Apr 2013 13:14:41 +0200 Subject: tagging ychat-0.7.4.1 --- docs/mysql_ychat.txt | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100755 docs/mysql_ychat.txt (limited to 'docs') diff --git a/docs/mysql_ychat.txt b/docs/mysql_ychat.txt new file mode 100755 index 0000000..46819bb --- /dev/null +++ b/docs/mysql_ychat.txt @@ -0,0 +1,16 @@ +USE ychat +CREATE TABLE `user` ( + `uid` int(10) NOT NULL auto_increment, + `nick` varchar(30) NOT NULL default '', + `password` varchar(30) NOT NULL default '', + `color1` varchar(30), + `color2` varchar(30), + `email` varchar(50) default '-', + `registerdate` varchar(30) default '-', + `logincounter` varchar(10) default '0', + `status` char(1) default '3', + PRIMARY KEY (`uid`), + KEY `uid` (`uid`) +) TYPE=MyISAM; +GRANT ALL PRIVILEGES ON ychat.* to ychat@localhost IDENTIFIED BY "yctest"; + -- cgit v1.2.3