Facebook
From Mammoth Coyote, 1 Year ago, written in SQL.
Embed
Download Paste or View Raw
Hits: 78
  1. INSERT INTO Veracity.dbo.BOQuery
  2. ( id,CampaignName, DialogCost, TemplateType, IsDeleted, DateCreated, CreateUser, DateModified, ModifyUser)
  3. VALUES( '80DC8A70-3887-4B6B-8EC4-D9D72B56F2C9','mobile temp', 100, 1, 0, '2022-07-28 13:45:18.937267 +00:00', 'q23AW+flJHNJ8FwBw/tL/g==', '', '');
  4.  
  5. INSERT INTO Veracity.dbo.BOQueryCriteria
  6. (Id, QueryId, CredentialDefinitionId, IsDeleted, DateCreated, CreateUser, DateModified, ModifyUser)
  7. 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';
  8.  
  9. INSERT INTO Veracity.dbo.Shoutback
  10. (Id, BoQueryId, IsDeleted, DateCreated, CreateUser, DateModified, ModifyUser, Icon, ShortDesc)
  11. VALUES('80DC8A70-3887-4B6B-8EC4-D9D72B56F2D1', '80DC8A70-3887-4B6B-8EC4-D9D72B56F2C9', 0, '', '', '', '', 'mobile', 'I want to renew my broadband contract');
  12.  
  13.  
  14. INSERT INTO Veracity.dbo.BOQuery
  15. ( id,CampaignName, DialogCost, TemplateType, IsDeleted, DateCreated, CreateUser, DateModified, ModifyUser)
  16. VALUES( '80DC8A70-3887-4B6B-8EC4-D9D72B56F2D2','food temp', 100, 1, 0, '2022-07-28 13:45:18.937267 +00:00', 'q23AW+flJHNJ8FwBw/tL/g==', '', '');
  17.  
  18. INSERT INTO Veracity.dbo.BOQueryCriteria
  19. (Id, QueryId, CredentialDefinitionId, IsDeleted, DateCreated, CreateUser, DateModified, ModifyUser)
  20. 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';
  21.  
  22. INSERT INTO Veracity.dbo.Shoutback
  23. (Id, BoQueryId, IsDeleted, DateCreated, CreateUser, DateModified, ModifyUser, Icon, ShortDesc)
  24. VALUES('80DC8A70-3887-4B6B-8EC4-D9D72B56F2D4', '80DC8A70-3887-4B6B-8EC4-D9D72B56F2D2', 0, '', '', '', '', 'cheeseburger', 'I’m feeling hungry');
  25.  
  26. INSERT INTO Veracity.dbo.BOQuery
  27. ( id,CampaignName, DialogCost, TemplateType, IsDeleted, DateCreated, CreateUser, DateModified, ModifyUser)
  28. VALUES( '80DC8A70-3887-4B6B-8EC4-D9D72B56F2D5','gambling temp', 100, 1, 0, '2022-07-28 13:45:18.937267 +00:00', 'q23AW+flJHNJ8FwBw/tL/g==', '', '');
  29.  
  30. INSERT INTO Veracity.dbo.BOQueryCriteria
  31. (Id, QueryId, CredentialDefinitionId, IsDeleted, DateCreated, CreateUser, DateModified, ModifyUser)
  32. 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';
  33.  
  34. INSERT INTO Veracity.dbo.Shoutback
  35. (Id, BoQueryId, IsDeleted, DateCreated, CreateUser, DateModified, ModifyUser, Icon, ShortDesc)
  36. VALUES('80DC8A70-3887-4B6B-8EC4-D9D72B56F2D7', '80DC8A70-3887-4B6B-8EC4-D9D72B56F2D5', 0, '', '', '', '', 'dice', 'I’m feeling lucky');