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

Diff of /contributions/modules/addressbook/addressbook.install

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

revision 1.3 by wplaat, Fri Sep 7 14:02:01 2007 UTC revision 1.4 by wplaat, Wed Sep 16 18:41:09 2009 UTC
# Line 1  Line 1 
1  <?php  <?php
2  // $Id: addressbook.install,v 1.2 2006/10/03 19:44:01 wplaat Exp $  // $Id: addressbook.install,v 1.3 2007/09/07 14:02:01 wplaat Exp $
3    
4  /**  /**
5   * Install the initial schema.   * Install the initial schema.
# Line 63  CREATE TABLE `addressbook_picture` ( Line 63  CREATE TABLE `addressbook_picture` (
63    }    }
64  }  }
65    
66    function addressbook_update_5300() {
67      switch ($GLOBALS['db_type']) {
68        case 'mysql':
69        case 'mysqli':
70    
71    db_query("
72    CREATE TABLE `addressbook_extention` (
73      `MID` int(11) NOT NULL COMMENT 'Member ID',
74      `STATUS` varchar(50) default NULL,
75      `REGION_NAME` date default NULL,
76      `SECTION` varchar(20) default NULL,
77      `SEX` varchar(10) default NULL,
78      `BIRTH_PLACE` varchar(50) default NULL,
79      `COVERMANCE_STATE` varchar(50) default NULL,
80      `CHURCH_STATE` varchar(50) default NULL,
81      `WANTED_ROLES` varchar(200) default NULL,
82      `UID` int(11) default NULL COMMENT 'User ID',
83      `FID` int(11) default NULL COMMENT 'Family ID',
84      `LAST_UPDATED` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
85      `MIDDLE_NAME` varchar(10) default NULL,
86      `LAST_NAME` varchar(50) default NULL,
87      PRIMARY KEY  (`MID`)
88    ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
89        ");
90    
91          break;
92      }
93    }
94    
95    
96  /**  /**
Legend:
Removed from v.1.3  
changed lines
  Added in v.1.4
  ViewVC Help
Powered by ViewVC 1.1.3