sql.sql

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(25) NOT NULL,
  `password` varchar(60) NOT NULL,
  `money` int(11) DEFAULT '100',
  `wanted_level` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4;

DROP TABLE IF EXISTS `businesses`;
CREATE TABLE `businesses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `x` float DEFAULT NULL,
  `y` float DEFAULT NULL,
  `z` float DEFAULT NULL,
  `interior` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4;

LOCK TABLES `businesses` WRITE;
INSERT INTO `businesses` VALUES (2,-2671.52,258.582,4.63281,0),(4,-2336.68,-166.852,35.5547,2),(5,-1816.58,617.818,35.1719,0),(6,-1912.09,828.069,35.2039,2),(7,-1882.7,866.056,35.1719,7),(9,-1808.26,945.402,24.8906,1),(10,-2374.55,910.151,45.4453,4),(11,-2356.27,1008.09,50.8984,2),(12,-2767.73,788.805,52.7812,3),(13,-1721.31,1359.76,7.18532,1),(14,-2490.54,-29.0599,25.6172,6);
UNLOCK TABLES;