Skip to content

Instantly share code, notes, and snippets.

@sarutobi

sarutobi/gist:3847796

Created October 7, 2012 10:28
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save sarutobi/3847796 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save sarutobi/3847796 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. sarutobi revised this gist Oct 7, 2012. 1 changed file with 21 additions and 21 deletions.
    42 changes: 21 additions & 21 deletions gistfile1.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -8,39 +8,39 @@ create table request (
    id integer not null auto_increment,
    code varchar(50) not null,
    description varchar(255) not null,
    primary key(id)
    institution integer not null,
    primary key(id),
    foreign key(institution) references institution(id) on delete restrict
    ) default character set=utf8;

    create table issue(
    id integer not null auto_increment,
    name varchar(50) not null,
    description varchar(255),
    primary key (id)
    id integer not null auto_increment,
    name varchar(50) not null,
    description varchar(255),
    primary key (id)
    ) default character set=utf8;

    create table institution (
    id integer not null auto_increment,
    name varchar(50) not null,
    description varchar(255),
    primary key(id)
    id integer not null auto_increment,
    name varchar(50) not null,
    description varchar(255),
    primary key(id)

    ) default character set utf8;

    create table documents_meta (
    id integer not null auto_increment,
    sender_number varchar(50) not null,
    sender_date date not null,
    own_number varchar(50) not null,
    own_date date not null,
    filename varchar(255) not null,
    institution integer not null,
    primary key(id),
    foreign key(institution) references institution(id) on delete restrict
    id integer not null auto_increment,
    request_date date not null,
    replay_date date not null,
    filename varchar(255) not null,
    request_id integer not null,
    primary key(id),
    foreign key (request_id) references request(id) on delete restrict
    ) default character set utf8;

    create table doc_issue(
    id_document integer not null,
    create table req_issue(
    id_request integer not null,
    id_issue integer not null,
    foreign key (id_document) references documents_meta(id) on delete restrict,
    foreign key (id_request) references request(id) on delete restrict,
    foreign key (id_issue) references issue(id) on delete restrict
    );
  2. sarutobi created this gist Oct 7, 2012.
    46 changes: 46 additions & 0 deletions gistfile1.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,46 @@
    create table city(
    id integer not null auto_increment,
    name character varying(50) not null,
    primary key (id)
    ) default character set utf8;

    create table request (
    id integer not null auto_increment,
    code varchar(50) not null,
    description varchar(255) not null,
    primary key(id)
    ) default character set=utf8;

    create table issue(
    id integer not null auto_increment,
    name varchar(50) not null,
    description varchar(255),
    primary key (id)
    ) default character set=utf8;

    create table institution (
    id integer not null auto_increment,
    name varchar(50) not null,
    description varchar(255),
    primary key(id)

    ) default character set utf8;

    create table documents_meta (
    id integer not null auto_increment,
    sender_number varchar(50) not null,
    sender_date date not null,
    own_number varchar(50) not null,
    own_date date not null,
    filename varchar(255) not null,
    institution integer not null,
    primary key(id),
    foreign key(institution) references institution(id) on delete restrict
    ) default character set utf8;

    create table doc_issue(
    id_document integer not null,
    id_issue integer not null,
    foreign key (id_document) references documents_meta(id) on delete restrict,
    foreign key (id_issue) references issue(id) on delete restrict
    );