aboutsummaryrefslogtreecommitdiff
path: root/src/wixext
diff options
context:
space:
mode:
Diffstat (limited to 'src/wixext')
-rw-r--r--src/wixext/SqlTableDefinitions.cs8
-rw-r--r--src/wixext/Tuples/SqlScriptTuple.cs4
-rw-r--r--src/wixext/Tuples/SqlStringTuple.cs4
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 }