diff options
Diffstat (limited to 'src/wixext/SqlTableDefinitions.cs')
| -rw-r--r-- | src/wixext/SqlTableDefinitions.cs | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/src/wixext/SqlTableDefinitions.cs b/src/wixext/SqlTableDefinitions.cs index e980aaae..3d1daee0 100644 --- a/src/wixext/SqlTableDefinitions.cs +++ b/src/wixext/SqlTableDefinitions.cs | |||
| @@ -8,6 +8,7 @@ namespace WixToolset.Sql | |||
| 8 | { | 8 | { |
| 9 | public static readonly TableDefinition SqlDatabase = new TableDefinition( | 9 | public static readonly TableDefinition SqlDatabase = new TableDefinition( |
| 10 | "SqlDatabase", | 10 | "SqlDatabase", |
| 11 | SqlTupleDefinitions.SqlDatabase, | ||
| 11 | new[] | 12 | new[] |
| 12 | { | 13 | { |
| 13 | new ColumnDefinition("SqlDb", ColumnType.String, 72, primaryKey: true, nullable: false, ColumnCategory.Identifier, description: "Primary key, non-localized token", modularizeType: ColumnModularizeType.Column), | 14 | new ColumnDefinition("SqlDb", ColumnType.String, 72, primaryKey: true, nullable: false, ColumnCategory.Identifier, description: "Primary key, non-localized token", modularizeType: ColumnModularizeType.Column), |
| @@ -20,12 +21,12 @@ namespace WixToolset.Sql | |||
| 20 | new ColumnDefinition("FileSpec_Log", ColumnType.String, 72, primaryKey: false, nullable: true, ColumnCategory.Identifier, keyTable: "SqlFileSpec", keyColumn: 1, description: "Foreign key referencing SqlFileSpec.", modularizeType: ColumnModularizeType.Column), | 21 | new ColumnDefinition("FileSpec_Log", ColumnType.String, 72, primaryKey: false, nullable: true, ColumnCategory.Identifier, keyTable: "SqlFileSpec", keyColumn: 1, description: "Foreign key referencing SqlFileSpec.", modularizeType: ColumnModularizeType.Column), |
| 21 | new ColumnDefinition("Attributes", ColumnType.Number, 2, primaryKey: false, nullable: true, ColumnCategory.Unknown, minValue: 0, maxValue: 255, description: "1 == create on install, 2 == drop on uninstall, 4 == continue on error, 8 == drop on install, 16 == create on uninstall, 32 == confirm update existing table, 64 == create on reinstall, 128 == drop on reinstall"), | 22 | new ColumnDefinition("Attributes", ColumnType.Number, 2, primaryKey: false, nullable: true, ColumnCategory.Unknown, minValue: 0, maxValue: 255, description: "1 == create on install, 2 == drop on uninstall, 4 == continue on error, 8 == drop on install, 16 == create on uninstall, 32 == confirm update existing table, 64 == create on reinstall, 128 == drop on reinstall"), |
| 22 | }, | 23 | }, |
| 23 | tupleDefinitionName: "SqlDatabase", | ||
| 24 | tupleIdIsPrimaryKey: true | 24 | tupleIdIsPrimaryKey: true |
| 25 | ); | 25 | ); |
| 26 | 26 | ||
| 27 | public static readonly TableDefinition SqlFileSpec = new TableDefinition( | 27 | public static readonly TableDefinition SqlFileSpec = new TableDefinition( |
| 28 | "SqlFileSpec", | 28 | "SqlFileSpec", |
| 29 | SqlTupleDefinitions.SqlFileSpec, | ||
| 29 | new[] | 30 | new[] |
| 30 | { | 31 | { |
| 31 | new ColumnDefinition("FileSpec", ColumnType.String, 72, primaryKey: true, nullable: false, ColumnCategory.Identifier, description: "Primary key, non-localized token", modularizeType: ColumnModularizeType.Column), | 32 | new ColumnDefinition("FileSpec", ColumnType.String, 72, primaryKey: true, nullable: false, ColumnCategory.Identifier, description: "Primary key, non-localized token", modularizeType: ColumnModularizeType.Column), |
| @@ -35,12 +36,12 @@ namespace WixToolset.Sql | |||
| 35 | new ColumnDefinition("MaxSize", ColumnType.String, 72, primaryKey: false, nullable: true, ColumnCategory.Formatted, description: "Maximum size for file", modularizeType: ColumnModularizeType.Property), | 36 | new ColumnDefinition("MaxSize", ColumnType.String, 72, primaryKey: false, nullable: true, ColumnCategory.Formatted, description: "Maximum size for file", modularizeType: ColumnModularizeType.Property), |
| 36 | new ColumnDefinition("GrowthSize", ColumnType.String, 72, primaryKey: false, nullable: true, ColumnCategory.Formatted, description: "Size file should grow when necessary", modularizeType: ColumnModularizeType.Property), | 37 | new ColumnDefinition("GrowthSize", ColumnType.String, 72, primaryKey: false, nullable: true, ColumnCategory.Formatted, description: "Size file should grow when necessary", modularizeType: ColumnModularizeType.Property), |
| 37 | }, | 38 | }, |
| 38 | tupleDefinitionName: "SqlFileSpec", | ||
| 39 | tupleIdIsPrimaryKey: true | 39 | tupleIdIsPrimaryKey: true |
| 40 | ); | 40 | ); |
| 41 | 41 | ||
| 42 | public static readonly TableDefinition SqlScript = new TableDefinition( | 42 | public static readonly TableDefinition SqlScript = new TableDefinition( |
| 43 | "SqlScript", | 43 | "SqlScript", |
| 44 | SqlTupleDefinitions.SqlScript, | ||
| 44 | new[] | 45 | new[] |
| 45 | { | 46 | { |
| 46 | new ColumnDefinition("Script", ColumnType.String, 72, primaryKey: true, nullable: false, ColumnCategory.Identifier, description: "Primary key, non-localized token"), | 47 | new ColumnDefinition("Script", ColumnType.String, 72, primaryKey: true, nullable: false, ColumnCategory.Identifier, description: "Primary key, non-localized token"), |
| @@ -51,12 +52,12 @@ namespace WixToolset.Sql | |||
| 51 | new ColumnDefinition("Attributes", ColumnType.Number, 2, primaryKey: false, nullable: false, ColumnCategory.Unknown, possibilities: "1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19;20;21;22;23;24;25;26;27;28;29;30;31", description: "1 == execute on install, 2 == execute on uninstall, 4 == continue on error, 8 == rollback on install, 16 == rollback on uninstall"), | 52 | new ColumnDefinition("Attributes", ColumnType.Number, 2, primaryKey: false, nullable: false, ColumnCategory.Unknown, possibilities: "1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19;20;21;22;23;24;25;26;27;28;29;30;31", description: "1 == execute on install, 2 == execute on uninstall, 4 == continue on error, 8 == rollback on install, 16 == rollback on uninstall"), |
| 52 | new ColumnDefinition("Sequence", ColumnType.Number, 2, primaryKey: false, nullable: true, ColumnCategory.Unknown, description: "Order to execute SQL Queries in"), | 53 | new ColumnDefinition("Sequence", ColumnType.Number, 2, primaryKey: false, nullable: true, ColumnCategory.Unknown, description: "Order to execute SQL Queries in"), |
| 53 | }, | 54 | }, |
| 54 | tupleDefinitionName: "SqlScript", | ||
| 55 | tupleIdIsPrimaryKey: true | 55 | tupleIdIsPrimaryKey: true |
| 56 | ); | 56 | ); |
| 57 | 57 | ||
| 58 | public static readonly TableDefinition SqlString = new TableDefinition( | 58 | public static readonly TableDefinition SqlString = new TableDefinition( |
| 59 | "SqlString", | 59 | "SqlString", |
| 60 | SqlTupleDefinitions.SqlString, | ||
| 60 | new[] | 61 | new[] |
| 61 | { | 62 | { |
| 62 | new ColumnDefinition("String", ColumnType.String, 72, primaryKey: true, nullable: false, ColumnCategory.Identifier, description: "Id for the SqlString", modularizeType: ColumnModularizeType.Column), | 63 | new ColumnDefinition("String", ColumnType.String, 72, primaryKey: true, nullable: false, ColumnCategory.Identifier, description: "Id for the SqlString", modularizeType: ColumnModularizeType.Column), |
| @@ -67,7 +68,6 @@ namespace WixToolset.Sql | |||
| 67 | new ColumnDefinition("Attributes", ColumnType.Number, 2, primaryKey: false, nullable: false, ColumnCategory.Unknown, possibilities: "1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19;20;21;22;23;24;25;26;27;28;29;30;31", description: "1 == execute on install, 2 == execute on uninstall, 4 == continue on error, 8 == rollback on install, 16 == rollback on uninstall"), | 68 | new ColumnDefinition("Attributes", ColumnType.Number, 2, primaryKey: false, nullable: false, ColumnCategory.Unknown, possibilities: "1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19;20;21;22;23;24;25;26;27;28;29;30;31", description: "1 == execute on install, 2 == execute on uninstall, 4 == continue on error, 8 == rollback on install, 16 == rollback on uninstall"), |
| 68 | new ColumnDefinition("Sequence", ColumnType.Number, 2, primaryKey: false, nullable: true, ColumnCategory.Unknown, description: "Order to execute SQL Queries in"), | 69 | new ColumnDefinition("Sequence", ColumnType.Number, 2, primaryKey: false, nullable: true, ColumnCategory.Unknown, description: "Order to execute SQL Queries in"), |
| 69 | }, | 70 | }, |
| 70 | tupleDefinitionName: "SqlString", | ||
| 71 | tupleIdIsPrimaryKey: true | 71 | tupleIdIsPrimaryKey: true |
| 72 | ); | 72 | ); |
| 73 | 73 | ||
