[ create a new paste ] login | about

Link: http://codepad.org/ST5AIzuQ    [ raw code | fork ]

Plain Text, pasted on Mar 11:
1
2
3
4
5
6
7
8
ALTER TABLE `users` DROP `course`, DROP `cdays`;

CREATE TABLE IF NOT EXISTS `users_courses` (
  `userid` int(11) unsigned NOT NULL COMMENT 'The user id',
  `course` int(3) unsigned NOT NULL COMMENT 'The course id',
  `cdays` int(3) unsigned NOT NULL COMMENT 'Amount of days left'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



Create a new paste based on this one


Comments: