netserva/sysadm.dbml at main · markc/netserva · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
// NetServa 3.0 - Per-VNode Database Schema
// MariaDB: sysadm database
// SQLite: /var/lib/sqlite/sysadm/sysadm.db

Project sysadm {
  Note: 'Minimal Postfix + Dovecot schema: vhosts, vmails, valias (SQLite or MySQL)'
}

Table vhosts {
  id integer [pk, increment]
  domain text [unique, not null]
  uid integer [not null]
  gid integer [not null]
  active integer [default: 1]
  created_at datetime
  updated_at datetime

  indexes {
    domain [name: 'idx_vhosts_domain']
  }
}

Table vmails {
  id integer [pk, increment]
  user varchar(255) [unique, not null]
  pass varchar(255) [not null]
  home varchar(255) [not null]
  uid integer [not null]
  gid integer [not null]
  active integer [default: 1]
  created_at datetime [default: `CURRENT_TIMESTAMP`]
  updated_at datetime [default: `CURRENT_TIMESTAMP`]

  indexes {
    user [name: 'idx_vmails_user']
  }
}

Table valias {
  id integer [pk, increment]
  source varchar(255) [unique, not null]
  target text [not null]
  active integer [default: 1]
  created_at datetime [default: `CURRENT_TIMESTAMP`]
  updated_at datetime [default: `CURRENT_TIMESTAMP`]

  indexes {
    source [name: 'idx_valias_source']
  }
}