michi/BDE
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Files
master
BDE/initdata/dblayout_sqlite.sql

344 lines
12 KiB
SQL
Raw Permalink Blame History

-- sqldum : sqlite
--
-- Database : storage
-- ------------------------------------------------------
-- Server version 4.0.24_Debian-10sarge1-log
--
-- Table structure for table bde
--
CREATE TABLE bde (
dmc char(25) UNIQUE,
startts timestamp(14) NOT NULL default '',
endts timestamp(14) NOT NULL default '',
ladungstraeger char(2) NOT NULL default '0',
seriennr char(25) NOT NULL default '',
variante char(25) NOT NULL default '',
pruefzelle1 char(25) NOT NULL default 'n.Durchlaufen',
putzzelle char(25) NOT NULL default 'n.Durchlaufen',
chiron char(25) NOT NULL default 'n.Durchlaufen',
blindniet char(25) NOT NULL default 'n.Durchlaufen',
bajonettclip char(25) NOT NULL default 'n.Durchlaufen',
cclip char(25) NOT NULL default 'n.Durchlaufen',
masseblech char(25) NOT NULL default 'n.Durchlaufen',
pruefzelle2 char(25) NOT NULL default 'n.Durchlaufen',
nacharbeit char(25) NOT NULL default 'n.Durchlaufen',
pruefzelle3 char(25) NOT NULL default 'n.Durchlaufen',
gesamtstatus char(25) NOT NULL default 'n.Durchlaufen',
anlage char(25) NOT NULL default 'Anlage',
userid INTEGER NOT NULL default 0,
csv integer NOT NULL default 0
);
alter table bde add anlage char(25) NOT NULL default 'Anlage';
alter table bde add userid INTEGER NOT NULL default 0;
CREATE TABLE blindniet (
dmc char(25) UNIQUE,
startts timestamp(14) NOT NULL,
endts timestamp(14) NOT NULL,
DGBM8status01 char(25) NOT NULL default '',
DGBM8status02 char(25) NOT NULL default '',
DGBM8status03 char(25) NOT NULL default '',
DGBM8status04 char(25) NOT NULL default '',
NietM8status01 char(25) NOT NULL default '',
NietM8status02 char(25) NOT NULL default '',
NietM6status01 char(25) NOT NULL default '',
NietM6status02 char(25) NOT NULL default '',
NietM6status03 char(25) NOT NULL default '',
NietM6status04 char(25) NOT NULL default '',
NietM6status05 char(25) NOT NULL default '',
DGBM8M01 INTEGER NOT NULL default '0',
DGBM8D01 INTEGER NOT NULL default '0',
DGBM8W01 INTEGER NOT NULL default '0',
DGBM8T01 INTEGER NOT NULL default '0',
DGBM8M02 INTEGER NOT NULL default '0',
DGBM8D02 INTEGER NOT NULL default '0',
DGBM8W02 INTEGER NOT NULL default '0',
DGBM8T02 INTEGER NOT NULL default '0',
DGBM8M03 INTEGER NOT NULL default '0',
DGBM8D03 INTEGER NOT NULL default '0',
DGBM8W03 INTEGER NOT NULL default '0',
DGBM8T03 INTEGER NOT NULL default '0',
DGBM8M04 INTEGER NOT NULL default '0',
DGBM8D04 INTEGER NOT NULL default '0',
DGBM8W04 INTEGER NOT NULL default '0',
DGBM8T04 INTEGER NOT NULL default '0',
NietM8F01 INTEGER NOT NULL default '0',
NietM8S01 INTEGER NOT NULL default '0',
NietM8F02 INTEGER NOT NULL default '0',
NietM8S02 INTEGER NOT NULL default '0',
NietM6F01 INTEGER NOT NULL default '0',
NietM6S01 INTEGER NOT NULL default '0',
NietM6F02 INTEGER NOT NULL default '0',
NietM6S02 INTEGER NOT NULL default '0',
NietM6F03 INTEGER NOT NULL default '0',
NietM6S03 INTEGER NOT NULL default '0',
NietM6F04 INTEGER NOT NULL default '0',
NietM6S04 INTEGER NOT NULL default '0',
NietM6F05 INTEGER NOT NULL default '0',
NietM6S05 INTEGER NOT NULL default '0'
);
CREATE TABLE bajonettclip (
dmc char(25) UNIQUE,
startts timestamp(14) NOT NULL,
endts timestamp(14) NOT NULL,
aufnahme INTEGER NOT NULL default '0',
bajostatus01 char(25) NOT NULL default '',
bajostatus02 char(25) NOT NULL default '',
bajostatus03 char(25) NOT NULL default '',
bajostatus04 char(25) NOT NULL default ''
);
CREATE TABLE cclip (
dmc char(25) UNIQUE,
startts timestamp(14) NOT NULL,
endts timestamp(14) NOT NULL,
aufnahme INTEGER NOT NULL default '0',
clipstatus01 char(25) NOT NULL default '',
clipstatus02 char(25) NOT NULL default '',
clipstatus03 char(25) NOT NULL default '',
clipstatus04 char(25) NOT NULL default '',
clipstatus05 char(25) NOT NULL default '',
clipstatus06 char(25) NOT NULL default '',
clipstatus07 char(25) NOT NULL default '',
clipstatus08 char(25) NOT NULL default '',
clipstatus09 char(25) NOT NULL default '',
clipstatus10 char(25) NOT NULL default '',
clipstatus11 char(25) NOT NULL default '',
clipstatus12 char(25) NOT NULL default '',
clipstatus13 char(25) NOT NULL default '',
clipstatus14 char(25) NOT NULL default '',
clipstatus15 char(25) NOT NULL default '',
clipstatus16 char(25) NOT NULL default '',
clipstatus17 char(25) NOT NULL default '',
clipstatus18 char(25) NOT NULL default ''
);
CREATE TABLE putzzelle (
dmc char(25) UNIQUE,
startts timestamp(14) NOT NULL,
endts timestamp(14) NOT NULL,
aufnahme INTEGER NOT NULL default '0'
);
CREATE TABLE chiron (
dmc char(25) UNIQUE,
startts timestamp(14) NOT NULL,
endts timestamp(14) NOT NULL,
chiron INTEGER NOT NULL default '0'
);
CREATE TABLE masseblech (
dmc char(25) UNIQUE,
startts timestamp(14) NOT NULL,
endts timestamp(14) NOT NULL,
ausgleichselement char(25) NOT NULL default '',
schallisolierung char(25) NOT NULL default '',
masseblech char(25) NOT NULL default '',
blindniet char(25) NOT NULL default '',
kombimutter char(25) NOT NULL default '',
fniet INTEGER NOT NULL default '0',
sniet INTEGER NOT NULL default '0',
mmutter INTEGER NOT NULL default '0',
dmutter INTEGER NOT NULL default '0',
wmutter INTEGER NOT NULL default '0',
tmutter INTEGER NOT NULL default '0'
);
CREATE TABLE pruefzelle1 (
dmc char(25) UNIQUE,
startts timestamp(14) NOT NULL,
endts timestamp(14) NOT NULL,
pp01 char(25) NOT NULL default '',
pp02 char(25) NOT NULL default '',
pp03 char(25) NOT NULL default '',
pp04 char(25) NOT NULL default '',
pp05 char(25) NOT NULL default '',
pp06 char(25) NOT NULL default '',
pp07 char(25) NOT NULL default '',
pp08 char(25) NOT NULL default '',
pp09 char(25) NOT NULL default '',
pp10 char(25) NOT NULL default '',
pp11 char(25) NOT NULL default '',
pp12 char(25) NOT NULL default '',
pp13 char(25) NOT NULL default '',
pp14 char(25) NOT NULL default '',
pp15 char(25) NOT NULL default '',
pp16 char(25) NOT NULL default '',
pp17 char(25) NOT NULL default '',
pp18 char(25) NOT NULL default '',
pp19 char(25) NOT NULL default '',
pp20 char(25) NOT NULL default '',
pp21 char(25) NOT NULL default '',
pp22 char(25) NOT NULL default '',
pp23 char(25) NOT NULL default '',
pp24 char(25) NOT NULL default '',
pp25 char(25) NOT NULL default '',
pp26 char(25) NOT NULL default '',
pp27 char(25) NOT NULL default '',
pp28 char(25) NOT NULL default '',
pp29 char(25) NOT NULL default '',
pp30 char(25) NOT NULL default '',
pp31 char(25) NOT NULL default '',
pp32 char(25) NOT NULL default '',
pp33 char(25) NOT NULL default '',
pp34 char(25) NOT NULL default '',
pp35 char(25) NOT NULL default '',
pp36 char(25) NOT NULL default '',
pp37 char(25) NOT NULL default '',
pp38 char(25) NOT NULL default '',
pp39 char(25) NOT NULL default '',
pp40 char(25) NOT NULL default ''
);
CREATE TABLE pruefzelle2 (
dmc char(25) UNIQUE,
startts timestamp(14) NOT NULL,
endts timestamp(14) NOT NULL,
pp01 char(25) NOT NULL default '',
pp02 char(25) NOT NULL default '',
pp03 char(25) NOT NULL default '',
pp04 char(25) NOT NULL default '',
pp05 char(25) NOT NULL default '',
pp06 char(25) NOT NULL default '',
pp07 char(25) NOT NULL default '',
pp08 char(25) NOT NULL default '',
pp09 char(25) NOT NULL default '',
pp10 char(25) NOT NULL default '',
pp11 char(25) NOT NULL default '',
pp12 char(25) NOT NULL default '',
pp13 char(25) NOT NULL default '',
pp14 char(25) NOT NULL default '',
pp15 char(25) NOT NULL default '',
pp16 char(25) NOT NULL default '',
pp17 char(25) NOT NULL default '',
pp18 char(25) NOT NULL default '',
pp19 char(25) NOT NULL default '',
pp20 char(25) NOT NULL default '',
pp21 char(25) NOT NULL default '',
pp22 char(25) NOT NULL default '',
pp23 char(25) NOT NULL default '',
pp24 char(25) NOT NULL default '',
pp25 char(25) NOT NULL default '',
pp26 char(25) NOT NULL default '',
pp27 char(25) NOT NULL default '',
pp28 char(25) NOT NULL default '',
pp29 char(25) NOT NULL default '',
pp30 char(25) NOT NULL default '',
pp31 char(25) NOT NULL default '',
pp32 char(25) NOT NULL default '',
pp33 char(25) NOT NULL default '',
pp34 char(25) NOT NULL default '',
pp35 char(25) NOT NULL default '',
pp36 char(25) NOT NULL default '',
pp37 char(25) NOT NULL default '',
pp38 char(25) NOT NULL default '',
pp39 char(25) NOT NULL default '',
pp40 char(25) NOT NULL default '',
pp41 char(25) NOT NULL default ''
);
CREATE TABLE limits (
id INTEGER PRIMARY KEY,
parameter char(25) NOT NULL default '',
fromts timestamp(14) NOT NULL,
tillts timestamp(14) ,
valmin INTEGER NOT NULL default '0',
valmax INTEGER NOT NULL default '0',
changed char(25) NOT NULL default ''
);
CREATE TABLE blindnietm6 (
dmc char(25),
nr INTEGER NOT NULL default '1',
ts timestamp(14) NOT NULL,
status char(25) NOT NULL default '',
F INTEGER NOT NULL default '0',
S INTEGER NOT NULL default '0'
);
CREATE TABLE blindnietm8 (
dmc char(25),
nr INTEGER NOT NULL default '1',
ts timestamp(14) NOT NULL,
status char(25) NOT NULL default '',
F INTEGER NOT NULL default '0',
S INTEGER NOT NULL default '0'
);
CREATE TABLE blindnietdgb (
dmc char(25),
nr INTEGER NOT NULL default '1',
ts timestamp(14) NOT NULL,
status char(25) NOT NULL default '',
M INTEGER NOT NULL default '0',
D INTEGER NOT NULL default '0',
W INTEGER NOT NULL default '0',
T INTEGER NOT NULL default '0'
);
CREATE TABLE locked (
dmc char(25),
rohteilnr INTEGER NOT NULL default '1',
aenderungsidx INTEGER NOT NULL default '1',
sperrts timestamp(14) NOT NULL,
sperrnr INTEGER NOT NULL default '0',
quelle char(25) NOT NULL default ''
);
CREATE TABLE pruefzelle3 (
dmc char(25) UNIQUE,
endts timestamp(14) NOT NULL,
anzahl INTEGER NOT NULL default '1',
pp01 char(25) NOT NULL default '',
pp02 char(25) NOT NULL default '',
pp03 char(25) NOT NULL default '',
pp04 char(25) NOT NULL default '',
pp05 char(25) NOT NULL default '',
pp06 char(25) NOT NULL default '',
pp07 char(25) NOT NULL default '',
pp08 char(25) NOT NULL default '',
pp09 char(25) NOT NULL default '',
pp10 char(25) NOT NULL default '',
pp11 char(25) NOT NULL default '',
pp12 char(25) NOT NULL default '',
pp13 char(25) NOT NULL default '',
pp14 char(25) NOT NULL default '',
pp15 char(25) NOT NULL default '',
pp16 char(25) NOT NULL default '',
pp17 char(25) NOT NULL default '',
pp18 char(25) NOT NULL default '',
pp19 char(25) NOT NULL default '',
pp20 char(25) NOT NULL default '',
pp21 char(25) NOT NULL default '',
pp22 char(25) NOT NULL default '',
pp23 char(25) NOT NULL default '',
pp24 char(25) NOT NULL default '',
pp25 char(25) NOT NULL default '',
pp26 char(25) NOT NULL default '',
pp27 char(25) NOT NULL default '',
pp28 char(25) NOT NULL default '',
pp29 char(25) NOT NULL default '',
pp30 char(25) NOT NULL default '',
pp31 char(25) NOT NULL default '',
pp32 char(25) NOT NULL default '',
pp33 char(25) NOT NULL default '',
pp34 char(25) NOT NULL default '',
pp35 char(25) NOT NULL default '',
pp36 char(25) NOT NULL default '',
pp37 char(25) NOT NULL default '',
pp38 char(25) NOT NULL default '',
pp39 char(25) NOT NULL default '',
pp40 char(25) NOT NULL default '',
pp41 char(25) NOT NULL default '',
pp42 char(25) NOT NULL default ''
);
Reference in New Issue View Git Blame Copy Permalink