tLJZN3sf

1
2-- --------------------------------------------------------
3
4--
5-- Table structure for table `prl_platnosci`
6--
7
8CREATE TABLE IF NOT EXISTS `prl_platnosci` (
9  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
10  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
11  `login` varchar(64) CHARACTER SET utf8 NOT NULL,
12  `email` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
13  `typ` varchar(16) NOT NULL,
14  `opis` text CHARACTER SET utf8,
15  `kod` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
16  `kwota` double UNSIGNED NOT NULL,
17  `usluga` varchar(10) NOT NULL,
18  `wartosc` int(10) UNSIGNED DEFAULT NULL,
19  `wynik` enum('W trakcie realizacji','Odrzucono','Zaakceptowano','Wykonano') NOT NULL DEFAULT 'W trakcie realizacji',
20  `wyjasnienie` varchar(512) CHARACTER SET utf8 DEFAULT NULL,
21  `notatki` text COMMENT 'Widoczne tylko dla administratorow',
22  PRIMARY KEY (`id`)
23) ENGINE=InnoDB AUTO_INCREMENT=5073 DEFAULT CHARSET=latin1;
24
25--
26-- Dumping data for table `prl_platnosci`
27--
28
29INSERT INTO `prl_platnosci` (`id`, `data`, `login`, `email`, `typ`, `opis`, `kod`, `kwota`, `usluga`, `wartosc`, `wynik`, `wyjasnienie`, `notatki`) VALUES