-
Notifications
You must be signed in to change notification settings - Fork 0
/
BD.sql
48 lines (42 loc) · 1.3 KB
/
BD.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50720
Source Host : localhost:3306
Source Database : test
Target Server Type : MYSQL
Target Server Version : 50720
File Encoding : 65001
Date: 2017-12-30 01:03:41
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for accounts
-- ----------------------------
DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(24) DEFAULT NULL,
`password` varchar(100) DEFAULT NULL,
`level` int(11) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for houses
-- ----------------------------
DROP TABLE IF EXISTS `houses`;
CREATE TABLE `houses` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`owner` varchar(24) NOT NULL DEFAULT 'None',
`enterX` float DEFAULT NULL,
`enterY` float DEFAULT NULL,
`enterZ` float DEFAULT NULL,
`exitX` float DEFAULT NULL,
`exitY` float DEFAULT NULL,
`exitZ` float DEFAULT NULL,
`interior` int(11) DEFAULT NULL,
`price` int(11) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`virtualWorld` int(11) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;