ÿØÿà JFIF    ÿÛ „  ( %"1!%)+...383,7(-.+  -+++--++++---+-+-----+---------------+---+-++7-----ÿÀ  ß â" ÿÄ     ÿÄ H    !1AQaq"‘¡2B±ÁÑð#R“Ò Tbr‚²á3csƒ’ÂñDS¢³$CÿÄ   ÿÄ %  !1AQa"23‘ÿÚ   ? ôÿ ¨pŸªáÿ —åYõõ\?àÒü©ŠÄï¨pŸªáÿ —åYõõ\?àÓü©ŠÄá 0Ÿªáÿ Ÿå[úƒ ú®ði~TÁbqÐ8OÕpÿ ƒOò¤Oè`–RÂáœá™êi€ßÉ< FtŸI“öÌ8úDf´°å}“¾œ6  öFá°y¥jñÇh†ˆ¢ã/ÃÐ:ªcÈ "Y¡ðÑl>ÿ ”ÏËte:qž\oäŠe÷󲍷˜HT4&ÿ ÓÐü6ö®¿øþßèô Ÿ•7Ñi’•j|“ñì>b…þS?*Óôÿ ÓÐü*h¥£ír¶ü UãSç‚Ÿ[AÐaè[ûª•õ&õj?†Éö+EzP—WeÒírJFt ‘BŒ†Ï‡%#tE Øz ¥OÛ«!1›üä±Í™%ºÍãö]°î(–:@<‹ŒÊö×òÆt¦ãº+‡¦%ÌÁ²h´OƒJŒtMÜ>ÀÜÊw3Y´•牋4ǍýʏTì>œú=Íwhyë,¾Ôò×õ¿ßÊa»«þˆѪQ|%6ž™A õ%:øj<>É—ÿ Å_ˆCbõ¥š±ý¯Ýƒï…¶|RëócÍf溪“t.СøTÿ *Ä¿-{†çàczůŽ_–^XþŒ±miB[X±d 1,é”zEù»& î9gœf™9Ð'.;—™i}!ôšåîqêÛ٤ёý£½ÆA–àôe"A$˝Úsäÿ ÷Û #°xŸëí(l »ý3—¥5m! rt`†0~'j2(]S¦¦kv,ÚÇ l¦øJA£Šƒ J3E8ÙiŽ:cÉžúeZ°€¯\®kÖ(79«Ž:¯X”¾³Š&¡* ….‰Ž(ÜíŸ2¥ª‡×Hi²TF¤ò[¨íÈRëÉ䢍mgÑ.Ÿ<öäS0í„ǹÁU´f#Vß;Õ–…P@3ío<ä-±»Ž.L|kªÀê›fÂ6@»eu‚|ÓaÞÆŸ…¨ááå>åŠ?cKü6ùTÍÆ”†sĤÚ;H2RÚ†õ\Ö·Ÿn'¾ ñ#ºI¤Å´%çÁ­‚â7›‹qT3Iï¨ÖÚ5I7Ë!ÅOóŸ¶øÝñØôת¦$Tcö‘[«Ö³šÒ';Aþ ¸èíg A2Z"i¸vdÄ÷.iõ®§)¿]¤À†–‡É&ä{V¶iŽ”.Ó×Õÿ û?h¬Mt–íª[ÿ Ñÿ ÌV(í}=ibÔ¡›¥¢±b Lô¥‡piη_Z<‡z§èŒ)iÖwiÇ 2hÙ3·=’d÷8éŽ1¦¸c¤µ€7›7Ø ð\á)} ¹fËí›pAÃL%âc2 í§æQz¿;T8sæ°qø)QFMð‰XŒÂ±N¢aF¨…8¯!U  Z©RÊ ÖPVÄÀÍin™Ì-GˆªÅËŠ›•zË}º±ŽÍFò¹}Uw×#ä5B¤{î}Ð<ÙD é©¤&‡ïDbàÁôMÁ." ¤‡ú*õ'VŽ|¼´Úgllº¼klz[Æüï÷Aób‡Eÿ dÑ»Xx9ÃÜ£ÁT/`¼¸vI±Ýµ·Ë‚“G³þ*Ÿû´r|*}<¨îºœ @¦mÄ’M¹”.œ«Y–|6ÏU¤jç¥ÕÞqO ˜kDÆÁ¨5ÿ š;Њ¦¦€GÙk \ –Þ=â¼=SͧµªS°ÚÍpÜãQűÀõ¬?ÃÁ1Ñ•õZà?hóœ€ L¦l{Y*K˜Ù›zc˜–ˆâ ø+¾ ­-Ök¥%ùEÜA'}ˆ><ÊIè“bpÍ/qÞâvoX€w,\úªò6Z[XdÒæ­@Ö—€$òJí#é>'°Ú ôª˜<)4ryÙ£|óAÅn5žêŸyÒäMÝ2{"}‰–¤l÷ûWX\l¾Á¸góÉOÔ /óñB¤f¸çñ[.P˜ZsÊË*ßT܈§QN¢’¡¨§V¼(Üù*eÕ“”5T¨‹Âê¥FŒã½Dü[8'Ò¥a…Ú¶k7a *•›¼'Ò·\8¨ª\@\õ¢¦íq+DÙrmÎ…_ªæ»ŠÓœ¡¯’Ré9MÅ×D™lælffc+ŒÑ,ý™ÿ ¯þǤ=Å’Á7µ÷ÚÛ/“Ü€ñýã¼àí¾ÕÑ+ƒ,uµMâÀÄbm:ÒÎPæ{˜Gz[ƒ¯«® KHà`ßØŠéí¯P8Aq.C‰ à€kòpj´kN¶qô€…Õ,ÜNŠª-­{Zö’æû44‰sŽè‰îVíRœÕm" 6?³D9¡ÇTíÅꋇ`4«¸ÝÁô ï’ýorqКÇZ«x4Žâéþuïf¹µö[P ,Q£éaX±`PÉÍZ ¸äYúg üAx ’6Lê‚xÝÓ*äQ  Ï’¨hÍ =²,6ï#rÃ<¯–£»ƒ‹,–ê•€ aÛsñ'%Æ"®ÛüìBᝠHÚ3ß°©$“XnœÖ’î2ËTeûìxîß ¦å¿çÉ ðK§þ{‘t‚Ϋ¬jéîZ[ ”š7L¥4VÚCE×]m¤Øy”ä4-dz£œ§¸x.*ãÊÊ b÷•h:©‡¦s`BTÁRû¾g⻩‹jø sF¢àJøFl‘È•Xᓁà~*j¯ +(ÚÕ6-£¯÷GŠØy‚<Ç’.F‹Hœw(+)ÜÜâÈzÄäT§FߘãÏ;DmVœ3Àu@mÚüXÝü•3B¨òÌÁÛ<·ÃÜ z,Ì@õÅ·d2]ü8s÷IôÞ¯^Ç9¢u„~ëAŸï4«M? K]­ÅàPl@s_ p:°¬ZR”´›JC[CS.h‹ƒïËœ«Æ]–÷ó‚wR×k7X‰k›‘´ù¦=¡«‰¨¨Â')—71ó’c‡Ðúµ `é.{§p¹ój\Ž{1h{o±Ý=áUÊïGÖŒõ–-BÄm+AZX¶¡ ïHðæ¥JmÙ;…ä¡Ÿˆ¦ ° äšiÉg«$üMk5¤L“’çÊvïâï ,=f“"íἊ5ô¬x6{ɏžID0e¸vçmi'︧ºð9$ò¹÷*£’9ÿ ²TÔ…×>JV¥}Œ}$p[bÔ®*[jzS*8 ”·T›Í–ñUîƒwo$áè=LT™ç—~ô·¤ÈÚ$榍q‰„+´kFm)ž‹©i–ËqÞŠ‰à¶ü( ‚•§ •°ò·‡#5ª•µÊ﯅¡X¨šÁ*F#TXJÊ ušJVÍ&=iÄs1‚3•'fý§5Ñ<=[íÞ­ PÚ;ѱÌ_~Ä££8rÞ ²w;’hDT°>ÈG¬8Á²ÚzŽ®ò®qZcqJêäÞ-ö[ܘbň±çb“Š¶31²n×iƒðÕ;1¶þÉ ªX‰,ßqÏ$>•î íZ¥Z 1{ç൵+ƒÕµ¥°T$§K]á»Ûï*·¤tMI’ÂZbŽÕiÒ˜}bÓ0£ª5›¨ [5Ž^ÝœWøÂÝh° ¢OWun£¤5 a2Z.G2³YL]jåtì”ä ÁÓ‘%"©<ÔúÊ°sº UZvä‡ÄiÆÒM .÷V·™ø#kèýiíÌ–ª)µT[)BˆõÑ xB¾B€ÖT¨.¥~ð@VĶr#¸ü*åZNDŽH;âi ],©£öØpù(šºãö¼T.uCê•4@ÿ GÕÛ)Cx›®0ø#:ÏðFÒbR\(€€Ä®fã4Þ‰Fä¯HXƒÅ,†öEÑÔÜ]Öv²?tLÃvBY£ú6Êu5ÅAQ³1‘’¬x–HŒÐ‡ ^ ¸KwJôÖŽ5×CÚ¨vÜ«/B0$×k°=ðbÇ(Ï)w±A†Á† 11Í=èQšµ626ŒÜ/`G«µ<}—-Ö7KEHÈÉðóȤmݱû±·ø«Snmá=“ä«šmݱŸ¡¶~ó·“äUóJæúòB|E LêŽy´jDÔ$G¢þÐñ7óR8ýÒ…Ç› WVe#·Ÿ p·Fx~•ݤF÷0Èÿ K¯æS<6’¡WШ; ´ÿ ¥Êø\Òuî†åÝ–VNœkÒ7oòX¨Á­Ø÷FÎÑä±g÷ÿ M~Çî=p,X´ ÝÌÚÅ‹’ÃjÖ.ØöÏñ qïQ¤ÓZE†° =6·]܈ s¸>v•Ž^Ý\wq9r‰Î\¸¡kURÒ$­*‹Nq?Þª*!sŠÆ:TU_u±T+øX¡ ®¹¡,ÄâÃBTsÜ$Ø›4m椴zÜK]’’›Pƒ @€#â˜`é¹=I‡fiV•Ôî“nRm+µFPOhÍ0B£ €+¬5c v•:P'ÒyÎ ‰V~‚Ó†ÖuókDoh$å\*ö%Ю=£«…aȼ½÷Û.-½VŒŠ¼'lyî±1¬3ó#ÞE¿ÔS¤gV£m›=§\û"—WU¤ÚǼÿ ÂnÁGŒÃ ‚õN D³õNÚíŒÕ;HôyÄÈ©P¹Ä{:?R‘Ô¨âF÷ø£bÅó® JS|‚R÷ivýáâ€Æé¡è³´IئÑT!§˜•Øª‚¬â@q€wnïCWÄ@JU€ê¯m6]Ï:£âx'+ÒðXvÓ¦Úm=–´7œ $ì“B£~p%ÕŸUþ« N@¼üï~w˜ñø5®—'Ôe»¤5ã//€ž~‰Tþ›Å7•#¤× Íö pÄ$ùeåì*«ÓŠEØWEÈsßg ¦ûvžSsLpºÊW–âµEWöˬH; ™!CYõZ ÃÄf æ#1W. \uWâ\,\Çf j’<qTbên›Î[vxx£ë 'ö¨1›˜ÀM¼Pÿ H)ƒêêŒA7s,|F“ 꺸k³9Ìö*ç®;Ö!Ö$Eiž•¹ÒÚ†ýóéÝû¾ÕS®ó$’NÝäŸz¤5r¦ãÄÃD÷Üø!°ø‡Ô&@m™Ì^Ãä­d q5Lnÿ N;.6½·N|#ä"1Nƒx“ã<3('&ñßt  ~ªu”1Tb㫨9ê–›–bìd$ߣ=#ÕãÒmU¯eí$EFù5ýYô櫨æ왍Ǘ±ssM]·á¿0ÕåJRÓªîiƒ+O58ÖñªŠÒx" \µâá¨i’¤i —Ö ” M+M¤ë9‚‰A¦°Qõ¾ßøK~¼Ã‘g…Ö´~÷Ï[3GUœÒ½#…kàÔ®Ò”‰³·dWV‰IP‰Ú8u¹”E ÖqLj¾êÕCBš{A^Âß;–¨`¯¬ìö ˼ ×tìø.tƐm*n¨y4o&Àx¥n¦×î‡aupáÛj8¿m›è¶ã!o½;ß0y^ý×^EÑ¿ÒjzŒ­)vÚÑnÄL …^ªô× ‡—‚3k Îý­hï]içå–îÏ*÷ñþ»Ô CÒjøjÍznˆ´ ¹#b'Fô‹ ‰v¥'’à'T´ƒHýÍ%M‰ ƒ&ÆÇŒï1 ‘ –Þ ‰i¬s žR-Ÿ kŠ¬á¬7:þ 0ŒÅÒÕ/aÙ¬ÃÝ#Úøœ ©aiVc‰. ¹¦ãµ” ›Yg¦›ÆÎýº°f³7ƒhá·¸­}&D9¡ÂsÉÙÞèŠõØàC™¨ñbFC|´Ü(ŸƒÚÒ-%»'a Ì¿)ËÇn¿úÿ ÞŽX…4ÊÅH^ôΑí@ù¹Eh¶“L8Çjù ¼ÎåVªóR©Ï5uà V4lZß®=€xÖŸ–ÑÈ ÷”¨°¾__yM1tÉ?uÆþIkÄgæ@þ[¢†°XÃJ£j·:nkÅ¢u ‘}âGzö­/IµèŠ¬¼48q¦F°ŽR¼=ûì{´¯RýicS ÕÛ íNtÍÙï£,w4rêì®»~x(©Uñ§#Ñ&œÕ¤>ÎåÍÓ9’Ö{9eV­[Öjâ²ãu]˜å2›qÑšÕJç0€sÄ|Êëè0튔bÁ>“{×_F`Ø©ºê:µä,v¤ðfc1±"«ÔÍän1#=· Âøv~H½ÐßA¾¿Ü€Óš]Õ; I¾÷ç‚Qi†î¹9ywÔKG˜áñ zQY—§ÃÕZ07§X‚ Áh;ÁM)iÌCH-¯T‘ë|A0{Ò½LÚ–TâÖkÜ’dÀ“rmm»”جPF³ÖcbE§T€ÒxKºû’Ó®7±²(\4ŽÃ¸Uu@j™yĵ;³µ!Á¢b.W¤=mõ´êµK k ¸K^ÜÛ#p*Ü14qkZç5ïë †°5Ï%ÍÛ<Õ¤×Ô¥ê†C Õ´¼ú$ƒÖ“”]Ù¬qÞÚ[4©ý!ûÏ—Áb쳐XµA¬â~`›Çr¸8ìùÝ䫦<>ä÷«?xs´ÇÑ /á;¹øüÊÈÙà{"@Žïzâ¬[âß‚ U_<ÇŸ½4èN˜ú61®qŠu ¦þF£»äJ_ˆÙÎ~ ÞAã–Ý„Ï—rŠD;xTž‘ô`É«…suãO`?³à™ô Lý#Íc5öoæØ‚y´´÷«ZR§<&JÇ+éâô´€i!Àˆ0æAoàðLèÖ-2ŸõW.’t^–(KÁmHµV@xÜÇy®Ñø­â^:Ú3w· 7½¹°ñ¸â¹®:',«Mœ—n­Á+Ãbš LÈ‘ÄnRÓÅœ%¦²‰¨ùQ:¤f‚ "PÕtô¸…cæl…&˜Ú˜Ôkv‹ž+vŠ,=¢v­6—Xy*¥t£«<™:“aîϲ=¦6rO]XI¿Œ÷¤zÚ­›¶ 6÷”w\d ü~v®ˆÌk«^m<ÿ ¢‰Õ\)ùºŽ;… lîÙÅEŠ®cѾ@vnMÏ,¼“ñ•ŽBxðÃzãÇç%3ˆ"}Ù•Åî> BÉú;Ò]V+P˜F_´ßé> Øše|ï‡ÄOmFæÇ ãqÞ$/xÐx­z`ï9"œÜij‚!7.\Td…9M‡•iŽ‹¾‘50ÞŽn¥ß4ÉôO ¹*í^QêËÜÇÌ8=Ž§s‰'ÂëÙ«á%Pú[O †ÅP¯VsŽ°.‰,kc¶ ¬A9n˜XÎ-ÞšN["¹QÕ‰ƒMýÁߺXJæÍaLj¾×Ãmã¾ãÚ uñÒþåQô¦¥ /ÄUx:‚ÍÜ’ Đ©ØÝ3V¨‰ÕnÐ6ó*óúK­«…c ¯U òhsý­jóÔj#,ímŒRµ«lbïUTŒÑ8†Ä0œÏr`ð¡¬É Ї ë"À² ™ 6¥ f¶ ¢ÚoܱԷ-<Àî)†a¶ž'Ú»¨TXqØæ¶÷YÄHy˜9ÈIW­YÀuMFë ºÏ’AqÌ4·/Ú †ô'i$øä­=Ä Ý|öK×40è|È6p‘0§)o¥ctî§H+CA-“ xØ|ÐXŠç l8íºð3Ø:³¤¬KX¯UÿÙ -- MySQL dump 10.13 Distrib 5.7.28, for Linux (x86_64) -- -- Host: localhost Database: billbee7360 -- ------------------------------------------------------ -- Server version 5.7.28-0ubuntu0.18.04.4 /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `customer_last_ids` -- DROP TABLE IF EXISTS `customer_last_ids`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `customer_last_ids` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `customername` text COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1011 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customer_last_ids` -- LOCK TABLES `customer_last_ids` WRITE; /*!40000 ALTER TABLE `customer_last_ids` DISABLE KEYS */; INSERT INTO `customer_last_ids` VALUES (1000,'customer',NULL,NULL),(1001,'customername',NULL,NULL),(1002,'customername',NULL,NULL),(1003,'customername',NULL,NULL),(1004,'customername',NULL,NULL),(1005,'customername',NULL,NULL),(1006,'customername',NULL,NULL),(1007,'customername',NULL,NULL),(1008,'customername',NULL,NULL),(1009,'customername',NULL,NULL),(1010,'customername',NULL,NULL); /*!40000 ALTER TABLE `customer_last_ids` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customers` -- DROP TABLE IF EXISTS `customers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `customers` ( `id` int(20) unsigned NOT NULL AUTO_INCREMENT, `Name` text COLLATE utf8mb4_unicode_ci NOT NULL, `AccNo` text COLLATE utf8mb4_unicode_ci, `Email` text COLLATE utf8mb4_unicode_ci, `PhoneNo` text COLLATE utf8mb4_unicode_ci, `Address` text COLLATE utf8mb4_unicode_ci, `Debit` text COLLATE utf8mb4_unicode_ci, `Credit` text COLLATE utf8mb4_unicode_ci, `CreatedDate` text COLLATE utf8mb4_unicode_ci, `Username` text COLLATE utf8mb4_unicode_ci, `Password` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `OpeningBalance` decimal(20,2) DEFAULT '0.00', `CurrentBalance` decimal(20,2) DEFAULT '0.00', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customers` -- LOCK TABLES `customers` WRITE; /*!40000 ALTER TABLE `customers` DISABLE KEYS */; INSERT INTO `customers` VALUES (3,'Sarves','ETC1003','sarves.tv@gmail.com','+14168544112','2657 Eglinton',NULL,NULL,'2019-12-25','sarves','123','2019-12-25 09:21:52','2019-12-27 01:13:55',0.00,1675.25),(4,'Kugeenthan','ETC1004','kugeenthan23@hotmail.com','+14169539192','2657 Eglinton',NULL,NULL,'2019-12-25','kuheenthan','123','2019-12-25 10:36:41','2019-12-25 11:36:47',24250.00,26887.00),(5,'Siva','ETC1005','siv38@live.com','+16475013108','2657 Eglinton',NULL,NULL,'2019-12-25','siva','123','2019-12-25 13:14:35','2019-12-25 13:15:27',12573.00,12573.00),(6,'Thushy','ETC1006','thushy@gmail.com','+16479604000','2657 Eglinton',NULL,NULL,'2019-12-25','thushy','123','2019-12-25 14:18:53','2019-12-25 14:18:53',10124.00,10124.00),(7,'Dinesh','ETC1007','dinesharan1985@gmail.com','+14167169050','2657 Eglinton',NULL,NULL,'2019-12-25','dinesh','123','2019-12-25 19:00:35','2019-12-28 13:01:36',45968.75,45130.75),(8,'Ananthaa','ETC1008','ananthaa@live.com','+16472061537','2657 Eglinton',NULL,NULL,'2019-12-26','ananthaa','123','2019-12-26 00:07:57','2019-12-26 00:07:57',3487.50,3487.50),(9,'Muhunthan','ETC1009','muhunth1@gmail.com','+14169186640','2657 Eglinton',NULL,NULL,'2019-12-26','muhunthan','123','2019-12-26 11:02:37','2019-12-27 00:26:53',960.00,785.00),(10,'Test User','ETC1010','selva.aran2012@gmail.com','+16472732759','Mississauga',NULL,NULL,'2019-12-27','Tsr','1123','2019-12-27 03:16:27','2019-12-27 03:21:04',75.00,985.00); /*!40000 ALTER TABLE `customers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customertransaction` -- DROP TABLE IF EXISTS `customertransaction`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `customertransaction` ( `id` int(11) NOT NULL AUTO_INCREMENT, `customer` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customertransaction` -- LOCK TABLES `customertransaction` WRITE; /*!40000 ALTER TABLE `customertransaction` DISABLE KEYS */; INSERT INTO `customertransaction` VALUES (1,'customername'),(2,'customername'),(3,'customername'),(4,'customername'),(5,'customername'),(6,'customername'),(7,'customername'),(8,'customername'),(9,'customername'),(10,'customername'); /*!40000 ALTER TABLE `customertransaction` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `generals` -- DROP TABLE IF EXISTS `generals`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `generals` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `CustomerName` text COLLATE utf8mb4_unicode_ci, `CompanyName` text COLLATE utf8mb4_unicode_ci, `Address` text COLLATE utf8mb4_unicode_ci, `Email` text COLLATE utf8mb4_unicode_ci, `PhoneNo` text COLLATE utf8mb4_unicode_ci, `Currency` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `LogoImage` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `generals` -- LOCK TABLES `generals` WRITE; /*!40000 ALTER TABLE `generals` DISABLE KEYS */; INSERT INTO `generals` VALUES (1,'Sarvesh Poopalasingam','Eagle TV','AJAX','spoopalasingam@gmail.com','+14168544112','$',NULL,'2019-12-19 04:32:55','LogoImage201912060925320000001575624332.jpg'); /*!40000 ALTER TABLE `generals` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `invoice_items` -- DROP TABLE IF EXISTS `invoice_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `invoice_items` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `InvoiceId` text COLLATE utf8mb4_unicode_ci NOT NULL, `ProductId` text COLLATE utf8mb4_unicode_ci NOT NULL, `Quantity` text COLLATE utf8mb4_unicode_ci NOT NULL, `SubTotal` text COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `Price` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `invoice_items` -- LOCK TABLES `invoice_items` WRITE; /*!40000 ALTER TABLE `invoice_items` DISABLE KEYS */; INSERT INTO `invoice_items` VALUES (2,'1','1','10','20000',NULL,NULL,'2000.00'),(3,'2','1','2','4000.00',NULL,NULL,'2000.00'),(4,'3','2','1','5.50',NULL,NULL,'5.50'),(5,'4','10','1','-0.25',NULL,NULL,'-0.25'),(6,'5','10','1','-0.25',NULL,NULL,'-0.25'),(8,'6','11','1000','4000',NULL,NULL,'4.00'),(9,'8','11','1000','4,000.00',NULL,NULL,'4.00'),(10,'9','7','2','210.00',NULL,NULL,'105.00'),(11,'9','6','7','525.00',NULL,NULL,'75.00'),(12,'9','7','9','945.00',NULL,NULL,'105.00'),(13,'10','9','10','60.00',NULL,NULL,'6.00'),(14,'11','11','1000','4,000.00',NULL,NULL,'4.00'),(15,'12','7','10','1,050.00',NULL,NULL,'105.00'),(16,'12','12','17','85.00',NULL,NULL,'5.00'),(17,'13','11','1000','4,000.00',NULL,NULL,'4.00'),(18,'14','6','10','750.00',NULL,NULL,'75.00'),(19,'14','7','10','1,050.00',NULL,NULL,'105.00'),(20,'15','3','1000','5,000.00',NULL,NULL,'5.00'),(21,'16','6','-1','-80.00',NULL,NULL,'80.00'),(22,'16','16','-1','-95.00',NULL,NULL,'95.00'),(23,'17','16','2','190.00',NULL,NULL,'95.00'),(24,'17','6','1','80.00',NULL,NULL,'80.00'),(25,'18','16','-2','-190.00',NULL,NULL,'95.00'),(26,'18','6','-1','-80.00',NULL,NULL,'80.00'),(27,'19','2','100','475.00',NULL,NULL,'4.75'),(28,'20','2','100','475.00',NULL,NULL,'4.75'),(29,'21','5','10','720.00',NULL,NULL,'72.00'),(30,'22','1','100','300.00',NULL,NULL,'3.00'),(31,'22','6','5','400.00',NULL,NULL,'80.00'),(32,'23','1','50','150.00',NULL,NULL,'3.00'),(33,'24','11','15','60.00',NULL,NULL,'4.00'),(34,'25','17','1062','1,062.00',NULL,NULL,'1.00'); /*!40000 ALTER TABLE `invoice_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `invoices` -- DROP TABLE IF EXISTS `invoices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `invoices` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `CustomerId` text COLLATE utf8mb4_unicode_ci NOT NULL, `CustomerName` text COLLATE utf8mb4_unicode_ci NOT NULL, `InvoiceNo` text COLLATE utf8mb4_unicode_ci NOT NULL, `Date` text COLLATE utf8mb4_unicode_ci NOT NULL, `Total` decimal(20,2) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `DueDate` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `invoices` -- LOCK TABLES `invoices` WRITE; /*!40000 ALTER TABLE `invoices` DISABLE KEYS */; INSERT INTO `invoices` VALUES (1,'1','Thangarasa Senthura','ETI1001','2019-12-16',20000.00,'2019-12-15 23:46:31','2019-12-15 23:46:31','2019-12-16'),(2,'1','Thangarasa Senthura','ETI1002','2019-12-16',4000.00,'2019-12-15 23:55:23','2019-12-15 23:55:23','2019-12-16'),(3,'3','Sarves','ETI1003','2019-12-25',5.50,'2019-12-25 09:23:39','2019-12-25 09:23:39','2019-12-25'),(5,'3','Sarves','ETI1005','2019-12-25',-0.25,'2019-12-25 10:10:40','2019-12-25 10:10:40','2019-12-25'),(7,'4','Kugeenthan','ETI1008','2019-12-25',4000.00,'2019-12-25 10:58:47','2019-12-25 10:58:47','2019-12-25'),(8,'4','Kugeenthan','ETI1009','2019-12-25',1680.00,'2019-12-25 11:08:49','2019-12-25 11:08:49','2019-12-25'),(9,'4','Kugeenthan','ETI1010','2019-12-25',60.00,'2019-12-25 11:09:58','2019-12-25 11:09:58','2019-12-25'),(10,'4','Kugeenthan','ETI1011','2019-12-25',4000.00,'2019-12-25 11:10:57','2019-12-25 11:10:57','2019-12-25'),(11,'4','Kugeenthan','ETI1012','2019-12-25',1135.00,'2019-12-25 11:12:58','2019-12-25 11:12:58','2019-12-25'),(12,'4','Kugeenthan','ETI1013','2019-12-25',4000.00,'2019-12-25 11:17:20','2019-12-25 11:17:20','2019-12-25'),(13,'4','Kugeenthan','ETI1014','2019-12-25',1800.00,'2019-12-25 11:27:08','2019-12-25 11:27:08','2019-12-25'),(14,'4','Kugeenthan','ETI1015','2019-12-25',5000.00,'2019-12-25 11:27:44','2019-12-25 11:27:44','2019-12-25'),(16,'3','Sarves','ETI1017','2019-12-27',270.00,'2019-12-27 00:38:56','2019-12-27 00:38:56','2019-12-27'),(17,'3','Sarves','ETI1018','2019-12-27',-270.00,'2019-12-27 00:40:26','2019-12-27 00:40:26','2019-12-27'),(18,'3','Sarves','ETI1019','2019-12-27',475.00,'2019-12-27 01:12:50','2019-12-27 01:12:50','2019-12-27'),(19,'3','Sarves','ETI1020','2019-12-27',475.00,'2019-12-27 01:12:51','2019-12-27 01:12:51','2019-12-27'),(20,'3','Sarves','ETI1021','2019-12-27',720.00,'2019-12-27 01:13:54','2019-12-27 01:13:54','2019-12-27'),(21,'10','Test User','ETI1022','2019-12-27',700.00,'2019-12-27 03:17:29','2019-12-27 03:17:29','2019-12-27'),(22,'10','Test User','ETI1023','2019-12-27',150.00,'2019-12-27 03:18:58','2019-12-27 03:18:58','2019-12-27'),(23,'10','Test User','ETI1024','2019-12-27',60.00,'2019-12-27 03:21:02','2019-12-27 03:21:02','2019-12-27'),(24,'7','Dinesh','ETI1025','2019-12-28',1062.00,'2019-12-28 13:01:35','2019-12-28 13:01:35','2019-12-28'); /*!40000 ALTER TABLE `invoices` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `invoicetransaction` -- DROP TABLE IF EXISTS `invoicetransaction`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `invoicetransaction` ( `id` int(11) NOT NULL AUTO_INCREMENT, `invoicetransaction` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `invoicetransaction` -- LOCK TABLES `invoicetransaction` WRITE; /*!40000 ALTER TABLE `invoicetransaction` DISABLE KEYS */; INSERT INTO `invoicetransaction` VALUES (1,'invoicetransaction'),(2,'invoicetransaction'),(3,'invoicetransaction'),(4,'invoicetransaction'),(5,'invoicetransaction'),(6,'invoicetransaction'),(7,'invoicetransaction'),(8,'invoicetransaction'),(9,'invoicetransaction'),(10,'invoicetransaction'),(11,'invoicetransaction'),(12,'invoicetransaction'),(13,'invoicetransaction'),(14,'invoicetransaction'),(15,'invoicetransaction'),(16,'invoicetransaction'),(17,'invoicetransaction'),(18,'invoicetransaction'),(19,'invoicetransaction'),(20,'invoicetransaction'),(21,'invoicetransaction'),(22,'invoicetransaction'),(23,'invoicetransaction'),(24,'invoicetransaction'),(25,'invoicetransaction'); /*!40000 ALTER TABLE `invoicetransaction` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `last_invoice_numbers` -- DROP TABLE IF EXISTS `last_invoice_numbers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `last_invoice_numbers` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `CustomerName` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1026 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `last_invoice_numbers` -- LOCK TABLES `last_invoice_numbers` WRITE; /*!40000 ALTER TABLE `last_invoice_numbers` DISABLE KEYS */; INSERT INTO `last_invoice_numbers` VALUES (1000,NULL,NULL,'customer'),(1001,NULL,NULL,'CustomerName'),(1002,NULL,NULL,'CustomerName'),(1003,NULL,NULL,'CustomerName'),(1004,NULL,NULL,'CustomerName'),(1005,NULL,NULL,'CustomerName'),(1006,NULL,NULL,'CustomerName'),(1007,NULL,NULL,'CustomerName'),(1008,NULL,NULL,'CustomerName'),(1009,NULL,NULL,'CustomerName'),(1010,NULL,NULL,'CustomerName'),(1011,NULL,NULL,'CustomerName'),(1012,NULL,NULL,'CustomerName'),(1013,NULL,NULL,'CustomerName'),(1014,NULL,NULL,'CustomerName'),(1015,NULL,NULL,'CustomerName'),(1016,NULL,NULL,'CustomerName'),(1017,NULL,NULL,'CustomerName'),(1018,NULL,NULL,'CustomerName'),(1019,NULL,NULL,'CustomerName'),(1020,NULL,NULL,'CustomerName'),(1021,NULL,NULL,'CustomerName'),(1022,NULL,NULL,'CustomerName'),(1023,NULL,NULL,'CustomerName'),(1024,NULL,NULL,'CustomerName'),(1025,NULL,NULL,'CustomerName'); /*!40000 ALTER TABLE `last_invoice_numbers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `last_payment_ids` -- DROP TABLE IF EXISTS `last_payment_ids`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `last_payment_ids` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `payment` text COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1017 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `last_payment_ids` -- LOCK TABLES `last_payment_ids` WRITE; /*!40000 ALTER TABLE `last_payment_ids` DISABLE KEYS */; INSERT INTO `last_payment_ids` VALUES (1000,'payment',NULL,NULL),(1001,'payment',NULL,NULL),(1002,'payment',NULL,NULL),(1003,'payment',NULL,NULL),(1004,'payment',NULL,NULL),(1005,'payment',NULL,NULL),(1006,'payment',NULL,NULL),(1007,'payment',NULL,NULL),(1008,'payment',NULL,NULL),(1009,'payment',NULL,NULL),(1010,'payment',NULL,NULL),(1011,'payment',NULL,NULL),(1012,'payment',NULL,NULL),(1013,'payment',NULL,NULL),(1014,'payment',NULL,NULL),(1015,'payment',NULL,NULL),(1016,'payment',NULL,NULL); /*!40000 ALTER TABLE `last_payment_ids` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `last_product_ids` -- DROP TABLE IF EXISTS `last_product_ids`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `last_product_ids` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ProductName` text COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1018 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `last_product_ids` -- LOCK TABLES `last_product_ids` WRITE; /*!40000 ALTER TABLE `last_product_ids` DISABLE KEYS */; INSERT INTO `last_product_ids` VALUES (1000,'product',NULL,NULL),(1001,'ProductName',NULL,NULL),(1002,'ProductName',NULL,NULL),(1003,'ProductName',NULL,NULL),(1004,'ProductName',NULL,NULL),(1005,'ProductName',NULL,NULL),(1006,'ProductName',NULL,NULL),(1007,'ProductName',NULL,NULL),(1008,'ProductName',NULL,NULL),(1009,'ProductName',NULL,NULL),(1010,'ProductName',NULL,NULL),(1011,'ProductName',NULL,NULL),(1012,'ProductName',NULL,NULL),(1013,'ProductName',NULL,NULL),(1014,'ProductName',NULL,NULL),(1015,'ProductName',NULL,NULL),(1016,'ProductName',NULL,NULL),(1017,'ProductName',NULL,NULL); /*!40000 ALTER TABLE `last_product_ids` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2019_09_11_105343_create_products_table',2),(3,'2019_09_11_154151_create_customers_table',3),(4,'2019_09_12_044130_create_transactions_table',4),(5,'2019_09_14_061422_create_customer_last_ids_table',5),(6,'2019_09_15_052130_create_payments_table',6),(7,'2019_10_12_104340_create_invoices_table',7),(8,'2019_10_12_105207_create_invoice_items_table',7),(9,'2019_10_17_053544_create_last_invoice_numbers_table',8),(10,'2019_10_29_100415_create_last_product_ids_table',9),(11,'2019_10_29_153459_create_payment_last_nos_table',10),(12,'2019_10_29_153527_create_transaction_last_nos_table',10),(13,'2019_10_29_154131_create_payment_last_ids_table',11),(14,'2019_10_29_154157_create_transaction_last_ids_table',11),(15,'2019_10_29_161726_create_last_payment_ids_table',12),(16,'2019_11_15_040647_create_generals_table',13),(17,'2019_12_14_150657_create_tests_table',14); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payments` -- DROP TABLE IF EXISTS `payments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `payments` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `CustomerId` text COLLATE utf8mb4_unicode_ci, `Description` text COLLATE utf8mb4_unicode_ci, `Date` text COLLATE utf8mb4_unicode_ci, `Amount` decimal(20,2) DEFAULT NULL, `PaymentType` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `PaymentNo` text COLLATE utf8mb4_unicode_ci, `CustomerName` text COLLATE utf8mb4_unicode_ci, `PaymentMethod` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payments` -- LOCK TABLES `payments` WRITE; /*!40000 ALTER TABLE `payments` DISABLE KEYS */; INSERT INTO `payments` VALUES (1,'1',NULL,'2019-12-16',30000.00,'Discount','2019-12-15 23:48:09','2019-12-15 23:48:09','ETP1','Thangarasa Senthura','Paypal'),(2,'4',NULL,'2019-12-25',2500.00,'Payment','2019-12-25 10:56:31','2019-12-25 10:56:31','ETP1002','Kugeenthan','E-Transfer'),(3,'4',NULL,'2019-12-25',2250.00,'Payment','2019-12-25 10:57:35','2019-12-25 10:57:35','ETP1003','Kugeenthan','Cash'),(4,'4',NULL,'2019-12-25',1600.00,'Payment','2019-12-25 10:59:31','2019-12-25 10:59:31','ETP1004','Kugeenthan','E-Transfer'),(5,'4',NULL,'2019-12-25',1420.00,'Payment','2019-12-25 11:09:21','2019-12-25 11:09:21','ETP1005','Kugeenthan','Cash'),(6,'4',NULL,'2019-12-25',1600.00,'Payment','2019-12-25 11:11:31','2019-12-25 11:11:31','ETP1006','Kugeenthan','Cash'),(7,'4',NULL,'2019-12-25',190.00,'Owing','2019-12-25 11:14:01','2019-12-25 11:14:01','ETP1007','Kugeenthan','Cash'),(8,'4',NULL,'2019-12-25',1600.00,'Payment','2019-12-25 11:15:23','2019-12-25 11:15:23','ETP1008','Kugeenthan','E-Transfer'),(9,'4',NULL,'2019-12-25',1900.00,'Payment','2019-12-25 11:16:03','2019-12-25 11:16:03','ETP1009','Kugeenthan','Cash'),(10,'4',NULL,'2019-12-25',900.00,'Payment','2019-12-25 11:16:25','2019-12-25 11:16:25','ETP1010','Kugeenthan','E-Transfer'),(11,'4',NULL,'2019-12-25',2500.00,'Payment','2019-12-25 11:17:46','2019-12-25 11:17:46','ETP1011','Kugeenthan','Cash'),(12,'4',NULL,'2019-12-25',1500.00,'Payment','2019-12-25 11:18:14','2019-12-25 11:18:14','ETP1012','Kugeenthan','Cash'),(13,'4',NULL,'2019-12-25',393.00,'Payment','2019-12-25 11:31:19','2019-12-25 11:31:19','ETP1013','Kugeenthan','Paypal'),(14,'4',NULL,'2019-12-25',685.00,'Payment','2019-12-25 11:36:45','2019-12-25 11:36:45','ETP1014','Kugeenthan','Paypal'),(15,'7',NULL,'2019-12-27',900.00,'Payment','2019-12-27 16:22:16','2019-12-27 16:22:16','ETP1015','Dinesh','E-Transfer'),(16,'7',NULL,'2019-12-27',1000.00,'Payment','2019-12-27 18:53:08','2019-12-27 18:53:08','ETP1016','Dinesh','E-Transfer'); /*!40000 ALTER TABLE `payments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `paymenttransaction` -- DROP TABLE IF EXISTS `paymenttransaction`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `paymenttransaction` ( `id` int(11) NOT NULL AUTO_INCREMENT, `paymenttransaction` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `paymenttransaction` -- LOCK TABLES `paymenttransaction` WRITE; /*!40000 ALTER TABLE `paymenttransaction` DISABLE KEYS */; INSERT INTO `paymenttransaction` VALUES (1,'invoicetransaction'),(2,'invoicetransaction'),(3,'invoicetransaction'),(4,'invoicetransaction'),(5,'invoicetransaction'),(6,'invoicetransaction'),(7,'invoicetransaction'),(8,'invoicetransaction'),(9,'invoicetransaction'),(10,'invoicetransaction'),(11,'invoicetransaction'),(12,'invoicetransaction'),(13,'invoicetransaction'),(14,'invoicetransaction'),(15,'invoicetransaction'),(16,'invoicetransaction'); /*!40000 ALTER TABLE `paymenttransaction` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `products` -- DROP TABLE IF EXISTS `products`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `products` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `Name` text COLLATE utf8mb4_unicode_ci, `Description` text COLLATE utf8mb4_unicode_ci, `Price` decimal(20,2) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `ProductNo` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `products` -- LOCK TABLES `products` WRITE; /*!40000 ALTER TABLE `products` DISABLE KEYS */; INSERT INTO `products` VALUES (1,'Admin Super Reseller Credit','Admin Super Reseller Credit',3.00,'2019-12-15 23:45:23','2019-12-25 09:33:55','EP1001'),(2,'Main Super Reseller Credit 4.75','Main Super Reseller Credit 4.75',4.75,'2019-12-19 04:34:17','2019-12-25 09:53:14','EP1002'),(3,'Main Super Reseller Credit 5.00','Main Super Reseller Credit 5.00',5.00,'2019-12-19 04:35:19','2019-12-25 09:55:22','EP1003'),(4,'Reseller Credit 5.50','Reseller Credit 5.50',5.50,'2019-12-19 04:35:57','2019-12-25 09:58:01','EP1004'),(5,'Box - Mag322','Box - Mag322',72.00,'2019-12-25 09:37:10','2019-12-25 09:41:52','EP1005'),(6,'Box - Mag322 w1','Box - Mag322 w1',80.00,'2019-12-25 09:42:49','2019-12-27 00:26:07','EP1006'),(7,'Box - Mag324 w2','Box - Mag324 w2',105.00,'2019-12-25 09:43:48','2019-12-25 09:43:48','EP1007'),(8,'Box - Mag420 w1','Box - Mag420 w1',115.00,'2019-12-25 09:45:19','2019-12-25 09:45:19','EP1008'),(9,'Ipguys','Ipguys',6.00,'2019-12-25 10:01:30','2019-12-25 10:01:30','EP1009'),(10,'Reseller Credit 6.00','Reseller Credit 6.00',6.00,'2019-12-25 10:03:46','2019-12-25 10:21:33','EP1010'),(11,'Reseller Credit 4.00','Reseller Credit 4.00',4.00,'2019-12-25 10:31:15','2019-12-25 10:31:15','EP1011'),(12,'Remote 5.00','Remote 5.00',5.00,'2019-12-25 10:37:12','2019-12-25 10:37:53','EP1012'),(13,'Remote 10.00','Rermote 10.00',10.00,'2019-12-25 10:37:41','2019-12-25 10:37:41','EP1013'),(14,'Wifi Ext','Wifi Ext',25.00,'2019-12-25 10:38:20','2019-12-25 10:38:20','EP1014'),(15,'Wifi USB','Wifi USB',10.00,'2019-12-25 10:38:50','2019-12-25 10:38:50','EP1015'),(16,'Formuler Z7','Formuler Z7',95.00,'2019-12-27 00:25:00','2019-12-27 00:25:00','EP1016'),(17,'Patel - Nov 19th - Dec 25th','Patel - Nov 19th - Dec 25th',1.00,'2019-12-28 12:59:40','2019-12-28 12:59:40','EP1017'); /*!40000 ALTER TABLE `products` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tests` -- DROP TABLE IF EXISTS `tests`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tests` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `Name` text COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tests` -- LOCK TABLES `tests` WRITE; /*!40000 ALTER TABLE `tests` DISABLE KEYS */; INSERT INTO `tests` VALUES (1,'senthu',NULL,NULL),(2,'saran',NULL,NULL); /*!40000 ALTER TABLE `tests` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `transaction_last_ids` -- DROP TABLE IF EXISTS `transaction_last_ids`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `transaction_last_ids` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `transaction` text COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1051 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `transaction_last_ids` -- LOCK TABLES `transaction_last_ids` WRITE; /*!40000 ALTER TABLE `transaction_last_ids` DISABLE KEYS */; INSERT INTO `transaction_last_ids` VALUES (1000,'transaction',NULL,NULL),(1001,'transaction',NULL,NULL),(1002,'transaction',NULL,NULL),(1003,'transaction',NULL,NULL),(1004,'transaction',NULL,NULL),(1005,'transaction',NULL,NULL),(1006,'transaction',NULL,NULL),(1007,'transaction',NULL,NULL),(1008,'transaction',NULL,NULL),(1009,'transaction',NULL,NULL),(1010,'transaction',NULL,NULL),(1011,'transaction',NULL,NULL),(1012,'transaction',NULL,NULL),(1013,'transaction',NULL,NULL),(1014,'transaction',NULL,NULL),(1015,'transaction',NULL,NULL),(1016,'transaction',NULL,NULL),(1017,'transaction',NULL,NULL),(1018,'transaction',NULL,NULL),(1019,'transaction',NULL,NULL),(1020,'transaction',NULL,NULL),(1021,'transaction',NULL,NULL),(1022,'transaction',NULL,NULL),(1023,'transaction',NULL,NULL),(1024,'transaction',NULL,NULL),(1025,'transaction',NULL,NULL),(1026,'transaction',NULL,NULL),(1027,'transaction',NULL,NULL),(1028,'transaction',NULL,NULL),(1029,'transaction',NULL,NULL),(1030,'transaction',NULL,NULL),(1031,'transaction',NULL,NULL),(1032,'transaction',NULL,NULL),(1033,'transaction',NULL,NULL),(1034,'transaction',NULL,NULL),(1035,'transaction',NULL,NULL),(1036,'transaction',NULL,NULL),(1037,'transaction',NULL,NULL),(1038,'transaction',NULL,NULL),(1039,'transaction',NULL,NULL),(1040,'transaction',NULL,NULL),(1041,'transaction',NULL,NULL),(1042,'transaction',NULL,NULL),(1043,'transaction',NULL,NULL),(1044,'transaction',NULL,NULL),(1045,'transaction',NULL,NULL),(1046,'transaction',NULL,NULL),(1047,'transaction',NULL,NULL),(1048,'transaction',NULL,NULL),(1049,'transaction',NULL,NULL),(1050,'transaction',NULL,NULL); /*!40000 ALTER TABLE `transaction_last_ids` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `transactions` -- DROP TABLE IF EXISTS `transactions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `transactions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `TraNo` text COLLATE utf8mb4_unicode_ci, `CustomerId` text COLLATE utf8mb4_unicode_ci, `Description` text COLLATE utf8mb4_unicode_ci, `Date` text COLLATE utf8mb4_unicode_ci, `Debit` decimal(20,2) DEFAULT NULL, `Credit` decimal(20,2) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `InvoiceTransaction` text COLLATE utf8mb4_unicode_ci, `TransactionNo` text COLLATE utf8mb4_unicode_ci, `PaymentTransaction` text COLLATE utf8mb4_unicode_ci, `TransactionType` text COLLATE utf8mb4_unicode_ci, `OpeningTransaction` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `transactions` -- LOCK TABLES `transactions` WRITE; /*!40000 ALTER TABLE `transactions` DISABLE KEYS */; INSERT INTO `transactions` VALUES (6,NULL,'3','Opening Balance','2019-12-25',0.00,0.00,'2019-12-25 09:21:52','2019-12-25 09:21:52',NULL,'ETT1006',NULL,'OBL','3'),(7,NULL,'3','Invoice->(ETI1003)','2019-12-25',0.00,5.50,'2019-12-25 09:23:39','2019-12-25 09:23:39','3','ETT1007',NULL,'INV',NULL),(9,NULL,'3','Invoice->(ETI1005)','2019-12-25',0.00,-0.25,'2019-12-25 10:10:40','2019-12-25 10:10:40','5','ETT1009',NULL,'INV',NULL),(10,NULL,'4','Opening Balance','2019-12-25',0.00,24250.00,'2019-12-25 10:36:41','2019-12-25 10:36:41',NULL,'ETT1010',NULL,'OBL','4'),(12,NULL,'4','Payment->(ETP1002)','2019-12-25',2500.00,0.00,'2019-12-25 10:56:31','2019-12-25 10:56:31',NULL,'ETT1012','2','PAY',NULL),(13,NULL,'4','Payment->(ETP1003)','2019-12-25',2250.00,0.00,'2019-12-25 10:57:35','2019-12-25 10:57:35',NULL,'ETT1013','3','PAY',NULL),(14,NULL,'4','Invoice->(ETI1008)','2019-12-25',0.00,4000.00,'2019-12-25 10:58:47','2019-12-25 10:58:47','8','ETT1014',NULL,'INV',NULL),(15,NULL,'4','Payment->(ETP1004)','2019-12-25',1600.00,0.00,'2019-12-25 10:59:31','2019-12-25 10:59:31',NULL,'ETT1015','4','PAY',NULL),(16,NULL,'4','Invoice->(ETI1009)','2019-12-25',0.00,1680.00,'2019-12-25 11:08:49','2019-12-25 11:08:49','9','ETT1016',NULL,'INV',NULL),(17,NULL,'4','Payment->(ETP1005)','2019-12-25',1420.00,0.00,'2019-12-25 11:09:21','2019-12-25 11:09:21',NULL,'ETT1017','5','PAY',NULL),(18,NULL,'4','Invoice->(ETI1010)','2019-12-25',0.00,60.00,'2019-12-25 11:09:58','2019-12-25 11:09:58','10','ETT1018',NULL,'INV',NULL),(19,NULL,'4','Invoice->(ETI1011)','2019-12-25',0.00,4000.00,'2019-12-25 11:10:57','2019-12-25 11:10:57','11','ETT1019',NULL,'INV',NULL),(20,NULL,'4','Payment->(ETP1006)','2019-12-25',1600.00,0.00,'2019-12-25 11:11:31','2019-12-25 11:11:31',NULL,'ETT1020','6','PAY',NULL),(21,NULL,'4','Invoice->(ETI1012)','2019-12-25',0.00,1135.00,'2019-12-25 11:12:58','2019-12-25 11:12:58','12','ETT1021',NULL,'INV',NULL),(22,NULL,'4','Owing->(ETP1007)','2019-12-25',190.00,0.00,'2019-12-25 11:14:01','2019-12-25 11:14:01',NULL,'ETT1022','7','PAY',NULL),(23,NULL,'4','Payment->(ETP1008)','2019-12-25',1600.00,0.00,'2019-12-25 11:15:23','2019-12-25 11:15:23',NULL,'ETT1023','8','PAY',NULL),(24,NULL,'4','Payment->(ETP1009)','2019-12-25',1900.00,0.00,'2019-12-25 11:16:03','2019-12-25 11:16:03',NULL,'ETT1024','9','PAY',NULL),(25,NULL,'4','Payment->(ETP1010)','2019-12-25',900.00,0.00,'2019-12-25 11:16:25','2019-12-25 11:16:25',NULL,'ETT1025','10','PAY',NULL),(26,NULL,'4','Invoice->(ETI1013)','2019-12-25',0.00,4000.00,'2019-12-25 11:17:20','2019-12-25 11:17:20','13','ETT1026',NULL,'INV',NULL),(27,NULL,'4','Payment->(ETP1011)','2019-12-25',2500.00,0.00,'2019-12-25 11:17:46','2019-12-25 11:17:46',NULL,'ETT1027','11','PAY',NULL),(28,NULL,'4','Payment->(ETP1012)','2019-12-25',1500.00,0.00,'2019-12-25 11:18:14','2019-12-25 11:18:14',NULL,'ETT1028','12','PAY',NULL),(29,NULL,'4','Invoice->(ETI1014)','2019-12-25',0.00,1800.00,'2019-12-25 11:27:08','2019-12-25 11:27:08','14','ETT1029',NULL,'INV',NULL),(39,NULL,'3','Invoice->(ETI1017)','2019-12-27',0.00,270.00,'2019-12-27 00:38:56','2019-12-27 00:38:56','17','ETT1039',NULL,'INV',NULL),(31,NULL,'4','Payment->(ETP1013)','2019-12-25',393.00,0.00,'2019-12-25 11:31:19','2019-12-25 11:31:19',NULL,'ETT1031','13','PAY',NULL),(32,NULL,'4','Payment->(ETP1014)','2019-12-25',685.00,0.00,'2019-12-25 11:36:45','2019-12-25 11:36:45',NULL,'ETT1032','14','PAY',NULL),(33,NULL,'5','Opening Balance','2019-12-25',0.00,12573.00,'2019-12-25 13:14:36','2019-12-25 13:14:36',NULL,'ETT1033',NULL,'OBL','5'),(34,NULL,'6','Opening Balance','2019-12-25',0.00,10124.00,'2019-12-25 14:18:53','2019-12-25 14:18:53',NULL,'ETT1034',NULL,'OBL','6'),(35,NULL,'7','Opening Balance','2019-12-25',0.00,45968.75,'2019-12-25 19:00:35','2019-12-25 19:00:35',NULL,'ETT1035',NULL,'OBL','7'),(36,NULL,'8','Opening Balance','2019-12-26',0.00,3487.50,'2019-12-26 00:07:57','2019-12-26 00:07:57',NULL,'ETT1036',NULL,'OBL','8'),(37,NULL,'9','Opening Balance','2019-12-26',0.00,960.00,'2019-12-26 11:02:37','2019-12-26 11:02:37',NULL,'ETT1037',NULL,'OBL','9'),(38,NULL,'9','Invoice->(ETI1016)','2019-12-27',0.00,-175.00,'2019-12-27 00:26:52','2019-12-27 00:26:52','16','ETT1038',NULL,'INV',NULL),(40,NULL,'3','Invoice->(ETI1018)','2019-12-27',0.00,-270.00,'2019-12-27 00:40:26','2019-12-27 00:40:26','18','ETT1040',NULL,'INV',NULL),(41,NULL,'3','Invoice->(ETI1019)','2019-12-27',0.00,475.00,'2019-12-27 01:12:50','2019-12-27 01:12:50','19','ETT1041',NULL,'INV',NULL),(42,NULL,'3','Invoice->(ETI1020)','2019-12-27',0.00,475.00,'2019-12-27 01:12:51','2019-12-27 01:12:51','20','ETT1042',NULL,'INV',NULL),(43,NULL,'3','Invoice->(ETI1021)','2019-12-27',0.00,720.00,'2019-12-27 01:13:54','2019-12-27 01:13:54','21','ETT1043',NULL,'INV',NULL),(44,NULL,'10','Opening Balance','2019-12-27',0.00,75.00,'2019-12-27 03:16:27','2019-12-27 03:16:27',NULL,'ETT1044',NULL,'OBL','10'),(45,NULL,'10','Invoice->(ETI1022)','2019-12-27',0.00,700.00,'2019-12-27 03:17:29','2019-12-27 03:17:29','22','ETT1045',NULL,'INV',NULL),(46,NULL,'10','Invoice->(ETI1023)','2019-12-27',0.00,150.00,'2019-12-27 03:18:58','2019-12-27 03:18:58','23','ETT1046',NULL,'INV',NULL),(47,NULL,'10','Invoice->(ETI1024)','2019-12-27',0.00,60.00,'2019-12-27 03:21:02','2019-12-27 03:21:02','24','ETT1047',NULL,'INV',NULL),(48,NULL,'7','Payment->(ETP1015)','2019-12-27',900.00,0.00,'2019-12-27 16:22:16','2019-12-27 16:22:16',NULL,'ETT1048','15','PAY',NULL),(49,NULL,'7','Payment->(ETP1016)','2019-12-27',1000.00,0.00,'2019-12-27 18:53:08','2019-12-27 18:53:08',NULL,'ETT1049','16','PAY',NULL),(50,NULL,'7','Invoice->(ETI1025)','2019-12-28',0.00,1062.00,'2019-12-28 13:01:35','2019-12-28 13:01:35','25','ETT1050',NULL,'INV',NULL); /*!40000 ALTER TABLE `transactions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `remember_token` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'Sarvesh','spoopalasingam@gmail.com','$2y$10$3.ivAvPH8O27ZvU0BUZ4gOXRd0y67m8goHmxvkBzdO6erD7SXjWEW','2019-09-11 05:30:11','2019-12-19 04:31:15','y6B4U0Dj5MnLOLcYDDGB7VA7EYEV6LOpBVKe8bx05oNr8rwrWg8RxU7D8WtU'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2019-12-29 5:08:52