Subversion Repositories general

Compare Revisions

Ignore whitespace Rev 9 → Rev 10

/it-ru/trunk/sql/00.tables.sql
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,