Oct 01, 2023, 01:51 PM
Hello everyone,today i re-uploaded LimeTray.com database
Originally posted @postmaster here - https://bf.st/Thread-LimeTray-com-INDIA-4-Million
lines:4.067.232
leak date:don't know
sample:full leak -
Originally posted @postmaster here - https://bf.st/Thread-LimeTray-com-INDIA-4-Million
lines:4.067.232
leak date:don't know
sample:
DROP TABLE IF EXISTS "limetray"."users";
CREATE TABLE limetray.users (
brand_user_id text PRIMARY KEY,
brand_id text,
created_at bigint,
email text,
first_failed_order_time bigint,
first_non_void_order_time bigint,
first_order_time bigint,
first_void_order_time bigint,
full_name text,
last_interaction_time bigint,
loss double,
mobile text,
revenue double,
source_id int,
source_name text,
total_discount double,
total_failed_orders int,
total_loyalty_amount double,
total_non_void_orders int,
total_orders int,
total_preorders int,
total_void_orders int
) WITH bloom_filter_fp_chance = 0.1
AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
AND comment = ''
AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy', 'tombstone_threshold': '.2'}
AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
AND crc_check_chance = 1.0
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 0
AND gc_grace_seconds = 864000
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = '99PERCENTILE';;
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "first_non_void_order_time", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('15482549', '507', 1505830272, 1502460147000, 1502460147000, 'Puranjay Singh', 1502460147000, 0.0, '9899295695', 351.05, 0, 'Admin', 52.5, 0, 0.0, 1, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "first_order_time", "first_void_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('11601354', '4242', 1505830168, 1483980330000, 1483980330000, 'Annuvrat.munjal', 1502213360000, 3846.14, '9818400077', 0.0, 0, 'Admin', 0.0, 0, 0.0, 0, 5, 0, 5);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "first_non_void_order_time", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('13343763', '3338', 1505823669, 1491543478000, 1491543478000, 'Vj Biswas', 1491543478000, 0.0, '9963996661', 205.0, 0, 'Admin', 0.0, 0, 0.0, 1, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('15783081', '4043', 1505830849, 1503593658000, 'Satya Swaroop', 1503593658000, 0.0, '9888195599', 0.0, 0, 'Admin', 0.0, 0, 0.0, 0, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('15536364', '4634', 1505830435, 1502738248000, 'Sahaj Arora', 1502738248000, 0.0, '9599170120', 0.0, 0, 'Admin', 0.0, 0, 0.0, 0, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_non_void_order_time", "first_order_time", "first_void_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('19293803', '5287', 1515927857, '[email protected]', 1515927645000, 1515927645000, 0, 'Ronan Pooh', 1515927645000, 0.0, '8383045737', 401.52, 0, 'Admin', 95.6, 0, 0.0, 1, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_non_void_order_time", "first_order_time", "first_void_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('20014474', '5235', 1518453734, '[email protected]', 1518449299000, 1518449299000, 0, 'Prathmesh Thakur', 1518449299000, 0.0, '9920805720', 542.48, 0, 'Admin', 82.35, 0, 0.0, 1, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('10383645', '3786', 1505812065, 1477222194000, 'sakshi ', 1477222194000, 0.0, '9920099249', 0.0, 0, 'Admin', 0.0, 0, 0.0, 0, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('13108577', '3789', 1505829216, 1489710045000, 'kanwar ', 1489710045000, 0.0, '8146101994', 0.0, 0, 'Admin', 0.0, 0, 0.0, 0, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_non_void_order_time", "first_order_time", "first_void_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('15993150', '1138', 1505831605, '[email protected]', 1504788799000, 1504788799000, 0, 'Arjun Tandon', 1505051717000, 0.0, '9920567744', 5614.529999999999, 0, 'Admin', 536.0, 0, 0.0, 9, 9, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_order_time", "first_void_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('19145832', '4843', 1515338633, '[email protected]', 1515338577000, 1515338577000, 'Sid J', 1515338577000, 443.7, '9769184466', 0.0, 0, 'Admin', 0.0, 0, 0.0, 0, 1, 0, 1);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('17773879', '3258', 1510470867, '[email protected]', 1510470424000, 'Pradeep Banavara', 1510470424000, 0.0, '8095978063', 611.24, 0, 'Admin', 81.0, 0, 0.0, 1, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "first_non_void_order_time", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('13155370', '1672', 1505828081, 1490177437000, 1490177437000, 'Priya ', 1490177437000, 0.0, '9524171091', 226.62, 0, 'Admin', 0.0, 0, 0.0, 1, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_non_void_order_time", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('5047866', '1672', 1505828177, '[email protected]', 1465400456000, 1465400456000, 'Sneha', 1490540494000, 0.0, '9619971847', 2039.79, 0, 'Admin', 123.0, 0, 0.0, 4, 4, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('17563953', '2994', 1509968565, '[email protected]', 1509968401000, 'Sarita Sinha', 1509968401000, 0.0, '8574588733', 192.64, 0, 'Admin', 38.0, 0, 0.0, 1, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_non_void_order_time", "first_order_time", "first_void_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('18988614', '5090', 1514747479, '[email protected]', 1514747477000, 1514747477000, 0, 'Aman Goel', 1514747477000, 0.0, '9958015310', 234.39, 0, 'Admin', 34.35, 0, 0.0, 1, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_non_void_order_time", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('14471461', '1144', 1505826451, '[email protected]', 1497342312000, 1497342312000, 'Kashif', 1497342312000, 0.0, '9820083635', 351.0, 0, 'Admin', 81.6, 0, 0.0, 1, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_non_void_order_time", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('11315225', '3372', 1505811197, '[email protected]', 1482692358000, 1482692358000, 'Himanshu Kumar', 1482692358000, 0.0, '8763451991', 241.36, 0, 'Admin', 18.9, 0, 0.0, 1, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('16967158', '3255', 1508078737, 1508078717000, 'Nisarg Jitendra Desai', 1508078717000, 0.0, '9377171457', 607.7, 0, 'Admin', 0.0, 0, 0.0, 1, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('15873814', '4374', 1505831122, 1504161234275, 'hjn ', 1504161234275, 0.0, '8409493140', 0.0, 0, 'Admin', 0.0, 0, 0.0, 0, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('6533264', '1056', 1505812607, 1471254037000, 'Saurabh Kumae r0uj', 1471254037000, 0.0, '9599925793', 0.0, 0, 'Admin', 0.0, 0, 0.0, 0, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('4456936', '1845', 1505812865, 1468137938000, 'naam ', 1468137938000, 0.0, '7767877115', 0.0, 0, 'Admin', 0.0, 0, 0.0, 0, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_order_time", "first_void_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('12026754', '1672', 1505828318, '[email protected]', 1485674558000, 1485674558000, 'Naman', 1485674558000, 268.0, '9927734085', 0.0, 0, 'Admin', 0.0, 0, 0.0, 0, 1, 0, 1);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_non_void_order_time", "first_order_time", "first_void_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('19419211', '2098', 1516433600, '[email protected]', 1516433598000, 1516433598000, 0, 'Kanika', 1516433598000, 0.0, '8527398181', 440.0, 0, 'Admin', 0.0, 0, 0.0, 1, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_failed_order_time", "first_non_void_order_time", "first_order_time", "first_void_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('6204635', '693', 1505828753, '[email protected]', 1485441039000, 1471531051000, 1471531051000, 1475160425000, 'Santosh Kumar', 1493476632000, 546.0, '7289934399', 4374.0, 0, 'Admin', 910.55, 3, 0.0, 12, 13, 1, 1);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_order_time", "first_void_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('4348917', '691', 1505815061, '[email protected]', 1459441617000, 1459441617000, 'harish', 1459441617000, 758.0, '8130134047', 0.0, 0, 'Admin', 0.0, 0, 0.0, 0, 1, 0, 1);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_non_void_order_time", "first_order_time", "first_void_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('18783503', '4806', 1514820133, '[email protected]', 1514820128000, 1514820128000, 0, 'Abhiram Sharma', 1514820128000, 0.0, '9873934535', 286.15, 0, 'Admin', 43.05, 0, 0.0, 1, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "first_non_void_order_time", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('14386969', '1672', 1505819054, 1496821121974, 1496821121974, 'Dylan', 1496821121974, 0.0, '9920602681', 285.0, 0, 'Admin', 0.0, 0, 0.0, 1, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('17538214', '863', 1509816157, 1509816153000, 'SANJAY SANGTANI', 1509816153000, 0.0, '9320504503', 581.65, 0, 'Admin', 82.5, 0, 0.0, 1, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "email", "first_failed_order_time", "first_non_void_order_time", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('14849468', '1230', 1505826331, '[email protected]', 1499279410000, 1499271662000, 1499271662000, 'sriniva', 1500451526000, 0.0, '8686383696', 1355.0, 0, 'Admin', 0.0, 1, 0.0, 2, 2, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "first_non_void_order_time", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('19781170', '5319', 1517584942, 1517578900209, 1517578900209, 'Divyanshi ', 1517578900209, 0.0, '8860315464', 624.75, 0, 'Admin', 0.0, 0, 0.0, 1, 1, 0, 0);
INSERT INTO "limetray"."users" ("brand_user_id", "brand_id", "created_at", "first_order_time", "full_name", "last_interaction_time", "loss", "mobile", "revenue", "source_id", "source_name", "total_discount", "total_failed_orders", "total_loyalty_amount", "total_non_void_orders", "total_orders", "total_preorders", "total_void_orders") VALUES ('15386892', '691', 1505830755, 1502006921000, 'Suneel T', 1503398493000, 0.0, '8745010082', 0.0, 0, 'Admin', 0.0, 0, 0.0, 0, 2, 0, 0);
