BlueGreycalmElegant

Català-Valencià – Catalan中文 – Chinese (Simplified)中文 – Chinese (Traditional)Česky – CzechDansk – DanishNederlands – DutchEnglish – EnglishSuomi – FinnishFrançais – FrenchDeutsch – Germanעברית – Hebrewहिंदी – HindiMagyar – HungarianBahasa Indonesia – IndonesianItaliano – Italian日本語 – Japanese한국어 – KoreanМакедонски – Macedonianमराठी – MarathiNorsk – NorwegianPolski – PolishPortuguês – PortuguesePortuguês – Portuguese (Brazil)Русский – RussianSlovenčina – SlovakSlovenščina – SlovenianEspañol – SpanishSvenska – SwedishTürkçe – TurkishУкраїнська – UkrainianOëzbekcha – Uzbek

Compare Revisions

• This comparison shows the changes necessary to convert path

  → /hostadmiral/trunk/sql @ 1016

  → /hostadmiral/trunk/sql @ 1029

  ↔ Reverse comparison

• Compare Path:	Rev

  With Path:	Rev

Ignore whitespace Rev 1016 → Rev 1029

/hostadmiral/trunk/sql/update/0001_0000-to-0002_0000.sql
0,0 → 1,15
--
-- HostAdmiral
-- update DB structure from 1 to 2.0
--
-- dbversion changed
drop table dbversion;
create table dbversion
(
major integer not null,
minor integer not null
);
insert into dbversion (major, minor) values (2, 0);

/hostadmiral/trunk/sql/00.tables.sql
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