File: named.sql

package info (click to toggle)
libsql-translator-perl 0.11020-1
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 4,544 kB
  • ctags: 2,126
  • sloc: perl: 67,105; sql: 3,809; xml: 233; makefile: 7
file content (13 lines) | stat: -rw-r--r-- 507 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
create table pet (
  "pet_id" int,
  "person_id" int
    constraint fk_person_id references person(person_id) on update CASCADE on delete RESTRICT,
  "person_id_2" int
    constraint fk_person_id_2 references person(person_id) on update SET NULL on delete SET DEFAULT,
  "person_id_3" int
    constraint fk_person_id_3 references person(person_id) on update NO ACTION,
  "name" varchar(30),
  "age" int,
  constraint age_under_100 check ( age < 100 ),
  constraint pk_pet primary key (pet_id, person_id)
);