123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912 |
- ;
- ;
- ;
- ;
- ;
- ;
- ;
- ;
- ;
- ;
- DROP TABLE IF EXISTS `accounts`;
- ;
- ;
- CREATE TABLE `accounts` (
- `ID` varchar(45) NOT NULL COMMENT '主键',
- `UID` varchar(45) DEFAULT NULL COMMENT '用户ID',
- `APPID` varchar(45) DEFAULT NULL COMMENT '应用ID',
- `RELATEDUSERNAME` varchar(200) DEFAULT NULL COMMENT '用户名',
- `RELATEDPASSWORD` varchar(200) DEFAULT NULL COMMENT '密码',
- `MODIFIEDDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
- `APPNAME` varchar(100) DEFAULT NULL,
- `USERNAME` varchar(45) DEFAULT NULL,
- `DISPLAYNAME` varchar(45) DEFAULT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='FormBased用户配置表';
- ;
- LOCK TABLES `accounts` WRITE;
- ;
- INSERT INTO `accounts` VALUES ('26b1c864-ae81-4b1f-9355-74c4c699cb6b','7BF5315CA1004CDB8E614B0361C4D46B','fe86db85-5475-4494-b5aa-dbd3b886ff64','test@connsec.com','6bc4cb2c2967c12ed0bdd93ee2e48bdd','2015-05-05 11:12:26','腾讯企业邮箱','admin','系统管理员'),('36371b00-1a88-4fce-955d-1828e778bdd6','7BF5315CA1004CDB8E614B0361C4D46B','c8038bd4-12a4-4b45-9d43-61b3ecdc2eb4','myltpv9527@163.com','3752d262dd2efc6db55a752ab2049f89','2015-01-16 15:36:44','有道云笔记','admin','系统管理员'),('37d640d9-5f1d-4b41-a20e-bad0d547fa20','7BF5315CA1004CDB8E614B0361C4D46B','850379a1-7923-4f6b-90be-d363b2dfd2ca','myltpv9527@163.com','3752d262dd2efc6db55a752ab2049f89','2015-01-17 03:05:24','网易163邮箱','admin','系统管理员'),('44f7e28d-399c-4756-a0c6-bad96bde4a8a','7BF5315CA1004CDB8E614B0361C4D46B','c1cabfaeb9a448028ffab2148da9f65c','21313','c1e66f5a57a76f19c9683e8a3a58898a','2015-05-05 08:06:49','QQ Login','admin','系统管理员'),('56bf4642-46d5-4d82-83a8-4b777eb0f371','3557da42-7f8d-4a55-ae19-b4abb1be926d','850379a1-7923-4f6b-90be-d363b2dfd2ca','shimingxy@ddd.com','26e47d909a07145e50aac4b523a24bc4','2015-05-05 09:13:34','网易163邮箱','wwww','wwww'),('e3ee7f1c-48cf-48ee-ad07-29491b649bf5','7BF5315CA1004CDB8E614B0361C4D46B','a08d486a-2007-4436-aeda-4310e9443ec7','a1','9653392173f7e8eb2a4545aa816506ff','2019-10-20 13:06:08','OAuth v1.0a Demo','admin','系统管理员');
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `apps`;
- ;
- ;
- CREATE TABLE `apps` (
- `ID` varchar(45) NOT NULL COMMENT '主键',
- `NAME` varchar(300) NOT NULL COMMENT '应用名称',
- `LOGINURL` varchar(300) NOT NULL COMMENT '应用登录地址',
- `CATEGORY` varchar(45) DEFAULT NULL COMMENT '应用类型',
- `SECRET` varchar(400) DEFAULT NULL COMMENT 'SECRET',
- `PROTOCOL` varchar(300) DEFAULT NULL COMMENT '应用协议',
- `ICON` blob COMMENT '应用图标',
- `STATUS` tinyint(3) unsigned DEFAULT NULL COMMENT '状态',
- `CREATEDBY` varchar(45) DEFAULT NULL COMMENT '创建人',
- `CREATEDDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `MODIFIEDBY` varchar(45) DEFAULT NULL COMMENT '修改人',
- `MODIFIEDDATE` datetime DEFAULT NULL COMMENT '修改时间',
- `DESCRIPTION` varchar(400) DEFAULT NULL COMMENT '描述',
- `VENDOR` varchar(45) DEFAULT NULL,
- `VENDORURL` varchar(200) DEFAULT NULL,
- `CREDENTIAL` tinyint(4) DEFAULT '0',
- `SHAREDUSERNAME` varchar(100) DEFAULT NULL,
- `SHAREDPASSWORD` varchar(400) DEFAULT NULL,
- `SYSTEMUSERATTR` varchar(45) DEFAULT NULL,
- `ISEXTENDATTR` varchar(4) DEFAULT NULL,
- `EXTENDATTR` varchar(400) DEFAULT NULL,
- `SORTINDEX` int(10) unsigned DEFAULT '0',
- `ISSIGNATURE` tinyint(4) DEFAULT '0',
- `VISIBLE` tinyint(4) DEFAULT '0',
- `ISADAPTER` tinyint(3) unsigned DEFAULT '0',
- `ADAPTER` varchar(400) DEFAULT NULL,
- `PRINCIPAL` varchar(45) DEFAULT NULL,
- `CREDENTIALS` varchar(200) DEFAULT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='应用表';
- ;
- LOCK TABLES `apps` WRITE;
- ;
- INSERT INTO `apps` VALUES ('1327c121-cfad-49ba-bf61-afd3a1e09d5c','LTPA-Cookie','http://tokenbased.demo.maxkey.org:8080/demo-ltpa/ltpa.jsp','FINANCE','d6227a3d7756c255874ec7029678b8d1','Token_Based','����\0JFIF\0\0\0\0\0\0��\0C\0 \n\r\Z\Z $.\' \",#(7),01444\'9=82<.342��\0C \r\r2!!22222222222222222222222222222222222222222222222222��\0\0�\0�\"\0��\0\0\0\0\0\0\0\0\0\0\0 \n��\0�\0\0\0}\0!1AQa\"q2���#B��R��$3br� \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz���������������������������������������������������������������������������\0\0\0\0\0\0\0\0 \n��\0�\0\0w\0!1AQaq\"2�B����
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `apps_cas_details`;
- ;
- ;
- CREATE TABLE `apps_cas_details` (
- `ID` varchar(45) NOT NULL,
- `SERVICE` varchar(400) NOT NULL,
- `VALIDATION` varchar(400) NOT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- ;
- LOCK TABLES `apps_cas_details` WRITE;
- ;
- INSERT INTO `apps_cas_details` VALUES ('12e99fd2-20b9-43ce-84c2-f16ef0a675a0','saf','saf'),('3f83593e-3826-4319-8467-651f45d3c977','HTTTPS','HTTTPS'),('41065fe3-ae67-4172-a460-fd0079e88294','http://cas.demo.maxkey.org:8080/demo-cas/','http://login.connsec.com:8080/casproxy'),('489807c2-3311-4289-ad56-30b9047515d9','asfd','asf'),('b1c9f5f0-6850-4845-a4f0-cd48ece0f364','HTTTPS','HTTTPS');
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `apps_desktop_details`;
- ;
- ;
- CREATE TABLE `apps_desktop_details` (
- `ID` varchar(45) NOT NULL,
- `PROGRAMPATH` varchar(400) NOT NULL,
- `PARAMETER` varchar(400) DEFAULT NULL,
- `USERNAMETYPE` varchar(45) NOT NULL,
- `PREUSERNAME` varchar(45) DEFAULT NULL,
- `USERNAMEPARAMETER` varchar(45) DEFAULT NULL,
- `PASSWORDTYPE` varchar(45) NOT NULL,
- `PREPASSWORD` varchar(45) DEFAULT NULL,
- `PASSWORDPARAMETER` varchar(45) DEFAULT NULL,
- `SUBMITTYPE` varchar(45) NOT NULL,
- `SUBMITKEY` varchar(45) DEFAULT NULL,
- `PRESUBMIT` varchar(45) DEFAULT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- ;
- LOCK TABLES `apps_desktop_details` WRITE;
- ;
- INSERT INTO `apps_desktop_details` VALUES ('c1cabfaeb9a448028ffab2148da9f65c','C:\\Program Files (x86)\\Tencent\\QQ\\Bin\\QQ.exe','','SIMULATION','','username','SIMULATION','','password','Enter','d','');
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `apps_form_based_details`;
- ;
- ;
- CREATE TABLE `apps_form_based_details` (
- `ID` varchar(45) NOT NULL COMMENT '主é®',
- `USERNAMEMAPPING` varchar(45) DEFAULT NULL COMMENT 'ç¨æ·åæ å°',
- `PASSWORDMAPPING` varchar(45) DEFAULT NULL COMMENT 'å¯ç æ å°',
- `REDIRECTURI` varchar(400) DEFAULT NULL COMMENT 'æäº¤å°å',
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='FormBaseé
置表';
- ;
- LOCK TABLES `apps_form_based_details` WRITE;
- ;
- INSERT INTO `apps_form_based_details` VALUES ('850379a1-7923-4f6b-90be-d363b2dfd2ca','userNameIpt','password','https://ssl.mail.163.com/entry/coremail/fcg/ntesdoor2'),('c8038bd4-12a4-4b45-9d43-61b3ecdc2eb4','username','password','http://note.youdao.com/signIn/');
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `apps_oauth_client_details`;
- ;
- ;
- CREATE TABLE `apps_oauth_client_details` (
- `CLIENT_ID` varchar(45) NOT NULL COMMENT 'appkey',
- `RESOURCE_IDS` varchar(256) DEFAULT NULL COMMENT 'åºç¨id',
- `CLIENT_SECRET` varchar(256) DEFAULT NULL COMMENT 'appsecret',
- `SCOPE` varchar(256) DEFAULT NULL COMMENT 'èå´',
- `AUTHORIZED_GRANT_TYPES` varchar(256) DEFAULT NULL COMMENT 'è®¤è¯æ¹å¼',
- `WEB_SERVER_REDIRECT_URI` varchar(256) DEFAULT NULL COMMENT 'åè°å°å',
- `AUTHORITIES` varchar(256) DEFAULT NULL COMMENT 'æéä¿¡æ¯',
- `ACCESS_TOKEN_VALIDITY` int(11) unsigned DEFAULT NULL COMMENT 'accesstokenæææ¶é´',
- `REFRESH_TOKEN_VALIDITY` int(11) unsigned DEFAULT NULL,
- `ADDITIONAL_INFORMATION` varchar(4096) DEFAULT NULL,
- `APPROVALPROMPT` varchar(45) DEFAULT 'force',
- `AUTOAPPROVE` varchar(45) DEFAULT NULL,
- `IDTOKENENCRYPTEDALGORITHM` varchar(45) DEFAULT NULL,
- `IDTOKENSIGNINGALGORITHM` varchar(45) DEFAULT NULL,
- `IDTOKENENCRYPTIONMETHOD` varchar(45) DEFAULT NULL,
- `USERINFOSIGNINGALGORITHM` varchar(45) DEFAULT NULL,
- `USERINFOCRYPTEDALGORITHM` varchar(45) DEFAULT NULL,
- `USERINFOENCRYPTIONMETHOD` varchar(45) DEFAULT NULL,
- `JWKSURI` varchar(400) DEFAULT NULL,
- PRIMARY KEY (`CLIENT_ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='oauthåºç¨ä¿¡æ¯';
- ;
- LOCK TABLES `apps_oauth_client_details` WRITE;
- ;
- INSERT INTO `apps_oauth_client_details` VALUES ('33e28d3d-5c74-4da4-b708-598291f43a2a','33e28d3d-5c74-4da4-b708-598291f43a2a','df9b97b854c5c0079c845b6bf8e4e82ac9bd3faa43f719b4beded2c7e509f159bdbd9571be32a6a15b016e9d764ee4a4fc907307f5c48bbf32a6197b56f97dde1e698f87c64032dc548d6ec7dc3c4863','read','authorization_code',NULL,'ROLE_CLIENT,ROLE_TRUSTED_CLIENT',180,180,'{}','force','read','none','none','none','none','none','none',''),('42853d95-71b1-4641-9e40-c5398e2ee92f','42853d95-71b1-4641-9e40-c5398e2ee92f','db0ec65fb9bdbcbf09a90429b55166f818cd97eed1a25764e172c77ecdff6d573c5631c3fa79e5818d5f7d2b12bb6aef9964797c213709ab1f66e3f540210dd51e698f87c64032dc548d6ec7dc3c4863','read','authorization_code','北京','ROLE_CLIENT,ROLE_TRUSTED_CLIENT',180,180,'{}','force','read','none','none','none','none','none','none',''),('71a1a118-5f41-40e6-914e-a82a81905b47','71a1a118-5f41-40e6-914e-a82a81905b47','a025cc2b9984d3d9fbcc1e52c7b0ee2c5f3c86ab15435fc782b8e7d21fe9fed348f858de7faeb943855a42dc585654e5f4def8c169305e6370cc8884d3daec4c1e698f87c64032dc548d6ec7dc3c4863','read','authorization_code','SADF','ROLE_CLIENT,ROLE_TRUSTED_CLIENT',180,180,'{}','force','read','none','none','none','none','none','none','DF'),('79b4d1d7-2046-47e4-8fd2-65c3337eee54','79b4d1d7-2046-47e4-8fd2-65c3337eee54','1b3b94f449aa3cda6b00c7730a3d1fac4e1904b86bf2650db7b0d963cff1e1c3440df18d26f10ddf74585e75aacbc279e3a690b3cdadc41d56fe73ed4cb164601e698f87c64032dc548d6ec7dc3c4863','read','authorization_code','FFFF','ROLE_CLIENT,ROLE_TRUSTED_CLIENT',180,180,'{}','force','read','none','none','none','none','none','none',''),('ae20330a-ef0b-4dad-9f10-d5e3485ca2ad','ae20330a-ef0b-4dad-9f10-d5e3485ca2ad','ade8aeb8b9513880baa804887ff89571e7fbe584acdbeff154519a5a39f6a567','openid,profile,read','authorization_code','http://oauth.demo.maxkey.org:8080/demo-oauth/oidc10callback.jsp','ROLE_CLIENT,ROLE_TRUSTED_CLIENT',180,180,'{}','force','read,openid,profile','none','RS256','none','none','none','none',''),('b32834accb544ea7a9a09dcae4a36403','b32834accb544ea7a9a09dcae4a36403','4e1d7eb7b14ad658e8d9066c95902c852ff6494512a742a8392d1d16adc5af551e698f87c64032dc548d6ec7dc3c4863','read','authorization_code','http://oauth.demo.maxkey.org:8080/demo-oauth/oauth20callback.jsp','ROLE_CLIENT,ROLE_TRUSTED_CLIENT',180,180,'{}','force','read','none','RS256','none','none','none','none','http://'),('b490248d-5f68-4996-93bc-60bea2879e93','b490248d-5f68-4996-93bc-60bea2879e93','2974f63bb37aaa5f3482b65a986835cfa41473aed3d0b939345e32eca65cdebbd99cc81926bb24d7bde66aa51d7e26e7ce216d1b5bc30e57f82c90f100165a921e698f87c64032dc548d6ec7dc3c4863','read','authorization_code','sadf','ROLE_CLIENT,ROLE_TRUSTED_CLIENT',180,180,'{}','force','read','none','none','none','none','none','none',''),('c3d44bb1-e2c4-45dd-91ce-43e821f1321c','c3d44bb1-e2c4-45dd-91ce-43e821f1321c','d9457a9a9017d2f92ce3d0b58e4328ea637dcc5a434d3bc900bd5f07cd1eda86','all,read,trust,write','authorization_code','http://liferay.demo.connsec.com:8080/','ROLE_CLIENT,ROLE_TRUSTED_CLIENT',180,180,'{}','force','trust,write,read,all','none','none','none','none','none','none',''),('my-client-with-registered-redirect',NULL,NULL,'trust','authorization_code,client_credentials','http://anywhere','ROLE_CLIENT',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('my-less-trusted-client',NULL,NULL,NULL,'authorization_code,implicit','http://','ROLE_CLIENT',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('my-trusted-client',NULL,NULL,'read,write,trust','password,authorization_code,refresh_token,implicit','http://','ROLE_CLIENT, ROLE_TRUSTED_CLIENT',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('my-trusted-client-with-secret',NULL,'somesecret','read,write,trust','password,authorization_code,refresh_token,implicit','http://','ROLE_CLIENT, ROLE_TRUSTED_CLIENT',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('my-untrusted-client-with-registered-redirect',NULL,NULL,'read','authorization_code','http://anywhere','ROLE_CLIENT',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `apps_saml_v20_details`;
- ;
- ;
- CREATE TABLE `apps_saml_v20_details` (
- `ID` varchar(45) NOT NULL,
- `CERTISSUER` varchar(200) DEFAULT NULL,
- `CERTSUBJECT` varchar(200) DEFAULT NULL,
- `CERTEXPIRATION` varchar(100) DEFAULT NULL,
- `KEYSTORE` blob,
- `SPACSURL` varchar(200) NOT NULL,
- `ISSUER` varchar(300) DEFAULT NULL,
- `ENTITYID` varchar(300) DEFAULT NULL,
- `VALIDITYINTERVAL` int(10) unsigned DEFAULT NULL,
- `NAMEIDFORMAT` varchar(45) DEFAULT NULL,
- `AUDIENCE` varchar(300) DEFAULT NULL,
- `ENCRYPTED` tinyint(3) unsigned DEFAULT NULL,
- `BINDING` varchar(45) DEFAULT NULL,
- `NAMEIDCONVERT` tinyint(3) unsigned DEFAULT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- ;
- LOCK TABLES `apps_saml_v20_details` WRITE;
- ;
- INSERT INTO `apps_saml_v20_details` VALUES ('525d261fa3b04d19af0debabbd5a1e2d','VeriSign Class 3 International Server CA - G3','CN=proxy.salesforce.com, OU=Applications, O=\"Salesforce.com, Inc.\", L=San Francisco, ST=California, C=US','17 Oct 2017 23:59:59 GMT','����\0\0\0\0\0\0\0\0\0\0 https://sso.connsec.com/sec/saml\0\0CDF��\0X.509\0\0d0�`0�H�C��7�7h�ֺpBn�g0\r *�H��\r\00��10 UUS10U\nVeriSign, Inc.10UVeriSign Trust Network1;09U2Terms of use at https://www.verisign.com/rpa (c)101604U-VeriSign Class 3 International Server CA - G30\r131018000000Z\r171017235959Z0��10 UUS10U\nCalifornia10U\rSan Francisco10U\nSalesforce.com, Inc.10UApplications10Uproxy.salesforce.com0�\"0\r *�H��\r\0�\00�\n�\0�mK�-&c��\"���I���==�`�Ӆu�j����DG���)�Y�$�\Z[U�`E�1_;��\n�e@��\\1��VC]���BUpgT���@:<��x\0�b�%dQ��^1�2x2�\"��\nu8ّ��\Z�d߯l4H�M>)��#z��z!�ݲD�\0���Rh�B���!�)�z�`,ě�D��Q����\"�-�4����~���P�AZ��g���� �pih�5\r������5iJO^�sF�RH����q\0���0��0U0�proxy.salesforce.com0 U0\00U��0(U%!0++ `�H��B0CU <0:08\n`�H��E60*0(+https://www.verisign.com/cps0U#0�כ|�\"��ݭ_�)�XüF\0�0AU:0806�4�2�0http://SVRIntl-G3-crl.verisign.com/SVRIntlG3.crl0r+f0d0$+0�http://ocsp.verisign.com0<+0�0http://SVRIntl-G3-aia.verisign.com/SVRIntlG3.cer0\r *�H��\r\0�\02��y����D�~�^��Z8���p�W�c�D���Q��s�6*����R/��X(��+=/T�6�t!¦!g��2J+9�k�1�m��V��W�i�ED���\Z��!D�g�� P�ͱ��5�eye��H:1�Z�;l \n���z�yEei�~�{�:����@q=���\n�A �K��;�:�;L��iY3H��.9�]������ �Jf�ar����q�6=g�b`�^˔�o��)��S\'R��@w�\0\0\0\0connsec.com\0\0>��\r�\0\0\00��0\n+*\0����aM���-�5�����Hfk<랓�nH ��%Њ{�4�
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `apps_token_based_details`;
- ;
- ;
- CREATE TABLE `apps_token_based_details` (
- `ID` varchar(45) NOT NULL COMMENT 'åºç¨id',
- `ALGORITHMKEY` varchar(400) NOT NULL COMMENT 'å å¯å¯é¥',
- `ALGORITHM` varchar(45) NOT NULL COMMENT 'å å¯ç®æ³ /DES,DESede,Blowfish and AES',
- `UID` tinyint(4) DEFAULT '0' COMMENT 'ç¨æ·id',
- `USERNAME` tinyint(4) DEFAULT '0' COMMENT 'ç¨æ·å',
- `EMAIL` tinyint(4) DEFAULT '0' COMMENT 'çµåé®ä»¶',
- `EXPIRES` int(10) unsigned DEFAULT '0' COMMENT 'è¿ææ¶é´',
- `REDIRECTURI` varchar(400) NOT NULL COMMENT 'åè°å°å',
- `WINDOWSACCOUNT` tinyint(4) DEFAULT '0',
- `EMPLOYEENUMBER` tinyint(4) DEFAULT '0',
- `DEPARTMENTID` tinyint(4) DEFAULT '0',
- `DEPARTMENT` tinyint(4) DEFAULT '0',
- `COOKIENAME` varchar(45) DEFAULT NULL,
- `tokenType` varchar(20) DEFAULT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- ;
- LOCK TABLES `apps_token_based_details` WRITE;
- ;
- INSERT INTO `apps_token_based_details` VALUES ('1327c121-cfad-49ba-bf61-afd3a1e09d5c','d6227a3d7756c255874ec7029678b8d1','DES',1,1,1,1,'http://tokenbased.demo.maxkey.org:8080/demo-ltpa/ltpa.jsp',0,1,0,0,'ltpa','LTPA'),('38c8a544eaa04aaeaa49d9c77ace40cd','c1f6adfcadd8ba23f73395f16a45dbe7','DES',1,1,1,1,'http://tokenbased.demo.maxkey.org:8080/demo-tokenbase/jsontoken.jsp',0,0,0,1,NULL,'POST'),('78917a82-1c86-4020-b86a-3b1b350357e3','985e805bd49770e7e797209db3cc2767','DES',0,1,1,1,'http://tokenbased.demo.maxkey.org:8080/demo-jwt/jwtcallback.jsp',0,0,0,0,'ttt','POST'),('f1e33b71-f553-42ab-ae91-2fd913854cda','1729a1ee16e532d61e097c01054dcfe7','DES',0,1,0,1,'http://tokenbased.demo.maxkey.org:8080/demo-tokenbase/sampletoken.jsp',0,0,0,0,NULL,'POST'),('maxkey_mgt','4bbb82a8f4928756c4054abdba5956ba1e698f87c64032dc548d6ec7dc3c4863','AES',1,1,0,1,'http://sso.maxkey.org:9521/maxkey-mgt/login',0,0,0,0,'','POST');
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `forgot_password`;
- ;
- ;
- CREATE TABLE `forgot_password` (
- `ID` varchar(45) NOT NULL COMMENT '主é®',
- `UID` varchar(45) DEFAULT NULL COMMENT 'ç¨æ·ID',
- `STATUS` tinyint(3) unsigned DEFAULT NULL COMMENT 'ç¶æ',
- `CREATEDDATE` datetime DEFAULT NULL COMMENT 'å建æ¶é´',
- `EMAIL` varchar(45) NOT NULL COMMENT 'é®ç®±',
- `USERNAME` varchar(45) NOT NULL COMMENT 'ç¨æ·å',
- PRIMARY KEY (`ID`),
- KEY `Index_forgot_password_id` (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='æ¾åå¯ç ';
- ;
- LOCK TABLES `forgot_password` WRITE;
- ;
- INSERT INTO `forgot_password` VALUES ('184d656b-01e8-472f-9661-6e5115aba41d','6ac07a3d-b935-43f2-a693-9ce49b6695b7',1,'2013-05-03 10:29:45','shimingxy@qq.com','sadf'),('44e7dfb1-49d7-4f3f-88f8-9542d383c3bb','6ac07a3d-b935-43f2-a693-9ce49b6695b7',1,'2013-05-03 10:32:03','shimingxy@qq.com','sadf'),('ebd73563-ee1f-493e-8f71-48b2c762cf05','6ac07a3d-b935-43f2-a693-9ce49b6695b7',1,'2013-05-03 10:30:52','shimingxy@qq.com','sadf');
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `group_member`;
- ;
- ;
- CREATE TABLE `group_member` (
- `ID` varchar(45) NOT NULL DEFAULT '' COMMENT '主é®',
- `GROUPID` varchar(45) NOT NULL COMMENT 'åºç¨ID',
- `MEMBERID` varchar(45) NOT NULL COMMENT 'ç¨æ·ID',
- `TYPE` varchar(45) NOT NULL,
- PRIMARY KEY (`ID`),
- KEY `FK_APPROLEU_REFERENCE_APPROLES` (`GROUPID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='åºç¨è§è²ç¨æ·è¡¨';
- ;
- LOCK TABLES `group_member` WRITE;
- ;
- INSERT INTO `group_member` VALUES ('0313f3d7-166f-4436-b667-ba940d58f507','0E1A4E0F39484456BB2BDE902B4BC275','7BF5315CA1004CDB8E614B0361C4D46B','USER'),('04ded9a1-4120-4de6-8856-2d85691b21f3','702D5E61C13047FEB64CF8DF476672D0','58bf53ad-46e9-4ebe-a910-2f325d459088','USER'),('151c97f3-4b73-4c98-a508-dba342e14aaa','3C36EE4661684DF8B4CBC977B9C8AE35','f3993b8f-e78f-4d79-b629-d6179c1ec2aa','USER'),('1a2d6d05-d7e9-480f-a854-f5b14de0ff80','7BA5E4713E994E3BBC11BA642DF988BF','7BF5315CA1004CDB8E614B0361C4D46B','USER'),('1fef08e5-a8da-409e-b2b7-9ba59e066396','35E6CE83F2C242838BF00563E2B1A3AE','58bf53ad-46e9-4ebe-a910-2f325d459088','USER'),('210d87eb-3a86-452f-92f6-7ca3107b6f93','10064180F8AC4492B30CBC9F8972C3D7','58bf53ad-46e9-4ebe-a910-2f325d459088','USER'),('21ef51cc-702f-432c-ba64-6b5006c4b39c','016e3a86-3181-4126-8e00-acb2e234bb58','97b8fc47-fb31-4c7a-8322-7d16266b08af','USER'),('2496b63c-b883-418d-8f44-3b3219886a04','2D7A79F2889347B781AF3F162B6CAF8B','3557da42-7f8d-4a55-ae19-b4abb1be926d','USER'),('24aff38d-45e3-47c7-8641-a0f06fb43ec8','702D5E61C13047FEB64CF8DF476672D0','7BF5315CA1004CDB8E614B0361C4D46B','USER'),('24edbd93-2586-4882-8e75-8cf261144065','10064180F8AC4492B30CBC9F8972C3D7','5a405e33-4ec1-4a59-b611-1abf42453611','USER'),('297c2209-c5bc-4eaf-89d1-b67e028b5bfa','35E6CE83F2C242838BF00563E2B1A3AE','44D64694BADD4423A336C05D49469B60','USER'),('2b1078ab-2152-4c35-9766-ebd8429ac571','2D7A79F2889347B781AF3F162B6CAF8B','44D64694BADD4423A336C05D49469B60','USER'),('2ca811a2-b705-42fc-8bea-73c97f35fe7d','2D7A79F2889347B781AF3F162B6CAF8B','a64d6778-cea0-4790-9a9f-155de1984501','USER'),('2d8813f8-8dce-4285-a9b2-5c51ab910e80','2D7A79F2889347B781AF3F162B6CAF8B','97b8fc47-fb31-4c7a-8322-7d16266b08af','USER'),('2f4ff1e8-a763-4f97-a382-3c6704f6c7e3','702D5E61C13047FEB64CF8DF476672D0','5a405e33-4ec1-4a59-b611-1abf42453611','USER'),('31d439f0-3295-4cb8-b4e8-fc00be0ca6db','1DF53A025E944C4C95DB5D330083DDB9','44D64694BADD4423A336C05D49469B60','USER'),('353da12a-c21b-46f4-8cd9-36759b2f0846','016e3a86-3181-4126-8e00-acb2e234bb58','6a52a7af-6855-4e15-8616-31ff0c5bcebc','USER'),('3717900f-e470-4b9b-9362-12ed87a719aa','016e3a86-3181-4126-8e00-acb2e234bb58','7b7af24a-1d8c-430a-ac2a-6d869bce96f6','USER'),('4a1547d0-34f4-46fb-914c-d4c4f48746fa','FC43153502BB4A489F71C390A09B55C1','1ff88ce8-4aea-4a43-9cbb-144487e71d6e','USER'),('4c048c310b24b6c0000801402b3b0d94','0E1A4E0F39484456BB2BDE902B4BC275','568d2022-6a45-496c-8df4-9886a27ff117','USER'),('4e9952f91590b6c0000801402b4323f4','0E1A4E0F39484456BB2BDE902B4BC275','53b78e43-1216-492d-bd2f-a2cc9318cb71','USER'),('5618b2f2-c69e-458e-b77c-84de51fee62b','3C36EE4661684DF8B4CBC977B9C8AE35','1b82c5a7-8822-4e0a-9fbb-3e5b54a1d9e2','USER'),('56d93dfa-3035-487f-bec4-fc952a12084c','702D5E61C13047FEB64CF8DF476672D0','97b8fc47-fb31-4c7a-8322-7d16266b08af','USER'),('577be9c2-990f-47c8-b295-3ce529289e2e','2D7A79F2889347B781AF3F162B6CAF8B','1b82c5a7-8822-4e0a-9fbb-3e5b54a1d9e2','USER'),('588a5565-0bca-4ff9-9331-39caf8b3ec8f','702D5E61C13047FEB64CF8DF476672D0','44D64694BADD4423A336C05D49469B60','USER'),('5b896a4a-0278-4f39-b69d-22f96c4b19ca','3C36EE4661684DF8B4CBC977B9C8AE35','97b8fc47-fb31-4c7a-8322-7d16266b08af','USER'),('5d6fde3c-444c-472f-b277-b5b8e3040cd0','2D7A79F2889347B781AF3F162B6CAF8B','f3993b8f-e78f-4d79-b629-d6179c1ec2aa','USER'),('6c797ac8-26e9-42d0-a064-73a6ce1d498f','2D7A79F2889347B781AF3F162B6CAF8B','58bf53ad-46e9-4ebe-a910-2f325d459088','USER'),('6f8f47a01590b6c0000801402b461e77','0E1A4E0F39484456BB2BDE902B4BC275','B79A140814E3446EA24E673DE436ABCB','USER'),('7482bb0a-6cb2-4d79-b56a-3155701c81c9','35E6CE83F2C242838BF00563E2B1A3AE','a64d6778-cea0-4790-9a9f-155de1984501','USER'),('7962a0d5-ea1d-49aa-9e5a-29f2b4dfb1c0','3C36EE4661684DF8B4CBC977B9C8AE35','6a52a7af-6855-4e15-8616-31ff0c5bcebc','USER'),('7b8a3284-7231-4592-b771-5dbac6fbefa6','FC43153502BB4A489F71C390A09B55C1','1b82c5a7-8822-4e0a-9fbb-3e5b54a1d9e2','USER'),('7d2c6ffe1590b6c0000801402b461e19','0E1A4E0F39484456BB2BDE902B4BC275','6ac07a3d-b935-43f2-a693-9ce49b6695b7','USER'),('7fc8e1a3-39c6-48c6-8162-e3a908e26cc6','ALL_USER_GROUP','97b8fc47-fb31-4c7a-8322-7d16266b08af','USER'),('8bc887fc1590b6c0000801402b461dbb','0E1A4E0F39484456BB2BDE902B4BC275','0e675911-09f9-4380-8280-33ec6a088187','USER'),('903e0493-7e38-468b-b597-bc89920b6ed9','1DF53A025E944C4C95DB5D330083DDB9','58bf53ad-46e9-4ebe-a910-2f325d459088','USER'),('951ce5c5-3b29-40d7-bf60-5b998e1098cc','1DF53A025E944C4C95DB5D330083DDB9','3557da42-7f8d-4a55-ae19-b4abb1be926d','USER'),('a7adea67-0857-4af6-8e0e-2eb95861b070','3C36EE4661684DF8B4CBC977B9C8AE35','58bf53ad-46e9-4ebe-a910-2f325d459088','USER'),('bad2a79b-0e0d-4350-8672-f1f1c87fff25','35E6CE83F2C242838BF00563E2B1A3AE','1b82c5a7-8822-4e0a-9fbb-3e5b54a1d9e2','USER'),('bb4afa27-dd51-44c9-a2ba-74f70798842c','1DF53A025E944C4C95DB5D330083DDB9','5a405e33-4ec1-4a59-b611-1abf42453611','USER'),('c182a6fb-4c50-4a10-be85-538d671c7c6a','3C36EE4661684DF8B4CBC977B9C8AE35','5a405e33-4ec1-4a59-b611-1abf42453611','USER'),('c5f8d381-79c5-40a3-8e46-45d26e4c9250','702D5E61C13047FEB64CF8DF476672D0','6a52a7af-6855-4e15-8616-31ff0c5bcebc','USER'),('c8f7bcff1590b6c0000801402b461e38','0E1A4E0F39484456BB2BDE902B4BC275','7AF5AD2269784EFB92DB2F621ED1E340','USER'),('cab09b86-ee4b-4991-9913-23eee5f2e792','016e3a86-3181-4126-8e00-acb2e234bb58','58bf53ad-46e9-4ebe-a910-2f325d459088','USER'),('cca1a319-9d03-4502-8d4d-76f26b521b8b','3C36EE4661684DF8B4CBC977B9C8AE35','3557da42-7f8d-4a55-ae19-b4abb1be926d','USER'),('ccbeaa39-156a-4b59-85c8-c678c5a6d160','016e3a86-3181-4126-8e00-acb2e234bb58','7BF5315CA1004CDB8E614B0361C4D46B','USER'),('cd3aca37-3a9b-4f23-a32e-814d07862dfb','702D5E61C13047FEB64CF8DF476672D0','f3993b8f-e78f-4d79-b629-d6179c1ec2aa','USER'),('d3551fa7-f84b-488b-862a-5aa7e570b0c3','2D7A79F2889347B781AF3F162B6CAF8B','6a52a7af-6855-4e15-8616-31ff0c5bcebc','USER'),('d694d4fc1590b6c0000801402b461dea','0E1A4E0F39484456BB2BDE902B4BC275','2C3FA5A17E51403CA49E4BEFF41B7375','USER'),('dbb8a8d5-ac77-4f82-8087-32899c3c438a','2D7A79F2889347B781AF3F162B6CAF8B','5a405e33-4ec1-4a59-b611-1abf42453611','USER'),('e3a346eb-a8c4-43fd-adf7-b561117ee732','10064180F8AC4492B30CBC9F8972C3D7','6a52a7af-6855-4e15-8616-31ff0c5bcebc','USER');
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `group_privileges`;
- ;
- ;
- CREATE TABLE `group_privileges` (
- `ID` varchar(45) NOT NULL COMMENT '主é®',
- `GROUPID` varchar(45) NOT NULL COMMENT 'åºç¨è§è²ID',
- `APPID` varchar(45) NOT NULL COMMENT 'åºç¨ID',
- PRIMARY KEY (`ID`),
- KEY `FK_APPROLEA_REFERENCE_APPLICAT` (`APPID`),
- KEY `FK_APPROLEA_REFERENCE_APPROLES` (`GROUPID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='åºç¨è§è²åºç¨å
³è表';
- ;
- LOCK TABLES `group_privileges` WRITE;
- ;
- INSERT INTO `group_privileges` VALUES ('01068c63-4f71-4d10-a863-75cc3ad76657','null','cas'),('0b9fd7f4-dce8-4e04-b85c-85bf1f0c1319','2D7A79F2889347B781AF3F162B6CAF8B','69DB747E5A464ECDA5E27C5C56C4006C'),('0bcdeae4-dc1a-455d-bf8d-04cd1758226d','016e3a86-3181-4126-8e00-acb2e234bb58','41065fe3-ae67-4172-a460-fd0079e88294'),('0efef5a2-d04f-436d-b9d6-83890aa78150','ALL_USER_GROUP','69DB747E5A464ECDA5E27C5C56C4006C'),('1650a3cb-183a-42e2-90da-95b0eabccc2d','0E415B0F253D45B0B752631A0D41D94F','7610cb37255842f892a2bf8bc822cb49'),('1a4311130cc4b6c0000801402b1878eb','0E1A4E0F39484456BB2BDE902B4BC275','0c5cca99774d41b797646e4bc666f295'),('1acce469-c8c5-4fb9-812c-72d214a4fe18','ALL_USER_GROUP','363b7606ff644c04a3c7a848d2d32247'),('1b0c8bd6-33e9-48a5-a0b7-f746272a2161','null','cas'),('204f1e1b-520a-4c64-8947-d94e70dfd4dc','0E415B0F253D45B0B752631A0D41D94F','33d21613-29a4-bf56-f8b9-0147168b7d20'),('213f81bf-a3c2-48db-b413-b0175550607f','0E415B0F253D45B0B752631A0D41D94F','525d261fa3b04d19af0debabbd5a1e2d'),('2949f0a8-02f5-40b8-be4c-8f9bb532ca4d','0E415B0F253D45B0B752631A0D41D94F','363b7606ff644c04a3c7a848d2d32247'),('37003683-350a-4c78-9d59-f635d2c74103','0E1A4E0F39484456BB2BDE902B4BC275','e6bfadbfc1d64d0e9140a716548c35db'),('3c20d159-f3fd-4c1d-9267-ce2cb349820f','016e3a86-3181-4126-8e00-acb2e234bb58','71b7b9b1-7d12-4f24-a956-24d21fd66052'),('3e6764730b24b6c0000801402b3cdad2','10064180F8AC4492B30CBC9F8972C3D7','0c5cca99774d41b797646e4bc666f295'),('4103ca41-7560-44e1-be0c-810d28a2ea86','0E415B0F253D45B0B752631A0D41D94F','3f57d0b2-99ab-4e66-a938-718befb55369'),('442ca6d1-a17b-4a3c-9712-c3b2c1473008','ALL_USER_GROUP','b32834accb544ea7a9a09dcae4a36403'),('44dc1c90-0216-4dc0-a7b5-127b5d24a832','ALL_USER_GROUP','525d261fa3b04d19af0debabbd5a1e2d'),('484a3f43-bf5a-436e-a5c0-f1d4ac28def0','ALL_USER_GROUP','33d21613-29a4-bf56-f8b9-0147168b7d20'),('4f5b4738-5b3b-4161-950e-051e6a5d158f','2D7A79F2889347B781AF3F162B6CAF8B','cas'),('50093f71-d4d8-42d6-9a3b-e7c1264adca6','ALL_USER_GROUP','1327c121-cfad-49ba-bf61-afd3a1e09d5c'),('547cdf12-3e03-4324-9fef-702f03500cd9','ALL_USER_GROUP','38c8a544eaa04aaeaa49d9c77ace40cd'),('54caa2f7-b393-4e4a-a5af-5df9d6dc33c4','016e3a86-3181-4126-8e00-acb2e234bb58','38c8a544eaa04aaeaa49d9c77ace40cd'),('568f3d7a-ce67-4d03-9d45-89fb6be215e3','0E415B0F253D45B0B752631A0D41D94F','a40388d23cea4c5ba93bed865b81d255'),('577246060cc4b6c0000801402b187968','0E1A4E0F39484456BB2BDE902B4BC275','3ada377b22d24254964b9c5707f792f1'),('6197521b-7b29-417e-883a-0ab6f12e884a','ALL_USER_GROUP','f1e33b71-f553-42ab-ae91-2fd913854cda'),('63e5d968-3df3-46ff-856e-b4e65d05b22f','2D7A79F2889347B781AF3F162B6CAF8B','3f57d0b2-99ab-4e66-a938-718befb55369'),('6d1d9701-93f7-4d9c-a3b0-e94b93f82acc','2D7A79F2889347B781AF3F162B6CAF8B','525d261fa3b04d19af0debabbd5a1e2d'),('6e153505-eeaf-4df8-a652-f2616bb1e5ca','0E1A4E0F39484456BB2BDE902B4BC275','7132bffd-1e94-bf56-f8b9-01474a2fe832'),('6e2f1b9d-1910-422f-a8d5-d1e09898c25c','0E1A4E0F39484456BB2BDE902B4BC275','213ffd94-1254-bf56-f8b9-014749d3a76e'),('70a24f4c-af66-45ed-90fa-b7e6682688dd','0E415B0F253D45B0B752631A0D41D94F','38c8a544eaa04aaeaa49d9c77ace40cd'),('73bb76910cc4b6c0000801402b18789d','0E1A4E0F39484456BB2BDE902B4BC275','007a423d09dd4d3891f881affc2168c9'),('752ad92f-a724-4d24-965d-7c299888eb92','0E1A4E0F39484456BB2BDE902B4BC275','363b7606ff644c04a3c7a848d2d322sd'),('7780cce2-efc4-46ab-98b7-e632f180b7f3','016e3a86-3181-4126-8e00-acb2e234bb58','7610cb37255842f892a2bf8bc822cb49'),('7b40056d-b4b0-4f14-b4f7-63fbf8a51113','0E1A4E0F39484456BB2BDE902B4BC275','69DB747E5A464ECDA5E27C5C56C4006C'),('7d07eb43-8b71-4bb5-9815-1d5d077ba2b7','ALL_USER_GROUP','3f57d0b2-99ab-4e66-a938-718befb55369'),('7e0ccd50-9772-4b84-9964-d69395586bda','ALL_USER_GROUP','52f0002d-4ef7-4b27-8c5b-41b9ee80835d'),('7e6b0f83-0834-47b0-bad8-425491dec6b1','2D7A79F2889347B781AF3F162B6CAF8B','38c8a544eaa04aaeaa49d9c77ace40cd'),('84dacff3-2c0a-49a7-bc9a-3fa14289d367','1DF53A025E944C4C95DB5D330083DDB9','363b7606ff644c04a3c7a848d2d32247'),('860553fb0cc4b6c0000801402b187a33','0E1A4E0F39484456BB2BDE902B4BC275','b20574e77d684bc2a7b622b0a7b11c68'),('88e218c2-c88e-4239-9b8f-48d94b63c795','0E1A4E0F39484456BB2BDE902B4BC275','b32834accb544ea7a9a09dcae4a36403'),('95b1eaf61058b6c000080140a69ee2ff','0E1A4E0F39484456BB2BDE902B4BC275','0b6765163d3d4600a35057dc5e64d906'),('9952b873-13e9-4646-8bb7-f3839f6055f4','DE1700C5A51F472D8EC31A36BB0FFF06','95ab7aec-782d-480f-8b86-74a851586b3d'),('99c80daf-7838-4c7c-bf04-5ed5f14d63a6','ALL_USER_GROUP','c1cabfaeb9a448028ffab2148da9f65c'),('9b70267c-8e15-4f5f-ab05-208b9814cebb','0E1A4E0F39484456BB2BDE902B4BC275','5a1e0d97-07b6-4b3a-8e51-80893dbad277'),('9c745a5c-8913-4fdf-bc6c-322b2265c259','35E6CE83F2C242838BF00563E2B1A3AE','cas'),('9dae04c0-f653-4d6b-87a4-1a0d76873d1c','1DF53A025E944C4C95DB5D330083DDB9','33d21613-29a4-bf56-f8b9-0147168b7d20'),('a24e83c60cc4b6c0000801402b187987','0E1A4E0F39484456BB2BDE902B4BC275','483679ad60624d48899e73faa27762f8'),('a27d8717-4c14-4076-bd19-660177e2a98a','10064180F8AC4492B30CBC9F8972C3D7','33d21613-29a4-bf56-f8b9-0147168b7d20'),('a5e575b5-53d5-4cb4-a36e-591f4aa87c7e','0E415B0F253D45B0B752631A0D41D94F','b32834accb544ea7a9a09dcae4a36403'),('a9006883-c143-403c-bc6b-97758c6f9ae3','2D7A79F2889347B781AF3F162B6CAF8B','a40388d23cea4c5ba93bed865b81d255'),('adef03e1-bd05-4c64-a867-13a3610222cc','0E1A4E0F39484456BB2BDE902B4BC275','b8860cc4-b381-48a8-9459-0918c3ab2485'),('afa043d9-bc5c-4d9f-af23-c2e7e878d710','0E415B0F253D45B0B752631A0D41D94F','c1cabfaeb9a448028ffab2148da9f65c'),('b17c6960-bc51-4246-b100-734a750990a3','2D7A79F2889347B781AF3F162B6CAF8B','41065fe3-ae67-4172-a460-fd0079e88294'),('b2c16f6f-68a8-4374-bde9-03cf30a16374','ALL_USER_GROUP','850379a1-7923-4f6b-90be-d363b2dfd2ca'),('b5fa0a8e-393f-451b-a4b2-f5732c7a4729','DE1700C5A51F472D8EC31A36BB0FFF06','5a1e0d97-07b6-4b3a-8e51-80893dbad277'),('b704282f-feb6-46d1-b981-23ff5c6d16bf','016e3a86-3181-4126-8e00-acb2e234bb58','525d261fa3b04d19af0debabbd5a1e2d'),('b79a6f1b-3f3f-45b0-b9d2-65917a6196e6','0E415B0F253D45B0B752631A0D41D94F','69DB747E5A464ECDA5E27C5C56C4006C'),('bb52639a-c574-411c-bd77-d9a85732ccf5','0E1A4E0F39484456BB2BDE902B4BC275','b8860cc4-b381-48a8-9459-0918c3ab2485'),('bccdda70-2849-4fb7-a537-b00112ad9442','0E1A4E0F39484456BB2BDE902B4BC275','e707c852-29a4-bf56-f8b9-014716850d89'),('be0f52d6-979b-4682-9379-06c1998a85e6','0E1A4E0F39484456BB2BDE902B4BC275','5a1e0d97-07b6-4b3a-8e51-80893dbad277'),('c3f19655-d42d-49bf-a28c-b5fd8909dec2','null','cas'),('c8c56e54-8649-49c7-975f-fd365b2415c6','0E1A4E0F39484456BB2BDE902B4BC275','abed57cada2a4b358762f914f0df71e9'),('ce77c3520cc4b6c0000801402b1878cb','0E1A4E0F39484456BB2BDE902B4BC275','0b6765163d3d4600a35057dc5e64d906'),('d376c691-44bf-4c9f-b5bd-f5d56a5834e6','016e3a86-3181-4126-8e00-acb2e234bb58','3f57d0b2-99ab-4e66-a938-718befb55369'),('e03e9984-6584-485f-8602-8222680d9b30','ALL_USER_GROUP','c3d44bb1-e2c4-45dd-91ce-43e821f1321c'),('e22641d1-02a7-4b37-8752-d117a98ffd4a','1DF53A025E944C4C95DB5D330083DDB9','38c8a544eaa04aaeaa49d9c77ace40cd'),('e42f333f-639a-498e-a6e0-f552897704df','2D7A79F2889347B781AF3F162B6CAF8B','7610cb37255842f892a2bf8bc822cb49'),('e518fa71-a07f-4947-be87-419ba500cd68','2D7A79F2889347B781AF3F162B6CAF8B','d623598669d348bca999ab94c73eead6'),('e63184b1-5126-4016-8a10-68b22c389e63','10064180F8AC4492B30CBC9F8972C3D7','363b7606ff644c04a3c7a848d2d32247'),('eb217090-eb60-45bc-a85b-de68a90a7929','ALL_USER_GROUP','fe86db85-5475-4494-b5aa-dbd3b886ff64'),('ec745945-a10f-4a87-af35-16adfb85b9d5','ALL_USER_GROUP','a08d486a-2007-4436-aeda-4310e9443ec7'),('ed8c1917-31e1-444d-bbb8-02697df96dea','6b612583-a9c7-45af-9d81-72acd3417052','3f57d0b2-99ab-4e66-a938-718befb55369'),('f32865e2-9269-4f79-a309-2e6342910116','ALL_USER_GROUP','c8038bd4-12a4-4b45-9d43-61b3ecdc2eb4'),('f427e1a8-7761-480a-a1c4-5cf124bb1be4','ALL_USER_GROUP','e6c21b8c-87f9-461e-918e-5af6cbc57694'),('f43e4dd0-4b9d-4482-b592-4fcb00a9c3c2','2D7A79F2889347B781AF3F162B6CAF8B','33d21613-29a4-bf56-f8b9-0147168b7d20'),('f4866d00-2012-4313-9906-ef94454fd910','ALL_USER_GROUP','78917a82-1c86-4020-b86a-3b1b350357e3'),('f5efde85-a6ed-429c-9d47-c011d65571fb','0E1A4E0F39484456BB2BDE902B4BC275','95ab7aec-782d-480f-8b86-74a851586b3d'),('f675b13f-748b-4ad4-b2d6-1539b5cd0752','0E1A4E0F39484456BB2BDE902B4BC275','d623598669d348bca999ab94c73eead6'),('f94ee98a-8285-49a9-a249-14af5772e231','0E1A4E0F39484456BB2BDE902B4BC275','95ab7aec-782d-480f-8b86-74a851586b3d'),('f9978fd3-2154-4839-96b8-a1fd8b909d3c','2D7A79F2889347B781AF3F162B6CAF8B','b32834accb544ea7a9a09dcae4a36403'),('fb9256eb-b5cf-4bf1-b6a3-d9be7b9d5f91','0E1A4E0F39484456BB2BDE902B4BC275','c11a96e39c744583a10293b44c415f55'),('fe2ae10e-a69f-44a9-af9e-0ee6ca547713','ALL_USER_GROUP','ae20330a-ef0b-4dad-9f10-d5e3485ca2ad'),('fe2ae10e-a69f-44a9-af9e-0ee6ca5477a4','ALL_USER_GROUP','41065fe3-ae67-4172-a460-fd0079e88294'),('fe2ae10e-a69f-44a9-af9e-0ee6ca5477ab','2D7A79F2889347B781AF3F162B6CAF8B','363b7606ff644c04a3c7a848d2d32247');
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `groups`;
- ;
- ;
- CREATE TABLE `groups` (
- `ID` varchar(45) NOT NULL COMMENT '主é®',
- `NAME` varchar(100) DEFAULT NULL COMMENT 'åºç¨è§è²å',
- `STATUS` tinyint(3) unsigned DEFAULT NULL COMMENT 'ç¶æ',
- `CREATEDBY` varchar(45) DEFAULT NULL COMMENT 'å建人',
- `ISDEFAULT` tinyint(3) unsigned DEFAULT NULL COMMENT 'é»è®¤è§è²',
- `CREATEDDATE` date DEFAULT NULL COMMENT 'å建æ¶é´',
- `MODIFIEDBY` varchar(45) DEFAULT NULL COMMENT 'ä¿®æ¹äºº',
- `MODIFIEDDATE` date DEFAULT NULL COMMENT 'ä¿®æ¹æ¶é´',
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='åºç¨è§è²è¡¨';
- ;
- LOCK TABLES `groups` WRITE;
- ;
- INSERT INTO `groups` VALUES ('35E6CE83F2C242838BF00563E2B1A3AE','role1',1,'admin',0,'2012-07-11',NULL,NULL),('7BA5E4713E994E3BBC11BA642DF988BF','CRM角色',1,'admin',0,'2012-06-21','7BF5315CA1004CDB8E614B0361C4D46A','2012-06-26'),('87B69209FEEE4BDE9E7377AAB28B5B76','role2',1,'admin',0,'2012-07-11',NULL,NULL),('AB3400CE12D640618DAEAEBEBA52B8BD','HR系统角色',1,'admin',0,'2012-06-21',NULL,NULL),('ALL_USER_GROUP','所有认证用户组',1,NULL,1,NULL,NULL,NULL),('DE1700C5A51F472D8EC31A36BB0FFF06','OA角色',1,'admin',1,'2012-06-21',NULL,NULL);
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `history_login`;
- ;
- ;
- CREATE TABLE `history_login` (
- `ID` varchar(45) NOT NULL COMMENT '主é®',
- `USERNAME` varchar(200) NOT NULL COMMENT 'ç»å½å',
- `DISPLAYNAME` varchar(45) DEFAULT NULL COMMENT 'å§å',
- `MESSAGE` varchar(200) DEFAULT NULL COMMENT 'æ¶æ¯',
- `SOURCEIP` varchar(45) DEFAULT NULL COMMENT 'æä½IP',
- `LOGINTIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'è®¤è¯æ¶é´',
- `LOGINTYPE` varchar(45) DEFAULT NULL COMMENT 'ç±»å',
- `UID` varchar(45) NOT NULL COMMENT 'ç¨æ·ID',
- `CODE` varchar(45) DEFAULT NULL COMMENT 'ç¼ç ',
- `PROVIDER` varchar(45) DEFAULT NULL COMMENT 'ç¬¬ä¸æ¹',
- `SESSIONID` varchar(45) DEFAULT NULL COMMENT 'ä¼è¯',
- `BROWSER` varchar(45) DEFAULT NULL COMMENT 'æµè§å¨çæ¬',
- `PLATFORM` varchar(45) DEFAULT NULL COMMENT 'å¹³å°',
- `APPLICATION` varchar(45) DEFAULT NULL COMMENT 'åºç¨ç¨åº',
- `LOGINURL` varchar(450) DEFAULT NULL COMMENT 'ç»å½URL',
- `LOGOUTTIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'ç»åºæ¶é´',
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ç»å½æ¥å¿è¡¨';
- ;
- LOCK TABLES `history_login` WRITE;
- ;
- INSERT INTO `history_login` VALUES ('092f65d4-4604-4c09-8b11-457e3af834df','admin','系统管理员','success','127.0.0.1','2020-02-05 09:45:46','Social Sign On','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','dingtalk','6497e50c-163f-43db-a5f4-f116b30376eb','Chrome/79','Windows NT 10.0','Browser','2020-02-05 17:45:46','0000-00-00 00:00:00'),('094921c7-6b1a-4556-8efd-d0ea142de1a3','admin','系统管理员','success','127.0.0.1','2019-12-04 15:53:57','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','8f5b2c26-4528-4b0c-8290-80f2e374130e','Chrome/78','Windows NT 10.0','Browser','2019-12-04 23:53:57','0000-00-00 00:00:00'),('0d17173b-9883-4817-8400-364f342e8e80','admin','系统管理员','success','127.0.0.1','2019-12-08 11:32:15','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','e7554c39-0aa5-4cb3-be64-71117017e555','Chrome/78','Windows NT 10.0','Browser','2019-12-08 19:32:15','0000-00-00 00:00:00'),('0deabdf4-2730-4b51-8772-f5ce9a5e9a08','admin','系统管理员','success','127.0.0.1','2019-12-08 11:27:02','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','01cd1509-9eaa-4aaa-a9aa-1b4894f134e2','Chrome/78','Windows NT 10.0','Browser','2019-12-08 19:27:02','2019-12-08 11:32:05'),('11a6dfc7-5d36-43fe-bf6c-9dccf6f1dd12','admin','系统管理员','success','127.0.0.1','2019-11-09 14:05:08','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','03e25597-33e1-43d1-80b7-37be15bdecf5','Chrome/78','Windows NT 10.0','Browser','2019-11-09 22:05:08','2019-11-09 14:23:38'),('12e7120a-c7e1-45fe-8d74-d12e95d5880d','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-04 14:45:03','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','f3691728-4580-4a4c-b204-4c96102a404e','Chrome/77','Windows NT 10.0','Browser','2019-11-04 22:45:03','0000-00-00 00:00:00'),('14db82b0-d2b2-4bf3-b4db-b62093f89d23','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-09 01:02:47','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','3fc6ee3b-5910-4e87-b504-5b5621fa48d4','Chrome/78','Windows NT 10.0','Browser','2019-11-09 09:02:47','0000-00-00 00:00:00'),('15035d4b-c5c7-4367-ace9-f9a8b4d8e2a3','admin','系统管理员','success','127.0.0.1','2019-12-02 14:59:56','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','0e66485e-2816-4f58-bd5c-c48f79f9ee90','Chrome/78','Windows NT 10.0','Browser','2019-12-02 22:59:56','0000-00-00 00:00:00'),('1937c1bd-ff1a-46e4-8307-7bcac1022139','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-09 10:16:48','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','c78f3ac8-2eae-4733-b7a8-01d74908e021','Chrome/78','Windows NT 10.0','Browser','2019-11-09 18:16:48','2019-11-09 10:28:45'),('1b43ea5f-7d68-4111-831f-f2b969ae25eb','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-06 14:58:26','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','98ef9cb6-ba1b-41ff-bf40-a2cb2d63b0c0','Chrome/77','Windows NT 10.0','Browser','2019-11-06 22:58:26','0000-00-00 00:00:00'),('2186d5f9-e0d1-4e75-845d-85e738aced91','admin','系统管理员','success','127.0.0.1','2019-11-09 14:48:25','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','d68ae4c5-b749-4ccd-bb18-e362c9db329a','Chrome/78','Windows NT 10.0','Browser','2019-11-09 22:48:25','0000-00-00 00:00:00'),('21afcfa5-da5b-49ef-82b4-5ec12ed2514a','admin','系统管理员','success','127.0.0.1','2019-12-02 14:38:09','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','0d75b467-4d1d-4707-a9d5-4cba197f18e9','Chrome/78','Windows NT 10.0','Browser','2019-12-02 22:38:09','0000-00-00 00:00:00'),('23ac5c2e-d2a0-4e4d-bbd8-d650b5463554','admin','系统管理员','success','127.0.0.1','2019-12-02 04:06:04','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','546f9be3-83a6-46d7-9e12-074af6ee9ef3','Chrome/78','Windows NT 10.0','Browser','2019-12-02 12:06:04','2019-12-02 04:10:03'),('24025b37-d043-4890-a2a8-fa41b6d750c8','admin','系统管理员','success','127.0.0.1','2019-12-08 10:32:03','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','130e5b27-c124-400a-a523-b021bec519a7','Chrome/78','Windows NT 10.0','Browser','2019-12-08 18:32:03','0000-00-00 00:00:00'),('2402a0d9-11ae-4fe8-81e0-bd58e331bb9f','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-10-30 15:00:28','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','06e55836-4fd5-4f66-b4c5-653b4f793119','Chrome/77','Windows NT 10.0','Browser','2019-10-30 23:00:28','0000-00-00 00:00:00'),('24ede113-b483-44a0-8a55-9b51ab364051','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-07 14:33:02','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','b668efa3-8423-4ed6-95d4-c38414a50491','Chrome/77','Windows NT 10.0','Browser','2019-11-07 22:33:02','0000-00-00 00:00:00'),('2577b5d2-205d-45bb-9186-4004c059864e','admin','系统管理员','success','127.0.0.1','2019-12-16 13:37:09','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','07e875c1-be6d-4f1e-bafa-4a6bf5977a14','Chrome/79','Windows NT 10.0','Browser','2019-12-16 21:37:09','0000-00-00 00:00:00'),('2b110937-a553-4edf-8f40-325b7bed1d7f','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-06 14:53:01','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','ca5d7ad6-1a9c-426a-bb85-9394a1940a0f','Chrome/77','Windows NT 10.0','Browser','2019-11-06 22:53:01','0000-00-00 00:00:00'),('2c4bdaaa-cfd7-4898-a53c-c57a6b8bec57','admin','系统管理员','success','127.0.0.1','2020-02-05 09:39:29','Social Sign On','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','dingtalk','35fc2cad-3688-4c47-9b26-0d275aeb5939','Chrome/79','Windows NT 10.0','Browser','2020-02-05 17:39:29','0000-00-00 00:00:00'),('305529f4-d40c-4877-9c2f-529430d431fb','admin','系统管理员','success','127.0.0.1','2020-02-05 11:38:40','Social Sign On','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','新浪微博','6300078e-803d-4698-9bec-95e40089daa0','Chrome/79','Windows NT 10.0','Browser','2020-02-05 19:38:40','2020-02-05 11:38:51'),('3077aae7-6298-4234-99ec-0f8390d06ebc','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-08 14:46:30','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','8854f632-873d-4108-935e-2006cc23f7f0','Chrome/78','Windows NT 10.0','Browser','2019-11-08 22:46:30','0000-00-00 00:00:00'),('32092eb3-436c-4c09-8c35-a17b79597f9c','admin','系统管理员','success','127.0.0.1','2020-02-17 15:04:49','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','d2b5bf64-3cd7-4606-86bb-e02b7f11558e','Chrome/79','Windows NT 10.0','Browser','2020-02-17 23:04:49','0000-00-00 00:00:00'),('36f78202-b41d-4044-bee2-7cd65811e189','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-12-31 13:25:00','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','07f4686a-1923-4d84-8e5d-001c22ec77a2','Chrome/79','Windows NT 10.0','Browser','2019-12-31 21:25:00','0000-00-00 00:00:00'),('39ca6a90-028c-4504-9896-356216d8f7dc','admin','系统管理员','success','127.0.0.1','2019-12-08 14:27:38','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','8157f7d1-3897-4206-9369-2401fc796482','Chrome/78','Windows NT 10.0','Browser','2019-12-08 22:27:38','0000-00-00 00:00:00'),('4086d31a-94a0-4c28-9dbe-ee345f730562','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-06 15:28:25','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','2e0c997f-6ce2-409b-b8a7-8d99fcd1ce66','Chrome/77','Windows NT 10.0','Browser','2019-11-06 23:28:25','0000-00-00 00:00:00'),('41a7c0a7-1203-4fca-91c7-ee434f31b12a','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-09 10:04:38','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','37cce053-b022-4331-b110-b808472f4ca3','Chrome/78','Windows NT 10.0','Browser','2019-11-09 18:04:38','0000-00-00 00:00:00'),('43a61c35-3e1d-48da-934a-a5f344ad58be','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-10-20 14:47:29','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','881e00e9-0047-4661-b7b2-f76dbd3a46c9','Chrome/77','Windows NT 10.0','Browser','2019-10-20 22:47:29','0000-00-00 00:00:00'),('469e92ca-be69-4d62-bc61-4d1a9b1d7554','admin','系统管理员','success','127.0.0.1','2019-12-26 14:23:18','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','bc3583ca-e3a1-4ea6-8ebe-63c3f5e2f6e7','Chrome/79','Windows NT 10.0','Browser','2019-12-26 22:23:18','0000-00-00 00:00:00'),('4b462700-0ed7-40c9-929e-c315cd3fd2e3','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-12-16 13:41:39','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','e497ee74-19a4-48e5-85fe-43ea0f2c655f','Chrome/79','Windows NT 10.0','Browser','2019-12-16 21:41:39','0000-00-00 00:00:00'),('4bbfcdce-efd2-4770-a501-3c7b87bbc518','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-10-21 15:46:44','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','19b2a9e4-94fc-4c8a-826b-ac20bab14e2d','Chrome/77','Windows NT 10.0','Browser','2019-10-21 23:46:44','0000-00-00 00:00:00'),('4e3bc4be-9e27-4e43-8160-4e12f9b61b4b','admin','系统管理员','success','127.0.0.1','2019-12-30 15:19:25','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','926e6924-5931-430e-98ce-16e9261c408f','Chrome/79','Windows NT 10.0','Browser','2019-12-30 23:19:25','0000-00-00 00:00:00'),('50ae5771-f04b-433c-8d81-05e4ff4d6bc3','admin','系统管理员','success','127.0.0.1','2019-12-16 13:32:25','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','9e139167-7e06-4053-a9ee-024e168673b2','Chrome/79','Windows NT 10.0','Browser','2019-12-16 21:32:25','0000-00-00 00:00:00'),('5179d964-fa8b-4a28-b286-8e6816771848','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-04 15:46:04','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','a285178a-2672-45a5-841c-bc20040ca16c','Chrome/77','Windows NT 10.0','Browser','2019-11-04 23:46:04','0000-00-00 00:00:00'),('54a63b5b-0000-4699-8cd5-30aed4d8fba5','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-07 13:30:38','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','afe35752-19ed-4140-9042-16123678d594','Chrome/77','Windows NT 10.0','Browser','2019-11-07 21:30:38','2019-11-07 14:15:55'),('57d624db-e7eb-4644-a22a-238c2f823cb3','admin','系统管理员','success','127.0.0.1','2019-12-06 13:42:32','Jwt','7BF5315CA1004CDB8E614B0361C4D46B','','','c4ead355-62b4-4167-a21a-51c97f5255ee','Chrome/78','Windows NT 10.0','Browser','2019-12-06 21:42:32','0000-00-00 00:00:00'),('58bc4415-b2ab-4867-a330-f05d90d292cf','admin','系统管理员','success','127.0.0.1','2020-02-17 14:52:15','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','55f71822-0331-4022-8a15-6cbe4aa2704d','Chrome/79','Windows NT 10.0','Browser','2020-02-17 22:52:15','0000-00-00 00:00:00'),('5b0ff6d8-2aca-4827-b608-e5506813d435','admin','系统管理员','success','127.0.0.1','2019-12-08 10:50:06','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','434c78db-7f12-4d50-ba6f-fa4932160b46','Chrome/78','Windows NT 10.0','Browser','2019-12-08 18:50:05','0000-00-00 00:00:00'),('5d126fbb-20ba-4035-9306-83ff24f711ab','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-10-30 14:54:46','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','3b4de92b-948a-4b42-9d5d-2803216c62dd','Chrome/77','Windows NT 10.0','Browser','2019-10-30 22:54:46','0000-00-00 00:00:00'),('5fb10fa1-b467-4a9e-bed4-f029202d997f','admin','系统管理员','success','127.0.0.1','2020-02-17 14:59:14','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','8f6b228b-b0cb-4b47-873c-544cd61d2122','Chrome/79','Windows NT 10.0','Browser','2020-02-17 22:59:14','2020-02-17 14:59:27'),('62144031-b5d8-4f01-b962-bf0a3b4a3e05','admin','系统管理员','success','127.0.0.1','2019-12-30 13:24:40','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','9496c5d9-ed8c-45fc-abf7-dcc49e4aface','Chrome/79','Windows NT 10.0','Browser','2019-12-30 21:24:40','0000-00-00 00:00:00'),('644000f4-0665-4c31-88b8-2f883ce54675','admin','系统管理员','success','127.0.0.1','2020-02-05 09:58:55','Social Sign On','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','dingtalk','081e071a-6847-4b9d-b5b5-89ae871e45eb','Chrome/79','Windows NT 10.0','Browser','2020-02-05 17:58:54','0000-00-00 00:00:00'),('64900db2-f2d9-49a7-9845-852ac8708c28','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-09 01:06:05','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','0fc5e1e5-4bf3-4a4e-9d52-77e2a84bfb71','Chrome/78','Windows NT 10.0','Browser','2019-11-09 09:06:05','0000-00-00 00:00:00'),('6bc27d76-afff-4721-98b5-cc86589b257a','admin','系统管理员','success','127.0.0.1','2019-11-09 10:58:59','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','b4b9d103-a850-499c-9ec5-7e4d5e1b677e','Chrome/78','Windows NT 10.0','Browser','2019-11-09 18:58:59','0000-00-00 00:00:00'),('6c4b7032-327a-4114-af59-903342143026','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-10-29 15:00:11','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','262ee673-8ac3-4e7e-8344-d216ff5994ab','Chrome/77','Windows NT 10.0','Browser','2019-10-29 23:00:11','0000-00-00 00:00:00'),('71c7652a-f241-4e3b-bac3-1b5855530ced','admin','系统管理员','success','127.0.0.1','2019-12-02 04:10:12','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','2d32a090-495e-4308-a40c-8a4eacd176cf','Chrome/78','Windows NT 10.0','Browser','2019-12-02 12:10:12','0000-00-00 00:00:00'),('76f041ef-732d-4c5d-b064-e52779cf92e9','admin','系统管理员','success','127.0.0.1','2020-02-05 11:38:29','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','22e92b63-4ee4-4acb-aef8-85707768bde6','Chrome/79','Windows NT 10.0','Browser','2020-02-05 19:38:29','2020-02-05 11:38:37'),('77060425-f04e-4624-b6e7-1d37ffe47c2a','admin','系统管理员','success','127.0.0.1','2020-02-05 09:51:03','Social Sign On','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','dingtalk','eed11616-e532-47cb-bda5-0ef980f52828','Chrome/79','Windows NT 10.0','Browser','2020-02-05 17:51:03','0000-00-00 00:00:00'),('77397d99-865b-4ee9-974e-013a0fc2a7dc','admin','系统管理员','success','127.0.0.1','2019-11-09 10:45:00','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','dfc2eb06-bbbc-4959-a8b1-aedb35686fdc','MSIE/ Touch','Windows NT 10.0','Browser','2019-11-09 18:45:00','0000-00-00 00:00:00'),('7e3d48cc-602c-464a-bd85-cf86d61a57ea','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-10-20 14:44:23','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','7db4e942-dfc4-4539-bf0b-317aea98222c','Chrome/77','Windows NT 10.0','Browser','2019-10-20 22:44:23','0000-00-00 00:00:00'),('7f438485-83b9-4174-802b-1bb33fcf44ae','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-09 02:28:45','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','1df9c283-01de-45a3-82a1-4dc1b4e7686d','Chrome/78','Windows NT 10.0','Browser','2019-11-09 10:28:45','2019-11-09 02:29:35'),('7f954cde-ce70-414b-8a5d-7c7404bfe791','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-09 03:28:22','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','d550de99-7ed4-4b39-b61f-186abe4ca271','Chrome/78','Windows NT 10.0','Browser','2019-11-09 11:28:22','0000-00-00 00:00:00'),('837a5d53-a6d1-4c67-bb7f-97414bd235f5','admin','系统管理员','success','127.0.0.1','2019-12-08 11:23:50','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','23e7e65e-20a6-4808-8564-53de5b41fa13','Chrome/78','Windows NT 10.0','Browser','2019-12-08 19:23:50','2019-12-08 11:26:55'),('86304e15-610f-438a-8e36-0d934f7a6757','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-02 07:46:03','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','122e7048-6333-4b96-ac46-c989d85dfdc5','Chrome/77','Windows NT 10.0','Browser','2019-11-02 15:46:03','0000-00-00 00:00:00'),('8a92127f-2ad9-4941-9235-8d08b479ab28','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-12-16 14:21:02','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','48525a80-fed1-49fd-86b3-b60ad63e0ce0','Chrome/79','Windows NT 10.0','Browser','2019-12-16 22:21:02','0000-00-00 00:00:00'),('8f61b272-4080-4e03-820f-19e6274fbb78','admin','系统管理员','success','127.0.0.1','2019-12-08 10:57:51','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','2a5a75a5-e616-4c0f-8c90-289e65384de1','Chrome/78','Windows NT 10.0','Browser','2019-12-08 18:57:51','2019-12-08 11:23:41'),('90348d1e-1a60-4cf1-9dc2-d4bf35ad2edc','admin','系统管理员','success','127.0.0.1','2019-11-09 01:49:18','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','ba1efb04-f5ac-4e69-831b-d40952c134ac','Chrome/78','Windows NT 10.0','Browser','2019-11-09 09:49:18','0000-00-00 00:00:00'),('93c7501c-afcf-45be-94b4-caaeaf9ec74b','admin','系统管理员','success','127.0.0.1','2019-11-09 01:45:35','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','a24d4f30-5508-43d7-9e29-5dfd7b57320e','Chrome/78','Windows NT 10.0','Browser','2019-11-09 09:45:35','2019-11-09 01:49:00'),('93c7eafc-0a3c-4122-a04b-e59ee2afc861','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-04 14:02:09','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','b6dc6e15-bb91-4a36-899a-fab7e1b89709','Chrome/77','Windows NT 10.0','Browser','2019-11-04 22:02:09','0000-00-00 00:00:00'),('952011da-dc11-4554-9b84-a4a859e4e883','admin','系统管理员','success','127.0.0.1','2020-02-05 09:31:22','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','fa76c16d-b755-4b4c-8410-557f43cffb73','Chrome/79','Windows NT 10.0','Browser','2020-02-05 17:31:22','2020-02-05 09:38:53'),('9604dcb8-08fa-4d87-ad64-bf1ada4bcb2b','admin','系统管理员','success','127.0.0.1','2019-12-08 15:00:33','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','ace6500f-2537-49dc-b2a5-f907b3790174','Chrome/78','Windows NT 10.0','Browser','2019-12-08 23:00:33','0000-00-00 00:00:00'),('961ecee0-7873-4da5-9f02-12e07797d18d','admin','系统管理员','success','0:0:0:0:0:0:0:1','2020-02-07 03:46:37','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','0d2dcf94-8b88-47e9-a797-2eb784a82b44','Chrome/79','Windows NT 10.0','Browser','2020-02-07 11:46:37','0000-00-00 00:00:00'),('9672f460-5861-474d-b669-cfb7921d13eb','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-10-22 14:41:13','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','cbcd9c77-79e3-4b5d-a3ac-0a5dfcd0c854','Chrome/77','Windows NT 10.0','Browser','2019-10-22 22:41:13','0000-00-00 00:00:00'),('9764f180-b539-4d36-96a3-8983cadd1e3d','admin','系统管理员','success','127.0.0.1','2020-02-17 15:15:27','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','b6857a5e-c5eb-4a29-9db4-c8c74ab27113','Chrome/79','Windows NT 10.0','Browser','2020-02-17 23:15:27','0000-00-00 00:00:00'),('9bbd3e07-92e7-4461-8d9a-33930d3440e3','admin','系统管理员','success','127.0.0.1','2020-02-17 14:55:18','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','f5ca7d37-7491-4e18-b0c7-5307bd2686aa','Chrome/79','Windows NT 10.0','Browser','2020-02-17 22:55:18','0000-00-00 00:00:00'),('9d84c430-62ee-4a84-84df-5669627c2f8f','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-12-31 13:13:36','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','7453e807-1a1d-4869-9cf6-93dd48472b76','Chrome/79','Windows NT 10.0','Browser','2019-12-31 21:13:36','2019-12-31 13:13:59'),('9dfa254a-767a-4c7e-ac1b-8e7fb0f01517','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-12-02 04:03:21','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','4b3719ed-fd1f-45e0-afb8-6da1acb03d72','Chrome/78','Windows NT 10.0','Browser','2019-12-02 12:03:21','0000-00-00 00:00:00'),('9f974c2f-f419-4f3e-ad48-52663b486061','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-10-20 15:19:59','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','9c277049-e9e4-4d0b-8b20-a8703458899c','Chrome/77','Windows NT 10.0','Browser','2019-10-20 23:19:59','0000-00-00 00:00:00'),('a0483e46-efc9-4660-a9e7-398df8a297f1','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-10-29 15:50:18','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','e837fd57-2efe-4627-bb85-fb3c087a9074','Chrome/77','Windows NT 10.0','Browser','2019-10-29 23:50:18','0000-00-00 00:00:00'),('a597d4a0-be6f-417f-bfad-1c781136e17e','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-04 15:52:32','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','bcdaf679-1e06-43da-b5c9-a30dd616c4e5','Chrome/77','Windows NT 10.0','Browser','2019-11-04 23:52:32','0000-00-00 00:00:00'),('a5a9c0ef-9822-4671-8a3e-7d9b7415a919','admin','系统管理员','success','127.0.0.1','2020-02-05 10:15:58','Social Sign On','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','dingtalk','5e7af068-44da-42cc-a2c5-ba981d197593','Chrome/79','Windows NT 10.0','Browser','2020-02-05 18:15:58','2020-02-05 10:16:30'),('a6b9651d-b0e5-4aed-82c7-416b8b5f92b1','admin','系统管理员','success','127.0.0.1','2019-11-09 10:43:25','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','fcedbcc7-3426-400e-bcf0-def47a14833d','Chrome/78','Windows NT 10.0','Browser','2019-11-09 18:43:25','0000-00-00 00:00:00'),('a7da5d68-1595-4525-8916-477a0cc63edf','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-02 07:28:11','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','f171642d-3a22-43d9-a378-71260a18e8e0','Chrome/77','Windows NT 10.0','Browser','2019-11-02 15:28:11','0000-00-00 00:00:00'),('a8d854f1-7dcb-4b0b-9d37-10f53f7e7637','admin','系统管理员','success','127.0.0.1','2019-11-09 03:18:13','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','c3d47b1c-f961-45b2-a909-c2a63ebfa28a','Chrome/78','Windows NT 10.0','Browser','2019-11-09 11:18:13','0000-00-00 00:00:00'),('aaf31480-ead5-40d6-9523-dbea71d50f7f','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-07 15:58:30','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','408da3a5-7544-4fb7-b970-f4a99868f047','Chrome/77','Windows NT 10.0','Browser','2019-11-07 23:58:30','0000-00-00 00:00:00'),('aec58000-a4ed-4546-b7a5-0959ac755834','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-02 11:04:05','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','c39868dc-7c0f-41e7-ac2c-b3ea93fc67c1','Chrome/77','Windows NT 10.0','Browser','2019-11-02 19:04:05','0000-00-00 00:00:00'),('b0165a8f-eee0-46f7-910e-3ec0390da019','admin','系统管理员','success','127.0.0.1','2020-02-17 14:50:01','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','4cda3927-420e-480f-a6c5-e8039531c664','Chrome/79','Windows NT 10.0','Browser','2020-02-17 22:50:01','0000-00-00 00:00:00'),('b3b0fd79-de1f-48b2-a5e7-7f8f02b6f92e','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-02 08:40:09','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','227fa42e-74e6-4647-9ac7-1852008325f1','Chrome/77','Windows NT 10.0','Browser','2019-11-02 16:40:09','0000-00-00 00:00:00'),('b4db274c-549a-4f41-ac45-ae6db651e392','admin','系统管理员','success','127.0.0.1','2019-12-06 13:25:58','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','80a2710c-91ae-416e-be6f-bc19f6e74166','Chrome/78','Windows NT 10.0','Browser','2019-12-06 21:25:58','0000-00-00 00:00:00'),('b52a2c85-6241-4893-99a6-6a2a2f6e193d','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-05 15:13:02','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','8a9ae8de-16c1-46a3-9433-4693a4688651','Chrome/77','Windows NT 10.0','Browser','2019-11-05 23:13:02','0000-00-00 00:00:00'),('ba9ff748-03cf-4ba2-b6e8-aa62e43339d1','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-07 14:16:15','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','5dd5579a-7e72-4e4a-a525-cd18a99c77b9','Chrome/77','Windows NT 10.0','Browser','2019-11-07 22:16:15','2019-11-07 14:32:49'),('bb954985-9e87-4787-92f0-c239139a00d3','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-04 15:50:02','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','3a1e3bf5-2db8-40f6-9ad0-861c16790fc5','Chrome/77','Windows NT 10.0','Browser','2019-11-04 23:50:02','0000-00-00 00:00:00'),('bda7bd29-d60e-46a9-af25-2259767d7b52','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-06 14:26:42','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','93bac58b-091b-42f2-9747-daac6b33aaff','Chrome/77','Windows NT 10.0','Browser','2019-11-06 22:26:42','0000-00-00 00:00:00'),('c4f7de49-f335-4c85-9d98-9a7be8d32532','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-10-20 13:01:29','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','7db51f3a-108c-4cf4-b15b-97c32c63ab56','Chrome/77','Windows NT 10.0','Browser','2019-10-20 21:01:29','0000-00-00 00:00:00'),('c54a4b2a-b0a9-4da4-abf4-0e62596cbac2','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-10-23 15:27:19','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','e64124dc-54fd-4104-9f5c-fd03710bd3f5','Chrome/77','Windows NT 10.0','Browser','2019-10-23 23:27:19','0000-00-00 00:00:00'),('c6a08bdf-33df-4f66-bd17-98c9ddb63f98','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-10-30 15:14:03','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','2934dcbc-1501-4ff0-8fd9-327c954bc7df','Chrome/77','Windows NT 10.0','Browser','2019-10-30 23:14:03','0000-00-00 00:00:00'),('cc589035-89e5-4a9f-b876-c80c379b29f5','admin','系统管理员','success','127.0.0.1','2019-12-26 14:19:32','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','45697390-b922-4cca-9725-4d836cef164e','Firefox/71','Windows NT 10.0','Browser','2019-12-26 22:19:32','0000-00-00 00:00:00'),('ccd0028a-815d-4479-b21e-ca80fe91b518','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-10-20 12:41:03','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','9c5da3b6-97e4-4239-b5f8-8990a9e3b9e4','Chrome/77','Windows NT 10.0','Browser','2019-10-20 20:41:03','0000-00-00 00:00:00'),('ccec12d2-c4cb-406c-b308-7cd7cb48c650','admin','系统管理员','success','127.0.0.1','2019-12-16 13:27:24','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','e7010261-a077-48af-a5cc-588712423976','Chrome/79','Windows NT 10.0','Browser','2019-12-16 21:27:24','0000-00-00 00:00:00'),('ce63a4e9-273f-4b84-b451-b294a24ececf','admin','系统管理员','success','127.0.0.1','2020-02-05 10:16:50','Social Sign On','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','dingtalk','7e1424b7-d384-433f-a4e2-e01e43a69198','Chrome/79','Windows NT 10.0','Browser','2020-02-05 18:16:50','0000-00-00 00:00:00'),('d17ee2ef-6756-4134-a2ca-cd28ddb815e6','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-07 16:00:20','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','89c1b5eb-9810-457e-b693-0ec7cf0a599b','Chrome/77','Windows NT 10.0','Browser','2019-11-08 00:00:20','0000-00-00 00:00:00'),('d4d748a0-dcac-49a6-938b-f6ef945180a3','admin','系统管理员','success','127.0.0.1','2019-11-09 02:29:48','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','c3a9b83c-bc9a-4f08-8580-0ed476042bfb','Chrome/78','Windows NT 10.0','Browser','2019-11-09 10:29:48','0000-00-00 00:00:00'),('dd022de9-042e-487c-b250-c784c9fff4b0','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-08 15:10:33','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','b64311b4-c64a-4a74-88af-890e87af4a41','Chrome/78','Windows NT 10.0','Browser','2019-11-08 23:10:33','0000-00-00 00:00:00'),('dfe0ba33-374a-4c94-8fef-02396c425804','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-12-16 14:24:17','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','449a360e-d24b-4402-baef-1803a94a9bdc','Chrome/79','Windows NT 10.0','Browser','2019-12-16 22:24:17','2019-12-16 14:24:20'),('e1b99914-b1e5-4bea-b949-bb8abbbe2983','admin','系统管理员','success','127.0.0.1','2020-02-05 11:20:45','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','c3acdd96-13e3-45d5-8789-8f1d7c81650d','Chrome/79','Windows NT 10.0','Browser','2020-02-05 19:20:45','2020-02-05 11:23:44'),('e1c4cc13-3ebe-41ea-b651-cd971a2ed3bd','admin','系统管理员','success','127.0.0.1','2019-11-09 10:29:06','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','ad186813-1c49-491a-b632-5576e91955b1','Chrome/78','Windows NT 10.0','Browser','2019-11-09 18:29:06','0000-00-00 00:00:00'),('e1ee0549-5adc-4a27-b4e4-f7ddb1007251','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-09 01:40:59','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','4e7e9212-75ba-4655-9da5-5737b65cfae6','Chrome/78','Windows NT 10.0','Browser','2019-11-09 09:40:59','0000-00-00 00:00:00'),('e2e8c05a-a649-40a8-8a8a-4fe6a1d6efc8','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-09 03:33:23','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','6e797edf-faef-4f29-988b-c99d628195a6','Chrome/78','Windows NT 10.0','Browser','2019-11-09 11:33:23','0000-00-00 00:00:00'),('e414b653-78e2-40de-80f1-14834ce53cc7','admin','系统管理员','success','127.0.0.1','2019-12-02 04:10:15','Jwt','7BF5315CA1004CDB8E614B0361C4D46B','','','bc0871db-0163-436c-955c-3d6a8eb98bd5','Chrome/78','Windows NT 10.0','Browser','2019-12-02 12:10:15','0000-00-00 00:00:00'),('e603dc84-620d-40c3-8503-1c2399600f7d','admin','系统管理员','success','127.0.0.1','2019-12-16 13:21:10','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','cc0b275a-f7b6-454e-b678-816e7cb5ed56','Chrome/79','Windows NT 10.0','Browser','2019-12-16 21:21:10','0000-00-00 00:00:00'),('e7b7cae3-3a88-4184-a2e2-81f490e179c0','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-12-02 14:15:40','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','7141c90b-1b9b-478f-b39d-72c119bbd619','Chrome/78','Windows NT 10.0','Browser','2019-12-02 22:15:40','0000-00-00 00:00:00'),('ed32d66e-5ab9-4e55-a720-f45d6dc8a779','admin','系统管理员','success','127.0.0.1','2019-12-04 15:14:08','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','e6790702-7344-4909-a4f8-b47e37a24b8a','Chrome/78','Windows NT 10.0','Browser','2019-12-04 23:14:08','2019-12-04 15:14:46'),('f03e8e5b-5613-4e77-b69d-04c3df77e773','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-07 15:54:57','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','71b6b7f9-2b7f-4a2d-81e3-c40e244cb38d','Chrome/77','Windows NT 10.0','Browser','2019-11-07 23:54:57','0000-00-00 00:00:00'),('f2c18a7b-0771-4ec1-a786-708d55aba341','admin','系统管理员','success','127.0.0.1','2019-12-02 14:29:25','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','3a86c7bf-f735-4b81-ab15-2e843cb091ac','Chrome/78','Windows NT 10.0','Browser','2019-12-02 22:29:25','0000-00-00 00:00:00'),('f3d3e385-aac0-4f3a-a122-4c0c5e17691a','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-02 08:28:25','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','26d1afd0-1741-470a-a558-be7532bebe3c','Chrome/77','Windows NT 10.0','Browser','2019-11-02 16:28:25','0000-00-00 00:00:00'),('f3da79f2-e49a-4a66-a16a-25df0a381fb1','admin','系统管理员','success','127.0.0.1','2019-12-16 13:25:21','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','e1b5d38e-7ba9-4b01-af44-94738877fbab','Chrome/79','Windows NT 10.0','Browser','2019-12-16 21:25:21','0000-00-00 00:00:00'),('fb55c52a-c315-4fb3-a878-1652f67a8373','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-11-08 14:29:24','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','eda90658-e76d-4ba7-b2b7-28729f9b1c6d','Chrome/78','Windows NT 10.0','Browser','2019-11-08 22:29:24','0000-00-00 00:00:00'),('fc6f5e6f-3536-4eb9-9929-737233875f9d','admin','系统管理员','success','0:0:0:0:0:0:0:1','2019-10-31 15:01:26','Local Login','7BF5315CA1004CDB8E614B0361C4D46B','xe00000004','','dc680e9d-83d8-4a48-b92b-73bdc8671fc1','Chrome/77','Windows NT 10.0','Browser','2019-10-31 23:01:26','0000-00-00 00:00:00');
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `history_login_apps`;
- ;
- ;
- CREATE TABLE `history_login_apps` (
- `ID` varchar(45) NOT NULL COMMENT '主é®',
- `SESSIONID` varchar(45) DEFAULT NULL COMMENT 'ä¼è¯',
- `LOGINTIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'åç¹ç»å½æ¶é´',
- `APPID` varchar(45) NOT NULL COMMENT 'åºç¨ID',
- `APPNAME` varchar(45) DEFAULT NULL,
- `UID` varchar(45) DEFAULT NULL,
- `USERNAME` varchar(45) DEFAULT NULL,
- `DISPLAYNAME` varchar(45) DEFAULT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='åç¹ç»å½æ¥å¿è¡¨';
- ;
- LOCK TABLES `history_login_apps` WRITE;
- ;
- INSERT INTO `history_login_apps` VALUES ('097f9281-0511-4cf4-b484-0ca38db03088','b64311b4-c64a-4a74-88af-890e87af4a41','2019-11-08 15:13:07','850379a1-7923-4f6b-90be-d363b2dfd2ca','网易163邮箱','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('1','1','2019-10-30 15:04:37','1','1','1','1','1'),('1d397fc8-23dc-4c86-9458-00b0165e46ae','eda90658-e76d-4ba7-b2b7-28729f9b1c6d','2019-11-08 14:34:08','850379a1-7923-4f6b-90be-d363b2dfd2ca','网易163邮箱','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('1da9367a-2dd9-4b84-bb05-5c7b382bb2a5','0fc5e1e5-4bf3-4a4e-9d52-77e2a84bfb71','2019-11-09 01:21:08','41065fe3-ae67-4172-a460-fd0079e88294','CAS Demo','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('27900d59-9b97-4022-8ab1-e7a8842264a5','dfc2eb06-bbbc-4959-a8b1-aedb35686fdc','2019-11-09 10:45:07','c1cabfaeb9a448028ffab2148da9f65c','QQ Login','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('2e498dde-f525-4123-aee0-bf7df0e3e8c9','b64311b4-c64a-4a74-88af-890e87af4a41','2019-11-08 15:17:47','850379a1-7923-4f6b-90be-d363b2dfd2ca','网易163邮箱','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('2fef5656-54bc-44c1-9611-d522ac50a7a9','55f71822-0331-4022-8a15-6cbe4aa2704d','2020-02-17 14:53:37','38c8a544eaa04aaeaa49d9c77ace40cd','Token_Based_Json','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('31d2838d-ffbd-45d1-bfcb-f93cc8b98497','45697390-b922-4cca-9725-4d836cef164e','2019-12-26 14:21:06','78917a82-1c86-4020-b86a-3b1b350357e3','JWT Demo','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('41333481-0ae4-4073-a929-5fda244627f3','55f71822-0331-4022-8a15-6cbe4aa2704d','2020-02-17 14:52:48','f1e33b71-f553-42ab-ae91-2fd913854cda','Token_Based_Simple','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('430ba289-01c0-4a75-b0ea-7ec49c507ac9','fcedbcc7-3426-400e-bcf0-def47a14833d','2019-11-09 10:43:28','525d261fa3b04d19af0debabbd5a1e2d','SalesForce ','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('433c3bd8-5a8f-4f02-b330-b23b329d52de','b6857a5e-c5eb-4a29-9db4-c8c74ab27113','2020-02-17 15:15:47','1327c121-cfad-49ba-bf61-afd3a1e09d5c','LTPA-Cookie','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('438fcf0c-cc6f-4349-be81-13e3ca211664','b64311b4-c64a-4a74-88af-890e87af4a41','2019-11-08 15:10:40','850379a1-7923-4f6b-90be-d363b2dfd2ca','网易163邮箱','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('52a6c789-c93a-4666-98a4-014b38a145ee','55f71822-0331-4022-8a15-6cbe4aa2704d','2020-02-17 14:52:51','38c8a544eaa04aaeaa49d9c77ace40cd','Token_Based_Json','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('58ddf266-8665-43ba-96aa-0ffba47913ab','07e875c1-be6d-4f1e-bafa-4a6bf5977a14','2019-12-16 13:37:34','maxkey_mgt','MaxKey管理系统','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('647e277d-433f-463c-a0a6-98930d0becd1','eda90658-e76d-4ba7-b2b7-28729f9b1c6d','2019-11-08 14:29:37','850379a1-7923-4f6b-90be-d363b2dfd2ca','网易163邮箱','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('6a8e9e75-76df-4b58-9135-0a5c6b197e2d','2d32a090-495e-4308-a40c-8a4eacd176cf','2019-12-02 04:10:15','maxkey_mgt','MaxKey管理系统','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('6d697814-f33d-4e52-819b-df230e9e795b','8854f632-873d-4108-935e-2006cc23f7f0','2019-11-08 14:50:12','850379a1-7923-4f6b-90be-d363b2dfd2ca','网易163邮箱','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('75230872-b6e3-4334-9998-8efdf845d219','0fc5e1e5-4bf3-4a4e-9d52-77e2a84bfb71','2019-11-09 01:06:09','41065fe3-ae67-4172-a460-fd0079e88294','CAS Demo','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('76028fc0-65db-4f14-83b7-e13497b8d48d','0fc5e1e5-4bf3-4a4e-9d52-77e2a84bfb71','2019-11-09 01:25:20','41065fe3-ae67-4172-a460-fd0079e88294','CAS Demo','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('797b9202-1ddc-44eb-b84b-4df41ef98f63','b64311b4-c64a-4a74-88af-890e87af4a41','2019-11-08 15:48:31','41065fe3-ae67-4172-a460-fd0079e88294','CAS Demo','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('7a329e91-bf7c-47b4-ac3a-ad428f37a4bd','3fc6ee3b-5910-4e87-b504-5b5621fa48d4','2019-11-09 01:02:52','41065fe3-ae67-4172-a460-fd0079e88294','CAS Demo','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('7b2356f4-197c-4afc-a6f2-9f02a1082817','b64311b4-c64a-4a74-88af-890e87af4a41','2019-11-08 15:18:19','c8038bd4-12a4-4b45-9d43-61b3ecdc2eb4','有道云笔记','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('86834e68-10c1-472f-9f83-0f6bbe54d126','55f71822-0331-4022-8a15-6cbe4aa2704d','2020-02-17 14:52:43','78917a82-1c86-4020-b86a-3b1b350357e3','JWT Demo','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('8754b8d4-33c4-418b-9440-ec2a68a1487b','fcedbcc7-3426-400e-bcf0-def47a14833d','2019-11-09 10:44:01','41065fe3-ae67-4172-a460-fd0079e88294','CAS Demo','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('8b340426-2cb6-4219-a530-70181777ed30','b64311b4-c64a-4a74-88af-890e87af4a41','2019-11-08 15:44:57','41065fe3-ae67-4172-a460-fd0079e88294','CAS Demo','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('9367e336-9c88-48a6-a514-5346e137c1e7','55f71822-0331-4022-8a15-6cbe4aa2704d','2020-02-17 14:52:55','1327c121-cfad-49ba-bf61-afd3a1e09d5c','LTPA-Cookie','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('93e012fa-0c33-4b00-ac85-7cf0ef2d1468','b64311b4-c64a-4a74-88af-890e87af4a41','2019-11-08 15:46:16','41065fe3-ae67-4172-a460-fd0079e88294','CAS Demo','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('94aeb5db-ccad-42e2-a51c-b916b59b02ec','dfc2eb06-bbbc-4959-a8b1-aedb35686fdc','2019-11-09 10:45:11','c1cabfaeb9a448028ffab2148da9f65c','QQ Login','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('a848cfc9-7004-4edd-b32f-ce34710f0c67','80a2710c-91ae-416e-be6f-bc19f6e74166','2019-12-06 13:42:32','maxkey_mgt','MaxKey管理系统','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('aab7c33d-3ea9-4398-97ee-7e0b63e01739','8854f632-873d-4108-935e-2006cc23f7f0','2019-11-08 14:46:37','850379a1-7923-4f6b-90be-d363b2dfd2ca','网易163邮箱','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('b1cde167-30b5-4bb2-951c-2e9a19db4ab7','4cda3927-420e-480f-a6c5-e8039531c664','2020-02-17 14:50:29','78917a82-1c86-4020-b86a-3b1b350357e3','JWT Demo','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('b4312fc6-811d-41d5-ae3a-268e3a4c9829','b64311b4-c64a-4a74-88af-890e87af4a41','2019-11-08 15:18:10','850379a1-7923-4f6b-90be-d363b2dfd2ca','网易163邮箱','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('b6f70f47-528d-4a73-bbb5-de0b76db4b65','0fc5e1e5-4bf3-4a4e-9d52-77e2a84bfb71','2019-11-09 01:26:26','41065fe3-ae67-4172-a460-fd0079e88294','CAS Demo','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('c64f34ba-7d6e-45e2-b946-369ec361b0bc','c3d47b1c-f961-45b2-a909-c2a63ebfa28a','2019-11-09 03:25:58','41065fe3-ae67-4172-a460-fd0079e88294','CAS Demo','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('d110f88a-efa1-4bfa-acfb-8a197821a546','f5ca7d37-7491-4e18-b0c7-5307bd2686aa','2020-02-17 14:55:41','1327c121-cfad-49ba-bf61-afd3a1e09d5c','LTPA-Cookie','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('db74b89c-7c10-405c-983d-baa838cae8d5','e7554c39-0aa5-4cb3-be64-71117017e555','2019-12-08 11:42:50','maxkey_mgt','MaxKey管理系统','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('dfc32176-616c-481a-98bf-1651a9286ec2','0fc5e1e5-4bf3-4a4e-9d52-77e2a84bfb71','2019-11-09 01:23:55','41065fe3-ae67-4172-a460-fd0079e88294','CAS Demo','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('e0c776ad-a1cb-45f3-a3ea-e083218a023f','d2b5bf64-3cd7-4606-86bb-e02b7f11558e','2020-02-17 15:04:54','1327c121-cfad-49ba-bf61-afd3a1e09d5c','LTPA-Cookie','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('e62dc743-cf40-4492-bbd0-0f4775a47479','55f71822-0331-4022-8a15-6cbe4aa2704d','2020-02-17 14:53:34','1327c121-cfad-49ba-bf61-afd3a1e09d5c','LTPA-Cookie','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('eaa39588-78a8-477a-a2ae-bcbd40152624','0fc5e1e5-4bf3-4a4e-9d52-77e2a84bfb71','2019-11-09 01:08:27','41065fe3-ae67-4172-a460-fd0079e88294','CAS Demo','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('f332a0fd-bc87-4639-ae1d-f4894cd95c8c','b64311b4-c64a-4a74-88af-890e87af4a41','2019-11-08 15:45:17','41065fe3-ae67-4172-a460-fd0079e88294','CAS Demo','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('f336631d-2d4b-4d1c-8708-6bfc5de5a439','8854f632-873d-4108-935e-2006cc23f7f0','2019-11-08 14:49:53','850379a1-7923-4f6b-90be-d363b2dfd2ca','网易163邮箱','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('f3d9ba18-370e-48e5-9723-092cbf613413','b64311b4-c64a-4a74-88af-890e87af4a41','2019-11-08 15:43:41','41065fe3-ae67-4172-a460-fd0079e88294','CAS Demo','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('fb524193-0a09-4007-bea8-42b7a94a9d12','f5ca7d37-7491-4e18-b0c7-5307bd2686aa','2020-02-17 14:55:26','41065fe3-ae67-4172-a460-fd0079e88294','CAS Demo','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员'),('fee87158-83e9-4e7a-bcba-476d4f32b7fb','0fc5e1e5-4bf3-4a4e-9d52-77e2a84bfb71','2019-11-09 01:28:48','41065fe3-ae67-4172-a460-fd0079e88294','CAS Demo','7BF5315CA1004CDB8E614B0361C4D46B','admin','系统管理员');
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `history_logs`;
- ;
- ;
- CREATE TABLE `history_logs` (
- `ID` varchar(45) NOT NULL COMMENT '主é®',
- `SERVICENAME` varchar(100) DEFAULT NULL COMMENT 'ä¸å¡åç§°',
- `MESSAGE` varchar(200) DEFAULT NULL COMMENT 'æ¶æ¯',
- `OPERATETYPE` varchar(45) DEFAULT NULL COMMENT 'æä½ç±»å',
- `CONTENT` text COMMENT 'æä½å
容ï¼JSONï¼',
- `CREATEDDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'æä½æ¶é´',
- `CREATEDBY` varchar(45) DEFAULT NULL COMMENT 'æä½äºº',
- `MESSAGETYPE` varchar(45) DEFAULT NULL COMMENT 'æ¶æ¯ç±»å',
- `TNAME` varchar(45) DEFAULT NULL COMMENT 'ä¼ä¸ç®ç§°',
- `USERNAME` varchar(45) DEFAULT NULL COMMENT 'ç»å½å',
- `CODE` varchar(45) DEFAULT NULL COMMENT 'æ¥å¿ç¼ç ',
- `TID` varchar(45) DEFAULT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='æä½æ¥å¿è¡¨';
- ;
- LOCK TABLES `history_logs` WRITE;
- ;
- INSERT INTO `history_logs` VALUES ('1','1',NULL,NULL,NULL,'2019-10-30 15:04:49',NULL,NULL,NULL,NULL,NULL,NULL);
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `ipaddrfilter`;
- ;
- ;
- CREATE TABLE `ipaddrfilter` (
- `ID` varchar(45) NOT NULL,
- `IPADDR` varchar(45) DEFAULT NULL,
- `FILTER` varchar(45) DEFAULT NULL,
- `DESCRIPTION` varchar(45) DEFAULT NULL,
- `STATUS` varchar(45) DEFAULT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- ;
- LOCK TABLES `ipaddrfilter` WRITE;
- ;
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `one_time_password`;
- ;
- ;
- CREATE TABLE `one_time_password` (
- `ID` varchar(45) NOT NULL,
- `OPTTYPE` tinyint(3) unsigned DEFAULT '1',
- `USERNAME` varchar(45) NOT NULL,
- `TOKEN` varchar(45) NOT NULL,
- `RECEIVER` varchar(45) DEFAULT NULL,
- `CREATETIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `STATUS` tinyint(3) unsigned DEFAULT '1',
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- ;
- LOCK TABLES `one_time_password` WRITE;
- ;
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `organizations`;
- ;
- ;
- CREATE TABLE `organizations` (
- `ID` varchar(45) NOT NULL,
- `NAME` varchar(200) NOT NULL,
- `PID` varchar(45) DEFAULT NULL,
- `DESCRIPTION` varchar(200) DEFAULT NULL,
- `STATUS` tinyint(3) unsigned DEFAULT NULL,
- `CREATEDBY` varchar(45) DEFAULT NULL,
- `CREATEDDATE` datetime DEFAULT NULL,
- `MODIFIEDBY` varchar(45) DEFAULT NULL,
- `MODIFIEDDATE` datetime DEFAULT NULL,
- `ADDRESS` varchar(200) DEFAULT NULL,
- `POSTALCODE` varchar(45) DEFAULT NULL,
- `PHONE` varchar(200) DEFAULT NULL,
- `FAX` varchar(200) DEFAULT NULL,
- `SORTORDER` int(10) unsigned DEFAULT '0',
- `FULLNAME` varchar(100) DEFAULT NULL,
- `TYPE` varchar(45) DEFAULT NULL,
- `XPATH` varchar(500) DEFAULT NULL,
- `LEVEL` int(10) unsigned DEFAULT NULL,
- `PNAME` varchar(45) DEFAULT NULL,
- `DIVISION` varchar(45) DEFAULT NULL,
- `COUNTRY` varchar(45) DEFAULT NULL,
- `REGION` varchar(45) DEFAULT NULL,
- `LOCALITY` varchar(45) DEFAULT NULL,
- `STREET` varchar(45) DEFAULT NULL,
- `HASCHILD` varchar(45) DEFAULT NULL,
- `CONTACT` varchar(45) DEFAULT NULL,
- `CODE` varchar(45) DEFAULT NULL,
- `EMAIL` varchar(45) DEFAULT NULL,
- `XNAMEPATH` varchar(400) DEFAULT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- ;
- LOCK TABLES `organizations` WRITE;
- ;
- INSERT INTO `organizations` VALUES ('101','产品部','1','',1,'admin','2014-12-28 16:41:30',NULL,NULL,'','','','',1,'','','/101',NULL,'海连软件','','','','','',NULL,'',NULL,'',NULL),('10101','云身份安全部','101','',1,'admin','2014-12-28 16:50:10',NULL,NULL,'','','','',1,'','','/101/10101',NULL,'产品部','','','','','',NULL,'',NULL,'',NULL),('10102','IAM产品部','101','',1,'admin','2014-12-28 16:50:30',NULL,NULL,'','','','',1,'','','/101/10102',NULL,'产品部','','','','','',NULL,'',NULL,'',NULL),('10103','动态令牌产品部','101','',1,'admin','2014-12-28 16:51:02',NULL,NULL,'','','','',1,'','','/101/10103',NULL,'产品部','','','','','',NULL,'',NULL,'',NULL),('102','项目部','1','',1,'admin','2014-12-28 16:41:46',NULL,NULL,'','','','',1,'','','/102',NULL,'海连软件','','','','','',NULL,'',NULL,'',NULL),('10201','IAM项目部','102','',1,'admin','2014-12-28 16:49:18',NULL,NULL,'','','','',1,'','','/102/10201',NULL,'项目部','','','','','',NULL,'',NULL,'',NULL),('10202','Portal项目部','102','',1,'admin','2014-12-28 16:49:35',NULL,NULL,'','','','',1,'','','/102/10202',NULL,'项目部','','','','','',NULL,'',NULL,'',NULL),('10203','技术支持部','102','',1,'admin','2014-12-28 16:52:45',NULL,NULL,'','','','',1,'','','/102/10203',NULL,'项目部','','','','','',NULL,'',NULL,'',NULL),('103','销售部','1','',1,'admin','2014-12-28 16:42:41','admin','2015-06-11 14:07:10','','','','',1,'销售部','','/103',NULL,'海连软件','','','','','',NULL,'',NULL,'',''),('104','财务部','1','',1,'admin','2014-12-28 16:42:56',NULL,NULL,'','','','',1,'','','/104',NULL,'海连软件','','','','','',NULL,'',NULL,'',NULL),('105','行政部','1','',1,'admin','2014-12-28 16:43:08','admin','2015-05-06 12:46:54','','','','',1,'','','/1/105',NULL,'海连软件','','','','','',NULL,'',NULL,'',NULL),('10601','北京分公司','1','',1,'admin','2014-12-28 16:53:30',NULL,NULL,'','','','',1,'','','/10601',NULL,'海连软件','','','','','',NULL,'',NULL,'',NULL),('1060101','产品支持部','10601','',1,'admin','2014-12-28 16:53:53',NULL,NULL,'','','','',1,'','','/10601/1060101',NULL,'北京分公司','','','','','',NULL,'',NULL,'',NULL),('1060102','项目服务部','10601','',1,'admin','2014-12-28 16:54:10',NULL,NULL,'','','','',1,'','','/10601/1060102',NULL,'北京分公司','','','','','',NULL,'',NULL,'',NULL),('107','商务部','1','',1,'admin','2015-06-11 14:08:04',NULL,NULL,'','','','',1,'商务部','','/1/107',NULL,'技安信息','','','','','',NULL,'',NULL,'','/技安信息/商务部');
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `password_policy`;
- ;
- ;
- CREATE TABLE `password_policy` (
- `ID` varchar(45) NOT NULL,
- `MINLENGTH` tinyint(3) unsigned DEFAULT '0' COMMENT 'æå°é¿åº¦',
- `MAXLENGTH` tinyint(3) unsigned DEFAULT '0' COMMENT 'æå¤§é¿åº¦',
- `LOWERCASE` tinyint(3) unsigned DEFAULT '0' COMMENT 'æå¤§æææ',
- `UPPERCASE` tinyint(3) unsigned DEFAULT '0' COMMENT 'æå°æææ',
- `DIGITS` tinyint(3) unsigned DEFAULT '0' COMMENT 'å
嫿°å个æ°',
- `SPECIALCHAR` tinyint(3) unsigned DEFAULT '0' COMMENT 'å
å«å°ååæ¯ä¸ªæ°',
- `ATTEMPTS` tinyint(3) unsigned DEFAULT '0' COMMENT 'å
å«å¤§ååæ¯ä¸ªæ°',
- `DURATION` tinyint(3) unsigned DEFAULT '0' COMMENT 'è´¦å·éå®éå¼',
- `EXPIRATION` tinyint(3) unsigned DEFAULT '0' COMMENT 'è§£éæ¶é´',
- `USERNAME` tinyint(3) unsigned DEFAULT '0' COMMENT 'ç¹æ®å符个æ°',
- `SIMPLEPASSWORDS` varchar(600) DEFAULT '0' COMMENT '约æå
å«ç»å½å',
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='å¯ç çç¥';
- ;
- LOCK TABLES `password_policy` WRITE;
- ;
- INSERT INTO `password_policy` VALUES ('1',6,15,1,1,2,2,6,3,10,1,'password,password1,admin,123456,666666,888888,999999,12345678,abc123,123456789,111111,1234567,123123,1234567890,1234,12345,000000');
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `remember_me`;
- ;
- ;
- CREATE TABLE `remember_me` (
- `ID` varchar(40) NOT NULL,
- `USERNAME` varchar(50) NOT NULL,
- `AUTHKEY` varchar(200) NOT NULL,
- `LASTLOGIN` datetime NOT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- ;
- LOCK TABLES `remember_me` WRITE;
- ;
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `saml_v20_metadata`;
- ;
- ;
- CREATE TABLE `saml_v20_metadata` (
- `ID` varchar(45) NOT NULL,
- `ORGNAME` varchar(100) NOT NULL,
- `ORGDISPLAYNAME` varchar(200) NOT NULL,
- `ORGURL` varchar(200) NOT NULL,
- `COMPANY` varchar(200) NOT NULL,
- `GIVENNAME` varchar(45) NOT NULL,
- `SURNAME` varchar(45) NOT NULL,
- `EMAILADDRESS` varchar(45) NOT NULL,
- `TELEPHONENUMBER` varchar(45) NOT NULL,
- `CONTACTTYPE` varchar(45) NOT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- ;
- LOCK TABLES `saml_v20_metadata` WRITE;
- ;
- INSERT INTO `saml_v20_metadata` VALUES ('0f6635fc1008b6c000080140977f33ef','connSec','connSec','http://www.connsec.com','connSec','connSec','connSec','admin@connSec.com','4008981111','technical');
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `socialsignon_users_token`;
- ;
- ;
- CREATE TABLE `socialsignon_users_token` (
- `ID` varchar(45) NOT NULL,
- `UID` varchar(45) NOT NULL COMMENT 'ç¨æ·id',
- `PROVIDER` varchar(45) NOT NULL COMMENT 'ç¬¬ä¸æ¹æä¾å',
- `SOCIALUSERINFO` text COMMENT '''ç¬¬ä¸æ¹åºç¨çç¨æ·ä¿¡æ¯''',
- `SOCIALUID` varchar(100) NOT NULL COMMENT '''ç¬¬ä¸æ¹åºç¨çç¨æ·id''',
- `EXATTRIBUTE` text,
- `ACCESSTOKEN` text,
- `CREATEDDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `UPDATEDDATE` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- `USERNAME` varchar(45) NOT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ç¨æ·åç¬¬ä¸æ¹è®¤è¯æä¾åçç»å®å
³ç³»';
- ;
- LOCK TABLES `socialsignon_users_token` WRITE;
- ;
- INSERT INTO `socialsignon_users_token` VALUES ('af8a6c51-f4cb-4f86-8e39-436038e82949','7BF5315CA1004CDB8E614B0361C4D46B','sinaweibo',NULL,'2490166710',NULL,NULL,'2020-02-05 11:38:40','2020-02-05 11:38:40','admin'),('c9bda0cf-fc15-4363-a73f-b600342b6653','7BF5315CA1004CDB8E614B0361C4D46B','dingtalk',NULL,'fYytDzVMiPHfccTsOjH52zQiEiE',NULL,NULL,'2020-02-05 10:16:50','2020-02-05 10:16:50','admin');
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `sso_saml_v20_config`;
- ;
- ;
- CREATE TABLE `sso_saml_v20_config` (
- `ID` varchar(45) NOT NULL,
- `ISSUER` varchar(200) NOT NULL,
- `CERTIFICATE` blob NOT NULL,
- `KEYSTORE` blob NOT NULL,
- `CERTISSUER` varchar(200) NOT NULL,
- `CERTSUBJECT` varchar(200) NOT NULL,
- `CERTEXPIRATION` varchar(45) NOT NULL,
- `ENTITYID` varchar(200) NOT NULL,
- `NAMEIDFORMAT` varchar(45) NOT NULL,
- `CREATEDBY` varchar(45) DEFAULT NULL,
- `CREATEDDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `MODIFIEDBY` varchar(45) DEFAULT NULL,
- `MODIFIEDDATE` datetime DEFAULT NULL,
- `STATUS` tinyint(3) unsigned NOT NULL,
- `VALIDITY_INTERVAL` tinyint(3) unsigned DEFAULT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- ;
- LOCK TABLES `sso_saml_v20_config` WRITE;
- ;
- INSERT INTO `sso_saml_v20_config` VALUES ('sdaf','sdaf','0r0Z >ºVc0\r *H÷\r\00O10 UCN10 USH10 USH10U\nconnsec10Uconnsec.com0\r130509143800Z\r130522063135Z0O10 UCN10 USH10 USH10U\nconnsec10Uconnsec.com0\"0\r *H÷\r\0\00\n\0[0u`35ÔKJéêü§%×¾ØO6zç½ù
öúßÓJ»0£îñ\0>1Z\"£ÊäÂåUûö pVïvø ù%e\n23 êl¹\rG6ù´Þ*£±ñMÔ<ÿ@<è\0Xä[Ñ.Îôh5é·¥¡W±¦íN-A9S½Ð³(,¦b#;Ä\0¸æ)SMañC78¿7ûJí¤uØ\"` 0Ü÷ûç~ß#Ûý7ÍÛ7XààéÏa¨p d¸å5éÊY`Ó,Ohä<\nD>\\#°1®Þj¹t{Nuÿ
\'=|8\\úÜ\0£T0R0Uÿ0\00Uÿ 0U%ÿ0\n+0\ZU0connsec@163.com0\r *H÷\r\0\06)3¸à7£»Ó m¨g²0à±HÛeìË~ÚBäûYSö£¼æ3:[ôúø\'ÎíóÐÂ/ª{ æ5.ü¼ËÑf»Î˵,÷H_çzÇÐ0é§?è¹CVf:ú]|pØSFþâ¿üÆvýMý\0¡fÜTÊRáû%2cê?R°çqÒßL¹èBøË§¦ôÀ¨·¶9ËtQ&|µ&ë`©o·´õx)Þ&¬æb73¥|5üúËi`ïHOÕ¤0»v\0ȨªH)&~Y?;F)âîiðCx¥z$/;','þíþí\0\0\0\0\0\0\0\0\0\0sdf\0\0>@ð\0X.509\0\0v0r0Z >ºVc0\r *H÷\r\00O10 UCN10 USH10 USH10U\nconnsec10Uconnsec.com0\r130509143800Z\r130522063135Z0O10 UCN10 USH10 USH10U\nconnsec10Uconnsec.com0\"0\r *H÷\r\0\00\n\0[0u`35ÔKJéêü§%×¾ØO6zç½ù
öúßÓJ»0£îñ\0>1Z\"£ÊäÂåUûö pVïvø ù%e\n23 êl¹\rG6ù´Þ*£±ñMÔ<ÿ@<è\0Xä[Ñ.Îôh5é·¥¡W±¦íN-A9S½Ð³(,¦b#;Ä\0¸æ)SMañC78¿7ûJí¤uØ\"` 0Ü÷ûç~ß#Ûý7ÍÛ7XààéÏa¨p d¸å5éÊY`Ó,Ohä<\nD>\\#°1®Þj¹t{Nuÿ
\'=|8\\úÜ\0£T0R0Uÿ0\00Uÿ 0U%ÿ0\n+0\ZU0connsec@163.com0\r *H÷\r\0\06)3¸à7£»Ó m¨g²0à±HÛeìË~ÚBäûYSö£¼æ3:[ôúø\'ÎíóÐÂ/ª{ æ5.ü¼ËÑf»Î˵,÷H_çzÇÐ0é§?è¹CVf:ú]|pØSFþâ¿üÆvýMý\0¡fÜTÊRáû%2cê?R°çqÒßL¹èBøË§¦ôÀ¨·¶9ËtQ&|µ&ë`©o·´õx)Þ&¬æb73¥|5üúËi`ïHOÕ¤0»v\0ȨªH)&~Y?;F)âîiðCx¥z$/;\0\0\0\0connsec.com\0\0>Ô\r\0\0\00ü0\n+*\0è˯aM麡-ÿ5³·¿Hfk<ënH Í%Ð{4º#bº¨ùzõÄ;W¿Â\rË£2?0ìQC#6¢wP@\\ª09CJ.õ*pAÊa§ûáÄH/íùCdB\\úO @E¹zî=ó\0h%ìb:}ÈÅÃËN©àí«¼R\'CÁ+Æ*ks«éw¿xë .îGÕ ±k[¡w³n_+
Ù\0sÂ=©`wd¶@ÑñÚHüte·``ý`â±(5\'1Z½Ù4LRhy_ú23y°Ñ¿!¬ËMä,é&ýCÚzÒb_£P¡û±B5Ï´Í%¤ö ý¹ÐP}³Åc×qHb~Ä¿7M÷êy¥Ð`O=Y»`/«rïÑë¼:P~Ë4Voü£·´´A7^»ú/ÏKþlbûrÀaS)$¯TC?\'¤V
- ;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `userinfo`;
- ;
- ;
- CREATE TABLE `userinfo` (
- `ID` varchar(45) NOT NULL,
- `USERNAME` varchar(100) NOT NULL,
- `PASSWORD` varchar(200) NOT NULL,
- `DECIPHERABLE` varchar(200) NOT NULL,
- `USERTYPE` varchar(45) DEFAULT NULL,
- `WINDOWSACCOUNT` varchar(45) DEFAULT NULL,
- `DISPLAYNAME` varchar(45) DEFAULT NULL,
- `NICKNAME` varchar(45) DEFAULT NULL,
- `GENDER` tinyint(3) unsigned DEFAULT NULL,
- `BIRTHDATE` varchar(45) DEFAULT NULL,
- `PICTURE` blob,
- `IDCARDNO` varchar(45) DEFAULT NULL,
- `MOBILE` varchar(45) DEFAULT NULL,
- `MOBILEVERIFIED` varchar(45) DEFAULT NULL,
- `EMAIL` varchar(45) DEFAULT NULL COMMENT 'ʼ',
- `EMAILVERIFIED` smallint(5) unsigned DEFAULT NULL,
- `WEBSITE` varchar(50) DEFAULT NULL COMMENT 'ʼ',
- `TIMEZONE` varchar(45) DEFAULT NULL,
- `LOCALE` varchar(45) DEFAULT NULL,
- `PREFERREDLANGUAGE` varchar(45) DEFAULT NULL,
- `PASSWORDQUESTION` varchar(45) DEFAULT NULL,
- `PASSWORDANSWER` varchar(45) DEFAULT NULL,
- `APPLOGINPASSWORD` varchar(45) DEFAULT NULL,
- `PROTECTEDAPPS` varchar(450) DEFAULT NULL COMMENT 'jsondata',
- `PASSWORDLASTSETTIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '޸ʱ',
- `BADPASSWORDCOUNT` smallint(5) unsigned DEFAULT NULL,
- `UNLOCKTIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- `ISLOCKED` tinyint(3) unsigned DEFAULT NULL,
- `LASTLOGINTIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '޸ʱ',
- `LASTLOGOFFTIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '޸ʱ',
- `EXTRAATTRIBUTE` varchar(4000) DEFAULT NULL COMMENT 'jsondata',
- `GIVENNAME` varchar(45) DEFAULT NULL,
- `MIDDLENAME` varchar(45) DEFAULT NULL,
- `FAMILYNAME` varchar(45) DEFAULT NULL,
- `HONORIFICPREFIX` varchar(45) DEFAULT NULL,
- `HONORIFICSUFFIX` varchar(45) DEFAULT NULL,
- `FORMATTEDNAME` varchar(400) DEFAULT NULL,
- `WORKEMAIL` varchar(45) DEFAULT NULL,
- `WORKPHONENUMBER` varchar(45) DEFAULT NULL,
- `WORKCOUNTRY` varchar(45) DEFAULT NULL,
- `WORKREGION` varchar(45) DEFAULT NULL,
- `WORKLOCALITY` varchar(45) DEFAULT NULL,
- `WORKSTREETADDRESS` varchar(45) DEFAULT NULL,
- `WORKADDRESSFORMATTED` varchar(45) DEFAULT NULL,
- `WORKPOSTALCODE` varchar(45) DEFAULT NULL,
- `WORKFAX` varchar(45) DEFAULT NULL,
- `HOMEEMAIL` varchar(45) DEFAULT NULL,
- `HOMEPHONENUMBER` varchar(45) DEFAULT NULL,
- `HOMECOUNTRY` varchar(45) DEFAULT NULL,
- `HOMEREGION` varchar(45) DEFAULT NULL,
- `HOMELOCALITY` varchar(45) DEFAULT NULL,
- `HOMESTREETADDRESS` varchar(45) DEFAULT NULL,
- `HOMEADDRESSFORMATTED` varchar(45) DEFAULT NULL,
- `HOMEPOSTALCODE` varchar(45) DEFAULT NULL,
- `HOMEFAX` varchar(45) DEFAULT NULL,
- `EMPLOYEENUMBER` varchar(45) DEFAULT NULL,
- `DIVISION` varchar(45) DEFAULT NULL,
- `COSTCENTER` varchar(45) DEFAULT NULL,
- `ORGANIZATION` varchar(45) DEFAULT NULL,
- `DEPARTMENTID` varchar(45) DEFAULT NULL,
- `DEPARTMENT` varchar(45) DEFAULT NULL,
- `JOBTITLE` varchar(45) DEFAULT NULL,
- `MANAGERID` varchar(45) DEFAULT NULL,
- `MANAGER` varchar(45) DEFAULT NULL,
- `ASSISTANTID` varchar(45) DEFAULT NULL,
- `ASSISTANT` varchar(45) DEFAULT NULL,
- `CREATEDBY` varchar(45) DEFAULT NULL,
- `CREATEDDATE` date DEFAULT NULL COMMENT 'ʱ',
- `MODIFIEDBY` varchar(45) DEFAULT NULL COMMENT 'Þ¸',
- `MODIFIEDDATE` date DEFAULT NULL COMMENT '޸ʱ',
- `STATUS` tinyint(3) unsigned DEFAULT NULL,
- `DESCRIPTION` varchar(400) DEFAULT NULL COMMENT 'Þ¸',
- `MARRIED` tinyint(3) unsigned DEFAULT '0',
- `IDTYPE` tinyint(3) unsigned DEFAULT '0',
- `ENTRYDATE` varchar(45) DEFAULT NULL,
- `STARTWORKDATE` varchar(45) DEFAULT NULL,
- `AUTHNTYPE` tinyint(3) unsigned DEFAULT NULL,
- `NAMEZHSPELL` varchar(100) DEFAULT NULL,
- `NAMEZHSHORTSPELL` varchar(45) DEFAULT NULL,
- `ONLINE` tinyint(3) unsigned DEFAULT NULL,
- `BADPASSWORDTIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- `SHAREDSECRET` varchar(500) DEFAULT NULL,
- `SHAREDCOUNTER` varchar(45) DEFAULT '0',
- `APPLOGINAUTHNTYPE` tinyint(3) unsigned DEFAULT '0',
- `JOBLEVEL` varchar(45) DEFAULT NULL,
- `QUITDATE` varchar(45) DEFAULT NULL,
- `PASSWORDSETTYPE` tinyint(3) unsigned DEFAULT '0',
- `LOGINCOUNT` int(10) unsigned DEFAULT '0',
- `LASTLOGINIP` varchar(45) DEFAULT NULL,
- `GRIDLIST` tinyint(3) unsigned DEFAULT '0',
- `QQ` varchar(45) DEFAULT NULL,
- `WEIXIN` varchar(45) DEFAULT NULL,
- `SINAWEIBO` varchar(45) DEFAULT NULL,
- `YIXIN` varchar(45) DEFAULT NULL,
- `FACEBOOK` varchar(45) DEFAULT NULL,
- `SKYPE` varchar(45) DEFAULT NULL,
- `MSN` varchar(45) DEFAULT NULL,
- `GTALK` varchar(45) DEFAULT NULL,
- `YAHOO` varchar(45) DEFAULT NULL,
- `LINE` varchar(45) DEFAULT NULL,
- `AIM` varchar(45) DEFAULT NULL,
- `DEFINEIM` varchar(45) DEFAULT NULL,
- `WEIXINFOLLOW` tinyint(3) unsigned DEFAULT NULL,
- `SORTORDER` tinyint(3) unsigned DEFAULT '0',
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='û';
- ;
- LOCK TABLES `userinfo` WRITE;
- ;
- INSERT INTO `userinfo` VALUES ('44D64694BADD4423A336C05D49469B60','superadmin','dJbALpTupUiaiWsbgp/TVT/3mXQK5Q2RwyEOa7Vc3j0=','c0aca9ea77b47ef681862d5a328b2366','TEMP',NULL,'超级管理员','SuperAdmin',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Asia/Shanghai','fr','zh_CN',NULL,NULL,NULL,NULL,'2015-04-30 02:07:25',NULL,'2014-01-20 08:00:00',NULL,'2015-04-30 02:08:09','2014-01-20 08:00:00','{\"age\":\"0\",\"cardno\":\"0\",\"oldname\":\"null\"}','超级管理员','超级管理员','超级管理员',NULL,NULL,NULL,NULL,NULL,'AFG',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'AFG',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'101','科技部',NULL,NULL,NULL,NULL,NULL,NULL,'2014-01-21','admin','2015-04-30',0,NULL,0,0,NULL,NULL,0,'chaojiguanliyuan','cjgly',1,'0000-00-00 00:00:00',NULL,'0',0,NULL,NULL,0,1,'127.0.0.1',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),('7BF5315CA1004CDB8E614B0361C4D46B','admin','$2a$10$xgeYHPy8HUo0/T2bmjTEHudD5NZR47.gBarWSvbSlNztbUq3cdTsi','1d7000f333781a3ab334a683f684306d','TEMP','adsystemadmin','系统管理员','系统管理员',1,NULL,NULL,'2342342343242344234','13705130848','0','admin@connsec.com',0,'http://login.maxkey.org/','Asia/Shanghai','de','zh_CN','5','wusdfdsf','96ba45115416faf22791c13ade20f437',',41065fe3-ae67-4172-a460-fd0079e88294,52f0002d-4ef7-4b27-8c5b-41b9ee80835d,3f57d0b2-99ab-4e66-a938-718befb55369','2020-02-17 14:50:14',2,'2015-04-29 02:10:51',0,'2020-02-17 15:15:27','2020-02-17 14:59:27','{\"age\":\"12\",\"cardno\":\"11111111111111111111111111111111\",\"oldname\":\"ç³é¸£1d\"}','admin','admin','admin',NULL,NULL,NULL,'shimin@qq.com','123123','CN','北京','北京','北京',NULL,'123123','123123','admin@qq.com','123123','中国','北京','北京','北京',NULL,'123123','sdf',NULL,NULL,NULL,'总部','105','科技部','系统管理员',NULL,'科技部经理',NULL,NULL,NULL,'2014-01-21','admin','2019-12-08',0,NULL,0,0,NULL,NULL,0,'xitongguanliyuan','xtgly',1,'2019-10-20 12:17:05','0cbb43e14a4e039613db10c3d359401c68e4e67dfa6b3cef6d751e13af0ec1171e698f87c64032dc548d6ec7dc3c4863','0',0,NULL,NULL,0,700,'127.0.0.1',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
- ;
- UNLOCK TABLES;
- ;
- ;
- ;
- ;
- ;
- ;
- ;
- ;
|