-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jun 10, 2024 at 06:31 AM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.0.28

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `getmyaiodb`
--

-- --------------------------------------------------------

--
-- Table structure for table `business_information`
--

CREATE TABLE `business_information` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `bname` varchar(255) NOT NULL,
  `bemail` varchar(255) NOT NULL,
  `bphone` varchar(255) NOT NULL,
  `website_url` varchar(255) DEFAULT NULL,
  `baddress` varchar(255) DEFAULT NULL,
  `working_hours` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `radius_address` varchar(255) NOT NULL,
  `radius` varchar(255) NOT NULL,
  `radius_image` varchar(1000) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `pid` bigint(20) UNSIGNED DEFAULT NULL,
  `services` varchar(255) DEFAULT NULL,
  `closerid` bigint(20) UNSIGNED DEFAULT NULL,
  `category` varchar(255) DEFAULT NULL,
  `timezone` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `business_information`
--

INSERT INTO `business_information` (`id`, `client_id`, `bname`, `bemail`, `bphone`, `website_url`, `baddress`, `working_hours`, `description`, `radius_address`, `radius`, `radius_image`, `created_at`, `updated_at`, `pid`, `services`, `closerid`, `category`, `timezone`) VALUES
(154, 95, 'AAA Leak Finders Inc', 'info@aaaleakfinders.com', '(386) 446-0000', 'http://www.aaaleakfinders.com/', 'Palm Coast, FL 32137, USA', NULL, 'aaa leak finders description', 'AAA Leak Finders Inc, Palm Coast, FL, USA', '12', 'https://maps.googleapis.com/maps/api/staticmap?center=29.58443170901557,-81.20786075000002&zoom=9.5&size=900x800&maptype=roadmap&markers=color:red%7C29.58443170901557,-81.20786075000002&path=color:red%7Cfillcolor:red%7Cweight:2%7Cenc:_bstDb|snNdAmmAlEamArIolAzMqkA`RkjAbVwhA`Z_gA~]{dAta@obAje@y_Axh@}|@`l@wy@fo@kv@br@yr@|t@}n@jw@_k@ty@yf@t{@ob@p}@_^b_AmYl`AwTnaA}OhbAcKxbAgFbcAiA`cApAxbApFfbAjKlaAdPj`A|T`_AtYn}@d^r{@rb@py@|f@hw@`k@vt@`o@~q@xr@bo@jv@~k@vy@th@z|@fe@t_Ara@jbAz]tdA~YxfA~UrhA~Q`jAxMhkAtIflAjEzlAbAbmAcAdmAkExlAuIflAyMhkA_RbjA_VphA_ZxfA{]tdAsa@jbAge@v_Auh@x|@_l@vy@co@jv@_r@xr@wt@`o@iw@`k@qy@|f@s{@rb@o}@f^a_ArYk`A|TmaAfPgbAjKybAnFacApAccAiAybAgFibAcKoaA}Om`AwTc_AmYq}@_^u{@ob@uy@yf@kw@}j@}t@_o@cr@wr@go@mv@al@wy@yh@}|@ke@y_Aua@obA_^{dAaZ}fAcVyhAaRijA{MqkAsIolAmEcmA&key=AIzaSyDtMhPtoqeZSt-5Qyh6E4FcO0Q_jqH2oLw&libraries=geometry&callback=initMap', '2024-02-13 18:05:40', '2024-02-13 18:05:52', 1, 'AIO', 98, 'General Contractor', 'Eastern Standard Time'),
(155, 96, 'SoCal Healthy Water', 'socalhealthywater@gmail.com', '(866) 888-4318', 'http://www.socalhealthywater.com/', '254 N Lake Ave, Pasadena, CA 91101, USA', NULL, NULL, 'SoCal Healthy Water, North Lake Avenue, Pasadena, CA, USA', '34', 'https://maps.googleapis.com/maps/api/staticmap?center=34.15038821077215,-118.13212465000001&zoom=9.5&size=900x800&maptype=roadmap&markers=color:red%7C34.15038821077215,-118.13212465000001&path=color:red%7Cfillcolor:red%7Cweight:2%7Cenc:__mrEvt_pU`EmiFfQohFj]sfFji@{cFbu@a`Fv`Ao{E`lA}uE`wAsoEvaBkhE~kBk`ExuBqwDd_CcnD`hC{cDhpCayC`xCqmCb_DqaCreDauBjkDahBppDuzA|tD}lArxD}~@p{Dsp@x}Deb@d_EsS|_E}Dz_EtG~~DfVl}Dvd@b{Dbs@~wDdaAftD~nAtoDp|AnjDtiBrdDhvBb~CpbC|vChnCfoCjyCzfCzcD`~BvmDvtB|vD~jBj_Ev`B`gEbvA~mEfkAbtE``AjyEnt@x}Ezh@jaF~\\`dF`QxeF`EvfFaEvfFaQzeF_]`dF{h@jaFot@x}Ea`AjyEgkAbtEcvA~mEw`B`gE_kBj_EwtB|vDa~BvmD{fCzcDgoCjyC}vChnCc~CpbCsdDhvBojDtiBuoDn|AgtD`oA_xDdaAc{Dbs@m}Dvd@__EfV{_EtG}_E}De_EsSy}Deb@q{Dsp@sxD}~@}tD}lAqpDuzAkkDahBseDauBc_DqaCaxCqmCipCayCahC{cDe_CcnDyuBqwD_lBk`EwaBkhEawAsoEalA}uEw`Ao{Ecu@a`Fki@{cFk]sfFgQohF&key=AIzaSyDtMhPtoqeZSt-5Qyh6E4FcO0Q_jqH2oLw&libraries=geometry&callback=initMap', '2024-02-14 10:19:19', '2024-02-14 10:19:29', 2, 'AIO', 98, 'Store', 'Pacific Standard Time'),
(156, 97, 'Beauty Theory Miami', 'beauty@gmail.com', '(786) 860-8430', 'http://beautytheorymiami.com/', '11735 SW 147th Ave #29, Miami, FL 33196, USA', NULL, NULL, 'Beauty Theory Miami, Southwest 147th Avenue, Miami, FL, USA', '45', 'https://maps.googleapis.com/maps/api/staticmap?center=25.658099107628388,-80.4305886&zoom=9.5&size=900x800&maptype=roadmap&markers=color:red%7C25.658099107628388,-80.4305886&path=color:red%7Cfillcolor:red%7Cweight:2%7Cenc:clq_Ddb|iN`Gy{GdWszGbg@kxG`w@_uGrfAmpG~uAyjG|dBcdGpsBm|FraCssFdoC}iFf|Ci_FrhDwsEhtDkgEh_EezDniEilD|rEu}Cl{EonCdcFu~BziFonBxoFw}ArtFwlApxFm{@n{Fyi@l}FeXj~FiFf~FlIb}Fd[`{Fvl@~wFf~@zsFhoA|nFd`BzhFppB`bFp`CfzE|oCpqEz~CdhE`mD|}DpzDzrDjgEfgDjsEzzCn~E|mCxhFl`CdrFlrBpzF|cB~aG`uAlhGzeAzmGlv@drGvf@juG|VrwG|FvxG}FtxG}VrwGwf@luGmv@drG{eAxmGauAlhG}cB`bGmrBpzFm`CdrF}mCxhF{zCn~EggDjsE{rDjgE}}DpzDehE`mDqqEx~CgzE~oCabFp`C{hFppB}nFd`B{sFhoA_xFd~@a{Fxl@c}Fd[g~FlIk~FkFm}FcXo{F{i@qxFk{@stFwlAyoFy}A{iFmnBecFw~Bm{EonC}rEu}CoiEglDi_EezDitDkgEshDwsEg|Ci_FeoC}iFsaCssFqsBm|F}dBcdG_vAyjGsfAmpGaw@_uGcg@kxGeWszG&key=AIzaSyDtMhPtoqeZSt-5Qyh6E4FcO0Q_jqH2oLw&libraries=geometry&callback=initMap', '2024-02-14 10:26:37', '2024-02-14 10:28:29', 2, 'AIO', 506, 'Beauty Salon', 'Eastern Standard Time'),
(158, 98, 'A&S Locksmith LLC', 'ans@gmail.com', '(239) 919-6189', 'https://aandslocksmith.com/', '29th St. NW, Naples, FL 34120, USA', NULL, NULL, 'A&S Locksmith LLC, 29th St. NW, Naples, FL, USA', '34', 'https://maps.googleapis.com/maps/api/staticmap?center=26.228604407823923,-81.68744715&zoom=9.5&size=900x800&maptype=roadmap&markers=color:red%7C26.228604407823923,-81.68744715&path=color:red%7Cfillcolor:red%7Cweight:2%7Cenc:{wabDpqqqN`E_wEfQavEh]ktEhi@yqE`u@knEr`AcjE|kAaeE|vAg_EraBsxDzkBgqDtuBgiD~~Bo`DzgCcwCdpCcmCzwCsbC~~CswBneDalBfkDc`BlpDysAztDegAnxDgz@p{Dcm@t}Dw_@f_EkRz_EyDz_ErF`_EbTn}Dpa@d{Dvn@bxDv{@htDphAxoD`uArjDfaBvdD|lBf~CfxBbwC`cChoCjmC`gCbwCf~Bh`DztBvhDbkBrpDz`BvwDhvAb~DhkAzcEb`AthErt@zlE|h@bpE`]trEbQftE~DduE_EbuEcQhtEa]rrE}h@dpEst@xlEc`AvhEikAxcEivAd~D{`BvwDckBppD{tBxhDg~Bf`DagCbwCioCjmCcwCbcCg~CfxBwdD|lBsjDdaByoD`uAitDphAcxDx{@e{Dvn@o}Dna@a_EbT{_EtF{_E{Dg_EiRu}Dy_@q{Dcm@oxDgz@{tDcgAmpDysAgkDe`BoeDalB__DqwB{wCsbCepCemC{gCcwC__Co`DuuBeiD{kBiqDsaBsxD}vAe_E}kAceEs`AcjEau@knEii@yqEi]ktEgQavE&key=AIzaSyDtMhPtoqeZSt-5Qyh6E4FcO0Q_jqH2oLw&libraries=geometry&callback=initMap', '2024-02-14 13:30:55', '2024-02-14 13:30:58', 2, 'AIO', 8888, 'Locksmith', 'Eastern Standard Time'),
(159, 99, 'ALLways Towing Inc.', 'allwaystowing@gmail.com', '(402) 435-2121', 'http://www.allwaystowinglincoln.com/', '5657 N 57th St, Lincoln, NE 68507, USA', NULL, 'testing description', 'ALLways Towing Inc., North 57th Street, Lincoln, NE, USA', '56', 'https://maps.googleapis.com/maps/api/staticmap?center=40.86914511374101,-96.64232464999999&zoom=9.5&size=900x800&maptype=roadmap&markers=color:red%7C40.86914511374101,-96.64232464999999&path=color:red%7Cfillcolor:red%7Cweight:2%7Cenc:akk}FnmzlQ`IihLh]sfLhq@ecLdeA}}KvxAawK|kBonKt~BidKzpCqxJpbDikJnsDq|ItcEklIdsE}zHvaFchHjoFitG~{Fg_GvgGiiFhrGmrEv{GwzDbdHibDhkHkiCfqH{oB~uH_vApyH{{@x{Hma@v|HcGp|HjQ`{Hpk@jxHreAhtHf_BdoHpxBzhHhqCfaHjiDtxGv`EznGjwEbdG`mFfxFzaGpkFpuGx}EdhHhoEryH|_ExiIzoDvxIb_DjfJxmCprJx{Bf}JliBrfKtvAjnKncArtKdp@jyKp\\p|KxH`~KyHb~Kq\\p|Kep@jyKocArtKuvAjnKmiBrfKy{Bf}JymCprJc_DhfJ{oDxxI}_ExiIioEryHy}EdhHqkFpuGgxFzaGcdG`mF{nGjwEuxGv`EgaHjiD{hHhqCeoHpxBitHf_BkxHreAa{Hpk@q|HhQw|HaGy{Hoa@qyHy{@_vH_vAgqH{oBikHkiCcdHibDw{GwzDirGmrEwgGiiF_|Fg_GkoFitGwaFchHesE}zHucEklIosDq|IqbDikJ{pCqxJu~BidK}kBonKwxAawKeeA}}Kiq@ecLi]sfL&key=AIzaSyDtMhPtoqeZSt-5Qyh6E4FcO0Q_jqH2oLw&libraries=geometry&callback=initMap', '2024-02-16 14:19:54', '2024-02-16 14:54:00', 3, 'AIO', 98, 'Point Of Interest', 'Central Standard Time'),
(160, 100, 'Best Garage Door Repair and Service', 'steveemerson@gmail.com', '(949) 939-2469', 'http://bestgaragedoorrepairandservice.com/', '15795 Rockfield Blvd suite d, Irvine, CA 92618, USA', NULL, 'Family Owned & Operated Business.', 'Best Garage Door Repair and Service, Rockfield Boulevard, Irvine, CA, USA', '100', 'https://maps.googleapis.com/maps/api/staticmap?center=33.63303186056405,-117.71884949999999&zoom=9.5&size=900x800&maptype=roadmap&markers=color:red%7C33.63303186056405,-117.71884949999999&path=color:red%7Cfillcolor:red%7Cweight:2%7Cenc:aibuEx}nmUdQetThu@iqThyAokTz|B_cT~_DqwSlbEmiS|cFuxRtdGgeRddHioQpbIawPp_Jm|Od{Js_OduK}`NpmLe`MbdMu}KzxMwyJvkNgtIp|NomHhkOseG`xO{|EnbPksDzjPeiC~pPs~AztP{s@nvP}H|uPv_@`sPhjA`nPjtBxfP|}Cl}OrfE|qOnnFjdOhuGztN|zHjcNh_J`pMbbK|zLlcL`dL`cMtkK|`NtqJx|NjvIvvOvyHrnPx{GhdQ||FxwQ`}E~hRh|DxwRzzCfdSzxBfnSjvAxuSps@xzSnPh}SoPh}Sqs@xzSkvAxuS{xBfnS{zCfdSi|DxwRa}E~hR}|FxwQy{GhdQwyHrnPkvIvvOuqJx|NukKz`NadLbcM}zLlcLapMbbKkcNf_J{tN~zHkdOhuG}qOnnFm}OrfEyfPz}CanPltBasPhjA}uPv_@ovP}H{tP{s@_qPs~A{jPeiCobPksDaxO{|EikOseGq|NomHwkNgtI{xMwyJcdMw}KqmLe`MeuK{`Ne{Js_Oq_Jo|OqbI_wPedHkoQudGgeR}cFsxRmbEmiS_`DqwS{|B_cTiyAqkTiu@gqT&key=AIzaSyDtMhPtoqeZSt-5Qyh6E4FcO0Q_jqH2oLw&libraries=geometry&callback=initMap', '2024-02-19 14:48:44', '2024-02-19 14:50:19', 4, 'AIO', 8888, 'Point Of Interest', 'Pacific Standard Time'),
(161, 101, 'Rankyoup', 'rankyoup@gmail.com', '(630) 439-7826', 'https://rankyoup.com/', '6406 N Western Ave, Chicago, IL 60645, USA', NULL, 'testing description', 'Rankyoup, North Western Avenue, Chicago, IL, USA', '23', 'https://maps.googleapis.com/maps/api/staticmap?center=41.99794571429767,-87.69003465&zoom=9.5&size=900x800&maptype=roadmap&markers=color:red%7C41.99794571429767,-87.69003465&path=color:red%7Cfillcolor:red%7Cweight:2%7Cenc:ktjaGt}evObCooDjKwnDnSmmDt[gkDpc@ohDlk@_eDbs@y`Dpz@c|CvaAsvCthAspCjoAajCruA{bCt{Ae{BfaBasBnfBmjBhkBmaBtoB}wApsBenA`wBedA`zBwy@p|Bgo@p~Bod@``CsY~`CsNnaCqCnaClEz`ClPz_Ch[f~Bdf@d|Bvp@ryBd{@pvBleA`sBfoA`oBzxArjB`bBzeB|jBp`BfsB~zAf{B~tArbCtnApiC`hA~oCdaAvuC|y@~zCrr@p_D~j@rcDfc@zfDh[riDjStkDdK~lD`CrmDaCtmDeK~lDkStkDi[piDgc@|fD_k@rcDsr@p_D}y@~zCeaAvuCahA~oCunApiC_uArbC_{Af{Bq`BfsB{eB|jBsjB`bBaoBzxAasBfoAqvBleAsyBd{@e|Bvp@g~Bdf@{_Ch[{`ClPoaClEoaCqC_aCsNa`CsYq~Bod@q|Bgo@azBwy@awBedAqsBenAuoB_xAikBkaBofBmjBgaBasBu{Ae{BsuA{bCkoAajCuhAspCwaAuvCqz@a|Ccs@y`Dmk@_eDqc@ohDu[gkDoSmmDkKwnD&key=AIzaSyDtMhPtoqeZSt-5Qyh6E4FcO0Q_jqH2oLw&libraries=geometry&callback=initMap', '2024-04-22 00:51:51', '2024-04-22 00:53:45', 1, 'AIO', 98, 'Point Of Interest', 'Central Daylight Time'),
(162, 102, 'Malcolm\'s Heating & Air', 'malcolm@gmail.com', '(817) 333-7310', 'http://malcolmsheatingandair.com/', '3416 Wendell Dr, North Richland Hills, TX 76117, USA', NULL, 'testing', 'Malcolm\'s Heating & Air, Wendell Drive, North Richland Hills, TX, USA', '30', 'https://maps.googleapis.com/maps/api/staticmap?center=32.95241161956831,-97.10298162497818&zoom=9.5&size=900x800&maptype=roadmap&markers=color:red%7C32.95241161956831,-97.10298162497818&path=color:red%7Cfillcolor:red%7Cweight:2%7Cenc:af|iEx_rpQjDojE`OwiExYahEhd@seEtn@kbE~x@m~D|bAsyDrlActD`vA{mD`_B}fDxgBi_D~oBcwCzwBgnCb_C{dC|eC}zBflCopB|qCueB`wCkzAp{CynAn_DybAvbDuv@jeDij@hgDw]rhDcQdiDkDdiDjFlhD~R`gDt_@~dD`l@hbDjx@|~CjdA~zCbpAjvCp{AfqCrfBlkCfqBdeCj{Bh~BbeC~vBfnCdoBzvC|fBz~Cj~AdfDhuA|lD~kA|rDhbAhxDlx@z|Dfn@t`E~c@zcEnYdfE|NvgEhDphEiDnhE}NvgEoYdfE_d@zcEgn@v`Emx@z|DibAfxD_lA~rDiuAzlDk~AffD}fBx~CeoBzvC_wBfnCi~BbeCeeCl{BmkCfqBgqCpfBkvCp{A_{CdpA}~CjdAibDhx@_eDbl@agDr_@mhD`SeiDhFeiDkDshDaQigDw]keDij@wbDuv@o_D{bAq{CynAawCkzA}qCseBglCqpB}eC}zBc_CydC{wBinC_pBawCygBk_Da_B}fDavA{mDslActD}bAsyD_y@k~Dun@mbEid@seEyYahEaOuiE&key=AIzaSyDtMhPtoqeZSt-5Qyh6E4FcO0Q_jqH2oLw&libraries=geometry&callback=initMap', '2024-06-04 17:57:06', '2024-06-04 17:57:11', 1, 'AIO', 8888, 'General Contractor', 'Central Daylight Time'),
(163, 103, 'Wood Heating & Air LLC', 'woodheating@gmail.com', '(434) 981-6627', 'https://www.woodheating.com', '3683 Airport Acres Rd, Charlottesville, VA 22911, USA', NULL, 'testing description', 'WOOD HEATING AND COOLING, 23rd Street, Mattawan, MI, USA', '20', 'https://maps.googleapis.com/maps/api/staticmap?center=42.27841281443901,-85.77528690000001&zoom=9.5&size=900x800&maptype=roadmap&markers=color:red%7C42.27841281443901,-85.77528690000001&path=color:red%7Cfillcolor:red%7Cweight:2%7Cenc:e~xbGp~ojOpBayCvIoxCxPewCzWkuCx^}rCre@}oChl@ilCvr@chC~x@kcC`_Ae~BxdAmxBjjAcrBnoAokBltAkdB|xA{|Ab}A_uA|`BwlAjdBgdAjgBm{@~iBmr@blBgi@|mBy_@doBiV`pBwLnpBcClpBnD~oBbN`oBtWrmBba@zkBjj@tiBns@~fBl|@|cB`eAn`BlmAr|AnuAlxAf}A|sApdB~nAlkBxiA`rBhdA`xBp~@r}Bpx@vbCjr@fgCzk@jkChe@xnCn^vqCtWbtCtPzuCrI`wCpBtwCqBrwCsI`wCuP|uCuW`tCo^vqCie@znC{k@hkCkr@hgCqx@tbCq~@t}BidA`xByiA~qB_oAnkB}sApdBmxAd}As|AnuAo`BlmA}cB`eA_gBl|@uiBns@{kBlj@smB`a@aoBtW_pBbNmpBnDopBcCapBuLeoBkV}mBy_@clBei@_jBmr@kgBo{@kdBedA}`BylAc}A}tA}xA{|AmtAkdBooAokBkjAerBydAmxBa_Ac~B_y@mcCwr@chCil@ilCse@{oCy^}rC{WkuCyPgwCwImxC&key=AIzaSyDtMhPtoqeZSt-5Qyh6E4FcO0Q_jqH2oLw&libraries=geometry&callback=initMap', '2024-06-08 19:37:12', '2024-06-08 19:39:53', 1, 'AIO', 506, 'General Contractor', 'Eastern Daylight Time');

-- --------------------------------------------------------

--
-- Table structure for table `closers`
--

CREATE TABLE `closers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `closer_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `closers`
--

INSERT INTO `closers` (`id`, `closer_name`, `created_at`, `updated_at`, `user_id`) VALUES
(98, 'Emilia Wilson', '2024-02-13 17:11:55', '2024-02-13 17:11:55', 85),
(117, 'Ross Miller', '2024-02-13 17:12:26', '2024-02-13 17:12:26', 87),
(200, 'Rich Richardson', '2024-02-13 17:12:56', '2024-02-13 17:12:56', 88),
(204, 'Aaron Wood', '2024-02-13 17:15:39', '2024-02-13 17:15:39', 89),
(233, 'Victor Hugo', '2024-02-13 17:22:56', '2024-02-13 17:22:56', 94),
(234, 'Albert Hall', '2024-02-13 17:19:20', '2024-02-13 17:19:20', 93),
(337, 'Michelle Jones', '2024-02-13 17:15:55', '2024-02-13 17:15:55', 90),
(346, 'Azmyrrh Jasper', '2024-02-13 17:12:40', '2024-02-13 17:12:40', 92),
(469, 'Marc Walters', '2024-02-13 17:16:17', '2024-02-13 17:16:17', 91),
(506, 'Blake Wilson', '2024-02-13 17:12:10', '2024-02-13 17:12:10', 86),
(8888, 'Self', '2024-02-14 18:30:28', '2024-02-14 18:30:28', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `closer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `comments` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` (`id`, `order_id`, `closer_id`, `comments`, `created_at`, `updated_at`) VALUES
(59, 223, 85, 'talha ikram', '2024-06-07 21:56:34', '2024-06-07 21:56:34'),
(60, 223, 85, 'muhammad azmat', '2024-06-07 21:56:48', '2024-06-07 21:56:48'),
(61, 224, 85, 'talha ikram', '2024-06-07 22:10:44', '2024-06-07 22:10:44'),
(62, 224, 85, 'muhammad talha', '2024-06-07 22:10:54', '2024-06-07 22:10:54'),
(63, 224, 85, 'xd', '2024-06-07 22:14:42', '2024-06-07 22:14:42'),
(64, 224, 85, 'cf', '2024-06-07 22:14:52', '2024-06-07 22:14:52'),
(65, 224, 85, 'xd', '2024-06-07 22:22:33', '2024-06-07 22:22:33'),
(66, 224, 85, 'asd', '2024-06-07 22:23:40', '2024-06-07 22:23:40'),
(67, 224, 85, 'azzza', '2024-06-07 22:23:53', '2024-06-07 22:23:53'),
(68, 224, 85, 'cx', '2024-06-07 22:24:48', '2024-06-07 22:24:48'),
(69, 224, 85, 'talha ikram', '2024-06-07 22:29:10', '2024-06-07 22:29:10'),
(70, 224, 85, 'very good', '2024-06-07 22:31:41', '2024-06-07 22:31:41'),
(71, 224, 87, 'good work', '2024-06-07 22:33:25', '2024-06-07 22:33:25'),
(72, 224, 85, 'thanks ross', '2024-06-07 22:34:01', '2024-06-07 22:34:01'),
(73, 222, 85, 'this is a good client', '2024-06-07 22:36:13', '2024-06-07 22:36:13'),
(74, 222, 86, 'i tried to call this client but he is not responding so i have to wait for his call.', '2024-06-08 19:43:46', '2024-06-08 19:43:46'),
(75, 222, 86, 'hello world', '2024-06-08 19:45:05', '2024-06-08 19:45:05'),
(76, 222, 86, 'hello', '2024-06-08 19:45:11', '2024-06-08 19:45:11'),
(77, 222, 86, 'nice', '2024-06-08 19:45:16', '2024-06-08 19:45:16'),
(78, 223, 87, '?', '2024-06-08 19:57:30', '2024-06-08 19:57:30');

-- --------------------------------------------------------

--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) NOT NULL,
  `discount_price` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `closer_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `coupons`
--

INSERT INTO `coupons` (`id`, `code`, `discount_price`, `created_at`, `updated_at`, `closer_id`) VALUES
(30, 'EM87', '100', '2024-02-13 18:00:32', '2024-02-13 18:00:32', 85),
(31, 'BK80', '200', '2024-02-14 10:26:08', '2024-02-14 10:26:08', 86),
(32, 'TA2423', '500', '2024-02-16 14:52:15', '2024-02-16 14:52:15', 85),
(33, 'BRWLCM', '600', '2024-02-19 14:45:04', '2024-02-19 14:45:04', 85),
(34, 'TR40', '450', '2024-06-08 19:41:15', '2024-06-08 19:41:15', 86);

-- --------------------------------------------------------

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `login_activities`
--

CREATE TABLE `login_activities` (
  `id` int(10) UNSIGNED NOT NULL,
  `users_id` bigint(20) UNSIGNED NOT NULL,
  `user_agent` varchar(255) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `login_activities`
--

INSERT INTO `login_activities` (`id`, `users_id`, `user_agent`, `ip_address`, `created_at`, `updated_at`) VALUES
(161, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-29 14:52:57', '2024-01-29 14:52:57'),
(162, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-29 14:53:46', '2024-01-29 14:53:46'),
(165, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-29 15:56:24', '2024-01-29 15:56:24'),
(167, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-29 18:13:55', '2024-01-29 18:13:55'),
(168, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-30 10:06:11', '2024-01-30 10:06:11'),
(170, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-30 12:31:08', '2024-01-30 12:31:08'),
(171, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-30 12:32:20', '2024-01-30 12:32:20'),
(172, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-30 12:41:41', '2024-01-30 12:41:41'),
(173, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-30 12:45:36', '2024-01-30 12:45:36'),
(174, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-30 12:52:17', '2024-01-30 12:52:17'),
(175, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-30 13:03:37', '2024-01-30 13:03:37'),
(176, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-30 13:21:10', '2024-01-30 13:21:10'),
(179, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-30 13:22:25', '2024-01-30 13:22:25'),
(180, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-30 14:38:29', '2024-01-30 14:38:29'),
(183, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-30 14:58:30', '2024-01-30 14:58:30'),
(184, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-30 16:52:10', '2024-01-30 16:52:10'),
(185, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-30 21:36:18', '2024-01-30 21:36:18'),
(188, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-30 22:42:08', '2024-01-30 22:42:08'),
(190, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-30 23:10:43', '2024-01-30 23:10:43'),
(191, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-31 09:50:07', '2024-01-31 09:50:07'),
(194, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-31 10:05:54', '2024-01-31 10:05:54'),
(199, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-31 10:32:51', '2024-01-31 10:32:51'),
(204, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-31 11:45:58', '2024-01-31 11:45:58'),
(209, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-31 13:44:59', '2024-01-31 13:44:59'),
(210, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-31 16:52:56', '2024-01-31 16:52:56'),
(212, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-01-31 17:52:54', '2024-01-31 17:52:54'),
(215, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-03 13:55:43', '2024-02-03 13:55:43'),
(216, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-03 13:57:53', '2024-02-03 13:57:53'),
(217, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-07 16:44:27', '2024-02-07 16:44:27'),
(218, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-12 13:04:47', '2024-02-12 13:04:47'),
(221, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-12 13:28:38', '2024-02-12 13:28:38'),
(223, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-12 18:00:29', '2024-02-12 18:00:29'),
(227, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-12 19:06:38', '2024-02-12 19:06:38'),
(229, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-12 19:08:43', '2024-02-12 19:08:43'),
(231, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-12 19:21:06', '2024-02-12 19:21:06'),
(232, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-12 20:59:19', '2024-02-12 20:59:19'),
(235, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 16:07:46', '2024-02-13 16:07:46'),
(236, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 16:36:53', '2024-02-13 16:36:53'),
(238, 85, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 16:56:52', '2024-02-13 16:56:52'),
(239, 86, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 16:58:08', '2024-02-13 16:58:08'),
(240, 87, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 16:58:50', '2024-02-13 16:58:50'),
(241, 88, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 16:59:54', '2024-02-13 16:59:54'),
(242, 89, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 17:01:00', '2024-02-13 17:01:00'),
(243, 90, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 17:02:20', '2024-02-13 17:02:20'),
(244, 91, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 17:03:25', '2024-02-13 17:03:25'),
(245, 92, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 17:05:07', '2024-02-13 17:05:07'),
(246, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 17:10:53', '2024-02-13 17:10:53'),
(247, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 17:17:24', '2024-02-13 17:17:24'),
(248, 93, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 17:18:45', '2024-02-13 17:18:45'),
(249, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 17:19:10', '2024-02-13 17:19:10'),
(250, 94, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 17:21:01', '2024-02-13 17:21:01'),
(251, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 17:21:26', '2024-02-13 17:21:26'),
(252, 95, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 17:22:42', '2024-02-13 17:22:42'),
(253, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 17:54:13', '2024-02-13 17:54:13'),
(254, 85, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 17:59:45', '2024-02-13 17:59:45'),
(255, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 18:01:10', '2024-02-13 18:01:10'),
(256, 95, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-13 18:04:36', '2024-02-13 18:04:36'),
(257, 96, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-14 10:18:09', '2024-02-14 10:18:09'),
(258, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-14 10:21:40', '2024-02-14 10:21:40'),
(259, 97, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-14 10:24:41', '2024-02-14 10:24:41'),
(260, 86, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-14 10:25:54', '2024-02-14 10:25:54'),
(261, 97, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-14 12:42:40', '2024-02-14 12:42:40'),
(262, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-14 13:22:40', '2024-02-14 13:22:40'),
(263, 98, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-14 13:28:24', '2024-02-14 13:28:24'),
(264, 99, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-15 14:25:58', '2024-02-15 14:25:58'),
(265, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-15 14:26:25', '2024-02-15 14:26:25'),
(266, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-16 14:02:19', '2024-02-16 14:02:19'),
(267, 99, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-16 14:04:44', '2024-02-16 14:04:44'),
(268, 85, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-16 14:23:02', '2024-02-16 14:23:02'),
(269, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-16 14:48:32', '2024-02-16 14:48:32'),
(270, 85, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-16 14:49:54', '2024-02-16 14:49:54'),
(271, 99, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-16 14:52:33', '2024-02-16 14:52:33'),
(272, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-16 14:53:31', '2024-02-16 14:53:31'),
(273, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-19 13:59:28', '2024-02-19 13:59:28'),
(274, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-19 14:41:38', '2024-02-19 14:41:38'),
(275, 85, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-19 14:44:07', '2024-02-19 14:44:07'),
(276, 100, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-02-19 14:46:39', '2024-02-19 14:46:39'),
(277, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-04-22 00:46:47', '2024-04-22 00:46:47'),
(278, 101, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-04-22 00:50:09', '2024-04-22 00:50:09'),
(279, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-05-18 23:36:28', '2024-05-18 23:36:28'),
(280, 102, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-04 17:53:38', '2024-06-04 17:53:38'),
(281, 102, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-04 17:54:46', '2024-06-04 17:54:46'),
(282, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-04 17:59:50', '2024-06-04 17:59:50'),
(283, 88, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-04 18:03:01', '2024-06-04 18:03:01'),
(284, 85, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-05 17:12:21', '2024-06-05 17:12:21'),
(285, 85, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-05 20:28:44', '2024-06-05 20:28:44'),
(286, 102, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-05 20:44:26', '2024-06-05 20:44:26'),
(287, 85, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-05 20:46:48', '2024-06-05 20:46:48'),
(288, 85, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-05 20:47:39', '2024-06-05 20:47:39'),
(289, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-05 20:48:18', '2024-06-05 20:48:18'),
(290, 87, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-06 09:40:52', '2024-06-06 09:40:52'),
(291, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-06 09:51:10', '2024-06-06 09:51:10'),
(292, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-06 16:46:05', '2024-06-06 16:46:05'),
(293, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-06 17:00:05', '2024-06-06 17:00:05'),
(294, 87, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-07 06:54:04', '2024-06-07 06:54:04'),
(295, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-07 06:55:36', '2024-06-07 06:55:36'),
(296, 85, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-07 09:15:43', '2024-06-07 09:15:43'),
(297, 87, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-07 09:16:17', '2024-06-07 09:16:17'),
(298, 89, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-07 10:40:12', '2024-06-07 10:40:12'),
(299, 86, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-07 10:41:23', '2024-06-07 10:41:23'),
(300, 87, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-07 06:53:34', '2024-06-07 06:53:34'),
(301, 87, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-07 06:58:18', '2024-06-07 06:58:18'),
(302, 87, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-07 07:33:38', '2024-06-07 07:33:38'),
(303, 85, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-07 21:09:19', '2024-06-07 21:09:19'),
(304, 87, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-07 22:32:39', '2024-06-07 22:32:39'),
(305, 85, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-07 22:33:45', '2024-06-07 22:33:45'),
(306, 103, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-08 19:33:09', '2024-06-08 19:33:09'),
(307, 86, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-08 19:40:52', '2024-06-08 19:40:52'),
(308, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-08 19:41:42', '2024-06-08 19:41:42'),
(309, 71, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-08 19:42:49', '2024-06-08 19:42:49'),
(310, 86, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-08 19:43:03', '2024-06-08 19:43:03'),
(311, 87, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-08 19:45:42', '2024-06-08 19:45:42'),
(312, 87, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-08 19:49:00', '2024-06-08 19:49:00'),
(313, 87, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36', '127.0.0.1', '2024-06-08 19:57:09', '2024-06-08 19:57:09');

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2023_08_28_000109_create_countries_states_cities_tables', 2),
(6, '2023_08_29_032505_create_users_table', 3),
(7, '2023_08_29_041432_create_business_information_table', 4),
(8, '2023_08_29_105414_create_products_table', 4),
(9, '2023_08_29_110404_create_orders_table', 4),
(10, '2023_08_29_112542_create_coupons_table', 4),
(11, '2023_08_30_094154_create_business_information_table', 5),
(12, '2023_08_30_094435_create_business_information_table', 6),
(13, '2023_08_31_155436_add_ordernumber_to_orders_table', 7),
(14, '2023_09_01_211531_add_order_status_to_orders_table', 8),
(15, '2023_09_03_215529_add_radius_to_products_table', 9),
(16, '2023_09_25_233051_add_pid_to_business_information_table', 10),
(17, '2023_10_14_160304_add_roles_to_users_table', 11),
(18, '2023_11_07_095032_create_closures_table', 12),
(19, '2023_11_07_180637_remove_closure_id_from_business_information', 13),
(20, '2023_11_07_184356_create_closers_table', 14),
(21, '2023_11_07_181945_add_closureid_to_business_information_table', 15),
(22, '2023_11_07_201441_add_closer_name_to_business_information', 16),
(23, '2023_11_07_225451_add_invoice_id_to_orders', 17),
(24, '2023_12_18_192948_add_services_to_business_information', 18),
(25, '2023_12_21_200023_add_closerid_to_business_information_table', 19),
(26, '2023_12_21_204913_rename_column_to_closers_table', 20),
(27, '2024_01_15_185117_add_category_to_business_information_table', 21),
(28, '2024_01_15_231218_add_timezone_to_business_information_table', 22),
(29, '2024_01_18_174721_create_login_activities_table', 23),
(30, '2024_01_19_213918_create_coupon_table', 24),
(31, '2024_01_19_214524_create_coupons_table', 25),
(32, '2024_01_19_214234_create_product_coupon_table', 26),
(33, '2024_01_19_214843_create_product_coupons_table', 27),
(34, '2024_01_19_223929_add_closer_id_to_coupons_table', 28),
(35, '2024_01_20_185124_add_new_price_to_product_coupons_table', 29),
(36, '2024_01_21_103742_add_user_id_to_closers_table', 30),
(37, '2024_01_22_012128_add_product_coupon_id_to_business_information_table', 31),
(38, '2024_01_22_151205_add_business_id_to_product_coupons_table', 32),
(39, '2024_02_13_015557_add_payment_method_to_orders_table', 33),
(40, '2024_06_07_121134_create_comments_table', 34);

-- --------------------------------------------------------

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `ordernumber` varchar(255) NOT NULL,
  `order_status` varchar(255) NOT NULL,
  `invoice_id` varchar(255) DEFAULT NULL,
  `payment_method` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `client_id`, `product_id`, `created_at`, `updated_at`, `ordernumber`, `order_status`, `invoice_id`, `payment_method`) VALUES
(222, 95, 1, '2024-02-13 18:07:31', '2024-02-13 18:07:31', 'J6UPe', 'Paid', '9212486459', 'Card'),
(223, 96, 2, '2024-02-14 10:21:15', '2024-02-14 10:21:15', '2DIEa', 'Paid', '9214197405', 'Card'),
(224, 97, 2, '2024-02-14 13:21:14', '2024-02-14 13:21:14', 'n64VT', 'Paid', '9214751710', 'Card');

-- --------------------------------------------------------

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `productname` varchar(255) NOT NULL,
  `price` varchar(255) NOT NULL,
  `productdescription` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `radius` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `productname`, `price`, `productdescription`, `created_at`, `updated_at`, `radius`) VALUES
(1, 'Package A', '650', 'in this package we\'ll cover your upto 30 miles radius.', NULL, NULL, '30'),
(2, 'Package B', '1', 'in this package we will cover upto 50 miles radius', NULL, NULL, '50'),
(3, 'Package C', '1500', 'in this package we will cover upto 70 miles radius.', NULL, NULL, '70'),
(4, 'Premium Package', '2000', 'in this package we will cover you desired radius miles', NULL, NULL, '100');

-- --------------------------------------------------------

--
-- Table structure for table `product_coupons`
--

CREATE TABLE `product_coupons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `coupon_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `new_discount_price` decimal(8,2) DEFAULT NULL,
  `business_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_coupons`
--

INSERT INTO `product_coupons` (`id`, `coupon_id`, `product_id`, `created_at`, `updated_at`, `new_discount_price`, `business_id`) VALUES
(106, 30, 1, '2024-02-13 18:05:52', '2024-02-13 18:05:52', 550.00, 154),
(107, 30, 2, '2024-02-14 10:19:29', '2024-02-14 10:19:29', 850.00, 155),
(110, 32, 3, '2024-02-16 14:54:00', '2024-02-16 14:54:00', 1000.00, 159);

-- --------------------------------------------------------

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(11) NOT NULL,
  `product_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `product_name`, `created_at`, `updated_at`) VALUES
(1, 'AIO Optimization', '2023-08-25 16:42:45', '2023-08-25 16:42:45'),
(2, 'AI Web Pages', '2023-08-25 16:42:45', '2023-08-25 16:42:45'),
(3, 'Google Ads', '2023-08-25 16:42:45', '2023-08-25 16:42:45'),
(4, 'Website Development OTC', '2023-08-25 16:42:45', '2023-08-25 16:42:45'),
(5, 'AIO (OTC)', '2023-08-25 16:42:45', '2023-08-25 16:42:45'),
(6, 'Landing Page OTC', '2023-08-25 16:42:45', '2023-08-25 16:42:45'),
(7, 'Voice Search OTC', '2023-08-25 16:42:45', '2023-08-25 16:42:45'),
(8, 'Yelp Cancellation OTC', '2023-08-25 16:42:45', '2023-08-25 16:42:45'),
(9, 'Social Media Management', '2023-08-25 16:42:45', '2023-08-25 16:42:45'),
(10, 'GBP Registration (OTC)', '2023-08-25 16:42:45', '2023-08-25 16:42:45'),
(11, 'GBP Reinstate (OTC)', '2023-08-25 16:42:45', '2023-08-25 16:42:45'),
(12, 'Google Adwords', '2023-08-25 16:42:45', '2023-08-25 16:42:45'),
(13, 'Review Plugin (OTC)', '2023-08-25 16:42:45', '2023-08-25 16:42:45'),
(14, 'Website Optimization', '2023-08-25 16:42:45', '2023-08-25 16:42:45'),
(15, 'Animated Video', '2023-08-25 16:42:45', '2023-08-25 16:42:45');

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `roles` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `first_name`, `last_name`, `email`, `phone`, `address`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `roles`) VALUES
(71, 'AIO', 'Admin', 'admin@getmyaio.com', '(454) 533-4334', 'myaio USA', '2024-01-29 14:53:06', '$2y$10$4BRmunG4wNVkEjMe7zST8uDeDWh2Xdb/K.mOOcc0xTYVFIGi/Jc/G', NULL, '2024-01-29 14:52:51', '2024-01-29 14:53:06', 1),
(85, 'Emilia', 'Wilson', 'emilia@myaio.com', '(123) 112-1212', 'chicago, US', '2024-02-13 16:57:01', '$2y$10$y7w0pAua3z8nzDT.MTymnO9k1.tSbUWZ/bvrSTbEEwB/dvRMIDYXK', NULL, '2024-02-13 16:56:47', '2024-02-13 17:11:55', 2),
(86, 'Blake', 'Wilson', 'blake@myaio.com', '(123) 456-7890', 'chicago, US', '2024-02-13 16:58:11', '$2y$10$L64B4R/FPW0qYYvewViHgeEXWsZRZe0bGXqf12V5OXPekdwlwitnO', NULL, '2024-02-13 16:58:03', '2024-02-13 17:12:10', 2),
(87, 'Ross', 'Miller', 'ross@myaio.com', '(123) 456-7890', 'chicago, US', '2024-02-13 16:59:02', '$2y$10$q3sv/7UrVJToMqjDd.2wiOeV0VvZKsKewHS6dxqQ5HvQtzaUNBYq6', NULL, '2024-02-13 16:58:46', '2024-02-13 17:12:26', 2),
(88, 'Rich', 'Richardson', 'rich@myaio.com', '(123) 456-7890', 'chicago, US', '2024-02-13 16:59:59', '$2y$10$qyNIQOYi9QtEF3LhK2n9fO6H6vnkQtSbNm68Alx7z5LUgl7qxHjJm', NULL, '2024-02-13 16:59:50', '2024-02-13 17:12:56', 2),
(89, 'Aaron', 'Wood', 'aaron@myaio.com', '(123) 456-7890', 'chicago, US', '2024-02-13 17:01:06', '$2y$10$B0WS6PbIFfwrkyRtO7Z.je4F8JFmc3wYlBS0PBosRzrulDjhElloS', NULL, '2024-02-13 17:00:53', '2024-02-13 17:15:39', 2),
(90, 'Michelle', 'Jones', 'michelle@myaio.com', '(123) 456-7890', 'chicago, US', '2024-02-13 17:02:29', '$2y$10$GANl9UfJJy4l2kEJBB7lxesaxTKaQ4AS.WT/6d5BoP8Sg5YOJSBj2', NULL, '2024-02-13 17:02:16', '2024-02-13 17:15:55', 2),
(91, 'Marc', 'Walters', 'marc@myaio.com', '(123) 456-7890', 'chicago, US', '2024-02-13 17:03:34', '$2y$10$GzJRnLhm08eYuMl2lGgx1eEzvjqpYv67bCr213HlBk2.8Vji3T1nq', NULL, '2024-02-13 17:03:21', '2024-02-13 17:16:17', 2),
(92, 'Azmyrrh', 'Jasper', 'azmyrrh@myaio.com', '(123) 456-7890', 'Chicago, US', '2024-02-13 17:07:49', '$2y$10$/WSwpmzb/ugyMt8R8R/aUuX85zfNWdHu8qRDT34Ylzgv6CwWBrRSO', NULL, '2024-02-13 17:05:03', '2024-02-13 17:12:40', 2),
(93, 'Albert', 'Halll', 'albert@myaio.com', '(123) 456-7890', 'chicago, US', '2024-02-13 17:18:50', '$2y$10$D2C9QoN3zKk94Rwre5kd4OSkcWJ1glQHB8hB.yq0WHIAOzx5ASwIO', NULL, '2024-02-13 17:18:41', '2024-02-16 14:02:36', 2),
(94, 'Victor', 'Hugo', 'victor@myaio.com', '(123) 456-7890', 'chicago, US', '2024-02-13 17:21:09', '$2y$10$j2HkBEXxNN9ibuJhqdU7HO951Wc.7RcVLob8MIzkInlUFVa7Ge.1W', NULL, '2024-02-13 17:20:56', '2024-02-13 17:22:56', 2),
(95, 'John', 'Doe', 'john@gmail.com', '(123) 456-7890', 'chicago, US', '2024-02-13 18:04:42', '$2y$10$CYZosCb8fRNFSnb.8SXx9.N6IqvMFVBjM9Vhn9hNzZuLLqKp0dpY.', NULL, '2024-02-13 17:22:38', '2024-02-13 18:04:42', 0),
(96, 'Zohaib', 'Shahid', 'zohaib@gmail.com', '(123) 456-7890', '576 Q block Johar Town Lahore', '2024-02-14 10:18:22', '$2y$10$liHY6WoFN9x9p19mcZdSoOEb4ZBAR1IqTXUllzVy630dDqfrWooza', NULL, '2024-02-14 10:17:59', '2024-02-14 10:18:22', 0),
(97, 'Salman', 'Naseem', 'salman@gmail.com', '(123) 456-7890', '576 Q block Johar Town Lahore', '2024-02-14 10:24:47', '$2y$10$6eWwPHHp2UmDflmsKprPNO1hNkkUvyWUkIwcSXjH/ohBnyuVUjomC', NULL, '2024-02-14 10:24:37', '2024-02-14 10:24:47', 0),
(98, 'Abbas', 'Zaidi', 'syed@gmail.com', '(123) 445-0569', '576 Q block Johar Town Lahore', '2024-02-14 13:28:51', '$2y$10$P5ydqpYsvi4zmBjhKLo3.e9Sy6WYtPGUBp6axqHd8ZdMoZxDPDfmu', NULL, '2024-02-14 13:28:20', '2024-02-14 13:28:51', 0),
(99, 'john', 'doe', 'johnn@gmail.com', '(123) 456-7890', 'XpertDigi, Block Q, Phase 2 Johar Town, Lahore, Pakistan, 23', '2024-02-15 14:26:07', '$2y$10$c8vrEExgXGzx7DN9BJ75heXKvbZukcPIvuV5UHxkf7BLJBPwYqrrq', NULL, '2024-02-15 14:25:54', '2024-02-15 14:26:07', 0),
(100, 'Steve', 'Emerson', 'steveemerson@gmail.com', '(773) 672-3637', '2424 W Devon Ave Chicago, IL 60659', '2024-02-19 14:47:11', '$2y$10$DIM7w6ed02xF8i3QmtUlLO6qXxUHd/RaYlT.nji4Qucg0TR7kIiXK', NULL, '2024-02-19 14:46:35', '2024-02-19 14:47:11', 0),
(101, 'Saif', 'Chughtai', 'saifchughtai@gmail.com', '(034) 343-0343', 'USA', '2024-04-22 00:50:43', '$2y$10$.ekGVwJeIvqmCW.E7rjhmuKlJHXdMgzdHsD0bfx6dtLimNnLDgzyW', NULL, '2024-04-22 00:50:00', '2024-04-22 00:50:43', 0),
(102, 'Muhammad', 'Azmat', 'web10@toppagerankers.com', '032323392', 'Testing address', '2024-06-04 17:53:46', '$2y$10$tOiVLljoEhWeYErrBcFW/epuTI7EAPfVtWXZbj141XIj/ZetSCJoO', NULL, '2024-06-04 17:53:33', '2024-06-04 17:53:46', 0),
(103, 'Talha', 'Ikram', 'talhaikram01@gmail.com', '(323) 223-2323', 'testing adress', '2024-06-08 19:33:18', '$2y$10$gYuvtxarxzdJ6qr.Z3bsMOGEboKesdPM0KaiNEDpTXU6K5nAe.06i', NULL, '2024-06-08 19:33:04', '2024-06-08 19:33:18', 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `business_information`
--
ALTER TABLE `business_information`
  ADD PRIMARY KEY (`id`),
  ADD KEY `business_information_client_id_foreign` (`client_id`),
  ADD KEY `business_information_pid_foreign` (`pid`),
  ADD KEY `business_information_closerid_foreign` (`closerid`);

--
-- Indexes for table `closers`
--
ALTER TABLE `closers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `closers_user_id_foreign` (`user_id`);

--
-- Indexes for table `comments`
--
ALTER TABLE `comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `comments_order_id_foreign` (`order_id`),
  ADD KEY `comments_closer_id_foreign` (`closer_id`);

--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`id`),
  ADD KEY `coupons_closer_id_foreign` (`closer_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `login_activities`
--
ALTER TABLE `login_activities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `login_activities_users_id_foreign` (`users_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orders_client_id_foreign` (`client_id`),
  ADD KEY `orders_product_id_foreign` (`product_id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_coupons`
--
ALTER TABLE `product_coupons`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_coupons_coupon_id_foreign` (`coupon_id`),
  ADD KEY `product_coupons_product_id_foreign` (`product_id`),
  ADD KEY `product_coupons_business_id_foreign` (`business_id`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `business_information`
--
ALTER TABLE `business_information`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=164;

--
-- AUTO_INCREMENT for table `closers`
--
ALTER TABLE `closers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=89799;

--
-- AUTO_INCREMENT for table `comments`
--
ALTER TABLE `comments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=79;

--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `login_activities`
--
ALTER TABLE `login_activities`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=314;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=225;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `product_coupons`
--
ALTER TABLE `product_coupons`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=114;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=104;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `business_information`
--
ALTER TABLE `business_information`
  ADD CONSTRAINT `business_information_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `business_information_closerid_foreign` FOREIGN KEY (`closerid`) REFERENCES `closers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `business_information_pid_foreign` FOREIGN KEY (`pid`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `closers`
--
ALTER TABLE `closers`
  ADD CONSTRAINT `closers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `comments`
--
ALTER TABLE `comments`
  ADD CONSTRAINT `comments_closer_id_foreign` FOREIGN KEY (`closer_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `comments_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `coupons`
--
ALTER TABLE `coupons`
  ADD CONSTRAINT `coupons_closer_id_foreign` FOREIGN KEY (`closer_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `login_activities`
--
ALTER TABLE `login_activities`
  ADD CONSTRAINT `login_activities_users_id_foreign` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `orders_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `product_coupons`
--
ALTER TABLE `product_coupons`
  ADD CONSTRAINT `product_coupons_business_id_foreign` FOREIGN KEY (`business_id`) REFERENCES `business_information` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_coupons_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_coupons_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
