File manager

File manager - Edit - /home2/zetasolve/the.shayantraders.com/backend/inventory.db

Back
SQLite format 3��@ ��.r�� 7� '��#��bb��=Q+�indexsqlite_autoindex_monthly_summary_1monthly_summary�m�9tableusersusers CREATE TABLE users ( id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT NOT NULL UNIQUE, password TEXT NOT NULL, role TEXT NOT NULL DEFAULT 'Manager', -- 'Admin' or 'Manager' permissions TEXT, -- JSON string of allowed pages/modules created_at DATETIME DEFAULT CURRENT_TIMESTAMP , status TEXT DEFAULT 'Active')��tableskusskusCREATE TABLE skus ( id INTEGER PRIMARY KEY AUTOINCREMENT, sku_code TEXT NOT NULL UNIQUE, product_id INTEGER NOT NULL, flavour TEXT NOT NULL, weight TEXT NOT NULL, current_stock INTEGER DEFAULT 0, price REAL NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, tag TEXT DEFAULT '', FOREIGN KEY (product_id) REFERENCES products(id) )) =�indexsqlite_autoindex_users_1users��wtablecustomerscustomersCREATE TABLE customers ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL UNIQUE, phone TEXT, email TEXT, address TEXT, total_outstanding REAL DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP )1E�indexsqlite_autoindex_customers_1customers��a++�ytablecredit_paymentscredit_paymentsCREATE TABLE credit_payments ( id INTEGER PRIMARY KEY AUTOINCREMENT, transaction_id INTEGER NOT NULL, payment_date DATE NOT NULL, amount_paid REAL NOT NULL, notes TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (transaction_id) REFERENCES transactions(id) )�X �tableexpensesexpensesCREATE TABLE expenses ( id INTEGER PRIMARY KEY AUTOINCREMENT, expense_date DATE NOT NULL, description TEXT NOT NULL, category TEXT NOT NULL CHECK(category IN ('Rent', 'Advance', 'Transport', 'Utilities', 'Other')), amount REAL NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP )�B %%�Gtablereturn_itemsreturn_items CREATE TABLE return_items ( id INTEGER PRIMARY KEY AUTOINCREMENT, return_id INTEGER NOT NULL, sku_id INTEGER NOT NULL, quantity INTEGER NOT NULL, FOREIGN KEY (return_id) REFERENCES returns(id) ON DELETE CASCADE, FOREIGN KEY (sku_id) REFERENCES skus(id) )�n�3tablereturnsreturns CREATE TABLE returns ( id INTEGER PRIMARY KEY AUTOINCREMENT, return_date DATE NOT NULL, original_transaction_id INTEGER, customer_name TEXT, reason TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, return_type TEXT DEFAULT 'Normal', FOREIGN KEY (original_transaction_id) REFERENCES transactions(id) )�//�gtabletransaction_itemstransaction_itemsCREATE TABLE transaction_items ( id INTEGER PRIMARY KEY AUTOINCREMENT, transaction_id INTEGER NOT NULL, sku_id INTEGER NOT NULL, quantity INTEGER NOT NULL, unit_price REAL NOT NULL, subtotal REAL NOT NULL, FOREIGN KEY (transaction_id) REFERENCES transactions(id) ON DELETE CASCADE, FOREIGN KEY (sku_id) REFERENCES skus(id) )�K%%�YtabletransactionstransactionsCREATE TABLE transactions ( id INTEGER PRIMARY KEY AUTOINCREMENT, transaction_date DATE NOT NULL, payment_type TEXT NOT NULL CHECK(payment_type IN ('Cash', 'Credit')), customer_name TEXT, total_amount REAL NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP )';�indexsqlite_autoindex_skus_1skusP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)/C�indexsqlite_autoindex_products_1products�L�ktableproductsproductsCREATE TABLE products ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL UNIQUE, description TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTA�� Y9��@� 3Masala2026-02-15 11:00:06C� 3masala2026-01-10 12:22:09/�13JuiceFresh fruit juices2025-12-21 13:03:31;�M3JamFruit jams in multiple varieties2025-12-21 13:03:317�A3AcharPickles in various flavors2025-12-21 13:03:31 ��Masala@ masalaC JuiceJam Achar � �^��:I��1standalone_credits+monthly_summarym� stan expensesCcustomer_credit_adjustments customers +credit_payments products�� monthly_summary usersreturns�� usersn%return_items skus>�� tra/transaction_items%transactions�� customers t� ��m< �@bA � � t > �� 3��t� � ��0�t � 3 DEL_DEBUGTest100g d2026-01-10 11:37:20:�s 6�s4 �3 JM-PI-05Pineapple5kgl2025-12-21 13:03:311 � 3 AC-MX-500Mixed500g��2025-12-21 13:03:3112 � 3 AC-GA-10Garlic10kg �2025-12-21 13:03:31- �3JZ-MX-1LMixed1L}2025-12-21 13:03:31. �3JZ-GR-1LGrape1L��2025-12-21 13:03:31. �3JZ-OR-1LOrange1Ln2025-12-21 13:03:31. �3JZ-AP-1LApple1L��2025-12-21 13:03:31- �3JZ-MA-1LMango1Lx2025-12-21 13:03:311 � 3 AC-GA-20Garlic20kgP2025-12-21 13:03:31315 �3JM-PI-500Pineapple500g��2025-12-21 13:03:315 �#3JM-MF-05Mixed Fruit5kg:2025-12-21 13:03:317 �#3JM-MF-500Mixed Fruit500g��2025-12-21 13:03:314 �!3JM-ST-05Strawberry5kg�2025-12-21 13:03:316 �!3JM-ST-500Strawberry500g��2025-12-21 13:03:31/ �3JM-AP-05Apple5kg2025-12-21 13:03:311 �3JM-AP-500Apple500g��2025-12-21 13:03:31/ �3JM-MA-05Mango5kg@2025-12-21 13:03:311 �3JM-MA-500Mango500g��2025-12-21 13:03:31��' 3AC-GA-20Garlic20kgP2025-12-:� �3AC-MX-099@biryani550g ��2026-02-15 11:00:06Shan/ � 3AC-GA-05Garlic5kgx2025-12-21 13:03:311 � 3AC-GA-500Garlic500g��2025-12-21 13:03:31/ � 3AC-MX-20Mixed20kg02025-12-21 13:03:31/ � 3AC-MX-10Mixed10kg�2025-12-21 13:03:31. � 3AC-MX-05Mixed5kg�2025-12-21 13:03:31��2 3AC-MX-500Mixed500g��2025-12-21 13:03:31 ��an\|�+8FS��DEL_DEBUGt DEL_TESTs AC-MX-099 �JZ-MX-1LJZ-GR-1LJZ-OR-1LJZ-AP-1LJZ-MA-1LJM-PI-05 JM-PI-500JM-MF-05 JM-MF-500JM-ST-05 JM-ST-500 JM-AP-05 JM-AP-500JM-MA-05 JM-MA-500 AC-GA-20AC-GA-10AC-GA-05 AC-GA-500AC-MX-20AC-MX-10AC-MX-05 AC-MX-500 � �� b$ � �� V��2 �!32026-01-28Creditumer2026-01-28 20:00:195 �!32026-01-28Creditumer �2026-01-28 14:23:36 ? �!-32026-01-28CashWalk-in Customer �2026-01-28 13:37:51K�"!-32026-01-28CashWalk-in C< �!32026-05-07CashSaad��2026-05-07 16:19:38@#333333��3 �!32026-02-15CashSaad��2026-02-15 11:35:52��5 �!32026-02-15CashUmer��2026-02-15 11:01:542��: �!32026-02-02Cashhasnain �2026-02-02 13:40:22 �? �!-32026-01-28CashWalk-in Customer �2026-01-28 11:04:43 ��!'32026-01-28CreditTest Customer,2026-01-28 10:53:59��x!-32025-12-30CashWalk-in Customer2025-12-30 09:01:07��<!-2 �!32026-01-28CreditUmer �2026-01-28 13:57:39 ��x��x��xx�iY�� ,�� _��J�_��@�!�-32026-05-07SaadPackage not seal2026-05-07 16:20:12Damagedm �!��32026-02-15azhanBabar ki centory 99 run say reh gai isliya packet phadd gya2026-02-15 11:38:27Damaged8�!�32026-02-15Hunaidnothing2026-02-15 11:37:18Normal;�!�%32026-02-15Saadnothing need2026-02-15 11:36:54Normal?�!��332026-02-15not sealed properly2026-02-15 11:02:42Damaged6 �!�32026-02-15Umerno need2026-02-15 11:02:18Normal �� D�!?32026-02-02Test Expense for DeletionOther�2026-02-02 138�!#32026-02-15Driver rentAdvance�2026-02-15 11:03:43 ��V��8�!+32026-01-28�Initial Payment2026-01-28 14:23:368�!+32026-01-28 �Initial Payment2026-01-28 13:57:397�!+3�2026-01-28�Initial Payment2026-01-28 11:08:487�!+3�2026-01-28,Initial Payment2026-01-28 11:07:516�!+3 2026-01-28dInitial Payment2026-01-28 10:53:59 ��a��4 ��#�3saad$2b$10$0C/ciyLwdAx56OqE390FE.xnt3GJqkzkCPx4psPQS1xw9iPSuDRXSDistributor["inventory.html","billing.html","returns.html","damage_items.html"]2026-05-07 16:21:44Disabledm ��3admin$2b$10$vPvTjr0ugQzDFOqcpvX4cOEefZKELDF8yRdG6hnBN5E3pZaG2pxfmAdmin[""]2026-01-27 13:40:28Active��y+�3saadbhaimerijan$2b$10$f59LhpB1YV1.uiNXfqkoFelql0ykZwnCmAuvX/GdVVHcAtdBaU.NSAdmin[""]2026-01-10 12:24:25Active �� umer admin saad admin ��x��x��!��3umer2026-01-28 14:23:36��3Umer2026-01-28 13:57:39B�'!-�3Test Customer1234567890test@example.com2026-01-28 10:51:3535 ��umerUmer' Test Customer ��p��p��"� 32026-05��2026-05-02 05:55:46 �32026-042026-04-29 20:57:15#�32026-02@2026-02-02 12:35:48#�32026-01` 2026-01-24 18:34:49 ��2026-052026-042026-02 2026-01 �� 1��4� '��0bb��/++�tablemonthly_summarymonthly_summaryCREATE TABLE monthly_summary ( id INTEGER PRIMARY KEY AUTOINCREMENT, month_year TEXT NOT NULL UNIQUE, -- Format: YYYY-MM total_sales REAL DEFAULT 0, total_transactions INTEGER DEFAULT 0, reset_date DATETIME DEFAULT CURRENT_TIMESTAMP )��Q+�indexsqlite_autoindex_monthly_summary_1monthly_summary�m�9tableusersusers CREATE TABLE users ( id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT NOT NULL UNIQUE, password TEXT NOT NULL, role TEXT NOT NULL DEFAULT 'Manager', -- 'Admin' or 'Manager' permissions TEXT, -- JSON string of allowed pages/modules created_at DATETIME DEFAULT CURRENT_TIMESTAMP , status TEXT DEFAULT 'Active')��tableskusskusCREATE TABLE skus ( id INTEGER PRIMARY KEY AUTOINCREMENT, sku_code TEXT NOT NULL UNIQUE, product_id INTEGER NOT NULL, flavour TEXT NOT NULL, weight TEXT NOT NULL, current_stock INTEGER DEFAULT 0, price REAL NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, tag TEXT DEFAULT '', FOREIGN KEY (product_id) REFERENCES products(id) ) 7�=�indexsqlite_autoindex_users_1users��wtablecustomerscustomersCREATE TABLE customers ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL UNIQUE, phone TEXT, email TEXT, address TEXT, total_outstanding REAL DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP )1E�indexsqlite_autoindex_customers_1customers��a++�ytablecredit_paymentscredit_paymentsCREATE TABLE credit_payments ( id INTEGER PRIMARY KEY AUTOINCREMENT, transaction_id INTEGER NOT NULL, payment_date DATE NOT NULL, amount_paid REAL NOT NULL, notes TEXT, created_at DATETIME DEFAULT �+%%�tabletransactionstransactionsCREATE TABLE transactions ( id INTEGER PRIMARY KEY AUTOINCREMENT, transaction_date DATE NOT NULL, payment_type TEXT NOT NULL CHECK(payment_type IN ('Cash', 'Credit')), customer_name TEXT, total_amount REAL NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP , discount_percentage REAL DEFAULT 0, discount_amount REAL DEFAULT 0, amount_paid REAL DEFAULT 0)�B %%�Gtablereturn_itemsreturn_items CREATE TABLE return_items ( id INTEGER PRIMARY KEY AUTOINCREMENT, return_id INTEGER NOT NULL, sku_id INTEGER NOT NULL, quantity INTEGER NOT NULL, FOREIGN KEY (return_id) REFERENCES returns(id) ON DELETE CASCADE, FOREIGN KEY (sku_id) REFERENCES skus(id) )�n�3tablereturnsreturns CREATE TABLE returns ( id INTEGER PRIMARY KEY AUTOINCREMENT, return_date DATE NOT NULL, original_transaction_id INTEGER, customer_name TEXT, reason TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, return_type TEXT DEFAULT 'Normal', FOREIGN KEY (original_transaction_id) REFERENCES transactions(id) )�//�gtabletransaction_itemstransaction_itemsCREATE TABLE transaction_items ( id INTEGER PRIMARY KEY AUTOINCREMENT, transaction_id INTEGER NOT NULL, sku_id INTEGER NOT NULL, quantity INTEGER NOT NULL, unit_price REAL NOT NULL, subtotal REAL NOT NULL, FOREIGN KEY (transaction_id) REFERENCES transactions(id) ON DELETE CASCADE, FOREIGN KEY (sku_id) REFERENCES skus(id) )��N%%�YtabletransactionstransactionsCREATE TABLE transactions ( id INTEGER PRIMARY KEY AUTOINCREMENT, transaction_date DATE NOT NULL, payment_type TEXT NOT NULL CHECK(payment_type IN ('Cash', 'Credit')), customer_name TEXT, total_amount REAL NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP )';�indexsqlite_autoindex_skus_1skusP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)/C�indexsqlite_autoindex_products_1products�L�ktableproductsproductsCREATE TABLE products ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL UNIQUE, description TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP ) �� x a .��3\��w11�tablestandalone_creditsstandalone_creditsCREATE TABLE standalone_credits ( id INTEGER PRIMARY KEY AUTOINCREMENT, customer_id INTEGER NOT NULL, customer_name TEXT NOT NULL, total_amount REAL NOT NULL, paid_amount REAL NOT NULL DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP )�TCC�/tablecustomer_credit_adjustmentscustomer_credit_adjustmentsCREATE TABLE customer_credit_adjustments ( id INTEGER PRIMARY KEY AUTOINCREMENT, customer_id INTEGER NOT NULL, adjustment_date DATE NOT NULL, amount_cleared REAL NOT NULL, notes TEXT, adjustment_type TEXT NOT NULL CHECK(adjustment_type IN ('CLEAR', 'ADJUST')), created_at DATETIME DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (customer_id) REFERENCES customers(id) )�33�5tablecredit_payments_newcredit_payments_newCREATE TABLE credit_payments_new (id INTEGER PRIMARY KEY AUTOINCREMENT, transaction_id INTEGER, customer_id INTEGER, payment_date DATE NOT NULL, amount_paid REAL NOT NULL, notes TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (transaction_id) REFERENCES transactions(id), FOREIGN KEY (customer_id) REFERENCES customers(id))=Q+�indexsqlite_autoindex_monthly_summary_1monthly_summary�/++�tablemonthly_summarymonthly_summaryCREATE TABLE monthly_summary ( id INTEGER PRIMARY KEY AUTOINCREMENT, month_year TEXT NOT NULL UNIQUE, -- Format: YYYY-MM total_sales REAL DEFAULT 0, total_transactions INTEGER DEFAULT 0, reset_date DATETIME DEFAULT CURRENT_TIMESTAMP )1E�indexsqlite_autoindex_customers_1customers��wtablecustomerscustomersCREATE TABLE customers ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL UNIQUE, phone TEXT, email TEXT, address TEXT, total_outstanding REAL DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP )) =�indexsqlite_autoindex_users_1users�m�9tableusersusers CREATE TABLE users ( id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT NOT NULL UNIQUE, password TEXT NOT NULL, role TEXT NOT NULL DEFAULT 'Manager', -- 'Admin' or 'Manager' permissions TEXT, -- JSON string of allowed pages/modules created_at DATETIME DEFAULT CURRENT_TIMESTAMP , status TEXT DEFAULT 'Active')�++�Utablecredit_paymentscredit_paymentsCREATE TABLE credit_payments ( id INTEGER PRIMARY KEY AUTOINCREMENT, transaction_id INTEGER NOT NULL, payment_date DATE NOT NULL, amount_paid REAL NOT NULL, notes TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, customer_id INTEGER REFERENCES customers(id), FOREIGN KEY (transaction_id) REFERENCES transactions(id) )�X �tableexpensesexpensesCREATE TABLE expenses ( id INTEGER PRIMARY KEY AUTOINCREMENT, expense_date DATE NOT NULL, description TEXT NOT NULL, category TEXT NOT NULL CHECK(category IN ('Rent', 'Advance', 'Transport', 'Utilities', 'Other')), amount REAL NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP ) �� x3��G�!A32026-01-28Credit deletion/correctionCLEAR2026-01-28 20:00:40C�!932026-01-28�Full credit settlementCLEAR2026-01-28 14:23:49G�!A32026-01-28��Credit deletion/correctionCLEAR2026-01-28 14:23:08=� !/32026-01-28��Test clear creditCLEAR2026-01-28 14:20:02 ��@�+33saadbhaimerijan�2026-02-15 11:39:392026-02-15 11:39:37�33Saad��2026-05-07 16:20:362026-05-07 16:20:44?� +33saadbhaimerijan�2026-02-15 11:39:392026-02-15 11:39:39

| ver. 1.4 | Github | . | PHP 8.1.34 | Generation time: 0.18 | proxy | phpinfo | Settings