/[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.6, Mon May 29 00:03:25 2006 UTC revision 1.7, Mon May 29 00:14:44 2006 UTC
# 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)
 ) TYPE=MyISAM;  
40    );
Legend:
Removed from v.1.6  
changed lines
  Added in v.1.7
  ViewVC Help
Powered by ViewVC 1.1.2