plugins/nuggie/schema.sql
changeset 7 cd46e29ae699
parent 0 a09fb41e48d5
--- a/plugins/nuggie/schema.sql	Sat Jun 14 22:01:05 2008 -0400
+++ b/plugins/nuggie/schema.sql	Mon Jun 16 12:54:24 2008 -0400
@@ -39,3 +39,11 @@
   PRIMARY KEY ( post_id )
 ) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_bin;
 
+CREATE TABLE {{TABLE_PREFIX}}planets_mapping(
+  mapping_id int(15) NOT NULL auto_increment,
+  planet_id smallint(6) NOT NULL,
+  mapping_type smallint(3) NOT NULL DEFAULT 1,
+  mapping_value text NOT NULL,
+  PRIMARY KEY ( mapping_id )
+) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_bin;
+