Advertisement
Guest User

Untitled

a guest
Nov 17th, 2019
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1.  
  2.  
  3. CREATE TABLE `peage_flash` (
  4. `id` int(11) NOT NULL,
  5. `plate` varchar(10) NOT NULL,
  6. `speed` int(11) NOT NULL,
  7. `modele` varchar(25) NOT NULL,
  8. `station` int(11) NOT NULL
  9. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  10.  
  11.  
  12.  
  13. INSERT INTO `peage_flash` (`id`, `plate`, `speed`, `modele`, `station`) VALUES
  14. (1, '09JBK526', 168, 'T20', 1);
  15.  
  16.  
  17.  
  18. ALTER TABLE `peage_flash`
  19. ADD PRIMARY KEY (`id`);
  20.  
  21.  
  22. --
  23. ALTER TABLE `peage_flash`
  24. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
  25. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  26. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  27. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement