X-Git-Url: http://git.harvie.cz/?a=blobdiff_plain;f=install.sql;h=2c0857e6f1176fdf168340cb694c5951a2395dc3;hb=a1545cbd97c44f28a54b0ec5780f4ec85b468785;hp=7ac736c9863863192bd0b5b5a9675b22f57f2a5f;hpb=1fb6317fc48de7e2324f51a280ea9e97b9cf3ed8;p=mirrors%2FSokoMan.git diff --git a/install.sql b/install.sql index 7ac736c..2c0857e 100644 --- a/install.sql +++ b/install.sql @@ -230,7 +230,7 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2012-07-25 23:54:42 +-- Dump completed on 2012-07-29 14:23:53 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -306,7 +306,16 @@ CREATE TABLE `barcode` ( PRIMARY KEY (`barcode_id`), KEY `model_id` (`model_id`), CONSTRAINT `barcode_ibfk_1` FOREIGN KEY (`model_id`) REFERENCES `model` (`model_id`) -) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; +) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; +/*!40101 SET character_set_client = @saved_cs_client */; +DROP TABLE IF EXISTS `lock`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `lock` ( + `lock_id` int(11) unsigned NOT NULL AUTO_INCREMENT, + `lock_name` varchar(4096) COLLATE utf8_czech_ci NOT NULL, + PRIMARY KEY (`lock_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;