CREATE COLLECTION "inventory" 
GO

INSERT INTO "inventory"("_id", "item", "qty")
  VALUES(1.0, 'abc123', 0.0)
GO
INSERT INTO "inventory"("_id", "item", "qty")
  VALUES(2.0, 'xyz123', 5.0)
GO
INSERT INTO "inventory"("_id", "item", "qty")
  VALUES(3.0, 'ijk123', 12.0)
GO
INSERT INTO "inventory"("_id", "item", "qty", "code", "tags")
  VALUES(OBJECTID('5234cc89687ea597eabee675'), 'Coffe cake in a set to be find', [ { "size" : 'S', "num" : 10.0, "color" : 'blue' }, { "size" : 'M', "num" : 45.0, "color" : 'blue' }, { "size" : 'L', "num" : 100.0, "color" : 'green' } ], 'xyz', [ 'school', 'book', 'bag', 'headphone', 'appliance' ])
GO
INSERT INTO "inventory"("_id", "qty", "code", "tags")
  VALUES(OBJECTID('5234cc8a687ea597eabee676'), [ { "size" : '6', "num" : 100.0, "color" : 'green' }, { "size" : '6', "num" : 50.0, "color" : 'blue' }, { "size" : '8', "num" : 100.0, "color" : 'brown' } ], 'abc', [ 'appliance', 'school', 'book' ])
GO
INSERT INTO "inventory"("_id", "qty", "code", "tags")
  VALUES(OBJECTID('5234ccb7687ea597eabee677'), [ { "size" : 'S', "num" : 10.0, "color" : 'blue' }, { "size" : 'M', "num" : 100.0, "color" : 'blue' }, { "size" : 'L', "num" : 100.0, "color" : 'green' } ], 'efg', [ 'school', 'book' ])
GO
INSERT INTO "inventory"("_id", "qty", "code", "tags")
  VALUES(OBJECTID('52350353b2eff1353b349de9'), [ { "size" : 'M', "num" : 100.0, "color" : 'green' } ], 'ijk', [ 'electronics', 'school' ])
GO
