git.rot13.org Git - vrDialog/blob - db3/vrDIALOG.sql

   1 -- ----------------------------------------------------------
   2 -- MDB Tools - A library for reading MS Access database files
   3 -- Copyright (C) 2000-2011 Brian Bruns and others.
   4 -- Files in libmdb are licensed under LGPL and the utilities under
   5 -- the GPL, see COPYING.LIB and COPYING files respectively.
   6 -- Check out http://mdbtools.sourceforge.net
   7 -- ----------------------------------------------------------
   8
   9 -- That file uses encoding UTF-8
  10
  11 CREATE TABLE [ComuInfos]
  12  (
  13         [Id]                    Integer,
  14         [Symbolname]                    Text (60),
  15         [Adresse]                       Long Integer,
  16         [TypId]                 Long Integer,
  17         [TexteId]                       Long Integer
  18 );
  19
  20 CREATE TABLE [DataTyps]
  21  (
  22         [TypeId]                        Long Integer,
  23         [TypeName]                      Text (510)
  24 );
  25
  26 CREATE TABLE [DiagnoseDaten]
  27  (
  28         [Id]                    Integer,
  29         [x0136]                 Boolean NOT NULL,
  30         [x0142]                 Boolean NOT NULL,
  31         [x0144]                 Boolean NOT NULL,
  32         [x0147]                 Boolean NOT NULL,
  33         [x0151]                 Boolean NOT NULL,
  34         [x0152]                 Boolean NOT NULL,
  35         [x0153]                 Boolean NOT NULL,
  36         [x0158]                 Boolean NOT NULL,
  37         [x0160]                 Boolean NOT NULL,
  38         [x0161]                 Boolean NOT NULL,
  39         [UserLevel]                     Byte
  40 );
  41
  42 CREATE TABLE [EinstellDaten]
  43  (
  44         [Id]                    Integer,
  45         [x0136]                 Boolean NOT NULL,
  46         [x0142]                 Boolean NOT NULL,
  47         [x0144]                 Boolean NOT NULL,
  48         [x0147]                 Boolean NOT NULL,
  49         [x0151]                 Boolean NOT NULL,
  50         [x0152]                 Boolean NOT NULL,
  51         [x0153]                 Boolean NOT NULL,
  52         [x0158]                 Boolean NOT NULL,
  53         [x0160]                 Boolean NOT NULL,
  54         [MinValue]                      Double,
  55         [MaxValue]                      Double,
  56         [Steps]                 Long Integer,
  57         [SubSteps]                      Long Integer,
  58         [x0161]                 Boolean NOT NULL,
  59         [DigitalMin]                    Long Integer,
  60         [DigitalMax]                    Long Integer,
  61         [UserLevel]                     Byte,
  62         [VisibleType]                   Byte
  63 );
  64
  65 CREATE TABLE [geraete]
  66  (
  67         [Id]                    Long Integer,
  68         [SpNr]                  Long Integer,
  69         [Name]                  Text (40)
  70 );
  71
  72 CREATE TABLE [MitschnittDaten]
  73  (
  74         [Id]                    Long Integer,
  75         [xMin]                  Double,
  76         [xMax]                  Double,
  77         [Userlevel]                     Byte,
  78         [x0136]                 Byte,
  79         [x0142]                 Byte,
  80         [x0144]                 Byte,
  81         [x0147]                 Byte,
  82         [x0151]                 Byte,
  83         [x0152]                 Byte,
  84         [x0153]                 Byte,
  85         [x0158]                 Byte,
  86         [x0160]                 Byte,
  87         [x0161]                 Byte,
  88         [AOrder]                        Integer
  89 );
  90
  91 CREATE TABLE [PageEnable]
  92  (
  93         [PageId]                        Integer,
  94         [UserLevel]                     Integer,
  95         [Info]                  Text (80)
  96 );
  97
  98 CREATE TABLE [ReglerDaten]
  99  (
 100         [Id]                    Long Integer,
 101         [Name]                  Text (200),
 102         [Address]                       Long Integer,
 103         [xCount]                        Long Integer,
 104         [CbId]                  Long Integer,
 105         [Adjust]                        Boolean NOT NULL,
 106         [Service]                       Boolean NOT NULL,
 107         [Periods]                       Boolean NOT NULL,
 108         [SaveAuto]                      Boolean NOT NULL,
 109         [SaveManual]                    Boolean NOT NULL,
 110         [AdrType]                       Byte,
 111         [TypeId]                        Long Integer
 112 );
 113
 114 CREATE TABLE [SymbolHints]
 115  (
 116         [Id]                    Integer,
 117         [Texte]                 Text (510),
 118         [TexteDE]                       Text (510),
 119         [TexteEN]                       Text (510),
 120         [TextePL]                       Text (510),
 121         [TexteNL]                       Text (510),
 122         [TexteIT]                       Text (510),
 123         [TexteCS]                       Text (510),
 124         [TexteES]                       Text (510),
 125         [TexteTR]                       Text (510),
 126         [TexteRO]                       Text (510),
 127         [TexteRU]                       Text (510),
 128         [TexteDA]                       Text (510),
 129         [TexteHR]                       Text (510),
 130         [TexteEL]                       Text (510),
 131         [TexteFR]                       Text (510),
 132         [TexteHU]                       Text (510)
 133 );
 134
 135 CREATE TABLE [SymbolNames]
 136  (
 137         [Id]                    Long Integer,
 138         [Texte]                 Text (510),
 139         [TexteDE]                       Text (510),
 140         [TexteEN]                       Text (510),
 141         [TextePL]                       Text (510),
 142         [TexteNL]                       Text (510),
 143         [TexteIT]                       Text (510),
 144         [TexteCS]                       Text (510),
 145         [TexteES]                       Text (510),
 146         [TexteTR]                       Text (510),
 147         [TexteRO]                       Text (510),
 148         [TexteRU]                       Text (510),
 149         [TexteDA]                       Text (510),
 150         [TexteHR]                       Text (510),
 151         [TexteEL]                       Text (510),
 152         [TexteFR]                       Text (510),
 153         [TexteHU]                       Text (510)
 154 );
 155
 156 CREATE TABLE [UnitNames]
 157  (
 158         [Id]                    Integer,
 159         [Texte]                 Text (510),
 160         [TexteDE]                       Text (510),
 161         [TexteEN]                       Text (510),
 162         [TextePL]                       Text (510),
 163         [TexteNL]                       Text (510),
 164         [TexteIT]                       Text (510),
 165         [TexteCS]                       Text (510),
 166         [TexteES]                       Text (510),
 167         [TexteTR]                       Text (510),
 168         [TexteRO]                       Text (510),
 169         [TexteRU]                       Text (510),
 170         [TexteDA]                       Text (510),
 171         [TexteHR]                       Text (510),
 172         [TexteEL]                       Text (510),
 173         [TexteFR]                       Text (510),
 174         [TexteHU]                       Text (510)
 175 );
 176
 177 CREATE TABLE [AdmUserLevel]
 178  (
 179         [Name]                  Text (510),
 180         [AId]                   Byte
 181 );
 182
 183 CREATE TABLE [AdmAddressType]
 184  (
 185         [AId]                   Byte,
 186         [AText]                 Text (100)
 187 );
 188
 189 CREATE TABLE [AdmVisType]
 190  (
 191         [AId]                   Byte,
 192         [Name]                  Text (510)
 193 );
 194
 195 CREATE TABLE [AdmLogType]
 196  (
 197         [AId]                   Byte,
 198         [AText]                 Text (100)
 199 );
 200
 201