modules/movino/movino.install

<?php

function movino_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      // the {tablename} syntax is so multisite installs can add a
      // prefix to the table name as set in the settings.php file

      db_query("CREATE TABLE IF NOT EXISTS {movino_videos} (
                 vid int(10) NOT NULL default '0',
                 id varchar(127) NOT NULL default '0',
                 type varchar(10) NOT NULL default '',
                 server varchar(127) NOT NULL default '0',
                 title varchar(255) NOT NULL default '',
                 author varchar(255) NOT NULL default '',
                 username varchar(255) NOT NULL default '',
                 url varchar(255) NOT NULL default '',
                 size varchar(11) NOT NULL default '0',
                 created int(11) NOT NULL default '0',
                 length int(11) NOT NULL default '0',
                 encoding varchar(63) NOT NULL default '0',
                 preview varchar(255) NOT NULL default '',
                 available int(1) NOT NULL default '1',
                 PRIMARY KEY (vid)
               ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE IF NOT EXISTS {movino_servers} (
                 id varchar(127) NOT NULL default '',
                 name varchar(127) NOT NULL default '',
                 description longtext NOT NULL default '',
                 host varchar(255) NOT NULL default '',
                 feed_live int(1) NOT NULL default '0',
                 feed_live_port int(5) NOT NULL default '0',
                 feed_live_path varchar(255) NOT NULL default '',
                 feed_live_updated int(11) NOT NULL default '0',
                 feed_archive int(1) NOT NULL default '0',
                 feed_archive_port int(5) NOT NULL default '0',
                 feed_archive_path varchar(255) NOT NULL default '',
                 feed_archive_updated int(11) NOT NULL default '0',
                 source_port int(5) NOT NULL default '0',
                 PRIMARY KEY (id)
               ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
  }
}

function movino_update_1() {
  $ret = array();
  db_add_column($ret, 'movino_servers', 'secret_key', 'varchar(255)');
}

function movino_update_2() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql("ALTER TABLE {movino_videos} ADD COLUMN published int(1) NOT NULL default 1");
      $ret[] = update_sql("ALTER TABLE {movino_videos} ADD COLUMN removed int(1) NOT NULL default 0");
      break;
  }
}

function movino_update_3() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql("ALTER TABLE {movino_videos} ADD COLUMN position varchar(31) NOT NULL default ''");
      $ret[] = update_sql("ALTER TABLE {movino_videos} ADD COLUMN trail varchar(255) NOT NULL default ''");
      break;
  }
}
1	<?php
2
3	function movino_install() {
4	switch ($GLOBALS['db_type']) {
5	case 'mysql':
6	case 'mysqli':
7	// the {tablename} syntax is so multisite installs can add a
8	// prefix to the table name as set in the settings.php file
9
10	db_query("CREATE TABLE IF NOT EXISTS {movino_videos} (
11	vid int(10) NOT NULL default '0',
12	id varchar(127) NOT NULL default '0',
13	type varchar(10) NOT NULL default '',
14	server varchar(127) NOT NULL default '0',
15	title varchar(255) NOT NULL default '',
16	author varchar(255) NOT NULL default '',
17	username varchar(255) NOT NULL default '',
18	url varchar(255) NOT NULL default '',
19	size varchar(11) NOT NULL default '0',
20	created int(11) NOT NULL default '0',
21	length int(11) NOT NULL default '0',
22	encoding varchar(63) NOT NULL default '0',
23	preview varchar(255) NOT NULL default '',
24	available int(1) NOT NULL default '1',
25	PRIMARY KEY (vid)
26	) /!40100 DEFAULT CHARACTER SET utf8 /;");
27
28	db_query("CREATE TABLE IF NOT EXISTS {movino_servers} (
29	id varchar(127) NOT NULL default '',
30	name varchar(127) NOT NULL default '',
31	description longtext NOT NULL default '',
32	host varchar(255) NOT NULL default '',
33	feed_live int(1) NOT NULL default '0',
34	feed_live_port int(5) NOT NULL default '0',
35	feed_live_path varchar(255) NOT NULL default '',
36	feed_live_updated int(11) NOT NULL default '0',
37	feed_archive int(1) NOT NULL default '0',
38	feed_archive_port int(5) NOT NULL default '0',
39	feed_archive_path varchar(255) NOT NULL default '',
40	feed_archive_updated int(11) NOT NULL default '0',
41	source_port int(5) NOT NULL default '0',
42	PRIMARY KEY (id)
43	) /!40100 DEFAULT CHARACTER SET utf8 /;");
44	break;
45	}
46	}
47
48	function movino_update_1() {
49	$ret = array();
50	db_add_column($ret, 'movino_servers', 'secret_key', 'varchar(255)');
51	}
52
53	function movino_update_2() {
54	$ret = array();
55	switch ($GLOBALS['db_type']) {
56	case 'mysql':
57	case 'mysqli':
58	$ret[] = update_sql("ALTER TABLE {movino_videos} ADD COLUMN published int(1) NOT NULL default 1");
59	$ret[] = update_sql("ALTER TABLE {movino_videos} ADD COLUMN removed int(1) NOT NULL default 0");
60	break;
61	}
62	}
63
64	function movino_update_3() {
65	$ret = array();
66	switch ($GLOBALS['db_type']) {
67	case 'mysql':
68	case 'mysqli':
69	$ret[] = update_sql("ALTER TABLE {movino_videos} ADD COLUMN position varchar(31) NOT NULL default ''");
70	$ret[] = update_sql("ALTER TABLE {movino_videos} ADD COLUMN trail varchar(255) NOT NULL default ''");
71	break;
72	}
73	}