modules/addressbook/addressbook.install

<?php
// $Id: addressbook.install,v 1.3 2007/09/07 14:02:01 wplaat Exp $

/**
 * Install the initial schema.
 */
function addressbook_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':

      db_query("
CREATE TABLE `addressbook_family` (
  `FID` int(11) NOT NULL auto_increment COMMENT 'Family ID',
  `LAST_NAME` varchar(50) default NULL,
  `MIDDLE_NAME` varchar(20) default NULL,
  `STREET` varchar(50) default NULL,
  `ZIPCODE` varchar(8) default NULL,
  `CITY` varchar(50) default NULL,
  `COUNTRY` varchar(50) default NULL,
  `TELEPHONE` varchar(20) default NULL,
  `LAST_UPDATED` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `UID` int(11) default NULL COMMENT 'User ID',
  PRIMARY KEY  (`FID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
      ");


db_query("
CREATE TABLE `addressbook_member` (
  `MID` int(11) NOT NULL auto_increment COMMENT 'Member ID',
  `FIRST_NAME` varchar(50) default NULL,
  `BIRTH_DAY` date default NULL,
  `MOBILE` varchar(20) default NULL,
  `EMAIL` varchar(50) default NULL,
  `NOTES` varchar(1000) default NULL,
  `WORK` varchar(1000) default NULL,
  `ACTIVE_ROLES` varchar(200) default NULL,
  `WANTED_ROLES` varchar(200) default NULL,
  `UID` int(11) default NULL COMMENT 'User ID',
  `FID` int(11) default NULL COMMENT 'Family ID',
  `LAST_UPDATED` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `MIDDLE_NAME` varchar(10) default NULL,
  `LAST_NAME` varchar(50) default NULL,
  PRIMARY KEY  (`MID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
    ");

db_query("
CREATE TABLE `addressbook_picture` (
  `PID` int(11) NOT NULL auto_increment COMMENT 'Picture ID',
  `FID` int(11) NOT NULL COMMENT 'Family ID',
  `MID` int(11) NOT NULL COMMENT 'Member ID',
  `PICTURE` varchar(50) NOT NULL COMMENT 'Image filename',
  `UID` int(11) NOT NULL COMMENT 'User ID',
  `LAST_UPDATED` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`PID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
        "); 

	drupal_set_message(t("addressbook database tables created."));
      break;
  }
}

function addressbook_update_5300() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':

db_query("
CREATE TABLE `addressbook_extention` (
  `MID` int(11) NOT NULL COMMENT 'Member ID',
  `STATUS` varchar(50) default NULL,
  `REGION_NAME` date default NULL,
  `SECTION` varchar(20) default NULL,
  `SEX` varchar(10) default NULL,
  `BIRTH_PLACE` varchar(50) default NULL,
  `COVERMANCE_STATE` varchar(50) default NULL,
  `CHURCH_STATE` varchar(50) default NULL,
  `WANTED_ROLES` varchar(200) default NULL,
  `UID` int(11) default NULL COMMENT 'User ID',
  `FID` int(11) default NULL COMMENT 'Family ID',
  `LAST_UPDATED` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `MIDDLE_NAME` varchar(10) default NULL,
  `LAST_NAME` varchar(50) default NULL,
  PRIMARY KEY  (`MID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
    ");

      break;
  }
}


/**
* Implementation of hook_uninstall().
*/

function addressbook_uninstall() {
db_query('DROP TABLE {addressbook_family}');
db_query('DROP TABLE {addressbook_member}');
db_query('DROP TABLE {addressbook_picture}');
}
1	<?php
2	// $Id: addressbook.install,v 1.3 2007/09/07 14:02:01 wplaat Exp $
3
4	/**
5	* Install the initial schema.
6	*/
7	function addressbook_install() {
8	switch ($GLOBALS['db_type']) {
9	case 'mysql':
10	case 'mysqli':
11
12	db_query("
13	CREATE TABLE `addressbook_family` (
14	`FID` int(11) NOT NULL auto_increment COMMENT 'Family ID',
15	`LAST_NAME` varchar(50) default NULL,
16	`MIDDLE_NAME` varchar(20) default NULL,
17	`STREET` varchar(50) default NULL,
18	`ZIPCODE` varchar(8) default NULL,
19	`CITY` varchar(50) default NULL,
20	`COUNTRY` varchar(50) default NULL,
21	`TELEPHONE` varchar(20) default NULL,
22	`LAST_UPDATED` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
23	`UID` int(11) default NULL COMMENT 'User ID',
24	PRIMARY KEY (`FID`)
25	) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
26	");
27
28
29	db_query("
30	CREATE TABLE `addressbook_member` (
31	`MID` int(11) NOT NULL auto_increment COMMENT 'Member ID',
32	`FIRST_NAME` varchar(50) default NULL,
33	`BIRTH_DAY` date default NULL,
34	`MOBILE` varchar(20) default NULL,
35	`EMAIL` varchar(50) default NULL,
36	`NOTES` varchar(1000) default NULL,
37	`WORK` varchar(1000) default NULL,
38	`ACTIVE_ROLES` varchar(200) default NULL,
39	`WANTED_ROLES` varchar(200) default NULL,
40	`UID` int(11) default NULL COMMENT 'User ID',
41	`FID` int(11) default NULL COMMENT 'Family ID',
42	`LAST_UPDATED` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
43	`MIDDLE_NAME` varchar(10) default NULL,
44	`LAST_NAME` varchar(50) default NULL,
45	PRIMARY KEY (`MID`)
46	) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
47	");
48
49	db_query("
50	CREATE TABLE `addressbook_picture` (
51	`PID` int(11) NOT NULL auto_increment COMMENT 'Picture ID',
52	`FID` int(11) NOT NULL COMMENT 'Family ID',
53	`MID` int(11) NOT NULL COMMENT 'Member ID',
54	`PICTURE` varchar(50) NOT NULL COMMENT 'Image filename',
55	`UID` int(11) NOT NULL COMMENT 'User ID',
56	`LAST_UPDATED` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
57	PRIMARY KEY (`PID`)
58	) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
59	");
60
61	drupal_set_message(t("addressbook database tables created."));
62	break;
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	/**
97	* Implementation of hook_uninstall().
98	*/
99
100	function addressbook_uninstall() {
101	db_query('DROP TABLE {addressbook_family}');
102	db_query('DROP TABLE {addressbook_member}');
103	db_query('DROP TABLE {addressbook_picture}');
104	}