db/db design.mwb000064400000027657150247310640007502 0ustar00PKGUZQ)n&szdocument.mwb.xml}YsCD@}ֹ:H}"UV/t/hݤH(z`O(KBv/@~忿G'ټN =ş~fb8=pt2߮ߧOgd0=->^hMNrl~m~I1c!I&xZ 6>͗??_"\tM/A6zy"NCU1+ ]s1$"v6ײ׺hwz60RAР-jyTz0,br+"e.+AEE+|18a ) me=-}g_T5?\?_L.6ً_~Z>*&M_g72꿨6xwkϺ0o./oIiko?}ͻP=t~z6u}+;Z9M29`1n\*>DF* Ϟ=тn Xc5bHk!q6$k܈^gcPyWӋP_g7w薭*t;l|%kqajL  8SPiDg0Ⱦy7].ɝztopطitWZz8((/\+2|U MVO|XjZ+ɻj2\]=X}Fם(?Ͽ3ZV2j.991Jn0Jl,Ö@8e[tWd/M';El³pf:;-ǓkV_[;,n+< }d2)s;ٵr1}9UJc21;{Tcܘ-aޯƍ,)sGc6|>_WNVЖ#mce{TզQVuk{bP,fd<[+<-r4< |S.zf<ڸVа}4Aݦ"1ȫ4?N_a<{17s6<7g"*v;g3l('':#@FJ}l2uP_Uґm#V0q &@[p0mqQ%8)R8LL4+4\@E3?͆b!MEIDž*p0%[) T(%РQB>'4+2аgh?b?6 FZ:l:.P@ch@ XE%P#(j@,bŦ[@#;h0bVo 0Z/nJRA~_A1$PL؆洼\l GM5YGm=R` )O[{żKgkzy%PISb(&GsrDL)1QRbˈ X.xkzIB„MpY#a59O x'f׏_4q?,F_ϊEJktV,/.&Qku`s&hr2̿^;ɰܠD" ʭ2H ׌\@;xgHI5>obGMuW[&=}7i$D"cx `#vxF{4}JdAj7X|2lI*ޙ <>7_Tov?V.fUCpl"|Q_rn4 f4|z_;o52\.Z$ocX^!/Gb^[Iv'wY1*Wm:t5XwLbvVU][Y+=_˼q~|fja}.&Mqd`NF|1IGܻ䢖vi<ɨܫ u0AX0ܧʬ:Ug_M̛gI6~r{/0ɿ.zeli4ȱ.٢(N54vrd龖fڵ62|P߲p6Pƺv yOˬutfY16>FƼ0~ 8keyl4h#m>G<Z,E÷EY5+^薠vf{[R{[^y֋'$*r2:\[>Q$u$fE6JUM6#l4kF Sj('XJE8]^vvշYǗbߋqD0} ԷMLq}'P1B6o͡!q3X0FQPZ)/oV?nwJľށp6XXVXXEU#HH*ͧSvgEL7Fich&QR&pyǑqd$'R,B˹YҤN==$Jg:8tV\<Ыþ@qPDmC퀎0~i×L%jθV6\Q|D2C XE͢3.VG#G>ь#cEqcG3*84uUU*x|D,>%>GO##RPGYGR'\)D#EM-G #z@`1$6O̕O7R`M#R"u]:-_S̈K1c_bƺ3!G#` 2*VɩP{+1~$8\!*''t@8 b'mSpc%Oc,~˿=TԞQ:vDG;"{;֘=ѠwO,M4GNrS:Ѡ'DhU~D~4gѠF' 2GѧHl҇ؤkuh ӊsdo) # BLJQ1L{0mh0H{\@!CPY='֐DrubY yb>V)$*"@rB T  (Kc& B { HDīx54~m:d@WbG sB`X>aH`S0ļ?`IqLQt1GZn" Yyׂ1{ (`p0t^/qA`b.򯏾&ZW̊PXCq("DAOFOۄ}D.] K&~&} 4ie ( h 'YzX/KyʁFe5G+@ĀxƦ'[z^.=d<'*E@XB",j2UjIVȫ[F9M}CmOeli[tǴQF]a Y1?=;UGpi۱Tm)WT+aV?5@3U0=Mn3m(DKPd("FcBR縋ͮm*U=mnJY6ۧQqi6.yf#J)!c,*#E1P<5w8J"XlcG,H1E-"ŗG8>:i1bG$D;6ɉ+7qv͕ "q9WnĕrWn=$$c͸r\ro6O]I?AxX`<$HYE=2]z + z@sbnN .k-P81*(TӪ nϪ᝷JAKb;0S@I0@Z*D>D$%ơC"&dSS2Zb &!5  $h2da}{* >!Z4KAXY֑%BZOCY˯وe,ƛTBjLcI0it@eۚpCJ E1ySG0Ip=]Ge^0a}8]1&&)N2?,o"p)u nC t԰=ĒmQǿeX*zwxxWsE,N1FPju?xA=}@N[ {(50 BicOĻۉw[#>!x޳_EluK[>PJ-i4[ PEv= (~iE/)v!Ea^v!&(=*uURV){i,>%DOcI+ ;4i/GJ[)9~D1R$׻0'L c(}njcG,H1E-"ŧC{xuWM kMDt&Ӎ!CLt[+&2Dt Q*/.9AgbJ~JKL Z%Duisw=魬?rq.OsutP/%9|:V);"JgNTzZꠓhkrQ@0k̢( @q.{j*h[oyN S s>{{:ƽypغ1]oe9_Ճʚ?Z}s[o n;Hb2%6KٍdQ/;ӴnD6AȚE7(gy@'י,ҍE1縣ɞ/fMe7.ΐv% |<¬Wԡo`]Y鎜:-D`;;23%lgfq6q3UthCYCYY1fW|:_ ;?/v& Dmi*NMtUҕqvWY=ilDn8~.9rNs-c]4Ŗ gzȀAɴ ;(C` Y局hW>XVS lYmg+-q!bqh80eiNEw 3Ȇ5'+-βy^ZjbpGz7h[_$exR~BO6{b65grG oǭߟ視ڵozͳ)1s P.0 @)Sh%`Q4",;>oYr,brIc;otvTjYLuZh-uy_ܲm.:6\CUoo]Z-o]վqK$8 )S*a4A1{N*ʾ.5`62?Nl.bxnoN;f_b ge:tO_~l,_J]|;]toZ1R `ir'0%7=!-Wvm. Z CØr hg$Z@v:‡ZR`4(&|;ջ|/[}M]ODxb;uռrU*~﹚D B$3@:n{;o;p/PCh1-m!ƭ2fٗbj,.-Ymn2a(;-dGz籔(8qhP¶?J8Vi ֺy]Sly51-B#|J䴤șOb@(Џ!ИE߃uTi3 ~i_0fH@nT|ł8&88c1BͱKHO:@A@b.v.""˥ (:x{B<"#b"P!ZluI#G=A8 4*Dϧ+Y\"IȳYYTDYpbZΡJR<`po.8_/ɰ\Eu k%(&"-$.g߹+旣j[UX m`CxNJ;, ! [D^$1F4麝[h1扔mfw?DKi1TD[*,о\ld=,y:ge6z_{UQƏoX D{]iM4yG * P֒#_K{#{9a3MXSy|}zQ:B-~:a)ֈZÁ6KÒƘ9K Jc̃ {Es.у>(μҮKrJi+D8}F*BlrqA3oNicoΛgݲ6e ne|Gvwh4`E\UVFCD=mX Ǵr٘"{r`{p?Y:S{ N_gf\j:Ca.|yj> { (=P 4 ht^.R+v# gƳ ԩn_^6fptZj]mtwz99nߙ|&EEyc8Y&$<7.Q0c5&*/k__NVk{Ț~X @ :gIYy)"wψUgImwttV'd󰲐66VnƷ^F#a? E>_,V>nSxk)<5ndzn hc7T B(!GxZ1]3], t jnU݇r9PDk1\篗bSe=dq}FxyV2]U\a5gO%W?PKBUlock38624PKBU0 @db/data.dboWq\L,*Պ"A"F9#zjPR46~iME^PV,X/ l(goRT 5jh<3w}~fssg<쏆q-sUWYUUAV_Zs={W}Q\~u_/ml~ukܿ;q%d#(g" h.Qٞ:W3z \;ӽʽ{GUrs4ހ(:*+O%&k OGSʘU2d%yTܤLA:r&,'E%JGT˒ᖐ)$!6h-  A(ZDA;P%0.@s@!6" U$WWM$"2Eٚ^:S}=eFh5jtV -)Sc% { EZ}Ub.Ǧ+ `4DSDj9WhA:Eh-jkHWQVR6墬$.S3IC(=7SkUQt EUڃZIj 碨 5/@H{,+ !7QytB7;דּYg/Vٷ~yu~Bڟc&a.CDD9QWZ}&xijA KJP('1%5 %9IBE_H* c""i^< ̳ YKhY&18,Hab u1YJK"y("94Z0+B eрDwQ s ДļZׁH@` 6%G-@C'21RZ^S& -R*c?PK?GUZQ)n&szdocument.mwb.xmlPK?BU&lockPK?BU0 &@db/data.dbPK.<MySQL Workbench Model archive 1.0 model-schemas: autoph_api db/Dump20220715 (1).sql000064400000015146150247310640007655 0ustar00-- MySQL dump 10.13 Distrib 8.0.24, for Win64 (x86_64) -- -- Host: 127.0.0.1 Database: autoph_api -- ------------------------------------------------------ -- Server version 8.0.29 /*!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 */; /*!50503 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 `api_key_access_uris` -- DROP TABLE IF EXISTS `api_key_access_uris`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `api_key_access_uris` ( `id` bigint NOT NULL AUTO_INCREMENT, `api_key_id` bigint DEFAULT NULL, `uri` text, `title` varchar(45) DEFAULT NULL, `description` text, `status` tinyint DEFAULT NULL, PRIMARY KEY (`id`), KEY `api_key_access_uris_fk1_idx` (`api_key_id`), CONSTRAINT `api_key_access_uris_fk1` FOREIGN KEY (`api_key_id`) REFERENCES `api_keys` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `api_key_access_uris` -- LOCK TABLES `api_key_access_uris` WRITE; /*!40000 ALTER TABLE `api_key_access_uris` DISABLE KEYS */; INSERT INTO `api_key_access_uris` VALUES (1,1,'/v1/qr/',NULL,NULL,1),(2,1,'/v1/sms/golf/',NULL,NULL,1),(3,1,'/v1/mail/',NULL,NULL,1),(4,1,'/v1/sms/default/',NULL,NULL,1); /*!40000 ALTER TABLE `api_key_access_uris` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `api_keys` -- DROP TABLE IF EXISTS `api_keys`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `api_keys` ( `id` bigint NOT NULL AUTO_INCREMENT, `api_key` varchar(245) DEFAULT NULL, `title` varchar(45) DEFAULT NULL, `description` text, `status` tinyint DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `api_keys` -- LOCK TABLES `api_keys` WRITE; /*!40000 ALTER TABLE `api_keys` DISABLE KEYS */; INSERT INTO `api_keys` VALUES (1,'1a08ff7af875429ab2ebc03678b6a5ab','Default','Default API Key',1); /*!40000 ALTER TABLE `api_keys` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `api_logs` -- DROP TABLE IF EXISTS `api_logs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `api_logs` ( `id` bigint NOT NULL AUTO_INCREMENT, `api_key_access_uri_id` bigint DEFAULT NULL, `ip_address` varchar(95) DEFAULT NULL, `user_agent` text, `description` text, `timestamp` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `api_logs_fk1_idx` (`api_key_access_uri_id`), CONSTRAINT `api_logs_fk1` FOREIGN KEY (`api_key_access_uri_id`) REFERENCES `api_key_access_uris` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `api_logs` -- LOCK TABLES `api_logs` WRITE; /*!40000 ALTER TABLE `api_logs` DISABLE KEYS */; INSERT INTO `api_logs` VALUES (1,1,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36',NULL,'2022-07-15 14:36:37'),(2,1,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36',NULL,'2022-07-15 14:36:43'); /*!40000 ALTER TABLE `api_logs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` bigint NOT NULL AUTO_INCREMENT, `firstname` varchar(95) DEFAULT NULL, `middlename` varchar(95) DEFAULT NULL, `lastname` varchar(95) DEFAULT NULL, `mobile` varchar(45) DEFAULT NULL, `email` varchar(95) DEFAULT NULL, `other_mobile` varchar(45) DEFAULT NULL, `other_email` varchar(95) DEFAULT NULL, `username` varchar(45) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `is_admin` tinyint DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `last_login` datetime DEFAULT NULL, `active` tinyint DEFAULT NULL, `status` tinyint DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3; /*!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,'Clarence','Acedera','Andaya','9389592854','clarenceandaya8@gmail.com',NULL,NULL,'clrkz','$2y$10$WllXm6G1LKwuzyocGyjrWe04DmUbRGXDnsyH3Fmt.IYawAHVZdmuW',1,NULL,NULL,NULL,1,1); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users_login_session_token` -- DROP TABLE IF EXISTS `users_login_session_token`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users_login_session_token` ( `id` bigint NOT NULL AUTO_INCREMENT, `user_id` bigint DEFAULT NULL, `token` varchar(95) DEFAULT NULL, `status` tinyint DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_id_UNIQUE` (`user_id`), KEY `login_token_fk1_idx` (`user_id`), CONSTRAINT `login_token_fk1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users_login_session_token` -- LOCK TABLES `users_login_session_token` WRITE; /*!40000 ALTER TABLE `users_login_session_token` DISABLE KEYS */; /*!40000 ALTER TABLE `users_login_session_token` 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 2022-07-15 14:37:23 db/db design.mwb.bak000064400000027670150247310640010231 0ustar00PKsT~w&zdocument.mwb.xml}YsCD@N`c$KQ.ReB"v~QMzY='%!; @ ?_ǣl^N'~gO E~r1[Og|g8p:XtquYoW٧b2xtXFg/tr|,Nͦg,g'l9XI>\Kyn7?<2EA&dHLpL )ߍbi!Υ\iL7Z)b3#p!9b)%ԂlWb I:Sqgkkn;\NC@ PkG<(=NW~zl_FOiLoOD tlÄ9($hW]|m~}RO?\? _N.6ً_~Z>*'M_g72 꿨7xwObL7?ŗ귟tٞd U.?^oJ뇫gg[GߗsU[ (ΙZ[ls!]h3<{>k FтP f``~W䙗{!ݮPίs#N{,U^M/|9*~Mߜͣ[v}qc|m ӵ0AM4R&<Ä=P$s[3&Tl& $`|OIx7].ɝztopxsnitWFzX cL_o6.gŰժN7!T#mB{TզQ^Mk{rP.d<_<-r4=GEp9=]D^yqe`rmmECQi~( }9C*,xb0olx6o>_gEPvj8kgzrZt4|]SFV *AQ8PBʝTq>(JO@P?x|Q}Ej"2- i"l8k {.a_넇 D !P*r* v)IA%D'"(lBĄmqJJ:.44RI0OH5 8i=DC ҄O)?a-9DžBP@Q`@L y14&$JHHS$t> a1Qw %p*L=A(G 32l%tYp8M8O40`.>XyaiDž9aDbbH)L1%HPMB~&$e ۣbD22 j D+ҖD#HĞb")SLb$M]IGh UF+@B4NHGsa%I'i! аh({TyY'|e:P_Wґm#z괒03@!@pE2aO5aJ'8!Rధpx01ѬpQN4IB a+R2 =@2.6*аK2.аoh>r\?6 Z9|:.PufX1e`E$y@)R H(&Plx9eASK$"@;c e&ibi $PL؁洺\l#c6 g(КT'Me4Lg9ɜMgk&P)(:@1m&A<Ι֓s\HJI BzHt4F20! HH ΃:yw$')"aݻud Vb6n4⇥v;(KqY(^XiuJ?$(sna{1nW}9_dX7hn+gH@Cr)ƍ֣<3$ 5|t1 q%>V6MOߍg,ȼ2zvxF{4}JdAj,kA1vդA]gLYq^̪ /7edمn,+2۶_V󗲚킮Mޗ.dM7>VWHw"K!W>ikBxVU]:V}oӧ|vեcVIײhlFYvZdX Adbd!Ƹq9_LU&nB9h~OC|f23jx*H>Lп/4&3kc' wj+yx9 pEC}r&ׅZ,p>9e>[Т>~!~{-}-kk/mdz =e+mᯥuQ5"5VYop rh>.']|ȍya6⧳qUV +hEb6&x(۵4YxWˇojMQض6P 0+/.BQj`N&/gfhzoܲNg4\\ x?^ZxK?0,wψ5!юHE.~'C%Iu|9_/.>o7OS޷@<~N}7w5:dj.j 01 {H怷gLBi˻-y>ć w VFR@@g$PAavSip]ݞ!q|hSڦFM֥0DzL ꬓ ##N2J4=,:JgbuZS}h:UC܏"ь #BE< paK284E_檋oj ZQ#ڧ1YQ,ikO1R41RTpm}@c D p0$6O̕O7RؑbE)HCu'¸Rk[ RcƦ3!Gv#`42*i& " y4Wapmqu9_00U)~Lŏ,>ŏ)~|/{rSQ{E)vK`&D`hЏtAO4=Ѡ: QӠlEnIm y\|N\$6Clҍ:46ôi)a[i g+&dh2iMF! 2UKH J0ݻrC]bg $K =!O Ӈ7j?DhY4@=#PdDH\~ æ?$*&^'ī_kw)bF)B6Ȉ[J2l$K`l0qk5?`IqLQc#K 7NtXuׂ1 9(`q{z:1k G_+fzw(l QP EAżg)-H?@d'@*) ҅_::*HjɥVI%<q@7@qQsk0>sc9PsB9P~HPjDZ\TzdKkZ|ڥ,>DrY(x"2UjIȫ;F!'JL" "&@iFpTG2M Z+!քVU 22H57S!y3BD{ 2 JqPeFpW:o.(iᯰX8(QR" 7B' XZج69$LLBh/ iĞn2;@L*O ʃ0BPs\s[/,2iPU )E!t"3`.A;G1H,3ޚYuz!}Q/ض#=>AbQ[Vse>|: _b B(^IC*Ң\I%ʗ|pژ{ᎄ#rmѐjyZh1eԴ~!|0)rVO?x'>m{m(TI`6 xb*!a z zfHGn3K)'JX "MB4 j-!ٵ͞Y*mVY6Kf8&n3?V^1BX[֑%0_1@5)RձCDRO1.%=C'4?/fU lgڲ )%abIP L-$aClo|OtŔjXxJ L|},5?g[:]xNe^v}.n,>ꡦbobΊ 3jA'ˏv Ş`fVe0iф!MԶv_FEq#TIע|,]ɛg$ksM%guie1p1@d@]Ճ `d0YeU} ߭: T#Us9*.o;ێ[RWB'kO-*D"a*v|^_ڱ4|oM*x._Wb:x}SݵjGI6L{]@8b@\%~lR@. :.naPĴ#WwDO XRYŞ5y 4  xGZ5og m _:^Ayʺ%4ʰM,@ pF Y7hM{`ϰs(|Ơ!ϱ_^n N<48{@ql\y,EŸبDZn{n|~ؾEi䪜,ڻ6Q ʰ4A2HjxrZQY9O @G"SV߃UTRB4Џ!eC1 6!^U'_qF,88c2c@3Y6, #?ai! G{`3`Åt6uVw'IywQmu4Q`Q뉦RYW{y1nhK9nFu^!H޵D~m7X@JA< Zq+| zoqϼ7'7l k1"<}ݞ/\r?G:B-~:a)V́LH1s@ƭ&|ϕof=xFyGqv]3 gΈR 8(Hp/)$$$gg}洵7ͫ3ql{"sn n~g-ѯ#ޝl+'iz]Q[g`E\uVFCD9=mX nǴr٘";)!G?~t:|t)^O_gf\T:Calҷ_=_D^G2mI(h:p]N9pfEogj]5mto~}}*иԫ/u*˫;k3WG$DNs. v1EӲ[f%H)auzzg"yW$7wQfe^ۆ05"!6,n Y-nE܀U~_ugnKM6L v) 2A| cBӖfJeHYo/94|7ҷcoWʞ8ϿAb0|q߅Aɰ$6/W u}Ow}^t|6 3"/~:闖B*jzKY+/oG8 +?NЛqXTeDT^nYYq_6Sqv:XVL/' [mp |^Dggy& 2/A>W~^_rZwݴF6V5'L`3)+tK *)՗gkwtRRQMLOBnoƷ^#a? ZEX,V>nSk(:ٮ%d8!VX+c2LfܖoW泋rEA"}]WX kzqR͡VwIB2_/,/Mz<GcNEC*(y.'8ky*PKsTplock11100PKsT0 @db/data.dboWq\L,*Պ"A"F9#zjPR46~iME^PV,X/ l(goRT 5jh<3w}~fssg<쏆q-sUWYUUAV_Zs={W}Q\~u_/ml~ukܿ;q%d#(g" h.Qٞ:W3z \;ӽʽ{GUrs4ހ(:*+O%&k OGSʘU2d%yTܤLA:r&,'E%JGT˒ᖐ)$!6h-  A(ZDA;P%0.@s@!6" U$WWM$"2Eٚ^:S}=eFh5jtV -)Sc% { EZ}Ub.Ǧ+ `4DSDj9WhA:Eh-jkHWQVR6墬$.S3IC(=7SkUQt EUڃZIj 碨 5/@H{,+ !7QytB7;דּYg/Vٷ~yu~Bڟc&a.CDD9QWZ}&xijA KJP('1%5 %9IBE_H* c""i^< ̳ YKhY&18,Hab u1YJK"y("94Z0+B eрDwQ s ДļZׁH@` 6%G-@C'21RZ^S& -R*c?PK?sT~w&zdocument.mwb.xmlPK?sTp&lockPK?sT0 &@db/data.dbPK.<MySQL Workbench Model archive 1.0 model-schemas: autoph_api db/Dump20220708.sql000064400000007211150247310640007407 0ustar00-- MySQL dump 10.13 Distrib 8.0.24, for Win64 (x86_64) -- -- Host: 127.0.0.1 Database: clrkz -- ------------------------------------------------------ -- Server version 8.0.29 /*!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 */; /*!50503 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 `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` bigint NOT NULL AUTO_INCREMENT, `firstname` varchar(95) DEFAULT NULL, `middlename` varchar(95) DEFAULT NULL, `lastname` varchar(95) DEFAULT NULL, `mobile` varchar(45) DEFAULT NULL, `email` varchar(95) DEFAULT NULL, `other_mobile` varchar(45) DEFAULT NULL, `other_email` varchar(95) DEFAULT NULL, `username` varchar(45) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `is_admin` tinyint DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `last_login` datetime DEFAULT NULL, `active` tinyint DEFAULT NULL, `status` tinyint DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3; /*!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,'Clarence','Acedera','Andaya','9389592854','clarenceandaya8@gmail.com',NULL,NULL,'clrkz','$2y$10$WllXm6G1LKwuzyocGyjrWe04DmUbRGXDnsyH3Fmt.IYawAHVZdmuW',1,NULL,NULL,'2022-07-08 14:20:55',1,1); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users_login_session_token` -- DROP TABLE IF EXISTS `users_login_session_token`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users_login_session_token` ( `id` bigint NOT NULL AUTO_INCREMENT, `user_id` bigint DEFAULT NULL, `token` varchar(95) DEFAULT NULL, `status` tinyint DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_id_UNIQUE` (`user_id`), KEY `login_token_fk1_idx` (`user_id`), CONSTRAINT `login_token_fk1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users_login_session_token` -- LOCK TABLES `users_login_session_token` WRITE; /*!40000 ALTER TABLE `users_login_session_token` DISABLE KEYS */; INSERT INTO `users_login_session_token` VALUES (1,1,'52bc4cdd-3c4c-4b8f-94fb-ba14958a676e',1,'2022-07-08 14:20:55'); /*!40000 ALTER TABLE `users_login_session_token` 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 2022-07-08 14:31:13