20,6 → 20,30 |
); |
*/ |
|
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 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 events |
( |
id integer not null, |
54,19 → 78,6 |
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, |
79,17 → 90,6 |
constraint event_apartments_prim primary key (event, apartment) |
); |
|
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, |