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