summaryrefslogtreecommitdiffstats
path: root/database/appmarket_update_2.0-3.0.sql
diff options
context:
space:
mode:
authorzheng_wenlong <wenlong_zheng@nexty-ele.com>2019-04-16 11:20:38 +0900
committerzheng_wenlong <wenlong_zheng@nexty-ele.com>2019-05-13 17:50:04 +0900
commit3b55d06b89bf64873e685c3d78fce5affbba3d17 (patch)
tree2adcff0087f4757107d2bf1e50c85ea649f04f94 /database/appmarket_update_2.0-3.0.sql
[Patch Set 2] Add ReadMe.md Change-Id: I6ade52d2490f5ca4ba107c1a27ed6d5b39048725 Signed-off-by: zheng_wenlong <wenlong_zheng@nexty-ele.com>
Diffstat (limited to 'database/appmarket_update_2.0-3.0.sql')
-rw-r--r--database/appmarket_update_2.0-3.0.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/database/appmarket_update_2.0-3.0.sql b/database/appmarket_update_2.0-3.0.sql
new file mode 100644
index 0000000..5f19cab
--- /dev/null
+++ b/database/appmarket_update_2.0-3.0.sql
@@ -0,0 +1,4 @@
+DELETE FROM `appmarket`.`t_authority_resource_link`;
+DELETE FROM `appmarket`.`t_resource`;
+INSERT INTO `t_authority_resource_link` VALUES ('00001','1'),('01001','1'),('01002','1'),('01003','1'),('01004','1'),('01005','1'),('01006','1'),('01007','1'),('02001','1'),('02002','1'),('02003','1'),('02004','1'),('02005','1'),('02006','1'),('02007','1'),('02008','1'),('10000','1'),('11001','1'),('11002','1'),('11003','1'),('11004','1'),('11005','1'),('12001','1'),('12002','1'),('12003','1'),('12004','1'),('12005','1'),('12006','1'),('12007','1'),('12008','1'),('12009','1'),('13001','1'),('14001','1'),('14002','1'),('14003','1'),('15001','1'),('16001','1'),('00001','2'),('02001','2'),('02002','2'),('02003','2'),('02004','2'),('02005','2'),('02006','2'),('02007','2'),('02008','2'),('10000','2'),('11005','2'),('12001','2'),('12002','2'),('12003','2'),('12004','2'),('12005','2'),('12006','2'),('12007','2'),('12008','2'),('12009','2'),('13001','2'),('14001','2'),('14002','2'),('14003','2'),('15001','2'),('16001','2'),('00001','3'),('02001','3'),('02004','3'),('02007','3'),('02008','3'),('10000','3'),('11005','3'),('12001','3'),('12002','3'),('12006','3'),('12008','3'),('12009','3'),('13001','3'),('14002','3'),('14003','3'),('15001','3'),('16001','3'),('00001','4'),('02001','4'),('02004','4'),('02007','4'),('02008','4'),('10000','4'),('11005','4'),('12001','4'),('12002','4'),('12006','4'),('12008','4'),('12009','4'),('13001','4'),('14002','4'),('14003','4'),('15001','4'),('16001','4');
+INSERT INTO `t_resource` VALUES ('00001','メイン画面','resource','/main',NULL),('01001','アカウントリスト','resource','/account/list',NULL),('01002','アカウント編集','resource','/account/modify',NULL),('01003','アカウント検索','resource','/account/search',NULL),('01004','アカウント更新','resource','/account/update',NULL),('01005','アカウント新規を保存','resource','/account/save',NULL),('01006','アカウントを削除','resource','/account/delete',NULL),('01007','アカウント詳細','resource','/account/detail',NULL),('02001','アプリリスト','resource','/app/list',NULL),('02002','アプリ編集','resource','/app/modify',NULL),('02003','アプリ新規','resource','/app/save',NULL),('02004','アプリ検索','resource','/app/search',NULL),('02005','アプリ新規','resource','/app/insert',NULL),('02006','アプリ削除','resource','/app/delete',NULL),('02007','アプリダウンロード ','resource','/app/download',NULL),('02008','アプリ情報','resource','/app/detail',NULL),('10000','login','api','/login','POST'),('11001','getUserList','api','/user/collection','GET'),('11002','getUserById','api','/user/{userId}','GET'),('11003','updateUser','api','/user','POST'),('11004','deleteUser','api','/user/{userId}','DELETE'),('11005','getCurrentUser','api','/user/currentUser','GET'),('12001','getAppList','api','/app/collection','GET'),('12002','getApp','api','/app/info/{appId}','GET'),('12003','updateApp','api','/app/info','POST'),('12004','updateAppVersion','api','/app/info/version','POST'),('12005','deleteAppAllInfo','api','/app/info/{appId}','DELETE'),('12006','getDictionaryCollection','api','/dictionary/collection/{DictionaryTypeId}','GET'),('12007','updateImageFile','api','/app/image','POST'),('12008','getAppInfoByCustomId','api','/app/info/dev/{appIdCustom}','GET'),('12009','saveDictionary','api','/dictionary/info','POST'),('13001','getAuthorityCollection','api','/authority/collection','GET'),('14001','updateAppFile','api','/app/file/{fileName}/{appTypeId}/{appId}','POST'),('14002','downloadAppFile','api','/app/file/{fileName}/{appTypeId}/{appId}','GET'),('14003','downloadAppFile','api','/app/file','GET'),('15001','getMenuResource','api','/resource/menuResource/collection','GET'),('16001','refreshToken','api','/token/{refreshToken}','GET'); \ No newline at end of file