← Back to branch summary

~dbversion-committers/dbversion/trunk

« back to all changes in this revision

Viewing changes to samples/classic-sample-with-updates/2/ddl.sql

  • Committer: Adam Connelly
  • Date: 2013-05-30 10:21:45 UTC
  • Revision ID: adam.rpconnelly@gmail.com-20130530102145-ggq1q7cvn23yws4z
Added the ability to execute any tasks in previous versions that have not already been run (-m or --missing).

  * Fixed a bug in the HelpCommand where it couldn't handle missing long or short arguments.
  * Removed the verify command and replaced it with a -r / --rollback flag on the create command.
  * Fixed a crash in the CheckCommand if the version table didn't exist.

Show diffs side-by-side

added added

removed removed

Lines of Context:
samples/classic-sample-with-updates/2/ddl.sql
 
1
create table EmailAddresses
 
2
(
 
3
        EmailId         char(36),       
 
4
        EmailAddress    varchar(100),
 
5
        primary key(EmailId)
 
6
);
 
7
 
 
8
create table UserEmailAddresses
 
9
(
 
10
        UserId  char(36),
 
11
        EmailId char(36),
 
12
        primary key(UserId, EmailId),
 
13
        foreign key (UserId) references Users (UserId),
 
14
        foreign key (EmailId) references EmailAddresses (EmailId)
 
15
);