Scout Database Model (CR)
Table: PowerManagementProfile
Stores the powermanagement profiles
| ColumnName | DataType | Key | Not Null | Default Value | Comment |
|---|---|---|---|---|---|
| PowerManagementProfileID | INTEGER IDENTITY(1,1) | PK | NN | Unique ID of the profile | |
| SetupID | INTEGER | NN | Setup the profile belongs to | ||
| ProfileType | INTEGER | NN | Eco (Power saver) / High performance (Power) | ||
| BrightnessLevel | INTEGER | NN | |||
| ActionOnLid | INTEGER | NN | Action when users close the lid | ||
| ActionOnPowerButton | INTEGER | NN | Action when users press the power button | ||
| ActionOnS3 | INTEGER | NN | Action when device goes to sleep mode | ||
| ActionOnS3NoLogin | INTEGER | NN | Action when device goes to sleep mode and user is logged off | ||
| ActionOnSleepButton
|
INTEGER
|
|
NN
|
3
|
Keyboard Power/Sleep key can be configured to |
| 0 no action | |||||
| 2 shutdown | |||||
| 3 suspend | |||||
| DPMS | BIT | NN | Switch off the display | ||
| DPMSDelay | INTEGER | NN | Delay for switching off display | ||
| S3 | BIT | NN | Activate sleep mode (S3) | ||
| S3Delay | INTEGER | NN | Delay for activating S3 | ||
| S3NoLogin | BIT | NN | |||
| NoLoginDelay | INTEGER | NN | 600 | Delay when user is logged off | |
| ScreenSaver | BIT | NN | Activate screen saver | ||
| ScreenSaverDelay | INTEGER | NN | Delay for activating screen saver |
| IndexName | IndexType | Columns |
|---|---|---|
| PRIMARY | PRIMARY | PowerManagementProfileID |
How to create
CREATE TABLE PowerManagementProfile(
PowerManagementProfileID INTEGER IDENTITY(1,1),
SetupID INTEGER NOT NULL,
ProfileType INTEGER NOT NULL,
BrightnessLevel INTEGER NOT NULL,
ActionOnLid INTEGER NOT NULL,
ActionOnPowerButton INTEGER NOT NULL,
ActionOnS3 INTEGER NOT NULL,
ActionOnS3NoLogin INTEGER NOT NULL,
ActionOnSleepButton INTEGER NOT NULL,
DPMS BIT NOT NULL,
DPMSDelay INTEGER NOT NULL,
S3 BIT NOT NULL,
S3Delay INTEGER NOT NULL,
ScreenSaver BIT NOT NULL,
ScreenSaverDelay INTEGER NOT NULL,
S3NoLogin BIT NOT NULL,
NoLoginDelay INTEGER NOT NULL DEFAULT 600,
CONSTRAINT PK_PowerManagementProfile
PRIMARY KEY (PowerManagementProfileID));
How to initialize
INSERT INTO PowerManagementProfile (BrightnessLevel, ActionOnLid, ActionOnPowerButton, DPMS, DPMSDelay, S3, S3Delay, ScreenSaver, ScreenSaverDelay, setupid, ProfileType, ActionOnS3)
SELECT 100, 1, 2, PowerManagement, StandbyTime*60, 0, 600, UseScreenSaver, XAutolockDelay *60, MemberID, 2, 3 from screensettings where MemberType=5 AND (PowerManagement <> 1 OR StandbyTime <> 10 OR UseScreenSaver <> 0 OR XAutolockDelay <> 3 );
Table: PowerManagementProfile
Copied!
Failed!