php-framework-benchmark/database.sql at main · webrium/php-framework-benchmark · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
-- ============================================
-- Benchmark Database Setup
-- ============================================

-- Create database
CREATEDATABASEIF NOT EXISTS `benchmark`
 CHARACTER SET utf8mb4
 COLLATE utf8mb4_unicode_ci;

USE `benchmark`;

-- Create users table
CREATETABLEIF NOT EXISTS `users` (
`id`INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name`VARCHAR(100) NOT NULL,
`email`VARCHAR(150) NOT NULL UNIQUE,
`password`VARCHAR(255) NOT NULL,
`created_at`TIMESTAMPNOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at`TIMESTAMPNOT NULL DEFAULT CURRENT_TIMESTAMPONUPDATECURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
 INDEX `idx_email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Insert test data (100 rows)
INSERT INTO`users` (`name`, `email`, `password`) VALUES
('Ali Ahmadi', 'ali.ahmadi@example.com', '$2y$10$examplehashedpassword001'),
('Sara Mohammadi', 'sara.mohammadi@example.com', '$2y$10$examplehashedpassword002'),
('Reza Karimi', 'reza.karimi@example.com', '$2y$10$examplehashedpassword003'),
('Maryam Hosseini', 'maryam.hosseini@example.com', '$2y$10$examplehashedpassword004'),
('Hassan Rezaei', 'hassan.rezaei@example.com', '$2y$10$examplehashedpassword005'),
('Zahra Sadeghi', 'zahra.sadeghi@example.com', '$2y$10$examplehashedpassword006'),
('Mohammad Rahimi', 'mohammad.rahimi@example.com', '$2y$10$examplehashedpassword007'),
('Fateme Abbasi', 'fateme.abbasi@example.com', '$2y$10$examplehashedpassword008'),
('Amir Nazari', 'amir.nazari@example.com', '$2y$10$examplehashedpassword009'),
('Niloofar Moradi', 'niloofar.moradi@example.com', '$2y$10$examplehashedpassword010'),
('Hossein Jafari', 'hossein.jafari@example.com', '$2y$10$examplehashedpassword011'),
('Elham Shirazi', 'elham.shirazi@example.com', '$2y$10$examplehashedpassword012'),
('Mehdi Ghorbani', 'mehdi.ghorbani@example.com', '$2y$10$examplehashedpassword013'),
('Shirin Mansouri', 'shirin.mansouri@example.com', '$2y$10$examplehashedpassword014'),
('Nima Taheri', 'nima.taheri@example.com', '$2y$10$examplehashedpassword015'),
('Parisa Akbari', 'parisa.akbari@example.com', '$2y$10$examplehashedpassword016'),
('Kamran Mostafavi', 'kamran.mostafavi@example.com', '$2y$10$examplehashedpassword017'),
('Leila Bagheri', 'leila.bagheri@example.com', '$2y$10$examplehashedpassword018'),
('Omid Soltani', 'omid.soltani@example.com', '$2y$10$examplehashedpassword019'),
('Nasrin Ebrahimi', 'nasrin.ebrahimi@example.com', '$2y$10$examplehashedpassword020'),
('Dariush Rashidi', 'dariush.rashidi@example.com', '$2y$10$examplehashedpassword021'),
('Mina Kazemi', 'mina.kazemi@example.com', '$2y$10$examplehashedpassword022'),
('Saeed Mousavi', 'saeed.mousavi@example.com', '$2y$10$examplehashedpassword023'),
('Roya Farahani', 'roya.farahani@example.com', '$2y$10$examplehashedpassword024'),
('Babak Maleki', 'babak.maleki@example.com', '$2y$10$examplehashedpassword025'),
('Azita Kiani', 'azita.kiani@example.com', '$2y$10$examplehashedpassword026'),
('Shahram Amiri', 'shahram.amiri@example.com', '$2y$10$examplehashedpassword027'),
('Golnaz Safavi', 'golnaz.safavi@example.com', '$2y$10$examplehashedpassword028'),
('Farshad Zamani', 'farshad.zamani@example.com', '$2y$10$examplehashedpassword029'),
('Mahsa Ghasemlou', 'mahsa.ghasemlou@example.com', '$2y$10$examplehashedpassword030'),
('Siavash Ranjbar', 'siavash.ranjbar@example.com', '$2y$10$examplehashedpassword031'),
('Neda Gholami', 'neda.gholami@example.com', '$2y$10$examplehashedpassword032'),
('Arash Farhadi', 'arash.farhadi@example.com', '$2y$10$examplehashedpassword033'),
('Tahereh Vosoughi', 'tahereh.vosoughi@example.com', '$2y$10$examplehashedpassword034'),
('Bijan Lotfi', 'bijan.lotfi@example.com', '$2y$10$examplehashedpassword035'),
('Sanaz Nikpour', 'sanaz.nikpour@example.com', '$2y$10$examplehashedpassword036'),
('Kourosh Haghighi', 'kourosh.haghighi@example.com', '$2y$10$examplehashedpassword037'),
('Mandana Yousefi', 'mandana.yousefi@example.com', '$2y$10$examplehashedpassword038'),
('Farhad Darvishi', 'farhad.darvishi@example.com', '$2y$10$examplehashedpassword039'),
('Pegah Salari', 'pegah.salari@example.com', '$2y$10$examplehashedpassword040'),
('Vahid Mohebbi', 'vahid.mohebbi@example.com', '$2y$10$examplehashedpassword041'),
('Roxana Jalali', 'roxana.jalali@example.com', '$2y$10$examplehashedpassword042'),
('Morteza Islami', 'morteza.islami@example.com', '$2y$10$examplehashedpassword043'),
('Shiva Kouhzad', 'shiva.kouhzad@example.com', '$2y$10$examplehashedpassword044'),
('Navid Shafiee', 'navid.shafiee@example.com', '$2y$10$examplehashedpassword045'),
('Paria Nouri', 'paria.nouri@example.com', '$2y$10$examplehashedpassword046'),
('Ehsan Poorahmad', 'ehsan.poorahmad@example.com', '$2y$10$examplehashedpassword047'),
('Nasim Derakhshan', 'nasim.derakhshan@example.com', '$2y$10$examplehashedpassword048'),
('Alireza Naderi', 'alireza.naderi@example.com', '$2y$10$examplehashedpassword049'),
('Yasamin Khodaei', 'yasamin.khodaei@example.com', '$2y$10$examplehashedpassword050'),
('Majid Tehrani', 'majid.tehrani@example.com', '$2y$10$examplehashedpassword051'),
('Fereshteh Amini', 'fereshteh.amini@example.com', '$2y$10$examplehashedpassword052'),
('Pouya Sadeghzade', 'pouya.sadeghzade@example.com', '$2y$10$examplehashedpassword053'),
('Setareh Bayat', 'setareh.bayat@example.com', '$2y$10$examplehashedpassword054'),
('Danial Mirzaei', 'danial.mirzaei@example.com', '$2y$10$examplehashedpassword055'),
('Mahnoush Tavakoli','mahnoush.tavakoli@example.com','$2y$10$examplehashedpassword056'),
('Keyvan Zare', 'keyvan.zare@example.com', '$2y$10$examplehashedpassword057'),
('Samira Torabi', 'samira.torabi@example.com', '$2y$10$examplehashedpassword058'),
('Iman Hatami', 'iman.hatami@example.com', '$2y$10$examplehashedpassword059'),
('Donya Ahmadpour', 'donya.ahmadpour@example.com', '$2y$10$examplehashedpassword060'),
('Shahab Nosrati', 'shahab.nosrati@example.com', '$2y$10$examplehashedpassword061'),
('Mersedeh Kabiri', 'mersedeh.kabiri@example.com', '$2y$10$examplehashedpassword062'),
('Foad Kargar', 'foad.kargar@example.com', '$2y$10$examplehashedpassword063'),
('Tina Mansouri', 'tina.mansouri2@example.com', '$2y$10$examplehashedpassword064'),
('Sahand Pourali', 'sahand.pourali@example.com', '$2y$10$examplehashedpassword065'),
('Mona Zebardast', 'mona.zebardast@example.com', '$2y$10$examplehashedpassword066'),
('Kasra Hedayat', 'kasra.hedayat@example.com', '$2y$10$examplehashedpassword067'),
('Ghazal Salehpour', 'ghazal.salehpour@example.com', '$2y$10$examplehashedpassword068'),
('Saman Moshiri', 'saman.moshiri@example.com', '$2y$10$examplehashedpassword069'),
('Azadeh Shamsi', 'azadeh.shamsi@example.com', '$2y$10$examplehashedpassword070'),
('Bahram Foroughi', 'bahram.foroughi@example.com', '$2y$10$examplehashedpassword071'),
('Nilufar Rasti', 'nilufar.rasti@example.com', '$2y$10$examplehashedpassword072'),
('Cyrus Mahdavi', 'cyrus.mahdavi@example.com', '$2y$10$examplehashedpassword073'),
('Homa Shakouri', 'homa.shakouri@example.com', '$2y$10$examplehashedpassword074'),
('Pedram Asadi', 'pedram.asadi@example.com', '$2y$10$examplehashedpassword075'),
('Zeinab Esfahani', 'zeinab.esfahani@example.com', '$2y$10$examplehashedpassword076'),
('Farhang Nikbakht', 'farhang.nikbakht@example.com', '$2y$10$examplehashedpassword077'),
('Shabnam Qasemi', 'shabnam.qasemi@example.com', '$2y$10$examplehashedpassword078'),
('Amin Asghari', 'amin.asghari@example.com', '$2y$10$examplehashedpassword079'),
('Vida Hassanzade', 'vida.hassanzade@example.com', '$2y$10$examplehashedpassword080'),
('Ramin Salehi', 'ramin.salehi@example.com', '$2y$10$examplehashedpassword081'),
('Faranak Sotoudeh', 'faranak.sotoudeh@example.com', '$2y$10$examplehashedpassword082'),
('Arman Hadizade', 'arman.hadizade@example.com', '$2y$10$examplehashedpassword083'),
('Parvin Yazdani', 'parvin.yazdani@example.com', '$2y$10$examplehashedpassword084'),
('Milad Rohani', 'milad.rohani@example.com', '$2y$10$examplehashedpassword085'),
('Laleh Akhavan', 'laleh.akhavan@example.com', '$2y$10$examplehashedpassword086'),
('Javad Monfared', 'javad.monfared@example.com', '$2y$10$examplehashedpassword087'),
('Soodeh Bahrami', 'soodeh.bahrami@example.com', '$2y$10$examplehashedpassword088'),
('Atefeh Khosravi', 'atefeh.khosravi@example.com', '$2y$10$examplehashedpassword089'),
('Erfan Rezazade', 'erfan.rezazade@example.com', '$2y$10$examplehashedpassword090'),
('Marzieh Ahmadi', 'marzieh.ahmadi2@example.com', '$2y$10$examplehashedpassword091'),
('Soroush Nassiri', 'soroush.nassiri@example.com', '$2y$10$examplehashedpassword092'),
('Yalda Davari', 'yalda.davari@example.com', '$2y$10$examplehashedpassword093'),
('Hirad Nazemi', 'hirad.nazemi@example.com', '$2y$10$examplehashedpassword094'),
('Elnaz Motlagh', 'elnaz.motlagh@example.com', '$2y$10$examplehashedpassword095'),
('Farzan Mohseni', 'farzan.mohseni@example.com', '$2y$10$examplehashedpassword096'),
('Rozita Pakzad', 'rozita.pakzad@example.com', '$2y$10$examplehashedpassword097'),
('Pejman Ghasemi', 'pejman.ghasemi@example.com', '$2y$10$examplehashedpassword098'),
('Nazanin Morady', 'nazanin.morady@example.com', '$2y$10$examplehashedpassword099'),
('Shahin Tavana', 'shahin.tavana@example.com', '$2y$10$examplehashedpassword100');

-- Verify
SELECTCOUNT(*) AS total_users FROM`users`;