/[drupal]/contributions/modules/moviereview/moviereview.mysql
ViewVC logotype

Diff of /contributions/modules/moviereview/moviereview.mysql

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.5, Mon May 15 01:31:04 2006 UTC revision 1.6, Mon May 29 00:03:25 2006 UTC
# Line 1  Line 1 
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 '',
# Line 18  CREATE TABLE moviereview ( Line 18  CREATE TABLE moviereview (
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,
# Line 27  CREATE TABLE moviereview_actors ( Line 27  CREATE TABLE moviereview_actors (
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,
# Line 37  CREATE TABLE moviereview_links ( Line 37  CREATE TABLE moviereview_links (
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;
Legend:
Removed from v.1.5  
changed lines
  Added in v.1.6
  ViewVC Help
Powered by ViewVC 1.1.2