[dbsrgits/SQL-Translator.git] / t / data / sqlite / named.sql

create table pet (
  "pet_id" int,
  "person_id" int
    constraint fk_person_id references person(person_id) on update CASCADE on delete RESTRICT,
  "name" varchar(30),
  "age" int,
  constraint age_under_100 check ( age < 100 ),
  constraint pk_pet primary key (pet_id, person_id)
);
Commit	Line	Data
eaaa8f8a	1	create table pet (
	2	"pet_id" int,
	3	"person_id" int
ea4a3ecc	4	constraint fk_person_id references person(person_id) on update CASCADE on delete RESTRICT,
eaaa8f8a	5	"name" varchar(30),
	6	"age" int,
	7	constraint age_under_100 check ( age < 100 ),
	8	constraint pk_pet primary key (pet_id, person_id)
	9	);