
--
-- Table structure for table `d_local_go_subscriptions`
--

CREATE TABLE `d_local_go_subscriptions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_d_local_go` varchar(100) NOT NULL,
  `merchant_id` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `frequency_type` varchar(50) DEFAULT NULL,
  `frequency_value` int(11) DEFAULT NULL,
  `day_of_month` int(11) DEFAULT NULL,
  `active` tinyint(1) DEFAULT NULL,
  `free_trial_days` int(11) DEFAULT NULL,
  `plan_token` varchar(255) DEFAULT NULL,
  `created_at` datetime(3) DEFAULT NULL,
  `updated_at` datetime(3) DEFAULT NULL,
  `subscribe_url` text,
  `error_url` text,
  PRIMARY KEY (`id`),
  KEY `id_d_local_go` (`id_d_local_go`),
  CONSTRAINT `d_local_go_subscriptions_ibfk_1` FOREIGN KEY (`id_d_local_go`) REFERENCES `d_local_go` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `d_local_go_subscriptions`
--

INSERT INTO `d_local_go_subscriptions` VALUES (9,'3475',3125,'Plan de prueba','DAILY',1,NULL,0,0,'hJONVSLJ6cCqwpe9I2xLhiLFcOqtw9fI','2025-06-11 14:16:48.698','2025-06-11 14:16:48.698','https://checkout-sbx.dlocalgo.com/validate/subscription/hJONVSLJ6cCqwpe9I2xLhiLFcOqtw9fI',NULL),(10,'3476',3125,'Plan de prueba 1','DAILY',1,NULL,1,0,'lxhRU0I3LuP8YKSD6GBQ7yQX5TFU6iNS','2025-06-11 14:33:21.937','2025-06-11 14:33:21.937','https://checkout-sbx.dlocalgo.com/validate/subscription/lxhRU0I3LuP8YKSD6GBQ7yQX5TFU6iNS',NULL),(11,'3841',3125,'Plan 1 de Runa-Tarot','MONTHLY',1,NULL,1,0,'AiM00uOPWUtd0Gi2crr1YDVIc95RE7T5','2025-06-25 21:19:21.769','2025-06-25 21:19:21.769','https://checkout-sbx.dlocalgo.com/validate/subscription/AiM00uOPWUtd0Gi2crr1YDVIc95RE7T5','https://example.com/error?id=123'),(12,'3842',3125,'Plan 2 de Runa-Tarot','MONTHLY',1,NULL,1,0,'XtOWCpy4MeJLyhla58B872uKgG683zth','2025-06-25 21:19:53.621','2025-06-25 21:19:53.622','https://checkout-sbx.dlocalgo.com/validate/subscription/XtOWCpy4MeJLyhla58B872uKgG683zth','https://example.com/error?id=123'),(13,'3843',3125,'Plan 3 de Runa-Tarot','MONTHLY',1,NULL,1,0,'gUfomGIfD3z5ySzjrpVSe0zHBDXL2p1N','2025-06-25 21:20:17.226','2025-06-25 21:20:17.226','https://checkout-sbx.dlocalgo.com/validate/subscription/gUfomGIfD3z5ySzjrpVSe0zHBDXL2p1N','https://example.com/error?id=123'),(14,'3858',3125,'Plan 3 de Runa-Tarot','MONTHLY',1,NULL,1,0,'mH4NtUzmmBXSuFkseL2suty6lsEQbIe1','2025-06-26 21:11:57.821','2025-06-26 21:11:57.821','https://checkout-sbx.dlocalgo.com/validate/subscription/mH4NtUzmmBXSuFkseL2suty6lsEQbIe1','https://example.com/error?id=123'),(15,'3878',3125,'Plan 3 de Runa-Tarot','MONTHLY',1,NULL,1,0,'Ct1vqtWPBu1EqT67nIdGLH6XBYUUvU5N','2025-07-01 14:47:23.442','2025-07-01 14:47:23.442','https://checkout-sbx.dlocalgo.com/validate/subscription/Ct1vqtWPBu1EqT67nIdGLH6XBYUUvU5N','https://example.com/error?id=123'),(16,'3881',3125,'Prueba Suscripción dLocal GO','DAILY',1,NULL,1,0,'iD3Tva7NG8u4neDFW3JF54yvXlsLd2Wo','2025-07-01 21:40:29.724','2025-07-01 21:40:29.724','https://checkout-sbx.dlocalgo.com/validate/subscription/iD3Tva7NG8u4neDFW3JF54yvXlsLd2Wo','https://example.com/error?id=123'),(17,'3882',3125,'Prueba Suscripción dLocal GO','DAILY',1,NULL,1,0,'XyUUi4wyXWgKyVK3rMhTI4GB4jAdbQi0','2025-07-01 21:40:58.966','2025-07-01 21:40:58.966','https://checkout-sbx.dlocalgo.com/validate/subscription/XyUUi4wyXWgKyVK3rMhTI4GB4jAdbQi0','https://example.com/error?id=123'),(18,'3883',3125,'Prueba Suscripción dLocal GO','DAILY',1,NULL,1,0,'g7vfpCKSl7S9W7cUF196QoJdLdPXKcld','2025-07-01 21:41:26.672','2025-07-01 21:41:26.672','https://checkout-sbx.dlocalgo.com/validate/subscription/g7vfpCKSl7S9W7cUF196QoJdLdPXKcld','https://example.com/error?id=123'),(19,'3884',3125,'Prueba Suscripción dLocal GO','DAILY',1,NULL,1,0,'i81skWMyvwLJfPW9dmsy6b4ouEjS1Agz','2025-07-01 21:42:15.357','2025-07-01 21:42:15.357','https://checkout-sbx.dlocalgo.com/validate/subscription/i81skWMyvwLJfPW9dmsy6b4ouEjS1Agz','https://example.com/error?id=123'),(20,'3885',3125,'Prueba Suscripción dLocal GO','DAILY',1,NULL,1,0,'gKhBaI6OtzLRnwIfMp8fCKQrHZ5sb2HB','2025-07-01 22:13:36.143','2025-07-01 22:13:36.143','https://checkout-sbx.dlocalgo.com/validate/subscription/gKhBaI6OtzLRnwIfMp8fCKQrHZ5sb2HB','https://example.com/error?id=123'),(21,'3888',3125,'Prueba Suscripción dLocal GO','DAILY',1,NULL,1,0,'sL5KQYmPE9sMuHWG8keg12YuqrO8kc8d','2025-07-02 13:19:29.118','2025-07-02 13:19:29.118','https://checkout-sbx.dlocalgo.com/validate/subscription/sL5KQYmPE9sMuHWG8keg12YuqrO8kc8d','https://example.com/error?id=123'),(22,'3889',3125,'Plan de thinkific test','MONTHLY',1,NULL,1,0,'fZ7eXE4gSCjG63HygOqPdiwSpThCF2lD','2025-07-02 13:29:48.905','2025-07-02 13:29:48.905','https://checkout-sbx.dlocalgo.com/validate/subscription/fZ7eXE4gSCjG63HygOqPdiwSpThCF2lD','https://example.com/error?id=123'),(23,'3890',3125,'Plan de thinkific test 2','MONTHLY',1,NULL,1,0,'V9U1q7DtRpevp6v1JWV9xg3MAtx1ZD45','2025-07-02 15:27:03.589','2025-07-02 15:27:03.589','https://checkout-sbx.dlocalgo.com/validate/subscription/V9U1q7DtRpevp6v1JWV9xg3MAtx1ZD45','https://example.com/error?id=123'),(24,'3891',3125,'Plan de thinkific test 3','MONTHLY',1,NULL,1,0,'NGTGsZzsBZ2wvR7jqNJc4FQdOnoDPQKi','2025-07-02 15:58:10.343','2025-07-02 15:58:10.343','https://checkout-sbx.dlocalgo.com/validate/subscription/NGTGsZzsBZ2wvR7jqNJc4FQdOnoDPQKi','https://example.com/error?id=123'),(25,'3892',3125,'Plan de thinkific test DAILY','DAILY',1,NULL,1,0,'D5dE5I5QL2YPHdGK85C70OPIKwZYLSN3','2025-07-02 21:57:03.937','2025-07-02 21:57:03.937','https://checkout-sbx.dlocalgo.com/validate/subscription/D5dE5I5QL2YPHdGK85C70OPIKwZYLSN3','https://example.com/error?id=123'),(26,'3894',3125,'Plan Generico','MONTHLY',1,NULL,1,0,'ej4TNcfMcjmyjZztVtWdsM9LxFpbJuVG','2025-07-03 14:27:09.775','2025-07-03 14:27:09.775','https://checkout-sbx.dlocalgo.com/validate/subscription/ej4TNcfMcjmyjZztVtWdsM9LxFpbJuVG','https://example.com/error?id=123'),(27,'3895',3125,'Plan Runa Tarot 20','MONTHLY',1,NULL,0,0,'gPzh8pmvo0M4N4gtkYqcuDvECUh0l0YO','2025-07-03 14:28:11.535','2025-07-03 14:28:11.535','https://checkout-sbx.dlocalgo.com/validate/subscription/gPzh8pmvo0M4N4gtkYqcuDvECUh0l0YO','http://localhost:5173/compras'),(28,'6633',174490,'Plan de prueba42353','DAILY',1,NULL,0,0,'xPCHrltE1RyadHhtxxwSh7aY8dXm7uNS','2025-07-04 16:10:32.165','2025-07-04 16:10:32.165','https://checkout.dlocalgo.com/validate/subscription/xPCHrltE1RyadHhtxxwSh7aY8dXm7uNS','https://example.com/error?id=123'),(29,'3917',3125,'Plan de prueba42354','DAILY',1,NULL,0,0,'ZpiFdh1IfEX3BE9sNrQr924SAc3xmyiR','2025-07-04 16:11:42.954','2025-07-04 16:11:42.954','https://checkout-sbx.dlocalgo.com/validate/subscription/ZpiFdh1IfEX3BE9sNrQr924SAc3xmyiR','https://example.com/error?id=123'),(30,'3918',3125,'Plan de prueba42355','DAILY',1,NULL,0,0,'IdsKEanoXRH4o0BIuh1gk1WROxf1Kvh4','2025-07-04 16:29:55.395','2025-07-04 16:29:55.395','https://checkout-sbx.dlocalgo.com/validate/subscription/IdsKEanoXRH4o0BIuh1gk1WROxf1Kvh4','https://example.com/error?id=123'),(31,'6671',174490,'Suscripcion a Runa','MONTHLY',1,NULL,0,0,'Idj9LJ22PxaDOkZ8LEPnPRwGy9qaSyLV','2025-07-07 16:52:53.310','2025-07-07 16:52:53.310','https://checkout.dlocalgo.com/validate/subscription/Idj9LJ22PxaDOkZ8LEPnPRwGy9qaSyLV','https://example.com/error?id=123'),(32,'3925',3125,'Suscripcion a Runa','MONTHLY',1,NULL,1,0,'gz2bMqoAB8Nkn6jU57Jva68hfayYK4A7','2025-07-07 16:53:36.887','2025-07-07 16:53:36.887','https://checkout-sbx.dlocalgo.com/validate/subscription/gz2bMqoAB8Nkn6jU57Jva68hfayYK4A7','https://example.com/error?id=123'),(33,'6675',174490,'Suscripcion a Runa','MONTHLY',1,NULL,0,0,'bcIwpduqbWLlBi8xWe26Lq4iy8vZqzuI','2025-07-07 21:16:38.227','2025-07-07 21:16:38.227','https://checkout.dlocalgo.com/validate/subscription/bcIwpduqbWLlBi8xWe26Lq4iy8vZqzuI','https://example.com/error?id=123'),(34,'6676',174490,'Suscripción a Runa','MONTHLY',1,NULL,0,0,'aJKESoXLhMro3a1ZjDAWVkrKTW7fAZrm','2025-07-07 21:38:03.778','2025-07-07 21:38:03.778','https://checkout.dlocalgo.com/validate/subscription/aJKESoXLhMro3a1ZjDAWVkrKTW7fAZrm','https://example.com/error?id=123'),(35,'3938',3125,'Plan de Thinkific no Email','DAILY',1,NULL,1,0,'Wvhv535KeDn37wq6sQZceakdEhCTIP2l','2025-07-10 15:54:31.343','2025-07-10 15:54:31.343','https://checkout-sbx.dlocalgo.com/validate/subscription/Wvhv535KeDn37wq6sQZceakdEhCTIP2l','https://example.com/error?id=123'),(36,'3939',3125,'Plan de Thinkific no Email','DAILY',1,NULL,1,0,'cQvznhahUaf7DI9Orog5ExqHH0wz1UKI','2025-07-10 15:57:50.356','2025-07-10 15:57:50.356','https://checkout-sbx.dlocalgo.com/validate/subscription/cQvznhahUaf7DI9Orog5ExqHH0wz1UKI','https://example.com/error?id=123'),(37,'3943',3125,'Runa Mensual','MONTHLY',1,NULL,1,0,'QsqWGkOjanD08Ll1tqAt38WFTREukxXi','2025-07-11 16:04:06.335','2025-07-11 16:04:06.335','https://checkout-sbx.dlocalgo.com/validate/subscription/QsqWGkOjanD08Ll1tqAt38WFTREukxXi','https://example.com/error?id=123'),(38,'6751',174490,'Runa Mensual','MONTHLY',1,NULL,1,0,'jZ5X0dB5e1ae323w7btmDlkBOxm8kLSL','2025-07-11 16:04:50.834','2025-07-11 16:04:50.834','https://checkout.dlocalgo.com/validate/subscription/jZ5X0dB5e1ae323w7btmDlkBOxm8kLSL','https://example.com/error?id=123'),(39,'6752',174490,'Runa Mensual','MONTHLY',1,NULL,1,0,'12ZYplDS7kNjx3vmYhtFUKFrzfhOXpMS','2025-07-11 16:08:03.497','2025-07-11 16:08:03.497','https://checkout.dlocalgo.com/validate/subscription/12ZYplDS7kNjx3vmYhtFUKFrzfhOXpMS','https://example.com/error?id=123'),(40,'6884',174490,'Runa Mensual','MONTHLY',1,NULL,0,0,'2Np0g1wgi6OS9GCCHy6knzyW5pursq57','2025-07-18 17:09:29.878','2025-07-18 17:09:29.878','https://checkout.dlocalgo.com/validate/subscription/2Np0g1wgi6OS9GCCHy6knzyW5pursq57','https://example.com/error?id=123'),(41,'6902',174490,'Runa Mensual','MONTHLY',1,NULL,0,0,'JWjbtx8u9b2msNvKUgNwNLFNtjlgPm0Q','2025-07-21 13:46:58.748','2025-07-21 13:46:58.748','https://checkout.dlocalgo.com/validate/subscription/JWjbtx8u9b2msNvKUgNwNLFNtjlgPm0Q','https://example.com/error?id=123'),(42,'6906',174490,'Runa Mensual','MONTHLY',1,NULL,0,0,'m7G2kInsMFQLaVOOzxRWOCo7K9L1ZBD7','2025-07-21 15:17:23.214','2025-07-21 15:17:23.214','https://checkout.dlocalgo.com/validate/subscription/m7G2kInsMFQLaVOOzxRWOCo7K9L1ZBD7','https://example.com/error?id=123'),(43,'6908',174490,'Runa Mensual','MONTHLY',1,NULL,1,0,'dbFMKaRGNyIHO9CFRZyRmfMWVu6yXDdn','2025-07-21 16:59:37.990','2025-07-21 16:59:37.990','https://checkout.dlocalgo.com/validate/subscription/dbFMKaRGNyIHO9CFRZyRmfMWVu6yXDdn','https://example.com/error?id=123'),(44,'6955',174490,'Runa Mensual','MONTHLY',1,NULL,0,0,'uakvGrosFtRx5Ctkh8KeHhC5c33bA43x','2025-07-22 15:52:08.843','2025-07-22 15:52:08.843','https://checkout.dlocalgo.com/validate/subscription/uakvGrosFtRx5Ctkh8KeHhC5c33bA43x','https://example.com/error?id=123'),(45,'3963',3125,'Runa Contenidos Subscripción Mensual','MONTHLY',1,NULL,0,0,'RAi9926SLKoOi1WUFCHBmyzelWoxmy9k','2025-07-22 15:56:08.882','2025-07-22 15:56:08.882','https://checkout-sbx.dlocalgo.com/validate/subscription/RAi9926SLKoOi1WUFCHBmyzelWoxmy9k','https://example.com/error'),(46,'3964',3125,'Runa Contenidos Subscripción Mensual','MONTHLY',1,NULL,0,0,'5T6KFia1hmS7mLCDkTBnJZmI9Ar4Ts0H','2025-07-22 15:56:34.536','2025-07-22 15:56:34.536','https://checkout-sbx.dlocalgo.com/validate/subscription/5T6KFia1hmS7mLCDkTBnJZmI9Ar4Ts0H','https://example.com/error'),(47,'3965',3125,'Runa Contenidos Subscripción Mensual','MONTHLY',1,NULL,0,0,'uJ6JJWqqBsEZq1mxfKcnlPBpJtW55ee9','2025-07-22 15:57:09.375','2025-07-22 15:57:09.375','https://checkout-sbx.dlocalgo.com/validate/subscription/uJ6JJWqqBsEZq1mxfKcnlPBpJtW55ee9','https://example.com/error'),(48,'3966',3125,'Runa Mensual','MONTHLY',1,NULL,0,0,'L9N3hZ3fDnSnbyWURqHT0pwKmoXXg9dF','2025-07-22 16:03:29.515','2025-07-22 16:03:29.515','https://checkout-sbx.dlocalgo.com/validate/subscription/L9N3hZ3fDnSnbyWURqHT0pwKmoXXg9dF','https://example.com/error?id=123'),(49,'3967',3125,'Runa Contenidos Subscripción Mensual','MONTHLY',1,NULL,0,0,'GDX2Fto4yx9GnJ0VlwiSTEMWQt4P3hRO','2025-07-22 16:04:47.109','2025-07-22 16:04:47.109','https://checkout-sbx.dlocalgo.com/validate/subscription/GDX2Fto4yx9GnJ0VlwiSTEMWQt4P3hRO','https://example.com/error'),(50,'3968',3125,'Runa Mensual Test Fran','MONTHLY',1,NULL,1,0,'efEwIfWWkrrhUpKUGCdyyJIz8lNnXQsk','2025-07-23 15:09:13.902','2025-07-23 15:09:13.902','https://checkout-sbx.dlocalgo.com/validate/subscription/efEwIfWWkrrhUpKUGCdyyJIz8lNnXQsk','https://example.com/error?id=123'),(51,'3984',3125,'Runa Mensual Test Fran','MONTHLY',1,NULL,1,0,'eCfmEFclqaLzQE5M01lNCs2F2gNeNszc','2025-07-25 15:07:48.430','2025-07-25 15:07:48.430','https://checkout-sbx.dlocalgo.com/validate/subscription/eCfmEFclqaLzQE5M01lNCs2F2gNeNszc','https://runa-tarot.netlify.app/compras'),(52,'7039',174490,'Runa-Tarot','MONTHLY',1,NULL,1,0,'HzPjBgcJm7h7Y2NUHnCUP7SfTdDnZBZ9','2025-07-25 15:32:03.264','2025-07-25 15:32:03.264','https://checkout.dlocalgo.com/validate/subscription/HzPjBgcJm7h7Y2NUHnCUP7SfTdDnZBZ9','https://runa-tarot.netlify.app/compras'),(53,'7040',174490,'Runa-Tarot','MONTHLY',1,NULL,1,0,'2B7kRmjcbxKBKwRlgnw89VzNseZOqxqb','2025-07-25 15:34:09.390','2025-07-25 15:34:09.390','https://checkout.dlocalgo.com/validate/subscription/2B7kRmjcbxKBKwRlgnw89VzNseZOqxqb','https://runa-tarot.netlify.app/compras'),(54,'7041',174490,'Runa-Tarot','MONTHLY',1,NULL,1,0,'fxLWwCFhboErKiOwYO1gF8frSmDga6bY','2025-07-25 15:35:00.280','2025-07-25 15:35:00.280','https://checkout.dlocalgo.com/validate/subscription/fxLWwCFhboErKiOwYO1gF8frSmDga6bY','https://runa-tarot.netlify.app/compras'),(55,'7042',174490,'Runa-Tarot','MONTHLY',1,NULL,1,0,'yGmps6gu3n5frMj9cuJyj1aHE9H9waLs','2025-07-25 15:36:16.258','2025-07-25 15:36:16.258','https://checkout.dlocalgo.com/validate/subscription/yGmps6gu3n5frMj9cuJyj1aHE9H9waLs','https://runa-tarot.netlify.app/compras'),(56,'4008',3125,'Topclass Lumina','MONTHLY',1,NULL,1,0,'3okfBfIzfQTYOo2vAb8JMgbGtEzyrXPV','2025-07-29 16:40:20.679','2025-07-29 16:40:20.679','https://checkout-sbx.dlocalgo.com/validate/subscription/3okfBfIzfQTYOo2vAb8JMgbGtEzyrXPV','https://example.com/error'),(57,'7086',174490,'Topclass Lumina 1','MONTHLY',1,NULL,0,0,'COGmH4f4LAHq7ClKRZfq5YjY0hzNN5Sh','2025-07-29 18:03:50.676','2025-07-29 18:03:50.676','https://checkout.dlocalgo.com/validate/subscription/COGmH4f4LAHq7ClKRZfq5YjY0hzNN5Sh','https://example.com/error'),(58,'4009',3125,'Topclass Lumina 12','MONTHLY',1,NULL,1,0,'SEQj7PMaic225XOeNrFwNGSAYTzu7JHr','2025-07-29 18:04:17.417','2025-07-29 18:04:17.417','https://checkout-sbx.dlocalgo.com/validate/subscription/SEQj7PMaic225XOeNrFwNGSAYTzu7JHr','https://example.com/error'),(59,'7087',174490,'Topclass Lumina','MONTHLY',1,NULL,1,0,'5xBISCQFuzP6BFq4ISLioMkp1yqRV84x','2025-07-29 18:17:53.140','2025-07-29 18:17:53.140','https://checkout.dlocalgo.com/validate/subscription/5xBISCQFuzP6BFq4ISLioMkp1yqRV84x','https://example.com/error'),(60,'4010',3125,'Topclass Lumina test','MONTHLY',1,NULL,1,0,'CEEC1YCNLaz11W5YaKrGC3T2g8AJxbNt','2025-07-29 22:10:13.171','2025-07-29 22:10:13.171','https://checkout-sbx.dlocalgo.com/validate/subscription/CEEC1YCNLaz11W5YaKrGC3T2g8AJxbNt','https://example.com/error'),(61,'4011',3125,'Topclass Lumina test1','MONTHLY',1,NULL,1,0,'NSjEYO2OFJVPk0PixFvPxNZe1ufjFGmE','2025-07-29 22:27:37.511','2025-07-29 22:27:37.511','https://checkout-sbx.dlocalgo.com/validate/subscription/NSjEYO2OFJVPk0PixFvPxNZe1ufjFGmE','https://example.com/error'),(62,'4033',3125,'Runa Mensual','MONTHLY',1,NULL,1,0,'fzpBPRdUarIBPrfQcPs4mhIXWg33qO4n','2025-08-08 17:52:40.168','2025-08-08 17:52:40.168','https://checkout-sbx.dlocalgo.com/validate/subscription/fzpBPRdUarIBPrfQcPs4mhIXWg33qO4n','https://example.com/error'),(63,'7329',174490,'Runa Mensual','MONTHLY',1,NULL,1,0,'yaU1g63j3O2Lh6jsRQB6LGV4fhMAupHA','2025-08-08 17:53:08.340','2025-08-08 17:53:08.340','https://checkout.dlocalgo.com/validate/subscription/yaU1g63j3O2Lh6jsRQB6LGV4fhMAupHA','https://example.com/error'),(64,'7437',174490,'Urania Mensual','MONTHLY',1,NULL,1,0,'pxneeaYeEQ90tyA0moK8dHxmqRwGwdtx','2025-08-13 13:40:31.401','2025-08-13 13:40:31.401','https://checkout.dlocalgo.com/validate/subscription/pxneeaYeEQ90tyA0moK8dHxmqRwGwdtx','https://example.com/error'),(65,'4081',3125,'Topclass Lumina test2','MONTHLY',1,NULL,1,0,'4hQZJB6Pp3o8NBlXmSDUpnFertlMaeNm','2025-08-13 15:24:29.165','2025-08-13 15:24:29.165','https://checkout-sbx.dlocalgo.com/validate/subscription/4hQZJB6Pp3o8NBlXmSDUpnFertlMaeNm','https://example.com/error'),(66,'7447',174490,'Cocinaria Mensual','MONTHLY',1,NULL,1,0,'gNVdnfslVu7FIrSgVm7XMIBTaTSlPA5f','2025-08-13 16:03:47.623','2025-08-13 16:03:47.623','https://checkout.dlocalgo.com/validate/subscription/gNVdnfslVu7FIrSgVm7XMIBTaTSlPA5f','https://example.com/error'),(67,'7452',174490,'Cocinaria Mensual','MONTHLY',1,NULL,1,0,'onOKtxw0OvK33fEcxuPnuLr1SpfFGgkk','2025-08-13 18:28:38.919','2025-08-13 18:28:38.919','https://checkout.dlocalgo.com/validate/subscription/onOKtxw0OvK33fEcxuPnuLr1SpfFGgkk','https://mkt.topclass.cl/landing-scroll-cocinaria/'),(68,'7454',174490,'Cocinaria Mensual','MONTHLY',1,NULL,1,0,'GIDAds6TeIxbj5oJhkf4Oh0tK2Htli7c','2025-08-13 18:31:38.711','2025-08-13 18:31:38.711','https://checkout.dlocalgo.com/validate/subscription/GIDAds6TeIxbj5oJhkf4Oh0tK2Htli7c','https://mkt.topclass.cl/landing-scroll-cocinaria/'),(69,'7455',174490,'Cocinaria Mensual','MONTHLY',1,NULL,1,0,'ohnOPzXgeR0g5p9jqWvfJN7xnPcNP14Z','2025-08-13 18:42:03.275','2025-08-13 18:42:03.275','https://checkout.dlocalgo.com/validate/subscription/ohnOPzXgeR0g5p9jqWvfJN7xnPcNP14Z','https://mkt.topclass.cl/landing-scroll-cocinaria-sin-email/'),(70,'7456',174490,'Urania Mensual','MONTHLY',1,NULL,1,0,'dP4Vvpi9rrmtVDlp7dkuJQtm8CNJVx8Z','2025-08-13 18:55:27.797','2025-08-13 18:55:27.797','https://checkout.dlocalgo.com/validate/subscription/dP4Vvpi9rrmtVDlp7dkuJQtm8CNJVx8Z','https://mkt.topclass.cl/landing-scroll-2-urania-3990/'),(71,'7462',174490,'Urania Mensual','MONTHLY',1,NULL,1,0,'llxssYEwXN6OS2rnr50JPQDqetpPJYVI','2025-08-13 20:28:03.252','2025-08-13 20:28:03.252','https://checkout.dlocalgo.com/validate/subscription/llxssYEwXN6OS2rnr50JPQDqetpPJYVI','https://mkt.topclass.cl/landing-scroll-2-urania-3990-sin-email/'),(72,'7465',174490,'Lumina Mensual','MONTHLY',1,NULL,1,0,'A6QZHraJXuT8gxRtV1xhs4HkUs5bTCzV','2025-08-13 20:48:48.955','2025-08-13 20:48:48.955','https://checkout.dlocalgo.com/validate/subscription/A6QZHraJXuT8gxRtV1xhs4HkUs5bTCzV','https://mkt.topclass.cl/landing-scroll-lumina-3990-sin-email/'),(73,'7466',174490,'Animalia Mensual','MONTHLY',1,NULL,1,0,'DxHkJfEhOzKwLInXnpSgd3mRCQDjMl3j','2025-08-13 21:05:01.814','2025-08-13 21:05:01.814','https://checkout.dlocalgo.com/validate/subscription/DxHkJfEhOzKwLInXnpSgd3mRCQDjMl3j','https://mkt.topclass.cl/landing-scroll-2-animalia-3990/'),(74,'7467',174490,'Animalia Mensual','MONTHLY',1,NULL,1,0,'P6w8QdgtkdhZo9TKMt38KzeMwiUGwpbE','2025-08-13 21:09:26.285','2025-08-13 21:09:26.285','https://checkout.dlocalgo.com/validate/subscription/P6w8QdgtkdhZo9TKMt38KzeMwiUGwpbE','https://mkt.topclass.cl/landing-scroll-2-animalia-3990-sin-email/'),(75,'7468',174490,'Animalia Mensual','MONTHLY',1,NULL,1,0,'jBx55IHKGsdVRT5ehQDzIunswKRI92ZN','2025-08-13 21:12:58.866','2025-08-13 21:12:58.866','https://checkout.dlocalgo.com/validate/subscription/jBx55IHKGsdVRT5ehQDzIunswKRI92ZN','https://mkt.topclass.cl/landing-scroll-2-animalia-3990-sin-email/'),(76,'4126',3125,'Suscripción anual','YEARLY',1,NULL,1,0,'ZOi2quFMrp1MuXjndCyWT3GffS32pzMC','2025-08-19 13:18:37.801','2025-08-19 13:18:37.801','https://checkout-sbx.dlocalgo.com/validate/subscription/ZOi2quFMrp1MuXjndCyWT3GffS32pzMC','https://example.com/error'),(77,'4127',3125,'Suscripción anual','YEARLY',1,NULL,1,0,'4nOJnmHk9H5iW2aWxuUF6njnJHCepx4y','2025-08-19 13:19:39.974','2025-08-19 13:19:39.974','https://checkout-sbx.dlocalgo.com/validate/subscription/4nOJnmHk9H5iW2aWxuUF6njnJHCepx4y','https://example.com/error'),(78,'7561',174490,'Runa Mensual','MONTHLY',1,NULL,1,0,'XSjp92a0guml964fG8r3mX4cwwy5qC9e','2025-08-20 16:37:06.198','2025-08-20 16:37:06.198','https://checkout.dlocalgo.com/validate/subscription/XSjp92a0guml964fG8r3mX4cwwy5qC9e','https://mkt.topclass.cl/runa-scrolltc-2/'),(79,'7562',174490,'Runa Mensual','MONTHLY',1,NULL,1,0,'HnECbm1zm3QSlPVUWtVd8aoQ5f9GebYQ','2025-08-20 16:48:09.837','2025-08-20 16:48:09.837','https://checkout.dlocalgo.com/validate/subscription/HnECbm1zm3QSlPVUWtVd8aoQ5f9GebYQ','https://mkt.topclass.cl/runa-scrolltc-2/'),(80,'4139',3125,'Suscripción anual','YEARLY',1,NULL,1,0,'Nd6mVVArAV7JVqgVFj8ChE0tUAdbiYiS','2025-08-20 21:28:19.365','2025-08-20 21:28:19.365','https://checkout-sbx.dlocalgo.com/validate/subscription/Nd6mVVArAV7JVqgVFj8ChE0tUAdbiYiS','https://example.com/error'),(81,'4141',3125,'Suscripción Diaria','DAILY',1,NULL,1,0,'AuxNWWzmxlIKmr6jKrSSIdNBZJD63Zke','2025-08-20 22:13:54.944','2025-08-20 22:13:54.944','https://checkout-sbx.dlocalgo.com/validate/subscription/AuxNWWzmxlIKmr6jKrSSIdNBZJD63Zke','https://mkt.topclass.cl/landing-scroll-2-animalia-3990/'),(82,'4142',3125,'Urania Mensual','MONTHLY',1,NULL,1,0,'qUNJ6ebpSL7XR64TWthrY8iQ21rzLi5F','2025-08-20 22:29:32.620','2025-08-20 22:29:32.620','https://checkout-sbx.dlocalgo.com/validate/subscription/qUNJ6ebpSL7XR64TWthrY8iQ21rzLi5F','https://mkt.topclass.cl/landing-scroll-2-urania-3990/'),(83,'4143',3125,'Urania Mensual','MONTHLY',1,NULL,1,0,'gjMVjtrHPink6GSBjMvdcSpMQ21h2alS','2025-08-20 22:33:56.835','2025-08-20 22:33:56.835','https://checkout-sbx.dlocalgo.com/validate/subscription/gjMVjtrHPink6GSBjMvdcSpMQ21h2alS','https://mkt.topclass.cl/landing-scroll-2-urania-3990/'),(84,'4144',3125,'Cocinaria Mensual','MONTHLY',1,NULL,1,0,'OSgpj0ReiGgYpEVvaWZmBCNQQYI9eb9n','2025-08-20 22:35:54.943','2025-08-20 22:35:54.943','https://checkout-sbx.dlocalgo.com/validate/subscription/OSgpj0ReiGgYpEVvaWZmBCNQQYI9eb9n','https://mkt.topclass.cl/landing-scroll-cocinaria-sin-email/'),(85,'4145',3125,'Cocinaria Mensual','MONTHLY',1,NULL,1,0,'D73Tf1MV2yqNl36uJRFM1ZIeuOvQirfx','2025-08-20 22:41:19.832','2025-08-20 22:41:19.832','https://checkout-sbx.dlocalgo.com/validate/subscription/D73Tf1MV2yqNl36uJRFM1ZIeuOvQirfx','https://mkt.topclass.cl/landing-scroll-cocinaria/'),(86,'4146',3125,'Urania Mensual','MONTHLY',1,NULL,1,0,'Q48zllKCwn9Boozs4A246Tmu843e8kAq','2025-08-20 22:45:53.849','2025-08-20 22:45:53.849','https://checkout-sbx.dlocalgo.com/validate/subscription/Q48zllKCwn9Boozs4A246Tmu843e8kAq','https://mkt.topclass.cl/landing-scroll-2-urania-3990-sin-email/'),(87,'4147',3125,'Cocinaria Mensual','MONTHLY',1,NULL,1,0,'obQ5hc6mSN2BLJNubvMh299daTF3ZO9r','2025-08-20 22:48:10.442','2025-08-20 22:48:10.442','https://checkout-sbx.dlocalgo.com/validate/subscription/obQ5hc6mSN2BLJNubvMh299daTF3ZO9r','https://mkt.topclass.cl/landing-scroll-cocinaria-sin-email/'),(88,'4148',3125,'Cocinaria Mensual','MONTHLY',1,NULL,1,0,'Zxy28avtoh93X9D1Wyxwx4losOiKxki5','2025-08-20 22:48:31.585','2025-08-20 22:48:31.585','https://checkout-sbx.dlocalgo.com/validate/subscription/Zxy28avtoh93X9D1Wyxwx4losOiKxki5','https://mkt.topclass.cl/landing-scroll-cocinaria-sin-email/'),(89,'4149',3125,'Cocinaria Mensual','MONTHLY',1,NULL,1,0,'C0xajMSAdG0hk1OOanjscMLp4i4pLzbX','2025-08-20 22:50:18.675','2025-08-20 22:50:18.675','https://checkout-sbx.dlocalgo.com/validate/subscription/C0xajMSAdG0hk1OOanjscMLp4i4pLzbX','https://mkt.topclass.cl/landing-scroll-cocinaria/'),(90,'4150',3125,'Cocinaria Mensual','MONTHLY',1,NULL,1,0,'FauAgqsFBzt1srGM2IQkm9Cb7IPpDyiy','2025-08-20 22:51:38.068','2025-08-20 22:51:38.068','https://checkout-sbx.dlocalgo.com/validate/subscription/FauAgqsFBzt1srGM2IQkm9Cb7IPpDyiy','https://mkt.topclass.cl/landing-scroll-cocinaria/'),(91,'4151',3125,'Cocinaria Mensual','MONTHLY',1,NULL,1,0,'ejPYN17ZGgLPefBUVAPSmVYZJJhaGnPo','2025-08-20 22:53:35.682','2025-08-20 22:53:35.682','https://checkout-sbx.dlocalgo.com/validate/subscription/ejPYN17ZGgLPefBUVAPSmVYZJJhaGnPo','https://mkt.topclass.cl/landing-scroll-cocinaria-sin-email/'),(92,'4152',3125,'Cocinaria Mensual','MONTHLY',1,NULL,1,0,'AsRVcfiBThzV6FZpu7Anhi7hCWxyr3qb','2025-08-20 22:53:45.855','2025-08-20 22:53:45.855','https://checkout-sbx.dlocalgo.com/validate/subscription/AsRVcfiBThzV6FZpu7Anhi7hCWxyr3qb','https://mkt.topclass.cl/landing-scroll-cocinaria-sin-email/'),(93,'4153',3125,'Cocinaria Mensual','MONTHLY',1,NULL,1,0,'2kW2sDFidPSSrL0n5SdPeKpdgzqGCy4z','2025-08-20 22:54:45.459','2025-08-20 22:54:45.459','https://checkout-sbx.dlocalgo.com/validate/subscription/2kW2sDFidPSSrL0n5SdPeKpdgzqGCy4z','https://mkt.topclass.cl/landing-scroll-cocinaria/'),(94,'4154',3125,'Cocinaria Mensual','MONTHLY',1,NULL,1,0,'rgRZcPsVEcXMDU0KHfHVB1MAQ4cf0M49','2025-08-20 22:56:35.315','2025-08-20 22:56:35.315','https://checkout-sbx.dlocalgo.com/validate/subscription/rgRZcPsVEcXMDU0KHfHVB1MAQ4cf0M49','https://mkt.topclass.cl/landing-scroll-cocinaria-sin-email/'),(95,'4155',3125,'Urania Mensual','MONTHLY',1,NULL,1,0,'LvyHChhi0eXgUg9DmIlrUY5BqpkPBjjk','2025-08-20 23:08:55.140','2025-08-20 23:08:55.140','https://checkout-sbx.dlocalgo.com/validate/subscription/LvyHChhi0eXgUg9DmIlrUY5BqpkPBjjk','https://mkt.topclass.cl/landing-scroll-2-urania-3990-sin-email/'),(96,'4156',3125,'Animalia Mensual','MONTHLY',1,NULL,1,0,'Y1CERd37Rz4tD4QiUK5n0rfD9cdCTHik','2025-08-20 23:12:34.251','2025-08-20 23:12:34.251','https://checkout-sbx.dlocalgo.com/validate/subscription/Y1CERd37Rz4tD4QiUK5n0rfD9cdCTHik','https://mkt.topclass.cl/landing-scroll-2-animalia-3990-sin-email/'),(97,'4157',3125,'Animalia Mensual','MONTHLY',1,NULL,1,0,'tFH65SJ92KHadJohCoaI3TqYJCDCu3Qa','2025-08-20 23:15:40.209','2025-08-20 23:15:40.209','https://checkout-sbx.dlocalgo.com/validate/subscription/tFH65SJ92KHadJohCoaI3TqYJCDCu3Qa','https://mkt.topclass.cl/landing-scroll-2-animalia-3990/'),(98,'4158',3125,'Lumina Mensual','MONTHLY',1,NULL,1,0,'pAARfwGTDF2lWA8FU3HFSymftNCJ3m0F','2025-08-20 23:19:02.798','2025-08-20 23:19:02.798','https://checkout-sbx.dlocalgo.com/validate/subscription/pAARfwGTDF2lWA8FU3HFSymftNCJ3m0F','https://mkt.topclass.cl/landing-scroll-lumina-3990-sin-email'),(99,'4159',3125,'Lumina Mensual','MONTHLY',1,NULL,1,0,'3CnqQxVPiXkv9ufoju0HXOkf4TYeGrae','2025-08-20 23:31:03.041','2025-08-20 23:31:03.041','https://checkout-sbx.dlocalgo.com/validate/subscription/3CnqQxVPiXkv9ufoju0HXOkf4TYeGrae','https://mkt.topclass.cl/landing-scroll2-lumina/'),(100,'4160',3125,'Cocinaria Mensual','MONTHLY',1,NULL,1,0,'kHa4dnvxGG2Na7Ub9rUIO2Buh7O2x6ID','2025-08-20 23:37:46.531','2025-08-20 23:37:46.531','https://checkout-sbx.dlocalgo.com/validate/subscription/kHa4dnvxGG2Na7Ub9rUIO2Buh7O2x6ID','https://mkt.topclass.cl/landing-scroll-cocinaria/'),(101,'4161',3125,'Cocinaria Mensual','MONTHLY',1,NULL,1,0,'9pPaxYezcetKJBQLTyQLhYf8pWzqDqBH','2025-08-20 23:37:53.602','2025-08-20 23:37:53.602','https://checkout-sbx.dlocalgo.com/validate/subscription/9pPaxYezcetKJBQLTyQLhYf8pWzqDqBH','https://mkt.topclass.cl/landing-scroll-cocinaria/'),(102,'7583',174490,'Urania Mensual','MONTHLY',1,NULL,1,0,'7qVUws4l0rjUjwzS45a4AxhVG6734c2d','2025-08-21 22:21:23.399','2025-08-21 22:21:23.399','https://checkout.dlocalgo.com/validate/subscription/7qVUws4l0rjUjwzS45a4AxhVG6734c2d','https://mkt.topclass.cl/landing-scroll-2-urania-3990/'),(103,'7584',174490,'Urania Mensual','MONTHLY',1,NULL,1,0,'rYa8qVEC6S0LkYhNtjv02dXxsCpkxOyN','2025-08-21 22:23:29.890','2025-08-21 22:23:29.890','https://checkout.dlocalgo.com/validate/subscription/rYa8qVEC6S0LkYhNtjv02dXxsCpkxOyN','https://mkt.topclass.cl/landing-scroll-2-urania-3990-sin-email/'),(104,'7585',174490,'Cocinaria Mensual','MONTHLY',1,NULL,1,0,'NKegnCt3oXOIj4IGxSIcD4CLTpnKtw7U','2025-08-21 22:27:59.130','2025-08-21 22:27:59.130','https://checkout.dlocalgo.com/validate/subscription/NKegnCt3oXOIj4IGxSIcD4CLTpnKtw7U','https://mkt.topclass.cl/landing-scroll-cocinaria-sin-email/'),(105,'7586',174490,'Cocinaria Mensual','MONTHLY',1,NULL,1,0,'ym8R1aOwXxSe0jBMJViihGWvP7TOkTAm','2025-08-21 22:30:44.719','2025-08-21 22:30:44.719','https://checkout.dlocalgo.com/validate/subscription/ym8R1aOwXxSe0jBMJViihGWvP7TOkTAm','https://mkt.topclass.cl/landing-scroll-cocinaria/'),(106,'7587',174490,'Animalia Mensual','MONTHLY',1,NULL,1,0,'ur8JeEXrHwo89evG1WGMTenFuUtxRIEx','2025-08-21 22:33:04.965','2025-08-21 22:33:04.965','https://checkout.dlocalgo.com/validate/subscription/ur8JeEXrHwo89evG1WGMTenFuUtxRIEx','https://mkt.topclass.cl/landing-scroll-2-animalia-3990-sin-email/'),(107,'7588',174490,'Animalia Mensual','MONTHLY',1,NULL,1,0,'21lTFbugXYEVmUreIxOKc58zS5aQHH5W','2025-08-21 22:35:00.375','2025-08-21 22:35:00.375','https://checkout.dlocalgo.com/validate/subscription/21lTFbugXYEVmUreIxOKc58zS5aQHH5W','https://mkt.topclass.cl/landing-scroll-2-animalia-3990/'),(108,'7589',174490,'Lumina Mensual','MONTHLY',1,NULL,1,0,'jCUj8fr6gFQthf7IAt3mI9cq5ethug7X','2025-08-21 22:36:39.132','2025-08-21 22:36:39.132','https://checkout.dlocalgo.com/validate/subscription/jCUj8fr6gFQthf7IAt3mI9cq5ethug7X','https://mkt.topclass.cl/landing-scroll-lumina-3990-sin-email/'),(109,'7590',174490,'Lumina Mensual','MONTHLY',1,NULL,1,0,'a1ONGHmy5tbVcIMaH1bzvAjxFpE0xMls','2025-08-21 22:38:17.414','2025-08-21 22:38:17.414','https://checkout.dlocalgo.com/validate/subscription/a1ONGHmy5tbVcIMaH1bzvAjxFpE0xMls','https://mkt.topclass.cl/landing-scroll2-lumina'),(110,'4244',3125,'Suscripción Diaria','DAILY',1,NULL,1,0,'ixXfrOKJJMx0EmQEtsh6yrvTwqnw27qL','2025-08-26 15:29:47.749','2025-08-26 15:29:47.749','https://checkout-sbx.dlocalgo.com/validate/subscription/ixXfrOKJJMx0EmQEtsh6yrvTwqnw27qL','https://example.com/error'),(111,'7649',174490,'Runa Mensual','MONTHLY',1,NULL,1,0,'SotYL0ifPE019twLz0y4puUjchyoGcgN','2025-08-26 22:01:48.748','2025-08-26 22:01:48.748','https://checkout.dlocalgo.com/validate/subscription/SotYL0ifPE019twLz0y4puUjchyoGcgN','https://runa-tarot.netlify.app/compras'),(112,'7650',174490,'Runa-Tarot','MONTHLY',1,NULL,1,0,'yi6057N8GNcbxwKXTHkloMABE9YYSqaw','2025-08-26 22:03:08.844','2025-08-26 22:03:08.844','https://checkout.dlocalgo.com/validate/subscription/yi6057N8GNcbxwKXTHkloMABE9YYSqaw','https://runa-tarot.netlify.app/compras'),(113,'4245',3125,'Runa-Tarot','MONTHLY',1,NULL,1,0,'1dOg9wz3SRGVOzM1XEgm3L6Hg7EQCx3c','2025-08-26 22:05:40.432','2025-08-26 22:05:40.432','https://checkout-sbx.dlocalgo.com/validate/subscription/1dOg9wz3SRGVOzM1XEgm3L6Hg7EQCx3c','https://runa-tarot.netlify.app/compras'),(114,'4246',3125,'Runa-Tarot','MONTHLY',1,NULL,1,0,'KhUpcvicaBEPtd8q3PATtUZl8G1jsa4b','2025-08-26 22:08:38.185','2025-08-26 22:08:38.185','https://checkout-sbx.dlocalgo.com/validate/subscription/KhUpcvicaBEPtd8q3PATtUZl8G1jsa4b','http://localhost:5173/compras'),(115,'7651',174490,'Runa-Tarot','MONTHLY',1,NULL,1,0,'tFxhY7KGNqkQroSsHubj4ivklj6q8idb','2025-08-26 22:15:12.595','2025-08-26 22:15:12.595','https://checkout.dlocalgo.com/validate/subscription/tFxhY7KGNqkQroSsHubj4ivklj6q8idb','http://localhost:5173/compras'),(116,'4247',3125,'Runa-Tarot','MONTHLY',1,NULL,1,0,'vcBKhBUQ7t7xVnANAHxTrUOWMvIx0IEj','2025-08-26 22:15:16.551','2025-08-26 22:15:16.551','https://checkout-sbx.dlocalgo.com/validate/subscription/vcBKhBUQ7t7xVnANAHxTrUOWMvIx0IEj','http://localhost:5173/compras'),(117,'4248',3125,'Runa-Tarot','MONTHLY',1,NULL,1,0,'iP4DKzei3hOLlHZr7mozY80xYCC06M8k','2025-08-26 22:21:48.462','2025-08-26 22:21:48.462','https://checkout-sbx.dlocalgo.com/validate/subscription/iP4DKzei3hOLlHZr7mozY80xYCC06M8k','http://localhost:5173/compras'),(118,'4249',3125,'Runa-Tarot','MONTHLY',1,NULL,1,0,'9tr96a03OXTI5lyFNMfHnnQuNOJAuxJQ','2025-08-26 22:25:00.636','2025-08-26 22:25:00.636','https://checkout-sbx.dlocalgo.com/validate/subscription/9tr96a03OXTI5lyFNMfHnnQuNOJAuxJQ','http://localhost:5173/compras'),(119,'4250',3125,'Runa-Tarot','DAILY',1,NULL,1,0,'VLoPuwyXBpb3faxKD4KfnPDsrUpKtZSf','2025-08-27 13:18:27.382','2025-08-27 13:18:27.382','https://checkout-sbx.dlocalgo.com/validate/subscription/VLoPuwyXBpb3faxKD4KfnPDsrUpKtZSf','http://localhost:5173/compras'),(120,'4263',3125,'Suscripción Diaria Test','DAILY',1,NULL,0,0,'IEqEgNTn5sxvsDZIK5gKXQgs3ZbwBkB9','2025-08-28 21:46:39.124','2025-08-28 21:46:39.124','https://checkout-sbx.dlocalgo.com/validate/subscription/IEqEgNTn5sxvsDZIK5gKXQgs3ZbwBkB9','https://runa-hub.multinethost.com/realizar-pago/'),(121,'7779',174490,'Lumina Mensual','MONTHLY',1,NULL,1,0,'MegWKaODanitBwbARSRbLEZqQnEeaQxE','2025-09-01 21:45:26.634','2025-09-01 21:45:26.634','https://checkout.dlocalgo.com/validate/subscription/MegWKaODanitBwbARSRbLEZqQnEeaQxE','https://mkt.topclass.cl/landing-scroll2-lumina'),(122,'4299',3125,'Lumina Mensual','MONTHLY',1,NULL,1,0,'VGxeLEgjIDJN1uirjW0jY6NJqaaWtAMA','2025-09-01 21:45:37.813','2025-09-01 21:45:37.813','https://checkout-sbx.dlocalgo.com/validate/subscription/VGxeLEgjIDJN1uirjW0jY6NJqaaWtAMA','https://mkt.topclass.cl/landing-scroll2-lumina'),(123,'4522',3125,'Suscripción Diaria Test12','DAILY',1,NULL,1,0,'uEGy7oYXlwnSYNuYHvP4afvZYXVf0UXk','2025-09-12 13:06:04.269','2025-09-12 13:06:04.269','https://checkout-sbx.dlocalgo.com/validate/subscription/uEGy7oYXlwnSYNuYHvP4afvZYXVf0UXk','https://runa-hub.multinethost.com/realizar-pago/'),(124,'14604',174490,'CiberClass','MONTHLY',1,NULL,1,0,'VmJ9SC2eGMgXuQUcPE1uQ49tPAT89NT7','2025-10-02 20:55:30.949','2025-10-02 20:55:30.949','https://checkout.dlocalgo.com/validate/subscription/VmJ9SC2eGMgXuQUcPE1uQ49tPAT89NT7','https://www.topclass.academy/pages/cyberclass'),(125,'4687',3125,'Animalia-test','MONTHLY',1,NULL,0,0,'YYE4lX502jWyVhcH7PDpZBRSKPPlOhJE','2025-10-07 20:10:11.800','2025-10-07 20:10:11.800','https://checkout-sbx.dlocalgo.com/validate/subscription/YYE4lX502jWyVhcH7PDpZBRSKPPlOhJE','https://mkt.topclass.cl/landing-scroll-2-animalia-3990/'),(126,'4688',3125,'Animalia-test-1','MONTHLY',1,NULL,1,0,'7WGaGb70d28pOTXXYGtxPi7CtPBgciDQ','2025-10-07 20:11:34.879','2025-10-07 20:11:34.880','https://checkout-sbx.dlocalgo.com/validate/subscription/7WGaGb70d28pOTXXYGtxPi7CtPBgciDQ','https://mkt.topclass.cl/landing-scroll-2-animalia-3990/'),(127,'14809',174490,'Topclass','MONTHLY',1,NULL,1,0,'plTIa92x7f9gUC2IvcfzYsvQ3TJ8m8Sm','2025-10-10 13:50:49.749','2025-10-10 13:50:49.749','https://checkout.dlocalgo.com/validate/subscription/plTIa92x7f9gUC2IvcfzYsvQ3TJ8m8Sm','https://mkt.topclass.cl/cambiodlocal/'),(128,'4724',3125,'Topclass test','MONTHLY',1,NULL,0,0,'IQArZHK7ssswe6yviNsHMW9MEaiYx6J5','2025-10-16 15:04:34.597','2025-10-16 15:04:34.597','https://checkout-sbx.dlocalgo.com/validate/subscription/IQArZHK7ssswe6yviNsHMW9MEaiYx6J5','https://mkt.topclass.cl/cambiodlocal/'),(129,'15097',174490,'Runa Semanal Prueba','WEEKLY',1,NULL,1,0,'4sMAspB9a2uEYtrdXXDeHz1pCZ53avFI','2025-10-20 12:18:12.225','2025-10-20 12:18:12.225','https://checkout.dlocalgo.com/validate/subscription/4sMAspB9a2uEYtrdXXDeHz1pCZ53avFI','https://runa-hub.multinethost.com/realizar-pago/'),(130,'15280',174490,'Lista Mensual','MONTHLY',1,NULL,0,0,'244A3LJIipLCiZOYaivCpzAvp7iOjLgw','2025-10-28 20:21:22.582','2025-10-28 20:21:22.582','https://checkout.dlocalgo.com/validate/subscription/244A3LJIipLCiZOYaivCpzAvp7iOjLgw','https://runa.topclass.academy/realizar-pago/'),(131,'15282',174490,'Lista Mensual','MONTHLY',1,NULL,1,0,'whmvy8q4otg4PLwX6MlsMHtUVIvRoTEL','2025-10-28 20:25:20.731','2025-10-28 20:25:20.731','https://checkout.dlocalgo.com/validate/subscription/whmvy8q4otg4PLwX6MlsMHtUVIvRoTEL','https://runa.topclass.academy/realizar-pago/'),(132,'15283',174490,'Lanzamiento Mensual','MONTHLY',1,NULL,1,0,'GE1j5QLwcr83bKpGWxRAUNhGvK21Y9pL','2025-10-28 20:28:57.083','2025-10-28 20:28:57.083','https://checkout.dlocalgo.com/validate/subscription/GE1j5QLwcr83bKpGWxRAUNhGvK21Y9pL','https://runa.topclass.academy/realizar-pago/'),(133,'15284',174490,'Lista Anual','YEARLY',1,NULL,1,0,'FDn83HGOAtwDjjdYmVhHDMgXFAZXC2DQ','2025-10-28 20:30:33.556','2025-10-28 20:30:33.556','https://checkout.dlocalgo.com/validate/subscription/FDn83HGOAtwDjjdYmVhHDMgXFAZXC2DQ','https://runa.topclass.academy/realizar-pago/'),(134,'15285',174490,'Lanzamiento Anual','YEARLY',1,NULL,1,0,'PU3TIAVGurJclamNjVsUUQhYAP5omvoF','2025-10-28 20:31:14.405','2025-10-28 20:31:14.405','https://checkout.dlocalgo.com/validate/subscription/PU3TIAVGurJclamNjVsUUQhYAP5omvoF','https://runa.topclass.academy/realizar-pago/'),(135,'15559',174490,'Noviembre Mensual','MONTHLY',1,NULL,1,0,'xtKcVZeqLvb3gCPqXhk73WZILMBGOzn8','2025-11-05 14:08:18.489','2025-11-05 14:08:18.489','https://checkout.dlocalgo.com/validate/subscription/xtKcVZeqLvb3gCPqXhk73WZILMBGOzn8','https://runa.topclass.academy/realizar-pago/'),(136,'15560',174490,'Noviembre Anual','YEARLY',1,NULL,1,0,'aLGkD3x2fBp48lWaNklhRuYxkyT85N9C','2025-11-05 14:09:27.246','2025-11-05 14:09:27.246','https://checkout.dlocalgo.com/validate/subscription/aLGkD3x2fBp48lWaNklhRuYxkyT85N9C','https://runa.topclass.academy/realizar-pago/');

--
-- Table structure for table `fake_link`
--

CREATE TABLE `fake_link` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `textPromo` varchar(101) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `url_imgage` varchar(200) DEFAULT NULL,
  `date_from` datetime DEFAULT NULL,
  `date_to` datetime DEFAULT NULL,
  `id_project` int(11) DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `permanent` int(11) DEFAULT NULL,
  `id_transaction` int(11) DEFAULT NULL,
  `date_remove` datetime DEFAULT NULL,
  `currency` varchar(20) DEFAULT '3',
  `Terms_and_Conditions` varchar(1000) DEFAULT NULL,
  `pasarela` varchar(9) DEFAULT NULL,
  `diasPrueba` int(11) DEFAULT NULL,
  `periodicidad` int(11) DEFAULT NULL,
  `metodoPago` varchar(300) DEFAULT NULL,
  `callback` varchar(500) DEFAULT NULL,
  `pass` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fake_link`
--


--
-- Table structure for table `fake_link_field`
--

CREATE TABLE `fake_link_field` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_link` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `column_size` varchar(40) NOT NULL,
  `regular_exp` varchar(200) DEFAULT NULL,
  `required` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_fake_link_field_link` (`id_link`),
  CONSTRAINT `FK_fake_link_field_link` FOREIGN KEY (`id_link`) REFERENCES `fake_link` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fake_link_field`
--


--
-- Table structure for table `fake_transaction_field`
--

CREATE TABLE `fake_transaction_field` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_transaction` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `value` varchar(200) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_fake_transaction_field_trasaction` (`id_transaction`),
  CONSTRAINT `FK_fake_transaction_field_trasaction` FOREIGN KEY (`id_transaction`) REFERENCES `fake_trasaction` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fake_transaction_field`
--


--
-- Table structure for table `fake_trasaction`
--

CREATE TABLE `fake_trasaction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_project` int(11) NOT NULL,
  `type` varchar(14) NOT NULL,
  `date` datetime NOT NULL,
  `id_credential` int(11) NOT NULL,
  `id_state` int(11) NOT NULL,
  `amount` float NOT NULL,
  `id_currency` int(11) NOT NULL,
  `email_user_app` varchar(100) NOT NULL,
  `id_suscription` int(11) DEFAULT NULL,
  `id_link` int(11) DEFAULT NULL,
  `ref_discount` varchar(50) DEFAULT NULL,
  `token_pay` varchar(551) DEFAULT NULL,
  `used` int(11) DEFAULT NULL,
  `baja` int(11) DEFAULT NULL,
  `id_stripeTransaction` varchar(200) DEFAULT NULL,
  `ticketNumber_kushki` varchar(200) DEFAULT NULL,
  `ticketNumber_refund_kushki` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_trasaction_fake_link` (`id_link`),
  CONSTRAINT `FK_trasaction_fake_link` FOREIGN KEY (`id_link`) REFERENCES `fake_link` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fake_trasaction`
--


--
-- Table structure for table `fields_d_local_go`
--

CREATE TABLE `fields_d_local_go` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_d_local_go` varchar(100) NOT NULL,
  `nombre` text,
  `apellido` text,
  `email` text,
  `telefono` text,
  `direccion` text,
  `rut` text,
  `nombre_de_empresa` text,
  `rut_de_empresa` text,
  `giro_de_empresa` text,
  `direccion_de_empresa` text,
  `email_de_empresa` text,
  PRIMARY KEY (`id`),
  KEY `fk_dlocalgo_fields` (`id_d_local_go`),
  CONSTRAINT `fk_dlocalgo_fields` FOREIGN KEY (`id_d_local_go`) REFERENCES `d_local_go` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=464 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `fields_d_local_go`
--

INSERT INTO `fields_d_local_go` VALUES (37,'3475',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'3476',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'DP-99297',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'DP-101199',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'DP-101204',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'DP-101229',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'DP-101230',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'DP-101231',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'DP-101232',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'DP-101244',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'DP-101245',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'DP-101246',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'DP-101247',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,'DP-101248',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'DP-101249',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,'DP-101250',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,'DP-101251',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'DP-101257',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'DP-101270',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'DP-101271',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'DP-101326',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'DP-101340',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'DP-101345',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,'DP-101346',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,'DP-101347',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,'DP-101348',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,'DP-101955',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,'DP-102079',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,'DP-102210',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,'DP-102226',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,'DP-102558',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,'DP-102563',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,'3841',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,'3842',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,'3843',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,'DP-102570',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(73,'DP-102573',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,'DP-102716',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(75,'DP-102718',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,'DP-102723',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,'DP-102724',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(78,'DP-102725',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(79,'DP-102726',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(80,'DP-102728',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,'DP-102731',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(82,'3858',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,'DP-102736',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(84,'DP-102737',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(85,'DP-102738',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(86,'DP-102754',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(87,'DP-102755',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(88,'DP-102830',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(89,'DP-102855',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(90,'DP-102857',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(91,'DP-102867',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(92,'DP-102868',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(93,'DP-102869',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(94,'DP-102870',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(95,'DP-102872',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,'DP-102880',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(97,'DP-103413',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(98,'DP-103416',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(99,'DP-103424',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(100,'DP-103425',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(101,'DP-103428',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(102,'DP-103429',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(103,'DP-103430',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(104,'DP-103435',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,'DP-103436',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(106,'DP-103437',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(107,'DP-103438',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(108,'DP-103439',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(109,'DP-103440',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(110,'DP-103441',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(111,'DP-103442',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(112,'DP-103443',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(113,'DP-103444',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(114,'DP-103445',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(115,'DP-103447',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(116,'DP-103448',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(117,'DP-103449',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(118,'DP-103450',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(119,'DP-103451',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(120,'DP-103455',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(121,'DP-103548',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(122,'DP-103550',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(123,'DP-103552',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(124,'DP-103553',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(125,'DP-103554',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(126,'DP-103555',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(127,'DP-103561',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(128,'DP-103562',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(129,'3878',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(130,'DP-103625',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(131,'DP-103629',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(132,'DP-103630',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(133,'DP-103631',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(134,'DP-103632',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(135,'DP-103633',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(136,'3881',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(137,'3882',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(138,'3883',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(139,'3884',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(140,'DP-103636',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(141,'3885',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(142,'3888',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(143,'3889',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(144,'DP-103721',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(145,'3890',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(146,'3891',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(147,'DP-103742',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(148,'3892',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(149,'DP-103923',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(150,'DP-103992',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(151,'3894',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(152,'3895',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(153,'DP-104012',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(154,'DP-104015',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(155,'DP-104031',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(156,'DP-104088',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(157,'DP-104089',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(158,'DP-104093',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(159,'DP-104095',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(160,'DP-104096',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(161,'6633',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(162,'3917',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(163,'DP-104302',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(164,'3918',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(165,'DP-104772',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(166,'DP-4019556',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(167,'6671',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(168,'3925',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(169,'6675',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(170,'6676',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(171,'3938',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(172,'3939',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(173,'3943',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(174,'6751',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(175,'6752',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(176,'DP-106684',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(177,'DP-106687',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(178,'DP-106688',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(179,'DP-106692',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(180,'DP-106694',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(181,'DP-106695',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(182,'DP-106696',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(183,'DP-106697',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(184,'DP-106698',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(185,'DP-106705',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(186,'DP-106732',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(187,'DP-106733',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(188,'DP-106741',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(189,'DP-106760',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(190,'DP-106858',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(191,'6884',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(192,'6902',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(193,'6906',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(194,'6908',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(195,'DP-107239',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(196,'DP-107240',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(197,'DP-107241',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(198,'DP-107242',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(199,'DP-107376',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(200,'DP-107379',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(201,'DP-107380',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(202,'6955',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(203,'3963',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(204,'3964',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(205,'3965',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(206,'3966',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(207,'3967',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(208,'DP-107408',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(209,'DP-107424',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(210,'3968',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(211,'DP-107841',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(212,'3984',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(213,'7039',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(214,'7040',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(215,'7041',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(216,'7042',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(217,'4008',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(218,'7086',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(219,'4009',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(220,'7087',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(221,'DP-4129714',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(222,'DP-4130026',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(223,'4010',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(224,'4011',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(225,'DP-109496',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(226,'DP-109497',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(227,'DP-109498',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(228,'DP-110587',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(229,'DP-110939',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(230,'DP-110983',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(231,'DP-110985',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(232,'DP-111019',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(233,'DP-111020',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(234,'DP-111021',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(235,'DP-111216',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(236,'DP-111219',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(237,'DP-111222',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(238,'DP-111224',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(239,'DP-111226',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(240,'DP-111233',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(241,'DP-111234',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(242,'4033',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(243,'7329',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(244,'DP-111864',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(245,'DP-111973',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(246,'DP-111989',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(247,'DP-111990',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(248,'7437',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(249,'4081',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(250,'7447',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(251,'7452',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(252,'7454',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(253,'7455',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(254,'7456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(255,'7462',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(256,'7465',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(257,'7466',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(258,'7467',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(259,'7468',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(260,'DP-112553',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(261,'DP-112554',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(262,'DP-112556',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(263,'DP-113283',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(264,'4126',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(265,'4127',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(266,'DP-113583',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(267,'DP-113584',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(268,'DP-113585',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(269,'DP-113589',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(270,'DP-113590',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(271,'DP-113606',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(272,'DP-113607',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(273,'DP-113609',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(274,'DP-113611',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(275,'DP-113622',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(276,'DP-113624',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(277,'DP-113625',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(278,'DP-113626',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(279,'DP-113628',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(280,'DP-113629',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(281,'DP-113630',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(282,'DP-113631',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(283,'DP-113633',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(284,'DP-113635',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(285,'DP-113636',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(286,'DP-113637',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(287,'DP-113639',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(288,'DP-113648',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(289,'DP-113651',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(290,'DP-113659',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(291,'DP-113661',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(292,'DP-113663',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(293,'DP-113667',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(294,'DP-113698',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(295,'DP-113703',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(296,'DP-113725',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(297,'DP-113882',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(298,'DP-113883',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(299,'DP-113885',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(300,'DP-113886',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(301,'DP-113890',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(302,'DP-113891',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(303,'DP-113897',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(304,'DP-113898',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(305,'DP-113899',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(306,'DP-113900',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(307,'7561',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(308,'7562',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(309,'DP-113908',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(310,'4139',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(311,'4141',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(312,'4142',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(313,'4143',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(314,'4144',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(315,'4145',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(316,'4146',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(317,'4147',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(318,'4148',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(319,'4149',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(320,'4150',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(321,'4151',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(322,'4152',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(323,'4153',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(324,'4154',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(325,'4155',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(326,'4156',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(327,'4157',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(328,'4158',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(329,'4159',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(330,'4160',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(331,'4161',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(332,'DP-114184',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(333,'DP-114188',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(334,'DP-114189',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(335,'DP-114194',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(336,'DP-114205',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(337,'DP-114206',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(338,'DP-114209',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(339,'DP-114210',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(340,'DP-114224',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(341,'DP-114225',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(342,'DP-114226',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(343,'DP-114227',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(344,'DP-114228',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(345,'DP-114229',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(346,'DP-114230',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(347,'DP-114243',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(348,'DP-114244',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(349,'DP-114245',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(350,'DP-114246',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(351,'7583',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(352,'7584',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(353,'7585',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(354,'7586',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(355,'7587',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(356,'7588',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(357,'7589',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(358,'7590',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(359,'DP-114402',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(360,'DP-114403',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(361,'DP-114404',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(362,'DP-114405',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(363,'DP-114406',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(364,'DP-114407',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(365,'DP-114412',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(366,'DP-114413',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(367,'DP-114414',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(368,'DP-114415',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(369,'DP-114416',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(370,'DP-114427',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(371,'DP-114428',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(372,'DP-114429',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(373,'DP-114430',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(374,'DP-114431',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(375,'DP-114432',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(376,'DP-114433',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(377,'DP-114434',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(378,'DP-114435',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(379,'DP-114437',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(380,'DP-114438',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(381,'DP-114439',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(382,'DP-114441',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(383,'DP-114442',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(384,'DP-114443',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(385,'DP-114446',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(386,'DP-114447',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(387,'DP-114448',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(388,'DP-114449',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(389,'DP-114450',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(390,'DP-114451',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(391,'DP-114453',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(392,'DP-114455',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(393,'DP-114457',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(394,'DP-114547',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(395,'DP-114985',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(396,'DP-114989',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(397,'DP-115186',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(398,'4244',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(399,'DP-115215',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(400,'DP-115227',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(401,'DP-115243',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(402,'DP-115246',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(403,'7649',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(404,'DP-115250',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(405,'DP-115251',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(406,'7650',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(407,'4245',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(408,'4246',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(409,'7651',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(410,'4247',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(411,'4248',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(412,'4249',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(413,'4250',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(414,'4263',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(415,'DP-116424',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(416,'DP-116425',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(417,'DP-116429',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(418,'DP-116430',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(419,'DP-116431',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(420,'DP-116434',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(421,'DP-116435',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(422,'DP-116436',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(423,'DP-116438',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(424,'DP-116494',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(425,'7779',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(426,'4299',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(427,'DP-116498',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(428,'DP-116500',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(429,'DP-116502',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(430,'DP-116504',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(431,'DP-116506',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(432,'DP-116507',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(433,'DP-116508',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(434,'DP-116509',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(435,'DP-116596',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(436,'DP-116609',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(437,'DP-116610',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(438,'DP-116693',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(439,'4522',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(440,'DP-121614',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(441,'DP-121617',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(442,'DP-121895',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(443,'DP-121896',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(444,'DP-121898',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(445,'DP-122053',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(446,'DP-122057',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(447,'DP-122075',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(448,'DP-122076',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(449,'DP-122077',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(450,'DP-122078',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(451,'14604',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(452,'4687',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(453,'4688',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(454,'14809',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(455,'4724',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(456,'15097',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(457,'15280',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(458,'15282',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(459,'15283',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(460,'15284',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(461,'15285',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(462,'15559',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(463,'15560',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `link`
--

CREATE TABLE `link` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `textPromo` varchar(101) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `url_imgage` varchar(200) DEFAULT NULL,
  `date_from` datetime DEFAULT NULL,
  `date_to` datetime DEFAULT NULL,
  `id_project` int(11) DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `permanent` int(11) DEFAULT NULL,
  `id_transaction` int(11) DEFAULT NULL,
  `date_remove` datetime DEFAULT NULL,
  `currency` varchar(20) DEFAULT '3',
  `Terms_and_Conditions` varchar(1000) DEFAULT NULL,
  `pasarela` varchar(9) DEFAULT NULL,
  `diasPrueba` int(11) DEFAULT NULL,
  `periodicidad` int(11) DEFAULT NULL,
  `metodoPago` varchar(300) DEFAULT NULL,
  `callback` varchar(500) DEFAULT NULL,
  `pass` varchar(8) DEFAULT NULL,
  `currencyString` varchar(8) DEFAULT NULL,
  `priceString` varchar(60) DEFAULT NULL,
  `enableDiscount` int(11) NOT NULL DEFAULT '0',
  `product_stripeString` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=651 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `link`
--

INSERT INTO `link` VALUES (620,'Test prod','Texto promocional','Descripcion del producto',1,'/warehouse/1644589228200.png','2022-02-06 00:00:00',NULL,317,500,1,1811,NULL,'3','Test','[2]',NULL,NULL,'[1]','https://www.topclass.academy/users/sign_in','Xl5RS7no','CLP','price_1KYVmqHzUFhQBekohW4GZxy6',1,'prod_LEzmeEy5LnO1NX'),(621,'Test prod','Texto promocional','test',2,'/warehouse/1646255211726.png','2022-03-01 00:00:00',NULL,317,500,1,1815,'2022-04-25 20:50:02','3','Test','[2]',NULL,1,'[1]','https://www.topclass.academy/users/sign_in','oNwcKErz','CLP','price_1KYzQsHzUFhQBekoLBSlzhfm',0,'prod_LFUPFYWQqzN0qb'),(622,'cl_sus','cl_sus','cl_sus',2,'/warehouse/1646330767746.png','2022-03-01 00:00:00',NULL,317,400,1,1829,NULL,'3','Test','[2]',NULL,1,'[1]','https://www.topclass.academy/','sRa0nRMG','CLP','price_1KZJDyHzUFhQBekoKFfXJST6',0,'prod_LForGJ1mPCBwfk'),(623,'Topclass Colombia','Topclass Colombia','Topclass Colombia',1,'/warehouse/1646338080760.png','2022-03-03 17:08:53',NULL,318,2000,0,NULL,NULL,'29','colombia','[2]',NULL,NULL,'[1]','https://www.topclass.academy/','AjHT5aRu','COP','price_1KZKxGEIHjJlosBdJrdUwONr',0,'prod_LFqeCmKKr4kc1M'),(624,'test Mood','testMood','testMood',2,'/warehouse/1648647377592.jpeg','2022-03-30 10:36:55',NULL,317,500,1,1828,NULL,'3','Test','[2]',NULL,1,'[1]','https://google.cl/payment','mQS6PgEX','CLP','price_1Kj1hkHzUFhQBekorsZQKfdW',0,'prod_LPrQOUIfSllZEt'),(625,'test-cl','test-cl','test-cl',2,'/warehouse/1650578149483.png','2022-04-20 20:00:00',NULL,317,400,1,1838,NULL,'3','Test','[2]',NULL,1,'[1]','https://google.cl/payment','8ecfWPXv','CLP','price_1Kr81OHzUFhQBekoDL67ko8F',0,'prod_LYEUN7Ja9Pc9zP'),(626,'Test-cl2','Test-cl2','Test-cl2',2,'/warehouse/1650919702500.png','2022-04-23 00:00:00',NULL,317,600,1,1852,NULL,'3','Test','[2]',NULL,1,'[1]','https://google.cl/payment','A94jFEB4','CLP','price_1Kttp2HzUFhQBekoMPu0ParZ',0,'prod_Lb613tS6mKf0f4'),(627,'test dev local','test dev local','test dev local',1,'/warehouse/1652449319357.png','2022-05-13 09:42:38',NULL,317,988,1,NULL,NULL,'3','Test','[2]',NULL,NULL,'[1]','https://www.google.com','P0pCGQuy','CLP','price_1KyylPHzUFhQBekoQoL38G6A',0,'prod_LgLS5HhKnG9FDb'),(628,'test test','promocion','test bueno',1,'/warehouse/1747746205424.jpeg','2025-05-19 20:00:00',NULL,317,1000,1,NULL,NULL,'3','Test','[2]',NULL,NULL,'[1]','https://www.google.com','AmeWGtYP','CLP','price_1RQpulHzUFhQBekoKkFpZHIY',0,'prod_SLWyPHVzfOCtEx'),(629,'test localGo','promocion localGo','lo mejor de localGo',1,'/warehouse/1747747100175.jpeg','2025-05-19 20:00:00',NULL,331,10,1,NULL,NULL,'137','Test8','[4]',NULL,NULL,'[2]','http://172.18.0.7:8080/dashboard/ecommerce','CuHDlk0v','USD',NULL,0,NULL),(630,'adsad','asdasd','adasd',1,'/warehouse/1747747649536.jpeg','2025-05-19 20:00:00',NULL,317,3000,1,NULL,NULL,'3','Test','[2]',NULL,NULL,'[1]','https://www.google.com','nwRnCDRd','CLP','price_1RQqD7HzUFhQBekoBiJQBzDv',0,'prod_SLXH4b4A7ymuRt'),(631,'test2 localGo','adasd','hola',1,'/warehouse/1748388144028.jpeg','2025-05-26 20:00:00',NULL,331,15,1,NULL,NULL,'137','Test8','[4]',NULL,NULL,'[1,2]','https://www.google.com','hO8i2TNM','USD',NULL,0,NULL),(632,'test3 localGo','test3','test3',1,'/warehouse/1748440641865.jpeg','2025-05-27 20:00:00',NULL,331,15,1,NULL,NULL,'137','Test8','[4]',NULL,NULL,'[1,2]','https://www.google.com','FBO2HSm1','USD',NULL,0,NULL),(633,'test fran','fran','test fran descripcion',1,'/warehouse/1748525413725.jpeg','2025-05-28 20:00:00',NULL,331,20,1,NULL,NULL,'137','Test8','[4]',NULL,NULL,'[1,2]','http://fran.back','Y9mZhP1f','USD',NULL,0,NULL),(634,'test4 localGo','Danger tests','Un producto muy bueno',1,'/warehouse/1748525555593.jpeg','2025-05-28 20:00:00',NULL,331,25,1,NULL,'2025-05-29 13:46:30','137','Test8','[4]',NULL,NULL,'[2]','https://test.com','IRlIz4WP','USD',NULL,0,NULL),(635,'test4 localGo','Tests para ver data','Todo facil',1,'/warehouse/1748526418895.jpeg','2025-05-28 20:00:00',NULL,331,32,1,NULL,NULL,'137','Test8','[4]',NULL,NULL,'[2]','https://test.com','j0A4lRKE','USD',NULL,0,NULL),(636,'test5 localGo','Tests para ver data','Todo facil',1,'/warehouse/1748526418895.jpeg','2025-05-28 20:00:00',NULL,331,32,1,NULL,NULL,'137','Test8','[4]',NULL,NULL,'[2]','https://test.com','dvnibDrH','USD','fake_price_1748527956045',0,'fake_product_1748527956045'),(637,'test7 localGo','Tests para ver data','Todo facil',1,'','2025-05-28 20:00:00',NULL,331,32,1,NULL,NULL,'137','Test8','[4]',NULL,NULL,'[2]','https://test.com','YH900RfG','USD','fake_price_1748528586212',0,'fake_product_1748528586212'),(638,'test8 localGo','Tests para ver data','Todo facil',1,'','2025-05-28 20:00:00',NULL,331,32,1,NULL,NULL,'137','Test8','4',NULL,NULL,'2','https://test.com','Kks4vj2N','USD','fake_price_1748528731049',0,'fake_product_1748528731049'),(639,'test9 localGo','Tests para ver data','Todo facil',1,'','2025-05-28 20:00:00',NULL,331,32,1,NULL,NULL,'137','Test8','4',NULL,NULL,'2','https://test.com','Ea6ZC1eH','USD','fake_price_1748528818034',0,'fake_product_1748528818034'),(640,'test10 localGo','Tests para ver data','Todo facil',1,'','2025-05-28 20:00:00',NULL,331,32,1,NULL,NULL,'137','Test8','[4]',NULL,NULL,'[2]','https://test.com','2PJ8cgrU','USD','fake_price_1748529006768',0,'fake_product_1748529006768'),(641,'test11 localGo','Tests para ver data','Todo facil',1,'','2025-05-28 20:00:00',NULL,331,32,1,NULL,NULL,'137','Test8','[4]',NULL,NULL,'[2]','https://test.com','vjtPOjcw','USD','fake_price_1748529543925',0,'fake_product_1748529543925'),(642,'test12 localGo','Tests para ver data','Todo facil',1,'','2025-05-28 20:00:00',NULL,331,32,1,NULL,NULL,'137','Test8','[4]',NULL,NULL,'[2]','https://test.com','3wDZpVEh','USD','fake_price_1748529677031',0,'fake_product_1748529677031'),(643,'test13 localGo','Tests para ver data','Todo facil',1,'','2025-05-29 15:05:15',NULL,331,32,1,NULL,NULL,'137','Test8','[4]',NULL,NULL,'[2]','https://test.com','2WFm1NJL','USD','fake_price_1748531115342',0,'fake_product_1748531115342'),(644,'test14 localGo','Tests para ver data','Todo facil',1,'','2025-05-29 15:34:58',NULL,331,32,1,NULL,NULL,'137','Test8','[4]',NULL,NULL,'[2]','https://test.com','9scfIQLi','USD','fake_price_1748532898677',0,'fake_product_1748532898677'),(645,'test suscrip','suscrip','esto es una suscrip',2,'/warehouse/1748532965187.jpeg','2025-05-28 20:00:00',NULL,331,32,1,NULL,NULL,'137','Test8','[4]',NULL,4,'[1,2]','https://testsucrip.com','mLGYASZU','USD',NULL,0,NULL),(646,'test15 localGo','Tests para ver data','Todo facil',2,'','2025-05-29 15:40:28',NULL,331,32,1,NULL,NULL,'137','Test8','[4]',NULL,4,'[2]','https://test.com','x9472Fb0','USD','fake_price_1748533228117',0,'fake_product_1748533228117'),(647,'test15 localGo','Tests para ver data','Todo facil',1,'','2025-05-29 15:40:40',NULL,331,32,1,NULL,NULL,'137','Test8','[4]',NULL,NULL,'[2]','https://test.com','8zEXI2DQ','USD','fake_price_1748533240990',0,'fake_product_1748533240990'),(648,'test15 localGo','Tests para ver data','Todo facil',1,'','2025-05-29 17:22:18',NULL,331,32,1,NULL,NULL,'137','Test8','[4]',NULL,NULL,'[2]','https://test.com','wieSTIDn','USD','fake_price_1748539338913',0,'fake_product_1748539338913'),(649,'test1 localGo suscrip','suscript','adfasdasd',2,'/warehouse/1748871567457.jpeg','2025-06-01 20:00:00',NULL,331,25,1,NULL,NULL,'137','Test8','[4]',NULL,1,'[2,1]','https://www.google.com/','EBJAydTl','USD',NULL,0,NULL),(650,'test15 localGo','Tests para ver data','Todo facil',1,'/warehouse/1748970599505.jpeg','2025-06-03 17:10:19',NULL,331,32,1,NULL,NULL,'137','Test8','[4]',NULL,NULL,'[2]','https://test.com','ePKHL2u2','USD','fake_price_1748970619512',0,'fake_product_1748970619512');

--
-- Table structure for table `link_field`
--

CREATE TABLE `link_field` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_link` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `column_size` varchar(40) NOT NULL,
  `regular_exp` varchar(200) DEFAULT NULL,
  `required` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_link_field_link` (`id_link`),
  CONSTRAINT `FK_link_field_link` FOREIGN KEY (`id_link`) REFERENCES `link` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1077 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `link_field`
--

INSERT INTO `link_field` VALUES (975,620,'Nombre','col-12','regular',1),(976,620,'Email','col-12','regular',1),(980,621,'Nombre','col-12','regular',1),(981,621,'Apellido','col-12','regular',1),(982,621,'Email','col-12','regular',1),(986,622,'Email','col-12','regular',1),(987,623,'Email','col-12','regular',1),(988,624,'Email','col-12','regular',1),(989,624,'Nombre','col-12','regular',1),(990,625,'Apellido','col-12','regular',1),(991,625,'Nombre','col-12','regular',1),(998,626,'Nombre','col-12','regular',1),(999,626,'Apellido','col-12','regular',1),(1000,626,'Email','col-12','regular',1),(1001,627,'Apellido','col-12','regular',1),(1002,627,'Nombre','col-12','regular',1),(1003,627,'Email','col-12','regular',1),(1004,628,'Email','col-12','regular',1),(1005,628,'Nombre','col-12','regular',1),(1006,629,'Email','col-12','regular',1),(1007,629,'Apellido','col-12','regular',1),(1008,629,'Nombre','col-12','regular',1),(1009,630,'Apellido','col-12','regular',1),(1010,630,'Nombre','col-12','regular',1),(1011,630,'Email','col-12','regular',1),(1012,631,'Email','col-12','regular',1),(1013,631,'Apellido','col-12','regular',1),(1014,631,'Nombre','col-12','regular',1),(1015,632,'Email de Empresa','col-12','regular',1),(1016,632,'RUT de Empresa','col-12','regular',1),(1017,632,'Dirección de Empresa','col-12','regular',1),(1018,632,'Giro de Empresa','col-12','regular',1),(1019,632,'Email','col-12','regular',1),(1020,632,'Apellido','col-12','regular',1),(1021,632,'Nombre','col-12','regular',1),(1022,632,'Teléfono','col-12','regular',1),(1023,632,'Nombre de Empresa','col-12','regular',1),(1024,632,'RUT','col-12','regular',1),(1025,632,'Dirección','col-12','regular',1),(1026,633,'Nombre','col-12','regular',1),(1027,633,'Apellido','col-12','regular',1),(1028,633,'Email','col-12','regular',1),(1029,633,'Teléfono','col-12','regular',1),(1030,634,'Nombre','col-12','regular',1),(1031,634,'Apellido','col-12','regular',1),(1032,634,'Teléfono','col-12','regular',1),(1033,634,'Email','col-12','regular',1),(1034,635,'Email','col-12','regular',1),(1035,635,'Teléfono','col-12','regular',1),(1036,636,'Email','col-12','regular',1),(1037,636,'Teléfono','col-12','regular',1),(1038,637,'Email','col-12','regular',1),(1039,637,'Teléfono','col-12','regular',1),(1040,638,'Email','col-12','regular',1),(1041,638,'Teléfono','col-12','regular',1),(1042,639,'Email','col-12','regular',1),(1043,639,'Teléfono','col-12','regular',1),(1044,640,'Email','col-12','regular',1),(1045,640,'Teléfono','col-12','regular',1),(1046,642,'RUT','col-12','regular',1),(1047,642,'Email','col-12','regular',1),(1048,642,'Teléfono','col-12','regular',1),(1049,643,'Email','col-12','regular',1),(1050,643,'RUT','col-12','regular',1),(1051,643,'Nombre','col-12','regular',1),(1052,643,'Teléfono','col-12','regular',1),(1053,644,'Email','col-12','regular',1),(1054,644,'Teléfono','col-12','regular',1),(1055,644,'RUT','col-12','regular',1),(1056,644,'Nombre','col-12','regular',1),(1057,645,'Nombre','col-12','regular',1),(1058,646,'Email','col-12','regular',1),(1059,646,'Nombre','col-12','regular',1),(1060,646,'RUT','col-12','regular',1),(1061,646,'Teléfono','col-12','regular',1),(1062,647,'Nombre','col-12','regular',1),(1063,647,'Teléfono','col-12','regular',1),(1064,647,'Email','col-12','regular',1),(1065,647,'RUT','col-12','regular',1),(1066,648,'Email','col-12','regular',1),(1067,648,'RUT','col-12','regular',1),(1068,648,'Nombre','col-12','regular',1),(1069,648,'Teléfono','col-12','regular',1),(1070,649,'Email','col-12','regular',1),(1071,649,'Nombre','col-12','regular',1),(1072,649,'Apellido','col-12','regular',1),(1073,650,'Email','col-12','regular',1),(1074,650,'RUT','col-12','regular',1),(1075,650,'Teléfono','col-12','regular',1),(1076,650,'Nombre','col-12','regular',1);

--
-- Table structure for table `origin`
--

CREATE TABLE `origin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `origin` varchar(255) NOT NULL,
  `active_url_prod` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `origin`
--

INSERT INTO `origin` VALUES (1,'thinkific',1),(2,'runa-tarot',0),(3,'runa-contenidos',1),(4,'thinkific-test',0);

--
-- Table structure for table `project`
--

CREATE TABLE `project` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `card_enable` int(11) NOT NULL,
  `trasfer_enable` int(11) NOT NULL,
  `cash_enable` int(11) NOT NULL,
  `suscription_enable` int(11) NOT NULL,
  `link_enable` int(11) NOT NULL,
  `discount_enable` int(11) NOT NULL,
  `date_rm` datetime DEFAULT NULL,
  `id_currency` int(11) DEFAULT NULL,
  `Terms_and_Conditions` varchar(400) DEFAULT NULL,
  `movistar_enable` int(11) DEFAULT NULL,
  `entel_enable` int(11) DEFAULT NULL,
  `url_discount` varchar(500) DEFAULT NULL,
  `apikey` varchar(120) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=332 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `project`
--

INSERT INTO `project` VALUES (316,'Tarot',1,1,1,1,1,1,NULL,3,'Prueba',0,0,'','eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MzE2LCJpYXQiOjE2NDQyNzEzNjZ9.8YHYJcSbm47GpIclPkMMXaKR7cf-8ksH1UI7lBWVjpc'),(317,'Test prod',1,0,0,1,1,1,NULL,3,'Test',0,0,'','eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MzE3LCJpYXQiOjE3NDc0MDc1MjF9.c4CUxY8h6Rs4UTHKI4HmsaTnyJVsScU3WHSjzT2xgvA'),(318,'Colombia',1,0,0,1,1,1,NULL,29,'colombia',0,0,'','eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MzE4LCJpYXQiOjE2NDYzMzgwMjl9.6RSM_IxVArKPU-wRGCGdeMM-xkPrhNNBt1pj7ggJ-p4'),(319,'test dLocalGo',1,0,0,0,1,0,'2025-05-19 14:41:33',137,'Producto para pago con dLocalGo',0,0,'','eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MzE5LCJpYXQiOjE3NDc0MTc5ODB9.-LKmpSmJwFUDSyAmwhT4etPEKd5NZ3J1sVG8Vk8wgok'),(320,'dLocalGo',1,0,0,0,1,0,'2025-05-19 15:17:26',137,'Hola test',0,0,'','eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MzIwLCJpYXQiOjE3NDc2NjU4MDJ9.GtCz89mitYVBmftdV-hleqor7jZNRKxt3V4MRM-seIo'),(321,'dLocalGo 1',1,0,0,0,1,0,'2025-05-19 15:19:56',137,'test de pasarela',0,0,'','eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MzIxLCJpYXQiOjE3NDc2Njc5MDZ9.ZPfQV0w536mBMCSjx13rJC3fKCmOry1OYDgBoA3HQbI'),(322,'dLocalGo2',1,0,0,0,1,0,'2025-05-19 15:23:52',137,'Hola',0,0,'','eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MzIyLCJpYXQiOjE3NDc2NjgwMTd9.BPLEleFVNmoZGt1UiWbxM_UWKUUXjuU-L7w0Kdg7Mko'),(323,'dLocalGo3',1,0,0,0,1,0,'2025-05-19 16:21:57',137,'hola test',0,0,'','eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MzIzLCJpYXQiOjE3NDc2NjgyNTl9.J1jkroBCkkO4L4fYiX8_P7P_h2Ct5vdVLuc3_UtPXNA'),(324,'dLocalGo4',1,0,0,0,1,0,'2025-05-19 16:22:03',137,'test',0,0,'','eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MzI0LCJpYXQiOjE3NDc2NjgzNTR9.sUcbGMD8of3PFvG2QDdwZ9J9L9PP9SW4uE-7vUdsqxc'),(325,'Danger Raul',1,0,0,0,1,0,'2025-05-19 16:22:07',137,'asdasd',0,0,'','eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MzI1LCJpYXQiOjE3NDc2NzAxMTl9.GcYBVrZy6nGlAwzy1q72D7Ix02ujMtNLCJPHIW1wMIM'),(326,'Messenger',1,0,0,0,1,0,'2025-05-19 16:22:11',137,'asdsad',0,0,'','eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MzI2LCJpYXQiOjE3NDc2NzAyNDB9.LN7LpQIBzDtSJbSPop7Cf9wVab9IgK7b-KgfhmvSj1o'),(327,'gracias',1,0,0,0,1,0,'2025-05-19 16:21:49',137,'\ndfgfds',0,0,'','eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MzI3LCJpYXQiOjE3NDc2NzAzMjh9.SV9lKwX83BCPq6zrVZYeZP_RkIZ5oi4hL7cnAXuk-Vg'),(328,'dLocalGo5',1,0,0,0,1,0,'2025-05-19 16:21:44',137,'test dLocalGo',0,0,'','eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MzI4LCJpYXQiOjE3NDc2NzA1OTN9.dvwvaJh3zt7O12dO7SzU7Gm6hCEYblHB4WSzflofx0Q'),(329,'dLocalGo6',1,0,0,0,1,0,'2025-05-19 16:30:51',137,'test 6',0,0,'','eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MzI5LCJpYXQiOjE3NDc2NzE3OTl9.1sg0PuazndcMJyMzf7X-J-kt-rqwVmYXjezphLBtOfo'),(330,'dLocalGo7',1,0,0,0,1,0,'2025-05-19 16:49:39',137,'test 7',0,0,'','eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MzMwLCJpYXQiOjE3NDc2NzIyNzd9.LQeuf1Z8VHM091mUm1lCQgGU18N6ShIyD_gt4oXK3Nc'),(331,'dLocalGo8',1,0,0,0,1,0,NULL,137,'Test8',0,0,'','eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6MzMxLCJpYXQiOjE3NDc2NzM0MTJ9.QmDESETo_-mPd12HJy7EAJKV79I8BvqwZO7bviMlB6w');

--
-- Table structure for table `project_country`
--

CREATE TABLE `project_country` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_project` int(11) NOT NULL,
  `id_country` varchar(3) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_project_country_project` (`id_project`),
  CONSTRAINT `FK_project_country_project` FOREIGN KEY (`id_project`) REFERENCES `project` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `project_country`
--


--
-- Table structure for table `project_credential`
--

CREATE TABLE `project_credential` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_project` int(11) NOT NULL,
  `id_gateway` int(11) NOT NULL,
  `credentials` varchar(1000) NOT NULL,
  `showCredentials` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_project_credential_idx` (`id_project`)
) ENGINE=InnoDB AUTO_INCREMENT=380 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `project_credential`
--

INSERT INTO `project_credential` VALUES (365,316,2,'{\"publicKey\":\"pk_test_51JO1lMEIHjJlosBdz4FmJyMrjfoBqrZpkHfszgumyguUDdwbvsDPWM8dzFLBJHjzNjRWDhn4IIErfZ81zcST7DUL00hHM2W7gS\",\"privateKey\":\"sk_test_51JO1lMEIHjJlosBdWXdbfoEEg4VguHnQHSaXk7jqUtd8T7nB0s8uofE8zLcEXoZIHrtil6QuToGpTLwwanJASxpC00sOG1Yt7n\"}',1),(366,316,1,'{\"publicKey\":\"7d0ec62a12ac4f678bb5fe4f6a5c20cd\",\"privateKey\":\"d17745e0dfce4b2bb0c1729a462cd18d\"}',1),(367,317,2,'{\"publicKey\":\"pk_live_f9CbXJsAoDLtN2aWYTbEYaoi00rGS2Amn4\",\"privateKey\":\"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\"}',1),(368,318,2,'{\"publicKey\":\"pk_test_51JO1lMEIHjJlosBdz4FmJyMrjfoBqrZpkHfszgumyguUDdwbvsDPWM8dzFLBJHjzNjRWDhn4IIErfZ81zcST7DUL00hHM2W7gS\",\"privateKey\":\"sk_test_51JO1lMEIHjJlosBdWXdbfoEEg4VguHnQHSaXk7jqUtd8T7nB0s8uofE8zLcEXoZIHrtil6QuToGpTLwwanJASxpC00sOG1Yt7n\"}',1),(369,321,1,'{\"publicKey\":\"eoggkYCpeKDbRUvteiXMZcklSGNVstdJ\",\"privateKey\":\"HqL90d46Bqo3Gi0BqaXEplzc26FDKVi7TbDtDWFx\"}',1),(370,322,1,'{\"publicKey\":\"eoggkYCpeKDbRUvteiXMZcklSGNVstdJ\",\"privateKey\":\"HqL90d46Bqo3Gi0BqaXEplzc26FDKVi7TbDtDWFx\"}',1),(371,323,1,'{\"publicKey\":\"eoggkYCpeKDbRUvteiXMZcklSGNVstdJ\",\"privateKey\":\"HqL90d46Bqo3Gi0BqaXEplzc26FDKVi7TbDtDWFx\"}',1),(372,324,1,'{\"publicKey\":\"eoggkYCpeKDbRUvteiXMZcklSGNVstdJ\",\"privateKey\":\"HqL90d46Bqo3Gi0BqaXEplzc26FDKVi7TbDtDWFx\"}',1),(373,325,3,'{\"publicKey\":\"eoggkYCpeKDbRUvteiXMZcklSGNVstdJ\",\"privateKey\":\"HqL90d46Bqo3Gi0BqaXEplzc26FDKVi7TbDtDWFx\"}',1),(374,326,3,'{\"publicKey\":\"eoggkYCpeKDbRUvteiXMZcklSGNVstdJ\",\"privateKey\":\"HqL90d46Bqo3Gi0BqaXEplzc26FDKVi7TbDtDWFx\"}',1),(375,327,3,'{\"publicKey\":\"eoggkYCpeKDbRUvteiXMZcklSGNVstdJ\",\"privateKey\":\"HqL90d46Bqo3Gi0BqaXEplzc26FDKVi7TbDtDWFx\"}',1),(376,328,4,'{\"publicKey\":\"eoggkYCpeKDbRUvteiXMZcklSGNVstdJ\",\"privateKey\":\"HqL90d46Bqo3Gi0BqaXEplzc26FDKVi7TbDtDWFx\"}',1),(379,331,4,'{\"publicKey\":\"eoggkYCpeKDbRUvteiXMZcklSGNVstdJ\",\"privateKey\":\"HqL90d46Bqo3Gi0BqaXEplzc26FDKVi7TbDtDWFx\"}',1);

--
-- Table structure for table `project_currency`
--

CREATE TABLE `project_currency` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_project` int(11) DEFAULT NULL,
  `id_currency_ref` int(11) DEFAULT NULL,
  `equivalent_amount` float DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_project_currency_project` (`id_project`),
  CONSTRAINT `FK_project_currency_project` FOREIGN KEY (`id_project`) REFERENCES `project` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `project_currency`
--


--
-- Table structure for table `refund`
--

CREATE TABLE `refund` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_transaction` int(11) NOT NULL,
  `amount` float NOT NULL,
  `date` datetime NOT NULL,
  `description` varchar(200) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_refund_trasaction` (`id_transaction`),
  CONSTRAINT `FK_refund_trasaction` FOREIGN KEY (`id_transaction`) REFERENCES `trasaction` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `refund`
--


--
-- Table structure for table `suscription_mobile`
--

CREATE TABLE `suscription_mobile` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_project` int(11) DEFAULT NULL,
  `keyaccess` varchar(45) NOT NULL,
  `amount` int(11) NOT NULL,
  `baja` int(11) DEFAULT '0',
  `entelredirect__op` varchar(45) NOT NULL,
  `entelredirect__stype` varchar(45) NOT NULL,
  `entelsusc__text` varchar(45) NOT NULL,
  `entelsusc__to` varchar(45) NOT NULL,
  `entelsusc__application_id` varchar(45) NOT NULL,
  `entelsusc__source` varchar(45) NOT NULL,
  `movistarencode__text` varchar(400) NOT NULL,
  `movistargen__idProduct` varchar(45) NOT NULL,
  `movistarsusc__idProduct` varchar(45) NOT NULL,
  `movistarsusc__deviceId` varchar(45) NOT NULL,
  `movistarsusc__source` varchar(45) NOT NULL,
  `movistarsusc__secondExternalId` varchar(45) NOT NULL,
  `movistarsusc__aliasMovistar` varchar(45) NOT NULL,
  `redirect_url` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `suscription_mobile`
--


--
-- Table structure for table `suscription_mobile_network`
--

CREATE TABLE `suscription_mobile_network` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_suscription` int(11) DEFAULT NULL,
  `name` varchar(45) DEFAULT NULL,
  `param` varchar(45) DEFAULT NULL,
  `type_webhook` varchar(5) DEFAULT NULL,
  `webhook` varchar(500) DEFAULT NULL,
  `source` varchar(45) DEFAULT NULL,
  `acceskey` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `suscription_mobile_network`
--


--
-- Table structure for table `suscription_mobile_operator`
--

CREATE TABLE `suscription_mobile_operator` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `external_id` int(11) DEFAULT NULL,
  `nombre` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `suscription_mobile_operator`
--

INSERT INTO `suscription_mobile_operator` VALUES (1,2,'Entel'),(2,5,'Movistar'),(3,6,'WOM');

--
-- Table structure for table `suscription_mobile_tr`
--

CREATE TABLE `suscription_mobile_tr` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_suscription` varchar(45) DEFAULT NULL,
  `id_ref` varchar(45) DEFAULT NULL,
  `json` varchar(1000) DEFAULT NULL,
  `moment` datetime DEFAULT CURRENT_TIMESTAMP,
  `amount` int(11) DEFAULT NULL,
  `id_conf` int(11) DEFAULT NULL,
  `id_network` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `suscription_mobile_tr`
--


--
-- Table structure for table `suscription_mobile_wh`
--

CREATE TABLE `suscription_mobile_wh` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `json` varchar(1000) DEFAULT NULL,
  `moment` datetime DEFAULT CURRENT_TIMESTAMP,
  `id_sm` int(11) DEFAULT NULL,
  `id_ntw` int(11) DEFAULT NULL,
  `id_tr` int(11) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `number` varchar(45) DEFAULT NULL,
  `action` varchar(45) DEFAULT NULL,
  `id_project` int(11) DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  `id_operador` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `suscription_mobile_wh`
--


--
-- Table structure for table `suscription_user`
--

CREATE TABLE `suscription_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_project` int(11) NOT NULL,
  `email_user_app` varchar(100) NOT NULL,
  `date_remove` datetime DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  `date_create` datetime DEFAULT NULL,
  `number_of_days` int(11) DEFAULT NULL,
  `number_of_months` int(11) DEFAULT NULL,
  `periodicidad` int(11) DEFAULT NULL,
  `diasPrueba` int(11) DEFAULT NULL,
  `baja` int(11) DEFAULT NULL,
  `suscription_string` varchar(100) DEFAULT NULL,
  `customer_string` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_suscription_user_project` (`id_project`),
  CONSTRAINT `FK_suscription_user_project` FOREIGN KEY (`id_project`) REFERENCES `project` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=516 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `suscription_user`
--

INSERT INTO `suscription_user` VALUES (481,317,'jggt16@gmail.com',NULL,50,'estefany jimenez','test','2022-03-02 21:13:53',1,1,1,NULL,0,'sub_1KYzUfHzUFhQBeko846fGWhI','cus_LFUTeUS1uKHsN3'),(482,317,'dovalle@celcom.cl',NULL,500,'estefany jimenez','test','2022-03-03 13:38:35',1,1,1,NULL,0,'sub_1KZEraHzUFhQBekovMlPA2pU','cus_LFkMCzK6cFFeo3'),(483,317,'prueba-pago-suscripcion@gmail.com',NULL,500,'estefany jimenez','test','2022-03-03 14:39:12',1,1,1,NULL,0,'sub_1KZFoFHzUFhQBekoo4rpWZmk','cus_LFlKHYyaS62oWO'),(484,317,'pago-suscripcion@gmail.com',NULL,500,'estefany jimenez','test','2022-03-03 14:50:22',1,1,1,NULL,0,'sub_1KZFz3HzUFhQBekomvrxdOLf','cus_LFlWtyVrQ2IQRt'),(485,317,'prueba-pago-suscripcion-hookin@gmail.com',NULL,500,'estefany jimenez','test','2022-03-03 14:59:52',1,1,1,NULL,0,'sub_1KZG8GHzUFhQBeko7xy3Fyjw','cus_LFlfxHfsPiiavU'),(486,317,'prueba-pago-suscripcion222@gmail.com',NULL,500,'estefany jimenez','test','2022-03-03 15:09:21',1,1,1,NULL,0,'sub_1KZGHRHzUFhQBekoOAmY6IfU','cus_LFlpXNA1nLzJdc'),(487,317,'dovalle@celcom.cl',NULL,400,'daniel','cl_sus','2022-03-03 18:18:57',1,1,1,NULL,0,'sub_1KZJEuHzUFhQBekoFvy37AdA','cus_LFosxfQvZzzzzT'),(488,317,'jgonzalez@celcom.cl',NULL,400,'estefany jimenez','cl_sus','2022-03-03 19:34:26',1,1,1,NULL,0,'sub_1KZKPxHzUFhQBeko1TUK0fyc','cus_LFq6F4ZBZBlWOB'),(489,317,'Deymos8.548@gmail.com',NULL,400,'estefany jimenez','cl_sus','2022-03-03 19:46:34',1,1,1,NULL,0,'sub_1KZKbhHzUFhQBekoBacdHyHS','cus_LFqIquA39disCq'),(490,317,'dovalle@celcom.cl',NULL,400,'daniel','cl_sus','2022-03-30 13:21:50',1,1,1,NULL,0,'sub_1Kj1TBHzUFhQBekoZCSZwxvC','cus_LPrBRUt7cyhpsy'),(491,317,'jgonzalez@celcom.cl',NULL,400,'estefany jimenez','cl_sus','2022-03-30 13:26:14',1,1,1,NULL,0,'sub_1Kj1XSHzUFhQBekourvHQVFf','cus_LPrFXYOsgSHUE8'),(492,317,'dovalle@celcom.cl',NULL,400,'daniel','cl_sus','2022-03-30 13:32:21',1,1,1,NULL,0,'sub_1Kj1dMHzUFhQBeko3Rm1vAmR','cus_LPrMlpUixvPAHi'),(493,317,'dovalle@celcom.cl',NULL,500,'daniel','testMood','2022-03-30 13:39:10',1,1,1,NULL,0,'sub_1Kj1jyHzUFhQBeko07kAvmYS','cus_LPrSD8TeZi3TdQ'),(494,317,'jonzalez@celcom.cl',NULL,500,'estefany jimenez','testMood','2022-04-11 18:42:43',1,1,1,NULL,0,'sub_1KnSCIHzUFhQBekoEGt6MYHO','cus_LUR4jtn2xXHrSs'),(495,317,'jggt16@gmail.com',NULL,400,'estefany jimenez','cl_sus','2022-04-11 18:47:20',1,1,1,NULL,0,'sub_1KnSGlHzUFhQBekoIpJPINbS','cus_LUR9llWQKw6cYB'),(496,317,'jonzalez@celcom.cl',NULL,500,'estefany jimenez','testMood','2022-04-12 20:26:08',1,1,1,NULL,0,'sub_1KnqHvHzUFhQBekodeDfYIV4','cus_LUpxpDHqJxU0jc'),(497,317,'jonzalez@celcom.cl',NULL,500,'estefany jimenez','testMood','2022-04-12 20:30:02',1,1,1,NULL,0,'sub_1KnqLhHzUFhQBekoLfEEY7Cd','cus_LUq1876UQPAy8N'),(498,317,'dovalle@celcom.cl',NULL,500,'daniel','testMood','2022-04-12 20:36:26',1,1,1,NULL,0,'sub_1KnqRtHzUFhQBekorNZCdep2','cus_LUq898DlfzXVXQ'),(499,317,'cgarcia@mad.cl',NULL,500,'Carlos Garcia','testMood','2022-04-21 13:12:40',1,1,1,NULL,0,'sub_1KqzoPHzUFhQBekoLtFuERHz','cus_LY60bj2UPZegzX'),(500,317,'cgarcia@mad.cl','2022-04-21 21:25:33',400,'Carlos Garcia','cl_sus','2022-04-21 13:59:48',1,1,1,NULL,1,'sub_1Kr0Y1HzUFhQBekofrvQMGiq','cus_LY6l1VTZCehnqO'),(501,317,'cgarcia@mad.cl','2022-04-25 12:59:29',400,'Carlos Garcia','test-cl','2022-04-21 22:01:54',1,1,1,NULL,1,'sub_1Kr84eHzUFhQBekogorg5CcK','cus_LYEXQP91p4ZnN5'),(502,317,'cgarcia@mad.cl','2022-04-27 12:55:05',400,'carlos garcia','Test-cl2','2022-04-25 20:55:35',1,1,1,NULL,1,'sub_1KsYwZHzUFhQBekoZItiaLel','cus_LZiNmTTknTdFAb'),(503,317,'jggt16@gmail.com','2022-04-29 13:00:55',400,'Juan Gonzalez','Test-cl2','2022-04-27 18:54:12',1,1,1,NULL,1,'sub_1KtG0CHzUFhQBekoCuyl4KGj','cus_LaQrKtepdo9A9a'),(504,317,'jgonzalez@celcom.cl','2022-05-11 12:47:03',600,'juan gonzalez','Test-cl2','2022-04-29 13:26:37',1,1,1,NULL,1,'sub_1KttqHHzUFhQBeko9sh0iHvG','cus_Lb62zJJLIE6Dtm'),(505,317,'dovall@celcom.cl','2022-05-12 20:22:14',600,'daniel','Test-cl2','2022-05-10 21:15:03',1,1,1,NULL,1,'sub_1Ky0OjHzUFhQBekoEwJhcW0r','cus_LfL4iorPlCLLdF'),(506,317,'jgonzalez@celcom.cl','2022-05-18 16:23:48',400,'Juan Gonzalez','test-cl','2022-05-17 15:25:35',1,1,1,NULL,1,'sub_1L0SHHHzUFhQBekogjEki7WL','cus_Lhs1E7grhksAv6'),(507,317,'jggt16@gmail.com','2022-05-20 22:22:10',600,'juan gonzalez','Test-cl2','2022-05-18 16:27:58',1,1,1,NULL,1,'sub_1L0pjEHzUFhQBekou3S8WyGs','cus_LiGFOjw86Y0QOR'),(508,317,'jgonzalez@celcom.cl','2022-06-01 14:49:14',600,'juan gonzalez','Test-cl2','2022-06-01 13:36:28',1,1,1,NULL,1,'sub_1L5rivHzUFhQBekoSdRYq2v5','cus_LnSezXHd7NqaTT'),(509,317,'jggt16@gmail.com','2022-06-02 13:58:34',600,'juan gonzalez','Test-cl2','2022-06-01 15:14:24',1,1,1,NULL,1,'sub_1L5tFfHzUFhQBekoN6qBFTxJ','cus_LnUEdY865Dyznv'),(510,317,'jonzalez@celcom.cl','2022-06-02 15:22:16',600,'juan gonzalez','Test-cl2','2022-06-02 15:10:40',1,1,1,NULL,1,'sub_1L6FfbHzUFhQBekog5M5QK81','cus_LnrOmI4oQ3QQA0'),(511,317,'jggt16@gmail.com','2022-06-02 16:08:31',600,'juan gonzalez','Test-cl2','2022-06-02 15:23:45',1,1,1,NULL,1,'sub_1L6FsGHzUFhQBekoImZktb8J','cus_Lnrb0HEX57G9BS'),(512,317,'jonzalez@celcom.cl','2022-06-03 15:10:40',600,'juan gonzalez','Test-cl2','2022-06-02 16:10:38',1,1,1,NULL,1,'sub_1L6GbdHzUFhQBekoJOkLbHQc','cus_LnsM0bLYpFiNdR'),(513,317,'jonzalez@celcom.cl','2022-06-03 15:21:53',600,'juan gonzalez','Test-cl2','2022-06-03 15:13:43',1,1,1,NULL,1,'sub_1L6cC6HzUFhQBekoZQuXu2qv','cus_LoEfLLhcLucO55'),(514,317,'jggt16@gmail.com','2022-06-03 15:45:28',600,'juan gonzalez','Test-cl2','2022-06-03 15:23:36',1,1,1,NULL,1,'sub_1L6cLhHzUFhQBekospSMJbAa','cus_LoEplfthsfYSEv'),(515,317,'dgonzalez@celcom.cl',NULL,600,'juan gonzalez','Test-cl2','2022-06-03 15:47:19',1,1,1,NULL,0,'sub_1L6cicHzUFhQBekoP291YDXS','cus_LoFDQiYN7GmuPc');

--
-- Table structure for table `template`
--

CREATE TABLE `template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `id_project` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_template_project` (`id_project`),
  CONSTRAINT `FK_template_project` FOREIGN KEY (`id_project`) REFERENCES `project` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=363 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `template`
--

INSERT INTO `template` VALUES (351,'Test prod',317),(352,'Test prod',317),(353,'Test prod',317),(354,'cl_sus',317),(355,'Topclass Colombia',318),(356,'test-cl',317),(357,'Test-cl2',317),(358,'test localGo',331),(359,'test3 localGo',331),(360,'test fran',331),(361,'test4 localGo',331),(362,'test suscrip',331);

--
-- Table structure for table `template_field`
--

CREATE TABLE `template_field` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `column_size` varchar(15) DEFAULT NULL,
  `regular_exp` varchar(200) DEFAULT NULL,
  `required` int(11) DEFAULT NULL,
  `id_template` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_template_field_template` (`id_template`),
  CONSTRAINT `FK_template_field_template` FOREIGN KEY (`id_template`) REFERENCES `template` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=489 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `template_field`
--

INSERT INTO `template_field` VALUES (454,'Nombre','col-12','regular',1,351),(455,'Email','col-12','regular',1,351),(456,'Email','col-12','regular',1,352),(457,'Nombre','col-12','regular',1,352),(458,'Nombre','col-12','regular',1,353),(459,'Email','col-12','regular',1,353),(460,'Apellido','col-12','regular',1,353),(461,'Email','col-12','regular',1,354),(462,'Email','col-12','regular',1,355),(463,'Apellido','col-12','regular',1,356),(464,'Nombre','col-12','regular',1,356),(465,'Apellido','col-12','regular',1,357),(466,'Email','col-12','regular',1,357),(467,'Nombre','col-12','regular',1,357),(468,'Email','col-12','regular',1,358),(469,'Apellido','col-12','regular',1,358),(470,'Nombre','col-12','regular',1,358),(471,'Dirección de Empresa','col-12','regular',1,359),(472,'Giro de Empresa','col-12','regular',1,359),(473,'RUT','col-12','regular',1,359),(474,'Email de Empresa','col-12','regular',1,359),(475,'RUT de Empresa','col-12','regular',1,359),(476,'Nombre de Empresa','col-12','regular',1,359),(477,'Dirección','col-12','regular',1,359),(478,'Teléfono','col-12','regular',1,359),(479,'Email','col-12','regular',1,359),(480,'Nombre','col-12','regular',1,359),(481,'Apellido','col-12','regular',1,359),(482,'Nombre','col-12','regular',1,360),(483,'Apellido','col-12','regular',1,360),(484,'Teléfono','col-12','regular',1,360),(485,'Email','col-12','regular',1,360),(486,'Email','col-12','regular',1,361),(487,'Teléfono','col-12','regular',1,361),(488,'Nombre','col-12','regular',1,362);

--
-- Table structure for table `transaction_field`
--

CREATE TABLE `transaction_field` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_transaction` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `value` varchar(200) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_transaction_field_trasaction` (`id_transaction`),
  CONSTRAINT `FK_transaction_field_trasaction` FOREIGN KEY (`id_transaction`) REFERENCES `trasaction` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1411 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `transaction_field`
--

INSERT INTO `transaction_field` VALUES (1357,1801,'Nombre','JUAN'),(1358,1801,'Email','JGGT16@GMAIL.COM'),(1359,1802,'Email','jggt16@gmail.com'),(1360,1802,'Nombre','juan'),(1361,1803,'Nombre','juan'),(1362,1803,'Email','jggt16@gmail.com'),(1363,1804,'Email','dovalle@celcom.cl'),(1364,1804,'Nombre','daniel'),(1365,1804,'Nombre','daniel'),(1366,1804,'Email','dovalle@celcom.cl'),(1367,1805,'Email','jggt16@gmail.com'),(1368,1805,'Nombre','juan gonzalez'),(1369,1806,'Nombre','juan'),(1370,1806,'Email','jggt16@gmail.com'),(1371,1807,'Email','jggt16@gmail.com'),(1372,1808,'Nombre','juan'),(1373,1809,'Email','jgonzalez@celcom.cl'),(1374,1809,'Nombre','juan'),(1375,1810,'Nombre','juan'),(1376,1811,'Nombre','juan'),(1377,1811,'Email','prueba-pago-unico@gmail.com'),(1378,1812,'Nombre','juan'),(1379,1813,'Nombre','juan'),(1380,1814,'Nombre','juan'),(1381,1815,'Nombre','juan'),(1382,1816,'Email','dovalle@celcom.cl'),(1383,1817,'Email','jgonzalez@celcom.cl'),(1384,1818,'Email','Deymos8.548@gmail.com'),(1385,1819,'Email','dovalle@celcom.cl'),(1386,1820,'Email','jgonzalez@celcom.cl'),(1387,1821,'Email','dovalle@celcom.cl'),(1388,1822,'Email','dovalle@celcom.cl'),(1389,1823,'Email','jgonzalez@celcom.cl'),(1390,1824,'Email','jggt16@gmail.com'),(1391,1825,'Email','jgonzalez@celcom.cl'),(1392,1826,'Email','jgonzalez@celcom.cl'),(1393,1827,'Email','dovalle@celcom.cl'),(1394,1828,'Email','cgarcia@mad.cl'),(1395,1829,'Email','cgarcia@mad.cl'),(1396,1830,'Apellido','Garcia'),(1397,1831,'Nombre','Carlos'),(1398,1834,'Nombre','Juan'),(1399,1836,'Nombre','juan'),(1400,1837,'Nombre','daniel'),(1401,1838,'Apellido','Gonzalez'),(1402,1839,'Nombre','juan'),(1403,1840,'Nombre','Juan'),(1404,1841,'Nombre','Juan'),(1405,1842,'Nombre','juan'),(1406,1844,'Nombre','juanuno'),(1407,1846,'Nombre','juandos'),(1408,1848,'Nombre','juan'),(1409,1850,'Nombre','juan'),(1410,1852,'Nombre','danger');

--
-- Table structure for table `trasaction`
--

CREATE TABLE `trasaction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_project` int(11) NOT NULL,
  `type` varchar(14) NOT NULL,
  `date` datetime NOT NULL,
  `id_credential` int(11) NOT NULL,
  `id_state` int(11) NOT NULL,
  `amount` float NOT NULL,
  `id_currency` int(11) NOT NULL,
  `email_user_app` varchar(100) NOT NULL,
  `id_suscription` int(11) DEFAULT NULL,
  `id_link` int(11) DEFAULT NULL,
  `ref_discount` varchar(50) DEFAULT NULL,
  `token_pay` varchar(551) DEFAULT NULL,
  `used` int(11) DEFAULT NULL,
  `baja` int(11) DEFAULT NULL,
  `id_stripeTransaction` varchar(200) DEFAULT NULL,
  `ticketNumber_kushki` varchar(200) DEFAULT NULL,
  `ticketNumber_refund_kushki` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_trasaction_project` (`id_project`),
  KEY `FK_trasaction_link` (`id_link`),
  CONSTRAINT `FK_trasaction_link` FOREIGN KEY (`id_link`) REFERENCES `link` (`id`),
  CONSTRAINT `FK_trasaction_project` FOREIGN KEY (`id_project`) REFERENCES `project` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1854 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `trasaction`
--

INSERT INTO `trasaction` VALUES (1801,317,'1','2022-02-23 15:38:44',2,2,500,3,'jggt16@gmail.com',NULL,620,NULL,'tok_1KWMvRHzUFhQBekoBVyt3V3t',0,NULL,'pi_3KWMvSHzUFhQBeko0Xqu5OeS',NULL,NULL),(1802,317,'1','2022-02-28 14:04:17',2,2,500,3,'jggt16@gmail.com',NULL,620,NULL,'tok_1KY9pnHzUFhQBekon1fEyteA',0,NULL,'pi_3KY9pnHzUFhQBeko0uXsEAwN',NULL,NULL),(1803,317,'1','2022-02-28 14:10:07',2,2,500,3,'jggt16@gmail.com',NULL,620,NULL,'tok_1KY9vRHzUFhQBekofW1auYU8',0,NULL,'pi_3KY9vRHzUFhQBeko0kNfZ5Zw',NULL,NULL),(1804,317,'1','2022-02-28 14:23:19',2,2,500,3,'dovalle@celcom.cl',NULL,620,NULL,'tok_1KYA8CHzUFhQBekor6byyBQm',0,NULL,'pi_3KYA8DHzUFhQBeko1KTI2WZE',NULL,NULL),(1805,317,'1','2022-03-01 13:28:24',2,2,500,3,'jggt16@gmail.com',NULL,620,NULL,'tok_1KYVkbHzUFhQBekobfguVKuo',0,NULL,'pi_3KYVkcHzUFhQBeko0j8p3NH7',NULL,NULL),(1806,317,'1','2022-03-01 13:34:08',2,2,500,3,'jggt16@gmail.com',NULL,620,NULL,'tok_1KYVq9HzUFhQBekoOdJGrjhV',0,NULL,'pi_3KYVqAHzUFhQBeko1ZGHYCGz',NULL,NULL),(1807,317,'2','2022-03-02 21:10:20',2,1,500,3,'jggt16@gmail.com',NULL,621,NULL,'',0,0,NULL,NULL,NULL),(1808,317,'2','2022-03-02 21:13:53',2,2,500,3,'jggt16@gmail.com',481,621,NULL,'pi_3KYzUdHzUFhQBeko1Sw71TSQ_secret_AtAVUrDDAM1FvGM1SJbXTbuJi',0,0,'pi_3KYzUdHzUFhQBeko1Sw71TSQ',NULL,NULL),(1809,317,'1','2022-03-03 13:31:18',2,2,500,3,'jonzalez@celcom.cl',NULL,620,NULL,'tok_1KZEkVHzUFhQBekoum50l9rP',0,NULL,'pi_3KZEkWHzUFhQBeko1Jrv05Xx',NULL,NULL),(1810,317,'2','2022-03-03 13:38:35',2,2,500,3,'dovalle@celcom.cl',482,621,NULL,'pi_3KZErYHzUFhQBeko0p7cMV8l_secret_SF1frj0fYblkLcjUrqtZZvRLW',0,0,'pi_3KZErYHzUFhQBeko0p7cMV8l',NULL,NULL),(1811,317,'1','2022-03-03 14:35:31',2,2,500,3,'prueba-pago-unico@gmail.com',NULL,620,NULL,'tok_1KZFkeHzUFhQBekovpJifSbG',0,NULL,'pi_3KZFkfHzUFhQBeko0U2xQBlG',NULL,NULL),(1812,317,'2','2022-03-03 14:39:12',2,2,500,3,'prueba-pago-suscripcion@gmail.com',483,621,NULL,'pi_3KZFoEHzUFhQBeko1Jzw9pb2_secret_SQk6tT4mUilUvLYhlEr69GcVF',0,0,'pi_3KZFoEHzUFhQBeko1Jzw9pb2',NULL,NULL),(1813,317,'2','2022-03-03 14:50:22',2,2,500,3,'pago-suscripcion@gmail.com',484,621,NULL,'pi_3KZFz2HzUFhQBeko15cTN4Ws_secret_YKHngSof3p0Wwfqbd7mbhAbQe',0,0,'pi_3KZFz2HzUFhQBeko15cTN4Ws',NULL,NULL),(1814,317,'2','2022-03-03 14:59:52',2,2,500,3,'prueba-pago-suscripcion-hookin@gmail.com',485,621,NULL,'pi_3KZG8EHzUFhQBeko0ZP2DA1k_secret_N86gLUV0gr9IBZo0xCusje8QZ',0,0,'pi_3KZG8EHzUFhQBeko0ZP2DA1k',NULL,NULL),(1815,317,'2','2022-03-03 15:09:21',2,2,500,3,'prueba-pago-suscripcion222@gmail.com',486,621,NULL,'pi_3KZGHPHzUFhQBeko05msoMVn_secret_7OYj1CLl9iRWcjXIPIwapvCOg',0,0,'pi_3KZGHPHzUFhQBeko05msoMVn',NULL,NULL),(1816,317,'2','2022-03-03 18:18:57',2,2,400,3,'dovalle@celcom.cl',487,622,NULL,'pi_3KZJEtHzUFhQBeko0kEOeHsF_secret_aOOVG2RnmHlztbnIMsDzPE9lx',0,0,'pi_3KZJEtHzUFhQBeko0kEOeHsF',NULL,NULL),(1817,317,'2','2022-03-03 19:34:26',2,2,400,3,'jgonzalez@celcom.cl',488,622,NULL,'pi_3KZKPwHzUFhQBeko0aN51woO_secret_1ntoJrO5HDmNZKnJkhOKnt48Z',0,0,'pi_3KZKPwHzUFhQBeko0aN51woO',NULL,NULL),(1818,317,'2','2022-03-03 19:46:34',2,2,400,3,'Deymos8.548@gmail.com',489,622,NULL,'pi_3KZKbgHzUFhQBeko1MP7nAJP_secret_5GcwCJeO2oePKzMuCSKnqBpLx',0,0,'pi_3KZKbgHzUFhQBeko1MP7nAJP',NULL,NULL),(1819,317,'2','2022-03-30 13:21:50',2,2,400,3,'dovalle@celcom.cl',490,622,NULL,'pi_3Kj1TAHzUFhQBeko0CMfZOmK_secret_Xp4dlYpE6q9CV9nKBt29nKWDX',0,0,'pi_3Kj1TAHzUFhQBeko0CMfZOmK',NULL,NULL),(1820,317,'2','2022-03-30 13:26:14',2,2,400,3,'jgonzalez@celcom.cl',491,622,NULL,'pi_3Kj1XQHzUFhQBeko1ncbFDkH_secret_0WmZJJllQkNOTBZ51Lwrjr4ZY',0,0,'pi_3Kj1XQHzUFhQBeko1ncbFDkH',NULL,NULL),(1821,317,'2','2022-03-30 13:32:21',2,2,400,3,'dovalle@celcom.cl',492,622,NULL,'pi_3Kj1dLHzUFhQBeko1FzTeGqN_secret_jhqtuHjKhTQ78Qy54Ro7yjBlN',0,0,'pi_3Kj1dLHzUFhQBeko1FzTeGqN',NULL,NULL),(1822,317,'2','2022-03-30 13:39:10',2,2,500,3,'dovalle@celcom.cl',493,624,NULL,'pi_3Kj1jwHzUFhQBeko0J5B0M6u_secret_ElyYhPzHM7KQ0ysJgOyPLRk9s',0,0,'pi_3Kj1jwHzUFhQBeko0J5B0M6u',NULL,NULL),(1823,317,'2','2022-04-11 18:42:43',2,2,500,3,'jonzalez@celcom.cl',494,624,NULL,'TEST',0,0,'TEST',NULL,NULL),(1824,317,'2','2022-04-11 18:47:20',2,2,400,3,'jggt16@gmail.com',495,622,NULL,'TEST',0,0,'TEST',NULL,NULL),(1825,317,'2','2022-04-12 20:26:08',2,1,500,3,'jonzalez@celcom.cl',NULL,624,NULL,'',0,0,NULL,NULL,NULL),(1826,317,'2','2022-04-12 20:30:02',2,2,500,3,'jonzalez@celcom.cl',497,624,NULL,'in_1KnqLhHzUFhQBekolzHZb8U6',0,0,NULL,NULL,NULL),(1827,317,'2','2022-04-12 20:36:26',2,2,500,3,'dovalle@celcom.cl',498,624,NULL,'in_1KnqRtHzUFhQBekoT1NYbeLG',0,0,NULL,NULL,NULL),(1828,317,'2','2022-04-21 13:12:40',2,2,500,3,'cgarcia@mad.cl',499,624,NULL,'in_1KqzoPHzUFhQBeko6jwrv6tP',0,0,NULL,NULL,NULL),(1829,317,'2','2022-04-21 13:59:48',2,2,400,3,'cgarcia@mad.cl',500,622,NULL,'in_1Kr0Y1HzUFhQBekoHYXLvipa',0,0,NULL,NULL,NULL),(1830,317,'2','2022-04-21 22:01:54',2,2,400,3,'cgarcia@mad.cl',501,625,NULL,'in_1Kr84eHzUFhQBekoZ7M8UCSY',0,0,NULL,NULL,NULL),(1831,317,'2','2022-04-25 20:55:35',2,2,400,3,'cgarcia@mad.cl',502,626,NULL,'in_1KsYwZHzUFhQBeko1ABaO859',0,0,NULL,NULL,NULL),(1832,317,'4','2022-04-22 23:05:52',2,2,400,3,'cgarcia@mad.cl',501,625,NULL,'-',0,NULL,'pi_3KrVXuHzUFhQBeko0WGyRJfB',NULL,NULL),(1833,317,'4','2022-04-26 21:59:28',2,2,400,3,'cgarcia@mad.cl',502,626,NULL,'-',0,NULL,'pi_3KswPpHzUFhQBeko0VgPt0TR',NULL,NULL),(1834,317,'2','2022-04-27 18:54:12',2,2,400,3,'jggt16@gmail.com',503,626,NULL,'in_1KtG0CHzUFhQBekoizXZIRUh',0,0,NULL,NULL,NULL),(1835,317,'4','2022-04-28 19:59:33',2,2,400,3,'jggt16@gmail.com',503,626,NULL,'-',0,NULL,'pi_3KtdUtHzUFhQBeko0WqKN3sH',NULL,NULL),(1836,317,'2','2022-04-29 13:26:37',2,1,600,3,'jgonzalez@celcom.cl',NULL,626,NULL,'',0,0,NULL,NULL,NULL),(1837,317,'2','2022-05-10 21:15:03',2,2,600,3,'dovall@celcom.cl',505,626,NULL,'in_1Ky0OjHzUFhQBekoNPL6hbPV',0,0,NULL,NULL,NULL),(1838,317,'2','2022-05-17 15:25:35',2,2,400,3,'jgonzalez@celcom.cl',506,625,NULL,'in_1L0SHHHzUFhQBekoTshjIJ4W',0,0,NULL,NULL,NULL),(1839,317,'2','2022-05-18 16:27:58',2,2,600,3,'jggt16@gmail.com',507,626,NULL,'in_1L0pjEHzUFhQBekoFg4TncBW',0,0,NULL,NULL,NULL),(1840,317,'2','2022-06-01 13:36:28',2,2,600,3,'jgonzalez@celcom.cl',508,626,NULL,'in_1L5rivHzUFhQBekow7Aftwh9',0,0,NULL,NULL,NULL),(1841,317,'2','2022-06-01 15:14:24',2,2,600,3,'jggt16@gmail.com',509,626,NULL,'in_1L5tFfHzUFhQBekomYaHxbmv',0,0,NULL,NULL,NULL),(1842,317,'2','2022-06-02 15:10:40',2,2,600,3,'jonzalez@celcom.cl',510,626,NULL,'in_1L6FfbHzUFhQBekoUeQ1OlnT',0,0,NULL,NULL,NULL),(1843,317,'4','2022-06-02 15:10:45',2,2,600,3,'jonzalez@celcom.cl',510,626,NULL,'-',0,NULL,'pi_3L6FfbHzUFhQBeko0oGk8fUQ',NULL,NULL),(1844,317,'2','2022-06-02 15:23:45',2,2,600,3,'jggt16@gmail.com',511,626,NULL,'in_1L6FsGHzUFhQBeko0p74HW13',0,0,NULL,NULL,NULL),(1845,317,'4','2022-06-02 15:23:50',2,2,600,3,'jggt16@gmail.com',511,626,NULL,'-',0,NULL,'pi_3L6FsGHzUFhQBeko09q7la5V',NULL,NULL),(1846,317,'2','2022-06-02 16:10:38',2,2,600,3,'jonzalez@celcom.cl',512,626,NULL,'in_1L6GbeHzUFhQBeko6ZIAtOEG',0,0,NULL,NULL,NULL),(1847,317,'4','2022-06-02 16:10:44',2,2,600,3,'jonzalez@celcom.cl',512,626,NULL,'-',0,NULL,'pi_3L6GbeHzUFhQBeko0ein5SRC',NULL,NULL),(1848,317,'2','2022-06-03 15:13:43',2,2,600,3,'jonzalez@celcom.cl',513,626,NULL,'in_1L6cC6HzUFhQBekoZ4exYHjv',0,0,NULL,NULL,NULL),(1849,317,'4','2022-06-03 15:13:49',2,2,600,3,'jonzalez@celcom.cl',513,626,NULL,'-',0,NULL,'pi_3L6cC6HzUFhQBeko15cTMfAB',NULL,NULL),(1850,317,'2','2022-06-03 15:23:36',2,2,600,3,'jggt16@gmail.com',514,626,NULL,'in_1L6cLhHzUFhQBekoX9xfUEy9',0,0,NULL,NULL,NULL),(1851,317,'4','2022-06-03 15:23:44',2,2,600,3,'jggt16@gmail.com',514,626,NULL,'-',0,NULL,'pi_3L6cLiHzUFhQBeko0m4qTDIK',NULL,NULL),(1852,317,'2','2022-06-03 15:47:19',2,2,600,3,'dgonzalez@celcom.cl',515,626,NULL,'in_1L6cicHzUFhQBekoNLPAxvWI',0,0,NULL,NULL,NULL),(1853,317,'4','2022-06-03 15:47:25',2,2,600,3,'dgonzalez@celcom.cl',515,626,NULL,'-',0,NULL,'pi_3L6cicHzUFhQBeko05ZPNw3N',NULL,NULL);

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(45) NOT NULL,
  `pass` varchar(100) DEFAULT NULL,
  `timezone` varchar(45) DEFAULT NULL,
  `name` varchar(45) DEFAULT NULL,
  `role` varchar(5) DEFAULT NULL,
  `baja` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=272 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES (269,'admincelcom@yopmail.com','$2a$12$GPyAM9EXvNIPovp4/HLKMeyZK7nFyRdlN/V3aLHFsBHuJJvQE5xW6','BSAS','Administrador General','ADMIN',0),(270,'dovalle@celcom.cl','$2a$12$KnhAATgG6vBzhqMh6L6kKe5bwawRXwsM4yaxunVlJ.qYhFKlnzDUa','BSAS','test test','BASIC',0),(271,'dgonzalez@celcom.cl','$2a$12$GPyAM9EXvNIPovp4/HLKMeyZK7nFyRdlN/V3aLHFsBHuJJvQE5xW6','BSAS','Danger Diaz','ADMIN',0);

--
-- Table structure for table `user_changepass`
--

CREATE TABLE `user_changepass` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `moment` datetime NOT NULL,
  `used` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_user_changepass_user` (`id_user`),
  CONSTRAINT `FK_user_changepass_user` FOREIGN KEY (`id_user`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_changepass`
--

INSERT INTO `user_changepass` VALUES (114,270,'2022-03-30 13:13:24',0),(115,270,'2022-03-30 13:14:38',0);

--
-- Table structure for table `user_project`
--

CREATE TABLE `user_project` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `id_project` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_user_project_user` (`id_user`),
  KEY `FK_user_project_project` (`id_project`),
  CONSTRAINT `FK_user_project_project` FOREIGN KEY (`id_project`) REFERENCES `project` (`id`),
  CONSTRAINT `FK_user_project_user` FOREIGN KEY (`id_user`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3098 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_project`
--

INSERT INTO `user_project` VALUES (3064,269,316),(3065,269,317),(3067,269,318),(3068,271,317),(3069,271,318),(3070,271,316),(3071,270,317),(3096,269,331),(3097,271,331);

--
-- Table structure for table `web_hooks`
--

CREATE TABLE `web_hooks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `url_api` varchar(200) NOT NULL,
  `id_event` int(11) NOT NULL,
  `id_project` int(11) NOT NULL,
  `single_payment` int(11) DEFAULT NULL,
  `recurring_payment` int(11) DEFAULT NULL,
  `single_payment_refund` int(11) DEFAULT NULL,
  `recurring_payment_refund` int(11) DEFAULT NULL,
  `single_payment_cancellation` int(11) DEFAULT NULL,
  `recurring_payment_cancellation` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_web_hooks_project` (`id_project`),
  CONSTRAINT `FK_web_hooks_project` FOREIGN KEY (`id_project`) REFERENCES `project` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `web_hooks`
--

INSERT INTO `web_hooks` VALUES (17,'2022-02-28 13:57:09','http://cms-lite.multinetlabs.com/api/celcom-checkout',2,317,1,1,1,0,0,1);


