mirror of
https://gitlab.com/sfz.aalen/infra/fabaccess.git
synced 2025-03-12 23:11:58 +01:00
12 lines
354 B
MySQL
12 lines
354 B
MySQL
|
CREATE TABLE ReaderPlug(
|
||
|
|
ReaderID INT NOT NULL,
|
||
|
|
PlugName VARCHAR(255) NOT NULL,
|
||
|
|
PermissionPath VARCHAR(255) NOT NULL,
|
||
|
|
Status BOOLEAN NOT NULL,
|
||
|
|
LastUser VARCHAR(255) NOT NULL
|
||
|
|
);
|
||
|
|
|
||
|
|
INSERT INTO ReaderPlug(
|
||
|
|
ReaderID, PlugName, PermissionPath, Status, LastUser
|
||
|
|
) VALUES (1, 'lasercutter', 'sfz.lasercutter.trotec', false, 'luca.lutz');
|