diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/mysql/patch/media.sql')
| -rw-r--r-- | upgrades/dbpatches/1.3/mysql/patch/media.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/upgrades/dbpatches/1.3/mysql/patch/media.sql b/upgrades/dbpatches/1.3/mysql/patch/media.sql index 9824f68b..00540275 100644 --- a/upgrades/dbpatches/1.3/mysql/patch/media.sql +++ b/upgrades/dbpatches/1.3/mysql/patch/media.sql @@ -7,7 +7,7 @@ CREATE TABLE media_tmp ( severity integer DEFAULT '63' NOT NULL, period varchar(100) DEFAULT '1-7,00:00-23:59' NOT NULL, PRIMARY KEY (mediaid) -); +) ENGINE=InnoDB; CREATE INDEX media_1 on media_tmp (userid); CREATE INDEX media_2 on media_tmp (mediatypeid); |