--- /dev/null
+alter table role_x_rights drop constraint fk_right_role;
+alter table role_x_rights drop constraint fk_role_right;
+alter table category drop constraint fk_category_categorytype;
+alter table category drop constraint fk_category_parentcategory;
+alter table category drop constraint fk_topic_childcategories;
+alter table media drop constraint fk_media_user;
+alter table media_x_media drop constraint fk_mediaxmedia_sourcemedia;
+alter table media_x_media drop constraint fk_mediaxmedia_relatedmedia;
+alter table media_x_media drop constraint fk_mediaxmedia_mediarelationtype;
+alter table uploaded_media drop constraint fk_uploadedmedia_mediafolder;
+alter table uploaded_media drop constraint fk_uploadedmedia_mediatype;
+alter table uploaded_media drop constraint fk_uploadedmedia_media;
+alter table article drop constraint fk_article_language;
+alter table article drop constraint fk_article_articlestatus;
+alter table article drop constraint fk_article_media;
+alter table article drop constraint fk_article_lockinguser;
+alter table article_x_category drop constraint fk_article_category_2;
+alter table article_x_category drop constraint fk_articlexcategory_category;
+alter table article_x_category drop constraint fk_article_category;
+alter table article_x_category drop constraint fk_category_article;
+alter table article_x_category drop constraint fk_articlexcategory_article_type;
+alter table article_x_category drop constraint fk_articlexcategory;
+alter table users drop constraint fk_user_role;
+alter table users drop constraint fk_role_user;
+drop table role_x_rights;
+drop table category_type;
+drop table media_type;
+drop table rights;
+drop table category;
+drop table media;
+drop table roles;
+drop table article_type;
+drop table media_x_media;
+drop table language;
+drop table uploaded_media;
+drop table article;
+drop table media_relation_type;
+drop table article_x_category;
+drop table breaking_news_items;
+drop table comment_status;
+drop table users;
+drop table media_folder;
+drop table messages;
+drop sequence language_id_seq;
+drop sequence users_id_seq;
+drop sequence media_relation_type_id_seq;
+drop sequence category_type_id_seq;
+drop sequence breaking_id_seq;
+drop sequence media_type_id_seq;
+drop sequence article_type_id_seq;
+drop sequence right_id_seq;
+drop sequence comment_status_id_seq;
+drop sequence media_folder_id_seq;
+drop sequence media_id_seq;
+drop sequence category_id_seq;
+drop sequence role_id_seq;
+create table role_x_rights (
+ role_id int4 not null,
+ right_id int4 not null,
+ primary key (role_id, right_id)
+);
+create table category_type (
+ id int4 not null,
+ name varchar(40) not null,
+ primary key (id)
+);
+create table media_type (
+ id int4 not null,
+ name varchar(80) not null,
+ mime_type varchar(40) not null,
+ classname varchar(80) not null,
+ tablename varchar(80) not null,
+ dcname varchar(20),
+ primary key (id)
+);
+create table rights (
+ id int4 not null,
+ name varchar(80) not null,
+ description varchar(255),
+ primary key (id)
+);
+create table category (
+ id int4 not null,
+ title varchar(80) not null,
+ description varchar(255),
+ filename varchar(20) not null,
+ category_type int4,
+ parent_id int4,
+ primary key (id)
+);
+create table media (
+ id int4 not null,
+ title varchar(255),
+ description text,
+ creator varchar(80),
+ creator_main_url varchar(255),
+ creator_email varchar(80),
+ creator_address varchar(80),
+ creator_phone varchar(80),
+ internal_comment varchar(255),
+ is_produced bool not null,
+ creation_date timestamp not null,
+ last_change timestamp,
+ to_publisher int4,
+ primary key (id)
+);
+create table roles (
+ id int4 not null,
+ name varchar(16) not null unique,
+ description varchar(255) not null,
+ primary key (id)
+);
+create table article_type (
+ id int4 not null,
+ name varchar(40) not null,
+ primary key (id)
+);
+create table media_x_media (
+ source_media_id int4 not null,
+ media_relation_type_id int4 not null,
+ related_media_id int4 not null,
+ primary key (source_media_id, related_media_id)
+);
+create table language (
+ id int4 not null,
+ name varchar(40) not null,
+ code varchar(2) not null,
+ primary key (id)
+);
+create table uploaded_media (
+ media_id int4 not null,
+ publish_server varchar(255),
+ publish_path varchar(255),
+ storage_path varchar(255),
+ icon_produced bool not null,
+ icon_path varchar(255),
+ size int4,
+ to_media_folder int4,
+ to_media_type int4,
+ primary key (media_id)
+);
+create table article (
+ media_id int4 not null,
+ date varchar(8) not null,
+ subtitle varchar(255),
+ edittitle varchar(255),
+ content text not null,
+ is_html bool not null,
+ to_article_status int4,
+ to_locking_user int4,
+ to_language int4,
+ primary key (media_id)
+);
+create table media_relation_type (
+ id int4 not null,
+ name varchar(255),
+ primary key (id)
+);
+create table article_x_category (
+ article_type_id int4 not null,
+ category_id int4 not null,
+ article_id int4 not null,
+ primary key (category_id, article_id)
+);
+create table breaking_news_items (
+ id int4 not null,
+ text varchar(255) not null,
+ creationDate timestamp not null,
+ primary key (id)
+);
+create table comment_status (
+ id int4 not null,
+ name varchar(40) not null,
+ primary key (id)
+);
+create table users (
+ id int4 not null,
+ login varchar(16) not null unique,
+ password varchar(255) not null,
+ internal_comment varchar(255),
+ is_disabled bool not null,
+ email varchar(255) not null,
+ profile varchar(255),
+ creationDate timestamp not null,
+ lastlogin timestamp,
+ to_role int4,
+ primary key (id)
+);
+create table media_folder (
+ id int4 not null,
+ name varchar(255) not null,
+ date varchar(8) not null,
+ place varchar(80),
+ keywords varchar(255),
+ internal_comment varchar(255),
+ creationDate timestamp not null,
+ last_change timestamp,
+ primary key (id)
+);
+create table messages (
+ id int4 not null,
+ title varchar(30),
+ description varchar(255) not null,
+ creator varchar(30) not null,
+ creation_date timestamp not null,
+ primary key (id)
+);
+alter table role_x_rights add constraint fk_right_role foreign key (right_id) references rights;
+alter table role_x_rights add constraint fk_role_right foreign key (role_id) references roles;
+alter table category add constraint fk_category_categorytype foreign key (category_type) references category_type;
+alter table category add constraint fk_category_parentcategory foreign key (parent_id) references category;
+alter table category add constraint fk_topic_childcategories foreign key (parent_id) references category;
+alter table media add constraint fk_media_user foreign key (to_publisher) references users;
+alter table media_x_media add constraint fk_mediaxmedia_sourcemedia foreign key (source_media_id) references media;
+alter table media_x_media add constraint fk_mediaxmedia_relatedmedia foreign key (related_media_id) references media;
+alter table media_x_media add constraint fk_mediaxmedia_mediarelationtype foreign key (media_relation_type_id) references media_relation_type;
+alter table uploaded_media add constraint fk_uploadedmedia_mediafolder foreign key (to_media_folder) references media_folder;
+alter table uploaded_media add constraint fk_uploadedmedia_mediatype foreign key (to_media_type) references media_type;
+alter table uploaded_media add constraint fk_uploadedmedia_media foreign key (media_id) references media;
+alter table article add constraint fk_article_language foreign key (to_language) references language;
+alter table article add constraint fk_article_articlestatus foreign key (to_article_status) references comment_status;
+alter table article add constraint fk_article_media foreign key (media_id) references media;
+alter table article add constraint fk_article_lockinguser foreign key (to_locking_user) references users;
+alter table article_x_category add constraint fk_article_category_2 foreign key (article_id) references article;
+alter table article_x_category add constraint fk_articlexcategory_category foreign key (category_id) references category;
+alter table article_x_category add constraint fk_article_category foreign key (article_id) references article;
+alter table article_x_category add constraint fk_category_article foreign key (category_id) references category;
+alter table article_x_category add constraint fk_articlexcategory_article_type foreign key (article_type_id) references article_type;
+alter table article_x_category add constraint fk_articlexcategory foreign key (article_type_id, category_id) references article_x_category;
+alter table users add constraint fk_user_role foreign key (to_role) references roles;
+alter table users add constraint fk_role_user foreign key (to_role) references roles;
+create sequence language_id_seq;
+create sequence users_id_seq;
+create sequence media_relation_type_id_seq;
+create sequence category_type_id_seq;
+create sequence breaking_id_seq;
+create sequence media_type_id_seq;
+create sequence article_type_id_seq;
+create sequence right_id_seq;
+create sequence comment_status_id_seq;
+create sequence media_folder_id_seq;
+create sequence media_id_seq;
+create sequence category_id_seq;
+create sequence role_id_seq;
projects / mir.git / blobdiff