Trac研究 (01) 表结构

nethermit

墨衍会员 · AI 创作全网分发码龄24年

关注

最新推荐文章于 2025-07-24 09:00:00 发布 234 阅读 AI 写同款· GEO 优化 ›

sql 代码

CREATE TABLE system (
name text PRIMARY KEY,
value text
)
CREATE TABLE permission (
username text,
action text,
UNIQUE (username,action)
)
CREATE TABLE auth_cookie (
cookie text,
name text,
ipnr text,
time integer,
UNIQUE (cookie,ipnr,name)
)
CREATE TABLE session (
sid text,
authenticated integer,
last_visit integer,
UNIQUE (sid,authenticated)
)
CREATE INDEX session_last_visit_idx ON session (last_visit)
CREATE INDEX session_authenticated_idx ON session (authenticated)
CREATE TABLE session_attribute (
sid text,
authenticated integer,
name text,
value text,
UNIQUE (sid,authenticated,name)
)
CREATE TABLE attachment (
type text,
id text,
filename text,
size integer,
time integer,
description text,
author text,
ipnr text,
UNIQUE (type,id,filename)
)
CREATE TABLE wiki (
name text,
version integer,
time integer,
author text,
ipnr text,
text text,
comment text,
readonly integer,
UNIQUE (name,version)
)
CREATE INDEX wiki_time_idx ON wiki (time)
CREATE TABLE revision (
rev text PRIMARY KEY,
time integer,
author text,
message text
)
CREATE INDEX revision_time_idx ON revision (time)
CREATE TABLE node_change (
rev text,
path text,
node_type text,
change_type text,
base_path text,
base_rev text,
UNIQUE (rev,path,change_type)
)
CREATE INDEX node_change_rev_idx ON node_change (rev)
CREATE TABLE ticket (
id integer PRIMARY KEY,
type text,
time integer,
changetime integer,
component text,
severity text,
priority text,
owner text,
reporter text,
cc text,
version text,
milestone text,
status text,
resolution text,
summary text,
description text,
keywords text
)
CREATE INDEX ticket_time_idx ON ticket (time)
CREATE INDEX ticket_status_idx ON ticket (status)
CREATE TABLE ticket_change (
ticket integer,
time integer,
author text,
field text,
oldvalue text,
newvalue text,
UNIQUE (ticket,time,field)
)
CREATE INDEX ticket_change_ticket_idx ON ticket_change (ticket)
CREATE INDEX ticket_change_time_idx ON ticket_change (time)
CREATE TABLE ticket_custom (
ticket integer,
name text,
value text,
UNIQUE (ticket,name)
)
CREATE TABLE enum (
type text,
name text,
value text,
UNIQUE (type,name)
)
CREATE TABLE component (
name text PRIMARY KEY,
owner text,
description text
)
CREATE TABLE milestone (
name text PRIMARY KEY,
due integer,
completed integer,
description text
)
CREATE TABLE version (
name text PRIMARY KEY,
time integer,
description text
)
CREATE TABLE report (
id integer PRIMARY KEY,
author text,
title text,
query text,
description text
)

收录于

Python

标签

#SQL

JAX/JAXlib GPU 加速版本安装教程（CUDA）本文介绍了在Windows WSL2+Ubuntu22.04环境下配置JAX/JAXlib GPU加速版本的详细步骤。使用RTX 4060显卡，安装CUDA 12.4和cuDNN 8.9.7驱动，通过Miniconda创建Python 3.9虚拟环境。具体步骤包括：安装Miniconda、配置CUDA环境变量、安装cuDNN驱动、下载并安装JAX/JAXlib。最后通过测试代码验证GPU加速功能，成功检测到GPU并完成矩阵运算。整个过程配有详细命令和截图说明，适合需要搭建JAX GPU开发环境的用户参考。阅读详情

Trac研究 (01) 表结构

相关推荐