Module dabab11132c1_initial_db_setup
|
|
1 """Initial DB setup
2
3 Revision ID: dabab11132c1
4 Revises: None
5 Create Date: 2018-09-04 09:58:36.678749
6
7 """
8
9
10 revision = 'dabab11132c1'
11 down_revision = None
12
13 from alembic import op
14 import sqlalchemy as sa
15
16 import sys, os
17 sys.path.append(os.getcwd())
18 import coprs
19
20
22
23 op.create_table('action',
24 sa.Column('id', sa.Integer(), nullable=False),
25 sa.Column('action_type', sa.Integer(), nullable=False),
26 sa.Column('object_type', sa.String(length=20), nullable=True),
27 sa.Column('object_id', sa.Integer(), nullable=True),
28 sa.Column('old_value', sa.String(length=255), nullable=True),
29 sa.Column('new_value', sa.String(length=255), nullable=True),
30 sa.Column('data', sa.Text(), nullable=True),
31 sa.Column('result', sa.Integer(), nullable=True),
32 sa.Column('message', sa.Text(), nullable=True),
33 sa.Column('created_on', sa.Integer(), nullable=True),
34 sa.Column('ended_on', sa.Integer(), nullable=True),
35 sa.PrimaryKeyConstraint('id')
36 )
37 op.create_table('counter_stat',
38 sa.Column('name', sa.String(length=127), nullable=False),
39 sa.Column('counter_type', sa.String(length=30), nullable=True),
40 sa.Column('counter', sa.Integer(), server_default='0', nullable=True),
41 sa.PrimaryKeyConstraint('name')
42 )
43 op.create_table('group',
44 sa.Column('id', sa.Integer(), nullable=False),
45 sa.Column('name', sa.String(length=127), nullable=True),
46 sa.Column('fas_name', sa.String(length=127), nullable=True),
47 sa.PrimaryKeyConstraint('id')
48 )
49 op.create_table('mock_chroot',
50 sa.Column('id', sa.Integer(), nullable=False),
51 sa.Column('os_release', sa.String(length=50), nullable=False),
52 sa.Column('os_version', sa.String(length=50), nullable=False),
53 sa.Column('arch', sa.String(length=50), nullable=False),
54 sa.Column('is_active', sa.Boolean(), nullable=True),
55 sa.PrimaryKeyConstraint('id')
56 )
57 op.create_table('user',
58 sa.Column('id', sa.Integer(), nullable=False),
59 sa.Column('username', sa.String(length=100), nullable=False),
60 sa.Column('mail', sa.String(length=150), nullable=False),
61 sa.Column('timezone', sa.String(length=50), nullable=True),
62 sa.Column('proven', sa.Boolean(), nullable=True),
63 sa.Column('admin', sa.Boolean(), nullable=True),
64 sa.Column('api_login', sa.String(length=40), nullable=False),
65 sa.Column('api_token', sa.String(length=40), nullable=False),
66 sa.Column('api_token_expiration', sa.Date(), nullable=False),
67 sa.Column('openid_groups', coprs.helpers.JSONEncodedDict(), nullable=True),
68 sa.PrimaryKeyConstraint('id'),
69 sa.UniqueConstraint('username')
70 )
71 op.create_table('copr',
72 sa.Column('id', sa.Integer(), nullable=False),
73 sa.Column('name', sa.String(length=100), nullable=False),
74 sa.Column('homepage', sa.Text(), nullable=True),
75 sa.Column('contact', sa.Text(), nullable=True),
76 sa.Column('repos', sa.Text(), nullable=True),
77 sa.Column('created_on', sa.Integer(), nullable=True),
78 sa.Column('description', sa.Text(), nullable=True),
79 sa.Column('instructions', sa.Text(), nullable=True),
80 sa.Column('deleted', sa.Boolean(), nullable=True),
81 sa.Column('playground', sa.Boolean(), nullable=True),
82 sa.Column('auto_createrepo', sa.Boolean(), nullable=True),
83 sa.Column('user_id', sa.Integer(), nullable=True),
84 sa.Column('group_id', sa.Integer(), nullable=True),
85 sa.Column('forked_from_id', sa.Integer(), nullable=True),
86 sa.Column('webhook_secret', sa.String(length=100), nullable=True),
87 sa.Column('build_enable_net', sa.Boolean(), server_default='1', nullable=False),
88 sa.Column('unlisted_on_hp', sa.Boolean(), nullable=False),
89 sa.Column('latest_indexed_data_update', sa.Integer(), nullable=True),
90 sa.Column('persistent', sa.Boolean(), server_default='0', nullable=False),
91 sa.Column('auto_prune', sa.Boolean(), server_default='1', nullable=False),
92 sa.ForeignKeyConstraint(['forked_from_id'], ['copr.id'], ),
93 sa.ForeignKeyConstraint(['group_id'], ['group.id'], ),
94 sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
95 sa.PrimaryKeyConstraint('id')
96 )
97 op.create_table('krb5_login',
98 sa.Column('user_id', sa.Integer(), nullable=False),
99 sa.Column('config_name', sa.String(length=30), nullable=False),
100 sa.Column('primary', sa.String(length=80), nullable=False),
101 sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
102 sa.PrimaryKeyConstraint('config_name', 'primary')
103 )
104 op.create_table('copr_chroot',
105 sa.Column('buildroot_pkgs', sa.Text(), nullable=True),
106 sa.Column('mock_chroot_id', sa.Integer(), nullable=False),
107 sa.Column('copr_id', sa.Integer(), nullable=False),
108 sa.Column('comps_zlib', sa.LargeBinary(), nullable=True),
109 sa.Column('comps_name', sa.String(length=127), nullable=True),
110 sa.Column('module_md_zlib', sa.LargeBinary(), nullable=True),
111 sa.Column('module_md_name', sa.String(length=127), nullable=True),
112 sa.ForeignKeyConstraint(['copr_id'], ['copr.id'], ),
113 sa.ForeignKeyConstraint(['mock_chroot_id'], ['mock_chroot.id'], ),
114 sa.PrimaryKeyConstraint('mock_chroot_id', 'copr_id')
115 )
116 op.create_table('copr_permission',
117 sa.Column('copr_builder', sa.SmallInteger(), nullable=True),
118 sa.Column('copr_admin', sa.SmallInteger(), nullable=True),
119 sa.Column('user_id', sa.Integer(), nullable=False),
120 sa.Column('copr_id', sa.Integer(), nullable=False),
121 sa.ForeignKeyConstraint(['copr_id'], ['copr.id'], ),
122 sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
123 sa.PrimaryKeyConstraint('user_id', 'copr_id')
124 )
125 op.create_table('legal_flag',
126 sa.Column('id', sa.Integer(), nullable=False),
127 sa.Column('raise_message', sa.Text(), nullable=True),
128 sa.Column('raised_on', sa.Integer(), nullable=True),
129 sa.Column('resolved_on', sa.Integer(), nullable=True),
130 sa.Column('copr_id', sa.Integer(), nullable=True),
131 sa.Column('reporter_id', sa.Integer(), nullable=True),
132 sa.Column('resolver_id', sa.Integer(), nullable=True),
133 sa.ForeignKeyConstraint(['copr_id'], ['copr.id'], ),
134 sa.ForeignKeyConstraint(['reporter_id'], ['user.id'], ),
135 sa.ForeignKeyConstraint(['resolver_id'], ['user.id'], ),
136 sa.PrimaryKeyConstraint('id')
137 )
138 op.create_table('module',
139 sa.Column('id', sa.Integer, primary_key=True),
140 sa.Column('name', sa.String(100), nullable=False),
141 sa.Column('stream', sa.String(100), nullable=False),
142 sa.Column('version', sa.BigInteger, nullable=False),
143 sa.Column('summary', sa.String(100), nullable=False),
144 sa.Column('description', sa.Text),
145 sa.Column('created_on', sa.Integer, nullable=True),
146 sa.Column('yaml_b64', sa.Text),
147 sa.Column('copr_id', sa.Integer, sa.ForeignKey('copr.id')),
148 )
149 op.create_table('package',
150 sa.Column('id', sa.Integer(), nullable=False),
151 sa.Column('name', sa.String(length=100), nullable=False),
152 sa.Column('source_type', sa.Integer(), nullable=True),
153 sa.Column('source_json', sa.Text(), nullable=True),
154 sa.Column('webhook_rebuild', sa.Boolean(), nullable=True),
155 sa.Column('enable_net', sa.Boolean(), server_default='0', nullable=False),
156 sa.Column('old_status', sa.Integer(), nullable=True),
157 sa.Column('copr_id', sa.Integer(), nullable=True),
158 sa.ForeignKeyConstraint(['copr_id'], ['copr.id'], ),
159 sa.PrimaryKeyConstraint('id'),
160 sa.UniqueConstraint('copr_id', 'name', name='packages_copr_pkgname')
161 )
162 op.create_table('build',
163 sa.Column('id', sa.Integer(), nullable=False),
164 sa.Column('pkgs', sa.Text(), nullable=True),
165 sa.Column('built_packages', sa.Text(), nullable=True),
166 sa.Column('pkg_version', sa.Text(), nullable=True),
167 sa.Column('canceled', sa.Boolean(), nullable=True),
168 sa.Column('repos', sa.Text(), nullable=True),
169 sa.Column('submitted_on', sa.Integer(), nullable=False),
170 sa.Column('results', sa.Text(), nullable=True),
171 sa.Column('memory_reqs', sa.Integer(), nullable=True),
172 sa.Column('timeout', sa.Integer(), nullable=True),
173 sa.Column('enable_net', sa.Boolean(), server_default='0', nullable=False),
174 sa.Column('source_type', sa.Integer(), nullable=True),
175 sa.Column('source_json', sa.Text(), nullable=True),
176 sa.Column('fail_type', sa.Integer(), nullable=True),
177 sa.Column('is_background', sa.Boolean(), server_default='0', nullable=False),
178 sa.Column('user_id', sa.Integer(), nullable=True),
179 sa.Column('copr_id', sa.Integer(), nullable=True),
180 sa.Column('package_id', sa.Integer(), nullable=True),
181 sa.ForeignKeyConstraint(['copr_id'], ['copr.id'], ),
182 sa.ForeignKeyConstraint(['package_id'], ['package.id'], ),
183 sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
184 sa.PrimaryKeyConstraint('id')
185 )
186 op.create_index('build_canceled', 'build', ['canceled'], unique=False)
187 op.create_table('build_chroot',
188 sa.Column('mock_chroot_id', sa.Integer(), nullable=False),
189 sa.Column('build_id', sa.Integer(), nullable=False),
190 sa.Column('git_hash', sa.String(length=40), nullable=True),
191 sa.Column('status', sa.Integer(), nullable=True),
192 sa.Column('started_on', sa.Integer(), nullable=True),
193 sa.Column('ended_on', sa.Integer(), nullable=True),
194 sa.Column('last_deferred', sa.Integer(), nullable=True),
195 sa.ForeignKeyConstraint(['build_id'], ['build.id'], ),
196 sa.ForeignKeyConstraint(['mock_chroot_id'], ['mock_chroot.id'], ),
197 sa.PrimaryKeyConstraint('mock_chroot_id', 'build_id')
198 )
199 op.create_index(op.f('ix_build_chroot_ended_on'), 'build_chroot', ['ended_on'], unique=False)
200
201
202
205