iframe-proxy | Sunbelt Computer Software

20 lines (18 loc) · 1 KB

-- 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;

Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

FilesExpand file tree

create_WPP.sql

Latest commit

History

create_WPP.sql

File metadata and controls