Advertisement
Guest User

payments

a guest
Aug 14th, 2012
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.42 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `payments` (
  2.   `uid` INT(11) NOT NULL,
  3.   `amount` FLOAT NOT NULL,
  4.   `pay_date` datetime NOT NULL
  5. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  6.  
  7. --
  8. -- Дамп данных таблицы `payments`
  9. --
  10.  
  11. INSERT INTO `payments` (`uid`, `amount`, `pay_date`) VALUES
  12. (1, 1000, '2012-08-01 12:07:10'),
  13. (1, 1500, '2012-08-01 10:29:29'),
  14. (2, 100, '2012-08-01 00:00:00'),
  15. (2, 50, '2012-08-01 09:15:24');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement