72feqE2E

1CREATE TABLE IF NOT EXISTS leduc_genre
2                            (
3                                id SERIAL PRIMARY KEY,
4                                description VARCHAR(250) not null,
5                                modified timestamptz DEFAULT CURRENT_TIMESTAMP,
6                                createdon timestamptz DEFAULT CURRENT_TIMESTAMP
7                            )
8
9CREATE TABLE IF NOT EXISTS leduc_include
10                            (
11                                id SERIAL PRIMARY KEY,
12                                description VARCHAR(250) not null,
13                                modified timestamptz DEFAULT CURRENT_TIMESTAMP,
14                                createdon timestamptz DEFAULT CURRENT_TIMESTAMP
15                            )
16
17CREATE TABLE IF NOT EXISTS leduc_age
18                            (
19                                id SERIAL PRIMARY KEY,
20                                description VARCHAR(250) not null,
21                                modified timestamptz DEFAULT CURRENT_TIMESTAMP,
22                                createdon timestamptz DEFAULT CURRENT_TIMESTAMP
23                            )
24
25CREATE TABLE IF NOT EXISTS leduc_attendance_type
26                            (
27                                id SERIAL PRIMARY KEY,
28                                parent_id INT,
29                                description VARCHAR(250),
30                                modified timestamptz DEFAULT CURRENT_TIMESTAMP,
31                                createdon timestamptz DEFAULT CURRENT_TIMESTAMP
32                            )
33
34CREATE TABLE IF NOT EXISTS leduc_event
35                            (
36                                id SERIAL PRIMARY KEY,
37                                userid INT REFERENCES leduc_user (id),
38                                title VARCHAR(250) not null,
39                                address VARCHAR(250) not null,
40                                fromdatetime timestamptz not null,
41                                todatetime timestamptznot null,
42                                price decimal not null,
43                                ageid INT REFERENCES leduc_age (id),
44                                attendance_type_id INT REFERENCES leduc_attendance_type (id),
45                                description VARCHAR(250),
46                                poster_image_url VARCHAR(500),
47                                email VARCHAR(250),
48                                phone VARCHAR(250),
49                                activated SMALLINT DEFAULT 1,
50                                modified timestamptz DEFAULT CURRENT_TIMESTAMP,
51                                createdon timestamptz DEFAULT CURRENT_TIMESTAMP
52                            )
53
54CREATE TABLE IF NOT EXISTS leduc_event_genre
55                            (
56                                id SERIAL PRIMARY KEY,
57                                eventid INT REFERENCES leduc_event (id),
58                                genreid INT REFERENCES leduc_genre (id),
59                                modified timestamptz DEFAULT CURRENT_TIMESTAMP,
60                                createdon timestamptz DEFAULT CURRENT_TIMESTAMP
61                            )
62
63CREATE TABLE IF NOT EXISTS leduc_event_include
64                            (
65                                id SERIAL PRIMARY KEY,
66                                eventid INT REFERENCES leduc_event (id),
67                                includeid INT REFERENCES leduc_include (id),
68                                modified timestamptz DEFAULT CURRENT_TIMESTAMP,
69                                createdon timestamptz DEFAULT CURRENT_TIMESTAMP
70                            )