| 0,0 → 1,129 |
|---|
| -- |
| -- it-ru sql tables |
| -- |
| |
| create sequence hibernate_sequence; |
| |
| create table participants |
| ( |
| id integer not null, |
| nick varchar(255) not null, |
| email varchar(255) not null, |
| name varchar(255), |
| phone varchar(255), |
| comment text, |
| mod_stamp timestamp, |
| |
| constraint participants_prim primary key (id), |
| constraint participants_email unique(email) |
| ); |
| |
| create table events |
| ( |
| id integer not null, |
| name varchar(255) not null, |
| place varchar(255), |
| address text, |
| transport_desc text, |
| start date, |
| stop date, |
| last_register date, |
| last_unregister date, |
| price decimal, |
| money_account text, |
| enabled char(1) default '1', |
| comment text, |
| mod_stamp timestamp, |
| |
| constraint events_prim primary key (id), |
| constraint events_name unique(name) |
| ); |
| |
| create table event_files |
| ( |
| id integer not null, |
| event integer not null, |
| name varchar(255) not null, |
| data file, |
| type char(1), |
| comment text, |
| mod_stamp timestamp, |
| |
| constraint event_files_prim primary key (id) |
| ); |
| |
| create table apartments |
| ( |
| id integer not null, |
| name varchar(255) not null, |
| address text, |
| price decimal, |
| url varchar(4000), |
| comment text, |
| mod_stamp timestamp, |
| |
| constraint apartments_prim primary key (id) |
| ); |
| |
| create table event_apartments |
| ( |
| id integer not null, |
| event integer not null, |
| apartments integer not null, |
| distance decimal, |
| comment text, |
| mod_stamp timestamp, |
| |
| constraint event_apartments_prim primary key (event, apartments) |
| ); |
| |
| create table acts |
| ( |
| id integer not null, |
| name varchar(255) not null, |
| comment text, |
| mod_stamp timestamp, |
| |
| constraint acts_prim primary key (id), |
| constraint acts_name unique(name) |
| ); |
| |
| create table event_acts |
| ( |
| id integer not null, |
| event integer not null, |
| act integer not null, |
| comment text, |
| mod_stamp timestamp, |
| |
| constraint event_acts_prim primary key (event, act) |
| ); |
| |
| create table participant_events |
| ( |
| participant integer not null, |
| event integer not null, |
| persons integer, |
| from_zip varchar(10), |
| from_city varchar(10), |
| departure datetime, |
| free_transport integer, |
| transport_comment integer, |
| free_sleep integer, |
| sleep_comment text, |
| comment text, |
| mod_stamp timestamp, |
| |
| constraint participant_events_prim primary key (participant, event) |
| ); |
| |
| create table participant_acts |
| ( |
| participant integer not null, |
| event integer not null, |
| act integer not null, |
| comment text, |
| mod_stamp timestamp, |
| |
| constraint participant_acts_prim primary key (participant, event, act) |
| ); |