Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 3.1.3
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Erstellungszeit: 31. Dezember 2011 um 15:20
- -- Server Version: 5.0.51
- -- PHP-Version: 5.2.4-2ubuntu5.19
- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- --
- -- Datenbank: `haushaltsbuch_mo`
- --
- -- --------------------------------------------------------
- --
- -- Tabellenstruktur für Tabelle `kontostaende`
- --
- CREATE TABLE IF NOT EXISTS `kontostaende` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `zeit` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `kontostand` DECIMAL(8,3) NOT NULL,
- `kontostand_zukunft` DECIMAL(8,3) NOT NULL,
- `konto` INT(11) NOT NULL,
- `protokoll` INT(11) NOT NULL,
- `bemerkung` text NOT NULL,
- `veraenderung` DECIMAL(8,3) NOT NULL,
- `deleted` tinyint(1) NOT NULL DEFAULT '0',
- `monat_jahr` INT(11) NOT NULL,
- `offen` tinyint(1) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `konto` (`konto`),
- KEY `protokoll` (`protokoll`),
- KEY `monat_jahr` (`monat_jahr`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
- --
- -- Daten für Tabelle `kontostaende`
- --
- INSERT INTO `kontostaende` (`id`, `zeit`, `kontostand`, `kontostand_zukunft`, `konto`, `protokoll`, `bemerkung`, `veraenderung`, `deleted`, `monat_jahr`, `offen`) VALUES
- (1, '2011-12-26 12:11:14', 0.000, 0.000, 1, 1, '', -50.000, 1, 122011, 0),
- (2, '2011-12-26 12:16:11', 0.000, 0.000, 34, 2, '', 200.000, 1, 122011, 0),
- (3, '2011-12-26 12:16:11', 0.000, 0.000, 1, 2, '', 200.000, 1, 122011, 0),
- (4, '2011-12-26 12:22:55', 0.000, 0.000, 1, 3, '', -205.000, 1, 122011, 0),
- (5, '2011-12-26 12:23:15', 0.000, 0.000, 1, 4, '', 205.000, 1, 122011, 0),
- (6, '2011-12-28 14:55:35', 205.000, 205.000, 4, 5, '', 205.000, 0, 122011, 0),
- (7, '2011-12-29 07:28:30', -28.000, -28.000, 1, 6, '', -28.000, 0, 122011, 0),
- (8, '2011-12-29 07:29:05', -45.000, -45.000, 1, 7, '', -17.000, 0, 122011, 0);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement