diff options
Diffstat (limited to 'src/wixext')
-rw-r--r-- | src/wixext/SqlTableDefinitions.cs | 8 | ||||
-rw-r--r-- | src/wixext/Tuples/SqlScriptTuple.cs | 4 | ||||
-rw-r--r-- | src/wixext/Tuples/SqlStringTuple.cs | 4 |
3 files changed, 8 insertions, 8 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 | ||
diff --git a/src/wixext/Tuples/SqlScriptTuple.cs b/src/wixext/Tuples/SqlScriptTuple.cs index de76d49d..6e4e484b 100644 --- a/src/wixext/Tuples/SqlScriptTuple.cs +++ b/src/wixext/Tuples/SqlScriptTuple.cs | |||
@@ -78,9 +78,9 @@ namespace WixToolset.Sql.Tuples | |||
78 | set => this.Set((int)SqlScriptTupleFields.Attributes, value); | 78 | set => this.Set((int)SqlScriptTupleFields.Attributes, value); |
79 | } | 79 | } |
80 | 80 | ||
81 | public int Sequence | 81 | public int? Sequence |
82 | { | 82 | { |
83 | get => this.Fields[(int)SqlScriptTupleFields.Sequence].AsNumber(); | 83 | get => this.Fields[(int)SqlScriptTupleFields.Sequence].AsNullableNumber(); |
84 | set => this.Set((int)SqlScriptTupleFields.Sequence, value); | 84 | set => this.Set((int)SqlScriptTupleFields.Sequence, value); |
85 | } | 85 | } |
86 | } | 86 | } |
diff --git a/src/wixext/Tuples/SqlStringTuple.cs b/src/wixext/Tuples/SqlStringTuple.cs index 77882d33..7a73f271 100644 --- a/src/wixext/Tuples/SqlStringTuple.cs +++ b/src/wixext/Tuples/SqlStringTuple.cs | |||
@@ -78,9 +78,9 @@ namespace WixToolset.Sql.Tuples | |||
78 | set => this.Set((int)SqlStringTupleFields.Attributes, value); | 78 | set => this.Set((int)SqlStringTupleFields.Attributes, value); |
79 | } | 79 | } |
80 | 80 | ||
81 | public int Sequence | 81 | public int? Sequence |
82 | { | 82 | { |
83 | get => this.Fields[(int)SqlStringTupleFields.Sequence].AsNumber(); | 83 | get => this.Fields[(int)SqlStringTupleFields.Sequence].AsNullableNumber(); |
84 | set => this.Set((int)SqlStringTupleFields.Sequence, value); | 84 | set => this.Set((int)SqlStringTupleFields.Sequence, value); |
85 | } | 85 | } |
86 | } | 86 | } |