function dbInstall($data)
{
$data = <<<EOD
app_pushbullet: ID int(10) unsigned NOT NULL auto_increment
app_pushbullet: apikey text
app_pushbullet: iden text
app_pushbullet: name text
EOD;
parent::dbInstall($data);
}
function dbInstall($data)
{
$data = <<<EOD
project_modules: ID tinyint(3) unsigned NOT NULL auto_increment
project_modules: NAME varchar(50) DEFAULT '' NOT NULL
project_modules: TITLE varchar(100) DEFAULT '' NOT NULL
project_modules: CATEGORY varchar(50) DEFAULT '' NOT NULL
project_modules: PARENT_NAME varchar(50) DEFAULT '' NOT NULL
project_modules: DATA text
project_modules: HIDDEN int(3) DEFAULT '0' NOT NULL
project_modules: PRIORITY int(10) DEFAULT '0' NOT NULL
project_modules: ADDED timestamp(14)
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data)
{
/*
commands - Commands
*/
$data = <<<EOD
commands: ID int(10) unsigned NOT NULL auto_increment
commands: TITLE varchar(255) NOT NULL DEFAULT ''
commands: SYSTEM varchar(255) NOT NULL DEFAULT ''
commands: COMMAND varchar(255) NOT NULL DEFAULT ''
commands: URL varchar(255) NOT NULL DEFAULT ''
commands: TYPE char(50) NOT NULL DEFAULT ''
commands: WINDOW varchar(255) NOT NULL DEFAULT ''
commands: WIDTH int(10) NOT NULL DEFAULT '0'
commands: HEIGHT int(10) NOT NULL DEFAULT '0'
commands: PARENT_ID int(10) NOT NULL DEFAULT '0'
commands: PRIORITY int(10) NOT NULL DEFAULT '0'
commands: MIN_VALUE float(10) NOT NULL DEFAULT '0'
commands: MAX_VALUE float(10) NOT NULL DEFAULT '0'
commands: CUR_VALUE varchar(255) NOT NULL DEFAULT '0'
commands: STEP_VALUE float(10) NOT NULL DEFAULT '1'
commands: DATA text
commands: LINKED_OBJECT varchar(255) NOT NULL DEFAULT ''
commands: LINKED_PROPERTY varchar(255) NOT NULL DEFAULT ''
commands: EXT_ID int(10) NOT NULL DEFAULT '0'
commands: VISIBLE_DELAY int(10) NOT NULL DEFAULT '0'
commands: INLINE int(3) NOT NULL DEFAULT '0'
commands: SUB_PRELOAD int(3) NOT NULL DEFAULT '0'
commands: RENDER_TITLE varchar(255) NOT NULL DEFAULT ''
commands: RENDER_DATA text
commands: RENDER_UPDATED datetime
commands: ONCHANGE_OBJECT varchar(255) NOT NULL DEFAULT ''
commands: ONCHANGE_METHOD varchar(255) NOT NULL DEFAULT ''
commands: SCRIPT_ID int(10) NOT NULL DEFAULT '0'
commands: ICON varchar(50) NOT NULL DEFAULT ''
commands: CODE text
commands: SUB_LIST text
commands: PARENT_LIST text
commands: AUTOSTART int(3) NOT NULL DEFAULT '0'
commands: AUTO_UPDATE int(10) NOT NULL DEFAULT '0'
EOD;
parent::dbInstall($data);
SQLExec("ALTER TABLE `commands` CHANGE `MIN_VALUE` `MIN_VALUE` FLOAT( 10 ) NOT NULL DEFAULT '0'");
SQLExec("ALTER TABLE `commands` CHANGE `MAX_VALUE` `MAX_VALUE` FLOAT( 10 ) NOT NULL DEFAULT '0'");
SQLExec("ALTER TABLE `commands` CHANGE `STEP_VALUE` `STEP_VALUE` FLOAT( 10 ) NOT NULL DEFAULT '0'");
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data)
{
/*
objects - Objects
*/
$data = <<<EOD
objects: ID int(10) unsigned NOT NULL auto_increment
objects: TITLE varchar(255) NOT NULL DEFAULT ''
objects: CLASS_ID int(10) NOT NULL DEFAULT '0'
objects: DESCRIPTION text
objects: LOCATION_ID int(10) NOT NULL DEFAULT '0'
EOD;
parent::dbInstall($data);
}
function dbInstall($data)
{
$data = <<<EOD
admin_users: ID tinyint(3) unsigned NOT NULL auto_increment
admin_users: NAME varchar(100) DEFAULT '' NOT NULL
admin_users: LOGIN varchar(100) DEFAULT '' NOT NULL
admin_users: PASSWORD varchar(100) DEFAULT '' NOT NULL
admin_users: EMAIL varchar(100) DEFAULT '' NOT NULL
admin_users: COMMENTS text
admin_users: ACCESS text
admin_users: PRIVATE tinyint(3) unsigned DEFAULT '0' NOT NULL
admin_users: EMAIL_ORDERS tinyint(3) unsigned NOT NULL default '0'
admin_users: EMAIL_INVENTORY tinyint(3) unsigned NOT NULL default '0'
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall()
{
/*
plugins - Plugins
*/
$data = <<<EOD
plugins: ID int(10) unsigned NOT NULL auto_increment
plugins: TITLE varchar(255) NOT NULL DEFAULT ''
plugins: MODULE_NAME varchar(255) NOT NULL DEFAULT ''
plugins: REPOSITORY_URL char(255) NOT NULL DEFAULT ''
plugins: AUTHOR varchar(255) NOT NULL DEFAULT ''
plugins: SUPPORT_URL char(255) NOT NULL DEFAULT ''
plugins: DESCRIPTION_RU text
plugins: DESCRIPTION_EN text
plugins: CURRENT_VERSION varchar(255) NOT NULL DEFAULT ''
plugins: LATEST_VERSION varchar(255) NOT NULL DEFAULT ''
plugins: IS_INSTALLED int(3) NOT NULL DEFAULT '0'
plugins: WHATSNEW text
plugins: LATEST_UPDATE datetime
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data)
{
/*
zwave_devices - Z-Wave
zwave_properties - Properties
*/
$data = <<<EOD
zwave_devices: ID int(10) unsigned NOT NULL auto_increment
zwave_devices: TITLE varchar(255) NOT NULL DEFAULT ''
zwave_devices: NODE_ID varchar(50) NOT NULL DEFAULT ''
zwave_devices: INSTANCE_ID varchar(50) NOT NULL DEFAULT ''
zwave_devices: BASIC varchar(50) NOT NULL DEFAULT ''
zwave_devices: LEVEL varchar(50) NOT NULL DEFAULT ''
zwave_devices: BATTERY_LEVEL varchar(50) NOT NULL DEFAULT ''
zwave_devices: SENSOR_VALUE varchar(255) NOT NULL DEFAULT ''
zwave_devices: MODE_VALUE varchar(255) NOT NULL DEFAULT ''
zwave_devices: DEVICE_TYPE varchar(50) NOT NULL DEFAULT ''
zwave_devices: STATUS int(3) NOT NULL DEFAULT '0'
zwave_devices: AUTO_POLL int(3) NOT NULL DEFAULT '0'
zwave_devices: LATEST_UPDATE datetime
zwave_devices: LOCATION_ID int(10) NOT NULL DEFAULT '0'
zwave_devices: CLASS_BASIC int(3) NOT NULL DEFAULT '0'
zwave_devices: CLASS_SENSOR_BINARY int(3) NOT NULL DEFAULT '0'
zwave_devices: CLASS_SENSOR_MULTILEVEL int(3) NOT NULL DEFAULT '0'
zwave_devices: CLASS_SWITCH_BINARY int(3) NOT NULL DEFAULT '0'
zwave_devices: CLASS_SWITCH_MULTILEVEL int(3) NOT NULL DEFAULT '0'
zwave_devices: CLASS_METER int(3) NOT NULL DEFAULT '0'
zwave_devices: CLASS_BATTERY int(3) NOT NULL DEFAULT '0'
zwave_devices: CLASS_THERMOSTAT int(3) NOT NULL DEFAULT '0'
zwave_devices: CLASS_SENSOR_ALARM int(3) NOT NULL DEFAULT '0'
zwave_devices: CLASS_SCENE_CONTROLLER int(3) NOT NULL DEFAULT '0'
zwave_devices: CLASS_CONFIG int(3) NOT NULL DEFAULT '0'
zwave_devices: ALL_CLASSES varchar(255) NOT NULL DEFAULT ''
zwave_devices: BRAND varchar(255) NOT NULL DEFAULT ''
zwave_devices: PRODUCT varchar(255) NOT NULL DEFAULT ''
zwave_devices: XMLFILE varchar(255) NOT NULL DEFAULT ''
zwave_devices: RAW_DATA text NOT NULL DEFAULT ''
zwave_properties: ID int(10) unsigned NOT NULL auto_increment
zwave_properties: DEVICE_ID int(10) NOT NULL DEFAULT '0'
zwave_properties: UNIQ_ID varchar(100) NOT NULL DEFAULT ''
zwave_properties: TITLE varchar(255) NOT NULL DEFAULT ''
zwave_properties: COMMENTS varchar(255) NOT NULL DEFAULT ''
zwave_properties: VALUE varchar(255) NOT NULL DEFAULT ''
zwave_properties: VALUE_TYPE varchar(255) NOT NULL DEFAULT ''
zwave_properties: READ_ONLY int(3) NOT NULL DEFAULT '0'
zwave_properties: UPDATE_PERIOD int(10) NOT NULL DEFAULT '0'
zwave_properties: VALIDATE int(3) NOT NULL DEFAULT '0'
zwave_properties: VALID_FROM varchar(10) NOT NULL DEFAULT ''
zwave_properties: VALID_TO varchar(10) NOT NULL DEFAULT ''
zwave_properties: CORRECT_VALUE varchar(10) NOT NULL DEFAULT ''
zwave_properties: COMMAND_CLASS varchar(10) NOT NULL DEFAULT ''
zwave_properties: LINKED_OBJECT varchar(255) NOT NULL DEFAULT ''
zwave_properties: LINKED_PROPERTY varchar(255) NOT NULL DEFAULT ''
zwave_properties: LINKED_METHOD varchar(255) NOT NULL DEFAULT ''
zwave_properties: UPDATED datetime
zwave_properties: NEXT_UPDATE datetime
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data)
{
/*
pinghosts - Pinghosts
*/
$data = <<<EOD
pinghosts: ID int(10) unsigned NOT NULL auto_increment
pinghosts: TITLE varchar(255) NOT NULL DEFAULT ''
pinghosts: HOSTNAME varchar(255) NOT NULL DEFAULT ''
pinghosts: TYPE int(30) NOT NULL DEFAULT '0'
pinghosts: STATUS int(3) NOT NULL DEFAULT '0'
pinghosts: SEARCH_WORD varchar(255) NOT NULL DEFAULT ''
pinghosts: CHECK_LATEST datetime
pinghosts: CHECK_NEXT datetime
pinghosts: SCRIPT_ID_ONLINE int(10) NOT NULL DEFAULT '0'
pinghosts: CODE_ONLINE text
pinghosts: SCRIPT_ID_OFFLINE int(10) NOT NULL DEFAULT '0'
pinghosts: CODE_OFFLINE text
pinghosts: OFFLINE_INTERVAL int(10) NOT NULL DEFAULT '0'
pinghosts: ONLINE_INTERVAL int(10) NOT NULL DEFAULT '0'
pinghosts: LINKED_OBJECT varchar(255) NOT NULL DEFAULT ''
pinghosts: LINKED_PROPERTY varchar(255) NOT NULL DEFAULT ''
pinghosts: COUNTER_CURRENT int(10) NOT NULL DEFAULT '0'
pinghosts: COUNTER_REQUIRED int(10) NOT NULL DEFAULT '0'
pinghosts: STATUS_EXPECTED int(3) NOT NULL DEFAULT '0'
pinghosts: LOG text
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data)
{
/*
gpslog - Log
gpslocations - Locations
gpsdevices - Devices
gpsactions - Actions
*/
$data = <<<EOD
gpslog: ID int(10) unsigned NOT NULL auto_increment
gpslog: ADDED datetime
gpslog: LAT float DEFAULT '0' NOT NULL
gpslog: LON float DEFAULT '0' NOT NULL
gpslog: ALT float DEFAULT '0' NOT NULL
gpslog: PROVIDER varchar(30) NOT NULL DEFAULT ''
gpslog: SPEED float DEFAULT '0' NOT NULL
gpslog: BATTLEVEL int(3) NOT NULL DEFAULT '0'
gpslog: CHARGING int(3) NOT NULL DEFAULT '0'
gpslog: DEVICEID varchar(255) NOT NULL DEFAULT ''
gpslog: DEVICE_ID int(10) NOT NULL DEFAULT '0'
gpslog: LOCATION_ID int(10) NOT NULL DEFAULT '0'
gpslog: ACCURACY float DEFAULT '0' NOT NULL
gpslog: INDEX (DEVICE_ID)
gpslog: INDEX (LOCATION_ID)
gpslocations: ID int(10) unsigned NOT NULL auto_increment
gpslocations: TITLE varchar(255) NOT NULL DEFAULT ''
gpslocations: LAT float DEFAULT '0' NOT NULL
gpslocations: LON float DEFAULT '0' NOT NULL
gpslocations: RANGE float DEFAULT '0' NOT NULL
gpslocations: VIRTUAL_USER_ID int(10) NOT NULL DEFAULT '0'
gpsdevices: ID int(10) unsigned NOT NULL auto_increment
gpsdevices: TITLE varchar(255) NOT NULL DEFAULT ''
gpsdevices: USER_ID int(10) NOT NULL DEFAULT '0'
gpsdevices: LAT varchar(255) NOT NULL DEFAULT ''
gpsdevices: LON varchar(255) NOT NULL DEFAULT ''
gpsdevices: UPDATED datetime
gpsdevices: DEVICEID varchar(255) NOT NULL DEFAULT ''
gpsdevices: INDEX (USER_ID)
gpsactions: ID int(10) unsigned NOT NULL auto_increment
gpsactions: LOCATION_ID int(10) NOT NULL DEFAULT '0'
gpsactions: USER_ID int(10) NOT NULL DEFAULT '0'
gpsactions: ACTION_TYPE int(255) NOT NULL DEFAULT '0'
gpsactions: SCRIPT_ID int(10) NOT NULL DEFAULT '0'
gpsactions: CODE text
gpsactions: LOG text
gpsactions: EXECUTED datetime
gpsactions: INDEX (LOCATION_ID)
gpsactions: INDEX (USER_ID)
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data)
{
/*
usbdevices - usbdevices
*/
$data = <<<EOD
usbdevices: ID int(10) unsigned NOT NULL auto_increment
usbdevices: TITLE varchar(255) NOT NULL DEFAULT ''
usbdevices: SERIAL varchar(255) NOT NULL DEFAULT ''
usbdevices: LOG text NOT NULL DEFAULT ''
usbdevices: SCRIPT text NOT NULL DEFAULT ''
usbdevices: SCRIPT_ID int(10) unsigned NOT NULL DEFAULT '0'
usbdevices: LAST_FOUND datetime
usbdevices: FIRST_FOUND datetime
usbdevices: USER_ID int(10) NOT NULL DEFAULT '0'
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data)
{
/*
watchfolders - Watchfolders
*/
$data = <<<EOD
watchfolders: ID int(10) unsigned NOT NULL auto_increment
watchfolders: TITLE varchar(255) NOT NULL DEFAULT ''
watchfolders: FOLDER varchar(255) NOT NULL DEFAULT ''
watchfolders: CHECK_MASK varchar(255) NOT NULL DEFAULT ''
watchfolders: CHECK_LATEST datetime
watchfolders: CHECK_NEXT datetime
watchfolders: CHECK_INTERVAL int(255) NOT NULL DEFAULT '0'
watchfolders: SCRIPT_ID int(10) NOT NULL DEFAULT '0'
watchfolders: CHECK_SUB int(3) NOT NULL DEFAULT '0'
watchfolders: SCRIPT_TYPE int(255) NOT NULL DEFAULT '0'
watchfolders: CHECK_RESULTS longtext
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data)
{
/*
scenes - Scenes
elements - Elements
elm_states - Element states
*/
$data = <<<EOD
scenes: ID int(10) unsigned NOT NULL auto_increment
scenes: TITLE varchar(255) NOT NULL DEFAULT ''
scenes: BACKGROUND varchar(255) NOT NULL DEFAULT ''
scenes: WALLPAPER varchar(255) NOT NULL DEFAULT ''
scenes: PRIORITY int(10) NOT NULL DEFAULT '0'
scenes: HIDDEN int(3) NOT NULL DEFAULT '0'
scenes: WALLPAPER_FIXED int(3) NOT NULL DEFAULT '0'
scenes: WALLPAPER_NOREPEAT int(3) NOT NULL DEFAULT '0'
elements: ID int(10) unsigned NOT NULL auto_increment
elements: SCENE_ID int(10) NOT NULL DEFAULT '0'
elements: TITLE varchar(255) NOT NULL DEFAULT ''
elements: TYPE varchar(255) NOT NULL DEFAULT ''
elements: CSS_STYLE varchar(255) NOT NULL DEFAULT ''
elements: TOP int(10) NOT NULL DEFAULT '0'
elements: LEFT int(10) NOT NULL DEFAULT '0'
elements: WIDTH int(10) NOT NULL DEFAULT '0'
elements: HEIGHT int(10) NOT NULL DEFAULT '0'
elements: DX int(10) NOT NULL DEFAULT '0'
elements: DY int(10) NOT NULL DEFAULT '0'
elements: POSITION_TYPE int(3) NOT NULL DEFAULT '0'
elements: LINKED_ELEMENT_ID int(10) NOT NULL DEFAULT '0'
elements: CONTAINER_ID int(10) NOT NULL DEFAULT '0'
elements: CROSS_SCENE int(3) NOT NULL DEFAULT '0'
elements: BACKGROUND int(3) NOT NULL DEFAULT '0'
elements: PRIORITY int(10) NOT NULL DEFAULT '0'
elements: JAVASCRIPT text
elements: CSS text
elm_states: ID int(10) unsigned NOT NULL auto_increment
elm_states: ELEMENT_ID int(10) NOT NULL DEFAULT '0'
elm_states: TITLE varchar(255) NOT NULL DEFAULT ''
elm_states: IMAGE varchar(255) NOT NULL DEFAULT ''
elm_states: HTML text
elm_states: IS_DYNAMIC int(3) NOT NULL DEFAULT '0'
elm_states: CURRENT_STATE int(3) NOT NULL DEFAULT '0'
elm_states: LINKED_OBJECT varchar(255) NOT NULL DEFAULT ''
elm_states: LINKED_PROPERTY varchar(255) NOT NULL DEFAULT ''
elm_states: ACTION_OBJECT varchar(255) NOT NULL DEFAULT ''
elm_states: ACTION_METHOD varchar(255) NOT NULL DEFAULT ''
elm_states: CONDITION int(3) NOT NULL DEFAULT '0'
elm_states: CONDITION_VALUE varchar(255) NOT NULL DEFAULT ''
elm_states: CONDITION_ADVANCED text
elm_states: CODE text
elm_states: SCRIPT_ID int(10) NOT NULL DEFAULT '0'
elm_states: MENU_ITEM_ID int(10) NOT NULL DEFAULT '0'
elm_states: HOMEPAGE_ID int(10) NOT NULL DEFAULT '0'
elm_states: OPEN_SCENE_ID int(10) NOT NULL DEFAULT '0'
elm_states: EXT_URL varchar(255) NOT NULL DEFAULT ''
elm_states: WINDOW_POSX int(10) NOT NULL DEFAULT '0'
elm_states: WINDOW_POSY int(10) NOT NULL DEFAULT '0'
elm_states: WINDOW_WIDTH int(10) NOT NULL DEFAULT '0'
elm_states: WINDOW_HEIGHT int(10) NOT NULL DEFAULT '0'
elm_states: SWITCH_SCENE int(3) NOT NULL DEFAULT '0'
elm_states: CURRENT_STATUS int(3) NOT NULL DEFAULT '0'
elm_states: PRIORITY int(10) NOT NULL DEFAULT '0'
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall() {
/*
scenes - Scenes
elements - Elements
elm_states - Element states
*/
$data = <<<EOD
scenes: ID int(10) unsigned NOT NULL auto_increment
scenes: TITLE varchar(255) NOT NULL DEFAULT ''
scenes: BACKGROUND varchar(255) NOT NULL DEFAULT ''
scenes: PRIORITY int(10) NOT NULL DEFAULT '0'
elements: ID int(10) unsigned NOT NULL auto_increment
elements: SCENE_ID int(10) NOT NULL DEFAULT '0'
elements: TITLE varchar(255) NOT NULL DEFAULT ''
elements: TYPE varchar(255) NOT NULL DEFAULT ''
elements: TOP int(10) NOT NULL DEFAULT '0'
elements: LEFT int(255) NOT NULL DEFAULT '0'
elements: WIDTH int(255) NOT NULL DEFAULT '0'
elements: HEIGHT int(255) NOT NULL DEFAULT '0'
elements: CROSS_SCENE int(3) NOT NULL DEFAULT '0'
elm_states: ID int(10) unsigned NOT NULL auto_increment
elm_states: ELEMENT_ID int(10) NOT NULL DEFAULT '0'
elm_states: TITLE varchar(255) NOT NULL DEFAULT ''
elm_states: IMAGE varchar(255) NOT NULL DEFAULT ''
elm_states: HTML text
elm_states: IS_DYNAMIC int(3) NOT NULL DEFAULT '0'
elm_states: CURRENT_STATE int(3) NOT NULL DEFAULT '0'
elm_states: LINKED_OBJECT varchar(255) NOT NULL DEFAULT ''
elm_states: LINKED_PROPERTY varchar(255) NOT NULL DEFAULT ''
elm_states: CONDITION int(3) NOT NULL DEFAULT '0'
elm_states: CONDITION_VALUE varchar(255) NOT NULL DEFAULT ''
elm_states: CONDITION_ADVANCED text
elm_states: SCRIPT_ID int(10) NOT NULL DEFAULT '0'
elm_states: SWITCH_SCENE int(3) NOT NULL DEFAULT '0'
elm_states: CURRENT_STATUS int(3) NOT NULL DEFAULT '0'
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall()
{
/*
myblocks - Myblocks
myblocks_categories - Myblocks Categories
*/
$data = <<<EOD
myblocks: ID int(10) unsigned NOT NULL auto_increment
myblocks: TITLE varchar(255) NOT NULL DEFAULT ''
myblocks: CATEGORY_ID int(10) NOT NULL DEFAULT '0'
myblocks: BLOCK_TYPE char(10) NOT NULL DEFAULT ''
myblocks: BLOCK_COLOR int(10) NOT NULL DEFAULT '0'
myblocks: SCRIPT_ID int(10) NOT NULL DEFAULT '0'
myblocks: LINKED_OBJECT varchar(255) NOT NULL DEFAULT ''
myblocks: LINKED_PROPERTY varchar(255) NOT NULL DEFAULT ''
myblocks_categories: ID int(10) unsigned NOT NULL auto_increment
myblocks_categories: TITLE varchar(255) NOT NULL DEFAULT ''
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data)
{
/*
classes - Classes
*/
$data = <<<EOD
classes: ID int(10) unsigned NOT NULL auto_increment
classes: TITLE varchar(255) NOT NULL DEFAULT ''
classes: PARENT_ID int(10) NOT NULL DEFAULT '0'
classes: NOLOG int(3) NOT NULL DEFAULT '0'
classes: SUB_LIST text
classes: PARENT_LIST text
classes: DESCRIPTION text
classes: INDEX (PARENT_ID)
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data)
{
/*
onewire - onewire
*/
$data = <<<EOD
owdevices: ID int(10) unsigned NOT NULL auto_increment
owdevices: TITLE varchar(255) NOT NULL DEFAULT ''
owdevices: UDID varchar(255) NOT NULL DEFAULT ''
owdevices: STATUS int(3) NOT NULL DEFAULT '0'
owdevices: CHECK_LATEST datetime
owdevices: CHECK_NEXT datetime
owdevices: SCRIPT_ID int(10) NOT NULL DEFAULT '0'
owdevices: CODE text
owdevices: ONLINE_INTERVAL int(10) NOT NULL DEFAULT '0'
owdevices: LOG text
owproperties: ID int(10) unsigned NOT NULL auto_increment
owproperties: DEVICE_ID int(10) unsigned NOT NULL DEFAULT '0'
owproperties: SYSNAME varchar(255) NOT NULL DEFAULT ''
owproperties: PATH varchar(255) NOT NULL DEFAULT ''
owproperties: VALUE varchar(255) NOT NULL DEFAULT ''
owproperties: CHECK_LATEST datetime
owproperties: UPDATED datetime
owproperties: STARRED int(3) unsigned NOT NULL DEFAULT '0'
owproperties: LINKED_OBJECT varchar(255) NOT NULL DEFAULT ''
owproperties: LINKED_PROPERTY varchar(255) NOT NULL DEFAULT ''
owdisplays: ID int(10) unsigned NOT NULL auto_increment
owdisplays: UDID int(10) unsigned NOT NULL DEFAULT '0'
owdisplays: TITLE varchar(255) NOT NULL DEFAULT ''
owdisplays: ROWS int(3) unsigned NOT NULL DEFAULT '0'
owdisplays: COLS int(3) unsigned NOT NULL DEFAULT '0'
owdisplays: UPDATE_INTERVAL int(10) unsigned NOT NULL DEFAULT '0'
owdisplays: VALUE text
owdisplays: UPDATE_LATEST int(10) unsigned NOT NULL DEFAULT '0'
owdisplays: UPDATE_NEXT int(10) unsigned NOT NULL DEFAULT '0'
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data)
{
$data = <<<EOD
// (description:settings) Web-site settings table
settings: ID int(10) unsigned NOT NULL auto_increment // Record ID
settings: PRIORITY int(3) unsigned NOT NULL DEFAULT '0' // Setting Priority
settings: HR int(3) unsigned NOT NULL DEFAULT '0' // Separator flag (1=<hr>)
settings: TITLE varchar(255) NOT NULL DEFAULT '' // Setting Title
settings: NAME varchar(50) NOT NULL DEFAULT '' // Setting system name
settings: TYPE varchar(59) NOT NULL DEFAULT '' // Setting value type
settings: NOTES text NOT NULL DEFAULT '' // Setting Notes / Description
settings: DATA text NOT NULL DEFAULT '' // Additional data
settings: VALUE varchar(255) NOT NULL DEFAULT '' // Setting Value
settings: DEFAULTVALUE varchar(255) NOT NULL DEFAULT '' // Setting Default Value
settings: URL varchar(255) NOT NULL DEFAULT '' // URL for more details
settings: URL_TITLE varchar(255) NOT NULL DEFAULT '' // URL description
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data)
{
/*
webvars - webvars
*/
$data = <<<EOD
webvars: ID int(10) unsigned NOT NULL auto_increment
webvars: TITLE varchar(255) NOT NULL DEFAULT ''
webvars: HOSTNAME varchar(255) NOT NULL DEFAULT ''
webvars: TYPE int(30) NOT NULL DEFAULT '0'
webvars: SEARCH_PATTERN varchar(255) NOT NULL DEFAULT ''
webvars: CHECK_PATTERN varchar(255) NOT NULL DEFAULT ''
webvars: LATEST_VALUE text NOT NULL DEFAULT ''
webvars: CHECK_LATEST datetime
webvars: CHECK_NEXT datetime
webvars: SCRIPT_ID int(10) NOT NULL DEFAULT '0'
webvars: ONLINE_INTERVAL int(10) NOT NULL DEFAULT '0'
webvars: LINKED_OBJECT varchar(255) NOT NULL DEFAULT ''
webvars: LINKED_PROPERTY varchar(255) NOT NULL DEFAULT ''
webvars: ENCODING varchar(50) NOT NULL DEFAULT ''
webvars: AUTH int(3) NOT NULL DEFAULT '0'
webvars: USERNAME varchar(100) NOT NULL DEFAULT ''
webvars: PASSWORD varchar(100) NOT NULL DEFAULT ''
webvars: CODE text
webvars: LOG text
EOD;
parent::dbInstall($data);
}
function dbInstall() {
/*
terminals - Terminals
*/
$data = <<<EOD
collections: ID int(10) unsigned NOT NULL auto_increment
collections: PATH varchar(255) NOT NULL DEFAULT ''
collections: TITLE varchar(255) NOT NULL DEFAULT ''
media_favorites: ID int(10) unsigned NOT NULL auto_increment
media_favorites: PATH varchar(255) NOT NULL DEFAULT ''
media_favorites: TITLE varchar(255) NOT NULL DEFAULT ''
media_favorites: LIST_ID int(10) unsigned NOT NULL DEFAULT '0'
media_favorites: COLLECTION_ID int(10) unsigned NOT NULL DEFAULT '0'
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data)
{
/*
history - History
*/
$data = <<<EOD
history: ID int(10) unsigned NOT NULL auto_increment
history: ADDED datetime
history: OBJECT_ID int(10) NOT NULL DEFAULT '0'
history: METHOD_ID int(10) NOT NULL DEFAULT '0'
history: VALUE_ID int(10) NOT NULL DEFAULT '0'
history: OLD_VALUE varchar(255) NOT NULL DEFAULT ''
history: NEW_VALUE varchar(255) NOT NULL DEFAULT ''
history: DETAILS text
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall() {
/*
shouts - Shoutbox
*/
$data = <<<EOD
shouts: ID int(10) unsigned NOT NULL auto_increment
shouts: ROOM_ID int(10) NOT NULL DEFAULT '0'
shouts: MEMBER_ID int(10) NOT NULL DEFAULT '0'
shouts: MESSAGE varchar(255) NOT NULL DEFAULT ''
shouts: IMPORTANCE int(10) NOT NULL DEFAULT '0'
shouts: ADDED datetime
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data)
{
/*
rss_channels - RSS Channels
rss_items - RSS Items
*/
$data = <<<EOD
rss_channels: ID int(10) unsigned NOT NULL auto_increment
rss_channels: TITLE varchar(255) NOT NULL DEFAULT ''
rss_channels: URL char(255) NOT NULL DEFAULT ''
rss_channels: NEXT_UPDATE datetime
rss_channels: LAST_UPDATE datetime
rss_channels: UPDATE_EVERY int(10) NOT NULL DEFAULT '0'
rss_channels: SCRIPT_ID int(10) NOT NULL DEFAULT '0'
rss_items: ID int(10) unsigned NOT NULL auto_increment
rss_items: CHANNEL_ID int(10) unsigned NOT NULL DEFAULT '0'
rss_items: TITLE varchar(255) NOT NULL DEFAULT ''
rss_items: BODY text
rss_items: URL char(255) NOT NULL DEFAULT ''
rss_items: GUID varchar(255) NOT NULL DEFAULT ''
rss_items: ADDED varchar(255) NOT NULL DEFAULT ''
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall() {
/*
methods - Methods
*/
$data = <<<EOD
methods: ID int(10) unsigned NOT NULL auto_increment
methods: OBJECT_ID int(10) NOT NULL DEFAULT '0'
methods: CLASS_ID int(10) NOT NULL DEFAULT '0'
methods: CALL_PARENT int(3) NOT NULL DEFAULT '0'
methods: TITLE varchar(255) NOT NULL DEFAULT ''
methods: DESCRIPTION text
methods: CODE text
methods: SCRIPT_ID int(10) NOT NULL DEFAULT '0'
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data)
{
/*
jobs - jobs
*/
$data = <<<EOD
jobs: ID int(10) unsigned NOT NULL auto_increment
jobs: TITLE varchar(255) NOT NULL DEFAULT ''
jobs: COMMANDS text NOT NULL DEFAULT ''
jobs: RUNTIME datetime
jobs: EXPIRE datetime
jobs: STARTED datetime
jobs: PROCESSED int(3) NOT NULL DEFAULT '0'
jobs: EXPIRED int(3) NOT NULL DEFAULT '0'
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data)
{
/*
btdevices - btdevices
*/
$data = <<<EOD
btdevices: ID int(10) unsigned NOT NULL auto_increment
btdevices: TITLE varchar(255) NOT NULL DEFAULT ''
btdevices: MAC varchar(255) NOT NULL DEFAULT ''
btdevices: LOG text NOT NULL DEFAULT ''
btdevices: LAST_FOUND datetime
btdevices: FIRST_FOUND datetime
btdevices: SCRIPT_ID int(10) NOT NULL DEFAULT '0'
btdevices: USER_ID int(10) NOT NULL DEFAULT '0'
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall() {
/*
layouts - Layouts
*/
$data = <<<EOD
layouts: ID int(10) unsigned NOT NULL auto_increment
layouts: TITLE varchar(255) NOT NULL DEFAULT ''
layouts: PRIORITY int(10) NOT NULL DEFAULT '0'
layouts: TYPE varchar(255) NOT NULL DEFAULT ''
layouts: CODE text
layouts: APP varchar(255) NOT NULL DEFAULT ''
layouts: URL char(255) NOT NULL DEFAULT ''
layouts: DETAILS text
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data)
{
/*
events - Events
*/
$data = <<<EOD
events: ID int(10) unsigned NOT NULL auto_increment
events: EVENT_NAME varchar(255) NOT NULL DEFAULT ''
events: EVENT_TYPE char(10) NOT NULL DEFAULT ''
events: TERMINAL_FROM varchar(255) NOT NULL DEFAULT ''
events: TERMINAL_TO varchar(255) NOT NULL DEFAULT ''
events: USER_FROM varchar(255) NOT NULL DEFAULT ''
events: USER_TO varchar(255) NOT NULL DEFAULT ''
events: WINDOW varchar(255) NOT NULL DEFAULT ''
events: DETAILS text
events: ADDED datetime
events: EXPIRE datetime
events: PROCESSED int(3) NOT NULL DEFAULT '0'
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall() {
/*
terminals - Terminals
*/
$data = <<<EOD
terminals: ID int(10) unsigned NOT NULL auto_increment
terminals: NAME varchar(255) NOT NULL DEFAULT ''
terminals: HOST varchar(255) NOT NULL DEFAULT ''
terminals: TITLE varchar(255) NOT NULL DEFAULT ''
terminals: CANPLAY int(3) NOT NULL DEFAULT '0'
terminals: PLAYER_TYPE char(10) NOT NULL DEFAULT ''
terminals: PLAYER_PORT varchar(255) NOT NULL DEFAULT ''
terminals: PLAYER_USERNAME varchar(255) NOT NULL DEFAULT ''
terminals: PLAYER_PASSWORD varchar(255) NOT NULL DEFAULT ''
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data)
{
/*
products - Products
product_categories - Categories
shopping_list_items - Shopping List
*/
$data = <<<EOD
products: ID int(10) unsigned NOT NULL auto_increment
products: TITLE varchar(255) NOT NULL DEFAULT ''
products: CATEGORY_ID int(10) NOT NULL DEFAULT '0'
products: IMAGE varchar(70) NOT NULL DEFAULT ''
products: WILL_EXPIRE int(3) NOT NULL DEFAULT '0'
products: EXPIRE_DATE date
products: EXPIRE_DEFAULT int(10) NOT NULL DEFAULT '0'
products: UPDATED datetime
products: QTY int(10) NOT NULL DEFAULT '0'
products: MIN_QTY int(10) NOT NULL DEFAULT '0'
products: DETAILS text
products: DEFAULT_PRICE float DEFAULT '0' NOT NULL
product_categories: ID int(10) unsigned NOT NULL auto_increment
product_categories: TITLE varchar(255) NOT NULL DEFAULT ''
product_categories: PRIORITY int(10) NOT NULL DEFAULT '0'
product_categories: PARENT_ID int(10) NOT NULL DEFAULT '0'
product_categories: SUB_LIST text
product_categories: PARENT_LIST text
shopping_list_items: ID int(10) unsigned NOT NULL auto_increment
shopping_list_items: TITLE varchar(255) NOT NULL DEFAULT ''
shopping_list_items: PRODUCT_ID int(10) NOT NULL DEFAULT '0'
shopping_list_items: PRICE float DEFAULT '0' NOT NULL
shopping_list_items: CODE varchar(255) NOT NULL DEFAULT ''
shopping_list_items: IN_CART int(3) NOT NULL DEFAULT '0'
product_log: ID int(10) unsigned NOT NULL auto_increment
product_log: TITLE varchar(255) NOT NULL DEFAULT ''
product_log: PRODUCT_ID int(10) NOT NULL DEFAULT '0'
product_log: CODE_ID int(10) NOT NULL DEFAULT '0'
product_log: QTY int(10) NOT NULL DEFAULT '0'
product_log: ACTION char(10) NOT NULL DEFAULT ''
product_log: UPDATED datetime
product_codes: ID int(10) unsigned NOT NULL auto_increment
product_codes: TITLE varchar(255) NOT NULL DEFAULT ''
product_codes: CODE varchar(255) NOT NULL DEFAULT ''
product_codes: PRODUCT_ID int(10) NOT NULL DEFAULT '0'
EOD;
parent::dbInstall($data);
}
/**
* dbInstall
*
* Database installation routine
*
* @access private
*/
function dbInstall($data)
{
/*
locations - Locations
*/
$data = <<<EOD
locations: ID int(10) unsigned NOT NULL auto_increment
locations: TITLE varchar(255) NOT NULL DEFAULT ''
EOD;
parent::dbInstall($data);
}
