---------------------------------------------------------------------------------------------
-- tabelle konto
---------------------------------------------------------------------------------------------
drop table konto;
create table konto (
    kid integer not null primary key,
    betrag integer not null
);

delete from konto;
insert into konto values (100, 0);
insert into konto values (200, 0);
select * from konto order by kid;

---------------------------------------------------------------------------------------------
-- tabelle personal
---------------------------------------------------------------------------------------------
drop table personal;
create table personal (
    pid integer not null primary key,
    gehalt integer not null
);

delete from personal;
insert into personal values (100, 0);
insert into personal values (200, 0);
select * from personal order by pid;

---------------------------------------------------------------------------------------------
-- tabelle kv
---------------------------------------------------------------------------------------------
drop table kv;
create table kv(k integer primary key, v varchar(10));

delete from kv;
insert into kv values(10, '10-a');
insert into kv values(20, '20-a');
select * from kv order by k;