| Pending Changes | |||
| changelogs/mysql/complete/included.changelog.xml | 3 | nvoxland | NOT YET RAN [SQL] |
| New row inserted into news | |||
| changelogs/common/common.tests.changelog.xml | contextstest-2 | nvoxland | NOT YET RAN [SQL] |
| New row inserted into contextsTest | |||
| changelogs/mysql/complete/root.changelog.xml | 54 | nvoxland | NOT YET RAN [SQL] |
| Column newcol(varchar(255)) added to address | |||
| changelogs/mysql/complete/root.changelog.xml | 55 | nvoxland | NOT YET RAN [SQL] |
| Column newcol2(varchar(255)) added to address | |||
| Past Changes | |||
| changelogs/mysql/complete/root.changelog.xml | 1 | nvoxland | Executed 11/15/07 9:37 AM |
| You can add comments to changeSets. They can even be multiple lines if you would like. They aren't used to compute the changeSet MD5Sum, so you can update them whenever you want without causing problems. | |||
| Table person created | |||
| changelogs/mysql/complete/root.changelog.xml | 2 | nvoxland | Executed 11/15/07 9:37 AM |
| Add a username column so we can use "person" for authentication | |||
| Column usernae(varchar(8)) added to person | |||
| changelogs/mysql/complete/root.changelog.xml | 3 | nvoxland | Executed 11/15/07 9:37 AM |
| Fix misspelled "username" column | |||
| Column person.usernae renamed to username | |||
| changelogs/mysql/complete/root.changelog.xml | 5 | nvoxland | Executed 11/15/07 9:37 AM |
| New row inserted into person | |||
| New row inserted into person | |||
| New row inserted into person | |||
| changelogs/mysql/complete/root.changelog.xml | 6 | nvoxland | Executed 11/15/07 9:37 AM |
| Don't keep username in the person table | |||
| Column person.username dropped | |||
| changelogs/mysql/complete/root.changelog.xml | 7 | nvoxland | Executed 11/15/07 9:37 AM |
| Table employee created | |||
| changelogs/mysql/complete/root.changelog.xml | 7a | nvoxland | Executed 11/15/07 9:37 AM |
| Column company_id(int) added to employee | |||
| changelogs/mysql/complete/root.changelog.xml | 9 | nvoxland | Executed 11/15/07 9:37 AM |
| Table employee renamed to company | |||
| changelogs/mysql/complete/root.changelog.xml | 10 | nvoxland | Executed 11/15/07 9:37 AM |
| Table testtable created | |||
| changelogs/mysql/complete/root.changelog.xml | 11 | nvoxland | Executed 11/15/07 9:37 AM |
| Table testtable dropped | |||
| changelogs/mysql/complete/root.changelog.xml | 12 | nvoxland | Executed 11/15/07 9:37 AM |
| Index idx_company_name created | |||
| Index idx_person_lastname created | |||
| changelogs/mysql/complete/root.changelog.xml | 13 | nvoxland | Executed 11/15/07 9:37 AM |
| Index idx_person_lastname dropped from table person | |||
| changelogs/mysql/complete/root.changelog.xml | 14 | nvoxland | Executed 11/15/07 9:37 AM |
| Table liquibaseRunInfo created | |||
| New row inserted into liquibaseRunInfo | |||
| changelogs/mysql/complete/root.changelog.xml | 15 | nvoxland | Executed 11/15/07 9:37 AM |
| Custom SQL executed | |||
| changelogs/mysql/complete/root.changelog.xml | 16 | nvoxland | Executed 11/15/07 9:37 AM |
| View personView created | |||
| changelogs/mysql/complete/root.changelog.xml | 18 | nvoxland | Executed 11/15/07 9:37 AM |
| View personView dropped | |||
| changelogs/mysql/complete/root.changelog.xml | 19 | nvoxland | Executed 11/15/07 9:37 AM |
| Columns person.firstname and person.lastname merged | |||
| changelogs/mysql/complete/root.changelog.xml | 20 | nvoxland | Executed 11/15/07 9:37 AM |
| View personView created | |||
| changelogs/mysql/complete/root.changelog.xml | 21 | nvoxland | Executed 11/15/07 9:37 AM |
| View personView renamed to v_person | |||
| changelogs/mysql/complete/root.changelog.xml | 22 | nvoxland | Executed 11/15/07 9:37 AM |
| Column employer_id(int) added to person | |||
| changelogs/mysql/complete/root.changelog.xml | 23 | nvoxland | Executed 11/15/07 9:37 AM |
| Foreign key contraint added to person (employer_id) | |||
| changelogs/mysql/complete/root.changelog.xml | 24 | nvoxland | Executed 11/15/07 9:37 AM |
| Foreign key fk_person_employer dropped | |||
| changelogs/mysql/complete/root.changelog.xml | 25 | nvoxland | Executed 11/15/07 9:37 AM |
| Table address created | |||
| changelogs/mysql/complete/root.changelog.xml | 25.1 | nvoxland | Executed 11/15/07 9:37 AM |
| Null constraint has been added to address.id | |||
| changelogs/mysql/complete/root.changelog.xml | 25.2 | nvoxland | Executed 11/15/07 9:37 AM |
| Primary key added to address (id) | |||
| changelogs/mysql/complete/root.changelog.xml | 25.3 | nvoxland | Executed 11/15/07 9:37 AM |
| Auto-increment added to address.id | |||
| changelogs/mysql/complete/root.changelog.xml | 26 | nvoxland | Executed 11/15/07 9:37 AM |
| New row inserted into address | |||
| New row inserted into address | |||
| New row inserted into address | |||
| New row inserted into address | |||
| changelogs/mysql/complete/root.changelog.xml | 27 | nvoxland | Executed 11/15/07 9:37 AM |
| Lookup table added for address.state | |||
| changelogs/mysql/complete/root.changelog.xml | 28 | nvoxland | Executed 11/15/07 9:37 AM |
| Default value added to address.line2 | |||
| changelogs/mysql/complete/root.changelog.xml | 29 | nvoxland | Executed 11/15/07 9:37 AM |
| Default value dropped from address.line2 | |||
| changelogs/mysql/complete/root.changelog.xml | 30 | nvoxland | Executed 11/15/07 9:37 AM |
| Table pkTest created | |||
| changelogs/mysql/complete/root.changelog.xml | 31 | nvoxland | Executed 11/15/07 9:37 AM |
| Primary key added to pkTest (id) | |||
| changelogs/mysql/complete/root.changelog.xml | 32 | nvoxland | Executed 11/15/07 9:37 AM |
| Primary key dropped from pkTest | |||
| changelogs/mysql/complete/root.changelog.xml | 33 | nvoxland | Executed 11/15/07 9:37 AM |
| Unique constraint added to address(line1, line2) | |||
| changelogs/mysql/complete/root.changelog.xml | 34 | nvoxland | Executed 11/15/07 9:38 AM |
| Unique constraint uq_address_line1line2 dropped from address | |||
| changelogs/mysql/complete/root.changelog.xml | 35 | nvoxland | Executed 11/15/07 9:38 AM |
| Table tableToRollback created | |||
| changelogs/mysql/complete/root.changelog.xml | 51 | nvoxland | Executed 11/15/07 9:38 AM |
| Table nulldefaulttest created | |||
| changelogs/mysql/complete/root.changelog.xml | 51b | nvoxland | Executed 11/15/07 9:38 AM |
| Column foreign_id(bigint) added to nulldefaulttest | |||
| changelogs/mysql/complete/included.changelog.xml | 1 | nvoxland | Executed 11/15/07 9:38 AM |
| Table news created | |||
| changelogs/mysql/complete/included.changelog.xml | 2 | nvoxland | Executed 11/15/07 9:38 AM |
| New row inserted into news | |||
| New row inserted into news | |||
| changelogs/mysql/complete/oldname.changelog.xml | 1 | nvoxland | Executed 11/15/07 9:38 AM |
| Table book created | |||
| changelogs/common/common.tests.changelog.xml | datatypetest-1 | nvoxland | Executed 11/15/07 9:38 AM |
| Table dataTypeTest created | |||
| changelogs/common/common.tests.changelog.xml | datatypetest-2 | nvoxland | Executed 11/15/07 9:38 AM |
| New row inserted into dataTypeTest | |||
| changelogs/common/common.tests.changelog.xml | defaultValueTest-1 | nvoxland | Executed 11/15/07 9:38 AM |
| Table defaultValueTest created | |||
| Default value added to defaultValueTest.intA | |||
| Default value added to defaultValueTest.textA | |||
| Default value added to defaultValueTest.booleanA | |||
| Default value added to defaultValueTest.dateA | |||
| Default value added to defaultValueTest.timeA | |||
| Default value added to defaultValueTest.datetimeA | |||
| New row inserted into defaultValueTest | |||
| changelogs/common/common.tests.changelog.xml | compoundPrimaryKeyTest | nvoxland | Executed 11/15/07 9:38 AM |
| Table compoundPKTest created | |||
| changelogs/common/common.tests.changelog.xml | compoundIndexTest | nvoxland | Executed 11/15/07 9:38 AM |
| Table compoundIndexTest created | |||
| Index idx_compoundtest created | |||
| changelogs/common/common.tests.changelog.xml | commentTest | nvoxland | Executed 11/15/07 9:38 AM |
| Creates a table and updates a value with actual SQL. Mainly for testing the comment tags | |||
| Table commentTest created | |||
| Custom SQL executed | |||
| changelogs/common/common.tests.changelog.xml | contextstest-1 | nvoxland | Executed 11/15/07 9:38 AM |
| Test how contexts work | |||
| Table contextsTest created | |||
| changelogs/common/common.tests.changelog.xml | contextstest-3 | nvoxland | Executed 11/15/07 9:38 AM |
| New row inserted into contextsTest | |||
| changelogs/common/common.tests.changelog.xml | contextstest-4 | nvoxland | Executed 11/15/07 9:38 AM |
| New row inserted into contextsTest | |||
| changelogs/common/common.tests.changelog.xml | contextstest-5 | nvoxland | Executed 11/15/07 9:38 AM |
| New row inserted into contextsTest | |||
| changelogs/common/common.tests.changelog.xml | contextstest-6 | nvoxland | Executed 11/15/07 9:38 AM |
| New row inserted into contextsTest | |||
| changelogs/common/common.tests.changelog.xml | datatype-conversion-teset | nvoxland | Executed 11/15/07 9:38 AM |
| Table datatypeConversionTest created | |||
| changelogs/common/schema.tests.changelog.xml | 1 | nvoxland | Executed 11/15/07 9:38 AM |
| Table person2 created | |||
| changelogs/common/schema.tests.changelog.xml | 2 | nvoxland | Executed 11/15/07 9:38 AM |
| Add a username column so we can use "person" for authentication | |||
| Column username(varchar(8)) added to person2 | |||
| changelogs/common/schema.tests.changelog.xml | 5 | nvoxland | Executed 11/15/07 9:38 AM |
| New row inserted into person2 | |||
| New row inserted into person2 | |||
| New row inserted into person2 | |||
| changelogs/common/schema.tests.changelog.xml | 7 | nvoxland | Executed 11/15/07 9:38 AM |
| Table company2 created | |||
| changelogs/common/schema.tests.changelog.xml | 7a | nvoxland | Executed 11/15/07 9:38 AM |
| Column company_id(int) added to company2 | |||
| changelogs/common/schema.tests.changelog.xml | 10 | nvoxland | Executed 11/15/07 9:38 AM |
| Table testtable2 created | |||
| changelogs/common/schema.tests.changelog.xml | 11 | nvoxland | Executed 11/15/07 9:38 AM |
| Table testtable2 dropped | |||
| changelogs/common/schema.tests.changelog.xml | 12 | nvoxland | Executed 11/15/07 9:38 AM |
| Index idx_company_name2 created | |||
| Index idx_person_lastname2 created | |||
| changelogs/common/schema.tests.changelog.xml | 13 | nvoxland | Executed 11/15/07 9:38 AM |
| Index idx_person_lastname2 dropped from table person2 | |||
| changelogs/common/schema.tests.changelog.xml | 19 | nvoxland | Executed 11/15/07 9:38 AM |
| Columns person2.firstname and person2.lastname merged | |||
| changelogs/common/schema.tests.changelog.xml | 22 | nvoxland | Executed 11/15/07 9:38 AM |
| Column employer_id(int) added to person2 | |||
| changelogs/common/schema.tests.changelog.xml | 23 | nvoxland | Executed 11/15/07 9:38 AM |
| Foreign key contraint added to person2 (employer_id) | |||
| changelogs/common/schema.tests.changelog.xml | 24 | nvoxland | Executed 11/15/07 9:38 AM |
| Foreign key fk_person_employer dropped | |||
| changelogs/common/schema.tests.changelog.xml | 25 | nvoxland | Executed 11/15/07 9:38 AM |
| Table address2 created | |||
| changelogs/common/schema.tests.changelog.xml | 25.1 | nvoxland | Executed 11/15/07 9:38 AM |
| Null constraint has been added to address2.id | |||
| changelogs/common/schema.tests.changelog.xml | 25.2 | nvoxland | Executed 11/15/07 9:38 AM |
| Primary key added to address2 (id) | |||
| changelogs/common/schema.tests.changelog.xml | 26 | nvoxland | Executed 11/15/07 9:38 AM |
| New row inserted into address2 | |||
| New row inserted into address2 | |||
| New row inserted into address2 | |||
| New row inserted into address2 | |||
| changelogs/common/schema.tests.changelog.xml | 28 | nvoxland | Executed 11/15/07 9:38 AM |
| Default value added to address2.line2 | |||
| changelogs/common/schema.tests.changelog.xml | 29 | nvoxland | Executed 11/15/07 9:38 AM |
| Default value dropped from address2.line2 | |||
| changelogs/common/schema.tests.changelog.xml | 30 | nvoxland | Executed 11/15/07 9:38 AM |
| Table pkTest2 created | |||
| changelogs/common/schema.tests.changelog.xml | 35 | nvoxland | Executed 11/15/07 9:38 AM |
| Table tableToRollback2 created | |||
| changelogs/common/schema.tests.changelog.xml | 50 | nvoxland | Executed 11/15/07 9:38 AM |
| Column address2.postalcode modified | |||