bxZKkiEJ

1--
2-- Struktura tabeli dla tabeli `transaction`
3--
4
5DROP TABLE IF EXISTS `transaction`;
6CREATE TABLE IF NOT EXISTS `transaction` (
7  `transactionID` int(8) UNSIGNED NOT NULL AUTO_INCREMENT,
8  `title` varchar(30) COLLATE utf8_polish_ci DEFAULT NULL,
9  `amount` double NOT NULL,
10  `currencyID` int(8) UNSIGNED NOT NULL DEFAULT '1',
11  `date` date NOT NULL,
12  `groupID` int(8) UNSIGNED NOT NULL,
13  `expensesTableID` int(8) UNSIGNED NOT NULL,
14  PRIMARY KEY (`transactionID`),
15  UNIQUE KEY `transactionID` (`transactionID`),
16  KEY `transactionID_2` (`transactionID`),
17  KEY `currencyID` (`currencyID`),
18  KEY `transaction_ibfk_4` (`groupID`),
19  KEY `expensesTableID` (`expensesTableID`)
20) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
21
22--