Subversion Repositories general

Rev

Rev 19 | Rev 31 | Go to most recent revision | 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 
 
5 
create sequence hibernate_sequence;
6 
 
9 dev 7 
/* removed in this version
3 dev 8 
create table participants
9 
(
10 
	id          integer                         not null,
11 
	nick        varchar(255)                    not null,
12 
	email       varchar(255)                    not null,
13 
	name        varchar(255),
14 
	phone       varchar(255),
15 
	comment     text,
16 
	mod_stamp   timestamp,
17 
 
18 
	constraint participants_prim  primary key (id),
19 
	constraint participants_email unique(email)
20 
);
9 dev 21 
*/
3 dev 22 
 
10 dev 23 
create table acts
24 
(
25 
	id          integer                         not null,
26 
	name        varchar(255)                    not null,
27 
	comment     text,
28 
	mod_stamp   timestamp,
29 
 
30 
	constraint acts_prim primary key (id),
31 
	constraint acts_name unique(name)
32 
);
33 
 
34 
create table apartments
35 
(
36 
	id          integer                         not null,
37 
	name        varchar(255)                    not null,
38 
	address     text,
39 
	price       decimal,
40 
	url         varchar(4000),
41 
	comment     text,
42 
	mod_stamp   timestamp,
43 
 
44 
	constraint apartments_prim primary key (id)
45 
);
46 
 
3 dev 47 
create table events
48 
(
49 
	id              integer                     not null,
50 
	name            varchar(255)                not null,
19 dev 51 
	email           varchar(255)                not null,
52 
	admins          varchar(255)                not null,
3 dev 53 
	place           varchar(255),
54 
	address         text,
55 
	transport_desc  text,
56 
	start           date,
57 
	stop            date,
58 
	last_register   date,
59 
	last_unregister date,
60 
	price           decimal,
61 
	money_account   text,
62 
	enabled         char(1)                     default '1',
63 
	comment         text,
64 
	mod_stamp       timestamp,
65 
 
66 
	constraint events_prim primary key (id),
67 
	constraint events_name unique(name)
68 
);
69 
 
14 dev 70 
/*
3 dev 71 
create table event_files
72 
(
73 
	id          integer                         not null,
74 
	event       integer                         not null,
75 
	name        varchar(255)                    not null,
76 
	data        file,
77 
	type        char(1),
78 
	comment     text,
79 
	mod_stamp   timestamp,
80 
 
81 
	constraint event_files_prim primary key (id)
82 
);
14 dev 83 
*/
3 dev 84 
 
85 
create table event_apartments
86 
(
87 
	id          integer                         not null,
88 
	event       integer                         not null,
9 dev 89 
	apartment   integer                         not null,
3 dev 90 
	distance    decimal,
91 
	comment     text,
92 
	mod_stamp   timestamp,
93 
 
9 dev 94 
	constraint event_apartments_prim primary key (event, apartment)
3 dev 95 
);
96 
 
97 
create table event_acts
98 
(
99 
	id          integer                         not null,
100 
	event       integer                         not null,
101 
	act         integer                         not null,
102 
	comment     text,
103 
	mod_stamp   timestamp,
104 
 
105 
	constraint event_acts_prim primary key (event, act)
106 
);
107 
 
9 dev 108 
/* removed in this version
3 dev 109 
create table participant_events
110 
(
111 
	participant       integer                   not null,
112 
	event             integer                   not null,
113 
	persons           integer,
114 
	from_zip          varchar(10),
115 
	from_city         varchar(10),
116 
	departure         datetime,
117 
	free_transport    integer,
118 
	transport_comment integer,
119 
	free_sleep        integer,
120 
	sleep_comment     text,
9 dev 121 
	payed             char(1)                   default ' ',
3 dev 122 
	comment           text,
123 
	mod_stamp         timestamp,
124 
 
125 
	constraint participant_events_prim primary key (participant, event)
126 
);
9 dev 127 
*/
3 dev 128 
 
9 dev 129 
create table participants
130 
(
131 
	id                integer                   not null,
132 
	ident             varchar(255)              not null,
133 
	nick              varchar(255)              not null,
134 
	email             varchar(255)              not null,
135 
	email_public      char(1)                   default ' ',
136 
	name              varchar(255),
137 
	phone             varchar(255),
138 
	event             integer                   not null,
139 
	persons           integer,
140 
	from_zip          varchar(10),
141 
	from_city         varchar(10),
142 
	departure         timestamp,
143 
	free_transport    integer,
144 
	transport_comment text,
145 
	free_sleep        integer,
146 
	sleep_comment     text,
147 
	payed             char(1)                   default ' ',
148 
	comment           text,
149 
	private_comment   text,
150 
	mod_stamp         timestamp,
151 
 
152 
	constraint participants_prim  primary key (id),
153 
	constraint participants_email unique(email)
154 
);
155 
 
3 dev 156 
create table participant_acts
157 
(
27 dev 158 
    id                integer                   not null,
159 
	participant       integer                   not null,
160 
	act               integer                   not null,
161 
	comment           text,
162 
	mod_stamp         timestamp,
3 dev 163 
 
27 dev 164 
	constraint participant_acts_prim primary key (participant, act)
3 dev 165 
);