/
create_WPP.sql
20 lines (18 loc) · 1 KB
/
create_WPP.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
-- Create DB
CREATE DATABASE `WPP`;
-- Table structure for table `SniffData`
CREATE TABLE IF NOT EXISTS `WPP`.`SniffData` (
`Build` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`SniffName` TEXT NOT NULL,
`ObjectType` ENUM('None','Spell','Map','LFGDungeon','Battleground','Unit','GameObject','Item','Quest','Opcode','PageText','NpcText','Gossip','Zone','Area','Phase','Player') NOT NULL DEFAULT 'None', -- StoreNameType.cs enum
`Id` INT(10) NOT NULL DEFAULT '0',
`Data` TEXT NOT NULL,
UNIQUE KEY `SniffName` (`ObjectType`,`Id`,`Data`(255))
) ENGINE=INNODB DEFAULT CHARSET=latin1;
-- Table structure for table `ObjectNames`
CREATE TABLE IF NOT EXISTS `WPP`.`ObjectNames` (
`ObjectType` enum('None','Spell','Map','LFGDungeon','Battleground','Unit','GameObject','Item','Quest','Opcode','PageText','NpcText','Gossip','Zone','Area','Phase','Player') NOT NULL DEFAULT 'None', -- StoreNameType.cs enum
`Id` int(10) NOT NULL,
`Name` text NOT NULL,
PRIMARY KEY (`ObjectType`,`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;