modules/moviedb/moviedb.mysql


--
-- Table structure for table `moviedb`
--

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 '',
  `genre` 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `moviedb_actors`
--

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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `moviedb_directors`
--

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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `moviedb_links`
--

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`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `moviedb_producers`
--

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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `moviedb_writers`
--

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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1
2	--
3	-- Table structure for table `moviedb`
4	--
5
6	CREATE TABLE `moviedb` (
7	`nid` int(10) unsigned NOT NULL default '0',
8	`movietitle` varchar(255) NOT NULL default '',
9	`releaseyear` char(4) NOT NULL default '',
10	`cover` varchar(255) NOT NULL default '',
11	`genre` varchar(255) NOT NULL default '',
12	`runtime` varchar(255) NOT NULL default '0',
13	`country` varchar(255) NOT NULL default '',
14	`language` varchar(255) NOT NULL default '',
15	`imdb` varchar(255) NOT NULL default '',
16	`amazon` varchar(255) NOT NULL,
17	PRIMARY KEY (`nid`),
18	FULLTEXT KEY `movietitle` (`movietitle`)
19	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
20
21	-- --------------------------------------------------------
22
23	--
24	-- Table structure for table `moviedb_actors`
25	--
26
27	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	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
34
35	-- --------------------------------------------------------
36
37	--
38	-- Table structure for table `moviedb_directors`
39	--
40
41	CREATE TABLE `moviedb_directors` (
42	`mid` int(11) NOT NULL,
43	`pid` int(11) NOT NULL,
44	`weight` tinyint(4) NOT NULL default '0',
45	KEY `movie` (`mid`),
46	KEY `people` (`pid`)
47	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
48
49	-- --------------------------------------------------------
50
51	--
52	-- Table structure for table `moviedb_links`
53	--
54
55	CREATE TABLE `moviedb_links` (
56	`lid` int(10) unsigned NOT NULL auto_increment,
57	`nid` int(10) unsigned NOT NULL default '0',
58	`movielink` varchar(255) NOT NULL default '',
59	`description` varchar(255) NOT NULL default '',
60	`weight` tinyint(4) default '0',
61	KEY `lid` (`lid`),
62	KEY `nid` (`nid`)
63	) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
64
65	-- --------------------------------------------------------
66
67	--
68	-- Table structure for table `moviedb_producers`
69	--
70
71	CREATE TABLE `moviedb_producers` (
72	`mid` int(11) NOT NULL,
73	`pid` int(11) NOT NULL,
74	`weight` tinyint(4) NOT NULL default '0',
75	KEY `movie` (`mid`),
76	KEY `people` (`pid`)
77	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
78
79	-- --------------------------------------------------------
80
81	--
82	-- Table structure for table `moviedb_writers`
83	--
84
85	CREATE TABLE `moviedb_writers` (
86	`mid` int(11) NOT NULL,
87	`pid` int(11) NOT NULL,
88	`weight` tinyint(4) NOT NULL default '0',
89	KEY `movie` (`mid`),
90	KEY `people` (`pid`)
91	) ENGINE=MyISAM DEFAULT CHARSET=latin1;