Advertisement
Guest User

Untitled

a guest
May 22nd, 2015
212
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `lc_notes` (
  2. `id` int(12) NOT NULL AUTO_INCREMENT,
  3. `admin` text NOT NULL,
  4. `adminid` varchar(50) NOT NULL,
  5. `playerid` varchar(50) NOT NULL,
  6. `time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  7. `note` text,
  8. PRIMARY KEY (`id`)
  9. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
  10.  
  11. ALTER TABLE `users`
  12. RENAME TO `lc_users`;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement