From 4c1a5fdfe1fb99901a24bfdd9d5c42a6939e6dd8 Mon Sep 17 00:00:00 2001
From: Julien Dessaux
Date: Thu, 14 Sep 2023 00:02:51 +0200
Subject: [javascript] improved contract lib

---
 nodejs/database/000_init.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'nodejs/database/000_init.sql')

diff --git a/nodejs/database/000_init.sql b/nodejs/database/000_init.sql
index 9c06622..67967b6 100644
--- a/nodejs/database/000_init.sql
+++ b/nodejs/database/000_init.sql
@@ -14,3 +14,4 @@ CREATE TABLE contracts (
 	data TEXT NOT NULL
 );
 CREATE UNIQUE INDEX contracts_data_id ON contracts (json_extract(data, '$.id'));
+CREATE UNIQUE INDEX contracts_data_fulfilled ON contracts (json_extract(data, '$.fulfilled'));
-- 
cgit v1.2.3

