From 66ec1dabe3fec6557dd060c8c6e10d7adb747ed2 Mon Sep 17 00:00:00 2001 From: Hamatoma Date: Sun, 1 Dec 2024 17:35:51 +0100 Subject: [PATCH] db-dump in correct path --- db/lrvoo4f.sql.gz | Bin 5382 -> 0 bytes resources/db/lrvoo4f.sql | 124 +++++++++++++++++++++++++++++++-------- 2 files changed, 100 insertions(+), 24 deletions(-) delete mode 100644 db/lrvoo4f.sql.gz diff --git a/db/lrvoo4f.sql.gz b/db/lrvoo4f.sql.gz deleted file mode 100644 index e6bd120105d7e91a0335926d6e7b9d7b7a02ac0c..0000000000000000000000000000000000000000 GIT binary patch literal 0 HcmV?d00001 literal 5382 zcmV+h75VBPiwFP!000001KnNga^lF6{=NMa+K4%UeGa&F;bJ`NjiwE@>EY51*lqiq z6KWx3kS!!e61H*d&*rDixuxxu(|sEX>x+ zl^}^nQd1Dxrsuon6#bNr>J@@13-^vI%#5k2*%iyQ*Dsa1y%r8$j_Yc@dibGI0e^){ z$Ma7F%h5G!0lo_0Ph0b~spc7=*nM)G>OI6&e(DdT92@SF;R@h?&vfknh)7ux{{cjl zXH}F$Nf>t~!lz-ct)5-BMy<0+XQYB6^{m(J3?`?aJ|z_kfB*PvE{9QP zeASzbV=PE{8joSG*P3*P1MqDy=$yf?kVQgqoWr2i?~H}De}BB3R@uu+Siz**@2Gdf zK?iURzQ?g4tn?32JQ2lGh!Le~$nR><{dUy>ZSS1@1{=%$E(`o+F@?$baMbBu4AkE` zw;`u^VOdB3iYb~Lf9t9JVH>uSek}_@VQDZ_TUV2zdfn;)`G8{YI-?=eNJ)zD8Vo0$ zF=2+jV{W(@3qkCBqD?JB0FJWO{k3Z#-|$h{4^7vdwe5R9AoN3fH2f+|TAzCzp?fZL zZn|S&7a=CvDo=YdW~%O~x@8(R@*m+;`1DC%Xs)LFhO2spPcO!ll88D*)`GxiqfTqm zA>xEW2nQbo;fFc!yA004~Oh zAE(upuvI@msM5`)W*r=tEQP-UC8`Wl z6Y3c6K8=n1! z?UD5g;rpmN>Ch-5ibAUgLTlV^+uboL0vck1Z3aPSz~iq5i~xn4dp2_o&oi>UI{@v} zy#p!s&%cRm{$^#Up6;xGvqQNgDdMTc;sAF&R@cfk9oO_XDOEVnw(&lZfa+VNEZH~^ zR1*&Z8FYLI2zhY+zxIp_-{1^7#vAbUgOhDi07Z;llC7NevzTbt&+ zW?G>256(2xG+Ed#O_P=5=LbmZHKa;6SKYB~L&xSCkEg${4H$0Y7gpNFax}o%a_o6h z9M+8$W||Bjjf)J$XgjF=>uc8qI#L73!D0Fs2hZ~HP>0c-3N-*d<#*VU1FVq!cDb0L zaxTZ&MW)Mf$bv4%(QNN>fLXS)A;3=E3`wwmGZ5eOt<0&#%yV~R#djNUpnBB#p?js&sG=txA^zwo$C0(NOEr^wI~FXxXguu@bg0yD5c z67BcEf;BnLOXzLRbQ20H=qD7uwWENsh&t7LFcrx378bTkmto}y{U+T~^DNnSe9a;Q zvcyhzW!N)tx3eJJs4fQqx&<$7*zTa=hQ}pfV(z7Dpd+^E@SfHdhcS^MStQdoy+sb2 zxVP@L2gYofb3@K_GJTOl7Ia9C<~_VJ&mDK}hud^qWa^vlmpM~l&G(Jv3a;t+roDkx zD+x7|(W?jd3^0bCIoQ>nfUm-vkc{W2_faQHLuQPJ(JUINLpAN0@d7(Ltew60wG<~S z;9YNWtM~9HxFrP#*9@l$LA&&

TH<7ovq!mr3D9-S*X7g%_n*It;DD1()UH=mghy z4a3huXtS9Km7`gC>wf#RHW=K}H?9q4(Y^oL;C@XxBOc2I8OB92BMpNq7;YGftz%BO zF(V`9grHr<9Ci=MzQvqv=AthLv$0 zSgM_I*`w=k=@ppvV@7}}Fb9rwq*8Ui9E~?q-qAw4$ab_47jv}kVB8r^1Q5W691!ih z9e+5G%1D*ypOWiXhF2<=M&xs9R#sq);@A~1bJia#_oiim;-zNV;Nv5NSJ1qu1cK#( z%(6m*8vwc@pHou^xG^jsjA5a$EO594s0;dqGI3Ux!7xEUhD(*@;;mckEBQ67YnVE9(`*krFTr>nuZ*S_i;$(_&>=gJI> zxEaQnmSs&$wIqvjwIWFsMHHm^i6WgSA|MF%pn>l#<~y!WV^v6?EN{++gCQ#b_n7a* zOf=J)Ixh@Ail+<j}nyZCcRG|?? zUEI$R1?$eq;|l6I#YPttU2u#+;dG=?W&0Np+(Dp}P;brl7BVQ8ae0l6|B6^{kYaYk zQWeW}Qp}D%0O>I)W}|UkEH_CpJ49%RNE}qocJjxdkQB3BbyF-;2^(CC#4>47jcY03 zT_xpgOC`|M8YnNU_U+@mId}8(tPEEwtH7IMcyNP3dO!2ZR)>Y|PZpeZ7VTfQUnh^>`tk&Wb@n(QH z6%Ya~0gIG@goKdn`{3{rg9lm?B}oqSk7gn~TxQ@6@E33o;CSN}2UjQ@XbHk=$F<-d zpvegjuTpqbm4RxTvJ?uBW*|JgM&UJ8J_g*YO(j%Pkmut_>O4tPtk;eyN${{BN73LY zWU<<;HG?L&n(b*iUO-@}WZDu*Qsp{mdksXbpq}7)BtoJfl3GXtj9Ug>jvN?OxJ(g{ z6mj+KdmFMyTWJmyl2Cz?2Duz)u3;6iMghjO+XmSBah%qdT^5pz}lG`%tqspFn-&9&rJelyaU9i{$uY^;nucUxT_b znP}^o>HLx5I;X$kH}|^6lj(r|t1xpLXt+3f>pefHFTitpsyMbQ2$UHGvufiOE?9L& zi3;{(7|f`S#j_fXk`UdoaH`HIG}c9?>{Cip4c~8sYU270`b=nIkCY-Z&o~gD<4faD z2H*GS>5@4o-WQ%ZcaPpGd9r0i7MeIKdut7uW0$0X3&-=%)&DcSDcAp#CS~^j1d~1A zC!plnKHSW)#Cti&qWtM8+T0aKihW~0{qSn;=zyAflQpkYW z`u^slRKw^A+>T`daEUHHRi!e_%fgi`S!CziY^&ivsncJgt#=qCdEPVVE>-xf|Gz0 z>aFcPcQeiIx6thC#+jVdclcxoeZFk##CL74oF#4JMv?6rg*ItKwq{6t26YLaKJ{I= z239IdVl2_!*KE)yfNQdtlIE_7u?+Xc+JKu6o6XdY=Dqegc!uZY?Q#e(yL7)mh$7EQ zzwHzeb4Aw*L!Q;7r>qcLa5v$ptZ6gl%!fTK&GS{bkolDQtX9S}j;bIyv?F-TGJfJn zfaR(TDR@ctyF27Rwxu>iqI?ZlCXw*NYOxUF}srZ|;-Yif2I`l}=M z+m6}4bT<03ujt~-)%1K&ABdi!iM88d$G4}~*S}xegGK-5i>JSi26vCQFUHm4^YjeS zzYfhWlD>R4hjORhpR8b66_l-}_Q;wpN7fy|4JMAMU5-S(?L775=F{Nfc0Ieeex02) z{k!iqNxK2~v4pWH1{|C`ryGaZ{$1g_GaL8AN&D3V)&Fo|6p#YZY+TzgP9~?4>6YUeGhE+UjF8(IT%wD*B_uI?Xk~_L9Q(64shmOz zrW#M^Q5RU{*EpS$LI)<4k0rQkx%53wR81lBH4hL~0nsEz)Z`i$E=EHc*Hg>XapS&T z#VO@8alyWL1SLdjkP^*$gi*nY&J=*62b=$gXcVh-5iPbdv zCv#>{dZ^~>Zo88}UrVDmmtdq!=xfmC`xkNQ*kfIkdgkcsC5#xDK|O_m%qbl&K|#G) znrWjUI?;N}MqrvRi4q=Iq`}l8)_Ff>k&>(=5?)UFJ*?=8}pU!;OW?N%k&n)!DrX>O;2AO;@S;cy%@z=$r-FJ40oy7 z!U6u=9Abe$=g{uN8O5ISVi=vnOg|9m+=T~19bzTkyXtv@K-COBT_5~{62UJ}9%!|u zuXbZMU*UCxLrIA_C=)BC9jB8M=sa6{G_b8f4UFSdN&*!K&#%NYW6@dR&6;`1Kq=VO z1qF;LTH&plC;Yl_?4;mar~}=41d2AgWsN;CV3(s#EW!R|_;Q#1q2NgeB%_P7b=EQC z3CF|!%ucR%J75OyR)5>!GHEn_^}RogOL1dlV#k@IV}dD|_9y7=g8;LUKQk7vxSfUs zR*?OR3~xA5hTlW8%zL#I)9~D#Kdh2`^r%n<7&h()H08*_&*Z6);#ph&*|gtlPtRKd z6#FbnC^WaJCTvOy9g&?SqRmO6cwBg%Owwj?A0Y68Br=h`9Zhlx(f>`~wYg z>?0n$|M`!2jO2qm*PiSc&q0fZdX8x8h>!1XMySVtUB-B7fIl1D^MY{hW(NdNpA6T$ zHwy-Sx(=Vk)-~_})@o!kg(QkO$Lzjm7nOM$LwpA)Go=e9X3kCwNYIq^bBSyT^&QIr z?AZesn+c7C=dpy?+#@OIlMvY{Sl65{{5(|tiEQ}kS8NO6acpF}O3*2U&&U=%Q6h!n z%_lnu!vSbjuLB$hy}uQz3=~~`Z9`u=YmLuZ?M~hRdcV$-VuBMFV@X8F46X!|omeIy z<^k`>h5;}|XMTS&UVt@P#*ywU$qc>pi@f6dvd!H3U&QsmbuoxqL!F z4z?nc=I}E^z?;qG>Q%g!-JW%|dG5GhoW<417*6KXUbi7O4deBC-fu_^#s4zWn%$am z>)!ny6R;Wx7`Z?tQp%-gm_B)a{It-PKxs?uXl6uYshYP7c{R7czr1{FKU}-dljmCh zXmi(l7(CRMpS_VR_HVuWJA1J{5*zyQNLyakDGx>~l5(OnPO8mPLTRm0V%6ClU6sEL zFU|RS>XaMJdO#vq6iE>4C-}w01=23WW^#JoloufLuT922zPNe2Z?fAq00|H)wyUTn40KQg{SO5S3 diff --git a/resources/db/lrvoo4f.sql b/resources/db/lrvoo4f.sql index 2d8e61b..7744359 100644 --- a/resources/db/lrvoo4f.sql +++ b/resources/db/lrvoo4f.sql @@ -45,6 +45,37 @@ LOCK TABLES `accounts` WRITE; /*!40000 ALTER TABLE `accounts` ENABLE KEYS */; UNLOCK TABLES; +-- +-- Table structure for table `addresses` +-- + +DROP TABLE IF EXISTS `addresses`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `addresses` ( + `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, + `created_at` timestamp NULL DEFAULT NULL, + `updated_at` timestamp NULL DEFAULT NULL, + `addresstype_scope` int(11) NOT NULL, + `name` varchar(255) NOT NULL, + `info` varchar(255) DEFAULT NULL, + `priority` int(11) NOT NULL, + `owner_id` bigint(20) unsigned DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `addresses_owner_id_foreign` (`owner_id`), + CONSTRAINT `addresses_owner_id_foreign` FOREIGN KEY (`owner_id`) REFERENCES `users` (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `addresses` +-- + +LOCK TABLES `addresses` WRITE; +/*!40000 ALTER TABLE `addresses` DISABLE KEYS */; +/*!40000 ALTER TABLE `addresses` ENABLE KEYS */; +UNLOCK TABLES; + -- -- Table structure for table `cache` -- @@ -147,7 +178,7 @@ CREATE TABLE `files` ( KEY `files_module_id_foreign` (`module_id`), CONSTRAINT `files_module_id_foreign` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`), CONSTRAINT `files_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -247,6 +278,40 @@ LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; +-- +-- Table structure for table `locations` +-- + +DROP TABLE IF EXISTS `locations`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `locations` ( + `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, + `created_at` timestamp NULL DEFAULT NULL, + `updated_at` timestamp NULL DEFAULT NULL, + `country` varchar(5) NOT NULL, + `zip` varchar(15) NOT NULL, + `city` varchar(128) NOT NULL, + `street` varchar(128) NOT NULL, + `additional` varchar(255) DEFAULT NULL, + `info` varchar(255) DEFAULT NULL, + `priority` int(11) NOT NULL, + `owner_id` bigint(20) unsigned DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `locations_owner_id_foreign` (`owner_id`), + CONSTRAINT `locations_owner_id_foreign` FOREIGN KEY (`owner_id`) REFERENCES `users` (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `locations` +-- + +LOCK TABLES `locations` WRITE; +/*!40000 ALTER TABLE `locations` DISABLE KEYS */; +/*!40000 ALTER TABLE `locations` ENABLE KEYS */; +UNLOCK TABLES; + -- -- Table structure for table `mandators` -- @@ -294,7 +359,7 @@ CREATE TABLE `menuitems` ( `section` varchar(64) NOT NULL, `link` varchar(255) NOT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -313,7 +378,9 @@ INSERT INTO `menuitems` VALUES (7,NULL,NULL,'notes','Notes','bi bi-card-checklist','main','/note-index'), (8,NULL,NULL,'terms','Terms','bi bi-calendar-date','main','/term-index'), (9,NULL,NULL,'pages','Pages','bi bi-journals','main','/page-index'), -(10,NULL,NULL,'exports','Exports','bi bi-file-earmark-arrow-down','main','/export-index'); +(10,NULL,NULL,'exports','Exports','bi bi-file-earmark-arrow-down','main','/export-index'), +(12,NULL,'2024-11-30 16:31:30','addresses','Addresses','bi bi-at','main','/address-index'), +(13,NULL,NULL,'locations','Locations','bi bi-mailbox','main','/location-index'); /*!40000 ALTER TABLE `menuitems` ENABLE KEYS */; UNLOCK TABLES; @@ -336,7 +403,7 @@ CREATE TABLE `menuitems_roles` ( KEY `menuitems_roles_role_id_foreign` (`role_id`), CONSTRAINT `menuitems_roles_menuitem_id_foreign` FOREIGN KEY (`menuitem_id`) REFERENCES `menuitems` (`id`), CONSTRAINT `menuitems_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -346,16 +413,18 @@ CREATE TABLE `menuitems_roles` ( LOCK TABLES `menuitems_roles` WRITE; /*!40000 ALTER TABLE `menuitems_roles` DISABLE KEYS */; INSERT INTO `menuitems_roles` VALUES -(6,NULL,NULL,10,7,1), -(7,NULL,NULL,20,6,1), -(8,NULL,NULL,30,8,1), -(9,NULL,NULL,40,9,1), -(10,NULL,NULL,50,10,1), -(11,NULL,NULL,60,1,1), -(12,NULL,NULL,70,2,1), -(13,NULL,NULL,80,3,1), -(14,NULL,NULL,90,4,1), -(15,NULL,NULL,100,5,1); +(48,NULL,NULL,10,13,1), +(49,NULL,NULL,20,12,1), +(50,NULL,NULL,30,7,1), +(51,NULL,NULL,40,6,1), +(52,NULL,NULL,50,8,1), +(53,NULL,NULL,60,9,1), +(54,NULL,NULL,70,10,1), +(55,NULL,NULL,80,1,1), +(56,NULL,NULL,90,2,1), +(57,NULL,NULL,100,3,1), +(58,NULL,NULL,110,4,1), +(59,NULL,NULL,120,5,1); /*!40000 ALTER TABLE `menuitems_roles` ENABLE KEYS */; UNLOCK TABLES; @@ -371,7 +440,7 @@ CREATE TABLE `migrations` ( `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -397,7 +466,9 @@ INSERT INTO `migrations` VALUES (14,'2024_04_21_092103_create_pages_table',2), (15,'2024_05_28_174935_create_mandators_table',2), (16,'2024_05_28_190658_create_accounts_table',2), -(17,'2024_05_28_204959_create_transactions_table',2); +(17,'2024_05_28_204959_create_transactions_table',2), +(24,'2024_11_26_075255_create_addresses_table',3), +(25,'2024_11_30_211027_create_locations_table',3); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; @@ -415,7 +486,7 @@ CREATE TABLE `modules` ( `name` varchar(64) NOT NULL, `tablename` varchar(64) NOT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -436,7 +507,10 @@ INSERT INTO `modules` VALUES (9,NULL,NULL,'Files','filess'), (10,NULL,NULL,'Term','terms'), (11,NULL,NULL,'Page','pages'), -(12,NULL,NULL,'Exports','exportss'); +(12,NULL,NULL,'Exports','exportss'), +(13,NULL,NULL,'Email','emails'), +(14,NULL,NULL,'Address','addresss'), +(15,NULL,NULL,'Location','locations'); /*!40000 ALTER TABLE `modules` ENABLE KEYS */; UNLOCK TABLES; @@ -468,7 +542,7 @@ CREATE TABLE `notes` ( CONSTRAINT `notes_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`), CONSTRAINT `notes_module_id_foreign` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`), CONSTRAINT `notes_owner_id_foreign` FOREIGN KEY (`owner_id`) REFERENCES `users` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -614,7 +688,7 @@ CREATE TABLE `sessions` ( LOCK TABLES `sessions` WRITE; /*!40000 ALTER TABLE `sessions` DISABLE KEYS */; INSERT INTO `sessions` VALUES -('v8Mj6lA9k1QcVxohYaMp363KNWWjSPL4HGgcL3Wk',3,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64; rv:128.0) Gecko/20100101 Firefox/128.0','YTo2OntzOjY6Il90b2tlbiI7czo0MDoidVZ0VVRCSm04VnVydU5JQ0NUQ1R2ek1xUU5aNmNVeDVrMEdJaHhLQSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9vbzRmLnRlc3QvcGFnZS1zaG93bWVudS9tYWluIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozNToiaHR0cDovL29vNGYudGVzdC9tZW51aXRlbS1tZW51X21haW4iO31zOjg6InVzZXJOYW1lIjtzOjI6IndrIjtzOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTozO30=',1731855752); +('IVlT4gHZgad1484HAH6LsGJf80aj4GvawbQvrbU9',3,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64; rv:128.0) Gecko/20100101 Firefox/128.0','YTo2OntzOjY6Il90b2tlbiI7czo0MDoiMHoycmM3c0xUbFN6N0s3a05YOEtnbVVqVnNhMXJsczRNZkYxeUhBbCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozNToiaHR0cDovL29vNGYudGVzdC9tZW51aXRlbS1tZW51X21haW4iO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozMToiaHR0cDovL29vNGYudGVzdC9tZW51aXRlbS1pbmRleCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjM7czo4OiJ1c2VyTmFtZSI7czoyOiJ3ayI7fQ==',1733069094); /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; UNLOCK TABLES; @@ -673,7 +747,9 @@ INSERT INTO `sproperties` VALUES (1204,NULL,NULL,'localization','Italian (Italy)',40,'it_IT',NULL,NULL), (1301,NULL,NULL,'task','description',10,'D',NULL,NULL), (1302,NULL,NULL,'task','snaketext',20,'S',NULL,NULL), -(1303,NULL,NULL,'task','cloze',30,'C',NULL,NULL); +(1303,NULL,NULL,'task','cloze',30,'C',NULL,NULL), +(1321,NULL,NULL,'addresstype','Email',10,'E',NULL,NULL), +(1322,NULL,NULL,'addresstype','Phone',20,'P',NULL,NULL); /*!40000 ALTER TABLE `sproperties` ENABLE KEYS */; UNLOCK TABLES; @@ -697,7 +773,7 @@ CREATE TABLE `terms` ( PRIMARY KEY (`id`), KEY `terms_owner_id_foreign` (`owner_id`), CONSTRAINT `terms_owner_id_foreign` FOREIGN KEY (`owner_id`) REFERENCES `users` (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -786,7 +862,7 @@ LOCK TABLES `users` WRITE; INSERT INTO `users` VALUES (1,'Administrator','administrator@example.com',NULL,'$2y$12$I.nWufXEZywFy0SGnHZZXefcl7/87ujg6OUNc.LMlrZA..ezt6gXy',NULL,NULL,NULL,1,'en_GB','','2024-11-17 01:52:00',NULL,NULL), (2,'Guest','guest@example.com',NULL,'$2y$12$XyHpz0V2rLlUywErJohUReOTgbLI709eezVgM7173tJRa9I53YrZq',NULL,NULL,NULL,4,'en_GB',NULL,NULL,NULL,NULL), -(3,'wk','wk@hamatoma.de',NULL,'$2y$12$4iYh2pgnWxxQDjVrwTw5M.yZLjNj6mBsR20MYsfZnhu.07c8RamH6',NULL,'2024-11-17 13:37:49','2024-11-17 13:37:57',1,'en_GB','=UQAHOH,on964uhy','2024-12-17 01:52:00',NULL,NULL); +(3,'wk','wk@hamatoma.de',NULL,'$2y$12$4iYh2pgnWxxQDjVrwTw5M.yZLjNj6mBsR20MYsfZnhu.07c8RamH6',NULL,'2024-11-17 13:37:49','2024-11-17 13:37:57',1,'en_GB','IRU,QOHigubo,796','2024-12-31 06:00:00',NULL,NULL); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; @@ -799,4 +875,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2024-11-17 17:55:13 +-- Dump completed on 2024-12-01 17:19:58 -- 2.39.5