Scout Database Model (CR)
Table: ScreenSaver
Screen saver settings belongs to a entry of table Setup.
| ColumnName | DataType | Key | Not Null | Default Value | Comment |
|---|---|---|---|---|---|
| ScreenSaverID | INTEGER | PK | NN | Unique ID of an entry | |
| Mode
|
NVARCHAR(255)
|
|
|
blank
|
Screen saver mode |
| blank Blank screen | |||||
| one One single screen saver is selected | |||||
| random Random selection | |||||
| Cycle | NVARCHAR(255) | 0:05:00 | Time after which the screen saver is restarted <hours:minutes:seconds> | ||
| PicDir | NVARCHAR(255) | /setup/xscreensaver | Client directory where pictures can be found by Slideshow | ||
| BannerText | NVARCHAR(255) | eLux NG | Literal text to be displayed by Fontglide | ||
| SelectedHack | NVARCHAR(255) | ripples | Currently selected screen saver (Mode must be set to one):deco/fontglide/ripples/slideshow/sonar/substrate/xmatrix | ||
| Deco | NVARCHAR(255) | Parameters for Deco <param1>=<value1>::<param2>=<value2>::<paramN>=<valueN>
|
|||
| Fontglide | NVARCHAR(255) | Parameters for Fontglide <param1>=<value1>::<param2>=<value2>::<paramN>=<valueN>
|
|||
| Ripples | NVARCHAR(255) | Parameters for Ripples <param1>=<value1>::<param2>=<value2>::<paramN>=<valueN>
|
|||
| Slideshow | NVARCHAR(255) | Parameters for Slideshow <param1>=<value1>::<param2>=<value2>::<paramN>=<valueN>
|
|||
| Sonar | NVARCHAR(255) | Parameters for Sonar <param1>=<value1>::<param2>=<value2>::<paramN>=<valueN>
|
|||
| Substrate | NVARCHAR(255) | Parameters for Substrate <param1>=<value1>::<param2>=<value2>::<paramN>=<valueN>
|
|||
| XMatrix | NVARCHAR(255) | Parameters for XMatrix <param1>=<value1>::<param2>=<value2>::<paramN>=<valueN>
|
|||
| PopSquares | NVARCHAR(255) | Parameters for PopSquares <param1>=<value1>::<param2>=<value2>::<paramN>=<valueN>
|
|||
| SetupID | INTEGER | FK | Setup ID (foreign key refers to table Setup) | ||
| HTML5 | NVARCHAR(255) |
| IndexName | IndexType | Columns |
|---|---|---|
| PRIMARY | PRIMARY | ScreenSaverID |
How to create
CREATE TABLE ScreenSaver(
ScreenSaverID INTEGER NOT NULL,
Mode NVARCHAR(255),
Cycle NVARCHAR(255),
PicDir NVARCHAR(255),
BannerText NVARCHAR(255),
SelectedHack NVARCHAR(255),
Deco NVARCHAR(255),
Fontglide NVARCHAR(255),
Ripples NVARCHAR(255),
Slideshow NVARCHAR(255),
Sonar NVARCHAR(255),
Substrate NVARCHAR(255),
XMatrix NVARCHAR(255),
SetupID INTEGER,
HTML5 NVARCHAR(255),
PRIMARY KEY (ScreenSaverID));
Table: ScreenSaver
In this article
Copied!
Failed!