Script 595a31c145fb_initial_db_setup_py
[hide private]
[frames] | no frames]

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( 22 "openid_name", sa.String(length=100), nullable=False), 23 sa.Column("mail", sa.String(length=150), nullable=False), 24 sa.Column("proven", sa.Boolean(), nullable=True), 25 sa.Column("admin", sa.Boolean(), nullable=True), 26 sa.PrimaryKeyConstraint("id") 27 ) 28 op.create_table("copr", 29 sa.Column("id", sa.Integer(), nullable=False), 30 sa.Column("name", sa.String(length=100), nullable=False), 31 sa.Column("chroots", sa.Text(), nullable=False), 32 sa.Column("repos", sa.Text(), nullable=True), 33 sa.Column("created_on", sa.Integer(), nullable=True), 34 sa.Column("build_count", sa.Integer(), nullable=True), 35 sa.Column("owner_id", sa.Integer(), nullable=True), 36 sa.ForeignKeyConstraint(["owner_id"], ["user.id"], ), 37 sa.PrimaryKeyConstraint("id") 38 ) 39 op.create_table("build", 40 sa.Column("id", sa.Integer(), nullable=False), 41 sa.Column("pkgs", sa.Text(), nullable=True), 42 sa.Column("canceled", sa.Boolean(), nullable=True), 43 sa.Column("chroots", sa.Text(), nullable=False), 44 sa.Column("repos", sa.Text(), nullable=True), 45 sa.Column("submitted_on", sa.Integer(), nullable=False), 46 sa.Column("started_on", sa.Integer(), nullable=True), 47 sa.Column("ended_on", sa.Integer(), nullable=True), 48 sa.Column("results", sa.Text(), nullable=True), 49 sa.Column("status", sa.Integer(), nullable=True), 50 sa.Column("memory_reqs", sa.Integer(), nullable=True), 51 sa.Column("timeout", sa.Integer(), nullable=True), 52 sa.Column("user_id", sa.Integer(), nullable=True), 53 sa.Column("copr_id", sa.Integer(), nullable=True), 54 sa.ForeignKeyConstraint(["copr_id"], ["copr.id"], ), 55 sa.ForeignKeyConstraint(["user_id"], ["user.id"], ), 56 sa.PrimaryKeyConstraint("id") 57 ) 58 op.create_table("copr_permission", 59 sa.Column( 60 "copr_builder", sa.SmallInteger(), nullable=True), 61 sa.Column("copr_admin", sa.SmallInteger(), nullable=True), 62 sa.Column("user_id", sa.Integer(), nullable=False), 63 sa.Column("copr_id", sa.Integer(), nullable=False), 64 sa.ForeignKeyConstraint(["copr_id"], ["copr.id"], ), 65 sa.ForeignKeyConstraint(["user_id"], ["user.id"], ), 66 sa.PrimaryKeyConstraint("user_id", "copr_id") 67 )
68 ### end Alembic commands ### 69 70
71 -def downgrade():
72 ### commands auto generated by Alembic - please adjust! ### 73 op.drop_table("copr_permission") 74 op.drop_table("build") 75 op.drop_table("copr") 76 op.drop_table("user")
77 ### end Alembic commands ### 78