ÿØÿà 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ÿÙ -- phpMyAdmin SQL Dump -- version 4.8.5 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1:3306 -- Generation Time: Jan 20, 2020 at 02:52 PM -- Server version: 5.7.26 -- PHP Version: 7.2.18 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; 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: `invoicemanagement1` -- -- -------------------------------------------------------- -- -- Table structure for table `customers` -- DROP TABLE IF EXISTS `customers`; CREATE TABLE IF NOT EXISTS `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 NULL, `CurrentBalance` decimal(20,2) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `customers` -- INSERT INTO `customers` (`id`, `Name`, `AccNo`, `Email`, `PhoneNo`, `Address`, `Debit`, `Credit`, `CreatedDate`, `Username`, `Password`, `created_at`, `updated_at`, `OpeningBalance`, `CurrentBalance`) VALUES (4, 'Thangarasa Senthura', 'ETC1006', 'senthusenthura@gmail.com', '0757576458', 'Jaffna, Jaffna', NULL, NULL, '2020-01-18', 'senthuvs8', 'senthu@1212', '2020-01-18 01:51:02', '2020-01-19 00:10:34', '2000.00', '15000.00'); -- -------------------------------------------------------- -- -- Table structure for table `customer_last_ids` -- DROP TABLE IF EXISTS `customer_last_ids`; CREATE TABLE IF NOT EXISTS `customer_last_ids` ( `id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `customer_last_ids` -- INSERT INTO `customer_last_ids` (`id`) VALUES (1007); -- -------------------------------------------------------- -- -- Table structure for table `generals` -- DROP TABLE IF EXISTS `generals`; CREATE TABLE IF NOT EXISTS `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, `Prefix` text COLLATE utf8mb4_unicode_ci, `ThemeColor` text COLLATE utf8mb4_unicode_ci, `BgImage` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `generals` -- INSERT INTO `generals` (`id`, `CustomerName`, `CompanyName`, `Address`, `Email`, `PhoneNo`, `Currency`, `created_at`, `updated_at`, `LogoImage`, `Prefix`, `ThemeColor`, `BgImage`) VALUES (1, 'Thangarasa Senthura', 'Eagle Tv', 'Post Office Road, Chavakachchery, Jaffna', 'senthusenthura@gmail.com', '0767653216', '$', NULL, '2020-01-07 02:56:14', 'LogoImage202001050917110000001578215831.jpg', 'ET', '#191d4d', 'BgImage202001070826140000001578385574.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `invoices` -- DROP TABLE IF EXISTS `invoices`; CREATE TABLE IF NOT EXISTS `invoices` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `CustomerId` int(11) 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(10,2) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `DueDate` text COLLATE utf8mb4_unicode_ci, `InvoiceNote` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `invoices` -- INSERT INTO `invoices` (`id`, `CustomerId`, `CustomerName`, `InvoiceNo`, `Date`, `Total`, `created_at`, `updated_at`, `DueDate`, `InvoiceNote`) VALUES (13, 4, 'Thangarasa Senthura', 'ETI1046', '2020-01-19', '12000.00', '2020-01-19 00:10:27', '2020-01-19 00:10:27', '2020-01-19', 'N/A'), (11, 4, 'Thangarasa Senthura', 'ETI1044', '2020-01-18', '2000.00', '2020-01-18 09:26:57', '2020-01-18 09:26:57', '2020-01-18', 'N/A'), (12, 4, 'Thangarasa Senthura', 'ETI1045', '2020-01-19', '4000.00', '2020-01-19 00:06:02', '2020-01-19 00:06:02', '2020-01-19', 'N/A'); -- -------------------------------------------------------- -- -- Table structure for table `invoice_items` -- DROP TABLE IF EXISTS `invoice_items`; CREATE TABLE IF NOT EXISTS `invoice_items` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `InvoiceId` int(11) NOT NULL, `ProductId` int(11) NOT NULL, `Quantity` int(11) NOT NULL, `SubTotal` decimal(10,2) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `Price` decimal(10,2) NOT NULL, `CustomerId` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `invoice_items` -- INSERT INTO `invoice_items` (`id`, `InvoiceId`, `ProductId`, `Quantity`, `SubTotal`, `created_at`, `updated_at`, `Price`, `CustomerId`) VALUES (13, 12, 3, 1, '2000.00', NULL, NULL, '2000.00', 4), (12, 12, 3, 1, '2000.00', NULL, NULL, '2000.00', 4), (11, 11, 1, 1, '2000.00', NULL, NULL, '2000.00', 4), (14, 13, 3, 1, '2000.00', NULL, NULL, '2000.00', 4), (15, 13, 3, 5, '10000.00', NULL, NULL, '2000.00', 4); -- -------------------------------------------------------- -- -- Table structure for table `last_invoice_numbers` -- DROP TABLE IF EXISTS `last_invoice_numbers`; CREATE TABLE IF NOT EXISTS `last_invoice_numbers` ( `id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `last_invoice_numbers` -- INSERT INTO `last_invoice_numbers` (`id`) VALUES (1047); -- -------------------------------------------------------- -- -- Table structure for table `last_payment_ids` -- DROP TABLE IF EXISTS `last_payment_ids`; CREATE TABLE IF NOT EXISTS `last_payment_ids` ( `id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `last_payment_ids` -- INSERT INTO `last_payment_ids` (`id`) VALUES (1014); -- -------------------------------------------------------- -- -- Table structure for table `last_product_ids` -- DROP TABLE IF EXISTS `last_product_ids`; CREATE TABLE IF NOT EXISTS `last_product_ids` ( `id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `last_product_ids` -- INSERT INTO `last_product_ids` (`id`) VALUES (1004); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; CREATE TABLE IF NOT EXISTS `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; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) 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); -- -------------------------------------------------------- -- -- Table structure for table `payments` -- DROP TABLE IF EXISTS `payments`; CREATE TABLE IF NOT EXISTS `payments` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `CustomerId` int(11) DEFAULT NULL, `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, `PaymentNote` text COLLATE utf8mb4_unicode_ci, `InvoiceId` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `payments` -- INSERT INTO `payments` (`id`, `CustomerId`, `Description`, `Date`, `Amount`, `PaymentType`, `created_at`, `updated_at`, `PaymentNo`, `CustomerName`, `PaymentMethod`, `PaymentNote`, `InvoiceId`) VALUES (7, 4, NULL, '2020-01-18', '5000.00', 'Payment', '2020-01-18 09:27:10', '2020-01-18 09:27:10', 'ETP1013', 'Thangarasa Senthura', 'Cash', 'N/A', 11); -- -------------------------------------------------------- -- -- Table structure for table `products` -- DROP TABLE IF EXISTS `products`; CREATE TABLE IF NOT EXISTS `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=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `products` -- INSERT INTO `products` (`id`, `Name`, `Description`, `Price`, `created_at`, `updated_at`, `ProductNo`) VALUES (1, 'Product 01', 'It is a good product', '2000.00', '2019-12-29 04:35:14', '2019-12-29 04:35:14', 'EP1001'), (2, 'Product 02', 'This is a good product', '4500.00', '2019-12-29 04:35:34', '2019-12-29 04:35:34', 'EP1002'), (3, 'Product 03', 'It is a good product', '2000.00', '2019-12-29 04:36:09', '2019-12-29 04:36:09', 'EP1003'); -- -------------------------------------------------------- -- -- Table structure for table `tests` -- DROP TABLE IF EXISTS `tests`; CREATE TABLE IF NOT EXISTS `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; -- -- Dumping data for table `tests` -- INSERT INTO `tests` (`id`, `Name`, `created_at`, `updated_at`) VALUES (1, 'senthu', NULL, NULL), (2, 'saran', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `transactions` -- DROP TABLE IF EXISTS `transactions`; CREATE TABLE IF NOT EXISTS `transactions` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `CustomerId` int(11) DEFAULT NULL, `Description` text COLLATE utf8mb4_unicode_ci, `Date` text COLLATE utf8mb4_unicode_ci, `Debit` decimal(10,2) DEFAULT NULL, `Credit` decimal(10,2) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `InvoiceTransaction` int(11) DEFAULT NULL, `TransactionNo` text COLLATE utf8mb4_unicode_ci, `PaymentTransaction` int(11) DEFAULT NULL, `TransactionType` text COLLATE utf8mb4_unicode_ci, `OpeningTransaction` int(11) DEFAULT NULL, `Note` varchar(3000) COLLATE utf8mb4_unicode_ci DEFAULT 'N/A', `InvoicePayment` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `transactions` -- INSERT INTO `transactions` (`id`, `CustomerId`, `Description`, `Date`, `Debit`, `Credit`, `created_at`, `updated_at`, `InvoiceTransaction`, `TransactionNo`, `PaymentTransaction`, `TransactionType`, `OpeningTransaction`, `Note`, `InvoicePayment`) VALUES (21, 4, 'Invoice->(ETI1044)', '2020-01-18', '0.00', '2000.00', '2020-01-18 09:26:57', '2020-01-18 09:26:57', 11, 'ETT1062', NULL, 'INV', NULL, 'N/A', NULL), (22, 4, 'Payment->(ETP1013)', '2020-01-18', '5000.00', '0.00', '2020-01-18 09:27:10', '2020-01-18 09:27:10', NULL, 'ETT1063', 7, 'PAY', NULL, 'N/A', 11), (13, 4, 'Opening Balance', '2020-01-18', '0.00', '2000.00', '2020-01-18 01:51:02', '2020-01-18 01:51:02', NULL, 'ETT1054', NULL, 'OBL', 4, 'N/A', NULL), (23, 4, 'Invoice->(ETI1045)', '2020-01-19', '0.00', '4000.00', '2020-01-19 00:06:02', '2020-01-19 00:06:02', 12, 'ETT1064', NULL, 'INV', NULL, 'N/A', NULL), (24, 4, 'Invoice->(ETI1046)', '2020-01-19', '0.00', '12000.00', '2020-01-19 00:10:27', '2020-01-19 00:10:27', 13, 'ETT1065', NULL, 'INV', NULL, 'N/A', NULL); -- -------------------------------------------------------- -- -- Table structure for table `transaction_last_ids` -- DROP TABLE IF EXISTS `transaction_last_ids`; CREATE TABLE IF NOT EXISTS `transaction_last_ids` ( `id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `transaction_last_ids` -- INSERT INTO `transaction_last_ids` (`id`) VALUES (1066); -- -------------------------------------------------------- -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; CREATE TABLE IF NOT EXISTS `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; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `password`, `created_at`, `updated_at`, `remember_token`) VALUES (1, 'senthu', 'senthusenthura@gmail.com', '$2y$10$Aw8pTvdyGiu5Vz.kfGTrQO/.kheeazRTJy00y/dzhwTgxDmQHgsyC', '2019-09-11 05:30:11', '2019-11-14 10:55:00', 'qR9gi62OsFJmvv4VpnlZlxMdYPlhrhpF2MwSOvnAc43li4jo5yNS17twAiqG'); 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 */;