41,13 → 41,28 |
userfield varchar(255) |
); |
|
create table telbook_export ( |
export_id serial primary key, |
export_name varchar(255) not null unique, |
export_comment text |
); |
|
create table telbook_categories ( |
category_id serial primary key, |
category_name varchar(255) not null unique, |
category_export_key integer, |
category_comment text |
); |
|
create table telbook_categories_export ( |
export_id integer, |
category_id integer, |
category_export_title varchar(255), |
|
primary key (export_id, category_id), |
foreign key (export_id) references telbook_export(export_id), |
foreign key (category_id) references telbook_categories(category_id) |
); |
|
create table telbook_persons ( |
person_id serial primary key, |
person_name varchar(255) not null unique, |
67,3 → 82,12 |
foreign key (entry_person) references telbook_persons(person_id) |
); |
|
create table telbook_entries_export ( |
export_id integer, |
entry_id integer, |
|
primary key (export_id, entry_id), |
foreign key (export_id) references telbook_export(export_id), |
foreign key (entry_id) references telbook_entries(entry_id) |
); |
|