server/sources/native.py
changeset 10208 249126034c0e
parent 10206 0ecd61f4bd37
child 10209 4c64a41c0a1d
--- a/server/sources/native.py	Fri Jan 16 11:17:53 2015 +0100
+++ b/server/sources/native.py	Fri Jan 16 12:43:32 2015 +0100
@@ -1387,10 +1387,9 @@
   eid INTEGER PRIMARY KEY NOT NULL,
   type VARCHAR(64) NOT NULL,
   asource VARCHAR(128) NOT NULL,
-  extid VARCHAR(256)
+  extid VARCHAR(256) UNIQUE
 );;
 CREATE INDEX entities_type_idx ON entities(type);;
-CREATE INDEX entities_extid_idx ON entities(extid);;
 
 CREATE TABLE transactions (
   tx_uuid CHAR(32) PRIMARY KEY NOT NULL,