|
<< Click to Display Table of Contents >> RayPack > 7.3 u6 > User Guide > Reference and Cheat Sheets > Custom RayPack Installer Database Tables RPSqlScript table |
The RPSqlScript table contains the columns shown in the following table.
Column |
Type |
Key |
Nullable |
|---|---|---|---|
RPSqlScript |
Text (s72) |
Y |
N |
RPSqlDatabase_ |
Text (s72) |
N |
N |
Component_ |
Text (s72) |
N |
N |
Source_ |
Text (S0) |
N |
Y |
RPUser_ |
Text (S72) |
N |
Y |
Attributes |
Integer (i2) |
N |
N |
Sequence |
Integer (i2) |
N |
N |
SourceType |
Integer (i2) |
N |
N |
Target |
Text (S0) |
N |
Y |
Description |
Text (S0) |
Y |
N |
RPSqlScript
ID of Sql Script.
RPSqlDatabase_
Foreign key related to RPSqldatabase table used to determine SQL database to execute the script on.
Component_
Foreign key to Component used to determine install state.
Source_
If SourceType = 1 : Foreign key related to Binary table
If SourceType = 2 : Foreign key related to Property table
RPUser_
User used to log into database.
Attributes
1 = execute on install
2 = execute on uninstall
4 = continue on error
8 = rollback on install
16 = rollback on uninstall
Sequence
Order to execute SQL scripts.
SourceType
1 = Binary
2 = Property
3 = Text
Target
SQLScript source if SourceType = 3
Description
The description of the sql script.