modules/playlist/playlist.install

<?php


/**
 * Install the initial schema.
 */
function playlist_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query(
<<<MYSQL_UPDATE
        CREATE TABLE {playlist_relate} (
          rid int(11) NOT NULL auto_increment,
          type varchar(255) NOT NULL default '',
          parent_id int(11) NOT NULL default 0,
          child_id int(11) NOT NULL default 0,
          weight int(11) default 0,
          PRIMARY KEY  (rid)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;;
MYSQL_UPDATE
      );
      break;
  }
}


/**
 * Add column for playlist type. We put audio_playlist as default for those migrating from 4.6.
 */
function playlist_update_1() {
  $items = array();
  $items[] = update_sql("ALTER TABLE {playlist_relate} ADD type varchar(255) NOT NULL default ''");
  $items[] = update_sql("UPDATE {playlist_relate} SET type = 'audio_playlist' WHERE type = ''");
  return $items;
}

/*
 * UTF 8 Conversion for 4.6 -> 4.7
 */
function playlist_update_2() {
  return _system_update_utf8(array('playlist_relate'));
}
1	<?php
2
3
4	/**
5	* Install the initial schema.
6	*/
7	function playlist_install() {
8	switch ($GLOBALS['db_type']) {
9	case 'mysql':
10	case 'mysqli':
11	db_query(
12	<<<MYSQL_UPDATE
13	CREATE TABLE {playlist_relate} (
14	rid int(11) NOT NULL auto_increment,
15	type varchar(255) NOT NULL default '',
16	parent_id int(11) NOT NULL default 0,
17	child_id int(11) NOT NULL default 0,
18	weight int(11) default 0,
19	PRIMARY KEY (rid)
20	) /!40100 DEFAULT CHARACTER SET utf8 /;;
21	MYSQL_UPDATE
22	);
23	break;
24	}
25	}
26
27
28	/**
29	* Add column for playlist type. We put audio_playlist as default for those migrating from 4.6.
30	*/
31	function playlist_update_1() {
32	$items = array();
33	$items[] = update_sql("ALTER TABLE {playlist_relate} ADD type varchar(255) NOT NULL default ''");
34	$items[] = update_sql("UPDATE {playlist_relate} SET type = 'audio_playlist' WHERE type = ''");
35	return $items;
36	}
37
38	/*
39	* UTF 8 Conversion for 4.6 -> 4.7
40	*/
41	function playlist_update_2() {
42	return _system_update_utf8(array('playlist_relate'));
43	}