Skip to content

Instantly share code, notes, and snippets.

@wasipo

wasipo/gist:28537fa9d3b9aa79b956ee44ee9354d3

Created September 25, 2020 20:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wasipo/28537fa9d3b9aa79b956ee44ee9354d3 to your computer and use it in GitHub Desktop.
Save wasipo/28537fa9d3b9aa79b956ee44ee9354d3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
```SQL
create schema test_1 collate utf8mb4_general_ci;
use test_1;
create table estimate
(
estimate_id int not null
primary key,
customer_id int null,
invoice_id int null,
host_id int null,
deleted_at timestamp null
)
collate=utf8mb4_unicode_ci;
create table invoice
(
invoice_id int not null
primary key,
estimate_id int null,
customer_id int null,
host_id int null,
deleted_at timestamp null
)
collate=utf8mb4_unicode_ci;
create table host
(
host_id int not null
primary key,
deleted_at timestamp null
)
collate=utf8mb4_unicode_ci;
create table customer
(
customer_id int not null
primary key,
host_id int not null,
deleted_at timestamp null
)
collate=utf8mb4_unicode_ci;
```
```SQL
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (6044810, null,null, 1203507743,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (42338015, null,922361081, 1203507743,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (59552397, null,970766793, 1203507743,'2020-09-25 15:38:26');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (124679391, null,null, 1203507743,'2020-08-31 15:44:11');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (130222192, null,null, 1991039758, null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (174710775, null,922361081, 1203507743,'2020-06-26 02:08:55');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (175000370, null,null, 1203507743, null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (180320018, null,null, 1203507743, null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (236980131, null,922361081, 1203507743, null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (242416684, null,null, 1203507743,'2020-08-31 15:44:11');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (245888039, null,null, 1203507743,'2020-08-31 15:43:10');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (299874035, null,1991039758, null, '2020-07-27 13:04:21');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (300345760, null,1410357342, 1991039758,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (349287102, null,null, 1203507743,'2020-08-31 15:44:11');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (358551119, null,922361081, 1203507743,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (381048064, null,null, 1203507743, null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (382883314, null,476796651, 1203507743, null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (393721566, null,null, 1203507743,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (422226530, null,1804306381, 1203507743,'2020-09-25 15:38:26');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (532238363, null,591041002, 1203507743,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (548214898, null,922361081, 1203507743,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (726703756, null,922361081, 1203507743, '2020-09-26 00:54:32');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (747840381, null,372352980, 1203507743,'2020-09-25 15:38:26');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (774301972, null,922361081, 1203507743,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (834540181, null,null, 1203507743,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (837742090, null,null, 1203507743,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (911255059, null,922361081, 1203507743,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (968779096, null,476796651, 1203507743, null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (979831281, null,null, 1203507743,'2020-08-31 15:44:11');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1052705800, null,null, 1203507743, null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1065846907, null,null, 1203507743, '2020-08-31 15:44:11');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1072751580, null,346016195, 1203507743, '2020-09-25 15:38:26');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1160421754, null,89970722, 1203507743,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1229749737, null,null, 1203507743,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1256360667, null,null, 1203507743,'2020-09-04 08:02:45');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1268274177, null,null, 1203507743, '2020-08-31 15:44:11');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1322818209, null,null, 1203507743, null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1356279794, null,922361081, 1203507743, null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1359315922, null,171983268, 1203507743, null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1422437965, null,922361081, 1203507743, null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1427592538, null,922361081, 1203507743,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1439026791, null,970766793, 1203507743, '2020-09-25 15:38:26');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1515421897, null,476796651, 1203507743, null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1523818119, null,null, 1203507743,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1536402587, null,null, 1203507743,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1552424523, null,null, 1203507743, null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1577468510, null,922361081, 1203507743,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1603924278, null,null, 1203507743,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1692438807, null,61781396, 1203507743, '2020-09-25 15:38:26');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1742672004, null,346016195, 1203507743, '2020-09-25 15:07:19');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1745708456, null,910348948, 1203507743, null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1784124366, null,1804306381, 1203507743, '2020-09-25 15:38:26');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1785017825, null, null, 1203507743,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1856004021, null,null, 1203507743, null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1991339554, null,328894664, 1203507743, null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (1999490201, null,null, 1203507743, '2020-08-31 15:44:11');
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (2036231011, null,null, 1203507743,null);
INSERT INTO test_1.estimate (estimate_id,invoice_id, customer_id, host_id, deleted_at) VALUES (2042213331, null,null, 1203507743, null);
INSERT INTO test_1.host (host_id, deleted_at) VALUES (1203507743,null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (61781396, 1203507743,null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (89970722, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (152285761, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (171983268, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (214640730, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (328894664, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (346016195, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (372352980, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (476796651, 1203507743,null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (591041002, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (623215491, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (670487944, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (708319169, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (898384507, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (910348948, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (920715431, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (922361081, 1203507743,null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (970766793, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (990664288, 1203507743,null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (1377412284, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (1399417056, 1203507743,null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (1422392005, 1203507743,null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (1476369726, 1203507743,null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (1481296540, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (1489346753, 1203507743,null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (1567640626, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (1670031530, 1203507743,null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (1714646629, 1203507743,null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (1804306381, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (1814807622, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (1907213687, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (1946015275, 1203507743, null);
INSERT INTO test_1.customer (customer_id, host_id, deleted_at) VALUES (2040202299, 1203507743, null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (149605796, null, null, 1203507743, null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (298429483, null, null, 1203507743, '2020-09-14 14:50:10');
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (414201883, null, null, 1203507743,null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (469165603, null, null, 1203507743, null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (524039149, 548214898, 922361081, 1203507743,null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (577871384, null, null, 1203507743,'2020-09-15 18:50:49');
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (650214673, null, null, 1203507743, '2020-09-03 16:46:25');
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (693978639, 1692438807, 61781396, 1203507743, null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (755455819, null, null, 1203507743,null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (773136329, null, null, 1203507743, null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (816749791, null, null, 1203507743, null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (936463529, null, null, 1203507743, null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (974282655, null, null, 1203507743,null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (986426253, 174710775, 922361081, 1203507743,null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (1010071563, null, null, 1203507743,null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (1118773350, null, 922361081, 1203507743, null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (1242845214, null, null, 1203507743,null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (1299190302, 1742672004, 346016195, 1203507743,null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (1354452965, null, null, 1203507743, '2020-09-14 14:50:10');
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (1383172622, null, null, 1203507743, null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (1406215183, null, null, 1203507743, null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (1482624057, null, null, 1203507743, '2020-09-16 09:53:55');
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (1492806334, null, null, 1203507743,null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (1605480346, null, null, 1203507743,null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (1712707189, null, null, 1203507743,null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (1825770574, null, null, 1203507743, null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (1896064108, null, null, 1203507743, null);
INSERT INTO test_1.invoice (invoice_id, estimate_id, customer_id, host_id, deleted_at) VALUES (2027245902, null, null, 1203507743, null);
```
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment