equal
deleted
inserted
replaced
37 post_timestamp int(32) NOT NULL DEFAULT 0, |
37 post_timestamp int(32) NOT NULL DEFAULT 0, |
38 post_published tinyint(1) NOT NULL DEFAULT 0, |
38 post_published tinyint(1) NOT NULL DEFAULT 0, |
39 PRIMARY KEY ( post_id ) |
39 PRIMARY KEY ( post_id ) |
40 ) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_bin; |
40 ) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_bin; |
41 |
41 |
|
42 CREATE TABLE {{TABLE_PREFIX}}planets_mapping( |
|
43 mapping_id int(15) NOT NULL auto_increment, |
|
44 planet_id smallint(6) NOT NULL, |
|
45 mapping_type smallint(3) NOT NULL DEFAULT 1, |
|
46 mapping_value text NOT NULL, |
|
47 PRIMARY KEY ( mapping_id ) |
|
48 ) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_bin; |
|
49 |