/
model.py
140 lines (114 loc) · 4.54 KB
/
model.py
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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
from sqlalchemy import MetaData, Table, Column, TEXT, Index, INTEGER
# In sqlite3 this does not matter, it supports 64-bit natively.
# In PostgreSQL we would care about the native type.
BIGINT = INTEGER
metadata = MetaData()
offtrac_meta = Table('offtrac_meta', metadata,
Column(u'key', TEXT(), primary_key=True),
Column(u'value', TEXT()))
attachment = Table('attachment', metadata,
Column(u'type', TEXT(), primary_key=True, nullable=False),
Column(u'id', TEXT(), primary_key=True, nullable=False),
Column(u'filename', TEXT(), primary_key=True, nullable=False),
Column(u'size', INTEGER()),
Column(u'time', BIGINT()),
Column(u'description', TEXT()),
Column(u'author', TEXT()),
Column(u'ipnr', TEXT()),
)
Index('attachment_pk', attachment.c.type, attachment.c.id, attachment.c.filename, unique=True)
wiki = Table('wiki', metadata,
Column(u'name', TEXT(), primary_key=True, nullable=False),
Column(u'version', INTEGER(), primary_key=True, nullable=False),
Column(u'time', BIGINT()),
Column(u'author', TEXT()),
Column(u'ipnr', TEXT()),
Column(u'text', TEXT()),
Column(u'comment', TEXT()),
Column(u'readonly', INTEGER()),
)
Index(u'wiki_time_idx', wiki.c.time, unique=False)
ticket = Table('ticket', metadata,
Column(u'id', INTEGER(), primary_key=True, nullable=False),
Column(u'type', TEXT()),
Column(u'time', BIGINT()),
Column(u'changetime', BIGINT()),
Column(u'component', TEXT()),
Column(u'severity', TEXT()),
Column(u'priority', TEXT()),
Column(u'owner', TEXT()),
Column(u'reporter', TEXT()),
Column(u'cc', TEXT()),
Column(u'version', TEXT()),
Column(u'milestone', TEXT()),
Column(u'status', TEXT()),
Column(u'resolution', TEXT()),
Column(u'summary', TEXT()),
Column(u'description', TEXT()),
Column(u'keywords', TEXT()),
)
Index(u'ticket_time_idx', ticket.c.time, unique=False)
Index(u'ticket_status_idx', ticket.c.status, unique=False)
version = Table('version', metadata,
Column(u'name', TEXT(), primary_key=True, nullable=False),
Column(u'time', BIGINT()),
Column(u'description', TEXT()),
)
Index('version_pkey', version.c.name, unique=True)
report = Table('report', metadata,
Column(u'id', INTEGER(), primary_key=True, nullable=False),
Column(u'author', TEXT()),
Column(u'title', TEXT()),
Column(u'query', TEXT()),
Column(u'description', TEXT()),
)
Index('report_pkey', report.c.id, unique=True)
ticket_change = Table('ticket_change', metadata,
Column(u'ticket', INTEGER(), primary_key=True, nullable=False),
Column(u'time', BIGINT(), primary_key=True, nullable=False),
Column(u'author', TEXT()),
Column(u'field', TEXT(), primary_key=True, nullable=False),
Column(u'oldvalue', TEXT()),
Column(u'newvalue', TEXT()),
)
Index(u'ticket_change_ticket_idx', ticket_change.c.ticket, unique=False)
Index(u'ticket_change_time_idx', ticket_change.c.time, unique=False)
ticket_custom = Table('ticket_custom', metadata,
Column(u'ticket', INTEGER(), primary_key=True, nullable=False),
Column(u'name', TEXT(), primary_key=True, nullable=False),
Column(u'value', TEXT()),
)
Index('ticket_custom_pk', ticket_custom.c.ticket, ticket_custom.c.name, unique=True)
enum = Table('enum', metadata,
Column(u'type', TEXT(), primary_key=True, nullable=False),
Column(u'name', TEXT(), primary_key=True, nullable=False),
Column(u'value', TEXT()),
)
Index('enum_pk', enum.c.type, enum.c.name, unique=True)
component = Table('component', metadata,
Column(u'name', TEXT(), primary_key=True, nullable=False),
Column(u'owner', TEXT()),
Column(u'description', TEXT()),
)
Index('component_pkey', component.c.name, unique=True)
repository = Table('repository', metadata,
Column(u'id', INTEGER(), primary_key=True, nullable=False),
Column(u'name', TEXT(), primary_key=True, nullable=False),
Column(u'value', TEXT()),
)
Index('repository_pk', repository.c.id, repository.c.name, unique=True)
milestone = Table('milestone', metadata,
Column(u'name', TEXT(), primary_key=True, nullable=False),
Column(u'due', BIGINT()),
Column(u'completed', BIGINT()),
Column(u'description', TEXT()),
)
Index('milestone_pkey', milestone.c.name, unique=True)
revision = Table('revision', metadata,
Column(u'repos', INTEGER(), primary_key=True, nullable=False),
Column(u'rev', TEXT(), primary_key=True, nullable=False),
Column(u'time', BIGINT()),
Column(u'author', TEXT()),
Column(u'message', TEXT()),
)
Index(u'revision_repos_time_idx', revision.c.repos, revision.c.time, unique=False)