mirror of
https://gitlab.com/sfz.aalen/infra/fabaccess.git
synced 2025-03-12 23:11:58 +01:00
69c7933894
migrated to Postgres because of binary availability of postgres python client. Also implemented development compose file and refactored production python image
12 lines
354 B
SQL
12 lines
354 B
SQL
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');
|