-- --------------------------------------------------------
-- 
-- Table structure for table `moviereview`
-- 
DROP TABLE IF EXISTS `moviereview` ;# MySQL returned an empty result set (i.e. zero rows).
CREATE TABLE IF NOT EXISTS `moviereview` (
`nid` int( 10 ) unsigned NOT NULL default '0',
`movietitle` varchar( 255 ) NOT NULL default '',
`release` varchar( 255 ) NOT NULL default '0',
`tvseries` int( 1 ) NOT NULL default '0',
`cover` varchar( 255 ) NOT NULL default '',
`genre` varchar( 255 ) NOT NULL default '',
`director` varchar( 255 ) NOT NULL default '',
`writer` 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 '',
`media` varchar( 255 ) NOT NULL default '',
`price` varchar( 255 ) NOT NULL default '',
`rating` int( 1 ) NOT NULL default '0',
`review` text,
`location` text,
PRIMARY KEY ( `nid` ) ,
KEY `movietitle` ( `movietitle` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;# MySQL returned an empty result set (i.e. zero rows).
-- 
-- Dumping data for table `moviereview`
-- 
-- --------------------------------------------------------
-- 
-- Table structure for table `moviereview_actors`
-- 
DROP TABLE IF EXISTS `moviereview_actors` ;# MySQL returned an empty result set (i.e. zero rows).
CREATE TABLE IF NOT EXISTS `moviereview_actors` (
`aid` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`nid` int( 10 ) unsigned NOT NULL default '0',
`actor` varchar( 255 ) NOT NULL default '',
`weight` tinyint( 4 ) default '0',
KEY `aid` ( `aid` ) ,
KEY `nid` ( `nid` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1;# MySQL returned an empty result set (i.e. zero rows).
-- 
-- Dumping data for table `moviereview_actors`
-- 
-- --------------------------------------------------------
-- 
-- Table structure for table `moviereview_links`
-- 
DROP TABLE IF EXISTS `moviereview_links` ;# MySQL returned an empty result set (i.e. zero rows).
CREATE TABLE IF NOT EXISTS `moviereview_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 DEFAULT CHARSET = latin1 AUTO_INCREMENT =3;# MySQL returned an empty result set (i.e. zero rows).