Subversion Repositories general

Compare Revisions

Ignore whitespace Rev 1392 → Rev 1393

/asterisk-stats/trunk/tables.sql
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)
);