create table farmers
	   (
	    farmer_id int not null,
	    name varchar (30) not null,
	    farm_id int not null,
	    );

create table farms
       (farm_id int not null,
	farm_name varchar (30) not null,
	size int not null,
	cows int,
	chickens int,
	est date
       );
	
# next id number for a table
create table id(
        tableName varchar(30) not null,
        nextID int            not null
        );


insert into farmers values
	( 0,'John Doe',0);

insert into farmers values
	( 1,'Jane Doe',0);

insert into farmers values
	( 2,'Steve Black',1);

insert into farms values
	(0,'Doebrook',375,3,15,'1893-01-01');

insert into farms values
	(1,'Emmerdale',1002,10,106,'1725-03-06');

insert into id values('farmers', 3);
insert into id values('farms', 2);