Open Data/Datenbank: Unterschied zwischen den Versionen

Aktuelle Version vom 7. Februar 2012, 18:08 Uhr

-- -- 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;