[0] Fix | Delete

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

[1] Fix | Delete

SET time_zone = "+00:00";

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

[5] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

[6] Fix | Delete

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

[7] Fix | Delete

/*!40101 SET NAMES utf8 */;

[8] Fix | Delete

[9] Fix | Delete

--

[10] Fix | Delete

-- Database: `soft_chat088`

[11] Fix | Delete

--

[12] Fix | Delete

[13] Fix | Delete

--

[14] Fix | Delete

-- Table structure for table `ajax_chat_bans`

[15] Fix | Delete

--

[16] Fix | Delete

[17] Fix | Delete

CREATE TABLE `ajax_chat_bans` (

[18] Fix | Delete

`userID` int(11) NOT NULL,

[19] Fix | Delete

`userName` varchar(64) COLLATE utf8_bin NOT NULL,

[20] Fix | Delete

`dateTime` datetime NOT NULL,

[21] Fix | Delete

`ip` varbinary(16) NOT NULL,

[22] Fix | Delete

PRIMARY KEY (`userID`),

[23] Fix | Delete

KEY `userName` (`userName`),

[24] Fix | Delete

KEY `dateTime` (`dateTime`)

[25] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

[26] Fix | Delete

[27] Fix | Delete

-- --------------------------------------------------------

[28] Fix | Delete

[29] Fix | Delete

--

[30] Fix | Delete

-- Table structure for table `ajax_chat_invitations`

[31] Fix | Delete

--

[32] Fix | Delete

[33] Fix | Delete

CREATE TABLE `ajax_chat_invitations` (

[34] Fix | Delete

`userID` int(11) NOT NULL,

[35] Fix | Delete

`channel` int(11) NOT NULL,

[36] Fix | Delete

`dateTime` datetime NOT NULL,

[37] Fix | Delete

PRIMARY KEY (`userID`,`channel`),

[38] Fix | Delete

KEY `dateTime` (`dateTime`)

[39] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

[40] Fix | Delete

[41] Fix | Delete

-- --------------------------------------------------------

[42] Fix | Delete

[43] Fix | Delete

--

[44] Fix | Delete

-- Table structure for table `ajax_chat_messages`

[45] Fix | Delete

--

[46] Fix | Delete

[47] Fix | Delete

CREATE TABLE `ajax_chat_messages` (

[48] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[49] Fix | Delete

`userID` int(11) NOT NULL,

[50] Fix | Delete

`userName` varchar(64) COLLATE utf8_bin NOT NULL,

[51] Fix | Delete

`userRole` int(1) NOT NULL,

[52] Fix | Delete

`channel` int(11) NOT NULL,

[53] Fix | Delete

`dateTime` datetime NOT NULL,

[54] Fix | Delete

`ip` varbinary(16) NOT NULL,

[55] Fix | Delete

`text` text COLLATE utf8_bin,

[56] Fix | Delete

PRIMARY KEY (`id`),

[57] Fix | Delete

KEY `message_condition` (`id`,`channel`,`dateTime`),

[58] Fix | Delete

KEY `dateTime` (`dateTime`)

[59] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

[60] Fix | Delete

[61] Fix | Delete

-- --------------------------------------------------------

[62] Fix | Delete

[63] Fix | Delete

--

[64] Fix | Delete

-- Table structure for table `ajax_chat_online`

[65] Fix | Delete

--

[66] Fix | Delete

[67] Fix | Delete

CREATE TABLE `ajax_chat_online` (

[68] Fix | Delete

`userID` int(11) NOT NULL,

[69] Fix | Delete

`userName` varchar(64) COLLATE utf8_bin NOT NULL,

[70] Fix | Delete

`userRole` int(1) NOT NULL,

[71] Fix | Delete

`channel` int(11) NOT NULL,

[72] Fix | Delete

`dateTime` datetime NOT NULL,

[73] Fix | Delete

`ip` varbinary(16) NOT NULL,

[74] Fix | Delete

PRIMARY KEY (`userID`),

[75] Fix | Delete

KEY `userName` (`userName`)

[76] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

[77] Fix | Delete

[78] Fix | Delete

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

[79] Fix | Delete

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

[80] Fix | Delete

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[81] Fix | Delete

[82] Fix | Delete