Project

General

Profile

Download (1.54 KB) Statistics
| Branch: | Tag: | Revision:
1
<?php
2
// $Id$
3

    
4
/**
5
 * Implementation of hook_install().
6
 */
7
function cdm_api_install(){
8
  
9
  db_query("CREATE TABLE {cache_cdm_ws} (
10
    cid varchar(255) NOT NULL default '', -- max key length in some cases is only 767 byte ~ varchar(255)
11
    data longblob,
12
    expire int NOT NULL default '0',
13
    created int NOT NULL default '0',
14
    headers text,
15
    PRIMARY KEY (cid),
16
    INDEX expire (expire)
17
    ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
18
    
19
  db_query(_get_sql_create_nodecdm());
20
  db_query(_get_sql_fix_watchdog());
21
}
22

    
23
/**
24
 * Implementation of hook_uninstall().
25
 */
26
function cdm_api_uninstall(){
27
    db_query("DROP TABLE {cache_cdm_ws};");
28
    //TODO delete all cdm nodes using node_delete()    
29
    db_query("DROP TABLE {node_cdm};");
30

    
31
}
32

    
33
/**
34
 * Implementation of hook_api_update_N().
35
 * 
36
 * Update 1 for version 5.x-1.0
37
 */
38
function cdm_api_update_5101() {
39
  $items = array();
40
  $items[] = update_sql(_get_sql_create_nodecdm());
41
  $items[] = update_sql(_get_sql_fix_watchdog());
42
  return $items;
43
}
44

    
45
// ------------------------- SQL  Scripts ------------------------ // 
46

    
47
function _get_sql_create_nodecdm() {
48
  return "
49
    CREATE TABLE {node_cdm} (
50
      `nid` int(11) NOT NULL,
51
      `wsuri` varchar(255) default NULL,
52
      `cdmtype` varchar(255) default NULL,
53
      `uuid` varchar(255) default NULL,
54
      PRIMARY KEY  (`uuid`)
55
    ) /*!40100 DEFAULT CHARACTER SET UTF8 */  
56
    ";
57
}
58

    
59
function _get_sql_fix_watchdog() {
60
  return  "ALTER TABLE {watchdog} CHANGE referer referer TEXT NOT NULL ;";
61
}
(3-3/9)