| 10,9 → 10,12 |
|---|
| -- one and only one entry is allowed |
| create table dbversion |
| ( |
| version integer not null |
| major integer not null, -- incremented if old structure is now useable with new code and upgrade needed |
| -- e.g. new tables, fields, new field type etc. minor is reset to 0 |
| minor integer not null -- incremented if some additional things changes and upgrade recomended but not |
| -- not needed, e.g. indexes |
| ); |
| insert into dbversion (version) values (1); |
| insert into dbversion (major, minor) values (2, 0); |
| |
| -- passwords for different objects and crypted by different digests |
| create table passwords |