--source include/have_innodb.inc

CREATE TABLE `postac_blokada` (
  `id` int(11) NOT NULL auto_increment,
  `postac_id` int(11) NOT NULL,
  `opis` varchar(255) collate utf8_polish_ci NOT NULL,
  `data` datetime NOT NULL,
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `postac_blokada_postac_id` (`postac_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci ;

INSERT INTO `postac_blokada` (`id`, `postac_id`, `opis`, `data`, `status`) VALUES
(1, 1, 'Lot do Mexico, Meksyk', '2008-07-02 01:57:34', 1),
(2, 1, 'Lot do Rio de Janeiro, Brazylia', '2008-07-02 11:03:07', 1),
(3, 1, 'Wakacje - Rio de Janeiro', '2008-07-02 13:07:55', 1),
(4, 1, 'Lot do Tokyo, Japonia', '2008-07-02 19:28:53', 1),
(5, 4, 'Lot do Villas, Stany Zjednoczone', '2008-07-02 20:14:35', 1),
(6, 3, 'Lot do Brno, Czechy', '2008-07-02 19:30:01', 1),
(7, 1, 'Wakacje - Tokyo', '2008-07-02 20:40:16', 1),
(8, 1, 'Lot do Bytom, Polska', '2008-07-03 11:43:39', 1);

SELECT `postac_blokada`.`id`, `postac_blokada`.`postac_id`, `postac_blokada`.`opis`,
`postac_blokada`.`data`, `postac_blokada`.`status` FROM `postac_blokada` WHERE
`postac_blokada`.`postac_id` = 1  ORDER BY `postac_blokada`.`id` DESC LIMIT 5;

SELECT `postac_blokada`.`id`, `postac_blokada`.`postac_id`, `postac_blokada`.`opis`,
`postac_blokada`.`data`, `postac_blokada`.`status` FROM `postac_blokada` WHERE
`postac_blokada`.`postac_id` = 1  ORDER BY `postac_blokada`.`id` ASC LIMIT 5;