forked from Toroid-io/wekan-gogs
-
Notifications
You must be signed in to change notification settings - Fork 3
/
wekan-gogs.sqlite
66 lines (58 loc) · 1.3 KB
/
wekan-gogs.sqlite
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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
/* This script creates an initial DB, with default configurations */
CREATE TABLE IF NOT EXISTS 'auth' (
'gogs_token' varchar,
PRIMARY KEY(gogs_token)
);
CREATE TABLE IF NOT EXISTS 'repos' (
'repoId' integer,
'username' varchar,
'repoName' varchar,
'boardId' varchar,
'backlogListId' varchar,
'active' integer,
'active_prio' integer,
'hookId' integer,
'hook_prioId' integer,
'defaultSwimlaneId' varchar,
PRIMARY KEY(repoId)
);
CREATE TABLE IF NOT EXISTS 'cards' (
'issueId' integer,
'repoId' integer,
'issueIndex' integer,
'cardId' varchar,
'cardPrioId' varchar,
'boardId' varchar,
'swimlaneId' varchar,
'listId' varchar,
'listPrioId' varchar,
PRIMARY KEY(issueId)
);
CREATE TABLE IF NOT EXISTS 'comments' (
'gcommentId' integer,
'wcommentId' varchar,
'cardId' varchar,
PRIMARY KEY(gcommentId)
);
CREATE TABLE IF NOT EXISTS 'boards_prio' (
'wekan_userid' varchar,
'boardId' varchar,
'backlogListId' varchar,
'defaultSwimlaneId' varchar,
PRIMARY KEY(wekan_userid)
);
CREATE TABLE IF NOT EXISTS 'lists_prio' (
'listId' varchar,
'boardId' varchar,
'labelName' varchar,
PRIMARY KEY(listId)
);
CREATE TABLE IF NOT EXISTS 'labels' (
'idsql' integer,
'id' integer UNIQUE,
'repoId' integer,
'labelName' varchar,
'listId' varchar,
'prioListId' varchar,
PRIMARY KEY(id)
);