[dbsrgits/SQL-Translator-2.0-ish.git] / t / data / sqlite / create.sql

create table person (
  person_id INTEGER PRIMARY KEY AUTOINCREMENT,
  'name' varchar(20) not null,
  'age' integer,
  weight double(11,2),
  iq tinyint default '0',
  description text
);

create unique index u_name on person (name);

create table pet (
  "pet_id" int,
  "person_id" int references person (person_id),
  "name" varchar(30),
  "age" int,
  check ( age < 100 ),
  primary key (pet_id, person_id)
);

create trigger pet_trig after insert on pet 
  begin
    update pet set name=name;
  end
;

create view person_pet as
  select pr.person_id, pr.name as person_name, pt.name as pet_name
  from   person pr, pet pt
  where  person.person_id=pet.pet_id
;
Commit	Line	Data
6019cb1c	1	create table person (
	2	person_id INTEGER PRIMARY KEY AUTOINCREMENT,
	3	'name' varchar(20) not null,
	4	'age' integer,
	5	weight double(11,2),
	6	iq tinyint default '0',
	7	description text
	8	);
	9
	10	create unique index u_name on person (name);
	11
	12	create table pet (
	13	"pet_id" int,
	14	"person_id" int references person (person_id),
	15	"name" varchar(30),
	16	"age" int,
	17	check ( age < 100 ),
	18	primary key (pet_id, person_id)
	19	);
	20
	21	create trigger pet_trig after insert on pet
	22	begin
	23	update pet set name=name;
	24	end
	25	;
	26
	27	create view person_pet as
	28	select pr.person_id, pr.name as person_name, pt.name as pet_name
	29	from person pr, pet pt
	30	where person.person_id=pet.pet_id
	31	;