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); }