modules/moviedb/moviedb.install

<?php
// $Id$

/**
 * @file
 * Control the installation of the module
 */
 
function moviedb_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':

      db_query("CREATE TABLE {moviedb} (
  `nid` int(10) unsigned NOT NULL default '0',
  `movietitle` varchar(255) NOT NULL default '',
  `releaseyear` char(4) NOT NULL default '',
  `cover` varchar(255) NOT NULL default '',
  `runtime` varchar(255) NOT NULL default '0',
  `country` varchar(255) NOT NULL default '',
  `language` varchar(255) NOT NULL default '',
  `imdb` varchar(255) NOT NULL default '',
  `amazon` varchar(255) NOT NULL,
  PRIMARY KEY  (`nid`),
  FULLTEXT KEY `movietitle` (`movietitle`)
)");
  db_query("CREATE TABLE {moviedb_actors} (
  `mid` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `weight` tinyint(4) NOT NULL default '0',
  KEY `movie` (`mid`),
  KEY `people` (`pid`)
)");
  db_query("CREATE TABLE {moviedb_directors} (
  `mid` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `weight` tinyint(4) NOT NULL default '0',
  KEY `movie` (`mid`),
  KEY `people` (`pid`)
)");
  db_query("CREATE TABLE {moviedb_links} (
  `lid` int(10) unsigned NOT NULL auto_increment,
  `nid` int(10) unsigned NOT NULL default '0',
  `movielink` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `weight` tinyint(4) default '0',
  KEY `lid` (`lid`),
  KEY `nid` (`nid`)
)");
  db_query("CREATE TABLE {moviedb_producers} (
  `mid` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `weight` tinyint(4) NOT NULL default '0',
  KEY `movie` (`mid`),
  KEY `people` (`pid`)
)");
  db_query("CREATE TABLE {moviedb_writers} (
  `mid` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `weight` tinyint(4) NOT NULL default '0',
  KEY `movie` (`mid`),
  KEY `people` (`pid`)
)");
      break;

    case 'pgsql':
      break;
  }
}
1	<?php
2	// $Id$
3
4	/**
5	* @file
6	* Control the installation of the module
7	*/
8
9	function moviedb_install() {
10	switch ($GLOBALS['db_type']) {
11	case 'mysql':
12	case 'mysqli':
13
14	db_query("CREATE TABLE {moviedb} (
15	`nid` int(10) unsigned NOT NULL default '0',
16	`movietitle` varchar(255) NOT NULL default '',
17	`releaseyear` char(4) NOT NULL default '',
18	`cover` varchar(255) NOT NULL default '',
19	`runtime` varchar(255) NOT NULL default '0',
20	`country` varchar(255) NOT NULL default '',
21	`language` varchar(255) NOT NULL default '',
22	`imdb` varchar(255) NOT NULL default '',
23	`amazon` varchar(255) NOT NULL,
24	PRIMARY KEY (`nid`),
25	FULLTEXT KEY `movietitle` (`movietitle`)
26	)");
27	db_query("CREATE TABLE {moviedb_actors} (
28	`mid` int(11) NOT NULL,
29	`pid` int(11) NOT NULL,
30	`weight` tinyint(4) NOT NULL default '0',
31	KEY `movie` (`mid`),
32	KEY `people` (`pid`)
33	)");
34	db_query("CREATE TABLE {moviedb_directors} (
35	`mid` int(11) NOT NULL,
36	`pid` int(11) NOT NULL,
37	`weight` tinyint(4) NOT NULL default '0',
38	KEY `movie` (`mid`),
39	KEY `people` (`pid`)
40	)");
41	db_query("CREATE TABLE {moviedb_links} (
42	`lid` int(10) unsigned NOT NULL auto_increment,
43	`nid` int(10) unsigned NOT NULL default '0',
44	`movielink` varchar(255) NOT NULL default '',
45	`description` varchar(255) NOT NULL default '',
46	`weight` tinyint(4) default '0',
47	KEY `lid` (`lid`),
48	KEY `nid` (`nid`)
49	)");
50	db_query("CREATE TABLE {moviedb_producers} (
51	`mid` int(11) NOT NULL,
52	`pid` int(11) NOT NULL,
53	`weight` tinyint(4) NOT NULL default '0',
54	KEY `movie` (`mid`),
55	KEY `people` (`pid`)
56	)");
57	db_query("CREATE TABLE {moviedb_writers} (
58	`mid` int(11) NOT NULL,
59	`pid` int(11) NOT NULL,
60	`weight` tinyint(4) NOT NULL default '0',
61	KEY `movie` (`mid`),
62	KEY `people` (`pid`)
63	)");
64	break;
65
66	case 'pgsql':
67	break;
68	}
69	}