API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 24th, 2017
52
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.62 KB | None | 0 0
raw download clone embed print report
  1. CREATE TABLE `campaign_platform_characteristics` (
  2. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  3. `country_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
  4. `platform_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
  5. `name` varchar(125) NOT NULL DEFAULT '0',
  6. `description` varchar(255) DEFAULT NULL,
  7. `value` varchar(50) NOT NULL DEFAULT '0',
  8. `status` tinyint(2) NOT NULL DEFAULT '0',
  9. `created` datetime NOT NULL,
  10. `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  11. PRIMARY KEY (`id`),
  12. KEY `country_id` (`country_id`),
  13. KEY `name` (`name`),
  14. KEY `status` (`status`)
  15. ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT
  16.  
  17. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (7, 1, 'VOUCHER_GROUP_LIMIT', 'Voucher Limit RO', '1000', 1, '2015-06-02 17:49:30', '2017-03-17 12:03:01');
  18. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (8, 2, 'VOUCHER_GROUP_LIMIT', 'Voucher Limit BG', '1000', 1, '2015-06-02 17:49:30', '2017-03-17 12:03:01');
  19. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (9, 3, 'VOUCHER_GROUP_LIMIT', 'Voucher Limit HU', '150000', 1, '2015-06-02 17:49:30', '2017-03-17 12:03:01');
  20. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (10, 1, 'BOUGHT_CAMPAIGN_ID', 'Bought vouchers RO', '201', 1, '2015-05-20 11:30:58', '2017-03-17 12:03:01');
  21. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (11, 2, 'BOUGHT_CAMPAIGN_ID', 'Bought vouchers BG', '5825', 1, '2015-05-20 11:30:58', '2017-03-17 12:03:01');
  22. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (12, 3, 'BOUGHT_CAMPAIGN_ID', 'Bought vouchers HU', '5826', 1, '2015-05-20 11:30:58', '2017-03-17 12:03:01');
  23. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (13, 1, 'ADDITIONAL_VAT_RATE', 'Vat rates', '0,0.09,0.2,0.05', 1, '2015-08-11 11:21:31', '2017-03-17 12:03:01');
  24. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (14, 2, 'ADDITIONAL_VAT_RATE', 'Vat rates', '0.09,0.20', 1, '2015-08-11 11:21:31', '2017-03-17 12:03:01');
  25. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (15, 3, 'ADDITIONAL_VAT_RATE', 'Vat rates', '0.05,0.18,0.27', 1, '2015-08-11 11:21:31', '2017-03-17 12:03:01');
  26. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (16, 1, 'DEFAULT_VAT', 'RO VAT RATE', '0.20', 1, '2015-12-31 03:52:53', '2017-03-17 12:03:01');
  27. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (17, 2, 'DEFAULT_VAT', 'BG VAT RATE', '0.20', 1, '2013-06-13 11:48:00', '2017-03-17 12:03:01');
  28. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (18, 3, 'DEFAULT_VAT', 'HU VAT RATE', '0.27', 1, '2013-09-02 13:25:45', '2017-03-17 12:03:01');
  29. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (19, 1, 'CLAIMS_NOTIFICATION_VALUE', 'Claims voucher notification value RO', '2000', 1, '2016-01-21 14:54:07', '2017-03-17 12:03:01');
  30. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (20, 2, 'CLAIMS_NOTIFICATION_VALUE', 'Claims voucher notification value BG', '881.48', 1, '2016-01-21 14:54:44', '2017-03-17 12:03:01');
  31. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (21, 3, 'CLAIMS_NOTIFICATION_VALUE', 'Claims voucher notification value HU', '141457.33', 1, '2016-01-21 14:54:56', '2017-03-17 12:03:01');
  32. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (22, 1, 'CUSTOMER_LIMIT', 'Customer Limit RO', '1000', 1, '2016-02-04 14:16:53', '2017-03-17 12:03:01');
  33. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (23, 2, 'CUSTOMER_LIMIT', 'Customer Limit BG', '1000', 1, '2016-02-04 14:16:53', '2017-03-17 12:03:01');
  34. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (24, 3, 'CUSTOMER_LIMIT', 'Customer Limit HU', '150000', 1, '2016-02-04 14:16:53', '2017-03-17 12:03:01');
  35. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (25, 1, 'RCA_VOUCHER_VALUE', 'Voucher value for RCA referral', '15', 1, '2016-03-01 20:47:51', '2017-03-17 12:03:01');
  36. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (26, 1, 'RCA_VOUCHER_PERIOD', 'Number of valability months for RCA referral ', '6', 1, '2016-03-01 20:47:51', '2017-03-17 12:03:01');
  37. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (27, 1, 'PLATFORM_CURRENCY_CODE', 'Platform currency code eMAG RO', 'RON', 1, '2016-03-01 20:47:51', '2017-03-22 16:58:24');
  38. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (28, 2, 'PLATFORM_CURRENCY_CODE', 'Platform currency code eMAG BG', 'BGN', 1, '2016-03-01 20:47:51', '2017-03-22 16:58:33');
  39. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (29, 3, 'PLATFORM_CURRENCY_CODE', 'Platform currency code eMAG HU', 'HUF', 1, '2016-03-01 20:47:51', '2017-03-22 16:58:41');
  40. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (30, 0, 'RELEASE_VAT0_DATE', 'RELEASE_VAT0_DATE', '2016-05-31', 1, '2016-05-31 09:02:39', '2016-05-31 09:02:39');
  41. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (31, 1, 'OVERRIDE_MKTP_VAT', 'Override mktp vat rate', '1', 1, '2015-08-11 11:21:31', '2017-03-17 12:03:01');
  42. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (32, 3, 'OVERRIDE_MKTP_VAT', 'Override mktp vat rate', '1', 1, '2015-08-11 11:21:31', '2017-03-17 12:03:01');
  43. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (33, 2, 'OVERRIDE_MKTP_VAT', 'Override mktp vat rate', '1', 1, '2015-08-11 11:21:31', '2017-03-17 12:03:01');
  44. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (34, 1, 'VOUCHER_TYPE_9_VAT', 'Override default vat for bought vouchers', '0', 1, '2015-06-02 17:49:30', '2017-03-17 12:03:01');
  45. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (35, 2, 'VOUCHER_TYPE_9_VAT', 'Override default vat for bought vouchers', '0', 1, '2015-06-02 17:49:30', '2017-03-17 12:03:01');
  46. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (36, 3, 'VOUCHER_TYPE_9_VAT', 'Override default vat for bought vouchers', '0', 1, '2015-06-02 17:49:30', '2017-03-17 12:03:01');
  47. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (37, 9, 'DEFAULT_VAT', 'RO_FD VAT RATE ', '0.20', 1, '2015-12-31 03:52:53', '2017-03-22 17:47:20');
  48. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (38, 10, 'DEFAULT_VAT', 'BG_FD VAT RATE', '0.20', 1, '2013-06-13 11:48:00', '2017-03-22 17:50:43');
  49. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (39, 11, 'DEFAULT_VAT', 'HU_FD VAT RATE', '0.27', 1, '2013-09-02 13:25:45', '2017-03-22 17:50:54');
  50. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (40, 9, 'COUNTRY_CURRENCY_CODE', 'Country currency code RO', 'RON', 1, '2016-03-01 20:47:51', '2017-03-24 15:59:46');
  51. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (41, 10, 'COUNTRY_CURRENCY_CODE', 'Country currency code BG', 'BGN', 1, '2016-03-01 20:47:51', '2017-03-24 15:59:48');
  52. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (42, 11, 'COUNTRY_CURRENCY_CODE', 'Country currency code HU', 'HUF', 1, '2016-03-01 20:47:51', '2017-03-24 15:59:51');
  53. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (43, 9, 'CUSTOMER_LIMIT', 'Customer Limit RO_FD', '1000', 1, '2016-02-04 14:16:53', '2017-03-17 12:03:01');
  54. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (44, 10, 'CUSTOMER_LIMIT', 'Customer Limit BG_FD', '1000', 1, '2016-02-04 14:16:53', '2017-03-23 11:13:33');
  55. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (45, 11, 'CUSTOMER_LIMIT', 'Customer Limit HU_FD', '150000', 1, '2016-02-04 14:16:53', '2017-03-17 12:03:01');
  56. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (46, 9, 'CLAIMS_NOTIFICATION_VALUE', 'Claims voucher notification value RO_FD', '2000', 1, '2016-01-21 14:54:07', '2017-03-17 12:03:01');
  57. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (47, 10, 'CLAIMS_NOTIFICATION_VALUE', 'Claims voucher notification value BG_FD', '881.48', 1, '2016-01-21 14:54:44', '2017-03-23 11:14:53');
  58. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (48, 11, 'CLAIMS_NOTIFICATION_VALUE', 'Claims voucher notification value HU_FD', '141457.33', 1, '2016-01-21 14:54:56', '2017-03-23 11:15:01');
  59. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (49, 9, 'VOUCHER_GROUP_LIMIT', 'Voucher Limit RO_FD', '1000', 1, '2015-06-02 17:49:30', '2017-03-17 12:03:01');
  60. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (50, 10, 'VOUCHER_GROUP_LIMIT', 'Voucher Limit BG_FD', '1000', 1, '2015-06-02 17:49:30', '2017-03-17 12:03:01');
  61. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (51, 11, 'VOUCHER_GROUP_LIMIT', 'Voucher Limit HU_FD', '150000', 1, '2015-06-02 17:49:30', '2017-03-17 12:03:01');
  62. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (52, 9, 'BOUGHT_CAMPAIGN_ID', 'Bought vouchers RO_FD', '201', 1, '2015-05-20 11:30:58', '2017-03-17 12:03:01');
  63. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (53, 10, 'BOUGHT_CAMPAIGN_ID', 'Bought vouchers BG_FD', '5825', 1, '2015-05-20 11:30:58', '2017-03-17 12:03:01');
  64. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (54, 11, 'BOUGHT_CAMPAIGN_ID', 'Bought vouchers HU_FD', '5826', 1, '2015-05-20 11:30:58', '2017-03-17 12:03:01');
  65. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (55, 9, 'ADDITIONAL_VAT_RATE', 'Vat rates RO_FD', '0,0.09,0.2,0.05', 1, '2015-08-11 11:21:31', '2017-03-23 11:17:29');
  66. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (56, 10, 'ADDITIONAL_VAT_RATE', 'Vat rates BG_FD', '0.09,0.20', 1, '2015-08-11 11:21:31', '2017-03-23 11:17:42');
  67. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (57, 11, 'ADDITIONAL_VAT_RATE', 'Vat rates HU_FD', '0.05,0.18,0.27', 1, '2015-08-11 11:21:31', '2017-03-17 12:03:01');
  68. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (58, 9, 'VOUCHER_TYPE_9_VAT', 'Override default vat for bought vouchers', '0', 1, '2015-06-02 17:49:30', '2017-03-17 12:03:01');
  69. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (59, 10, 'VOUCHER_TYPE_9_VAT', 'Override default vat for bought vouchers', '0', 1, '2015-06-02 17:49:30', '2017-03-17 12:03:01');
  70. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (60, 11, 'VOUCHER_TYPE_9_VAT', 'Override default vat for bought vouchers', '0', 1, '2015-06-02 17:49:30', '2017-03-17 12:03:01');
  71. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (61, 9, 'OVERRIDE_MKTP_VAT', 'Override mktp vat rate', '1', 1, '2015-08-11 11:21:31', '2017-03-17 12:03:01');
  72. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (62, 10, 'OVERRIDE_MKTP_VAT', 'Override mktp vat rate', '1', 1, '2015-08-11 11:21:31', '2017-03-17 12:03:01');
  73. INSERT INTO `campaign_characteristics` (`id`, `platform_id`, `name`, `description`, `value`, `status`, `created`, `modified`) VALUES (63, 11, 'OVERRIDE_MKTP_VAT', 'Override mktp vat rate', '1', 1, '2015-08-11 11:21:31', '2017-03-17 12:03:01');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!