Subversion Repositories general

Rev

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