mirror of
https://github.com/araxiaonline/mod-azerothshard.git
synced 2026-06-13 01:32:21 -04:00
15 lines
559 B
SQL
15 lines
559 B
SQL
DROP TABLE IF EXISTS `guildhouses`;
|
|
CREATE TABLE IF NOT EXISTS `guildhouses` (
|
|
`id` int(16) unsigned NOT NULL AUTO_INCREMENT,
|
|
`guildId` bigint(20) NOT NULL DEFAULT '0',
|
|
`x` double NOT NULL,
|
|
`y` double NOT NULL,
|
|
`z` double NOT NULL,
|
|
`map` int(16) NOT NULL,
|
|
`comment` varchar(255) NOT NULL DEFAULT '',
|
|
`price` bigint(20) NOT NULL DEFAULT '0',
|
|
`faction` int(8) unsigned NOT NULL DEFAULT '3',
|
|
`minguildsize` int(16) unsigned NOT NULL DEFAULT '1',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
|