-- phpMyAdmin SQL Dump -- version 4.4.1.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Aug 12, 2015 at 06:07 AM -- Server version: 5.5.44 -- PHP Version: 5.6.0 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `ngrp_main` -- -- -------------------------------------------------------- -- -- Table structure for table `jobs` -- CREATE TABLE IF NOT EXISTS `jobs` ( `id` int(11) NOT NULL, `type` int(11) NOT NULL DEFAULT '0', `actormodel` int(11) NOT NULL DEFAULT '0', `posx` float NOT NULL DEFAULT '0', `posy` float NOT NULL DEFAULT '0', `posz` float NOT NULL DEFAULT '0', `delx` float NOT NULL DEFAULT '0', `dely` float NOT NULL DEFAULT '0', `delz` float NOT NULL DEFAULT '0', `int` int(11) NOT NULL DEFAULT '0', `vw` int(11) NOT NULL DEFAULT '0', `level` int(11) NOT NULL DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `jobs` -- ALTER TABLE `jobs` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `jobs` -- ALTER TABLE `jobs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;