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 |