Tweet
Galera , está sql aqui é pra cria um xat.com private , eu estava tentando executa-lá , no appserv 1.5.0 com navicat , mas da erro.
Alguem sabe qual MYSQL suporta etá sql ?
Alguem sabe qual MYSQL suporta etá sql ?
Código PHP:
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!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 */;
--
-- Database: `julpai_xat`
--
-- --------------------------------------------------------
--
-- Table structure for table `bans`
--
CREATE TABLE IF NOT EXISTS `bans` (
`chatid` int(11) NOT NULL,
`userid` int(11) NOT NULL,
`unbandate` bigint(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `chats`
--
CREATE TABLE IF NOT EXISTS `chats` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`bg` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=207 ;
INSERT INTO `chats` (`id`, `name`, `bg`, `email`) VALUES
(1, 'Lobby', 'http://i51.tinypic.com/eiqrd2.png', ''),
(2, 'help', 'http://4.bp.blogspot.com/-zJkxbK6E6Q8/TaT2Q39iX8I/AAAAAAAACYo/JW9_Syo3c_4/s400/2z3pagp.gif', 'julia.on@live.com'),
(3, 'trade', 'http://tradec.com.br/wordpress/wp-content/uploads/painel_foto-institucional-trade.png', 'pricila2012@hotmail.com'),
(4, 'test', 'http://i835.photobucket.com/albums/zz272/DefectXat/bluehelp.png', 'julia.on@live.com'),
(4, 'Ajuda', 'http://img132.imageshack.us/img132/1867/ajudateste.jpg', 'capim.ichat@live.com'),
-- --------------------------------------------------------
--
-- Table structure for table `log`
--
CREATE TABLE IF NOT EXISTS `log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL,
`action` varchar(999) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9397 ;
-- --------------------------------------------------------
--
-- Table structure for table `powers`
--
CREATE TABLE IF NOT EXISTS `powers` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Power ID',
`section` varchar(255) NOT NULL DEFAULT 'p0' COMMENT 'P string index',
`name` varchar(255) NOT NULL COMMENT 'Power name',
`subid` bigint(20) NOT NULL COMMENT 'ID in the p string',
`cost` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;
INSERT INTO `powers` (`id`, `section`, `name`, `subid`, `cost`) VALUES
(1, 'p0', 'topman', 2, 200),
(2, 'p0', 'subhide', 4, 100),
(3, 'p0', 'mod8', 8, 500),
(4, 'p0', 'zoom', 16, 300),
(5, 'p0', 'nofollow', 32, 100),
(6, 'p0', 'invert', 64, 200),
(7, 'p0', 'mirror', 128, 100),
(8, 'p0', 'noaudices', 256, 10),
(9, 'p0', 'reghide', 512, 100),
(10, 'p0', 'nopc', 1024, 200),
(11, 'p0', 'tempmod', 2048, 280),
(12, 'p0', 'hat', 4096, 50),
(13, 'p0', 'red', 8192, 100),
(14, 'p0', 'green', 16384, 100),
(15, 'p0', 'blue', 32768, 100),
(16, 'p0', 'light', 65536, 100),
(17, 'p0', 'heart', 131072, 7000),
(18, 'p0', 'shuffle', 262144, 15),
(19, 'p0', 'animate', 524288, 320),
(20, 'p0', 'square', 1048576, 180),
(21, 'p0', 'nameglow', 2097152, 300),
(22, 'p0', 'clear', 15397, 4000),
(23, 'p0', 'boot', 15398, 7000),
(24, 'p0', 'gback', 15399, 6000),
(25, 'p0', 'angel', 15400, 9000),
(26, 'p0', 'diamond', 15396, 2000),
(27, 'p0', 'gag', 15395, 2000),
(28, 'p0', 'fade', 15394, 3000),
(29, 'p0', 'six', 153932, 7000),
(30, 'p0', 'fruit', 153931, 500),
(31, 'p0', 'halloween', 153930, 1000),
(32, 'p0', 'thanksgiving', 153929, 1000),
(33, 'p0', 'snowy', 153928, 600),
(34, 'p0', 'christmas', 153927, 2000),
(35, 'p0', 'irish', 153926, 600),
(36, 'p0', 'easter', 153925, 500),
(37, 'p0', 'military', 153924, 500),
(38, 'p0', 'gkaliens', 153923, 1000),
(39, 'p0', 'scifi', 153922, 900),
(40, 'p0', 'independence', 153921, 500),
(41, 'p0', 'blastde', 153920, 700),
(42, 'p0', 'summer', 153919, 200),
(43, 'p0', 'adventure', 153918, 600),
(44, 'p0', 'feast', 153917, 700),
(45, 'p0', 'shocker', 153916, 700),
(46, 'p0', 'fairy', 153915, 900),
(47, 'p0', 'gkbear', 153914, 200),
(48, 'p0', 'angry', 153913, 2000),
(49, 'p0', 'ugly', 153912, 400),
(50, 'p0', 'gkkitty', 153911, 200),
(51, 'p0', 'hero', 153910, 400),
(52, 'p0', 'gkpanda', 153909, 300),
(53, 'p0', 'unwell', 153908, 400),
(54, 'p0', 'sins', 153907, 2000),
(55, 'p0', 'outfit', 153906, 300),
(56, 'p0', 'wildwest', 153905, 500),
(57, 'p0', 'work', 153904, 300),
(58, 'p0', 'beach', 153903, 400),
(59, 'p0', 'candy', 153902, 600),
(60, 'p0', 'flower', 153901, 2000),
(61, 'p0', 'stoneage', 153900, 300),
(62, 'p0', 'spaceban', 153899, 3000),
(63, 'p0', 'dance', 153898, 200),
(-4, 'p1', 'namecolor', 15301, 10000),
(-3, 'p1', 'valentine', 15300, 9000),
(-2, 'p1', 'purple', 8, 25000),
(-1, 'p1', 'yellow', 16, 50000);
-- --------------------------------------------------------
--
-- Table structure for table `ranks`
--
CREATE TABLE IF NOT EXISTS `ranks` (
`chatid` int(11) NOT NULL,
`userid` int(11) NOT NULL,
`f` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `userpowers`
--
CREATE TABLE IF NOT EXISTS `userpowers` (
`userid` int(11) NOT NULL,
`powerid` int(11) NOT NULL,
`count` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`nickname` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`avatar` varchar(255) NOT NULL,
`url` varchar(255) NOT NULL,
`k` int(255) NOT NULL,
`k2` int(255) NOT NULL,
`k3` int(255) NOT NULL,
`xats` int(11) NOT NULL DEFAULT '50000',
`days` int(11) NOT NULL DEFAULT '3600',
`email` varchar(999) NOT NULL,
`powers` varchar(255) NOT NULL,
`enabled` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1144 ;
(`1``Ju``emersonmeuamor``http://www.xatworld.com/xatimages/xatbootbuy_1.gif``www.google.com``9000000``90000`)
(`2``ixat``aa334455``http://www.xatworld.com/xatimages/xatbootbuy_1.gif``www.google.com``1000000``415`)
(`666``Zica``purpleabcd``http://www.xatworld.com/xatimages/xatbootbuy_1.gif``www.google.com``667000``100`)
(`10``Boss``vollunter10``http://www.xatworld.com/xatimages/xatbootbuy_1.gif``www.google.com``37000``100`)
(`12``trade``pricila``http://www.xatworld.com/xatimages/xatbootbuy_1.gif``www.google.com``50000``4000`)
(`17``Andy``147anderso``http://www.xatworld.com/xatimages/xatbootbuy_1.gif``www.google.com``38000``220`)
(`22``Wiki``Wiki``http://www.xatworld.com/xatimages/xatbootbuy_1.gif``www.google.com``56000``415`)
(`157``Ladrao``yagospynet``http://www.xatworld.com/xatimages/xatbootbuy_1.gif``www.ladrao.com.br``45000``220`)