Edit File by line
• /home/barbar84/public_h.../wp-conte.../plugins/sujqvwi/ExeBy/smexe_ro.../var/softacul.../dolph
• File: dolph.sql
[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: `dolph742`
[11] Fix | Delete
--
[12] Fix | Delete
[13] Fix | Delete
-- --------------------------------------------------------
[14] Fix | Delete
[15] Fix | Delete
--
[16] Fix | Delete
-- Table structure for table `Profiles`
[17] Fix | Delete
--
[18] Fix | Delete
[19] Fix | Delete
CREATE TABLE `Profiles` (
[20] Fix | Delete
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
[21] Fix | Delete
`NickName` varchar(255) NOT NULL DEFAULT '',
[22] Fix | Delete
`Email` varchar(255) NOT NULL DEFAULT '',
[23] Fix | Delete
`Password` varchar(40) NOT NULL DEFAULT '',
[24] Fix | Delete
`Salt` varchar(10) NOT NULL DEFAULT '',
[25] Fix | Delete
`Status` enum('Unconfirmed','Approval','Active','Rejected','Suspended') NOT NULL DEFAULT 'Unconfirmed',
[26] Fix | Delete
`Role` tinyint(4) unsigned NOT NULL DEFAULT '1',
[27] Fix | Delete
`Couple` int(10) unsigned NOT NULL DEFAULT '0',
[28] Fix | Delete
`Sex` varchar(255) NOT NULL DEFAULT '',
[29] Fix | Delete
`LookingFor` set('male','female') NOT NULL DEFAULT '',
[30] Fix | Delete
`DescriptionMe` text NOT NULL,
[31] Fix | Delete
`Country` varchar(255) NOT NULL DEFAULT '',
[32] Fix | Delete
`City` varchar(255) NOT NULL,
[33] Fix | Delete
`DateOfBirth` date NOT NULL,
[34] Fix | Delete
`Featured` tinyint(1) NOT NULL DEFAULT '0',
[35] Fix | Delete
`DateReg` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[36] Fix | Delete
`DateLastEdit` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[37] Fix | Delete
`DateLastLogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[38] Fix | Delete
`DateLastNav` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[39] Fix | Delete
`aff_num` int(10) unsigned NOT NULL DEFAULT '0',
[40] Fix | Delete
`Tags` varchar(255) NOT NULL DEFAULT '',
[41] Fix | Delete
`zip` varchar(255) NOT NULL,
[42] Fix | Delete
`EmailNotify` tinyint(1) NOT NULL DEFAULT '1',
[43] Fix | Delete
`LangID` int(11) NOT NULL,
[44] Fix | Delete
`UpdateMatch` tinyint(1) NOT NULL DEFAULT '1',
[45] Fix | Delete
`Views` int(11) NOT NULL,
[46] Fix | Delete
`Rate` float NOT NULL,
[47] Fix | Delete
`RateCount` int(11) NOT NULL,
[48] Fix | Delete
`CommentsCount` int(11) NOT NULL,
[49] Fix | Delete
`PrivacyDefaultGroup` int(11) NOT NULL DEFAULT '3',
[50] Fix | Delete
`allow_view_to` int(11) NOT NULL DEFAULT '3',
[51] Fix | Delete
`UserStatus` varchar(64) NOT NULL DEFAULT 'online',
[52] Fix | Delete
`UserStatusMessage` varchar(255) NOT NULL DEFAULT '',
[53] Fix | Delete
`UserStatusMessageWhen` int(10) NOT NULL,
[54] Fix | Delete
`Avatar` int(10) unsigned NOT NULL,
[55] Fix | Delete
`Height` varchar(255) NOT NULL,
[56] Fix | Delete
`Weight` varchar(255) NOT NULL,
[57] Fix | Delete
`Income` varchar(255) NOT NULL,
[58] Fix | Delete
`Occupation` varchar(255) NOT NULL,
[59] Fix | Delete
`Religion` varchar(255) NOT NULL,
[60] Fix | Delete
`Education` varchar(255) NOT NULL,
[61] Fix | Delete
`RelationshipStatus` enum('Single','In a Relationship','Engaged','Married','It''s Complicated','In an Open Relationship') DEFAULT NULL,
[62] Fix | Delete
`Hobbies` text NOT NULL,
[63] Fix | Delete
`Interests` text NOT NULL,
[64] Fix | Delete
`Ethnicity` varchar(255) NOT NULL,
[65] Fix | Delete
`FavoriteSites` text NOT NULL,
[66] Fix | Delete
`FavoriteMusic` text NOT NULL,
[67] Fix | Delete
`FavoriteFilms` text NOT NULL,
[68] Fix | Delete
`FavoriteBooks` text NOT NULL,
[69] Fix | Delete
`FullName` varchar(255) NOT NULL,
[70] Fix | Delete
`FirstName` varchar(255) NOT NULL,
[71] Fix | Delete
`LastName` varchar(255) NOT NULL,
[72] Fix | Delete
PRIMARY KEY (`ID`),
[73] Fix | Delete
UNIQUE KEY `NickName` (`NickName`),
[74] Fix | Delete
KEY `Country` (`Country`),
[75] Fix | Delete
KEY `DateOfBirth` (`DateOfBirth`),
[76] Fix | Delete
KEY `DateReg` (`DateReg`),
[77] Fix | Delete
KEY `DateLastNav` (`DateLastNav`),
[78] Fix | Delete
FULLTEXT KEY `NickName_2` (`NickName`,`FullName`,`FirstName`,`LastName`,`City`,`DescriptionMe`,`Tags`)
[79] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
[80] Fix | Delete
[81] Fix | Delete
--
[82] Fix | Delete
-- Dumping data for table `Profiles`
[83] Fix | Delete
--
[84] Fix | Delete
[85] Fix | Delete
INSERT INTO `Profiles` VALUES
[86] Fix | Delete
(1, '[[admin_username]]', '[[admin_email]]', '[[admin_pass]]', '[[salt]]', 'Active', 3, 0, '', '', '', '', '', '0000-00-00', 0, '[[regtime]]', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', '', 1, 0, 1, 0, 0, 0, 0, 3, 3, 'online', '', 0, 0, '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '');
[87] Fix | Delete
[88] Fix | Delete
-- --------------------------------------------------------
[89] Fix | Delete
[90] Fix | Delete
--
[91] Fix | Delete
-- Table structure for table `RayBoardBoards`
[92] Fix | Delete
--
[93] Fix | Delete
[94] Fix | Delete
CREATE TABLE `RayBoardBoards` (
[95] Fix | Delete
`ID` int(11) NOT NULL AUTO_INCREMENT,
[96] Fix | Delete
`Name` varchar(255) NOT NULL DEFAULT '',
[97] Fix | Delete
`Password` varchar(255) NOT NULL DEFAULT '',
[98] Fix | Delete
`OwnerID` varchar(20) NOT NULL DEFAULT '0',
[99] Fix | Delete
`When` int(11) DEFAULT NULL,
[100] Fix | Delete
`Status` enum('new','normal','delete') NOT NULL DEFAULT 'new',
[101] Fix | Delete
PRIMARY KEY (`ID`)
[102] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[103] Fix | Delete
[104] Fix | Delete
-- --------------------------------------------------------
[105] Fix | Delete
[106] Fix | Delete
--
[107] Fix | Delete
-- Table structure for table `RayBoardCurrentUsers`
[108] Fix | Delete
--
[109] Fix | Delete
[110] Fix | Delete
CREATE TABLE `RayBoardCurrentUsers` (
[111] Fix | Delete
`ID` varchar(20) NOT NULL DEFAULT '',
[112] Fix | Delete
`Nick` varchar(255) NOT NULL,
[113] Fix | Delete
`Sex` enum('M','F') NOT NULL DEFAULT 'M',
[114] Fix | Delete
`Age` int(11) NOT NULL DEFAULT '0',
[115] Fix | Delete
`Photo` varchar(255) NOT NULL DEFAULT '',
[116] Fix | Delete
`Profile` varchar(255) NOT NULL DEFAULT '',
[117] Fix | Delete
`Desc` varchar(255) NOT NULL,
[118] Fix | Delete
`When` int(11) NOT NULL DEFAULT '0',
[119] Fix | Delete
`Status` enum('new','old','idle') NOT NULL DEFAULT 'new',
[120] Fix | Delete
PRIMARY KEY (`ID`)
[121] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[122] Fix | Delete
[123] Fix | Delete
-- --------------------------------------------------------
[124] Fix | Delete
[125] Fix | Delete
--
[126] Fix | Delete
-- Table structure for table `RayBoardUsers`
[127] Fix | Delete
--
[128] Fix | Delete
[129] Fix | Delete
CREATE TABLE `RayBoardUsers` (
[130] Fix | Delete
`ID` int(11) NOT NULL AUTO_INCREMENT,
[131] Fix | Delete
`Board` int(11) NOT NULL DEFAULT '0',
[132] Fix | Delete
`User` varchar(20) NOT NULL DEFAULT '',
[133] Fix | Delete
`When` int(11) DEFAULT NULL,
[134] Fix | Delete
`Status` enum('normal','delete') NOT NULL DEFAULT 'normal',
[135] Fix | Delete
PRIMARY KEY (`ID`)
[136] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[137] Fix | Delete
[138] Fix | Delete
-- --------------------------------------------------------
[139] Fix | Delete
[140] Fix | Delete
--
[141] Fix | Delete
-- Table structure for table `RayChatCurrentUsers`
[142] Fix | Delete
--
[143] Fix | Delete
[144] Fix | Delete
CREATE TABLE `RayChatCurrentUsers` (
[145] Fix | Delete
`ID` varchar(20) NOT NULL DEFAULT '',
[146] Fix | Delete
`Nick` varchar(36) NOT NULL DEFAULT '',
[147] Fix | Delete
`Sex` enum('M','F') NOT NULL DEFAULT 'M',
[148] Fix | Delete
`Age` int(11) NOT NULL DEFAULT '0',
[149] Fix | Delete
`Desc` text NOT NULL,
[150] Fix | Delete
`Photo` varchar(255) NOT NULL DEFAULT '',
[151] Fix | Delete
`Profile` varchar(255) NOT NULL DEFAULT '',
[152] Fix | Delete
`Online` varchar(10) NOT NULL DEFAULT 'online',
[153] Fix | Delete
`Start` int(11) NOT NULL DEFAULT '0',
[154] Fix | Delete
`When` int(11) NOT NULL DEFAULT '0',
[155] Fix | Delete
`Status` enum('new','old','idle','kick','type','online') NOT NULL DEFAULT 'new',
[156] Fix | Delete
PRIMARY KEY (`ID`)
[157] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[158] Fix | Delete
[159] Fix | Delete
-- --------------------------------------------------------
[160] Fix | Delete
[161] Fix | Delete
--
[162] Fix | Delete
-- Table structure for table `RayChatHistory`
[163] Fix | Delete
--
[164] Fix | Delete
[165] Fix | Delete
CREATE TABLE `RayChatHistory` (
[166] Fix | Delete
`ID` int(11) NOT NULL AUTO_INCREMENT,
[167] Fix | Delete
`Room` int(11) NOT NULL DEFAULT '0',
[168] Fix | Delete
`SndRcp` varchar(40) NOT NULL DEFAULT '',
[169] Fix | Delete
`Sender` varchar(20) NOT NULL DEFAULT '',
[170] Fix | Delete
`Recipient` varchar(20) NOT NULL DEFAULT '',
[171] Fix | Delete
`Message` text NOT NULL,
[172] Fix | Delete
`When` int(11) NOT NULL DEFAULT '0',
[173] Fix | Delete
PRIMARY KEY (`ID`)
[174] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[175] Fix | Delete
[176] Fix | Delete
-- --------------------------------------------------------
[177] Fix | Delete
[178] Fix | Delete
--
[179] Fix | Delete
-- Table structure for table `RayChatMemberships`
[180] Fix | Delete
--
[181] Fix | Delete
[182] Fix | Delete
CREATE TABLE `RayChatMemberships` (
[183] Fix | Delete
`ID` int(11) NOT NULL AUTO_INCREMENT,
[184] Fix | Delete
`Setting` int(11) NOT NULL DEFAULT '0',
[185] Fix | Delete
`Value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[186] Fix | Delete
`Membership` int(11) NOT NULL DEFAULT '0',
[187] Fix | Delete
PRIMARY KEY (`ID`)
[188] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
[189] Fix | Delete
[190] Fix | Delete
-- --------------------------------------------------------
[191] Fix | Delete
[192] Fix | Delete
--
[193] Fix | Delete
-- Table structure for table `RayChatMembershipsSettings`
[194] Fix | Delete
--
[195] Fix | Delete
[196] Fix | Delete
CREATE TABLE `RayChatMembershipsSettings` (
[197] Fix | Delete
`ID` int(11) NOT NULL AUTO_INCREMENT,
[198] Fix | Delete
`Name` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[199] Fix | Delete
`Caption` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[200] Fix | Delete
`Type` enum('boolean','number','custom') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'boolean',
[201] Fix | Delete
`Default` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[202] Fix | Delete
`Range` int(3) NOT NULL DEFAULT '3',
[203] Fix | Delete
`Error` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
[204] Fix | Delete
PRIMARY KEY (`ID`),
[205] Fix | Delete
UNIQUE KEY `Name` (`Name`)
[206] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;
[207] Fix | Delete
[208] Fix | Delete
--
[209] Fix | Delete
-- Dumping data for table `RayChatMembershipsSettings`
[210] Fix | Delete
--
[211] Fix | Delete
[212] Fix | Delete
INSERT INTO `RayChatMembershipsSettings` VALUES
[213] Fix | Delete
(1, 'RoomCreate', 'New Rooms Creating:', 'boolean', 'true', 1, 'RayzRoomCreate'),
[214] Fix | Delete
(2, 'PrivateRoomCreate', 'Private Rooms Creating:', 'boolean', 'true', 1, 'RayzPrivateRoomCreate'),
[215] Fix | Delete
(3, 'AVCasting', 'Audio/Video Casting:', 'boolean', 'true', 1, 'RayzAVCasting'),
[216] Fix | Delete
(4, 'AVPlaying', 'Audio/Video Playing (for Messenger):', 'boolean', 'true', 1, 'RayzAVPlaying'),
[217] Fix | Delete
(5, 'AVLargeWindow', 'Enable Large Video Window:', 'boolean', 'true', 1, 'RayzAVLargeWindow'),
[218] Fix | Delete
(6, 'FileSend', 'Files Sending:', 'boolean', 'true', 1, 'RayzFileSend'),
[219] Fix | Delete
(7, 'WhisperMessages', 'Whispering Messages:', 'boolean', 'true', 1, 'RayzWhisperMessages'),
[220] Fix | Delete
(8, 'DirectMessages', 'Addressed Messages:', 'boolean', 'true', 1, 'RayzDirectMessages'),
[221] Fix | Delete
(9, 'RoomsNumber', 'Maximum Rooms Number:', 'number', '100', 3, 'RayzRoomsNumber'),
[222] Fix | Delete
(10, 'ChatsNumber', 'Maximum Private Chats Number:', 'number', '100', 3, 'RayzChatsNumber'),
[223] Fix | Delete
(11, 'AVWindowsNumber', 'Maximum Video Windows Number:', 'number', '100', 3, 'RayzAVWindowsNumber'),
[224] Fix | Delete
(12, 'RestrictedRooms', 'Restricted Rooms:', 'custom', '', 1, 'RayzRestrictedRooms');
[225] Fix | Delete
[226] Fix | Delete
-- --------------------------------------------------------
[227] Fix | Delete
[228] Fix | Delete
--
[229] Fix | Delete
-- Table structure for table `RayChatMessages`
[230] Fix | Delete
--
[231] Fix | Delete
[232] Fix | Delete
CREATE TABLE `RayChatMessages` (
[233] Fix | Delete
`ID` int(11) NOT NULL AUTO_INCREMENT,
[234] Fix | Delete
`Room` int(11) NOT NULL DEFAULT '0',
[235] Fix | Delete
`SndRcp` varchar(40) NOT NULL DEFAULT '',
[236] Fix | Delete
`Sender` varchar(20) NOT NULL DEFAULT '',
[237] Fix | Delete
`Recipient` varchar(20) NOT NULL DEFAULT '',
[238] Fix | Delete
`Whisper` enum('true','false') NOT NULL DEFAULT 'false',
[239] Fix | Delete
`Message` text NOT NULL,
[240] Fix | Delete
`Style` text NOT NULL,
[241] Fix | Delete
`Type` varchar(10) NOT NULL DEFAULT 'text',
[242] Fix | Delete
`When` int(11) NOT NULL DEFAULT '0',
[243] Fix | Delete
PRIMARY KEY (`ID`)
[244] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[245] Fix | Delete
[246] Fix | Delete
-- --------------------------------------------------------
[247] Fix | Delete
[248] Fix | Delete
--
[249] Fix | Delete
-- Table structure for table `RayChatProfiles`
[250] Fix | Delete
--
[251] Fix | Delete
[252] Fix | Delete
CREATE TABLE `RayChatProfiles` (
[253] Fix | Delete
`ID` varchar(20) NOT NULL DEFAULT '0',
[254] Fix | Delete
`Banned` enum('true','false') NOT NULL DEFAULT 'false',
[255] Fix | Delete
`Type` varchar(10) NOT NULL DEFAULT 'full',
[256] Fix | Delete
`Smileset` varchar(255) NOT NULL DEFAULT '',
[257] Fix | Delete
PRIMARY KEY (`ID`)
[258] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[259] Fix | Delete
[260] Fix | Delete
-- --------------------------------------------------------
[261] Fix | Delete
[262] Fix | Delete
--
[263] Fix | Delete
-- Table structure for table `RayChatRooms`
[264] Fix | Delete
--
[265] Fix | Delete
[266] Fix | Delete
CREATE TABLE `RayChatRooms` (
[267] Fix | Delete
`ID` int(11) NOT NULL AUTO_INCREMENT,
[268] Fix | Delete
`Name` varchar(255) NOT NULL DEFAULT '',
[269] Fix | Delete
`Password` varchar(255) NOT NULL DEFAULT '',
[270] Fix | Delete
`Desc` text NOT NULL,
[271] Fix | Delete
`OwnerID` varchar(20) NOT NULL DEFAULT '0',
[272] Fix | Delete
`When` int(11) DEFAULT NULL,
[273] Fix | Delete
`Status` enum('normal','delete') NOT NULL DEFAULT 'normal',
[274] Fix | Delete
PRIMARY KEY (`ID`),
[275] Fix | Delete
UNIQUE KEY `Name` (`Name`)
[276] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
[277] Fix | Delete
[278] Fix | Delete
--
[279] Fix | Delete
-- Dumping data for table `RayChatRooms`
[280] Fix | Delete
--
[281] Fix | Delete
[282] Fix | Delete
INSERT INTO `RayChatRooms` VALUES
[283] Fix | Delete
(1, 'Lobby', '', 'Welcome to our chat! You are in the "Lobby" now, but you can pass into any other public room you wish to - take a look at the "All rooms" box.', '0', 0, 'normal'),
[284] Fix | Delete
(2, 'Friends', '', 'Welcome to the "Friends" room! This is a public room where you can have a fun chat with existing friends or make new ones! Enjoy!', '0', 1, 'normal');
[285] Fix | Delete
[286] Fix | Delete
-- --------------------------------------------------------
[287] Fix | Delete
[288] Fix | Delete
--
[289] Fix | Delete
-- Table structure for table `RayChatRoomsUsers`
[290] Fix | Delete
--
[291] Fix | Delete
[292] Fix | Delete
CREATE TABLE `RayChatRoomsUsers` (
[293] Fix | Delete
`ID` int(11) NOT NULL AUTO_INCREMENT,
[294] Fix | Delete
`Room` int(11) NOT NULL DEFAULT '0',
[295] Fix | Delete
`User` varchar(20) NOT NULL DEFAULT '',
[296] Fix | Delete
`When` int(11) DEFAULT NULL,
[297] Fix | Delete
`Status` enum('normal','delete') NOT NULL DEFAULT 'normal',
[298] Fix | Delete
PRIMARY KEY (`ID`)
[299] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[300] Fix | Delete
[301] Fix | Delete
-- --------------------------------------------------------
[302] Fix | Delete
[303] Fix | Delete
--
[304] Fix | Delete
-- Table structure for table `RayImContacts`
[305] Fix | Delete
--
[306] Fix | Delete
[307] Fix | Delete
CREATE TABLE `RayImContacts` (
[308] Fix | Delete
`ID` int(11) NOT NULL AUTO_INCREMENT,
[309] Fix | Delete
`SenderID` int(11) NOT NULL DEFAULT '0',
[310] Fix | Delete
`RecipientID` int(11) NOT NULL DEFAULT '0',
[311] Fix | Delete
`Online` varchar(10) NOT NULL DEFAULT 'online',
[312] Fix | Delete
`When` int(11) NOT NULL DEFAULT '0',
[313] Fix | Delete
PRIMARY KEY (`ID`)
[314] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[315] Fix | Delete
[316] Fix | Delete
-- --------------------------------------------------------
[317] Fix | Delete
[318] Fix | Delete
--
[319] Fix | Delete
-- Table structure for table `RayImMessages`
[320] Fix | Delete
--
[321] Fix | Delete
[322] Fix | Delete
CREATE TABLE `RayImMessages` (
[323] Fix | Delete
`ID` int(11) NOT NULL AUTO_INCREMENT,
[324] Fix | Delete
`ContactID` int(11) NOT NULL DEFAULT '0',
[325] Fix | Delete
`Message` text NOT NULL,
[326] Fix | Delete
`Style` text NOT NULL,
[327] Fix | Delete
`Type` varchar(10) NOT NULL DEFAULT 'text',
[328] Fix | Delete
`When` int(11) NOT NULL DEFAULT '0',
[329] Fix | Delete
PRIMARY KEY (`ID`)
[330] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[331] Fix | Delete
[332] Fix | Delete
-- --------------------------------------------------------
[333] Fix | Delete
[334] Fix | Delete
--
[335] Fix | Delete
-- Table structure for table `RayImPendings`
[336] Fix | Delete
--
[337] Fix | Delete
[338] Fix | Delete
CREATE TABLE `RayImPendings` (
[339] Fix | Delete
`ID` int(11) NOT NULL AUTO_INCREMENT,
[340] Fix | Delete
`SenderID` int(11) NOT NULL DEFAULT '0',
[341] Fix | Delete
`RecipientID` int(11) NOT NULL DEFAULT '0',
[342] Fix | Delete
`Message` varchar(255) NOT NULL DEFAULT '',
[343] Fix | Delete
`When` int(11) NOT NULL DEFAULT '0',
[344] Fix | Delete
PRIMARY KEY (`ID`),
[345] Fix | Delete
KEY `RecipientID` (`RecipientID`)
[346] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[347] Fix | Delete
[348] Fix | Delete
-- --------------------------------------------------------
[349] Fix | Delete
[350] Fix | Delete
--
[351] Fix | Delete
-- Table structure for table `RayImProfiles`
[352] Fix | Delete
--
[353] Fix | Delete
[354] Fix | Delete
CREATE TABLE `RayImProfiles` (
[355] Fix | Delete
`ID` int(11) NOT NULL DEFAULT '0',
[356] Fix | Delete
`Smileset` varchar(255) NOT NULL DEFAULT '',
[357] Fix | Delete
PRIMARY KEY (`ID`)
[358] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[359] Fix | Delete
[360] Fix | Delete
-- --------------------------------------------------------
[361] Fix | Delete
[362] Fix | Delete
--
[363] Fix | Delete
-- Table structure for table `RayMp3Files`
[364] Fix | Delete
--
[365] Fix | Delete
[366] Fix | Delete
CREATE TABLE `RayMp3Files` (
[367] Fix | Delete
`ID` int(11) NOT NULL AUTO_INCREMENT,
[368] Fix | Delete
`Categories` text NOT NULL,
[369] Fix | Delete
`Title` varchar(255) NOT NULL DEFAULT '',
[370] Fix | Delete
`Uri` varchar(255) NOT NULL DEFAULT '',
[371] Fix | Delete
`Tags` text NOT NULL,
[372] Fix | Delete
`Description` text NOT NULL,
[373] Fix | Delete
`Time` int(11) NOT NULL DEFAULT '0',
[374] Fix | Delete
`Date` int(20) NOT NULL DEFAULT '0',
[375] Fix | Delete
`Reports` int(11) NOT NULL DEFAULT '0',
[376] Fix | Delete
`Owner` varchar(64) NOT NULL DEFAULT '',
[377] Fix | Delete
`Listens` int(12) DEFAULT '0',
[378] Fix | Delete
`Rate` float NOT NULL,
[379] Fix | Delete
`RateCount` int(11) NOT NULL,
[380] Fix | Delete
`CommentsCount` int(11) NOT NULL,
[381] Fix | Delete
`Featured` tinyint(4) NOT NULL,
[382] Fix | Delete
`Status` enum('approved','disapproved','pending','processing','failed') NOT NULL DEFAULT 'pending',
[383] Fix | Delete
PRIMARY KEY (`ID`),
[384] Fix | Delete
UNIQUE KEY `Uri` (`Uri`),
[385] Fix | Delete
KEY `Owner` (`Owner`),
[386] Fix | Delete
FULLTEXT KEY `ftMain` (`Title`,`Tags`,`Description`,`Categories`),
[387] Fix | Delete
FULLTEXT KEY `ftTags` (`Tags`),
[388] Fix | Delete
FULLTEXT KEY `ftCategories` (`Categories`)
[389] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[390] Fix | Delete
[391] Fix | Delete
-- --------------------------------------------------------
[392] Fix | Delete
[393] Fix | Delete
--
[394] Fix | Delete
-- Table structure for table `RayMp3Tokens`
[395] Fix | Delete
--
[396] Fix | Delete
[397] Fix | Delete
CREATE TABLE `RayMp3Tokens` (
[398] Fix | Delete
`ID` int(11) NOT NULL DEFAULT '0',
[399] Fix | Delete
`Token` varchar(32) NOT NULL DEFAULT '',
[400] Fix | Delete
`Date` int(20) NOT NULL DEFAULT '0',
[401] Fix | Delete
PRIMARY KEY (`ID`,`Token`)
[402] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[403] Fix | Delete
[404] Fix | Delete
-- --------------------------------------------------------
[405] Fix | Delete
[406] Fix | Delete
--
[407] Fix | Delete
-- Table structure for table `RayShoutboxMessages`
[408] Fix | Delete
--
[409] Fix | Delete
[410] Fix | Delete
CREATE TABLE `RayShoutboxMessages` (
[411] Fix | Delete
`ID` int(11) NOT NULL AUTO_INCREMENT,
[412] Fix | Delete
`UserID` varchar(20) NOT NULL DEFAULT '0',
[413] Fix | Delete
`Msg` text NOT NULL,
[414] Fix | Delete
`When` int(11) NOT NULL DEFAULT '0',
[415] Fix | Delete
PRIMARY KEY (`ID`)
[416] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[417] Fix | Delete
[418] Fix | Delete
-- --------------------------------------------------------
[419] Fix | Delete
[420] Fix | Delete
--
[421] Fix | Delete
-- Table structure for table `RayVideoFiles`
[422] Fix | Delete
--
[423] Fix | Delete
[424] Fix | Delete
CREATE TABLE `RayVideoFiles` (
[425] Fix | Delete
`ID` int(11) NOT NULL AUTO_INCREMENT,
[426] Fix | Delete
`Categories` text NOT NULL,
[427] Fix | Delete
`Title` varchar(255) NOT NULL DEFAULT '',
[428] Fix | Delete
`Uri` varchar(255) NOT NULL DEFAULT '',
[429] Fix | Delete
`Tags` text NOT NULL,
[430] Fix | Delete
`Description` text NOT NULL,
[431] Fix | Delete
`Time` int(11) NOT NULL DEFAULT '0',
[432] Fix | Delete
`Date` int(20) NOT NULL DEFAULT '0',
[433] Fix | Delete
`Owner` varchar(64) NOT NULL DEFAULT '',
[434] Fix | Delete
`Views` int(12) DEFAULT '0',
[435] Fix | Delete
`Rate` float NOT NULL,
[436] Fix | Delete
`RateCount` int(11) NOT NULL,
[437] Fix | Delete
`CommentsCount` int(11) NOT NULL,
[438] Fix | Delete
`Featured` tinyint(4) NOT NULL,
[439] Fix | Delete
`Status` enum('approved','disapproved','pending','processing','failed') NOT NULL DEFAULT 'pending',
[440] Fix | Delete
`Source` varchar(20) NOT NULL DEFAULT '',
[441] Fix | Delete
`Video` varchar(32) NOT NULL DEFAULT '',
[442] Fix | Delete
PRIMARY KEY (`ID`),
[443] Fix | Delete
UNIQUE KEY `Uri` (`Uri`),
[444] Fix | Delete
KEY `Owner` (`Owner`),
[445] Fix | Delete
FULLTEXT KEY `ftMain` (`Title`,`Tags`,`Description`,`Categories`),
[446] Fix | Delete
FULLTEXT KEY `ftTags` (`Tags`),
[447] Fix | Delete
FULLTEXT KEY `ftCategories` (`Categories`)
[448] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[449] Fix | Delete
[450] Fix | Delete
-- --------------------------------------------------------
[451] Fix | Delete
[452] Fix | Delete
--
[453] Fix | Delete
-- Table structure for table `RayVideoTokens`
[454] Fix | Delete
--
[455] Fix | Delete
[456] Fix | Delete
CREATE TABLE `RayVideoTokens` (
[457] Fix | Delete
`ID` int(11) NOT NULL DEFAULT '0',
[458] Fix | Delete
`Token` varchar(32) NOT NULL DEFAULT '',
[459] Fix | Delete
`Date` int(20) NOT NULL DEFAULT '0',
[460] Fix | Delete
PRIMARY KEY (`ID`,`Token`)
[461] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[462] Fix | Delete
[463] Fix | Delete
-- --------------------------------------------------------
[464] Fix | Delete
[465] Fix | Delete
--
[466] Fix | Delete
-- Table structure for table `RayVideo_commentsFiles`
[467] Fix | Delete
--
[468] Fix | Delete
[469] Fix | Delete
CREATE TABLE `RayVideo_commentsFiles` (
[470] Fix | Delete
`ID` int(11) NOT NULL AUTO_INCREMENT,
[471] Fix | Delete
`Categories` text NOT NULL,
[472] Fix | Delete
`Title` varchar(255) NOT NULL DEFAULT '',
[473] Fix | Delete
`Uri` varchar(255) NOT NULL DEFAULT '',
[474] Fix | Delete
`Tags` text NOT NULL,
[475] Fix | Delete
`Description` text NOT NULL,
[476] Fix | Delete
`Time` int(11) NOT NULL DEFAULT '0',
[477] Fix | Delete
`Date` int(20) NOT NULL DEFAULT '0',
[478] Fix | Delete
`Owner` varchar(64) NOT NULL DEFAULT '',
[479] Fix | Delete
`Views` int(12) DEFAULT '0',
[480] Fix | Delete
`Status` enum('approved','disapproved','pending','processing','failed') NOT NULL DEFAULT 'pending',
[481] Fix | Delete
PRIMARY KEY (`ID`),
[482] Fix | Delete
UNIQUE KEY `Uri` (`Uri`),
[483] Fix | Delete
KEY `Owner` (`Owner`)
[484] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[485] Fix | Delete
[486] Fix | Delete
-- --------------------------------------------------------
[487] Fix | Delete
[488] Fix | Delete
--
[489] Fix | Delete
-- Table structure for table `RayVideo_commentsTokens`
[490] Fix | Delete
--
[491] Fix | Delete
[492] Fix | Delete
CREATE TABLE `RayVideo_commentsTokens` (
[493] Fix | Delete
`ID` int(11) NOT NULL DEFAULT '0',
[494] Fix | Delete
`Token` varchar(32) NOT NULL DEFAULT '',
[495] Fix | Delete
`Date` int(20) NOT NULL DEFAULT '0',
[496] Fix | Delete
PRIMARY KEY (`ID`,`Token`)
[497] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[498] Fix | Delete
[499] Fix | Delete
123456...17
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function