All pastes #611221 Raw Edit

Ex0r

public text v1 · immutable
·published 2007-07-09 20:38 UTC
rendered paste body
/*
SQLyog Community Edition- MySQL GUI v6.03
Host - 5.0.41-community-nt : Database - mangos
*********************************************************************
Server version : 5.0.41-community-nt
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `mangos`;

USE `mangos`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `transports` */

DROP TABLE IF EXISTS `transports`;

CREATE TABLE `transports` (
  `entry` int(11) unsigned NOT NULL default '0',
  `name` text,
  `period` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Transports';

/*Data for the table `transports` */

insert  into `transports`(`entry`,`name`,`period`) values (20808,'Ratchet and Booty Bay',350818),(176244,'Teldrassil and Auberdine',316251),(176231,'Menethil Harbor and Theramore Isle',329313),(176310,'Menethil Harbor and Auberdine',295579),(177233,'Forgotton Coast and Feathermoon Stronghold',317038),(164871,'Orgrimmar and Undercity',356284),(175080,'Grom\'Gol Base Camp and Orgrimmar',303463),(176495,'Grom\'Gol Base Camp and Undercity',333044),(181646,'Azuremyst and Auberdine',251191);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;