diff options
Diffstat (limited to 'bin/schemat_bazy')
| -rw-r--r-- | bin/schemat_bazy | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/bin/schemat_bazy b/bin/schemat_bazy new file mode 100644 index 0000000..d2a9d48 --- /dev/null +++ b/bin/schemat_bazy @@ -0,0 +1,21 @@ +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,''); |