| 44,6 → 44,7 |
|---|
| create table telbook_export ( |
| export_id serial primary key, |
| export_name varchar(255) not null unique, |
| export_type integer, |
| export_comment text |
| ); |
| |
| 72,6 → 73,16 |
|---|
| foreign key (person_category) references telbook_categories(category_id) |
| ); |
| |
| create table telbook_persons_export ( |
| export_id integer, |
| person_id integer, |
| person_export_title varchar(255), |
| |
| primary key (export_id, person_id), |
| foreign key (export_id) references telbook_export(export_id), |
| foreign key (person_id) references telbook_persons(person_id) |
| ); |
| |
| create table telbook_entries ( |
| entry_id serial primary key, |
| entry_value varchar(255) not null unique, |