DBViewer

• ⌂ /
• main

Create tables

CREATE TABLE collaboration (
  row_id integer primary key autoincrement,
  project integer not null default 0,
  user integer not null default 0,
  unique(project,
  user)
)    

CREATE TABLE issue (
  row_id integer primary key autoincrement,
  project integer not null default 0,
  number integer not null default 0,
  title not null default '',
  open integer not null default 0,
  open_time integer not null default 0,
  open_user integer not null default 0,
  pull_request integer not null default 0,
  unique(project,
  number)
)    

CREATE TABLE issue_label (
  row_id integer primary key autoincrement,
  issue integer not null default 0,
  label integer not null default 0,
  unique(issue,
  label)
)    

CREATE TABLE issue_message (
  row_id integer primary key autoincrement,
  issue integer not null default 0,
  number integer not null default 0,
  message not null default '',
  create_time integer not null default 0,
  update_time integer not null default 0,
  user integer not null default 0,
  reactions not null default '',
  unique(issue,
  number)
)    

CREATE TABLE label (
  row_id integer primary key autoincrement,
  project integer not null default 0,
  id varchar(100) not null default '',
  description not null default '',
  color not null default '',
  unique(project,
  id)
)    

CREATE TABLE project (
  row_id integer primary key autoincrement,
  user integer not null default 0,
  id not null default '',
  original_project integer not null default 0,
  created integer not null default 0,
  private integer not null default 0,
  ignore_space_change integer not null default 0,
  guess_encoding not null default '',
  website_url not null default '',
  unique(user,
  id)
)    

CREATE TABLE pull_request (
  row_id integer primary key autoincrement,
  base_project integer not null default 0,
  base_branch not null default '',
  target_project integer not null default 0,
  target_branch not null default '',
  create_time integer not null default 0,
  update_time integer not null default 0,
  user integer not null default 0,
  unique(base_project,
  base_branch,
  target_project,
  target_branch)
)    

CREATE TABLE ruleset (
  row_id integer primary key autoincrement,
  project integer not null default 0,
  name not null default '',
  target not null default '',
  active integer not null default 0,
  owner_bypass integer not null default 0,
  creation integer not null default 0,
  updating integer not null default 0,
  deletion integer not null default 0,
  required_signatures integer not null default 0,
  non_fast_forward integer not null default 0,
  unique(project,
  name,
  target)
)    

CREATE TABLE ruleset_selector (
  row_id integer primary key autoincrement,
  ruleset integer not null default 0,
  kind not null default '',
  selector not null default ''
)    

CREATE TABLE sqlite_sequence(
  name,seq
)    

CREATE TABLE ssh_public_key (
  row_id integer primary key autoincrement,
  key not null unique default '',
  user integer not null default 0,
  title not null default ''
)    

CREATE TABLE subscription (
  row_id integer primary key autoincrement,
  issue integer not null default 0,
  user integer not null default 0,
  reason text not null default '',
  unique(issue,
  user)
)    

CREATE TABLE user (
  row_id integer primary key autoincrement,
  id not null unique default '',
  email not null unique default '',
  admin integer not null default 0,
  password not null default '',
  salt not null default '',
  name not null default '',
  show_email integer not null default 0,
  avatar blob not null default '',
  bio not null default '',
  url not null default '',
  location not null default '',
  company not null default '',
  social not null default ''
)    

CREATE TABLE watch (
  row_id integer primary key autoincrement,
  user integer not null default 0,
  project integer not null default 0,
  unique(user,
  project)
)    

CREATE TABLE wiki (
  row_id integer primary key autoincrement,
  project integer not null default 0,
  unique(project)
)