--
-- ### Counter checks
-- 
-- and basic table creation / retrieval
--

drop if exists table fico_account;
drop if exists counter accid;

create table fico_account ( primary aid int not null, accountname string(20));
create counter accid;
insert into fico_account values ( nextcount(accid), 'MyAccount');
insert into fico_account values ( nextcount(accid), 'YourAccount');
set counter accid to 1000;
insert into fico_account values ( nextcount(accid), 'XAccount');
insert into fico_account values ( nextcount(accid), 'YAccount');

set b = nextcount(accid);

insert into fico_account values ( setcount(accid, 10000), 'MoreAccount');

insert into fico_account values ( nextcount(accid), 'LastAccount');
select * from fico_account;
