-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathrs.sqbpro
More file actions
47 lines (23 loc) · 5.17 KB
/
Copy pathrs.sqbpro
File metadata and controls
47 lines (23 loc) · 5.17 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
<?xml version="1.0" encoding="UTF-8"?><sqlb_project><db path="rs.db" readonly="0" foreign_keys="1" case_sensitive_like="0" temp_store="0" wal_autocheckpoint="1000" synchronous="2"/><attached/><window><main_tabs open="structure browser pragmas query" current="1"/></window><tab_structure><column_width id="0" width="300"/><column_width id="1" width="0"/><column_width id="2" width="100"/><column_width id="3" width="2072"/><column_width id="4" width="0"/><expanded_item id="0" parent="1"/><expanded_item id="1" parent="1"/><expanded_item id="2" parent="1"/><expanded_item id="3" parent="1"/></tab_structure><tab_browse><table title="Users" custom_title="0" dock_id="1" table="4,5:mainUsers"/><dock_state state="000000ff00000000fd00000001000000020000039100000258fc0100000001fb000000160064006f0063006b00420072006f00770073006500310100000000000003910000012300ffffff000002690000000000000004000000040000000800000008fc00000000"/><default_encoding codec=""/><browse_table_settings><table schema="main" name="Admins" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_" freeze_columns="0"><sort/><column_widths><column index="1" value="60"/><column index="2" value="65"/><column index="3" value="62"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter/></table><table schema="main" name="Bookings" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_" freeze_columns="0"><sort/><column_widths><column index="1" value="70"/><column index="2" value="101"/><column index="3" value="94"/><column index="4" value="95"/><column index="5" value="71"/><column index="6" value="87"/><column index="7" value="75"/><column index="8" value="131"/><column index="9" value="70"/><column index="10" value="63"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter/></table><table schema="main" name="Users" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_" freeze_columns="0"><sort/><column_widths><column index="1" value="50"/><column index="2" value="103"/><column index="3" value="95"/><column index="4" value="127"/><column index="5" value="87"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter/></table><table schema="main" name="Vehicles" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_" freeze_columns="0"><sort/><column_widths><column index="1" value="65"/><column index="2" value="215"/><column index="3" value="86"/><column index="4" value="79"/><column index="5" value="81"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter/></table><table schema="main" name="sqlite_sequence" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_" freeze_columns="0"><sort/><column_widths><column index="1" value="71"/><column index="2" value="35"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter/></table></browse_table_settings></tab_browse><tab_sql><sql name="SQL 1*">INSERT INTO users (name, phone, cnic, address) VALUES
('Ali Raza', '03001234567', '35202-1234567-1', 'Lahore'),
('Sara Khan', '03019876543', '35201-9876543-2', 'Islamabad'),
('Ahmed Noor', '03111223344', '36302-1111222-3', 'Karachi'),
('Zara Sheikh', '03214567890', '37406-3333444-4', 'Rawalpindi'),
('Usman Tariq', '03451234567', '35202-5555666-5', 'Multan'),
('Hina Aslam', '03331234567', '35203-6666777-6', 'Faisalabad'),
('Bilal Ahmed', '03009988776', '35201-8888999-7', 'Quetta'),
('Nimra Ali', '03134567890', '35204-7777888-8', 'Sialkot'),
('Fahad Javed', '03217654321', '35206-9999000-9', 'Gujranwala'),
('Mariam Shafi', '03338885544', '35207-2222333-0', 'Peshawar');
INSERT INTO bookings (customer_name, phone_number, cnic, address, booking_date, rental_item, rental_duration_days, total_price, status) VALUES
('Ali Raza', '03001234567', '35202-1234567-1', 'Lahore', '2025-07-01', 'Toyota Corolla', 3, 9000, 'Pending'),
('Sara Khan', '03019876543', '35201-9876543-2', 'Islamabad', '2025-07-01', 'Honda Civic', 2, 7500, 'Confirmed'),
('Ahmed Noor', '03111223344', '36302-1111222-3', 'Karachi', '2025-07-02', 'Suzuki Alto', 4, 8000, 'Pending'),
('Zara Sheikh', '03214567890', '37406-3333444-4', 'Rawalpindi', '2025-07-02', 'KIA Sportage', 1, 6500, 'Confirmed'),
('Usman Tariq', '03451234567', '35202-5555666-5', 'Multan', '2025-07-03', 'Toyota Hilux', 5, 15000, 'Pending'),
('Hina Aslam', '03331234567', '35203-6666777-6', 'Faisalabad', '2025-07-03', 'Honda BRV', 3, 10500, 'Pending'),
('Bilal Ahmed', '03009988776', '35201-8888999-7', 'Quetta', '2025-07-03', 'Suzuki Cultus', 2, 5000, 'Confirmed'),
('Nimra Ali', '03134567890', '35204-7777888-8', 'Sialkot', '2025-07-04', 'KIA Picanto', 3, 6000, 'Confirmed'),
('Fahad Javed', '03217654321', '35206-9999000-9', 'Gujranwala', '2025-07-04', 'Honda City', 1, 3000, 'Pending'),
('Mariam Shafi', '03338885544', '35207-2222333-0', 'Peshawar', '2025-07-04', 'Hyundai Tucson', 4, 14000, 'Confirmed');
</sql><current_tab id="0"/></tab_sql></sqlb_project>