X-Git-Url: https://git.nirgal.com/?p=squasher.git;a=blobdiff_plain;f=squasher.sql;h=bed5d84b2ef1ae541a2ffa73c9d6d992c478cec7;hp=852a89e7be4e74b1138230ca01b1fe52e477c940;hb=HEAD;hpb=2aed6acb928d200efd3fb4290f8fc5c168a98a66;ds=sidebyside diff --git a/squasher.sql b/squasher.sql index 852a89e..bed5d84 100644 --- a/squasher.sql +++ b/squasher.sql @@ -30,7 +30,7 @@ CREATE TABLE `file_hash` ( `validated_chunks` int(6) unsigned zerofill NOT NULL DEFAULT '000000' COMMENT 'validated till chunk #, starting from 0', UNIQUE KEY `md5_hash` (`md5_hash`,`file`), KEY `md5_hash_2` (`md5_hash`) -) ENGINE=MyISAM DEFAULT CHARSET=utf-8; +) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -54,7 +54,7 @@ CREATE TABLE `log` ( KEY `user_id` (`user_id`), KEY `ip` (`ip`), KEY `date` (`date`) -) ENGINE=MyISAM AUTO_INCREMENT=8255 DEFAULT CHARSET=utf-8; +) ENGINE=MyISAM AUTO_INCREMENT=8255 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -69,7 +69,7 @@ CREATE TABLE `user_rights` ( `folder_path` varchar(255) NOT NULL DEFAULT '', `access` tinyint(1) unsigned zerofill NOT NULL DEFAULT '0', PRIMARY KEY (`user_id`,`folder_path`) -) ENGINE=MyISAM DEFAULT CHARSET=utf-8; +) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -88,7 +88,7 @@ CREATE TABLE `users` ( PRIMARY KEY (`user_id`), UNIQUE KEY `user_id` (`user_id`), KEY `user_id_2` (`user_id`) -) ENGINE=MyISAM AUTO_INCREMENT=119 DEFAULT CHARSET=utf-8; +) ENGINE=MyISAM AUTO_INCREMENT=119 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; --