273 lines
6.3 KiB
SQL
273 lines
6.3 KiB
SQL
-- sqldum : sqlite
|
|
--
|
|
-- Database : storage
|
|
-- ------------------------------------------------------
|
|
-- Server version 4.0.24_Debian-10sarge1-log
|
|
|
|
--
|
|
-- Table structure for table Physics
|
|
--
|
|
|
|
CREATE TABLE Physics (
|
|
k varchar(30) NOT NULL default '',
|
|
v varchar(255) default NULL
|
|
);
|
|
|
|
|
|
--
|
|
-- Table structure for Transportmartrix
|
|
--
|
|
CREATE TABLE Transportmatrix (
|
|
src varchar(4) NOT NULL,
|
|
dst varchar(4) NOT NULL,
|
|
rfz varchar (4) NOT NULL,
|
|
mode varchar (10) default '',
|
|
prio integer NOT NULL
|
|
);
|
|
|
|
--
|
|
-- Table structure for table Inqueue
|
|
--
|
|
|
|
CREATE TABLE Inqueue (
|
|
location varchar (4) NOT NULL default 'I001',
|
|
boxnr varchar(20) NOT NULL default '',
|
|
article varchar(20) NOT NULL default '',
|
|
gtin varchar(20) NOT NULL default '',
|
|
lotnr varchar(20) NOT NULL default '',
|
|
lotnr2 varchar(20) NOT NULL default '',
|
|
duedate varchar(20) NOT NULL default '',
|
|
pieces varchar(20) NOT NULL default '',
|
|
deststorage varchar(4) NOT NULL default '',
|
|
destination INTEGER NOT NULL default '0',
|
|
PRIMARY KEY (location, boxnr)
|
|
);
|
|
|
|
|
|
--
|
|
-- Table structure for table Storage
|
|
--
|
|
|
|
CREATE TABLE Storage (
|
|
id varchar (4) NOT NULL default '',
|
|
boxnr varchar(20) NOT NULL default '',
|
|
article varchar(20) NOT NULL default '',
|
|
lotnr varchar(20) NOT NULL default '',
|
|
lotnr2 varchar(20) NOT NULL default '',
|
|
duedate varchar(20) NOT NULL default '',
|
|
pieces INTEGER NOT NULL default '0',
|
|
x INTEGER NOT NULL default '0',
|
|
y INTEGER NOT NULL default '0',
|
|
z INTEGER NOT NULL default '0',
|
|
rfzts timestamp(14) NOT NULL,
|
|
PRIMARY KEY (id, boxnr)
|
|
);
|
|
|
|
CREATE UNIQUE INDEX Storage_xyz ON Storage (id, x, y, z);
|
|
|
|
|
|
--
|
|
-- Table structure for table Insertiontimestamps
|
|
--
|
|
CREATE TABLE Insertiontimestamps (
|
|
boxnr varchar(20) NOT NULL default '',
|
|
rfzts timestamp(14) NOT NULL,
|
|
PRIMARY KEY (boxnr)
|
|
);
|
|
|
|
--
|
|
-- Table structure for table Outqueue
|
|
--
|
|
|
|
CREATE TABLE Outqueue (
|
|
id varchar (4) NOT NULL default 'O001',
|
|
boxnr varchar(20) NOT NULL default '',
|
|
article varchar(20) NOT NULL default '',
|
|
lotnr varchar(20) NOT NULL default '',
|
|
lotnr2 varchar(20) NOT NULL default '',
|
|
duedate varchar(20) NOT NULL default '',
|
|
pieces varchar(20) NOT NULL default '',
|
|
x INTEGER NOT NULL default '0',
|
|
y INTEGER NOT NULL default '0',
|
|
z INTEGER NOT NULL default '0',
|
|
rfzts timestamp(14) NOT NULL,
|
|
PRIMARY KEY (id, boxnr)
|
|
);
|
|
|
|
|
|
--
|
|
-- Table structure for table Slotbase
|
|
--
|
|
|
|
CREATE TABLE Slotbase (
|
|
id varchar (4) NOT NULL default '',
|
|
x INTEGER NOT NULL default '0',
|
|
y INTEGER NOT NULL default '0',
|
|
article varchar(20) NOT NULL default '',
|
|
PRIMARY KEY (id, x, y)
|
|
);
|
|
|
|
--
|
|
-- Table structure for table Lockedslots
|
|
--
|
|
|
|
CREATE TABLE Lockedslots (
|
|
id INTEGER NOT NULL default '0',
|
|
x INTEGER NOT NULL default '0',
|
|
y INTEGER NOT NULL default '0',
|
|
reason varchar(255) NOT NULL default ''
|
|
);
|
|
|
|
CREATE UNIQUE INDEX Lockedslots_idcy ON Lockedslots (id, x, y);
|
|
|
|
--
|
|
-- Table structure for table Transports
|
|
--
|
|
|
|
CREATE TABLE Transports (
|
|
boxnr varchar(20) NOT NULL default '',
|
|
position varchar(6) NOT NULL default '',
|
|
src varchar(6) NOT NULL default '',
|
|
src_x varchar(2) NOT NULL default '',
|
|
src_y varchar(2) NOT NULL default '',
|
|
src_z varchar(2) NOT NULL default '',
|
|
dst varchar(6) NOT NULL default '',
|
|
dst_x varchar(2) NOT NULL default '',
|
|
dst_y varchar(2) NOT NULL default '',
|
|
dst_z varchar(2) NOT NULL default '',
|
|
state varchar(5) NOT NULL default '',
|
|
ts timestamp(14)
|
|
);
|
|
|
|
--
|
|
-- Table structure for Trace
|
|
--
|
|
|
|
CREATE TABLE Trace (
|
|
boxnr varchar(20) NOT NULL default '',
|
|
article varchar(20) NOT NULL default '',
|
|
lotnr varchar(20) NOT NULL default '',
|
|
lotnr2 varchar(20) NOT NULL default '',
|
|
pieces INTEGER NOT NULL default '0',
|
|
x INTEGER NOT NULL default '0',
|
|
y INTEGER NOT NULL default '0',
|
|
z INTEGER NOT NULL default '0',
|
|
rfzts timestamp(14) NOT NULL,
|
|
action varchar(20) NOT NULL default ''
|
|
);
|
|
|
|
--
|
|
-- Table structure for table Expressjobs
|
|
--
|
|
|
|
CREATE TABLE Expressjobs (
|
|
id INTEGER PRIMARY KEY,
|
|
source varchar(6) NOT NULL default '',
|
|
state varchar(5) NOT NULL default '',
|
|
customer varchar(20) NOT NULL default '',
|
|
packlist varchar(20) NOT NULL default '',
|
|
article varchar(20) NOT NULL default '',
|
|
boxes integer not NULL default '0',
|
|
boxes_delivered integer not NULL default '0',
|
|
created timestamp(14) NOT NULL,
|
|
info varchar(50) NOT NULL default ''
|
|
);
|
|
|
|
|
|
--
|
|
-- Table structure for Expresslog
|
|
--
|
|
|
|
CREATE TABLE Expresslog (
|
|
expressjob INTEGER NOT NULL,
|
|
boxnr varchar(20) NOT NULL default '',
|
|
lotnr varchar(20) NOT NULL default '',
|
|
lotnr2 varchar(20) NOT NULL default '',
|
|
pieces INTEGER NOT NULL default '0',
|
|
rfzts timestamp(14) NOT NULL
|
|
);
|
|
|
|
|
|
--
|
|
-- Table structure for table Reefeed
|
|
--
|
|
|
|
CREATE TABLE Refeed (
|
|
kistennummer varchar(20) NOT NULL default '',
|
|
artikelnummer varchar(20) NOT NULL default '',
|
|
charge varchar(20) NOT NULL default '',
|
|
gewicht decimal(10,0) NOT NULL default '0',
|
|
z INTEGER NOT NULL default '0',
|
|
reserved timestamp(14) NOT NULL,
|
|
PRIMARY KEY (kistennummer)
|
|
);
|
|
|
|
|
|
--
|
|
-- Compression Jobs
|
|
--
|
|
|
|
CREATE TABLE Compressionjobs (
|
|
id INTEGER PRIMARY KEY,
|
|
position varchar(6) NOT NULL default '',
|
|
state varchar(5) NOT NULL default '',
|
|
artikelnummer varchar(20) NOT NULL default '',
|
|
created timestamp(14) NOT NULL,
|
|
info varchar(50) NOT NULL default ''
|
|
);
|
|
|
|
|
|
--
|
|
-- Umlager Jobs Chaos
|
|
--
|
|
|
|
CREATE TABLE Umlagerchaosjobs (
|
|
id INTEGER PRIMARY KEY,
|
|
position varchar(6) NOT NULL default '',
|
|
state varchar(5) NOT NULL default '',
|
|
artikelnummer varchar(20) NOT NULL default '',
|
|
sourcex INTEGER NOT NULL default '0',
|
|
sourcey INTEGER NOT NULL default '0',
|
|
created timestamp(14) NOT NULL,
|
|
info varchar(50) NOT NULL default ''
|
|
);
|
|
|
|
|
|
|
|
--
|
|
-- Umlager Jobs ES
|
|
--
|
|
|
|
CREATE TABLE Umlageresjobs (
|
|
id INTEGER PRIMARY KEY,
|
|
position varchar(6) NOT NULL default '',
|
|
state varchar(5) NOT NULL default '',
|
|
artikelnummer varchar(20) NOT NULL default '',
|
|
sourcex INTEGER NOT NULL default '0',
|
|
sourcey INTEGER NOT NULL default '0',
|
|
created timestamp(14) NOT NULL,
|
|
info varchar(50) NOT NULL default ''
|
|
);
|
|
|
|
|
|
|
|
|
|
--
|
|
-- Umlager Jobs ES
|
|
--
|
|
|
|
CREATE TABLE singlemovejobs (
|
|
id INTEGER PRIMARY KEY,
|
|
position varchar(6) NOT NULL default '',
|
|
state varchar(5) NOT NULL default '',
|
|
artikelnummer varchar(20) NOT NULL default '',
|
|
src_id varchar (4) NOT NULL default '',
|
|
sourcex INTEGER NOT NULL default '0',
|
|
sourcey INTEGER NOT NULL default '0',
|
|
created timestamp(14) NOT NULL,
|
|
info varchar(50) NOT NULL default ''
|
|
);
|
|
|
|
|
|
|