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
- )