Rev 1086 | Details | Compare with Previous | Last modification | View Log | RSS feed
Rev | Author | Line No. | Line |
---|---|---|---|
3 | dev | 1 | -- |
11 | dev | 2 | -- kickup sql tables |
3 | dev | 3 | -- |
4 | |||
1086 | dev | 5 | create sequence hibernate_sequence; |
6 | |||
7 | create table acts |
||
8 | ( |
||
9 | id integer not null, |
||
10 | name varchar(255) not null, |
||
10 | dev | 11 | comment text, |
1086 | dev | 12 | mod_stamp timestamp, |
13 | |||
14 | constraint acts_prim primary key (id), |
||
15 | constraint acts_name unique(name) |
||
16 | ); |
||
17 | |||
18 | create table apartments |
||
19 | ( |
||
20 | id integer not null, |
||
21 | name varchar(255) not null, |
||
22 | address text, |
||
23 | price decimal, |
||
24 | url varchar(4000), |
||
10 | dev | 25 | comment text, |
1086 | dev | 26 | mod_stamp timestamp, |
27 | |||
28 | constraint apartments_prim primary key (id), |
||
29 | constraint apartments_name unique(name) |
||
30 | ); |
||
31 | |||
32 | create table events |
||
33 | ( |
||
34 | id integer not null, |
||
35 | name varchar(255) not null, |
||
36 | email varchar(255) not null, |
||
37 | admins varchar(255) not null, |
||
38 | phones varchar(255), |
||
39 | place varchar(255), |
||
40 | address text, |
||
41 | transport_desc text, |
||
42 | estart date, |
||
43 | estop date, |
||
44 | last_register date, |
||
45 | last_unregister date, |
||
46 | price decimal, |
||
47 | money_account text, |
||
48 | enabled char(1) default '1', |
||
3 | dev | 49 | comment text, |
1086 | dev | 50 | mod_stamp timestamp, |
51 | |||
52 | constraint events_prim primary key (id), |
||
53 | constraint events_name unique(name) |
||
54 | ); |
||
55 | |||
56 | create table event_apartments |
||
57 | ( |
||
58 | id integer not null, |
||
59 | event integer not null, |
||
60 | apartment integer not null, |
||
61 | distance decimal, |
||
3 | dev | 62 | comment text, |
1086 | dev | 63 | mod_stamp timestamp, |
64 | |||
65 | constraint event_apartments_prim primary key (id), |
||
66 | constraint event_apartments_event foreign key (event) references events(id), |
||
67 | constraint event_apartments_apartment foreign key (apartment) references apartments(id) |
||
68 | ); |
||
69 | |||
70 | create table event_acts |
||
71 | ( |
||
72 | id integer not null, |
||
73 | event integer not null, |
||
74 | act integer not null, |
||
3 | dev | 75 | comment text, |
1086 | dev | 76 | mod_stamp timestamp, |
77 | |||
78 | constraint event_acts_prim primary key (id), |
||
79 | constraint event_acts_event foreign key (event) references events(id), |
||
80 | constraint event_acts_act foreign key (act) references acts(id) |
||
81 | ); |
||
82 | |||
83 | create table participants |
||
84 | ( |
||
85 | id integer not null, |
||
86 | ident varchar(255) not null, |
||
87 | nick varchar(255) not null, |
||
88 | email varchar(255) not null, |
||
89 | email_public char(1) default ' ', |
||
90 | name varchar(255), |
||
91 | phone varchar(255), |
||
92 | event integer not null, |
||
93 | persons integer not null, |
||
94 | from_zip varchar(10), |
||
95 | from_city varchar(100), |
||
96 | departure timestamp, |
||
97 | free_transport integer, |
||
98 | transport_comment text, |
||
99 | free_sleep integer, |
||
100 | sleep_comment text, |
||
101 | payed decimal, |
||
1428 | dev | 102 | comment text, -- editeable by participant and visible for anybody |
103 | protected_comment text, -- editeable by participant and visible for admins only |
||
104 | private_comment text, -- editeable by admin and visible for admins only |
||
1086 | dev | 105 | mod_stamp timestamp, |
106 | |||
107 | constraint participants_prim primary key (id), |
||
108 | constraint participants_email unique(email, event) |
||
109 | ); |
||
110 | |||
111 | create table participant_acts |
||
112 | ( |
||
113 | id integer not null, |
||
114 | participant integer not null, |
||
115 | act integer not null, |
||
27 | dev | 116 | comment text, |
1086 | dev | 117 | mod_stamp timestamp, |
118 | |||
119 | constraint participant_acts_prim primary key (id), |
||
120 | constraint participant_acts_participant foreign key (participant) references participants(id), |
||
121 | constraint participant_acts_act foreign key (act) references acts(id) |
||
122 | ); |
||
123 |