Advertisement
Guest User

rfid.sql

a guest
Apr 7th, 2015
403
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.61 KB | None | 0 0
  1. SET NAMES utf8;
  2. SET FOREIGN_KEY_CHECKS = 0;
  3.  
  4. -- ----------------------------
  5. --  Table structure for `rfid`
  6. -- ----------------------------
  7. DROP TABLE IF EXISTS `rfid`;
  8. CREATE TABLE `rfid` (
  9.   `ID` text NOT NULL,
  10.   `name` text,
  11.   `counter` INT(10) DEFAULT NULL,
  12.   `money` FLOAT(20,0) DEFAULT NULL,
  13.   `access` INT(1) NOT NULL,
  14.   PRIMARY KEY (`ID`(10))
  15. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  16.  
  17. -- ----------------------------
  18. --  Records of `rfid`
  19. -- ----------------------------
  20. BEGIN;
  21. INSERT INTO `rfid` VALUES ('[2f75b800]', 'Peter Parker', '0', '10', '1');
  22. COMMIT;
  23.  
  24. SET FOREIGN_KEY_CHECKS = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement