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
10 revision = "595a31c145fb"
11 down_revision = None
12
13 from alembic import op
14 import sqlalchemy as sa
15
16
18
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
69
70
72
73 op.drop_table("copr_permission")
74 op.drop_table("build")
75 op.drop_table("copr")
76 op.drop_table("user")
77
78