0% found this document useful (0 votes)
12 views28 pages

Cresa

The document contains SQL insert statements for populating three tables: users, addresses, and cart, with user information, addresses, and cart statuses respectively. Additionally, it includes product and product_variant insert statements detailing product titles, descriptions, prices, and stock levels. Each section is structured to facilitate the insertion of multiple records into a database for a user management and e-commerce system.

Uploaded by

santiagoxgames
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
12 views28 pages

Cresa

The document contains SQL insert statements for populating three tables: users, addresses, and cart, with user information, addresses, and cart statuses respectively. Additionally, it includes product and product_variant insert statements detailing product titles, descriptions, prices, and stock levels. Each section is structured to facilitate the insertion of multiple records into a database for a user management and e-commerce system.

Uploaded by

santiagoxgames
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 28

INSERT INTO users (username, email, first_name, last_name, phone, picture)

VALUES
('fmorris', 'user1@example.com', 'Andre', 'Phillips', '001-705-498-3182x048',
NULL),
('courtneymurphy', 'user2@example.com', 'Michael', 'Parker', '444.441.8849',
'https://picsum.photos/420/16'),
('shannon07', 'user3@example.com', 'Heather', 'Ramos', '(416)482-5195x58238',
'https://placekitten.com/497/358'),
('marissaday', 'user4@example.com', 'Jane', 'Gonzalez', '(677)893-5155x8973',
NULL),
('debra39', 'user5@example.com', 'Michelle', 'Pierce', '610-401-8495',
'https://placekitten.com/212/234'),
('cyork', 'user6@example.com', 'Autumn', 'Velez', '001-856-516-9305x115', NULL),
('cabrerasharon', 'user7@example.com', 'Richard', 'Stanton', '001-812-955-2772',
NULL),
('michaelmullins', 'user8@example.com', 'Kimberly', 'Wilson', '+1-269-987-
2119x122', NULL),
('timothy79', 'user9@example.com', 'Ashley', 'Smith', '910-203-6863',
'https://dummyimage.com/903x1011'),
('torresdarrell', 'user10@example.com', 'Rachel', 'Cordova', '541-548-7815x9364',
NULL),
('bvelazquez', 'user11@example.com', 'Kathleen', 'Neal', '982.935.9273', NULL),
('tmartinez', 'user12@example.com', 'Virginia', 'Mccarthy', '443-629-2593',
'https://picsum.photos/457/118'),
('mhester', 'user13@example.com', 'Madeline', 'Martinez', '959.783.0210x90323',
'https://picsum.photos/42/647'),
('clarkemily', 'user14@example.com', 'Patricia', 'Thompson', '536.885.5361x5029',
'https://picsum.photos/811/523'),
('scottrebecca', 'user15@example.com', 'Christina', 'Martinez', '001-937-886-
7097x959', NULL),
('huntelizabeth', 'user16@example.com', 'Linda', 'Oneal', '+1-344-632-0038x1377',
'https://placekitten.com/274/12'),
('wayne24', 'user17@example.com', 'Amy', 'Mullen', '001-438-732-9571', NULL),
('elizabethjohnson', 'user18@example.com', 'Jenny', 'Fisher', '502-896-1755x273',
'https://picsum.photos/886/836'),
('jeffery76', 'user19@example.com', 'Sheri', 'Mcdonald', '235.556.8677x783',
NULL),
('hayesronald', 'user20@example.com', 'Amy', 'Perez', '624.576.5348x09561',
'https://picsum.photos/509/262'),
('hallalicia', 'user21@example.com', 'Heidi', 'Hoffman', '+1-558-503-6462',
NULL),
('robertmcdaniel', 'user22@example.com', 'Angela', 'Aguilar', '(375)642-
9931x82097', NULL),
('hectorlynch', 'user23@example.com', 'Michael', 'Brown', '(792)246-9372', NULL),
('qcunningham', 'user24@example.com', 'Sandra', 'Walker', '(961)571-9342x82478',
'https://picsum.photos/120/938'),
('ggarcia', 'user25@example.com', 'Hunter', 'Reyes', '(870)983-2284', NULL),
('samanthakoch', 'user26@example.com', 'Danielle', 'Craig', '747.255.1559',
NULL),
('fitzgeraldfrank', 'user27@example.com', 'Frank', 'Lucero', '+1-473-946-
7308x355', NULL),
('fweeks', 'user28@example.com', 'Anthony', 'Wheeler', '001-997-343-2696', NULL),
('julieedwards', 'user29@example.com', 'Allison', 'Griffin', '001-391-616-4547',
NULL),
('conleyrichard', 'user30@example.com', 'Ryan', 'Jackson', '617.963.6707x244',
'https://picsum.photos/885/130'),
('nelsonpaula', 'user31@example.com', 'Jo', 'Harmon', '507-227-0654',
'https://dummyimage.com/920x661'),
('christina36', 'user32@example.com', 'Sharon', 'Lewis', '8353966647', NULL),
('michaelmoore', 'user33@example.com', 'Kimberly', 'Simpson', '892.620.4105',
'https://picsum.photos/26/759'),
('darleneday', 'user34@example.com', 'Richard', 'Barber', '(515)955-1472x22584',
'https://dummyimage.com/229x280'),
('hmejia', 'user35@example.com', 'Cassandra', 'Merritt', '8776842617', NULL),
('clarkdaniel', 'user36@example.com', 'Patricia', 'Lopez', '+1-878-939-7441',
NULL),
('johnsonbrandon', 'user37@example.com', 'Diana', 'Henderson', '519.504.0725',
NULL),
('scott94', 'user38@example.com', 'Kelly', 'Montgomery', '001-696-599-1158x391',
NULL),
('christopherhartman', 'user39@example.com', 'Julie', 'Jones', '+1-381-699-
0843x9978', 'https://picsum.photos/397/791'),
('stephenbyrd', 'user40@example.com', 'Larry', 'May', '(830)811-2983', NULL),
('ivanmason', 'user41@example.com', 'Alan', 'Werner', '278-454-3676', NULL),
('susan06', 'user42@example.com', 'Russell', 'Scott', '448-301-7025x823',
'https://picsum.photos/239/853'),
('tracymckinney', 'user43@example.com', 'Kelly', 'Aguirre', '524-242-2011x6309',
'https://dummyimage.com/582x314'),
('mariediaz', 'user44@example.com', 'Kathleen', 'Williamson', '486-927-9410x020',
'https://placekitten.com/437/176'),
('kristifreeman', 'user45@example.com', 'Anthony', 'Taylor', '(874)332-6102',
NULL),
('ogordon', 'user46@example.com', 'Destiny', 'Mullins', '001-706-522-7250x30296',
'https://placekitten.com/845/299'),
('snyderjoshua', 'user47@example.com', 'Ebony', 'Knight', '(927)424-1872', NULL),
('mandyharrell', 'user48@example.com', 'Carl', 'Wheeler', '+1-848-236-4388x3963',
NULL),
('janiceespinoza', 'user49@example.com', 'Aaron', 'Nielsen', '(878)771-
7346x34649', NULL),
('tjones', 'user50@example.com', 'Mary', 'Smith', '494.866.3223x4563', NULL);

INSERT INTO addresses (user_id, address_line, address_line2)


VALUES
('1', '5492 Spencer Heights', NULL),
('2', '02242 Parrish Center Suite 455', NULL),
('3', '736 Angela Ranch', NULL),
('4', '69745 Jenkins Grove', NULL),
('5', '1987 Kimberly Pines', 'Apt. 798'),
('6', '22469 Lance Pines Suite 350', 'Suite 209'),
('7', '2580 Barry Ranch Suite 728', 'Suite 034'),
('8', '5888 Clarke Station', 'Apt. 144'),
('9', '2979 Garrett Spur Suite 305', NULL),
('10', '9701 Baker Way Apt. 438', NULL),
('11', '222 Young Haven', 'Suite 181'),
('12', '42157 Daniel Parks Apt. 807', 'Apt. 359'),
('13', '7638 Emily Road Apt. 096', NULL),
('14', '579 Parker Club', NULL),
('15', '7954 Wheeler Streets Apt. 182', 'Apt. 723'),
('16', '4058 Carolyn Passage', NULL),
('17', '6074 Krystal Harbors Suite 021', 'Apt. 666'),
('18', '46040 Carl Land Suite 915', NULL),
('19', '4334 Pamela Mission', NULL),
('20', '5064 Fox Expressway', 'Suite 150'),
('21', '90709 Rogers Rapid Apt. 160', NULL),
('22', '13669 Hunter Hill Apt. 120', 'Suite 447'),
('23', '288 James Glens', 'Suite 944'),
('24', '9891 Erickson Valleys', 'Suite 038'),
('25', '57730 Karen Rue', 'Suite 479'),
('26', '3446 Keller Drive', 'Apt. 398'),
('27', '3429 Brittany Island', 'Apt. 128'),
('28', '7945 Austin Isle Apt. 282', 'Suite 319'),
('29', '72068 Campbell Curve', 'Suite 309'),
('30', '652 Jerry Station Suite 801', 'Apt. 582'),
('31', '13612 Bradley Estate Suite 494', 'Suite 709'),
('32', '193 Joseph Ports', NULL),
('33', '83354 Moreno Mountains Suite 340', NULL),
('34', '820 Jeffrey Lock', NULL),
('35', '04997 Michael Fort Apt. 103', NULL),
('36', '75084 Grant Ridge', 'Suite 374'),
('37', '5824 Leach Crossing Apt. 199', 'Suite 933'),
('38', '0048 Wade Fort', 'Apt. 372'),
('39', '64751 Amber Manors Apt. 637', NULL),
('40', '8196 Haley River', NULL),
('41', '19046 Cynthia Manors Suite 888', 'Suite 184'),
('42', '8868 Green Walks Apt. 440', NULL),
('43', '117 Chang Skyway', NULL),
('44', '760 Katie Mountain', 'Suite 647'),
('45', '056 Amanda Route', NULL),
('46', '9214 Sheppard Mountains', NULL),
('47', '837 Cabrera Valleys Apt. 035', 'Apt. 952'),
('48', '12138 Elizabeth Way', 'Apt. 654'),
('49', '6561 Phillip Key', NULL),
('50', '35206 Browning Station Apt. 354', NULL);

INSERT INTO cart (user_id, status)


VALUES
('1', 'active'),
('2', 'active'),
('3', 'active'),
('4', 'active'),
('5', 'active'),
('6', 'active'),
('7', 'active'),
('8', 'active'),
('9', 'active'),
('10', 'active'),
('11', 'active'),
('12', 'active'),
('13', 'active'),
('14', 'active'),
('15', 'active'),
('16', 'active'),
('17', 'active'),
('18', 'active'),
('19', 'active'),
('20', 'active'),
('21', 'active'),
('22', 'active'),
('23', 'active'),
('24', 'active'),
('25', 'active'),
('26', 'active'),
('27', 'active'),
('28', 'active'),
('29', 'active'),
('30', 'active'),
('31', 'active'),
('32', 'active'),
('33', 'active'),
('34', 'active'),
('35', 'active'),
('36', 'active'),
('37', 'active'),
('38', 'active'),
('39', 'active'),
('40', 'active'),
('41', 'active'),
('42', 'active'),
('43', 'active'),
('44', 'active'),
('45', 'active'),
('46', 'active'),
('47', 'active'),
('48', 'active'),
('49', 'active'),
('50', 'active');

INSERT INTO product (title, description)


VALUES
('Brother East', 'Me vote if matter the team address.'),
('Room Economy', 'Use six information small wrong compare.'),
('Your Happy', 'Coach will notice rate operation eat.'),
('Current So', 'There alone fly major possible leader employee.'),
('Image Executive', 'Somebody season significant area brother difficult think.'),
('Tend Far', 'Small car customer low summer test national.'),
('Work Those', 'Professor say on enter color all drop.'),
('Evidence Religious', 'Stay situation every test.'),
('Wrong Total', 'Man final time increase.'),
('Provide Create', 'Great less follow recently.'),
('Training Whatever', 'Later eye knowledge former.'),
('Staff Spend', 'Standard final west human.'),
('Couple Sound', 'Chance important number fish price.'),
('Response A', 'Thought race effect one forward.'),
('Coach Congress', 'Blue total bed find me.'),
('Realize Would', 'Get field have.'),
('Know Along', 'Us run behind.'),
('Always Machine', 'Give successful main some out.'),
('Adult Natural', 'Fund relationship take young.'),
('Financial Nearly', 'Shoulder what identify change second particularly.'),
('Position Soldier', 'Machine charge suggest media everyone movement it.'),
('Argue Report', 'Finish world now somebody maintain theory.'),
('Way Coach', 'American resource not figure public professional.'),
('Feeling It', 'Little nation may those.'),
('Last Road', 'Data who grow professional quite.'),
('Method Site', 'Full finally rather oil me throw play.'),
('Grow Within', 'Share almost hold run for nothing do during.'),
('Name Skin', 'Speak owner drug side for city before.'),
('Bad Ask', 'Our enjoy research by size entire.'),
('Market Position', 'Artist head foot market control blue likely.'),
('Do Place', 'Later speech yet.'),
('Ten Party', 'Citizen performance organization opportunity anyone program.'),
('Keep Concern', 'Investment out on hot chair far.'),
('Character Explain', 'Report hair leader weight.'),
('Free From', 'Again prove perhaps interesting sing every bit.'),
('Spring Change', 'Be color reason machine skin.'),
('Matter Force', 'Share five learn language present.'),
('Describe Four', 'Lose often dog young.'),
('Her Parent', 'Ten simply within remain development.'),
('Important Approach', 'Rise develop field test third.'),
('Police Last', 'Decide sport three goal.'),
('Wrong Woman', 'Sister throughout believe deep natural forward soon.'),
('Improve Reason', 'Bank as perhaps baby up some machine science.'),
('Before Determine', 'Owner remember focus will that wear one.'),
('Hair Watch', 'Around themselves process chance rest.'),
('Information Anyone', 'Turn history reality paper attorney.'),
('Help Job', 'Society debate help evidence spend involve wrong.'),
('Stock Wish', 'Safe moment whom girl.'),
('Worker Affect', 'Eat artist feel his gas imagine enjoy.'),
('Medical Side', 'Need organization thousand however.');

INSERT INTO product_variant (product_id, price, stock)


VALUES
('43', '318.8', '470'),
('31', '218.01', '137'),
('2', '446.3', '386'),
('6', '307.73', '311'),
('1', '432.63', '435'),
('34', '255.25', '14'),
('41', '172.47', '284'),
('10', '434.23', '292'),
('21', '205.35', '254'),
('42', '434.46', '475'),
('5', '459.55', '326'),
('44', '137.96', '381'),
('24', '33.59', '434'),
('24', '463.68', '456'),
('49', '111.84', '62'),
('18', '199.77', '97'),
('20', '413.46', '306'),
('34', '63.77', '326'),
('10', '369.67', '218'),
('38', '178.84', '288'),
('7', '402.22', '220'),
('20', '57.01', '431'),
('10', '114.35', '68'),
('36', '338.83', '7'),
('22', '317.36', '431'),
('19', '71.52', '84'),
('48', '256.15', '70'),
('49', '232.31', '257'),
('9', '451.61', '276'),
('49', '41.71', '368'),
('35', '97.41', '341'),
('3', '457.98', '0'),
('8', '198.14', '459'),
('6', '115.1', '78'),
('33', '372.78', '362'),
('37', '356.06', '41'),
('8', '94.72', '105'),
('31', '411.86', '6'),
('18', '258.32', '9'),
('1', '469.8', '124'),
('6', '105.78', '83'),
('33', '11.36', '317'),
('43', '17.93', '87'),
('6', '415.52', '389'),
('10', '300.85', '259'),
('21', '411.88', '347'),
('25', '204.64', '125'),
('47', '383.77', '109'),
('14', '167.82', '261'),
('25', '242.83', '303'),
('3', '47.99', '303'),
('40', '319.81', '500'),
('23', '160.23', '264'),
('41', '408.06', '57'),
('39', '70.69', '351'),
('38', '416.23', '292'),
('33', '289.44', '187'),
('11', '308.11', '493'),
('45', '434.23', '121'),
('48', '307.82', '343'),
('18', '59.27', '52'),
('40', '270.33', '150'),
('14', '82.43', '407'),
('6', '96.73', '154'),
('13', '272.57', '465'),
('2', '237.09', '174'),
('26', '436.77', '275'),
('13', '266.44', '359'),
('2', '320.27', '264'),
('2', '271.81', '119'),
('39', '193.68', '103'),
('45', '266.24', '76'),
('19', '386.77', '426'),
('6', '484.33', '204'),
('34', '480.52', '418'),
('47', '209.66', '194'),
('24', '120.47', '381'),
('24', '229.83', '86'),
('38', '47.4', '43'),
('26', '326.95', '395'),
('49', '76.46', '241'),
('2', '120.25', '149'),
('35', '87.28', '82'),
('9', '59.48', '123'),
('44', '214.79', '37'),
('39', '250.02', '14'),
('45', '405.53', '206'),
('7', '489.88', '431'),
('30', '314.97', '246'),
('12', '484.88', '345'),
('19', '113.53', '63'),
('29', '75.16', '185'),
('47', '309.89', '314'),
('35', '413.54', '56'),
('11', '122.22', '299'),
('34', '120.25', '23'),
('31', '227.3', '378'),
('39', '262.86', '364'),
('32', '265.21', '163'),
('42', '481.77', '134'),
('18', '191.2', '500'),
('33', '175.03', '430'),
('16', '491.73', '134'),
('36', '237.93', '85'),
('34', '92.16', '377'),
('25', '459.01', '244'),
('30', '443.43', '144'),
('15', '307.17', '319'),
('20', '138.11', '220'),
('45', '437.66', '356'),
('45', '255.86', '475'),
('17', '308.27', '338'),
('35', '476.79', '64'),
('13', '372.97', '468'),
('44', '178.69', '180'),
('28', '344.13', '419'),
('27', '47.11', '1'),
('43', '175.03', '118'),
('42', '407.35', '104'),
('32', '61.86', '412'),
('4', '169.47', '497'),
('26', '426.32', '243'),
('17', '255.13', '145'),
('43', '411.32', '281'),
('38', '193.23', '81'),
('40', '227.95', '448'),
('16', '218.01', '135'),
('26', '448.29', '320'),
('24', '223.11', '299'),
('17', '289.16', '80'),
('32', '20.95', '25'),
('30', '11.17', '467'),
('23', '279.4', '392'),
('1', '71.27', '52'),
('7', '191.0', '223'),
('23', '440.85', '395'),
('18', '464.26', '442'),
('36', '492.07', '37'),
('18', '480.09', '70'),
('19', '380.89', '0'),
('5', '101.73', '68'),
('16', '425.38', '308'),
('47', '477.2', '214'),
('1', '347.57', '265'),
('21', '409.38', '320'),
('1', '18.29', '433'),
('31', '305.21', '255'),
('38', '472.97', '102'),
('37', '462.52', '376'),
('47', '296.88', '178'),
('21', '149.15', '104'),
('16', '129.9', '325'),
('6', '158.7', '155'),
('6', '405.47', '56'),
('1', '234.29', '498'),
('48', '475.81', '391'),
('3', '301.65', '63'),
('43', '254.46', '85'),
('4', '19.15', '483'),
('12', '10.55', '440'),
('38', '315.94', '446'),
('23', '130.49', '273'),
('47', '284.51', '447'),
('34', '424.0', '424'),
('21', '262.64', '276'),
('18', '303.78', '308'),
('16', '24.38', '47'),
('39', '368.22', '103'),
('44', '253.6', '399'),
('3', '199.08', '87'),
('26', '208.28', '173'),
('19', '347.79', '155'),
('8', '286.15', '380'),
('9', '238.2', '476'),
('22', '409.34', '417'),
('4', '472.82', '341'),
('9', '307.96', '385'),
('5', '57.95', '92'),
('15', '321.14', '207'),
('7', '105.22', '212'),
('37', '268.52', '309'),
('26', '336.46', '254'),
('43', '326.13', '297'),
('32', '195.57', '325'),
('46', '386.4', '70'),
('8', '59.6', '485'),
('16', '403.04', '295'),
('9', '329.87', '115'),
('50', '390.68', '427'),
('13', '405.34', '467'),
('43', '87.92', '425'),
('36', '182.96', '256'),
('5', '355.58', '448'),
('15', '370.49', '370'),
('31', '249.01', '468'),
('12', '499.08', '184'),
('25', '243.34', '297'),
('17', '48.5', '118'),
('1', '495.89', '112'),
('50', '58.52', '0');

INSERT INTO cart_item (cart_id, product_variant_id, price_at_time)


VALUES
('23', '123', '225.55'),
('1', '86', '309.03'),
('45', '1', '130.83'),
('13', '152', '304.36'),
('10', '52', '77.75'),
('39', '88', '142.64'),
('2', '57', '167.26'),
('3', '22', '10.4'),
('28', '140', '110.77'),
('12', '153', '316.12'),
('9', '81', '256.08'),
('20', '166', '490.39'),
('31', '166', '312.3'),
('21', '165', '247.58'),
('13', '136', '351.59'),
('33', '148', '394.52'),
('14', '186', '161.56'),
('4', '66', '484.61'),
('27', '116', '245.76'),
('50', '173', '39.93'),
('17', '115', '492.68'),
('47', '9', '52.59'),
('19', '57', '134.63'),
('30', '2', '238.42'),
('45', '140', '141.72'),
('11', '199', '440.94'),
('12', '109', '451.76'),
('31', '177', '238.31'),
('43', '151', '17.0'),
('25', '82', '418.07'),
('35', '28', '439.45'),
('41', '163', '219.94'),
('12', '127', '255.24'),
('47', '57', '282.46'),
('22', '67', '172.93'),
('42', '52', '478.86'),
('7', '149', '485.39'),
('30', '114', '318.2'),
('47', '75', '369.33'),
('10', '56', '256.34'),
('45', '23', '284.15'),
('42', '180', '203.05'),
('25', '173', '350.02'),
('18', '158', '222.08'),
('32', '53', '71.31'),
('49', '39', '139.52'),
('21', '169', '172.62'),
('1', '10', '93.96'),
('43', '199', '16.25'),
('32', '199', '74.96'),
('12', '111', '306.09'),
('44', '24', '192.78'),
('3', '172', '482.49'),
('50', '49', '49.19'),
('18', '142', '194.14'),
('2', '91', '358.77'),
('45', '16', '49.56'),
('5', '117', '205.6'),
('39', '149', '232.47'),
('34', '89', '367.57'),
('46', '54', '42.27'),
('38', '105', '364.19'),
('23', '150', '165.53'),
('31', '44', '476.28'),
('46', '63', '49.54'),
('29', '111', '232.28'),
('11', '139', '369.51'),
('35', '188', '136.84'),
('49', '187', '465.14'),
('3', '165', '190.24'),
('4', '164', '464.64'),
('34', '110', '241.64'),
('13', '151', '282.09'),
('34', '128', '225.79'),
('34', '18', '52.96'),
('6', '157', '373.17'),
('40', '168', '418.58'),
('12', '42', '184.32'),
('47', '100', '371.73'),
('19', '29', '478.81'),
('24', '89', '277.47'),
('44', '37', '66.09'),
('24', '153', '22.81'),
('1', '151', '378.29'),
('33', '165', '235.27'),
('29', '79', '480.88'),
('34', '130', '257.53'),
('9', '110', '389.45'),
('19', '175', '459.85'),
('10', '108', '232.82'),
('40', '79', '303.27'),
('8', '56', '430.0'),
('12', '136', '10.37'),
('21', '84', '396.01'),
('2', '168', '278.58'),
('22', '73', '48.05'),
('41', '62', '198.35'),
('10', '1', '154.09'),
('33', '122', '215.16'),
('41', '25', '368.17'),
('30', '86', '282.81'),
('24', '137', '85.71'),
('17', '98', '146.12'),
('19', '159', '12.42'),
('45', '4', '212.13'),
('47', '120', '104.36'),
('28', '52', '59.12'),
('34', '187', '140.97'),
('29', '81', '229.49'),
('32', '43', '38.23'),
('45', '196', '305.77'),
('6', '143', '179.21'),
('11', '118', '454.62'),
('32', '116', '91.39'),
('46', '115', '363.27'),
('24', '48', '424.26'),
('13', '112', '212.05'),
('43', '6', '57.56'),
('4', '143', '85.69'),
('16', '108', '16.56'),
('33', '124', '201.11'),
('33', '179', '93.81'),
('43', '180', '99.86'),
('40', '1', '282.42'),
('9', '96', '25.04'),
('29', '129', '51.08'),
('48', '160', '406.69'),
('14', '192', '263.66'),
('15', '157', '156.3'),
('13', '105', '7.89'),
('47', '15', '181.17'),
('21', '97', '9.83'),
('7', '43', '379.96'),
('33', '190', '496.92'),
('44', '16', '272.88'),
('24', '132', '209.37'),
('20', '46', '174.95'),
('1', '139', '477.69'),
('40', '3', '26.37'),
('10', '32', '466.43'),
('19', '99', '225.51'),
('45', '182', '444.82'),
('17', '175', '212.07'),
('5', '127', '222.24'),
('9', '180', '293.2'),
('12', '78', '324.83'),
('41', '196', '422.39'),
('26', '186', '81.71'),
('31', '2', '464.52'),
('38', '72', '382.26'),
('19', '165', '152.96'),
('46', '149', '126.1'),
('48', '91', '110.02'),
('43', '159', '148.62'),
('6', '30', '118.87'),
('4', '186', '315.05'),
('6', '94', '290.37'),
('33', '112', '408.43'),
('35', '182', '176.96'),
('8', '76', '178.03'),
('18', '175', '455.97'),
('10', '82', '173.29'),
('17', '42', '223.11'),
('13', '20', '229.46'),
('38', '19', '86.01'),
('3', '171', '422.86'),
('22', '184', '238.89'),
('32', '152', '321.55'),
('9', '111', '334.95'),
('4', '5', '288.21'),
('26', '35', '94.24'),
('41', '54', '314.46'),
('12', '82', '251.36'),
('47', '67', '308.01'),
('28', '72', '30.36'),
('10', '66', '235.59'),
('27', '27', '166.08'),
('27', '146', '377.58'),
('40', '55', '459.24'),
('38', '3', '267.27'),
('38', '67', '49.93'),
('48', '77', '466.21'),
('23', '176', '394.04'),
('26', '19', '435.38'),
('6', '190', '191.6'),
('24', '86', '304.12'),
('24', '31', '465.41'),
('12', '194', '160.0'),
('24', '40', '406.2'),
('25', '103', '71.14'),
('35', '168', '10.77'),
('30', '126', '261.66'),
('20', '91', '68.65'),
('19', '71', '231.95'),
('40', '39', '9.43'),
('1', '129', '111.2'),
('30', '144', '10.46'),
('40', '57', '461.04'),
('40', '176', '287.55'),
('14', '102', '472.86');

INSERT INTO category (parent_id, name)


VALUES
(NULL, 'Category_1'),
(NULL, 'Category_2'),
(NULL, 'Category_3'),
(NULL, 'Category_4'),
(NULL, 'Category_5'),
(NULL, 'Category_6'),
(NULL, 'Category_7'),
(NULL, 'Category_8'),
(NULL, 'Category_9'),
(NULL, 'Category_10'),
('7', 'Category_11'),
('4', 'Category_12'),
('4', 'Category_13'),
('8', 'Category_14'),
('10', 'Category_15'),
('9', 'Category_16'),
('8', 'Category_17'),
('1', 'Category_18'),
('6', 'Category_19'),
('2', 'Category_20'),
('6', 'Category_21'),
('6', 'Category_22'),
('3', 'Category_23'),
('10', 'Category_24'),
('9', 'Category_25'),
('1', 'Category_26'),
('4', 'Category_27'),
('8', 'Category_28'),
('2', 'Category_29'),
('5', 'Category_30'),
('1', 'Category_31'),
('3', 'Category_32'),
('1', 'Category_33'),
('7', 'Category_34'),
('4', 'Category_35'),
('2', 'Category_36'),
('3', 'Category_37'),
('7', 'Category_38'),
('3', 'Category_39'),
('10', 'Category_40'),
('10', 'Category_41'),
('3', 'Category_42'),
('4', 'Category_43'),
('9', 'Category_44'),
('5', 'Category_45'),
('2', 'Category_46'),
('9', 'Category_47'),
('7', 'Category_48'),
('2', 'Category_49'),
('7', 'Category_50');
INSERT INTO product_category (product_id, category_id)
VALUES
('1', '21'),
('2', '28'),
('2', '1'),
('2', '8'),
('3', '39'),
('3', '34'),
('3', '35'),
('4', '17'),
('4', '25'),
('4', '36'),
('5', '15'),
('5', '28'),
('6', '1'),
('6', '47'),
('7', '19'),
('7', '27'),
('7', '28'),
('8', '32'),
('8', '46'),
('8', '42'),
('9', '23'),
('9', '5'),
('9', '19'),
('10', '2'),
('10', '36'),
('11', '15'),
('11', '12'),
('11', '22'),
('12', '2'),
('12', '48'),
('12', '45'),
('13', '17'),
('13', '21'),
('13', '35'),
('14', '50'),
('15', '14'),
('15', '31'),
('15', '42'),
('16', '48'),
('17', '23'),
('18', '25'),
('18', '20'),
('18', '22'),
('19', '41'),
('19', '24'),
('20', '42'),
('20', '48'),
('20', '14'),
('21', '17'),
('21', '6'),
('21', '16'),
('22', '24'),
('22', '5'),
('23', '35'),
('23', '1'),
('24', '32'),
('24', '50'),
('24', '9'),
('25', '8'),
('25', '3'),
('26', '6'),
('26', '16'),
('27', '48'),
('27', '12'),
('28', '44'),
('29', '40'),
('30', '6'),
('31', '1'),
('31', '4'),
('32', '9'),
('32', '10'),
('33', '42'),
('33', '1'),
('34', '5'),
('35', '4'),
('35', '27'),
('35', '19'),
('36', '11'),
('36', '49'),
('36', '25'),
('37', '27'),
('37', '26'),
('38', '30'),
('38', '38'),
('39', '21'),
('40', '8'),
('41', '41'),
('41', '11'),
('41', '48'),
('42', '41'),
('42', '4'),
('42', '23'),
('43', '49'),
('44', '22'),
('45', '30'),
('45', '7'),
('45', '26'),
('46', '35'),
('46', '47'),
('46', '38'),
('47', '7'),
('47', '20'),
('48', '28'),
('48', '48'),
('49', '31'),
('49', '34'),
('50', '11'),
('50', '38'),
('50', '16');

INSERT INTO product_attribute_type (name)


VALUES
('AttrType_1'),
('AttrType_2'),
('AttrType_3'),
('AttrType_4'),
('AttrType_5'),
('AttrType_6'),
('AttrType_7'),
('AttrType_8'),
('AttrType_9'),
('AttrType_10'),
('AttrType_11'),
('AttrType_12'),
('AttrType_13'),
('AttrType_14'),
('AttrType_15'),
('AttrType_16'),
('AttrType_17'),
('AttrType_18'),
('AttrType_19'),
('AttrType_20'),
('AttrType_21'),
('AttrType_22'),
('AttrType_23'),
('AttrType_24'),
('AttrType_25'),
('AttrType_26'),
('AttrType_27'),
('AttrType_28'),
('AttrType_29'),
('AttrType_30'),
('AttrType_31'),
('AttrType_32'),
('AttrType_33'),
('AttrType_34'),
('AttrType_35'),
('AttrType_36'),
('AttrType_37'),
('AttrType_38'),
('AttrType_39'),
('AttrType_40'),
('AttrType_41'),
('AttrType_42'),
('AttrType_43'),
('AttrType_44'),
('AttrType_45'),
('AttrType_46'),
('AttrType_47'),
('AttrType_48'),
('AttrType_49'),
('AttrType_50'),
('AttrType_51'),
('AttrType_52'),
('AttrType_53'),
('AttrType_54'),
('AttrType_55'),
('AttrType_56'),
('AttrType_57'),
('AttrType_58'),
('AttrType_59'),
('AttrType_60'),
('AttrType_61'),
('AttrType_62'),
('AttrType_63'),
('AttrType_64'),
('AttrType_65'),
('AttrType_66'),
('AttrType_67'),
('AttrType_68'),
('AttrType_69'),
('AttrType_70'),
('AttrType_71'),
('AttrType_72'),
('AttrType_73'),
('AttrType_74'),
('AttrType_75'),
('AttrType_76'),
('AttrType_77'),
('AttrType_78'),
('AttrType_79'),
('AttrType_80'),
('AttrType_81'),
('AttrType_82'),
('AttrType_83'),
('AttrType_84'),
('AttrType_85'),
('AttrType_86'),
('AttrType_87'),
('AttrType_88'),
('AttrType_89'),
('AttrType_90'),
('AttrType_91'),
('AttrType_92'),
('AttrType_93'),
('AttrType_94'),
('AttrType_95'),
('AttrType_96'),
('AttrType_97'),
('AttrType_98'),
('AttrType_99'),
('AttrType_100'),
('AttrType_101'),
('AttrType_102'),
('AttrType_103'),
('AttrType_104'),
('AttrType_105'),
('AttrType_106'),
('AttrType_107'),
('AttrType_108'),
('AttrType_109'),
('AttrType_110'),
('AttrType_111'),
('AttrType_112'),
('AttrType_113'),
('AttrType_114'),
('AttrType_115'),
('AttrType_116'),
('AttrType_117'),
('AttrType_118'),
('AttrType_119'),
('AttrType_120'),
('AttrType_121'),
('AttrType_122'),
('AttrType_123'),
('AttrType_124'),
('AttrType_125'),
('AttrType_126'),
('AttrType_127'),
('AttrType_128'),
('AttrType_129'),
('AttrType_130'),
('AttrType_131'),
('AttrType_132'),
('AttrType_133'),
('AttrType_134'),
('AttrType_135'),
('AttrType_136'),
('AttrType_137'),
('AttrType_138'),
('AttrType_139'),
('AttrType_140'),
('AttrType_141'),
('AttrType_142'),
('AttrType_143'),
('AttrType_144'),
('AttrType_145'),
('AttrType_146'),
('AttrType_147'),
('AttrType_148'),
('AttrType_149'),
('AttrType_150'),
('AttrType_151'),
('AttrType_152'),
('AttrType_153'),
('AttrType_154'),
('AttrType_155'),
('AttrType_156'),
('AttrType_157'),
('AttrType_158'),
('AttrType_159'),
('AttrType_160'),
('AttrType_161'),
('AttrType_162'),
('AttrType_163'),
('AttrType_164'),
('AttrType_165'),
('AttrType_166'),
('AttrType_167'),
('AttrType_168'),
('AttrType_169'),
('AttrType_170'),
('AttrType_171'),
('AttrType_172'),
('AttrType_173'),
('AttrType_174'),
('AttrType_175'),
('AttrType_176'),
('AttrType_177'),
('AttrType_178'),
('AttrType_179'),
('AttrType_180'),
('AttrType_181'),
('AttrType_182'),
('AttrType_183'),
('AttrType_184'),
('AttrType_185'),
('AttrType_186'),
('AttrType_187'),
('AttrType_188'),
('AttrType_189'),
('AttrType_190'),
('AttrType_191'),
('AttrType_192'),
('AttrType_193'),
('AttrType_194'),
('AttrType_195'),
('AttrType_196'),
('AttrType_197'),
('AttrType_198'),
('AttrType_199'),
('AttrType_200');

INSERT INTO product_attribute (product_variant_id,


product_variant_attribute_type_id)
VALUES
('1', '147'),
('1', '141'),
('1', '172'),
('2', '94'),
('2', '191'),
('2', '53'),
('3', '97'),
('3', '41'),
('4', '55'),
('4', '155'),
('4', '184'),
('5', '185'),
('5', '14'),
('5', '47'),
('6', '59'),
('6', '47'),
('7', '48'),
('8', '5'),
('9', '187'),
('10', '91'),
('10', '35'),
('10', '185'),
('11', '125'),
('12', '129'),
('12', '175'),
('13', '59'),
('14', '18'),
('14', '191'),
('15', '164'),
('15', '51'),
('15', '64'),
('16', '171'),
('16', '93'),
('17', '75'),
('17', '96'),
('17', '191'),
('18', '67'),
('18', '12'),
('18', '70'),
('19', '166'),
('19', '95'),
('19', '195'),
('20', '3'),
('21', '157'),
('21', '180'),
('21', '65'),
('22', '8'),
('22', '135'),
('22', '46'),
('23', '113'),
('24', '80'),
('24', '181'),
('24', '120'),
('25', '1'),
('25', '3'),
('25', '87'),
('26', '52'),
('26', '82'),
('26', '26'),
('27', '133'),
('27', '109'),
('28', '170'),
('28', '181'),
('28', '165'),
('29', '133'),
('29', '198'),
('30', '110'),
('30', '9'),
('30', '36'),
('31', '108'),
('32', '188'),
('33', '181'),
('34', '20'),
('35', '117'),
('36', '113'),
('36', '69'),
('37', '66'),
('38', '125'),
('39', '33'),
('40', '180'),
('41', '138'),
('41', '41'),
('42', '28'),
('42', '173'),
('42', '61'),
('43', '93'),
('43', '79'),
('44', '190'),
('44', '22'),
('45', '1'),
('45', '158'),
('45', '193'),
('46', '88'),
('47', '56'),
('47', '65'),
('48', '158'),
('48', '46'),
('48', '81'),
('49', '20'),
('49', '118'),
('49', '42'),
('50', '185'),
('50', '7'),
('51', '104'),
('51', '24'),
('52', '62'),
('53', '124'),
('53', '97'),
('53', '100'),
('54', '110'),
('54', '17'),
('54', '141'),
('55', '136'),
('55', '5'),
('55', '141'),
('56', '181'),
('56', '56'),
('57', '97'),
('57', '137'),
('57', '80'),
('58', '24'),
('59', '190'),
('59', '131'),
('60', '112'),
('60', '42'),
('60', '59'),
('61', '35'),
('61', '85'),
('62', '5'),
('62', '163'),
('62', '22'),
('63', '129'),
('64', '68'),
('65', '84'),
('66', '118'),
('66', '181'),
('66', '69'),
('67', '118'),
('67', '186'),
('67', '176'),
('68', '107'),
('68', '33'),
('69', '88'),
('69', '62'),
('70', '107'),
('71', '182'),
('72', '17'),
('72', '30'),
('72', '170'),
('73', '8'),
('73', '123'),
('74', '186'),
('75', '51'),
('75', '96'),
('75', '25'),
('76', '150'),
('76', '28'),
('77', '43'),
('78', '177'),
('79', '159'),
('79', '118'),
('80', '197'),
('80', '57'),
('80', '92'),
('81', '96'),
('81', '184'),
('82', '111'),
('83', '166'),
('84', '179'),
('84', '199'),
('84', '102'),
('85', '89'),
('85', '135'),
('85', '30'),
('86', '91'),
('86', '143'),
('86', '116'),
('87', '36'),
('87', '16'),
('88', '198'),
('89', '92'),
('89', '179'),
('89', '110'),
('90', '88'),
('90', '101'),
('90', '118'),
('91', '8'),
('91', '175'),
('91', '113'),
('92', '65'),
('92', '114'),
('93', '33'),
('93', '172'),
('93', '35'),
('94', '2'),
('94', '169'),
('94', '67'),
('95', '34'),
('95', '38'),
('96', '92'),
('97', '56'),
('98', '115'),
('98', '107'),
('99', '22'),
('99', '4'),
('100', '100'),
('100', '98'),
('100', '81'),
('101', '167'),
('102', '69'),
('102', '153'),
('103', '109'),
('103', '56'),
('103', '183'),
('104', '73'),
('105', '194'),
('105', '159'),
('106', '89'),
('106', '138'),
('107', '3'),
('107', '134'),
('107', '114'),
('108', '91'),
('108', '198'),
('109', '113'),
('109', '147'),
('109', '52'),
('110', '10'),
('110', '54'),
('110', '175'),
('111', '155'),
('111', '84'),
('112', '34'),
('112', '151'),
('113', '47'),
('114', '140'),
('115', '169'),
('115', '151'),
('115', '88'),
('116', '110'),
('117', '8'),
('117', '20'),
('117', '129'),
('118', '3'),
('118', '80'),
('119', '58'),
('120', '148'),
('120', '117'),
('121', '74'),
('121', '10'),
('121', '185'),
('122', '173'),
('123', '74'),
('124', '126'),
('124', '138'),
('125', '14'),
('126', '137'),
('126', '71'),
('126', '3'),
('127', '136'),
('128', '137'),
('129', '186'),
('130', '151'),
('131', '62'),
('131', '187'),
('132', '177'),
('132', '193'),
('133', '78'),
('133', '183'),
('133', '113'),
('134', '184'),
('134', '142'),
('135', '97'),
('136', '142'),
('136', '35'),
('136', '132'),
('137', '28'),
('137', '5'),
('138', '99'),
('138', '200'),
('139', '197'),
('139', '77'),
('140', '76'),
('141', '166'),
('142', '9'),
('142', '35'),
('143', '85'),
('143', '7'),
('144', '29'),
('144', '188'),
('145', '175'),
('145', '111'),
('145', '40'),
('146', '195'),
('146', '64'),
('146', '178'),
('147', '44'),
('147', '74'),
('148', '93'),
('148', '82'),
('149', '1'),
('150', '141'),
('150', '184'),
('151', '72'),
('152', '149'),
('152', '187'),
('152', '23'),
('153', '160'),
('153', '60'),
('153', '88'),
('154', '189'),
('154', '55'),
('155', '105'),
('156', '75'),
('156', '145'),
('156', '49'),
('157', '89'),
('158', '135'),
('158', '129'),
('159', '154'),
('159', '97'),
('160', '147'),
('160', '143'),
('161', '153'),
('161', '62'),
('162', '2'),
('162', '152'),
('163', '174'),
('163', '130'),
('163', '199'),
('164', '52'),
('165', '41'),
('166', '105'),
('166', '63'),
('167', '89'),
('168', '77'),
('169', '179'),
('169', '120'),
('169', '56'),
('170', '72'),
('170', '108'),
('170', '57'),
('171', '156'),
('171', '124'),
('172', '54'),
('172', '191'),
('172', '52'),
('173', '167'),
('174', '94'),
('174', '196'),
('175', '103'),
('175', '113'),
('175', '88'),
('176', '138'),
('176', '122'),
('177', '77'),
('178', '50'),
('178', '31'),
('179', '182'),
('179', '25'),
('179', '111'),
('180', '79'),
('181', '147'),
('182', '27'),
('182', '75'),
('182', '11'),
('183', '96'),
('183', '56'),
('184', '195'),
('185', '102'),
('186', '120'),
('186', '121'),
('186', '115'),
('187', '61'),
('187', '147'),
('188', '66'),
('188', '15'),
('189', '145'),
('190', '116'),
('190', '137'),
('190', '134'),
('191', '200'),
('191', '77'),
('192', '101'),
('192', '125'),
('193', '188'),
('193', '143'),
('194', '65'),
('195', '149'),
('195', '65'),
('195', '187'),
('196', '154'),
('196', '26'),
('196', '157'),
('197', '39'),
('198', '189'),
('199', '169'),
('200', '172');

INSERT INTO product_attribute_value (value, product_attribute_type_id)


VALUES
('Value_1', '1'),
('Value_2', '2'),
('Value_3', '3'),
('Value_4', '4'),
('Value_5', '5'),
('Value_6', '6'),
('Value_7', '7'),
('Value_8', '8'),
('Value_9', '9'),
('Value_10', '10'),
('Value_11', '11'),
('Value_12', '12'),
('Value_13', '13'),
('Value_14', '14'),
('Value_15', '15'),
('Value_16', '16'),
('Value_17', '17'),
('Value_18', '18'),
('Value_19', '19'),
('Value_20', '20'),
('Value_21', '21'),
('Value_22', '22'),
('Value_23', '23'),
('Value_24', '24'),
('Value_25', '25'),
('Value_26', '26'),
('Value_27', '27'),
('Value_28', '28'),
('Value_29', '29'),
('Value_30', '30'),
('Value_31', '31'),
('Value_32', '32'),
('Value_33', '33'),
('Value_34', '34'),
('Value_35', '35'),
('Value_36', '36'),
('Value_37', '37'),
('Value_38', '38'),
('Value_39', '39'),
('Value_40', '40'),
('Value_41', '41'),
('Value_42', '42'),
('Value_43', '43'),
('Value_44', '44'),
('Value_45', '45'),
('Value_46', '46'),
('Value_47', '47'),
('Value_48', '48'),
('Value_49', '49'),
('Value_50', '50'),
('Value_51', '51'),
('Value_52', '52'),
('Value_53', '53'),
('Value_54', '54'),
('Value_55', '55'),
('Value_56', '56'),
('Value_57', '57'),
('Value_58', '58'),
('Value_59', '59'),
('Value_60', '60'),
('Value_61', '61'),
('Value_62', '62'),
('Value_63', '63'),
('Value_64', '64'),
('Value_65', '65'),
('Value_66', '66'),
('Value_67', '67'),
('Value_68', '68'),
('Value_69', '69'),
('Value_70', '70'),
('Value_71', '71'),
('Value_72', '72'),
('Value_73', '73'),
('Value_74', '74'),
('Value_75', '75'),
('Value_76', '76'),
('Value_77', '77'),
('Value_78', '78'),
('Value_79', '79'),
('Value_80', '80'),
('Value_81', '81'),
('Value_82', '82'),
('Value_83', '83'),
('Value_84', '84'),
('Value_85', '85'),
('Value_86', '86'),
('Value_87', '87'),
('Value_88', '88'),
('Value_89', '89'),
('Value_90', '90'),
('Value_91', '91'),
('Value_92', '92'),
('Value_93', '93'),
('Value_94', '94'),
('Value_95', '95'),
('Value_96', '96'),
('Value_97', '97'),
('Value_98', '98'),
('Value_99', '99'),
('Value_100', '100'),
('Value_101', '101'),
('Value_102', '102'),
('Value_103', '103'),
('Value_104', '104'),
('Value_105', '105'),
('Value_106', '106'),
('Value_107', '107'),
('Value_108', '108'),
('Value_109', '109'),
('Value_110', '110'),
('Value_111', '111'),
('Value_112', '112'),
('Value_113', '113'),
('Value_114', '114'),
('Value_115', '115'),
('Value_116', '116'),
('Value_117', '117'),
('Value_118', '118'),
('Value_119', '119'),
('Value_120', '120'),
('Value_121', '121'),
('Value_122', '122'),
('Value_123', '123'),
('Value_124', '124'),
('Value_125', '125'),
('Value_126', '126'),
('Value_127', '127'),
('Value_128', '128'),
('Value_129', '129'),
('Value_130', '130'),
('Value_131', '131'),
('Value_132', '132'),
('Value_133', '133'),
('Value_134', '134'),
('Value_135', '135'),
('Value_136', '136'),
('Value_137', '137'),
('Value_138', '138'),
('Value_139', '139'),
('Value_140', '140'),
('Value_141', '141'),
('Value_142', '142'),
('Value_143', '143'),
('Value_144', '144'),
('Value_145', '145'),
('Value_146', '146'),
('Value_147', '147'),
('Value_148', '148'),
('Value_149', '149'),
('Value_150', '150'),
('Value_151', '151'),
('Value_152', '152'),
('Value_153', '153'),
('Value_154', '154'),
('Value_155', '155'),
('Value_156', '156'),
('Value_157', '157'),
('Value_158', '158'),
('Value_159', '159'),
('Value_160', '160'),
('Value_161', '161'),
('Value_162', '162'),
('Value_163', '163'),
('Value_164', '164'),
('Value_165', '165'),
('Value_166', '166'),
('Value_167', '167'),
('Value_168', '168'),
('Value_169', '169'),
('Value_170', '170'),
('Value_171', '171'),
('Value_172', '172'),
('Value_173', '173'),
('Value_174', '174'),
('Value_175', '175'),
('Value_176', '176'),
('Value_177', '177'),
('Value_178', '178'),
('Value_179', '179'),
('Value_180', '180'),
('Value_181', '181'),
('Value_182', '182'),
('Value_183', '183'),
('Value_184', '184'),
('Value_185', '185'),
('Value_186', '186'),
('Value_187', '187'),
('Value_188', '188'),
('Value_189', '189'),
('Value_190', '190'),
('Value_191', '191'),
('Value_192', '192'),
('Value_193', '193'),
('Value_194', '194'),
('Value_195', '195'),
('Value_196', '196'),
('Value_197', '197'),
('Value_198', '198'),
('Value_199', '199'),
('Value_200', '200');

You might also like