-- MySqlBackup.NET 2.3.9.0
-- Dump Time: 2025-06-26 11:57:56
-- --------------------------------------




-- 
-- Definition of accgroupmain
-- 

CREATE TABLE IF NOT EXISTS `accgroupmain` (
  `id` int NOT NULL AUTO_INCREMENT,
  `group` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mainhead` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `debitorcredit` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table accgroupmain
-- 

INSERT INTO `accgroupmain`(`id`,`group`,`mainhead`,`debitorcredit`) VALUES
(1,'Accounts Receivable (A/R)','ASSETS','DEBIT'),
(2,'Current Assets','ASSETS','DEBIT'),
(3,'Cash and cash equivalents','ASSETS','DEBIT'),
(4,'Fixed Assets','ASSETS','DEBIT'),
(5,'Non-current Assets','ASSETS','DEBIT'),
(6,'Accounts Payable (A/P)','LIABILITIES','CREDIT'),
(7,'Credit Card','LIABILITIES','CREDIT'),
(8,'Current liabilities','LIABILITIES','CREDIT'),
(9,'Non-current liabilities','LIABILITIES','CREDIT'),
(10,'Owner''s equity','CAPITAL ACCOUNT','CREDIT'),
(11,'Direct Income','INCOME','CREDIT'),
(12,'Other income','INCOME','CREDIT'),
(13,'Cost of Sales','INCOME','CREDIT'),
(14,'Indirect Expenses','EXPENSES','DEBIT'),
(15,'Other Expense','EXPENSES','DEBIT'),
(16,'Direct Expense','EXPENSES','DEBIT'),
(17,'Purchase','EXPENSES','DEBIT');

-- 
-- Definition of accgroups
-- 

CREATE TABLE IF NOT EXISTS `accgroups` (
  `id` int NOT NULL,
  `Group` varchar(55) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `subGroup` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Description` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `gid` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table accgroups
-- 

INSERT INTO `accgroups`(`id`,`Group`,`subGroup`,`Description`,`gid`) VALUES
(1,'Accounts Receivable (A/R)','Accounts Receivable (A/R)','Accounts receivable (also called A/R, Debtors, or Trade and other receivables) tracks money that customers owe you for products or services, and payments customers make. SincA automatically creates one Accounts receivable account for you. Most businesses need only one. Each customer has a register, which functions like an Accounts receivable account for each customer.',1),
(2,'Current Assets','Accounts Receivable','Use Accounts Receivable (A/R) to track monies to the company by their customers. This is also known as Debtors or Trade and other receivables.',2),
(3,'Current Assets','Allowance for bad debts','Use Allowance for bad debts to estimate the part of Accounts Receivable that you think you might not collect.\nUse this only if you are keeping your books on the accrual basis.',2),
(4,'Current Assets','Assets available for sale','Use Assets available for sale to track assets that are available for sale that are not expected to be held for a long period of time.',2),
(5,'Current Assets','Development Costs','Use Development costs to track amounts you deposit or set aside to arrange for financing, such as an SBA loan, or for deposits in anticipation of the purchase of property or other assets.\nWhen the deposit is refunded, or the purchase takes place, remove the amount from this account.',2),
(6,'Current Assets','Employee Cash Advances','Use Employee cash advances to track employee wages and salary you issue to an employee early, or other non-salary money given to employees.\nIf you make a loan to an employee, use the Current asset account type called Loans to others, instead.',2),
(7,'Current Assets','Inventory','Use Inventory to track the cost of goods your business purchases for resale.\nWhen the goods are sold, assign the sale to a Cost of sales account.',2),
(8,'Current Assets','Investments - Other','Use Investments - Other to track the value of investments not covered by other investment account types. Examples include publicly-traded shares, coins, or gold.',2),
(9,'Current Assets','Loans To Officers','If you operate your business as a Corporation, use Loans to officers to track money loaned to officers of your business.',2),
(10,'Current Assets','Loans to Others','Use Loans to others to track money your business loans to other people or businesses.\nThis type of account is also referred to as Notes Receivable. For early salary payments to employees, use Employee cash advances, instead.',2),
(11,'Current Assets','Loans to Shareholders','If you operate your business as a Corporation, use Loans to Shareholders to track money your business loans to its shareholders.',2),
(12,'Current Assets','Other current assets','Use Other current assets for current assets not covered by the other types. Current assets are likely to be converted to cash or used up in a year.',2),
(13,'Current Assets','Prepaid Expenses','Use Prepaid expenses to track payments for expenses that you won’t recognise until your next accounting period.\nWhen you recognise the expense, make a journal entry to transfer money from this account to the expense account.',2),
(14,'Current Assets','Retainage','Use Retainage if your customers regularly hold back a portion of a contract amount until you have completed a project.\nThis type of account is often used in the construction industry, and only if you record income on an accrual basis.',2),
(15,'Current Assets','Undeposited Funds','Use Undeposited funds for cash or cheques from sales that haven’t been deposited yet.\nFor petty cash, use Cash on hand, instead.',2),
(16,'Cash and cash equivalents','Cash and cash equivalents','Use Cash and Cash Equivalents to track cash or assets that can be converted into cash immediately. For example, marketable securities and Treasury bills.',3),
(17,'Cash and cash equivalents','Cash on hand','Use a Cash on hand account to track cash your company keeps for occasional expenses, also called petty cash.\nTo track cash from sales that have not been deposited yet, use a pre-created account called Undeposited funds, instead.',3),
(18,'Cash and cash equivalents','Client trust account','Use Client trust accounts for money held by you for the benefit of someone else.\nFor example, trust accounts are often used by attorneys to keep track of expense money their customers have given them. Often, to keep the amount in a trust account from looking like it’s yours, the amount is offset in a contra liability account (a Current Liability).',3),
(19,'Cash and cash equivalents','Money Market','Use Money market to track amounts in money market accounts.\nFor investments, see Current Assets, instead.',3),
(20,'Cash and cash equivalents','Rents Held in Trust','Use Rents held in trust to track deposits and rent held on behalf of the property owners.\nTypically only property managers use this type of account.',3),
(21,'Cash and cash equivalents','Bank','Use Savings accounts to track your savings and CD activity.\nEach savings account your company has at a bank or other financial institution should have its own Savings type account. For investments, see Current Assets, instead.',3),
(22,'Cash and cash equivalents','Transaction','Use Transaction accounts to track all your transaction activity, including debit card transactions.\r Each transaction account your company has at a bank or other financial institution should have its own Transaction type account in SincA.',3),
(23,'Fixed Assets','Accumulated depletion','Use Accumulated depletion to track how much you deplete a natural resource.',4),
(24,'Fixed Assets','Accumulated depreciation on property, plant and eq','Use Accumulated depreciation on property, plant and equipment to track how much you depreciate a fixed asset (a physical asset you do not expect to convert to cash during one year of normal operations).',4),
(25,'Fixed Assets','Buildings','Use Buildings to track the cost of structures you own and use for your business. If you have a business in your home, consult your accountant.\nUse a Land account for the land portion of any real property you own, splitting the cost of the property between land and building in a logical method. A common method is to mimic the land-to-building ratio on the property tax statement.',4),
(26,'Fixed Assets','Depletable Assets','Use Depletable assets to track natural resources, such as timberlands, oil wells, and mineral deposits.',4),
(27,'Fixed Assets','Furniture and Fixtures','Use Furniture and fixtures to track any furniture and fixtures your business owns and uses, like a dental chair or sales booth.',4),
(28,'Fixed Assets','Intangible Assets','Use Intangible assets to track intangible assets that you plan to amortise. Examples include franchises, customer lists, copyrights, and patents.',4),
(29,'Fixed Assets','Land','Use Land to track assets that are not easily convertible to cash or not expected to become cash within the next year. For example, leasehold improvements.',4),
(30,'Fixed Assets','Leasehold Improvements','Use Leasehold improvements to track improvements to a leased asset that increases the asset’s value. For example, if you carpet a leased office space and are not reimbursed, that’s a leasehold improvement.',4),
(31,'Fixed Assets','Machinery and equipment','Use Machinery and equipment to track computer hardware, as well as any other non-furniture fixtures or devices owned and used for your business.\nThis includes equipment that you ride, like tractors and lawn mowers. Cars and trucks, however, should be tracked with Vehicle accounts, instead.',4),
(32,'Fixed Assets','Other fixed assets','Use Other fixed asset for fixed assets that are not covered by other asset types.\nFixed assets are physical property that you use in your business and that you do not expect to convert to cash or be used up during one year of normal operations.',4),
(33,'Fixed Assets','Vehicles','Use Vehicles to track the value of vehicles your business owns and uses for business. This includes off-road vehicles, air planes, helicopters, and boats.\nIf you use a vehicle for both business and personal use, consult your accountant to see how you should track its value.',4),
(34,'Non-current Assets','Accumulated amortisation of non-current assets','Use Accumulated amortisation of non-current assets to track how much you’ve amortised an asset whose type is Non-Current Asset.',5),
(35,'Non-current Assets','Assets held for sale','Use Assets held for sale to track assets of a company that are available for sale that are not expected to be held for a long period of time.',5),
(36,'Non-current Assets','Deferred tax','Use Deferred tax for tax liabilities or assets that are to be used in future accounting periods.',5),
(37,'Non-current Assets','Goodwill','Use Goodwill only if you have acquired another company. It represents the intangible assets of the acquired company which gave it an advantage, such as favourable government relations, business name, outstanding credit ratings, location, superior management, customer lists, product quality, or good labour relations.',5),
(38,'Non-current Assets','Intangible Assets','Use Intangible assets to track intangible assets that you plan to amortise. Examples include franchises, customer lists, copyrights, and patents.',5),
(39,'Non-current Assets','Investments','Use Investments to track the amounts received from individuals or other organisations',5),
(40,'Non-current Assets','Lease Buyout','Use Lease buyout to track lease payments to be applied toward the purchase of a leased asset. You don’t track the leased asset itself until you purchase it.',5),
(41,'Non-current Assets','Licences','Use Licences to track non-professional licences for permission to engage in an activity, like selling alcohol or radio broadcasting. For fees associated with professional licences granted to individuals, use a Legal and professional fees expense account, instead.',5),
(42,'Non-current Assets','Long-term investments','Use Long-term investments to track investments that have a maturity date of longer than one year.',5),
(43,'Non-current Assets','Organisational Costs','Use Organisational costs to track costs incurred when forming a partnership or corporation. The costs include the legal and accounting costs necessary to organise the company, facilitate the filings of the legal documents, and other paperwork.',5),
(44,'Non-current Assets','Other non-current assets','Use Other non-current assets to track assets not covered by other types. Non-current assets are long-term assets that are expected to provide value for more than one year.',5),
(45,'Non-current Assets','Security Deposits','Use Security deposits to track funds you’ve paid to cover any potential costs incurred by damage, loss, or theft. The funds should be returned to you at the end of the contract. If you collect deposits, use an Other current liabilities account (a Current liability account).',5),
(46,'Accounts Payable (A/P)','Accounts Payable (A/P)','Accounts payable (also called A/P, Trade and other payables, or Creditors) tracks amounts you owe to your suppliers. SincA automatically creates one Accounts Payable account for you. Most businesses need only one.',6),
(47,'Credit Card','Credit Card','Credit card accounts track the balance due on your business credit cards. Create one Credit card account for each credit card account your business uses.',7),
(48,'Current liabilities','Accrued liabilities','Use Accrued Liabilities to track expenses that a business has incurred but has not yet paid. For example, pensions for companies that contribute to a pension fund for their employees for their retirement.',8),
(49,'Current liabilities','BAS Payable','Use BAS payable to track GST or other tax you have collected, but not yet remitted to ATO.',8),
(50,'Current liabilities','Client Trust Accounts - Liabilities','Use Client Trust accounts - liabilities to offset Client Trust accounts in assets. Amounts in these accounts are held by your business on behalf of others. They do not belong to your business, so should not appear to be yours on your balance sheet. This contra account takes care of that, as long as the two balances match.',8),
(51,'Current liabilities','Current Liabilities','Use Current liabilities to track liabilities due within the next twelve months that do not fit the Current liability account types.',8),
(52,'Current liabilities','Current Tax Liability','Use Current tax liability to track the total amount of taxes collected but not yet paid to the government.',8),
(53,'Current liabilities','Current portion of employee benefits obligations','Use Current portion of employee benefits obligations to track the current amount due of employee benefits',8),
(54,'Current liabilities','Current portion of obligations under finance lease','Use Current portion of obligations under finance leases to track the value of lease payments due within the next 12 months.',8),
(55,'Current liabilities','Dividends payable','Use Dividends payable to track dividends that are owed to shareholders but have not yet been paid.',8),
(56,'Current liabilities','Federal Income Tax Payable','Use Federal income tax payable if your business keeps records on an accrual basis. This account tracks income tax liabilities in the year the income is earned.',8),
(57,'Current liabilities','Income tax payable','Use Income tax payable to track monies that are due to pay the company’s income tax liabilities.',8),
(58,'Current liabilities','Insurance payable','Use Insurance payable to keep track of insurance amounts due. This account is most useful for businesses with monthly recurring insurance expenses.',8),
(59,'Current liabilities','Line of Credit','Use Line of credit to track the balance due on any lines of credit your business has. Each line of credit your business has should have its own Line of credit account.',8),
(60,'Current liabilities','Loan Payable','Use Loan payable to track loans your business owes which are payable within the next twelve months. For longer-term loans, use the Long-term liability called Notes payable, instead.',8),
(61,'Current liabilities','Other current liabilities','Use Other current liabilities to track monies owed by the company and due within one year.',8),
(62,'Current liabilities','Payroll Clearing','Use Payroll clearing to keep track of any non-tax amounts that you have deducted from employee payroll payments or that you owe as a result of doing payroll. When you forward money to the appropriate suppliers, deduct the amount from the balance of this account. Do not use this account for tax amounts you have withheld or owe from paying employee wages. For those amounts, use the Payroll tax payable account instead.',8),
(63,'Current liabilities','Payroll liabilities','Use Payroll liabilities to keep track of tax amounts that you owe to government agencies as a result of paying wages. This includes taxes withheld, health care premiums, employment insurance, government pensions, etc. When you forward the money to the government agency, deduct the amount from the balance of this account.',8),
(64,'Current liabilities','Prepaid Expenses Payable','Use Prepaid expenses payable to track items such as property taxes that are due, but not yet deductible as an expense because the period they cover has not yet passed.',8),
(65,'Current liabilities','Rents in trust - Liability','Use Rents in trust - liability to offset the Rents in trust amount in assets. Amounts in these accounts are held by your business on behalf of others. They do not belong to your business, so should not appear to be yours on your balance sheet. This contra account takes care of that, as long as the two balances match.',8),
(66,'Current liabilities','Short term borrowings from related parties','Use Short term borrowings to track loans that need to be paid back within 12 months.',8),
(67,'Current liabilities','Sundry debtors and creditors','Use Sundry debtors and creditors to track miscellaneous amounts owed by customers and to suppliers that are not assigned their own account, and that are due within a year.',8),
(68,'Non-current liabilities','Accrued holiday payable','Use Accrued holiday payable to track holiday earned but that has not been paid out to employees.',9),
(69,'Non-current liabilities','Accrued non-current liabilities','Use Accrued Non-current liabilities to track expenses that a business has incurred but has not yet paid. For example, pensions for companies that contribute to a pension fund for their employees for their retirement.',9),
(70,'Non-current liabilities','Bank loans','Use Bank loans to track the amount due on bank loans.',9),
(71,'Non-current liabilities','Debts related to participating interests','Use Debts related to participating interests to track amounts owed to employees (or on their behalf) that are not due within a year.',9),
(72,'Non-current liabilities','Liabilities related to assets held for sale','Use Liabilities related to assets held for sale to track any liabilities that are directly related to assets being sold or written off.',9),
(73,'Non-current liabilities','Long term borrowings','Use Long term borrowings to track the amount due on long term borrowing',9),
(74,'Non-current liabilities','Long-term debt','Use Long-term debt to track loans and obligations with a maturity of longer than one year. For example, mortgages.',9),
(75,'Non-current liabilities','Notes Payable','Use Notes payable to track the amounts your business owes in long-term (over twelve months) loans. For shorter loans, use the Current liability account type called Loan payable, instead.',9),
(76,'Non-current liabilities','Other non-current liabilities','Use Other non-current liabilities to track liabilities due in more than twelve months that don’t fit the other Non-Current liability account types.',9),
(77,'Non-current liabilities','Shareholder Notes Payable','Use Shareholder notes payable to track long-term loan balances your business owes its shareholders.',9),
(78,'Non-current liabilities','Staff and related accounts','Use Staff and related accounts to track miscellaneous amounts owed by customers and to suppliers that are not assigned their own account, and that are not due within a year.',9),
(79,'Owner''s equity','Accumulated adjustment','Some corporations use this account to track adjustments to owner’s equity that are not attributable to net income.',10),
(80,'Owner''s equity','Dividend disbursed','Use Dividend disbursed to track a payment given to its shareholders out of the company’s retained earnings.',10),
(81,'Owner''s equity','Equity in earnings of subsidiaries','Use Equity in earnings of subsidiaries to track the original investment in shares of subsidiaries plus the share of earnings or losses from the operations of the subsidiary.',10),
(82,'Owner''s equity','Opening Balance Equity','SincA creates this account the first time you enter an opening balance for a balance sheet account. As you enter opening balances, SincA records the amounts in Opening balance equity. This ensures that you have a correct balance sheet for your company, even before you’ve finished entering all your company’s assets and liabilities.',10),
(83,'Owner''s equity','Ordinary shares','Corporations use Ordinary shares to track its ordinary shares in the hands of shareholders. The amount in this account should be the stated (or par) value of the inventory.',10),
(84,'Owner''s equity','Other comprehensive income','Use Other comprehensive income to track the increases or decreases in income from various businesses that is not yet absorbed by the company.',10),
(85,'Owner''s equity','Owner''s Equity','Corporations use Owner’s equity to show the cumulative net income or loss of their business as of the beginning of the financial year.',10),
(86,'Owner''s equity','Paid-in capital or surplus','Corporations use Paid-in capital to track amounts received from shareholders in exchange for shares that are over and above the shares’ stated (or par) value.',10),
(87,'Owner''s equity','Partner Contributions','Partnerships use Partner contributions to track amounts partners contribute to the partnership during the year.',10),
(88,'Owner''s equity','Partner Distributions','Partnerships use Partner distributions to track amounts distributed by the partnership to its partners during the year. Don’t use this for regular payments to partners for interest or service. For regular payments, use a Guaranteed payments account (a Expense account in Payroll expenses), instead.',10),
(89,'Owner''s equity','Partner''s Equity','Partnerships use Partner’s equity to show the income remaining in the partnership for each partner as of the end of the prior year.',10),
(90,'Owner''s equity','Preferred shares','Corporations use this account to track its preferred shares in the hands of shareholders. The amount in this account should be the stated (or par) value of the shares.',10),
(91,'Owner''s equity','Retained Earnings','SincA adds this account when you create your company.\r Retained earnings tracks net income from previous financial years. SincA automatically transfers your profit (or loss) to Retained earnings at the end of each financial year.',10),
(92,'Owner''s equity','Share capital','Use Share capital to track the funds raised by issuing shares.',10),
(93,'Owner''s equity','Treasury Shares','Corporations use Treasury shares to track amounts paid by the corporation to buy its own shares back from shareholders.',10),
(94,'Income','Discounts/Refunds Given','Use Discounts/refunds given to track discounts you give to customers. This account typically has a negative balance so it offsets other income.\nFor discounts from suppliers, use an expense account, instead.',11),
(95,'Income','Non-Profit Income','Use Non-profit income to track money coming in if you are a non-profit organization',11),
(96,'Income','Operating grants','Use Operating grants to track capital transfers in cash or in kind made by governments or by the rest of the world for regular operating purposes.',11),
(97,'Income','Other Primary Income','Use Other primary income to track income from normal business operations that doesn’t fall into another Income type.',11),
(98,'Income','Other current operating income','Use Other current operating income to track income arising from operations of the company that do not fit under any other category and that are not tracked in individual accounts.',11),
(99,'Income','Own work capitalised','Use Own work capitalised to track the value of work performed for one’s own purposes and capitalised as part of fixed assets.',11),
(100,'Income','Revenue - General','Use Revenue - General to track income from normal business operations that do not fit under any other category.',11),
(101,'Income','Sales - retail','Use Sales - retail to track sales of goods/services that have a mark-up cost to consumers.',11),
(102,'Income','Sales - wholesale','Use Sales - wholesale to track the sale of goods in quantity for resale purposes.',11),
(103,'Income','Sales of Product Income','Use Sales of product income to track income from selling products. This can include all kinds of products, like crops and livestock, rental fees, performances, and food served.',11),
(104,'Income','Service/Fee Income','Use Service/fee income to track income from services you perform or ordinary usage fees you charge. For fees customers pay you for late payments or other uncommon situations, use an Other Income account type called Other miscellaneous income, instead.',11),
(105,'Income','Unapplied Cash Payment Income','Unapplied Cash Payment Income reports the Cash Basis income from customers payments you’ve received but not applied to invoices or charges. In general, you would never use this directly on a purchase or sale transaction.',11),
(106,'Other income','Dividend income','Use Dividend income to track taxable dividends from investments.',12),
(107,'Other income','Interest earned','Use Interest earned to track interest from bank or savings accounts, investments, or interest payments to you on loans your business made.',12),
(108,'Other income','Loss on disposal of assets','Use Loss on disposal of assets to track losses realised on the disposal of assets.',12),
(109,'Other income','Other Investment Income','Use Other investment income to track other types of investment income that isn’t from dividends or interest.',12),
(110,'Other income','Other Miscellaneous Income','Use Other miscellaneous income to track income that isn’t from normal business operations, and doesn’t fall into another Other Income type.',12),
(111,'Other income','Other operating income','Use Other operating income to track income from activities other than normal business operations. For example, Investment interest, foreign exchange gains, and rent income.',12),
(112,'Other income','Tax-Exempt Interest','Use Tax-exempt interest to record interest that isn’t taxable, such as interest on money in tax-exempt retirement accounts, or interest from tax-exempt bonds.',12),
(113,'Other income','Unrealised loss on securities, net of tax','Use Unrealised loss on securities, net of tax to track losses on securities that have occurred but are yet been realised through a transaction. For example, shares whose value has fallen but that are still being held.',12),
(114,'Cost of Sales','Cost of Sales','',13),
(115,'Cost of Sales','Cost of labour - COS','Use Cost of labour - COS to track the cost of paying employees to produce products or supply services. It includes all employment costs, including food and transportation, if applicable.',13),
(116,'Cost of Sales','Equipment rental - COS','Use Equipment rental - COS to track the cost of renting equipment to produce products or services. If you purchase equipment, use a Fixed Asset account type called Machinery and equipment.',13),
(117,'Cost of Sales','Freight and delivery - COS','Use Freight and delivery - COS to track the cost of shipping/delivery of obtaining raw materials and producing finished goods for resale.',13),
(118,'Cost of Sales','Other costs of sales - COS','Use Other costs of sales - COS to track costs related to services or sales that you provide that don’t fall into another Cost of Sales type.',13),
(119,'Cost of Sales','Shipping, Freight and Delivery - COS','Use Shipping, freight and delivery - COS to track the cost of shipping products to customers or distributors.',13),
(120,'Cost of Sales','Supplies and materials - COS','Use Supplies and materials - COS to track the cost of raw goods and parts used or consumed when producing a product or providing a service.',13),
(121,'Expenses','Advertising/Promotional','Use Advertising/promotional to track money spent promoting your company. You may want different accounts of this type to track different promotional efforts (Yellow Pages, newspaper, radio, flyers, events, and so on).\nIf the promotion effort is a meal, use Promotional meals instead.',14),
(122,'Expenses','Amortisation expense','Use Amortisation expense to track writing off of assets (such as intangible assets or investments) over the projected life of the assets.',14),
(123,'Expenses','Auto','Use Auto to track costs associated with vehicles.\nYou may want different accounts of this type to track petrol, repairs, and maintenance. If your business owns a car or lorry, you may want to track its value as a Fixed Asset, in addition to tracking its expenses.',14),
(124,'Expenses','Bad debts','Use Bad debt to track debt you have written off.',14),
(125,'Expenses','Bank charges','Use Bank charges for any fees you pay to financial institutions.',14),
(126,'Expenses','Charitable Contributions','Use Charitable contributions to track gifts to charity.',14),
(127,'Expenses','Commissions and fees','Use Commissions and fees to track amounts paid to agents (such as brokers) in order for them to execute a trade.',14),
(128,'Expenses','Cost of Labour','Use Cost of labour to track the cost of paying employees to produce products or supply services. It includes all employment costs, including food and transportation, if applicable.\nThis account is also available as a Cost of Sales (COS) account.',14),
(129,'Expenses','Distribution costs','Use Distribution costs to track the cost of shipping goods to customers or distributors.',14),
(130,'Expenses','Dues and Subscriptions','Use Dues and subscriptions to track dues and subscriptions related to running your business. You may want different accounts of this type for professional dues, fees for licences that can’t be transferred, magazines, newspapers, industry publications, or service subscriptions.',14),
(131,'Expenses','Entertainment','Use Entertainment to track events to entertain employees. If the event is a meal, use Entertainment meals, instead.',14),
(132,'Expenses','Equipment rental','Use Equipment rental to track the cost of renting equipment to produce products or services. This account is also available as a Cost of Sales account. If you purchase equipment, use a Fixed asset account type called Machinery and equipment.',14),
(133,'Expenses','External services','Use External services to track expenses paid for services provided by other companies that you are tracking in Supplier-specific accounts. If you need to track expenses paid to other companies that do not have their own accounts, use Other external services instead.',14),
(134,'Expenses','Finance costs','Use Finance costs to track the costs of obtaining loans or credit. Examples of finance costs would be credit card fees, interest and mortgage costs.',14),
(135,'Expenses','Income tax expense','Use Income tax expense to track income taxes that the company has paid to meet their tax obligations.',14),
(136,'Expenses','Insurance','Use Insurance to track insurance payments. You may want different accounts of this type for different types of insurance (auto, general liability, and so on).',14),
(137,'Expenses','Interest paid','Use Interest paid for all types of interest you pay, including mortgage interest, finance charges on credit cards, or interest on loans.',14),
(138,'Expenses','Legal and professional fees','Use Legal and professional fees to track money to pay to professionals to help you run your business. You may want different accounts of this type for payments to your accountant, attorney, or other consultants.',14),
(139,'Expenses','Loss on discontinued operations, net of tax','Use Loss on discontinued operations, net of tax to track the loss realised when a part of the business ceases to operate or when a product line is discontinued.',14),
(140,'Expenses','Management compensation','Use Management compensation to track remuneration paid to Management, Executives and non-Executives. For example, salary, fees, and benefits.',14),
(141,'Expenses','Meals and entertainment','Use Meals and entertainment to track how much you spend on dining with your employees to promote morale. Be sure to include who you ate with and the purpose of the meal when you enter the transaction.',14),
(142,'Expenses','Office/General Administrative Expenses','Use Office/general administrative expenses to track all types of general or office-related expenses.',14),
(143,'Expenses','Other Miscellaneous Service Cost','Use Other miscellaneous service cost to track costs related to providing services that don’t fall into another Expense type. This account is also available as a Cost of Sales (COS) account.',14),
(144,'Expenses','Other current operating charge','Use Other current operating charges to track operating expenses that do not fall under any other category.',14),
(145,'Expenses','Other external services','Use Other external services to track expenses paid for services provided by other companies that you are not tracking in Supplier-specific accounts. If you need to track expenses paid to other companies that do have their own accounts, use External services instead.',14),
(146,'Expenses','Other selling expenses','Use Other selling expenses to track selling expenses incurred that do not fall under any other category.',14),
(147,'Expenses','Payroll Expenses','Use Payroll expenses to track payroll expenses. You may want different accounts of this type for things like: Compensation of officers, Guaranteed payments, Workers compensation, Salaries and wages, Payroll taxes',14),
(148,'Expenses','Project studies, surveys, assessments','Use Project studies, surveys, assessments to track expenses relating to studies, surveys, and assessments.',14),
(149,'Expenses','Promotional Meals','Use Promotional meals to track how much you spend dining with a customer to promote your business. Be sure to include who you ate with and the purpose of the meal when you enter the transaction.',14),
(150,'Expenses','Rent or Lease of Buildings','Use Rent or lease of buildings to track rent payments you make.',14),
(151,'Expenses','Repair and maintenance','Use Repair and maintenance to track any repairs and periodic maintenance fees. You may want different accounts of this type to track different types repair & maintenance expenses (auto, equipment, landscape, and so on).',14),
(152,'Expenses','Shipping and delivery expense','Use Shipping and delivery expense to track the cost of shipping and delivery of goods to customers.',14),
(153,'Expenses','Shipping, Freight, and Delivery','Use Shipping, Freight and Delivery to track the cost of shipping products to customers or distributors. You might use this type of account for incidental shipping expenses, and the COS type of Shipping, freight & delivery account for direct costs.\nThis account is also available as a Cost of Sales (COS) account.',14),
(154,'Expenses','Staff costs','Use Staff costs to track costs that can be associated with employees, such as benefits or parties.',14),
(155,'Expenses','Sundry','Use Sundry to track miscellaneous expenses that do not fit under any other category.',14),
(156,'Expenses','Supplies and materials','Use Supplies & materials to track the cost of raw goods and parts used or consumed when producing a product or providing a service. This account is also available as a Cost of Sales account.',14),
(157,'Expenses','Taxes Paid','Use Taxes paid to track taxes you pay. You may want different accounts of this type for payments to different tax agencies.',14),
(158,'Expenses','Travel','Use Travel to track travel costs. For food you eat while travelling, use Travel meals, instead.',14),
(159,'Expenses','Travel expenses - general and admin expenses','Use Travel expenses - general and admin expenses to track travelling costs incurred that are not directly related to the revenue-generating operation of the company. For example, flight tickets and hotel costs when performing job interviews.',14),
(160,'Expenses','Travel expenses - selling expense','Use Travel expenses - selling expense to track travelling costs incurred that are directly related to the revenue-generating operation of the company. For example, flight tickets and hotel costs when selling products and services.',14),
(161,'Expenses','Travel meals','Use Travel meals to track how much you spend on food while travelling. If you dine with a customer to promote your business, use a Promotional meals account, instead. If you dine with your employees to promote morale, use Entertainment meals, instead.',14),
(162,'Expenses','Unapplied Cash Bill Payment Expense','Unapplied Cash Bill Payment Expense reports the Cash Basis expense from supplier payment cheques you’ve sent but not yet applied to supplier bills. In general, you would never use this directly on a purchase or sale transaction.',14),
(163,'Expenses','Utilities','Use Utilities to track utility payments. You may want different accounts of this type to track different types of utility payments (gas and electric, telephone, water, and so on).',14),
(164,'Other Expense','Amortisation','Use Amortisation to track amortisation of intangible assets. Amortisation is spreading the cost of an intangible asset over its useful life, like depreciation of fixed assets.\nYou may want an amortisation account for each intangible asset you have.',15),
(165,'Other Expense','BAS Roundoff Gain or Loss','Use BAS Roundoff Gain or Loss to track gains or losses that occur as a result of BAS lodgement roundoff.',15),
(166,'Other Expense','Depreciation','Use Depreciation to track how much you depreciate fixed assets. You may want a depreciation account for each fixed asset you have.',15),
(167,'Other Expense','Exchange Gain or Loss','Use Exchange Gain or Loss to track gains or losses that occur as a result of exchange rate fluctuations.',15),
(168,'Other Expense','Other Expense','Use Other expense to track unusual or infrequent expenses that don’t fall into another Other Expense type.',15),
(169,'Other Expense','Penalties and settlements','Use Penalties and settlements to track money you pay for violating laws or regulations, settling lawsuits, or other penalties.',15),
(170,'Direct Expenses','Direct Expenses','',16),
(171,'Fixed Assets','Electronics','',4),
(174,'Current Assets','Staff','',2),
(175,'Current Assets','Trainees','',2),
(176,'Purchase','Purchase','',17);

-- 
-- Definition of batches
-- 

CREATE TABLE IF NOT EXISTS `batches` (
  `id` int NOT NULL AUTO_INCREMENT,
  `batch_id` varchar(36) NOT NULL,
  `uid` int NOT NULL,
  `ref_no` varchar(45) NOT NULL,
  `table_name` varchar(45) NOT NULL,
  `mode` varchar(45) NOT NULL,
  `batchno` varchar(45) NOT NULL,
  `mfg` datetime DEFAULT NULL,
  `exp` datetime DEFAULT NULL,
  `stockin` double NOT NULL DEFAULT '0',
  `stockout` double NOT NULL DEFAULT '0',
  `status` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- 
-- Dumping data for table batches
-- 



-- 
-- Definition of centralsyncactivity
-- 

CREATE TABLE IF NOT EXISTS `centralsyncactivity` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sync_id` int NOT NULL,
  `sincamob_id` varchar(20) NOT NULL,
  `sincamob_name` varchar(100) NOT NULL,
  `sincamob_branch_id` varchar(50) NOT NULL,
  `central_sync_id` varchar(20) NOT NULL,
  `central_table` varchar(30) NOT NULL,
  `sync_mode` varchar(50) NOT NULL,
  `sync_data` json NOT NULL,
  `sync_time` datetime NOT NULL,
  `user` varchar(20) NOT NULL,
  `status` varchar(20) NOT NULL,
  `status_change` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- 
-- Dumping data for table centralsyncactivity
-- 



-- 
-- Definition of cheque_managemrnt
-- 

CREATE TABLE IF NOT EXISTS `cheque_managemrnt` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `chequedate` date NOT NULL,
  `chequenumber` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `narration` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `amount` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `to` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `reference` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `account` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table cheque_managemrnt
-- 



-- 
-- Definition of company
-- 

CREATE TABLE IF NOT EXISTS `company` (
  `company` varchar(450) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table company
-- 



-- 
-- Definition of brand
-- 

CREATE TABLE IF NOT EXISTS `brand` (
  `brand` varchar(450) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `company` varchar(450) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table brand
-- 



-- 
-- Definition of customerpoint
-- 

CREATE TABLE IF NOT EXISTS `customerpoint` (
  `biller` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `amount` double NOT NULL,
  `cusid` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `giftcardno` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `narration` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table customerpoint
-- 



-- 
-- Definition of damagestatusadd
-- 

CREATE TABLE IF NOT EXISTS `damagestatusadd` (
  `id` int NOT NULL AUTO_INCREMENT,
  `status` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table damagestatusadd
-- 



-- 
-- Definition of moredetails
-- 

CREATE TABLE IF NOT EXISTS `moredetails` (
  `id` int NOT NULL AUTO_INCREMENT,
  `MoreDetails` json NOT NULL,
  `Table` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mode` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `RefNo` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table moredetails
-- 



-- 
-- Definition of agent
-- 

CREATE TABLE IF NOT EXISTS `agent` (
  `id` int NOT NULL AUTO_INCREMENT,
  `agentName` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Address` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Mob` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `agentper` double NOT NULL,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table agent
-- 



-- 
-- Definition of category
-- 

CREATE TABLE IF NOT EXISTS `category` (
  `id` int NOT NULL AUTO_INCREMENT,
  `Discount` double NOT NULL,
  `Category` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Aliascat` varchar(105) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Printer` varchar(105) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`Category`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table category
-- 



-- 
-- Definition of codeadv
-- 

CREATE TABLE IF NOT EXISTS `codeadv` (
  `parentcode` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Alias` varchar(450) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Code` varchar(450) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `maincode` int NOT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `Name` varchar(450) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `price` double NOT NULL,
  `qty` double NOT NULL,
  `qtyin` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `price1` double NOT NULL,
  `price2` double NOT NULL,
  `mrp` double NOT NULL,
  `size` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `verify` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `wooid` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `moredetails` json DEFAULT NULL,
  `codeadvcol` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table codeadv
-- 



-- 
-- Definition of complaints
-- 

CREATE TABLE IF NOT EXISTS `complaints` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cust_id` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `cust_name` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `moredetails` json DEFAULT NULL,
  `status` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `dated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table complaints
-- 



-- 
-- Definition of customergroup
-- 

CREATE TABLE IF NOT EXISTS `customergroup` (
  `CustomerGroupName` varchar(450) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `ProfitP` double NOT NULL,
  `orderID` int NOT NULL,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table customergroup
-- 



-- 
-- Definition of daily_closing
-- 

CREATE TABLE IF NOT EXISTS `daily_closing` (
  `id_closing` int NOT NULL AUTO_INCREMENT,
  `cashinhand` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `closing_date` datetime NOT NULL,
  `closing_staff` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `daily_tax` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `daily_total_disc` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `opening_amount` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `total_cardpayment` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `total_credit` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `total_exp` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `total_sales` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `moredetails` json NOT NULL,
  `mode` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_closing`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table daily_closing
-- 



-- 
-- Definition of expence
-- 

CREATE TABLE IF NOT EXISTS `expence` (
  `id` int NOT NULL AUTO_INCREMENT,
  `Date` date NOT NULL,
  `RefNo` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Expence` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Amount` double NOT NULL,
  `Payee` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `PayeeRef` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `taxref` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `tax` double NOT NULL,
  `locaction` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `account` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `acoountref` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `expid` int NOT NULL,
  `md` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `PayeeName` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table expence
-- 



-- 
-- Definition of itemvariant
-- 

CREATE TABLE IF NOT EXISTS `itemvariant` (
  `id` int NOT NULL AUTO_INCREMENT,
  `mode` varchar(45) NOT NULL,
  `refno` varchar(45) NOT NULL,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- 
-- Dumping data for table itemvariant
-- 



-- 
-- Definition of jobcard
-- 

CREATE TABLE IF NOT EXISTS `jobcard` (
  `id` int NOT NULL AUTO_INCREMENT,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- 
-- Dumping data for table jobcard
-- 



-- 
-- Definition of journal
-- 

CREATE TABLE IF NOT EXISTS `journal` (
  `id` int NOT NULL AUTO_INCREMENT,
  `Date` date NOT NULL,
  `Debit` double NOT NULL,
  `Credit` double NOT NULL,
  `Memo` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Particuler` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Narration` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `jvno` int NOT NULL,
  `ac` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ParticulerId` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table journal
-- 



-- 
-- Definition of leads
-- 

CREATE TABLE IF NOT EXISTS `leads` (
  `id` int NOT NULL AUTO_INCREMENT,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table leads
-- 



-- 
-- Definition of location
-- 

CREATE TABLE IF NOT EXISTS `location` (
  `id` int NOT NULL AUTO_INCREMENT,
  `location` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `system_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `server_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `moredetails` json NOT NULL,
  `status` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table location
-- 



-- 
-- Definition of acctransaction
-- 

CREATE TABLE IF NOT EXISTS `acctransaction` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `Reference` varchar(450) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `AccountCr` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `AccountDr` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Particular` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Type` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Amount` double NOT NULL,
  `ref` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `location` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ccc` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `chqdate` date NOT NULL,
  `SincaRef` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `perfix` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `moredetails` json NOT NULL,
  `entryno` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table acctransaction
-- 



-- 
-- Definition of maincat
-- 

CREATE TABLE IF NOT EXISTS `maincat` (
  `category` varchar(450) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `main` varchar(450) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table maincat
-- 



-- 
-- Definition of opening
-- 

CREATE TABLE IF NOT EXISTS `opening` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cr` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `amt` double NOT NULL,
  `Status` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table opening
-- 



-- 
-- Definition of accounts
-- 

CREATE TABLE IF NOT EXISTS `accounts` (
  `id` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `AccountName` varchar(55) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Alias` varchar(55) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Group` int NOT NULL,
  `subGroup` int NOT NULL,
  `Address` varchar(55) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Address1` varchar(55) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `BankDetails` json NOT NULL,
  `taxble` tinyint NOT NULL,
  `TaxRegNo` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `OpDate` date NOT NULL,
  `Opening` double NOT NULL,
  `status` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`),
  KEY `Mgroup_index` (`Group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table accounts
-- 

INSERT INTO `accounts`(`id`,`AccountName`,`Alias`,`Group`,`subGroup`,`Address`,`Address1`,`BankDetails`,`taxble`,`TaxRegNo`,`OpDate`,`Opening`,`status`,`moredetails`) VALUES
('-1','Wallet/UPI/Card Commissions','Wallet/UPI/Card Commissions',14,127,'','','null',0,'','0001-01-01 00:00:00',0,'','null'),
('-2','Wallet/UPI/Card Receivable','Wallet/UPI/Card Receivable',1,1,'','','null',0,'','0001-01-01 00:00:00',0,'','null'),
('-3','Counter Expenses','Counter Expenses',15,168,'','','null',0,'','0001-01-01 00:00:00',0,'','null'),
('-4','Round off','Round off',15,165,'','','null',0,'','0001-01-01 00:00:00',0,'','null'),
('-5','Local Purchase','Local Purchase',6,46,'','','null',0,'','0001-01-01 00:00:00',0,'','null'),
('0','Cash','Cash',3,16,'','','null',0,'','0001-01-01 00:00:00',0,'','null');

-- 
-- Definition of customer
-- 

CREATE TABLE IF NOT EXISTS `customer` (
  `id` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `idd` int NOT NULL,
  `Name` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(405) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `code` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Credit` double NOT NULL,
  `DueDate` date NOT NULL,
  `Giftcard` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `MobNo` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `UID` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `place` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `group` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `state` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `GSTIN` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `statecode` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Point` double NOT NULL,
  `opening` double NOT NULL,
  `openingDate` date NOT NULL,
  `status` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Active',
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table customer
-- 



-- 
-- Definition of poslog
-- 

CREATE TABLE IF NOT EXISTS `poslog` (
  `date` date NOT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `invoice` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `work` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table poslog
-- 



-- 
-- Definition of powerof
-- 

CREATE TABLE IF NOT EXISTS `powerof` (
  `id` int NOT NULL AUTO_INCREMENT,
  `powerof` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `power` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table powerof
-- 



-- 
-- Definition of powers
-- 

CREATE TABLE IF NOT EXISTS `powers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `power` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `deatails` json NOT NULL,
  `status` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table powers
-- 

INSERT INTO `powers`(`id`,`power`,`deatails`,`status`,`moredetails`) VALUES
(1,'admin','[]','','{\"dash\": {\"WA\": true, \"Sync\": true, \"Notes\": true, \"Warning\": true, \"RecentTabs\": true, \"btnInvoice\": true, \"invNoSearch\": true, \"salesReport\": true, \"btnInventory\": true, \"stockWarning\": true, \"invDateSearch\": true}, \"sales\": {\"invEdit\": true, \"invSplit\": true, \"invReturn\": true, \"invSearch\": true, \"invDisable\": true, \"priceChange\": true, \"discountLimit\": 100.0, \"invDateChange\": true, \"salesDiscount\": true, \"invUnclosedConfirm\": true}}'),
(2,'Stock','[10000, 10010, 10020, 10030, 10040, 10050, 10060, 10070, 10080, 10090, 10110, 10120, 10130, 10200, 5050, 5060, 5070, 5090, 5100, 5120, 5130, 5140, 5160, 5170, 2900, 4000, 4001, 4010, 4020, 4101, 4110, 4140, 4150, 4160, 4180, 4450, 4460, 4480, 4490, 4299, 4300, 4500, 5150, 4470, 4120, 4130, 4305, 4343, 4348, 4345, 4350, 4315, 4325, 4336, 4335, 4330, 4340, 5110]','','{\"dash\": {\"WA\": true, \"Sync\": true, \"Notes\": true, \"Warning\": true, \"RecentTabs\": true, \"btnInvoice\": false, \"invNoSearch\": false, \"salesReport\": false, \"btnInventory\": true, \"stockWarning\": true, \"invDateSearch\": false}, \"sales\": {\"invEdit\": false, \"invSplit\": false, \"invReturn\": false, \"invSearch\": false, \"invDisable\": false, \"priceChange\": false, \"discountLimit\": 10.0, \"invDateChange\": false, \"salesDiscount\": false, \"invUnclosedConfirm\": true}}'),
(3,'Biller','[7000, 7010, 7020, 7030, 7040, 7050, 7070, 1000, 1010, 1030, 1035, 1050, 1120]','','{\"dash\": {\"WA\": true, \"Sync\": true, \"Notes\": true, \"Warning\": true, \"RecentTabs\": true, \"btnInvoice\": true, \"invNoSearch\": true, \"salesReport\": true, \"btnInventory\": false, \"stockWarning\": false, \"invDateSearch\": true}, \"sales\": {\"invEdit\": false, \"invSplit\": false, \"invReturn\": false, \"invSearch\": false, \"invDisable\": false, \"priceChange\": false, \"discountLimit\": 10.0, \"invDateChange\": true, \"salesDiscount\": true, \"invUnclosedConfirm\": true}}'),
(4,'Barcode','[10010, 10020, 10030, 10040, 10060, 10070, 10080, 10090]','','{\"dash\": {\"WA\": true, \"Sync\": true, \"Notes\": true, \"Warning\": false, \"RecentTabs\": false, \"btnInvoice\": false, \"invNoSearch\": false, \"salesReport\": false, \"btnInventory\": false, \"stockWarning\": true, \"invDateSearch\": false}, \"sales\": {\"invEdit\": false, \"invSplit\": false, \"invReturn\": false, \"invSearch\": false, \"invDisable\": false, \"priceChange\": false, \"discountLimit\": 10.0, \"invDateChange\": false, \"salesDiscount\": false, \"invUnclosedConfirm\": true}}'),
(5,'Cashier','[7000, 7010, 7020, 7030, 7040, 7050, 7070, 7090, 1000, 1010, 1030, 1035, 1036, 1040, 1042, 1047, 1049, 1050, 1190, 1180, 1160, 1130, 1100, 1120, 1090, 1060, 1055, 1052, 1200, 5000, 5140, 5560, 3001, 3010, 7200, 7100, 3030, 3040, 3050, 3060, 3070, 3020]','','{\"dash\": {\"WA\": true, \"Sync\": true, \"Notes\": true, \"Warning\": true, \"RecentTabs\": true, \"btnInvoice\": true, \"invNoSearch\": true, \"salesReport\": true, \"btnInventory\": false, \"stockWarning\": false, \"invDateSearch\": true}, \"sales\": {\"invEdit\": true, \"invSplit\": true, \"invReturn\": true, \"invSearch\": true, \"invDisable\": true, \"priceChange\": true, \"discountLimit\": 10.0, \"invDateChange\": true, \"salesDiscount\": true, \"invUnclosedConfirm\": true}}'),
(7,'Online Report','[1050, 2130, 2131, 2133, 2140, 2148, 3010, 3020, 4010, 4450, 4140, 5000, 5610, 5615, 5620, 5625, 5635, 5120]','','{\"CRM\": {\"LeadsViewPower\": false}, \"Inv\": {\"inventoryProf\": false}, \"dash\": {\"WA\": false, \"Sync\": false, \"Notes\": false, \"Warning\": true, \"PieChart\": false, \"mostused\": false, \"totalcus\": false, \"totalsup\": false, \"ecommerce\": false, \"RecentTabs\": false, \"btnInvoice\": false, \"totalstaff\": false, \"invNoSearch\": false, \"salesReport\": true, \"weeklysales\": false, \"btnInventory\": true, \"stockWarning\": true, \"counterDetail\": true, \"invDateSearch\": true, \"qckcounterclose\": false, \"RecentActivities\": false}, \"sales\": {\"foc\": false, \"PRSR\": false, \"invPay\": false, \"TProfit\": false, \"invEdit\": false, \"InvDateW\": false, \"InvPrice\": false, \"invSplit\": false, \"payLater\": false, \"BillModeP\": \"\", \"CostPrice\": false, \"invReturn\": false, \"invSearch\": false, \"pricetype\": \"N\", \"saveOrder\": false, \"unpaidbtn\": false, \"PriceGroup\": false, \"invDisable\": false, \"multiprice\": false, \"JobCardEdit\": false, \"SearJobcard\": false, \"priceChange\": false, \"saveInvoice\": false, \"ReturnItmHis\": false, \"deliveryNote\": false, \"BillModePower\": false, \"DefaultBiller\": false, \"discountLimit\": 10.0, \"invDateChange\": false, \"salesDiscount\": false, \"savePrintOrder\": false, \"DefaultBillmode\": false, \"savePrintInvoice\": false, \"invUnclosedConfirm\": true}, \"stock\": {\"Byproduct\": false, \"StkAdjstmntBtn\": false}, \"finance\": {\"AllCounterClose\": false}, \"Miscelle\": {\"PrintPower\": true, \"ExportPower\": true}, \"dayClose\": false, \"StkRptPrv\": {\"Tax\": true, \"Cost\": true, \"Supplier\": true, \"BuyingPrice\": true}, \"shiftClose\": false}');

-- 
-- Definition of preproduction
-- 

CREATE TABLE IF NOT EXISTS `preproduction` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `ItemIDPre` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ItemNamePre` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `QuantityPre` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table preproduction
-- 



-- 
-- Definition of production
-- 

CREATE TABLE IF NOT EXISTS `production` (
  `id` int NOT NULL AUTO_INCREMENT,
  `prd_id` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ingredient_id` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ingredient_qty` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table production
-- 



-- 
-- Definition of purchaserequesition
-- 

CREATE TABLE IF NOT EXISTS `purchaserequesition` (
  `slno` int NOT NULL AUTO_INCREMENT,
  `Date` date NOT NULL,
  `PurchaseReqNo` varchar(250) NOT NULL,
  `uid` varchar(100) NOT NULL,
  `Itemname` varchar(500) NOT NULL,
  `Qty` double NOT NULL,
  `moredetails` json DEFAULT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- 
-- Dumping data for table purchaserequesition
-- 



-- 
-- Definition of quntityin
-- 

CREATE TABLE IF NOT EXISTS `quntityin` (
  `Quntityin` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`Quntityin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table quntityin
-- 

INSERT INTO `quntityin`(`Quntityin`) VALUES
('KGS'),
('LTR'),
('MTR'),
('NOS'),
('PCS'),
('SQF'),
('SQM');

-- 
-- Definition of serviceadd
-- 

CREATE TABLE IF NOT EXISTS `serviceadd` (
  `id` int NOT NULL AUTO_INCREMENT,
  `itemid` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `itemname` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cusid` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cusname` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cusmobno` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `edate` date NOT NULL,
  `service` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table serviceadd
-- 



-- 
-- Definition of servicestatusadd
-- 

CREATE TABLE IF NOT EXISTS `servicestatusadd` (
  `id` int NOT NULL AUTO_INCREMENT,
  `status` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table servicestatusadd
-- 



-- 
-- Definition of sinca_pref
-- 

CREATE TABLE IF NOT EXISTS `sinca_pref` (
  `id` int NOT NULL AUTO_INCREMENT,
  `mode` varchar(45) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- 
-- Dumping data for table sinca_pref
-- 

INSERT INTO `sinca_pref`(`id`,`mode`,`moredetails`) VALUES
(3,'ItemUpdated','1742404008'),
(4,'CustGroupUpdated','1742404008'),
(8,'CategoryUpdated','1742912266'),
(9,'StockUpdated','1745582865'),
(10,'PowerUpdated','1750497379'),
(13,'LocationUpdated','1750919043'),
(16,'GovRules','{\"proTax\": [{\"loc\": \"Kerala\", \"slab\": [{\"slab\": 11999.0}, {\"amt\": 20.0, \"slab\": 17999.0}, {\"amt\": 30.0, \"slab\": 29999.0}, {\"amt\": 50.0, \"slab\": 44999.0}, {\"amt\": 75.0, \"slab\": 59999.0}, {\"amt\": 100.0, \"slab\": 74999.0}, {\"amt\": 125.0, \"slab\": 99999.0}, {\"amt\": 167.0, \"slab\": 124999.0}, {\"amt\": 208.0, \"slab\": 124999.0}]}], \"TaxType\": \"GST\", \"MonthSlab\": 1, \"gstinInfo\": {\"userInfo\": {}}, \"TaxCountry\": \"India\", \"VATKsaInfo\": {\"SchemeList\": [{\"Value\": \"CRN\", \"Content\": \"Commercial registration number (CRN)\"}, {\"Value\": \"MOM\", \"Content\": \"Momra license (MOM)\"}, {\"Value\": \"MLS\", \"Content\": \"MLSD license (MLS)\"}, {\"Value\": \"SAG\", \"Content\": \"Sagia license (SAG)\"}, {\"Value\": \"OTH\", \"Content\": \"Other (OTH)\"}], \"_IsSandbox\": true, \"_IsProduction\": true}, \"countryCode\": {\"countryList\": [{\"ISO2\": \"IN\", \"ISO3\": \"IND\", \"list\": [{\"code\": \"01\", \"name\": \"Jammu & Kashmir\"}, {\"code\": \"02\", \"name\": \"Himachal Pradesh\"}, {\"code\": \"03\", \"name\": \"Punjab\"}, {\"code\": \"04\", \"name\": \"Chandigarh\"}, {\"code\": \"05\", \"name\": \"Uttranchal\"}, {\"code\": \"06\", \"name\": \"Haryana\"}, {\"code\": \"07\", \"name\": \"Delhi\"}, {\"code\": \"08\", \"name\": \"Rajasthan\"}, {\"code\": \"09\", \"name\": \"Uttar Pradesh\"}, {\"code\": \"10\", \"name\": \"Bihar\"}, {\"code\": \"11\", \"name\": \"Sikkim\"}, {\"code\": \"12\", \"name\": \"Arunachal Pradesh\"}, {\"code\": \"13\", \"name\": \"Nagaland\"}, {\"code\": \"14\", \"name\": \"Manipur\"}, {\"code\": \"15\", \"name\": \"Mizoram\"}, {\"code\": \"16\", \"name\": \"Tripura\"}, {\"code\": \"17\", \"name\": \"Meghalaya\"}, {\"code\": \"18\", \"name\": \"Assam\"}, {\"code\": \"19\", \"name\": \"West Bengal\"}, {\"code\": \"20\", \"name\": \"Jharkhand\"}, {\"code\": \"21\", \"name\": \"Orissa\"}, {\"code\": \"22\", \"name\": \"Chhattisgarh\"}, {\"code\": \"23\", \"name\": \"Madhya Pradesh\"}, {\"code\": \"24\", \"name\": \"Gujarat\"}, {\"code\": \"25\", \"name\": \"Daman & Diu\"}, {\"code\": \"26\", \"name\": \"Dadra & Nagar Haveli\"}, {\"code\": \"27\", \"name\": \"Maharashtra\"}, {\"code\": \"28\", \"name\": \"Andhra Pradesh\"}, {\"code\": \"29\", \"name\": \"Karnataka\"}, {\"code\": \"30\", \"name\": \"Goa\"}, {\"code\": \"31\", \"name\": \"Lakshadweep\"}, {\"code\": \"32\", \"name\": \"Kerala\"}, {\"code\": \"33\", \"name\": \"Tamil Nadu\"}, {\"code\": \"34\", \"name\": \"Pondicherry\"}, {\"code\": \"35\", \"name\": \"Andaman & Nicobar Islands\"}, {\"code\": \"36\", \"name\": \"Telangana\"}, {\"code\": \"37\", \"name\": \"Andhra Pradesh\"}, {\"code\": \"38\", \"name\": \"Ladakh\"}, {\"code\": \"97\", \"name\": \"Other Territory\"}, {\"code\": \"99\", \"name\": \"Centre Jurisdiction\"}], \"country\": \"India\"}, {\"ISO2\": \"SA\", \"ISO3\": \"SAU\", \"list\": [{\"code\": \"\", \"name\": \"Asir Province\"}, {\"code\": \"\", \"name\": \"Al-Bahah Province\"}, {\"code\": \"\", \"name\": \"Al-Jawf Province\"}, {\"code\": \"\", \"name\": \"Al-Qassim Province\"}, {\"code\": \"\", \"name\": \"Eastern Province\"}, {\"code\": \"\", \"name\": \"Ḥail Province\"}, {\"code\": \"\", \"name\": \"Jazan Province\"}, {\"code\": \"\", \"name\": \"Mecca Province\"}, {\"code\": \"\", \"name\": \"Medina Province\"}, {\"code\": \"\", \"name\": \"Najran Province\"}, {\"code\": \"\", \"name\": \"Northern Borders Province\"}, {\"code\": \"\", \"name\": \"Riyadh Province\"}, {\"code\": \"\", \"name\": \"Tabuk Province\"}], \"country\": \"Saudi Arabia\"}, {\"ISO2\": \"AE\", \"ISO3\": \"ARE\", \"list\": [{\"code\": \"\", \"name\": \"Abu Dhabi\"}, {\"code\": \"\", \"name\": \"Ajman\"}, {\"code\": \"\", \"name\": \"Dubai\"}, {\"code\": \"\", \"name\": \"Fujairah\"}, {\"code\": \"\", \"name\": \"Ras Al Khaimah\"}, {\"code\": \"\", \"name\": \"Sharjah\"}, {\"code\": \"\", \"name\": \"Umm Al Quwain\"}], \"country\": \"United Arab Emirates\"}, {\"ISO2\": \"US\", \"ISO3\": \"USA\", \"list\": [{\"code\": \"AL\", \"name\": \"Alabama\"}, {\"code\": \"AK\", \"name\": \"Alaska\"}, {\"code\": \"AZ\", \"name\": \"Arizona\"}, {\"code\": \"AR\", \"name\": \"Arkansas\"}, {\"code\": \"CA\", \"name\": \"California\"}, {\"code\": \"CO\", \"name\": \"Colorado\"}, {\"code\": \"CT\", \"name\": \"Connecticut\"}, {\"code\": \"DE\", \"name\": \"Delaware\"}, {\"code\": \"FL\", \"name\": \"Florida\"}, {\"code\": \"GA\", \"name\": \"Georgia\"}, {\"code\": \"HI\", \"name\": \"Hawaii\"}, {\"code\": \"ID\", \"name\": \"Idaho\"}, {\"code\": \"IL\", \"name\": \"Illinois\"}, {\"code\": \"IN\", \"name\": \"Indiana\"}, {\"code\": \"IA\", \"name\": \"IOWA\"}, {\"code\": \"KS\", \"name\": \"Kansas\"}, {\"code\": \"KY\", \"name\": \"Kentucky\"}, {\"code\": \"LA\", \"name\": \"Louisiana\"}, {\"code\": \"ME\", \"name\": \"Maine\"}, {\"code\": \"MD\", \"name\": \"Maryland\"}, {\"code\": \"MA\", \"name\": \"Massachusetts\"}, {\"code\": \"MI\", \"name\": \"Michigan\"}, {\"code\": \"MN\", \"name\": \"Minnesota\"}, {\"code\": \"MS\", \"name\": \"Mississippi\"}, {\"code\": \"MO\", \"name\": \"Missouri\"}, {\"code\": \"MT\", \"name\": \"Montana\"}, {\"code\": \"NE\", \"name\": \"Nebraska\"}, {\"code\": \"NV\", \"name\": \"Nevada\"}, {\"code\": \"NH\", \"name\": \"New Hampshire\"}, {\"code\": \"NJ\", \"name\": \"New Jersey\"}, {\"code\": \"NM\", \"name\": \"New Mexico\"}, {\"code\": \"NY\", \"name\": \"New York\"}, {\"code\": \"NC\", \"name\": \"North Carolina\"}, {\"code\": \"ND\", \"name\": \"North Dakota\"}, {\"code\": \"OH\", \"name\": \"Ohio\"}, {\"code\": \"OK\", \"name\": \"Oklahoma\"}, {\"code\": \"OR\", \"name\": \"Oregon\"}, {\"code\": \"PA\", \"name\": \"Pennsylvania\"}, {\"code\": \"RI\", \"name\": \"Rhode Island\"}, {\"code\": \"SC\", \"name\": \"South Carolina\"}, {\"code\": \"SD\", \"name\": \"South Dakota\"}, {\"code\": \"TN\", \"name\": \"Tennessee\"}, {\"code\": \"TX\", \"name\": \"Texas\"}, {\"code\": \"UT\", \"name\": \"Utah\"}, {\"code\": \"VT\", \"name\": \"Vermont\"}, {\"code\": \"VA\", \"name\": \"Virginia\"}, {\"code\": \"WA\", \"name\": \"Washington\"}, {\"code\": \"WV\", \"name\": \"West Virginia\"}, {\"code\": \"WI\", \"name\": \"Wisconsin\"}, {\"code\": \"WY\", \"name\": \"Wyoming\"}], \"country\": \"United States of America\"}]}}'),
(17,'StaffUpdated','1750919244');

-- 
-- Definition of sincareports
-- 

CREATE TABLE IF NOT EXISTS `sincareports` (
  `id` int NOT NULL AUTO_INCREMENT,
  `label` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `rawjson` json NOT NULL,
  `printfile` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table sincareports
-- 



-- 
-- Definition of staff_attendance
-- 

CREATE TABLE IF NOT EXISTS `staff_attendance` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date_attendance` date NOT NULL,
  `staffname` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `dailywork` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `checkin` time NOT NULL,
  `checkout` time NOT NULL,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table staff_attendance
-- 



-- 
-- Definition of staff_jobtitle
-- 

CREATE TABLE IF NOT EXISTS `staff_jobtitle` (
  `id` int NOT NULL AUTO_INCREMENT,
  `jobtitle` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table staff_jobtitle
-- 

INSERT INTO `staff_jobtitle`(`id`,`jobtitle`) VALUES
(1,'ADMINISTRATOR'),
(2,'WEIGHTER'),
(3,'SALES EXECUTIVE'),
(4,'ACCOUNTS');

-- 
-- Definition of staff_register
-- 

CREATE TABLE IF NOT EXISTS `staff_register` (
  `id` int NOT NULL,
  `idstaff_register` int NOT NULL AUTO_INCREMENT,
  `fname_staff` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `lname_staff` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `gender_staff` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `qualification_staff` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `address_staff` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `email_staff` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `dob_staff` date NOT NULL,
  `age_staff` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `joindate` date NOT NULL,
  `mob_staff` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `blood_staff` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `job_staff` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `salary_staff` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `job_id` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `OpeningAmt` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `OpeningDate` date NOT NULL,
  `moredetails` json NOT NULL,
  `status` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`idstaff_register`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table staff_register
-- 

INSERT INTO `staff_register`(`id`,`idstaff_register`,`fname_staff`,`lname_staff`,`gender_staff`,`qualification_staff`,`address_staff`,`email_staff`,`dob_staff`,`age_staff`,`joindate`,`mob_staff`,`blood_staff`,`job_staff`,`salary_staff`,`job_id`,`OpeningAmt`,`OpeningDate`,`moredetails`,`status`) VALUES
(1,1,'Admin','','Others','','','','2023-12-01 00:00:00','','2023-12-01 00:00:00','','','ADMINISTRATOR','0','','0','2023-12-01 00:00:00','{\"BA\": 0.0, \"DA\": 0.0, \"PF\": 0.0, \"SA\": 0.0, \"TA\": 0.0, \"ESI\": 0.0, \"HRA\": 0.0, \"PRO\": false, \"TDS\": 0.0, \"P_DA\": 0.0, \"docs\": [], \"Agent\": false, \"Bonus\": 0.0, \"Conve\": 0.0, \"ProLoc\": \"\", \"payment\": false, \"WageType\": \"\", \"WorkingX\": {\"fri\": true, \"mon\": true, \"sat\": true, \"sun\": false, \"thu\": true, \"tue\": true, \"wed\": true, \"friF\": \"09:00:00\", \"friT\": \"18:00:00\", \"monF\": \"09:00:00\", \"monT\": \"18:00:00\", \"satF\": \"09:00:00\", \"satT\": \"18:00:00\", \"sunF\": \"09:00:00\", \"sunT\": \"18:00:00\", \"thuF\": \"09:00:00\", \"thuT\": \"18:00:00\", \"tueF\": \"09:00:00\", \"tueT\": \"18:00:00\", \"wedF\": \"09:00:00\", \"wedT\": \"18:00:00\"}, \"allowInv\": false, \"paylater\": true, \"AllOrders\": false, \"employeeid\": 0, \"OrderCancel\": true}','Active');

-- 
-- Definition of staff_workflow
-- 

CREATE TABLE IF NOT EXISTS `staff_workflow` (
  `id` int NOT NULL AUTO_INCREMENT,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- 
-- Dumping data for table staff_workflow
-- 



-- 
-- Definition of stock_available
-- 

CREATE TABLE IF NOT EXISTS `stock_available` (
  `uid` varchar(36) NOT NULL,
  `loc_id` varchar(36) NOT NULL,
  `variant_id` varchar(36) NOT NULL,
  `batch_id` varchar(36) NOT NULL,
  `stock_in` double NOT NULL DEFAULT '0',
  `stock_out` double NOT NULL DEFAULT '0',
  `stock_actual` double GENERATED ALWAYS AS ((`stock_in` - `stock_out`)) STORED,
  `stock_in_hold` double NOT NULL DEFAULT '0',
  `stock_out_hold` double NOT NULL DEFAULT '0',
  `stock_forecast` double GENERATED ALWAYS AS (((`stock_actual` + `stock_in_hold`) - `stock_out_hold`)) STORED,
  `last_updated` varchar(11) DEFAULT NULL,
  PRIMARY KEY (`uid`,`loc_id`,`variant_id`,`batch_id`),
  KEY `idx_stock` (`loc_id`,`variant_id`,`batch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- 
-- Dumping data for table stock_available
-- 



-- 
-- Definition of stocktransfer
-- 

CREATE TABLE IF NOT EXISTS `stocktransfer` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `itemname` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `quantity` double NOT NULL,
  `loc_id` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `location` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `transferdate` date NOT NULL,
  `priceqty` double NOT NULL,
  `totalprice` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `inout` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `reff` varchar(145) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `note` varchar(145) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `discount` double NOT NULL,
  `locref` varchar(65) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `fromd` varchar(65) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `transferid` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `settlement` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `BPrice` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `TotalBPrice` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table stocktransfer
-- 



-- 
-- Definition of stocktransferv2
-- 

CREATE TABLE IF NOT EXISTS `stocktransferv2` (
  `id` int NOT NULL AUTO_INCREMENT,
  `mode` varchar(45) NOT NULL,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- 
-- Dumping data for table stocktransferv2
-- 



-- 
-- Definition of subcat
-- 

CREATE TABLE IF NOT EXISTS `subcat` (
  `category` varchar(450) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `main` varchar(450) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sub` varchar(450) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table subcat
-- 



-- 
-- Definition of supplier
-- 

CREATE TABLE IF NOT EXISTS `supplier` (
  `SupplierId` int NOT NULL AUTO_INCREMENT,
  `Supplier` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `detail` varchar(450) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ShopAddress` varchar(450) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ShopName` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `SupplierEmail` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `SupplierMob` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `GST` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Opening` double NOT NULL,
  `OpeningDate` date NOT NULL,
  `status` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Active',
  `moredetails` json NOT NULL,
  PRIMARY KEY (`SupplierId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table supplier
-- 



-- 
-- Definition of goodsreceipt
-- 

CREATE TABLE IF NOT EXISTS `goodsreceipt` (
  `account` varchar(255) NOT NULL,
  `Additional` double NOT NULL,
  `Alias` varchar(255) NOT NULL,
  `BillNo` varchar(255) NOT NULL,
  `InvNo` varchar(45) NOT NULL,
  `Cess` double NOT NULL,
  `Date` date NOT NULL,
  `DDate` date NOT NULL,
  `Discount` double NOT NULL,
  `exp` date NOT NULL,
  `intersate` varchar(255) NOT NULL,
  `InvId` int NOT NULL,
  `ItemBuyingPrice` double NOT NULL,
  `ItemBuyingPricectn` double NOT NULL,
  `Itemname` varchar(500) NOT NULL,
  `ItemSellingPrice` double NOT NULL,
  `ItemSellingPricectn` double NOT NULL,
  `mfg` date NOT NULL,
  `Qty` double NOT NULL,
  `SDate` date NOT NULL,
  `slno` int NOT NULL,
  `Supplier` varchar(255) NOT NULL,
  `Tax` double NOT NULL,
  `TotalPrice` double NOT NULL,
  `Tx` varchar(255) NOT NULL,
  `uid` varchar(255) NOT NULL,
  `moredetails` json NOT NULL,
  `SupplierId` varchar(255) NOT NULL,
  `mrp` double NOT NULL,
  `itemDiscount` double NOT NULL,
  `free` double NOT NULL,
  `Notes` varchar(400) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- 
-- Dumping data for table goodsreceipt
-- 



-- 
-- Definition of inventory
-- 

CREATE TABLE IF NOT EXISTS `inventory` (
  `slno` int NOT NULL AUTO_INCREMENT,
  `uid` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Date` date NOT NULL,
  `Itemname` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ItemBuyingPrice` double NOT NULL,
  `ItemSellingPrice` double NOT NULL,
  `Supplier` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `SupplierId` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Qty` double NOT NULL,
  `TotalPrice` double NOT NULL,
  `BillNo` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InvNo` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InvId` int NOT NULL,
  `DDate` date NOT NULL,
  `SDate` date NOT NULL,
  `Cess` double NOT NULL,
  `Additional` double NOT NULL,
  `Discount` double NOT NULL,
  `ItemBuyingPricectn` double NOT NULL,
  `ItemSellingPricectn` double NOT NULL,
  `intersate` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Tax` double NOT NULL,
  `account` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mfg` date NOT NULL,
  `exp` date NOT NULL,
  `mrp` double NOT NULL,
  `itemDiscount` double NOT NULL,
  `Ref` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Notes` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `free` double NOT NULL,
  `moredetails` json NOT NULL,
  `Mode` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table inventory
-- 



-- 
-- Definition of lpo
-- 

CREATE TABLE IF NOT EXISTS `lpo` (
  `account` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Additional` double NOT NULL,
  `Alias` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `BillNo` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InvNo` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Cess` double NOT NULL,
  `Date` date NOT NULL,
  `DDate` date NOT NULL,
  `Discount` double NOT NULL,
  `exp` date NOT NULL,
  `intersate` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InvId` int NOT NULL,
  `ItemBuyingPrice` double NOT NULL,
  `ItemBuyingPricectn` double NOT NULL,
  `Itemname` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ItemSellingPrice` double NOT NULL,
  `ItemSellingPricectn` double NOT NULL,
  `mfg` date NOT NULL,
  `Qty` double NOT NULL,
  `SDate` date NOT NULL,
  `slno` int NOT NULL AUTO_INCREMENT,
  `Supplier` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Tax` double NOT NULL,
  `TotalPrice` double NOT NULL,
  `Tx` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `uid` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `moredetails` json DEFAULT NULL,
  `SupplierId` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mrp` double NOT NULL,
  `itemDiscount` double NOT NULL,
  `free` double NOT NULL,
  `Notes` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`slno`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table lpo
-- 



-- 
-- Definition of invoiceno
-- 

CREATE TABLE IF NOT EXISTS `invoiceno` (
  `invoiceno` int NOT NULL,
  `invoicenoA` int NOT NULL,
  `invoicenoA1` int NOT NULL,
  `invoicenoB` int NOT NULL,
  `invoicenoC` int NOT NULL,
  `invoicenoD` int NOT NULL,
  `invoicenoEstimate` int NOT NULL,
  `ReturnNo` int NOT NULL,
  `AccNo` int NOT NULL,
  `Od` int NOT NULL,
  `invoicenoOrder` int NOT NULL,
  `interbranch` int NOT NULL,
  `intrabranch` int NOT NULL,
  `purchase` int NOT NULL DEFAULT '10000',
  `debitnote` int NOT NULL DEFAULT '100000',
  `stockadjust` int NOT NULL DEFAULT '100000',
  `damage` int NOT NULL DEFAULT '100000',
  `lpo` int NOT NULL DEFAULT '100000',
  `goodsreceipt` int NOT NULL DEFAULT '100000',
  PRIMARY KEY (`invoiceno`),
  UNIQUE KEY `invoiceno_UNIQUE` (`invoiceno`),
  UNIQUE KEY `invoicenocol_UNIQUE` (`invoicenoA`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table invoiceno
-- 

INSERT INTO `invoiceno`(`invoiceno`,`invoicenoA`,`invoicenoA1`,`invoicenoB`,`invoicenoC`,`invoicenoD`,`invoicenoEstimate`,`ReturnNo`,`AccNo`,`Od`,`invoicenoOrder`,`interbranch`,`intrabranch`,`purchase`,`debitnote`,`stockadjust`,`damage`,`lpo`,`goodsreceipt`) VALUES
(0,0,0,0,0,0,0,0,1,0,100000,0,0,10000,100000,100000,100000,100000,100000);

-- 
-- Definition of agentac
-- 

CREATE TABLE IF NOT EXISTS `agentac` (
  `Agent` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `commi` double NOT NULL,
  `commiAmd` double NOT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `InvoiceNo` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ItemCode` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ItemName` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `new_tablecol` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `payment` double NOT NULL,
  `qty` double NOT NULL,
  `TotalAmount` double NOT NULL,
  `Date` date NOT NULL,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table agentac
-- 



-- 
-- Definition of estimate
-- 

CREATE TABLE IF NOT EXISTS `estimate` (
  `advpayment` double NOT NULL,
  `agent` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `AgentId` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Alias` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Biller` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `BillStatus` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Bundle` double NOT NULL,
  `card` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cardpayment` double NOT NULL,
  `cashback` double NOT NULL,
  `Cashier` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ccc` varchar(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cess` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `CGST` double NOT NULL,
  `code` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Cosid` varchar(7) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `CosName` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cusgst` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cusother` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cusProfit` double NOT NULL,
  `cusstate` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Date` date NOT NULL,
  `datep` date NOT NULL,
  `Disc` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `GTotal` double NOT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `IGST` double NOT NULL,
  `InvoiceNo` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InvoiceNo1` int NOT NULL,
  `invoicetype` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `invvid` int NOT NULL,
  `Item` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ItemID` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mrp` double NOT NULL,
  `Oldcredit` double NOT NULL,
  `payment` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `placep` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Price` double NOT NULL,
  `Qty` double NOT NULL,
  `Qtyin` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `refinvoice` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `RetunAmt` double NOT NULL,
  `SGST` double NOT NULL,
  `slno` int NOT NULL,
  `TaxAmd` double NOT NULL,
  `Time` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Total` double NOT NULL,
  `Tx` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Vat` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Wholesale` double NOT NULL,
  `moredetails` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table estimate
-- 



-- 
-- Definition of orders
-- 

CREATE TABLE IF NOT EXISTS `orders` (
  `slno` int NOT NULL,
  `ItemID` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Item` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Qty` double NOT NULL,
  `Price` double NOT NULL,
  `Disc` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `GTotal` double NOT NULL,
  `Date` date NOT NULL,
  `InvoiceNo` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `CosName` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Cosid` varchar(7) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Wholesale` double NOT NULL,
  `Total` double NOT NULL,
  `invoicetype` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `RetunAmt` double NOT NULL,
  `Biller` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `BillStatus` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Cashier` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `invvid` int NOT NULL,
  `Time` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Vat` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Bundle` double NOT NULL,
  `Qtyin` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Tx` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `AgentId` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `InvoiceNo1` int NOT NULL,
  `payment` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `TaxAmd` double NOT NULL,
  `cashback` double NOT NULL,
  `ccc` varchar(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `code` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cusProfit` double NOT NULL,
  `card` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cardpayment` double NOT NULL,
  `cusother` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mrp` double NOT NULL,
  `CGST` double NOT NULL,
  `cusstate` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `datep` date NOT NULL,
  `IGST` double NOT NULL,
  `placep` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `SGST` double NOT NULL,
  `cusgst` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Alias` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `agent` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `refinvoice` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `advpayment` double NOT NULL,
  `Oldcredit` double NOT NULL,
  `cess` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `moredetails` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `index2` (`InvoiceNo1`,`InvoiceNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table orders
-- 



-- 
-- Definition of sales_items
-- 

CREATE TABLE IF NOT EXISTS `sales_items` (
  `slno` int NOT NULL,
  `ItemID` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Item` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Qty` double NOT NULL,
  `Price` double NOT NULL,
  `Disc` double NOT NULL,
  `GTotal` double NOT NULL,
  `Date` date NOT NULL,
  `InvoiceNo` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `CosName` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Cosid` varchar(7) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Wholesale` double NOT NULL,
  `Total` double NOT NULL,
  `invoicetype` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `RetunAmt` double NOT NULL,
  `Biller` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `BillStatus` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Cashier` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `invvid` int NOT NULL,
  `Time` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Vat` double NOT NULL,
  `Bundle` double NOT NULL,
  `Qtyin` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Tx` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `AgentId` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `InvoiceNo1` int NOT NULL,
  `payment` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `TaxAmd` double NOT NULL,
  `cashback` double NOT NULL,
  `ccc` varchar(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `code` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cusProfit` double NOT NULL,
  `card` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cardpayment` double NOT NULL,
  `cusother` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mrp` double NOT NULL,
  `CGST` double NOT NULL,
  `cusstate` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `IGST` double NOT NULL,
  `SGST` double NOT NULL,
  `cusgst` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Alias` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `agent` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `refinvoice` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `advpayment` double NOT NULL,
  `Oldcredit` double NOT NULL,
  `cess` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `moredetails` json NOT NULL,
  `Ref` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `index2` (`InvoiceNo1`,`InvoiceNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table sales_items
-- 



-- 
-- Definition of sales_items_temp
-- 

CREATE TABLE IF NOT EXISTS `sales_items_temp` (
  `slno` int NOT NULL,
  `ItemID` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Item` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Qty` double NOT NULL,
  `Price` double NOT NULL,
  `Disc` double NOT NULL,
  `GTotal` double NOT NULL,
  `Date` date NOT NULL,
  `InvoiceNo` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `CosName` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Cosid` varchar(7) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Wholesale` double NOT NULL,
  `Total` double NOT NULL,
  `invoicetype` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `RetunAmt` double NOT NULL,
  `Biller` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `BillStatus` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Cashier` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `invvid` int NOT NULL,
  `Time` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Vat` double NOT NULL,
  `Bundle` double NOT NULL,
  `Qtyin` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Tx` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `AgentId` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `InvoiceNo1` int NOT NULL,
  `payment` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `TaxAmd` double NOT NULL,
  `cashback` double NOT NULL,
  `ccc` varchar(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `code` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cusProfit` double NOT NULL,
  `card` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cardpayment` double NOT NULL,
  `cusother` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mrp` double NOT NULL,
  `CGST` double NOT NULL,
  `cusstate` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `IGST` double NOT NULL,
  `SGST` double NOT NULL,
  `cusgst` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Alias` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `agent` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `refinvoice` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `advpayment` double NOT NULL,
  `Oldcredit` double NOT NULL,
  `cess` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `moredetails` json NOT NULL,
  `Ref` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  KEY `index2` (`InvoiceNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table sales_items_temp
-- 



-- 
-- Definition of stock
-- 

CREATE TABLE IF NOT EXISTS `stock` (
  `uid` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Name` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Brand` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `company` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Category` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `BuyingPrice` varchar(22) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `SellingPrice` varchar(22) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `BuyingPriceCtn` varchar(22) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `SellingPriceCtn` varchar(22) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `MRP` varchar(22) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `VAT` varchar(22) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Supplier` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `iQty` double NOT NULL,
  `sQty` double NOT NULL,
  `Stock` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table stock
-- 



-- 
-- Definition of reorderlevel
-- 

CREATE TABLE IF NOT EXISTS `reorderlevel` (
  `uid` int NOT NULL DEFAULT '0',
  `Name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `stock` double DEFAULT NULL,
  `ReorderLevel` double NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table reorderlevel
-- 



-- 
-- Definition of items
-- 

CREATE TABLE IF NOT EXISTS `items` (
  `UID` int NOT NULL AUTO_INCREMENT,
  `Name` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Quantityin` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Category` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `BuyingPrice` double NOT NULL,
  `SellingPrice` double NOT NULL,
  `bundle` double NOT NULL,
  `NameAli` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `expdate` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `VAT` double NOT NULL,
  `Disc` double NOT NULL,
  `Supplier` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Qty` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ReorderLevel` double NOT NULL DEFAULT '0',
  `Location` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Description` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `code` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `MRP` double NOT NULL,
  `i` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `size` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `company` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Brand` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `UidLis` int NOT NULL,
  `CodeAdv` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `SellingPrice1` double NOT NULL,
  `SellingPrice2` double NOT NULL,
  `BuyingPriceCtn` double NOT NULL,
  `SellingPriceCtn` double NOT NULL,
  `Commission` double NOT NULL,
  `dpr` double NOT NULL,
  `dqty` double NOT NULL,
  `dsr` double NOT NULL,
  `ispromotion` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `maxstock` double NOT NULL,
  `mfgdate` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `plocation` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `point` double NOT NULL,
  `cost` double NOT NULL,
  `dated` date NOT NULL,
  `main` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `porc` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sub` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `verify` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `last_updated` varchar(11) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1577836800',
  `v` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `w` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `plu` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `MaxDisc` double NOT NULL,
  `wooid` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `parentid` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `veriation` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `wooid1` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `moredetails` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `isSale` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `SellingPriceWtax` double NOT NULL,
  PRIMARY KEY (`UID`),
  KEY `Name` (`Name`) /*!80000 INVISIBLE */,
  KEY `uid` (`UID`),
  KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table items
-- 



-- 
-- Definition of syc
-- 

CREATE TABLE IF NOT EXISTS `syc` (
  `idsyc` int NOT NULL AUTO_INCREMENT,
  `sycsql` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sycsys` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `syctime` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sycuser` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`idsyc`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table syc
-- 

INSERT INTO `syc`(`idsyc`,`sycsql`,`sycsys`,`syctime`,`sycuser`) VALUES
(1,'TRUNCATE `syc`;','','2025-06-26 11:57:53','1');

-- 
-- Definition of sycdown
-- 

CREATE TABLE IF NOT EXISTS `sycdown` (
  `id` int NOT NULL AUTO_INCREMENT,
  `query` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `system_id` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `time` datetime NOT NULL,
  `user` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ltime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table sycdown
-- 



-- 
-- Definition of update
-- 

CREATE TABLE IF NOT EXISTS `update` (
  `id` int NOT NULL AUTO_INCREMENT,
  `Date` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `version` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `min_build` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table update
-- 

INSERT INTO `update`(`id`,`Date`,`version`,`min_build`) VALUES
(1,'26-06-2025','5.2.0.51',1);

-- 
-- Definition of userlog
-- 

CREATE TABLE IF NOT EXISTS `userlog` (
  `id` int NOT NULL AUTO_INCREMENT,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Userid` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `userlog` varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `moredetails` json NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table userlog
-- 



-- 
-- Dumping triggers
-- 

DROP TRIGGER /*!50030 IF EXISTS */ `sales_items_AFTER_INSERT`;
DELIMITER |
CREATE TRIGGER `sales_items_AFTER_INSERT` AFTER INSERT ON `sales_items` FOR EACH ROW BEGIN
UPDATE stock SET sQty = sQty + NEW.Qty where uid = NEW.ItemID;
END |
DELIMITER ;

DROP TRIGGER /*!50030 IF EXISTS */ `sales_items_AFTER_DELETE`;
DELIMITER |
CREATE TRIGGER `sales_items_AFTER_DELETE` AFTER DELETE ON `sales_items` FOR EACH ROW BEGIN
UPDATE stock SET sQty = sQty - OLD.Qty where uid = OLD.ItemID;
END |
DELIMITER ;




-- Total time: 0:0:0:0:606 (d:h:m:s:ms)
