modules/node_annotate/node_annotate.install

<?php
// $Id: node_annotate.install,v 1.2 2008/02/08 20:55:52 tc1415 Exp $

/**
 * Implementation of hook_install
 */
function node_annotate_install() {
  $sql = 'CREATE TABLE {node_annotate} (
`vid` INT(10) NOT NULL,
`nid` INT(10) NOT NULL,
`description` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`annotations` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`vid`),
INDEX (`nid`));';

  db_query($sql);
}

/**
 * Implmentation of hook_uninstall
 */
function node_annotate_uninstall() {
  $sql = 'DROP TABLE {node_annotate}';
  db_query($sql);
}

/**
 * First update
 *
 * Fixes incorrect collations
 */
function node_annotate_update_1() {
  $sql = 'ALTER TABLE {node_annotate}
CHANGE `annotation` `annotation` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
CHANGE `lines` `lines` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL';

  $return[] = update_sql($sql);

  return $return;
}

/**
 * Second Update
 *
 * Rename Annotation -> Description
 *   "    Lines      -> Annotations
 */
function node_annotate_update_2() {
  $sql = 'ALTER TABLE {node_annotate}
CHANGE `annotation` `description` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
CHANGE `lines` `annotations` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL';

  $return[] = update_sql($sql);

  return $return;
}
1	<?php
2	// $Id: node_annotate.install,v 1.2 2008/02/08 20:55:52 tc1415 Exp $
3
4	/**
5	* Implementation of hook_install
6	*/
7	function node_annotate_install() {
8	$sql = 'CREATE TABLE {node_annotate} (
9	`vid` INT(10) NOT NULL,
10	`nid` INT(10) NOT NULL,
11	`description` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
12	`annotations` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
13	PRIMARY KEY (`vid`),
14	INDEX (`nid`));';
15
16	db_query($sql);
17	}
18
19	/**
20	* Implmentation of hook_uninstall
21	*/
22	function node_annotate_uninstall() {
23	$sql = 'DROP TABLE {node_annotate}';
24	db_query($sql);
25	}
26
27	/**
28	* First update
29	*
30	* Fixes incorrect collations
31	*/
32	function node_annotate_update_1() {
33	$sql = 'ALTER TABLE {node_annotate}
34	CHANGE `annotation` `annotation` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
35	CHANGE `lines` `lines` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL';
36
37	$return[] = update_sql($sql);
38
39	return $return;
40	}
41
42	/**
43	* Second Update
44	*
45	* Rename Annotation -> Description
46	* " Lines -> Annotations
47	*/
48	function node_annotate_update_2() {
49	$sql = 'ALTER TABLE {node_annotate}
50	CHANGE `annotation` `description` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
51	CHANGE `lines` `annotations` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL';
52
53	$return[] = update_sql($sql);
54
55	return $return;
56	}