Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.2.7
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: Aug 28, 2014 at 05:27 PM
- -- Server version: 5.6.17
- -- PHP Version: 5.3.28
- 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: `svr`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `players`
- --
- CREATE TABLE IF NOT EXISTS `players` (
- `ID` int(10) NOT NULL,
- `User` varchar(24) NOT NULL,
- `Pass` varchar(129) NOT NULL,
- `IP` varchar(16) NOT NULL,
- `Admin` int(10) NOT NULL,
- `SkinID` int(10) NOT NULL,
- `LastActivity` varchar(20) NOT NULL,
- `Health` float NOT NULL,
- `Armour` float NOT NULL,
- `MoneyHand` int(10) NOT NULL,
- `MoneyBank` int(10) NOT NULL,
- `AccountLocked` int(10) NOT NULL,
- `AccountBanned` int(10) NOT NULL,
- `BanningAdmin` varchar(24) NOT NULL,
- `BannedReason` varchar(24) NOT NULL,
- `WeaponSlot1` int(10) NOT NULL,
- `WepSlotAmmo1` int(10) NOT NULL,
- `WeaponSlot2` int(10) NOT NULL,
- `WepSlotAmmo2` int(10) NOT NULL,
- `WeaponSlot3` int(10) NOT NULL,
- `WepSlotAmmo3` int(10) NOT NULL,
- `WeaponSlot4` int(10) NOT NULL,
- `WepSlotAmmo4` int(10) NOT NULL,
- `WeaponSlot5` int(10) NOT NULL,
- `WepSlotAmmo5` int(10) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `players`
- --
- ALTER TABLE `players`
- ADD PRIMARY KEY (`ID`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `players`
- --
- ALTER TABLE `players`
- MODIFY `ID` int(10) 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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement