| 1 |
CREATE TABLE moviereview ( |
CREATE TABLE moviereview ( |
| 2 |
nid int(10) unsigned NOT NULL default '0', |
nid int(10) unsigned NOT NULL default '0', |
| 3 |
movietitle varchar(255) NOT NULL default '', |
movietitle varchar(255) NOT NULL default '', |
| 4 |
release varchar(255) NOT NULL default '0', |
releaseyear char(4) NOT NULL default '', |
| 5 |
tvseries int(1) NOT NULL default '0', |
tvseries int(1) NOT NULL default '0', |
| 6 |
cover varchar(255) NOT NULL default '', |
cover varchar(255) NOT NULL default '', |
| 7 |
genre varchar(255) NOT NULL default '', |
genre varchar(255) NOT NULL default '', |
| 18 |
location text, |
location text, |
| 19 |
PRIMARY KEY (nid), |
PRIMARY KEY (nid), |
| 20 |
KEY movietitle (movietitle) |
KEY movietitle (movietitle) |
| 21 |
); |
) TYPE=MyISAM; |
| 22 |
|
|
| 23 |
CREATE TABLE moviereview_actors ( |
CREATE TABLE moviereview_actors ( |
| 24 |
aid int(10) unsigned NOT NULL auto_increment, |
aid int(10) unsigned NOT NULL auto_increment, |
| 27 |
weight tinyint(4) default '0', |
weight tinyint(4) default '0', |
| 28 |
KEY aid (aid), |
KEY aid (aid), |
| 29 |
KEY nid (nid) |
KEY nid (nid) |
| 30 |
); |
) TYPE=MyISAM; |
| 31 |
|
|
| 32 |
CREATE TABLE moviereview_links ( |
CREATE TABLE moviereview_links ( |
| 33 |
lid int(10) unsigned NOT NULL auto_increment, |
lid int(10) unsigned NOT NULL auto_increment, |
| 37 |
weight tinyint(4) default '0', |
weight tinyint(4) default '0', |
| 38 |
KEY lid (lid), |
KEY lid (lid), |
| 39 |
KEY nid (nid) |
KEY nid (nid) |
|
); |
|
| 40 |
|
) TYPE=MyISAM; |