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

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

create unique index u_name on person (name);

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

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