-- Company Backup: Computer Services and Networks
-- Code: CSNBKS-COMP-0001
-- Generated: 2026-04-19 21:10:49
-- By: System


-- Table: clients
;

INSERT INTO `clients` VALUES ('1','Demo-001','DEMO','123 demo','Bakersfield','Ca.','93311','661112233','csnbks@gmail.com','0',NULL,'0.00','','Active');

-- Table: company
;

INSERT INTO `company` VALUES ('Computer Services and Networks','10605 Quiet Breeze Lane','Bakersfield','Ca.','','','csnbks@gmail.com','company_logo.jpg','verde-profesional','mediana');

-- Table: email_config
;

INSERT INTO `email_config` VALUES ('1','smtp.gmail.com','587','csnbks@gmail.com','lkzwruoiyahestsw','csnbks@gmail.com','Computer Services','2026-04-19 14:53:06','Admin');

-- Table: email_tracking
;

INSERT INTO `email_tracking` VALUES ('1','61bc2dc500e9b9f10fcc4f68b575b2d954e418fb4ee9f12f1a216175528e0099','estimate','2026-04-19','2026-04-19','Computer Services and Networks','csnbks@gmail.com','DEMO','csnbks@gmail.com','Estimate EST-00001 — Computer Services and Networks','2026-04-19 14:53:54','2026-04-19 14:53:54',NULL,NULL,'0',NULL,NULL,'Received','1');
INSERT INTO `email_tracking` VALUES ('2','3dddf2447d3a1a4a1f5c504f73cf14e839176353d2cea6280b880b7a40d43679','invoice','2026-04-19','2026-04-19','Computer Services and Networks','csnbks@gmail.com','DEMO','csnbks@gmail.com','Invoice INV-0001 — Computer Services and Networks','2026-04-19 14:59:59','2026-04-19 14:59:59',NULL,NULL,'0',NULL,NULL,'Received','1');
INSERT INTO `email_tracking` VALUES ('3','aea08527484993c54ad548cb74111b49c7ad0b09481180ec6db3b5964a6f7b8b','report_estimates','2026-02-01','2026-04-30','Computer Services and Networks','csnbks@gmail.com','DEMO','csnbks@gmail.com','Estimates Report — 02/01/2026 to 04/30/2026','2026-04-19 15:00:38','2026-04-19 15:00:38',NULL,NULL,'0',NULL,NULL,'Received','1');
INSERT INTO `email_tracking` VALUES ('4','c0eaa71f951299a376e1c488ffcc182760241b2eec45268c419b8ca3d91a8c09','report_invoices','2026-03-01','2026-04-30','Computer Services and Networks','csnbks@gmail.com','DEMO','csnbks@gmail.com','Invoices Report — 03/01/2026 to 04/30/2026','2026-04-19 15:01:03','2026-04-19 15:01:03',NULL,NULL,'0',NULL,NULL,'Received','1');
INSERT INTO `email_tracking` VALUES ('5','2758cb896d1708ff1596e6df0bb6686dd171f2a09d8e9613d0b8699346e33b39','report_invoices','2026-02-01','2026-04-30','Computer Services and Networks','csnbks@gmail.com','DEMO','csnbks@gmail.com','Invoices Report — 02/01/2026 to 04/30/2026','2026-04-19 23:44:51','2026-04-19 23:44:51',NULL,NULL,'0',NULL,NULL,'Received','1');
INSERT INTO `email_tracking` VALUES ('6','2aca6aa2e223306d9a07f3fbe43180bd4714e4c67cc651a9c7d68091b3331410','report_estimates','2026-03-01','2026-04-30','Computer Services and Networks','csnbks@gmail.com','DEMO','csnbks@gmail.com','Estimates Report — 03/01/2026 to 04/30/2026','2026-04-19 23:52:46','2026-04-19 23:52:46',NULL,NULL,'0',NULL,NULL,'Received','1');

-- Table: employee_pays
;

-- Table: employees
;

INSERT INTO `employees` VALUES ('1','Demo-001','DEMO','123 demo','Bakersfield','Ca.','93311','661112233','csnbks@gmail.com','','2026-04-19','Worker','Active','16.50','0.00',NULL,NULL);

-- Table: estimates
;

INSERT INTO `estimates` VALUES ('1','EST-00001','Demo-001','2026-04-19','Yes','10.00','123 demo','Bakersfield','Ca.','93311','661112233','Test','No Notes','0.00','480.00','48.00','528.00','Converted');

-- Table: estimates_movs
;

INSERT INTO `estimates_movs` VALUES ('29','EST-00001','1.00','List','DEMO','100.00','240.00','240.00');
INSERT INTO `estimates_movs` VALUES ('30','EST-00001','1.00','New','Fees','150.00','240.00','240.00');

-- Table: expenses
;

INSERT INTO `expenses` VALUES ('1','2026-04-18','Food','Dewaards Ice cream','1.00','14.75','14.75','1.22','15.97','Credit Card','','','Strawberry Special','Active',NULL);

-- Table: expenses_concepts
;

INSERT INTO `expenses_concepts` VALUES ('1','Offi-001','Office Supplies','Active');
INSERT INTO `expenses_concepts` VALUES ('2','Offi-002','Office Rent','Active');
INSERT INTO `expenses_concepts` VALUES ('3','Offi-003','Office Phone Service','Active');
INSERT INTO `expenses_concepts` VALUES ('4','Offi-004','Office Rent/Lease','Active');
INSERT INTO `expenses_concepts` VALUES ('5','Offi-005','Office Power Energy','Active');
INSERT INTO `expenses_concepts` VALUES ('6','Offi-006','Office Water Service','Active');
INSERT INTO `expenses_concepts` VALUES ('7','Offi-007','Office Gas Service','Active');
INSERT INTO `expenses_concepts` VALUES ('8','Food-008','Food','Active');
INSERT INTO `expenses_concepts` VALUES ('9','Gaso-009','Gasoline Utility Cars','Active');
INSERT INTO `expenses_concepts` VALUES ('10','Cust-010','Customers Food','Active');

-- Table: invoice_payments
;

-- Table: invoice_photos
;

-- Table: invoices
;

INSERT INTO `invoices` VALUES ('1','INV-0001','Demo-001','2026-04-19','Yes','10.00','123 demo','Bakersfield','Ca.','93311','661112233','','Test','No Notes','','0.00','0.00','480.00','48.00','528.00','Active');

-- Table: invoices_movs
;

INSERT INTO `invoices_movs` VALUES ('INV-0001','1.00','List','DEMO','240.00','240.00','7');
INSERT INTO `invoices_movs` VALUES ('INV-0001','1.00','New','Fees','240.00','240.00','8');

-- Table: products
;

INSERT INTO `products` VALUES ('1','Demo-00001','DEMO','100.00','','','','','','0.00','0.00','0.00','0.00','0.00','','','','','','240.00','Active','No');

-- Table: system_settings
;

INSERT INTO `system_settings` VALUES ('1','font_size','13px','2026-04-18 23:37:09','Administrador');
INSERT INTO `system_settings` VALUES ('2','theme_key','ocean','2026-04-19 03:18:41','Administrador');
INSERT INTO `system_settings` VALUES ('3','theme_name','Ocean Blue','2026-04-19 03:18:41','Administrador');
INSERT INTO `system_settings` VALUES ('4','theme_main','#174474','2026-04-19 03:18:41','Administrador');
INSERT INTO `system_settings` VALUES ('5','theme_mid','#1e5496','2026-04-19 03:18:41','Administrador');
INSERT INTO `system_settings` VALUES ('6','theme_hover','#0f2d5c','2026-04-19 03:18:41','Administrador');
INSERT INTO `system_settings` VALUES ('7','theme_sh','#0a1e3d','2026-04-19 03:18:41','Administrador');
INSERT INTO `system_settings` VALUES ('8','theme_acc','#0f6af3','2026-04-19 03:18:41','Administrador');

-- Table: users
;

INSERT INTO `users` VALUES ('1','Syst-001','System','','Bakersfield','Ca.','','','admin@empresa.com','Active','System','$argon2id$v=19$m=65536,t=4,p=1$ejZOUnEzRkxpVmZCN1V5aw$R8BSJwrv0wydj5bfRJtXigif0kaNeKOA6XntAJwh1JE');
INSERT INTO `users` VALUES ('2','Demo-002','DEMO','123 demo','Bakersfield','CA.','93311','661112233','demo@gmail.com','Active','Administrator','$argon2id$v=19$m=65536,t=4,p=1$ZERXb2Q4L01QLnh6b05rVQ$cCkrb5MwdFanBC1FfoCE/29T2+HJTewelhM4r0KgKUE');

-- Table: vendors
;

INSERT INTO `vendors` VALUES ('1','DEMO-001','DEMO','123 demo','Bakersfield','Ca.','93311','661112233','','csnbks@gmail.com','Active');

