Open Data/Datenbank
Aus /dev/tal
-- -- Database: `openhaushalt` --
Momentan (7.2.12) sind nur die Tabellen "betrag" und "gruppe" in Benutzung.
-- --------------------------------------------------------
-- -- Table structure for table `betrag` --
CREATE TABLE IF NOT EXISTS `betrag` ( `id` int(11) NOT NULL AUTO_INCREMENT, `wert` int(11) NOT NULL, `gruppe_id` int(11) NOT NULL, `jahr` int(4) NOT NULL, `positiv` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `gb` --
CREATE TABLE IF NOT EXISTS `gb` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(256) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `gruppe` --
CREATE TABLE IF NOT EXISTS `gruppe` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(256) NOT NULL, `vererbung_id` int(11) NOT NULL, `ressort_id` int(11) DEFAULT NULL, `gb_id` int(11) DEFAULT NULL, `amt_id` varchar(256) NOT NULL, `farbe` varchar(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `link` --
CREATE TABLE IF NOT EXISTS `link` ( `id` int(11) NOT NULL AUTO_INCREMENT, `url` varchar(512) NOT NULL, `betrag_id` int(11) NOT NULL, `text` varchar(512) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- -- Table structure for table `ressort` --
CREATE TABLE IF NOT EXISTS `ressort` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(256) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;