From fb631145f988b965def1261836278090c1c76dc6 Mon Sep 17 00:00:00 2001 From: Agnibho Mondal Date: Fri, 5 Jan 2024 03:16:51 +0530 Subject: [PATCH] Optional personnel id --- etc/schema.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/etc/schema.sql b/etc/schema.sql index 76f058e..bb1ad9f 100644 --- a/etc/schema.sql +++ b/etc/schema.sql @@ -72,7 +72,7 @@ CREATE TABLE transactions ( ); CREATE TABLE personnel ( sid INTEGER PRIMARY KEY AUTOINCREMENT, - cid TEXT UNIQUE, + cid TEXT, mid INTEGER, name TEXT, designation TEXT, -- 2.39.5