Mercurial > lada > lada-server

comparison db_schema/lada_data.sql @ 1289:788311087838

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fix consistence errors
author Michael Stanko <mstanko@bfs.de>
date Wed, 08 Feb 2017 17:46:45 +0100
parents 38059e566aba
children 512616ea3228
comparison
equal deleted inserted replaced
1288:d73cfd90ffc0 1289:788311087838
51 300 000007575949X f 11010 11010 121200008 2 1 1 D: 01 29 02 01 01 02 02 00 00 00 00 Apfel N42 2012-01-27 10:45:00+01 2012-01-27 10:45:00+01 \N 2012-02-01 09:14:31 \N \N \N \N 2012-01-01 00:00:00 2012-12-31 21:59:59 2016-03-17 09:19:04.94469 51 300 000007575949X f 11010 11010 121200008 2 1 1 D: 01 29 02 01 01 02 02 00 00 00 00 Apfel N42 2012-01-27 10:45:00+01 2012-01-27 10:45:00+01 \N 2012-02-01 09:14:31 \N \N \N \N 2012-01-01 00:00:00 2012-12-31 21:59:59 2016-03-17 09:19:04.94469
52 24 000007587691X f 06010 06010 120619004 2 1 1 D: 01 29 03 07 00 00 00 00 00 00 00 Süßkirsche N43 2012-06-18 11:30:00+02 \N \N 2012-06-20 08:56:20 \N 78 \N \N 2012-06-01 00:00:00 2012-06-30 21:59:59 2016-03-17 09:19:04.94469 52 24 000007587691X f 06010 06010 120619004 2 1 1 D: 01 29 03 07 00 00 00 00 00 00 00 Süßkirsche N43 2012-06-18 11:30:00+02 \N \N 2012-06-20 08:56:20 \N 78 \N \N 2012-06-01 00:00:00 2012-06-30 21:59:59 2016-03-17 09:19:04.94469
53 296 000007575943X f 11010 11010 121200002 2 1 1 D: 01 29 05 14 01 02 02 00 02 00 00 Rhabarber N4Z 2012-05-07 10:10:00+02 2012-05-07 10:10:00+02 \N 2012-05-15 08:27:55 \N \N \N \N 2012-08-06 00:00:00 2012-10-21 21:59:59 2016-03-17 09:19:04.94469 53 296 000007575943X f 11010 11010 121200002 2 1 1 D: 01 29 05 14 01 02 02 00 02 00 00 Rhabarber N4Z 2012-05-07 10:10:00+02 2012-05-07 10:10:00+02 \N 2012-05-15 08:27:55 \N \N \N \N 2012-08-06 00:00:00 2012-10-21 21:59:59 2016-03-17 09:19:04.94469
54 99 000007575726X f 11010 11010 123100001 2 1 3 D: 01 50 90 01 06 02 05 00 00 00 00 51 Tageskost einschl. flüssiger Bestandteile und Getränke N81 2012-01-03 23:00:00+01 2012-01-04 22:00:00+01 82800 2012-01-23 08:56:08 \N \N \N \N 2012-01-02 00:00:00 2012-01-15 21:59:59 2016-03-17 09:19:04.94469 54 99 000007575726X f 11010 11010 123100001 2 1 3 D: 01 50 90 01 06 02 05 00 00 00 00 51 Tageskost einschl. flüssiger Bestandteile und Getränke N81 2012-01-03 23:00:00+01 2012-01-04 22:00:00+01 82800 2012-01-23 08:56:08 \N \N \N \N 2012-01-02 00:00:00 2012-01-15 21:59:59 2016-03-17 09:19:04.94469
55 194 000007575847X f 11010 11010 125500001 2 1 1 D: 01 59 01 01 05 02 03 03 01 01 00 Rohwasser aus Grundwasser nicht aufbereitet G51 2012-03-02 12:10:00+01 2012-03-02 12:10:00+01 \N 2012-03-22 08:12:08 \N \N \N \N 2012-01-09 00:00:00 2012-04-01 21:59:59 2016-03-17 09:19:04.94469 55 194 000007575847X f 11010 11010 125500001 2 1 1 D: 01 59 01 01 05 02 03 03 01 01 00 Rohwasser aus Grundwasser nicht aufbereitet G51 2012-03-02 12:10:00+01 2012-03-02 12:10:00+01 \N 2012-03-22 08:12:08 \N \N \N \N 2012-01-09 00:00:00 2012-04-01 21:59:59 2016-03-17 09:19:04.94469
56 3 000007581040X f 06010 06010 120515001 2 1 1 D: 01 59 03 01 01 02 05 01 02 00 00 Trinkwasser Zentralversorgung Grundwasser aufbereitet N71 2012-05-10 11:00:00+02 \N \N 2012-05-30 13:21:12 \N 716 \N \N 2012-05-07 00:00:00 2012-05-13 21:59:59 2016-03-17 09:19:04.94469 56 3 000007581040X f 06010 06010 120515001 2 1 1 D: 01 59 03 01 01 02 05 01 02 00 00 Trinkwasser Zentralversorgung Grundwasser aufbereitet N71 2012-05-10 11:00:00+02 \N \N 2012-05-30 13:21:12 \N 714 \N \N 2012-05-07 00:00:00 2012-05-13 21:59:59 2016-03-17 09:19:04.94469
57 1 000007581034X f 06010 06010 120510002 2 1 1 D: 01 59 04 01 00 05 05 01 02 00 00 Trinkwasser Zentralversorgung Oberflächenwasser aufbereitet N72 2012-05-08 11:00:00+02 \N \N 2012-06-13 08:51:46 \N 726 \N \N 2012-05-07 00:00:00 2012-05-13 21:59:59 2016-03-17 09:19:04.94469 57 1 000007581034X f 06010 06010 120510002 2 1 1 D: 01 59 04 01 00 05 05 01 02 00 00 Trinkwasser Zentralversorgung Oberflächenwasser aufbereitet N72 2012-05-08 11:00:00+02 \N \N 2012-06-13 08:51:46 \N 726 \N \N 2012-05-07 00:00:00 2012-05-13 21:59:59 2016-03-17 09:19:04.94469
58 31 000007578204X f 06010 06010 120210003 2 1 1 D: 01 59 05 01 05 05 05 01 02 00 00 Trinkwasser aus Mischwasser Zentralversorgung aufbereitet N73 2012-02-07 23:00:00+01 \N \N 2012-03-02 12:40:21 \N 724 \N \N 2012-02-06 00:00:00 2012-02-12 21:59:59 2016-03-17 09:19:04.94469 58 31 000007578204X f 06010 06010 120210003 2 1 1 D: 01 59 05 01 05 05 05 01 02 00 00 Trinkwasser aus Mischwasser Zentralversorgung aufbereitet N73 2012-02-07 23:00:00+01 \N \N 2012-03-02 12:40:21 \N 724 \N \N 2012-02-06 00:00:00 2012-02-12 21:59:59 2016-03-17 09:19:04.94469
59 84 000007578312X f 06010 06010 120404004 2 1 1 D: 04 01 98 01 00 00 23 07 00 72 03 Unbearbeiteter Boden B33 2012-04-02 12:30:00+02 \N \N 2012-04-23 12:32:56 \N 60 \N \N 2012-04-02 00:00:00 2012-04-08 21:59:59 2016-03-17 09:19:04.94469 59 84 000007578312X f 06010 06010 120404004 2 1 1 D: 04 01 98 01 00 00 23 07 00 72 03 Unbearbeiteter Boden B33 2012-04-02 12:30:00+02 \N \N 2012-04-23 12:32:56 \N 60 \N \N 2012-04-02 00:00:00 2012-04-08 21:59:59 2016-03-17 09:19:04.94469
60 76 000007578301X f 06010 06010 120326001 2 1 1 D: 04 01 42 28 00 00 10 08 00 31 03 Unbearbeiteter Boden B31 2012-03-26 09:00:00+02 \N \N 2012-04-18 11:47:05 \N 813 \N \N 2012-04-02 00:00:00 2012-04-08 21:59:59 2016-03-17 09:19:04.94469 60 76 000007578301X f 06010 06010 120326001 2 1 1 D: 04 01 42 28 00 00 10 08 00 31 03 Unbearbeiteter Boden B31 2012-03-26 09:00:00+02 \N \N 2012-04-18 11:47:05 \N 813 \N \N 2012-04-02 00:00:00 2012-04-08 21:59:59 2016-03-17 09:19:04.94469
61 88 000007578316X f 06010 06010 120326002 2 1 1 D: 04 01 24 84 00 00 60 15 00 31 07 Unbearbeiteter Boden B34 2012-03-26 10:40:00+02 \N \N 2012-04-18 11:47:21 \N 813 \N \N 2012-04-02 00:00:00 2012-04-08 21:59:59 2016-03-17 09:19:04.94469 61 88 000007578316X f 06010 06010 120326002 2 1 1 D: 04 01 24 84 00 00 60 15 00 31 07 Unbearbeiteter Boden B34 2012-03-26 10:40:00+02 \N \N 2012-04-18 11:47:21 \N 813 \N \N 2012-04-02 00:00:00 2012-04-08 21:59:59 2016-03-17 09:19:04.94469
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)