22 lines
796 B
Plaintext
22 lines
796 B
Plaintext
Co musi być:
|
|
1)id ksiazki
|
|
2)tytul ksiazki
|
|
3)autor ksiazki
|
|
4)wlasciciel ksiazki
|
|
5)czy ksiazka jest?
|
|
6)kto wzial ksiazke?
|
|
7)czy mozna ksiazke brac?
|
|
8)czy ksiazka jest zarezerwowana?
|
|
9)komentarz
|
|
|
|
create table ksiazki (id integer primary key autoincrement not null unique,isbn int, title string,
|
|
author string,owner string,state bool,who string,can_borrow bool,reserved bool,comment string);
|
|
|
|
create table ksiazki (id int,isbn int, title string,
|
|
author string,owner string,state bool,who string,can_borrow bool,reserved bool,comment string);
|
|
|
|
|
|
insert into ksiazki values (null,1,'tytul1','autor1','wlasciciel1',1,'nikt',1,0,'');
|
|
insert into ksiazki values (null,2,'tytul2','autor2','wlasciciel2',1,'nikt',1,0,'');
|
|
insert into ksiazki values (null,3,'tytul3','autor3','wlasciciel3',1,'nikt',1,0,'');
|