commit 4720585551b4a34091ec115bb50f0b684ce99b64
author 刘洪青 <loie.engine@gmail.com> 周五 8月 14 13:39:30 2020 +0800
committer 刘洪青 <loie.engine@gmail.com> 周五 8月 14 13:39:30 2020 +0800
tree fe82e91e316eeeee169e444177b4acfefe8d75b2

docs: 认证授权服务部署文档

testing/sql/accounts.sql

diff --git a/testing/sql/accounts.sql b/testing/sql/accounts.sql
new file mode 100644
index 0000000..54dfc5e
--- /dev/null
+++ b/testing/sql/accounts.sql
@@ -0,0 +1,12 @@
+
+
+select TB_B_ACCOUNT.ACCOUNT_NAME, TB_B_USER.PASSWORD from TB_B_ACCOUNT
+inner join TB_B_USER on TB_B_ACCOUNT.USER_ID=TB_B_USER.ID
+where TB_B_ACCOUNT.IDENTITY_TYPE_ID='T01'
+  and TB_B_ACCOUNT.ACCOUNT_EXPIRY_DATE is null
+  and TB_B_ACCOUNT.STATE='NORMAL'
+
+
+
+update TB_B_ACCOUNT
+set ACTIVATION=1