SQLite Web: gitea.db

id

Primary key. INTEGER NOT NULL

title

TEXT

repo_id

INTEGER

owner_id

INTEGER

workflow_id

TEXT

index

INTEGER

trigger_user_id

INTEGER

schedule_id

INTEGER

ref

TEXT

commit_sha

TEXT

is_fork_pull_request

INTEGER

need_approval

INTEGER

approved_by

INTEGER

event

TEXT

event_payload

{"ref":"refs/heads/master","before":"0000000000000000000000000000000000000000","after":"f6b6a3099bdc2128ef1527c4935844f1e9358dac","compare_url":"https://gitea.g-hi.com/","commits":[{"id":"f6b6a3099bdc2128ef1527c4935844f1e9358dac","message":"添加 Gitea Actions CI/CD 配置\n\n- 自动构建 Debug/Release 版本\n- 运行单元测试和 Lint 检查\n- 构建产物自动存档\n\nCo-Authored-By: Claude Opus 4.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/laiqiaojie/comtraffic/commit/f6b6a3099bdc2128ef1527c4935844f1e9358dac","author":{"name":"lqj","email":"lqj@g-hi.com","username":""},"committer":{"name":"lqj","email":"lqj@g-hi.com","username":""},"verification":null,"timestamp":"2026-02-06T14:25:43+08:00","added":[".gitea/workflows/android.yml"],"removed":[],"modified":[]},{"id":"23be956676468adfb084a7612e9a0d425d5a103b","message":"Initial commit: ComTraffic Android通讯服务模块\n\n项目包含：\n- KTV/娱乐系统后台通讯服务\n- UDP/WebSocket/HTTP多协议支持\n- 22个业务线程处理模块\n- 62个数据模型类\n- 15个工具类\n\nCo-Authored-By: Claude Opus 4.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/laiqiaojie/comtraffic/commit/23be956676468adfb084a7612e9a0d425d5a103b","author":{"name":"lqj","email":"lqj@g-hi.com","username":""},"committer":{"name":"lqj","email":"lqj@g-hi.com","username":""},"verification":null,"timestamp":"2026-02-06T14:19:57+08:00","added":[".gitignore","build.gradle","gradle/wrapper/gradle-wrapper.jar","gradle/wrapper/gradle-wrapper.properties","gradlew","gradlew.bat","libs/aliyun-vod-upload-android-sdk-1.0.6.jar","libs/commons-beanutils-1.8.3-connections.jar","libs/commons-collections-3.1.jar","libs/commons-compress-1.18.jar","libs/commons-lang-2.5.jar","libs/commons-logging.jar","libs/core-3.2.1.jar","libs/ezmorph-1.0.3.jar","libs/httpclient-4.2.5.jar","libs/httpclient-cache-4.2.5.jar","libs/httpcore-4.2.4.jar","libs/httpmime-4.2.5.jar","libs/ini4j-0.5.4.jar","libs/java_websocket.jar","libs/json-lib-2.1-jdk15.jar","libs/okhttp-3.9.0.jar","libs/okio-1.13.0.jar","libs/websocket-api.jar","proguard-rules.pro","src/main/AndroidManifest.xml","src/main/java/org/juhai/comtraffic/ComTrafficService.java","src/main/java/org/juhai/comtraffic/controller/ComTrafficFunction.java","src/main/java/org/juhai/comtraffic/controller/ComTrafficThread.java","src/main/java/org/juhai/comtraffic/controller/DownLoadCustomSongsThread.java","src/main/java/org/juhai/comtraffic/controller/DownLoadUpdateThread.java","src/main/java/org/juhai/comtraffic/controller/DownloadPatchResThread.java","src/main/java/org/juhai/comtraffic/controller/DownloadVoiceThread.java","src/main/java/org/juhai/comtraffic/controller/GetAdResourceThread.java","src/main/java/org/juhai/comtraffic/controller/GetImgResourceThread.java","src/main/java/org/juhai/comtraffic/controller/GetRoomInfoThread.java","src/main/java/org/juhai/comtraffic/controller/IniUpdateThread.java","src/main/java/org/juhai/comtraffic/controller/JHPlazaThread.java","src/main/java/org/juhai/comtraffic/controller/JspkThread.java","src/main/java/org/juhai/comtraffic/controller/LocationThread.java","src/main/java/org/juhai/comtraffic/controller/MicroPhoneThread.java","src/main/java/org/juhai/comtraffic/controller/NoticeThread.java","src/main/java/org/juhai/comtraffic/controller/ProxyBackupThread.java","src/main/java/org/juhai/comtraffic/controller/ProxyThread.java","src/main/java/org/juhai/comtraffic/controller/RebootThread.java","src/main/java/org/juhai/comtraffic/controller/UdpReceiveThread.java","src/main/java/org/juhai/comtraffic/controller/UpdateLightThread.java","src/main/java/org/juhai/comtraffic/controller/UpdateResThread.java","src/main/java/org/juhai/comtraffic/controller/UpdateTimeThread.java","src/main/java/org/juhai/comtraffic/model/AdResource/AdResourceHeader.java","src/main/java/org/juhai/comtraffic/model/AdResource/AdResourceModel.java","src/main/java/org/juhai/comtraffic/model/AdResource/AdResourceRequest.java","src/main/java/org/juhai/comtraffic/model/AdResource/AdUrlList.java","src/main/java/org/juhai/comtraffic/model/assistData/AssistDataHeader.java","src/main/java/org/juhai/comtraffic/model/assistData/AssistDataList.java","src/main/java/org/juhai/comtraffic/model/assistData/AssistDataModel.java","src/main/java/org/juhai/comtraffic/model/assistData/AssistDataResponse.java","src/main/java/org/juhai/comtraffic/model/customSongCarousel/CustomSongCarouselData.java","src/main/java/org/juhai/comtraffic/model/customSongCarousel/CustomSongCarouselHeader.java","src/main/java/org/juhai/comtraffic/model/customSongCarousel/CustomSongCarouselModel.java","src/main/java/org/juhai/comtraffic/model/customSongCarousel/CustomSongCarouselResponse.java","src/main/java/org/juhai/comtraffic/model/customSongCarousel/CustomSongCodeList.java","src/main/java/org/juhai/comtraffic/model/customSongCarousel/CustomSongData.java","src/main/java/org/juhai/comtraffic/model/data/GlobalModel.java","src/main/java/org/juhai/comtraffic/model/data/HttpResponseData.java","src/main/java/org/juhai/comtraffic/model/data/JspkId.java","src/main/java/org/juhai/comtraffic/model/data/ResData.java","src/main/java/org/juhai/comtraffic/model/data/RoomState.java","src/main/java/org/juhai/comtraffic/model/data/TypeDefine.java","src/main/java/org/juhai/comtraffic/model/data/UdpResponseData.java","src/main/java/org/juhai/comtraffic/model/data/UpdateListData.java","src/main/java/org/juhai/comtraffic/model/jspk/JspkHeader.java","src/main/java/org/juhai/comtraffic/model/jspk/JspkModel.java","src/main/java/org/juhai/comtraffic/model/jspk/JspkRequest.java","src/main/java/org/juhai/comtraffic/model/locationModel/LocationContent.java","src/main/java/org/juhai/comtraffic/model/locationModel/LocationModel.java","src/main/java/org/juhai/comtraffic/model/plazaModel/PlazaHeader.java","src/main/java/org/juhai/comtraffic/model/plazaModel/PlazaInfo.java","src/main/java/org/juhai/comtraffic/model/plazaModel/PlazaModel.java","src/main/java/org/juhai/comtraffic/model/plazaModel/PlazaResponse.java","src/main/java/org/juhai/comtraffic/model/plazaModel/PlazaResult.java","src/main/java/org/juhai/comtraffic/model/songCarousel/SongCarouselData.java","src/main/java/org/juhai/comtraffic/model/songCarousel/SongCarouselDataList.java","src/main/java/org/juhai/comtraffic/model/songCarousel/SongCarouselHeader.java","src/main/java/org/juhai/comtraffic/model/songCarousel/SongCarouselModel.java","src/main/java/org/juhai/comtraffic/model/songCarousel/SongCarouselResponse.java","src/main/java/org/juhai/comtraffic/model/ssh/SSHHeader.java","src/main/java/org/juhai/comtraffic/model/ssh/SSHModel.java","src/main/java/org/juhai/comtraffic/model/ssh/SSHRequest.java","src/main/java/org/juhai/comtraffic/model/udpReceive/UdpOrderSongsList.java","src/main/java/org/juhai/comtraffic/model/udpReceive/UdpReceiveHeader.java","src/main/java/org/juhai/comtraffic/model/udpReceive/UdpReceiveModel.java","src/main/java/org/juhai/comtraffic/model/udpReceive/UdpReceiveRequest.java","src/main/java/org/juhai/comtraffic/model/udpReceive/UdpSingersList.java","src/main/java/org/juhai/comtraffic/model/udpReceive/UdpSongsList.java","src/main/java/org/juhai/comtraffic/model/updateIni/UpdateIniHeader.java","src/main/java/org/juhai/comtraffic/model/updateIni/UpdateIniList.java","src/main/java/org/juhai/comtraffic/model/updateIni/UpdateIniModel.java","src/main/java/org/juhai/comtraffic/model/updateIni/UpdateIniResponse.java","src/main/java/org/juhai/comtraffic/model/updateSongs/UpdateSongsHeader.java","src/main/java/org/juhai/comtraffic/model/updateSongs/UpdateSongsModel.java","src/main/java/org/juhai/comtraffic/model/updateSongs/UpdateSongsResponse.java","src/main/java/org/juhai/comtraffic/model/updateVersion/UpdateVersionHeader.java","src/main/java/org/juhai/comtraffic/model/updateVersion/UpdateVersionModel.java","src/main/java/org/juhai/comtraffic/model/updateVersion/UpdateVersionResponse.java","src/main/java/org/juhai/comtraffic/model/updatetInterface/UpdateInterfaceHeader.java","src/main/java/org/juhai/comtraffic/model/updatetInterface/UpdateInterfaceModel.java","src/main/java/org/juhai/comtraffic/model/updatetInterface/UpdateInterfaceResponse.java","src/main/java/org/juhai/comtraffic/model/websocketReceive/WebsocketReceiveHeader.java","src/main/java/org/juhai/comtraffic/model/websocketReceive/WebsocketReceiveModel.java","src/main/java/org/juhai/comtraffic/model/websocketReceive/WebsocketReceiveRequest.java","src/main/java/org/juhai/comtraffic/util/CheckFileUtil.java","src/main/java/org/juhai/comtraffic/util/CmdUtil.java","src/main/java/org/juhai/comtraffic/util/CommonUtil.java","src/main/java/org/juhai/comtraffic/util/CompressUtil.java","src/main/java/org/juhai/comtraffic/util/DownloadUtil.java","src/main/java/org/juhai/comtraffic/util/DownloadUtil1.java","src/main/java/org/juhai/comtraffic/util/HttpGetUtil.java","src/main/java/org/juhai/comtraffic/util/HttpUtil.java","src/main/java/org/juhai/comtraffic/util/HttpUtils.java","src/main/java/org/juhai/comtraffic/util/IniUtil.java","src/main/java/org/juhai/comtraffic/util/LogUtil.java","src/main/java/org/juhai/comtraffic/util/Md5Util.java","src/main/java/org/juhai/comtraffic/util/PreferencesUtils.java","src/main/java/org/juhai/comtraffic/util/UdpUtil.java","src/main/java/org/juhai/comtraffic/util/UploadLogUtil.java","src/main/res/drawable-hdpi/listserver_status.png","src/main/res/drawable-ldpi/listserver_status.png","src/main/res/drawable-mdpi/listserver_status.png","src/main/res/drawable-xhdpi/listserver_status.png","src/main/res/values/strings.xml"],"removed":[],"modified":[]}],"total_commits":0,"head_commit":{"id":"f6b6a3099bdc2128ef1527c4935844f1e9358dac","message":"添加 Gitea Actions CI/CD 配置\n\n- 自动构建 Debug/Release 版本\n- 运行单元测试和 Lint 检查\n- 构建产物自动存档\n\nCo-Authored-By: Claude Opus 4.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/laiqiaojie/comtraffic/commit/f6b6a3099bdc2128ef1527c4935844f1e9358dac","author":{"name":"lqj","email":"lqj@g-hi.com","username":""},"committer":{"name":"lqj","email":"lqj@g-hi.com","username":""},"verification":null,"timestamp":"2026-02-06T14:25:43+08:00","added":[".gitea/workflows/android.yml"],"removed":[],"modified":[]},"repository":{"id":3,"owner":{"id":4,"login":"laiqiaojie","login_name":"","source_id":0,"full_name":"","email":"584481098@qq.com","avatar_url":"https://gitea.g-hi.com/avatars/6b2595dc076a8139122d7d30d2fc49a7","html_url":"https://gitea.g-hi.com/laiqiaojie","language":"","is_admin":false,"last_login":"0001-01-01T00:00:00Z","created":"2026-01-30T16:06:00+08:00","restricted":false,"active":false,"prohibit_login":false,"location":"","website":"","description":"","visibility":"public","followers_count":0,"following_count":0,"starred_repos_count":0,"username":"laiqiaojie"},"name":"comtraffic","full_name":"laiqiaojie/comtraffic","description":"包厢 通讯中心 服务","empty":false,"private":true,"fork":false,"template":false,"parent":null,"mirror":false,"size":27,"language":"","languages_url":"https://gitea.g-hi.com/api/v1/repos/laiqiaojie/comtraffic/languages","html_url":"https://gitea.g-hi.com/laiqiaojie/comtraffic","url":"https://gitea.g-hi.com/api/v1/repos/laiqiaojie/comtraffic","link":"","ssh_url":"git@gitea.g-hi.com:laiqiaojie/comtraffic.git","clone_url":"https://gitea.g-hi.com/laiqiaojie/comtraffic.git","original_url":"","website":"","stars_count":0,"forks_count":0,"watchers_count":1,"open_issues_count":0,"open_pr_counter":0,"release_counter":0,"default_branch":"master","archived":false,"created_at":"2026-02-06T14:30:14+08:00","updated_at":"2026-02-06T14:40:30+08:00","archived_at":"1970-01-01T08:00:00+08:00","permissions":{"admin":true,"push":true,"pull":true},"has_issues":true,"internal_tracker":{"enable_time_tracker":true,"allow_only_contributors_to_track_time":true,"enable_issue_dependencies":true},"has_wiki":true,"has_pull_requests":true,"has_projects":true,"projects_mode":"all","has_releases":true,"has_packages":true,"has_actions":true,"ignore_whitespace_conflicts":false,"allow_merge_commits":true,"allow_rebase":true,"allow_rebase_explicit":true,"allow_squash_merge":true,"allow_fast_forward_only_merge":true,"allow_rebase_update":true,"default_delete_branch_after_merge":false,"default_merge_style":"merge","default_allow_maintainer_edit":false,"avatar_url":"","internal":false,"mirror_interval":"","object_format_name":"sha1","mirror_updated":"0001-01-01T00:00:00Z","repo_transfer":null},"pusher":{"id":4,"login":"laiqiaojie","login_name":"","source_id":0,"full_name":"","email":"laiqiaojie@noreply.localhost","avatar_url":"https://gitea.g-hi.com/avatars/6b2595dc076a8139122d7d30d2fc49a7","html_url":"https://gitea.g-hi.com/laiqiaojie","language":"","is_admin":false,"last_login":"0001-01-01T00:00:00Z","created":"2026-01-30T16:06:00+08:00","restricted":false,"active":false,"prohibit_login":false,"location":"","website":"","description":"","visibility":"public","followers_count":0,"following_count":0,"starred_repos_count":0,"username":"laiqiaojie"},"sender":{"id":4,"login":"laiqiaojie","login_name":"","source_id":0,"full_name":"","email":"laiqiaojie@noreply.localhost","avatar_url":"https://gitea.g-hi.com/avatars/6b2595dc076a8139122d7d30d2fc49a7","html_url":"https://gitea.g-hi.com/laiqiaojie","language":"","is_admin":false,"last_login":"0001-01-01T00:00:00Z","created":"2026-01-30T16:06:00+08:00","restricted":false,"active":false,"prohibit_login":false,"location":"","website":"","description":"","visibility":"public","followers_count":0,"following_count":0,"starred_repos_count":0,"username":"laiqiaojie"}}

TEXT

trigger_event

TEXT

status

INTEGER

version

INTEGER (default 0

started

INTEGER

stopped

INTEGER

previous_duration

INTEGER

created

INTEGER

updated

INTEGER

raw_concurrency

TEXT

concurrency_group

TEXT NOT NULL (default ''

concurrency_cancel

INTEGER NOT NULL (default FALSE

Update row 1 in action_run