· 6 years ago · Apr 16, 2019, 09:16 AM
1-- MySQL dump 10.13 Distrib 8.0.15, for Linux (x86_64)
2--
3-- Host: localhost Database: syncope
4-- ------------------------------------------------------
5-- Server version 8.0.15
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10 SET NAMES utf8mb4 ;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `SyncopeUser`
20--
21
22DROP TABLE IF EXISTS `SyncopeUser`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24 SET character_set_client = utf8mb4 ;
25CREATE TABLE `SyncopeUser` (
26 `id` varchar(36) NOT NULL,
27 `creationDate` datetime(3) DEFAULT NULL,
28 `creator` varchar(255) DEFAULT NULL,
29 `lastChangeDate` datetime(3) DEFAULT NULL,
30 `lastModifier` varchar(255) DEFAULT NULL,
31 `status` varchar(255) DEFAULT NULL,
32 `changePwdDate` datetime(3) DEFAULT NULL,
33 `cipherAlgorithm` varchar(20) DEFAULT NULL,
34 `failedLogins` int(11) DEFAULT NULL,
35 `lastLoginDate` datetime(3) DEFAULT NULL,
36 `mustChangePassword` int(11) DEFAULT NULL,
37 `password` varchar(255) DEFAULT NULL,
38 `securityAnswer` varchar(255) DEFAULT NULL,
39 `suspended` int(11) DEFAULT NULL,
40 `token` text,
41 `tokenExpireTime` datetime(3) DEFAULT NULL,
42 `username` varchar(255) DEFAULT NULL,
43 `plainAttrs` json DEFAULT NULL,
44 `REALM_ID` varchar(36) DEFAULT NULL,
45 `SECURITYQUESTION_ID` varchar(36) DEFAULT NULL,
46 PRIMARY KEY (`id`),
47 UNIQUE KEY `U_SYNCPSR_USERNAME` (`username`)
48) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
49/*!40101 SET character_set_client = @saved_cs_client */;
50
51--
52-- Dumping data for table `SyncopeUser`
53--
54
55LOCK TABLES `SyncopeUser` WRITE;
56/*!40000 ALTER TABLE `SyncopeUser` DISABLE KEYS */;
57INSERT INTO `SyncopeUser` VALUES ('10b1956e-050c-4bcc-b195-6e050c6bcce6','2019-04-16 07:49:28.681','admin','2019-04-16 07:49:28.956','admin','created','2019-04-16 07:49:28.487','SHA1',NULL,'2019-04-16 07:49:28.845',0,'CBFDAC6008F9CAB4083784CBD1874F76618D2A97',NULL,0,NULL,NULL,'4fc8a2aaauth@test.org','[{\"schema\": \"userId\", \"uniqueValue\": {\"stringValue\": \"4fc8a2aaauth@test.org\"}}, {\"schema\": \"ctype\", \"values\": [{\"stringValue\": \"a type\"}]}, {\"schema\": \"loginDate\", \"values\": [{\"dateValue\": 1555365600000}]}, {\"schema\": \"surname\", \"values\": [{\"stringValue\": \"surname\"}]}, {\"schema\": \"firstname\", \"values\": [{\"stringValue\": \"4fc8a2aaauth@test.org\"}]}, {\"schema\": \"fullname\", \"uniqueValue\": {\"stringValue\": \"4fc8a2aaauth@test.org\"}}, {\"schema\": \"email\", \"values\": [{\"stringValue\": \"4fc8a2aaauth@test.org\"}]}]','e4c28e7a-9dbf-4ee7-9441-93812a0d4a28',NULL),('1417acbe-cbf6-4277-9372-e75e04f97000','2010-10-20 09:00:00.000','admin','2010-10-20 09:00:00.000','admin','active',NULL,'SHA1',NULL,NULL,0,'5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8',NULL,0,NULL,NULL,'rossini','[{\"schema\": \"ctype\", \"values\": [{\"stringValue\": \"G\"}]}, {\"schema\": \"firstname\", \"values\": [{\"stringValue\": \"Gioacchino\"}]}, {\"schema\": \"surname\", \"values\": [{\"stringValue\": \"Rossini\"}]}, {\"schema\": \"loginDate\", \"values\": [{\"dateValue\": 1243288800000}, {\"dateValue\": 1274824800000}]}, {\"schema\": \"fullname\", \"uniqueValue\": {\"stringValue\": \"Gioacchino Rossini\"}}, {\"schema\": \"userId\", \"uniqueValue\": {\"stringValue\": \"rossini@apache.org\"}}]','c5b75db1-fce7-470f-b780-3b9934d82a9d',NULL),('5a28c5f0-44d5-422c-a8c5-f044d5022c72','2019-04-16 07:49:36.462','admin','2019-04-16 07:49:36.649','admin','created','2019-04-16 07:49:36.311','SHA1',NULL,'2019-04-16 07:49:36.538',0,'CBFDAC6008F9CAB4083784CBD1874F76618D2A97',NULL,0,NULL,NULL,'f6031407testusersearch@test.org','[{\"schema\": \"userId\", \"uniqueValue\": {\"stringValue\": \"f6031407testusersearch@test.org\"}}, {\"schema\": \"email\", \"values\": [{\"stringValue\": \"f6031407testusersearch@test.org\"}]}, {\"schema\": \"loginDate\", \"values\": [{\"dateValue\": 1555365600000}]}, {\"schema\": \"ctype\", \"values\": [{\"stringValue\": \"a type\"}]}, {\"schema\": \"surname\", \"values\": [{\"stringValue\": \"surname\"}]}, {\"schema\": \"fullname\", \"uniqueValue\": {\"stringValue\": \"f6031407testusersearch@test.org\"}}, {\"schema\": \"firstname\", \"values\": [{\"stringValue\": \"f6031407testusersearch@test.org\"}]}]','e4c28e7a-9dbf-4ee7-9441-93812a0d4a28',NULL),('6e6addb5-9c5f-4835-aadd-b59c5f9835f4','2019-04-16 07:49:31.404','admin','2019-04-16 07:49:32.676','admin','active','2019-04-16 07:49:31.243','SHA1',0,'2019-04-16 07:49:32.595',0,'CBFDAC6008F9CAB4083784CBD1874F76618D2A97',NULL,0,NULL,NULL,'9abe81cdcheckSuspension@syncope.apache.org','[{\"schema\": \"loginDate\", \"values\": [{\"dateValue\": 1555365600000}]}, {\"schema\": \"email\", \"values\": [{\"stringValue\": \"9abe81cdcheckSuspension@syncope.apache.org\"}]}, {\"schema\": \"ctype\", \"values\": [{\"stringValue\": \"a type\"}]}, {\"schema\": \"userId\", \"uniqueValue\": {\"stringValue\": \"9abe81cdcheckSuspension@syncope.apache.org\"}}, {\"schema\": \"surname\", \"values\": [{\"stringValue\": \"surname\"}]}, {\"schema\": \"fullname\", \"uniqueValue\": {\"stringValue\": \"9abe81cdcheckSuspension@syncope.apache.org\"}}, {\"schema\": \"firstname\", \"values\": [{\"stringValue\": \"9abe81cdcheckSuspension@syncope.apache.org\"}]}]','722f3d84-9c2b-4525-8f6e-e4b82c55a36c',NULL),('74cd8ece-715a-44a4-a736-e17b46c4e7e6','2010-10-20 09:00:00.000','admin','2010-10-20 09:00:00.000','admin','active',NULL,'SHA1',NULL,NULL,0,'5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8',NULL,0,NULL,NULL,'verdi','[{\"schema\": \"firstname\", \"values\": [{\"stringValue\": \"Giuseppe\"}]}, {\"schema\": \"surname\", \"values\": [{\"stringValue\": \"Verdi\"}]}, {\"schema\": \"email\", \"values\": [{\"stringValue\": \"verdi@syncope.org\"}]}, {\"schema\": \"fullname\", \"uniqueValue\": {\"stringValue\": \"Giuseppe Verdi\"}}, {\"schema\": \"userId\", \"uniqueValue\": {\"stringValue\": \"verdi@apache.org\"}}]','e4c28e7a-9dbf-4ee7-9441-93812a0d4a28',NULL),('823074dc-d280-436d-a7dd-07399fae48ec','2010-10-20 09:00:00.000','admin','2019-04-16 07:49:31.090','admin','active',NULL,'SHA1',NULL,'2019-04-16 07:49:30.987',0,'5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8',NULL,0,NULL,NULL,'puccini','[{\"schema\": \"firstname\", \"values\": [{\"stringValue\": \"Giacomo\"}]}, {\"schema\": \"surname\", \"values\": [{\"stringValue\": \"Puccini\"}]}, {\"schema\": \"fullname\", \"uniqueValue\": {\"stringValue\": \"Giacomo Puccini\"}}, {\"schema\": \"userId\", \"uniqueValue\": {\"stringValue\": \"puccini@apache.org\"}}]','e4c28e7a-9dbf-4ee7-9441-93812a0d4a28',NULL),('92a6a4f8-3197-4733-a6a4-f83197f733a0','2019-04-16 07:49:29.338','admin','2019-04-16 07:49:30.226','admin','created','2019-04-16 07:49:29.177','SHA1',0,'2019-04-16 07:49:30.125',0,'CBFDAC6008F9CAB4083784CBD1874F76618D2A97',NULL,0,NULL,NULL,'ead6770bcheckFailedLogin@syncope.apache.org','[{\"schema\": \"firstname\", \"values\": [{\"stringValue\": \"ead6770bcheckFailedLogin@syncope.apache.org\"}]}, {\"schema\": \"email\", \"values\": [{\"stringValue\": \"ead6770bcheckFailedLogin@syncope.apache.org\"}]}, {\"schema\": \"ctype\", \"values\": [{\"stringValue\": \"a type\"}]}, {\"schema\": \"fullname\", \"uniqueValue\": {\"stringValue\": \"ead6770bcheckFailedLogin@syncope.apache.org\"}}, {\"schema\": \"surname\", \"values\": [{\"stringValue\": \"surname\"}]}, {\"schema\": \"loginDate\", \"values\": [{\"dateValue\": 1555365600000}]}, {\"schema\": \"userId\", \"uniqueValue\": {\"stringValue\": \"ead6770bcheckFailedLogin@syncope.apache.org\"}}]','e4c28e7a-9dbf-4ee7-9441-93812a0d4a28',NULL),('a41afb3b-6ec4-4a99-9afb-3b6ec48a99fd','2019-04-16 07:49:30.530','admin','2019-04-16 07:49:30.697','admin','created','2019-04-16 07:49:30.390','SHA1',NULL,'2019-04-16 07:49:30.614',0,'CBFDAC6008F9CAB4083784CBD1874F76618D2A97',NULL,0,NULL,NULL,'e5617669testuserread@test.org','[{\"schema\": \"fullname\", \"uniqueValue\": {\"stringValue\": \"e5617669testuserread@test.org\"}}, {\"schema\": \"userId\", \"uniqueValue\": {\"stringValue\": \"e5617669testuserread@test.org\"}}, {\"schema\": \"loginDate\", \"values\": [{\"dateValue\": 1555365600000}]}, {\"schema\": \"ctype\", \"values\": [{\"stringValue\": \"a type\"}]}, {\"schema\": \"firstname\", \"values\": [{\"stringValue\": \"e5617669testuserread@test.org\"}]}, {\"schema\": \"surname\", \"values\": [{\"stringValue\": \"surname\"}]}, {\"schema\": \"email\", \"values\": [{\"stringValue\": \"e5617669testuserread@test.org\"}]}]','e4c28e7a-9dbf-4ee7-9441-93812a0d4a28',NULL),('b3cbc78d-32e6-4bd4-92e0-bbe07566a2ee','2010-10-20 09:00:00.000','admin','2010-10-20 09:00:00.000','admin','active',NULL,'SHA1',NULL,NULL,0,'5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8',NULL,0,NULL,NULL,'vivaldi','[{\"schema\": \"firstname\", \"values\": [{\"stringValue\": \"Antonio\"}]}, {\"schema\": \"surname\", \"values\": [{\"stringValue\": \"Vivaldi\"}]}, {\"schema\": \"email\", \"values\": [{\"stringValue\": \"vivaldi@syncope.org\"}]}, {\"schema\": \"ctype\", \"values\": [{\"stringValue\": \"F\"}]}, {\"schema\": \"fullname\", \"uniqueValue\": {\"stringValue\": \"Antonio Vivaldi\"}}, {\"schema\": \"userId\", \"uniqueValue\": {\"stringValue\": \"vivaldi@apache.org\"}}]','e4c28e7a-9dbf-4ee7-9441-93812a0d4a28',NULL),('c9b2dec2-00a7-4855-97c0-d854842b4b24','2010-10-20 09:00:00.000','admin','2019-04-16 07:49:36.150','admin','active',NULL,'SHA1',NULL,'2019-04-16 07:49:36.054',0,'5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8',NULL,0,NULL,NULL,'bellini','[{\"schema\": \"firstname\", \"values\": [{\"stringValue\": \"Vincenzo\"}]}, {\"schema\": \"surname\", \"values\": [{\"stringValue\": \"Bellini\"}]}, {\"schema\": \"loginDate\", \"values\": [{\"dateValue\": 1245794400000}]}, {\"schema\": \"cool\", \"values\": [{\"booleanValue\": true}]}, {\"schema\": \"gender\", \"values\": [{\"stringValue\": \"M\"}]}, {\"schema\": \"fullname\", \"uniqueValue\": {\"stringValue\": \"Vincenzo Bellini\"}}, {\"schema\": \"userId\", \"uniqueValue\": {\"stringValue\": \"bellini@apache.org\"}}]','e4c28e7a-9dbf-4ee7-9441-93812a0d4a28',NULL),('df8d321f-e63c-4196-8d32-1fe63c719679','2019-04-16 07:49:23.596','admin','2019-04-16 07:49:27.914','admin','created','2019-04-16 07:49:25.614','SHA1',NULL,'2019-04-16 07:49:27.755',0,'AA6AE8C005B9048B03F6059224C858650D9E52D5',NULL,0,NULL,NULL,'312fd106syncope164@syncope.apache.org','[{\"schema\": \"userId\", \"uniqueValue\": {\"stringValue\": \"312fd106syncope164@syncope.apache.org\"}}, {\"schema\": \"ctype\", \"values\": [{\"stringValue\": \"a type\"}]}, {\"schema\": \"loginDate\", \"values\": [{\"dateValue\": 1555365600000}]}, {\"schema\": \"surname\", \"values\": [{\"stringValue\": \"surname\"}]}, {\"schema\": \"email\", \"values\": [{\"stringValue\": \"312fd106syncope164@syncope.apache.org\"}]}, {\"schema\": \"fullname\", \"uniqueValue\": {\"stringValue\": \"312fd106syncope164@syncope.apache.org\"}}, {\"schema\": \"firstname\", \"values\": [{\"stringValue\": \"312fd106syncope164@syncope.apache.org\"}]}]','0679e069-7355-4b20-bd11-a5a0a5453c7c',NULL);
58/*!40000 ALTER TABLE `SyncopeUser` ENABLE KEYS */;
59UNLOCK TABLES;
60/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
61
62/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
63/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
64/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
65/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
66/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
67/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
68/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
69
70-- Dump completed on 2019-04-16 7:51:36