INSERT INTO Veracity.dbo.BOQuery
( id,CampaignName, DialogCost, TemplateType, IsDeleted, DateCreated, CreateUser, DateModified, ModifyUser)
VALUES( '80DC8A70-3887-4B6B-8EC4-D9D72B56F2C9','mobile temp', 100, 1, 0, '2022-07-28 13:45:18.937267 +00:00', 'q23AW+flJHNJ8FwBw/tL/g==', '', '');

INSERT INTO Veracity.dbo.BOQueryCriteria
(Id, QueryId, CredentialDefinitionId, IsDeleted, DateCreated, CreateUser, DateModified, ModifyUser)
Select '80DC8A70-3887-4B6B-8EC4-D9D72B56A2D3', '80DC8A70-3887-4B6B-8EC4-D9D72B56F2C9', Id, 0, '2022-07-28 13:45:18.937267 +00:00', 'q23AW+flJHNJ8FwBw/tL/g==', '', ''  FROM Veracity.dbo.CredentialDefinition  WHERE name='Mobile OS';

INSERT INTO Veracity.dbo.Shoutback
(Id, BoQueryId, IsDeleted, DateCreated, CreateUser, DateModified, ModifyUser, Icon, ShortDesc)
VALUES('80DC8A70-3887-4B6B-8EC4-D9D72B56F2D1', '80DC8A70-3887-4B6B-8EC4-D9D72B56F2C9', 0, '', '', '', '', 'mobile', 'I want to renew my broadband contract');


INSERT INTO Veracity.dbo.BOQuery
( id,CampaignName, DialogCost, TemplateType, IsDeleted, DateCreated, CreateUser, DateModified, ModifyUser)
VALUES( '80DC8A70-3887-4B6B-8EC4-D9D72B56F2D2','food temp', 100, 1, 0, '2022-07-28 13:45:18.937267 +00:00', 'q23AW+flJHNJ8FwBw/tL/g==', '', '');

INSERT INTO Veracity.dbo.BOQueryCriteria
(Id, QueryId, CredentialDefinitionId, IsDeleted, DateCreated, CreateUser, DateModified, ModifyUser)
Select '80DC8A70-3887-4B6B-8EC4-D9D72B56F2D3', '80DC8A70-3887-4B6B-8EC4-D9D72B56F2D2', Id, 0, '2022-07-28 13:45:18.937267 +00:00', 'q23AW+flJHNJ8FwBw/tL/g==', '', ''  FROM Veracity.dbo.CredentialDefinition  WHERE name='Food&Drink';

INSERT INTO Veracity.dbo.Shoutback
(Id, BoQueryId, IsDeleted, DateCreated, CreateUser, DateModified, ModifyUser, Icon, ShortDesc)
VALUES('80DC8A70-3887-4B6B-8EC4-D9D72B56F2D4', '80DC8A70-3887-4B6B-8EC4-D9D72B56F2D2', 0, '', '', '', '', 'cheeseburger', 'I’m feeling hungry');

INSERT INTO Veracity.dbo.BOQuery
( id,CampaignName, DialogCost, TemplateType, IsDeleted, DateCreated, CreateUser, DateModified, ModifyUser)
VALUES( '80DC8A70-3887-4B6B-8EC4-D9D72B56F2D5','gambling temp', 100, 1, 0, '2022-07-28 13:45:18.937267 +00:00', 'q23AW+flJHNJ8FwBw/tL/g==', '', '');

INSERT INTO Veracity.dbo.BOQueryCriteria
(Id, QueryId, CredentialDefinitionId, IsDeleted, DateCreated, CreateUser, DateModified, ModifyUser)
Select '80DC8A70-3887-4B6B-8EC4-D9D72B56F2D6', '80DC8A70-3887-4B6B-8EC4-D9D72B56F2D5', Id, 0, '2022-07-28 13:45:18.937267 +00:00', 'q23AW+flJHNJ8FwBw/tL/g==', '', '' FROM Veracity.dbo.CredentialDefinition  WHERE name='Gambling';

INSERT INTO Veracity.dbo.Shoutback
(Id, BoQueryId, IsDeleted, DateCreated, CreateUser, DateModified, ModifyUser, Icon, ShortDesc)
VALUES('80DC8A70-3887-4B6B-8EC4-D9D72B56F2D7', '80DC8A70-3887-4B6B-8EC4-D9D72B56F2D5', 0, '', '', '', '', 'dice', 'I’m feeling lucky');