DenChat Code

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;


CREATE TABLE IF NOT EXISTS `DenCrypt_Msgs` (
  `mid` bigint(20) NOT NULL AUTO_INCREMENT,
  `to_u` varchar(255) COLLATE utf8_bin NOT NULL,
  `from_u` varchar(255) COLLATE utf8_bin NOT NULL,
  `msg` longtext COLLATE utf8_bin NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `read_status` enum('UNREAD','READ') COLLATE utf8_bin NOT NULL DEFAULT 'UNREAD',
  UNIQUE KEY `mid` (`mid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=176 ;

CREATE TABLE IF NOT EXISTS `DenCrypt_SignupCodes` (
  `code` varchar(255) NOT NULL,
  `used` tinyint(1) NOT NULL DEFAULT '0',
  `user` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `DenCrypt_Users` (
  `usr` varchar(255) COLLATE utf8_bin NOT NULL,
  `pwd` longtext COLLATE utf8_bin NOT NULL,
  `admin` enum('0','1','2') COLLATE utf8_bin NOT NULL DEFAULT '0',
  `online` enum('Online','Offline','Away') COLLATE utf8_bin NOT NULL DEFAULT 'Offline',
  `lastPing` bigint(20) NOT NULL DEFAULT '0',
  UNIQUE KEY `usr` (`usr`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;