Source Code for Script script-595a31c145fb_initial_db_setup_py

 1  """Initial DB setup 
 2   
 3  Revision ID: 595a31c145fb 
 4  Revises: None 
 5  Create Date: 2012-11-26 09:39:51.229910 
 6   
 7  """ 
 8   
 9  # revision identifiers, used by Alembic. 
10  revision = '595a31c145fb' 
11  down_revision = None 
12   
13  from alembic import op 
14  import sqlalchemy as sa 
15   
16   
17 -def upgrade(): 
18      ### commands auto generated by Alembic - please adjust! ### 
19      op.create_table('user', 
20      sa.Column('id', sa.Integer(), nullable=False), 
21      sa.Column('openid_name', sa.String(length=100), nullable=False), 
22      sa.Column('mail', sa.String(length=150), nullable=False), 
23      sa.Column('proven', sa.Boolean(), nullable=True), 
24      sa.Column('admin', sa.Boolean(), nullable=True), 
25      sa.PrimaryKeyConstraint('id') 
26      ) 
27      op.create_table('copr', 
28      sa.Column('id', sa.Integer(), nullable=False), 
29      sa.Column('name', sa.String(length=100), nullable=False), 
30      sa.Column('chroots', sa.Text(), nullable=False), 
31      sa.Column('repos', sa.Text(), nullable=True), 
32      sa.Column('created_on', sa.Integer(), nullable=True), 
33      sa.Column('build_count', sa.Integer(), nullable=True), 
34      sa.Column('owner_id', sa.Integer(), nullable=True), 
35      sa.ForeignKeyConstraint(['owner_id'], ['user.id'], ), 
36      sa.PrimaryKeyConstraint('id') 
37      ) 
38      op.create_table('build', 
39      sa.Column('id', sa.Integer(), nullable=False), 
40      sa.Column('pkgs', sa.Text(), nullable=True), 
41      sa.Column('canceled', sa.Boolean(), nullable=True), 
42      sa.Column('chroots', sa.Text(), nullable=False), 
43      sa.Column('repos', sa.Text(), nullable=True), 
44      sa.Column('submitted_on', sa.Integer(), nullable=False), 
45      sa.Column('started_on', sa.Integer(), nullable=True), 
46      sa.Column('ended_on', sa.Integer(), nullable=True), 
47      sa.Column('results', sa.Text(), nullable=True), 
48      sa.Column('status', sa.Integer(), nullable=True), 
49      sa.Column('memory_reqs', sa.Integer(), nullable=True), 
50      sa.Column('timeout', sa.Integer(), nullable=True), 
51      sa.Column('user_id', sa.Integer(), nullable=True), 
52      sa.Column('copr_id', sa.Integer(), nullable=True), 
53      sa.ForeignKeyConstraint(['copr_id'], ['copr.id'], ), 
54      sa.ForeignKeyConstraint(['user_id'], ['user.id'], ), 
55      sa.PrimaryKeyConstraint('id') 
56      ) 
57      op.create_table('copr_permission', 
58      sa.Column('copr_builder', sa.SmallInteger(), nullable=True), 
59      sa.Column('copr_admin', sa.SmallInteger(), nullable=True), 
60      sa.Column('user_id', sa.Integer(), nullable=False), 
61      sa.Column('copr_id', sa.Integer(), nullable=False), 
62      sa.ForeignKeyConstraint(['copr_id'], ['copr.id'], ), 
63      sa.ForeignKeyConstraint(['user_id'], ['user.id'], ), 
64      sa.PrimaryKeyConstraint('user_id', 'copr_id') 
65      ) 
66      ### end Alembic commands ### 
67   
68   
69 -def downgrade(): 
70      ### commands auto generated by Alembic - please adjust! ### 
71      op.drop_table('copr_permission') 
72      op.drop_table('build') 
73      op.drop_table('copr') 
74      op.drop_table('user') 
75      ### end Alembic commands ### 
76