PHP module::dbInstall方法代码示例

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