Advertisement
Guest User

J_register SQL

a guest
Aug 1st, 2011
515
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.12 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 3.2.0.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Darbinė stotis: localhost
  6. -- Atlikimo laikas: 2011 m. Rugpjūčio 02 d. 18:49
  7. -- Serverio versija: 5.1.36
  8. -- PHP versija: 5.3.0
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11.  
  12. --
  13. -- Duombazė: `new_test`
  14. --
  15.  
  16. -- --------------------------------------------------------
  17.  
  18. --
  19. -- Sukurta duomenų struktūra lentelei `users`
  20. --
  21.  
  22. CREATE TABLE IF NOT EXISTS `users` (
  23. `user` varchar(24) NOT NULL,
  24. `password` varchar(24) NOT NULL,
  25. `kills` int(11) NOT NULL,
  26. `deaths` int(11) NOT NULL,
  27. `score` int(11) NOT NULL,
  28. `money` int(11) NOT NULL,
  29. `IP` varchar(18) NOT NULL,
  30. `fight style` int(11) NOT NULL,
  31. `skin` int(11) NOT NULL,
  32. `baned` int(11) NOT NULL,
  33. `Admin Level` int(11) NOT NULL,
  34. `Vip Level` int(11) NOT NULL,
  35. `PositionX` float NOT NULL,
  36. `PositionY` float NOT NULL,
  37. `PositionZ` float NOT NULL,
  38. `Health` float NOT NULL,
  39. `Armour` float NOT NULL,
  40. `Interior` int(11) NOT NULL,
  41. `Wanted Level` int(11) NOT NULL
  42. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  43.  
  44. --
  45. -- Sukurta duomenų kopija lentelei `users`
  46. --
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement