MYSQl help

[ruttie239]

I need a table tiles

help me fast

thanks

 

[ruttie239]

Sorry i made that table

need table Bans

 

[bolero]

Try this:

CREATE TABLE IF NOT EXISTS `bans` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` tinyint(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
`value` int(10) unsigned NOT NULL COMMENT 'ip address (integer), player guid or account number',
`param` int(10) unsigned NOT NULL DEFAULT '4294967295' COMMENT 'used only for ip banishment mask (integer)',
`active` tinyint(1) NOT NULL DEFAULT '1',
`expires` int(11) NOT NULL,
`added` int(10) unsigned NOT NULL,
`admin_id` int(10) unsigned NOT NULL DEFAULT '0',
`comment` text NOT NULL,
`reason` int(10) unsigned NOT NULL DEFAULT '0',
`action` int(10) unsigned NOT NULL DEFAULT '0',
`statement` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `type` (`type`,`value`),
KEY `active` (`active`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

And this:

CREATE TABLE IF NOT EXISTS `tiles` (
`id` int(10) unsigned NOT NULL,
`world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
`house_id` int(10) unsigned NOT NULL,
`x` int(5) unsigned NOT NULL,
`y` int(5) unsigned NOT NULL,
`z` tinyint(2) unsigned NOT NULL,
UNIQUE KEY `id` (`id`,`world_id`),
KEY `x` (`x`,`y`,`z`),
KEY `house_id` (`house_id`,`world_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

[ruttie239]

Thanks for ur help

 

[bolero]

Rep++

 

[dgprado]

I just dont understand why u post the bans table =o
xD

 

[Evil Puncker]

I just dont understand why u post the bans table =o
xD

lol

need table Bans

 

[dgprado]

@up O.O sorry...