Advertisement
DubStepMad

Untitled

Apr 30th, 2017
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. CREATE TABLE `staff_logs` (
  2. `case_id` int(11) NOT NULL AUTO_INCREMENT,
  3. `staffn` varchar(50) NOT NULL,
  4. `personr` varchar(50) NOT NULL,
  5. `personbr` varchar(50) NOT NULL,
  6. `playerid` varchar(50) NOT NULL,
  7. `report` int(100) NOT NULL DEFAULT '0',
  8. `outcome` varchar(255) NOT NULL,
  9. `staff_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  10. `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  11. PRIMARY KEY (`case_id`),
  12. UNIQUE KEY `case_id` (`case_id`)
  13. ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement