/[drupal]/contributions/modules/flexinode/flexinode.install
ViewVC logotype

Diff of /contributions/modules/flexinode/flexinode.install

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.2.2.2, Fri Feb 2 12:24:57 2007 UTC revision 1.2.2.3, Fri Apr 20 07:51:25 2007 UTC
# Line 29  function flexinode_install() { Line 29  function flexinode_install() {
29          ctype_id int(10) unsigned NOT NULL default '0',          ctype_id int(10) unsigned NOT NULL default '0',
30          name varchar(255) NOT NULL default '',          name varchar(255) NOT NULL default '',
31          description varchar(255) NOT NULL default '',          description varchar(255) NOT NULL default '',
         help text NOT NULL,  
32          PRIMARY KEY ctype_id (ctype_id)          PRIMARY KEY ctype_id (ctype_id)
33        ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");        ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");
34    
# Line 67  function flexinode_install() { Line 66  function flexinode_install() {
66          ctype_id int NOT NULL default '0',          ctype_id int NOT NULL default '0',
67          name varchar(255) NOT NULL default '',          name varchar(255) NOT NULL default '',
68          description varchar(255) NOT NULL default '',          description varchar(255) NOT NULL default '',
         help text NOT NULL default '',  
69          PRIMARY KEY (ctype_id)          PRIMARY KEY (ctype_id)
70        );");        );");
71    
# Line 101  function flexinode_update_1() { Line 99  function flexinode_update_1() {
99    return _system_update_utf8(array('flexinode_data', 'flexinode_field', 'flexinode_type'));    return _system_update_utf8(array('flexinode_data', 'flexinode_field', 'flexinode_type'));
100  }  }
101    
102    function flexinode_update_2() {
103      $items = array();
104    
105      // Move helptext into variable for each flexinode type
106      $sql = "SELECT ctype_id, help FROM {flexinode_type}";
107      $result = db_query($sql);
108      $items[] = array('success' => $result !== FALSE, 'query' => check_plain($sql));
109      while ($ctype = db_fetch_object($result)) {
110        variable_set("flexinode-$ctype->ctype_id_help", variable_get("flexinode-$ctype->ctype_id_help",'').$ctype->help);
111      }
112    
113      // Drop the 'help' column. Works for both PostgreSQL and MySQL
114      $items[] = update_sql("ALTER TABLE {flexinode_type} DROP help");
115      return $items;
116    }
Legend:
Removed from v.1.2.2.2  
changed lines
  Added in v.1.2.2.3
  ViewVC Help
Powered by ViewVC 1.1.2