vorerst ich weiß das man eigentlich ein korrektes datum in die jeweilige spalte eintragen sollte
das problem ist er gibt mir selbst beim eintragen eines datums aus dass es ein ungültiges default value wäre
auch beim erstellen von accounts trage ich zwei sachen ein gibt er mir aus
1067 - Invalid default value for 'last_play' und so gehts immer weiter bei jeder spalte ! ich wusste den fix mal aber mir fällt er nicht ein
hier ist meine account struktur
Code
- /*
- Navicat Premium Data Transfer
- Source Server : chiyoko
- Source Server Type : MySQL
- Source Server Version : 50726
- Source Host : 192.168.178.121:3306
- Source Schema : account
- Target Server Type : MySQL
- Target Server Version : 50726
- File Encoding : 65001
- Date: 06/06/2019 20:17:41
- */
- SET NAMES utf8mb4;
- SET FOREIGN_KEY_CHECKS = 0;
- -- ----------------------------
- -- Table structure for account
- -- ----------------------------
- DROP TABLE IF EXISTS `account`;
- CREATE TABLE `account` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `login` varchar(30) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
- `password` varchar(45) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
- `real_name` varchar(16) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT '',
- `social_id` varchar(13) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
- `email` varchar(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
- `phone1` varchar(16) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
- `phone2` varchar(16) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
- `address` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
- `zipcode` varchar(7) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT '',
- `create_time` datetime(0) NOT NULL,
- `question1` varchar(48) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
- `answer1` varchar(48) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
- `question2` varchar(48) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
- `answer2` varchar(48) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
- `is_testor` tinyint(1) NOT NULL DEFAULT 0,
- `status` varchar(8) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT 'OK',
- `securitycode` varchar(192) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT '',
- `newsletter` tinyint(1) NULL DEFAULT 0,
- `empire` tinyint(4) NOT NULL DEFAULT 0,
- `name_checked` tinyint(1) NOT NULL DEFAULT 0,
- `availDt` datetime(0) NOT NULL,
- `mileage` int(11) NOT NULL DEFAULT 0,
- `cash` int(11) NOT NULL DEFAULT 0,
- `gold_expire` datetime(0) NOT NULL,
- `silver_expire` datetime(0) NOT NULL DEFAULT '2035-05-05 21:00:00',
- `safebox_expire` datetime(0) NOT NULL DEFAULT '2035-05-05 21:00:00',
- `autoloot_expire` datetime(0) NOT NULL DEFAULT '2035-05-05 21:00:00',
- `fish_mind_expire` datetime(0) NOT NULL DEFAULT '2035-05-05 21:00:00',
- `marriage_fast_expire` datetime(0) NOT NULL DEFAULT '2035-05-05 21:00:00',
- `money_drop_rate_expire` datetime(0) NOT NULL,
- `ttl_cash` int(11) NOT NULL DEFAULT 0,
- `ttl_mileage` int(11) NOT NULL DEFAULT 0,
- `channel_company` varchar(30) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
- `last_play` datetime(0) NOT NULL,
- `coins` int(11) NOT NULL DEFAULT 0,
- `web_admin` int(1) NOT NULL DEFAULT 0,
- `vote_coins` int(12) NULL DEFAULT NULL,
- `web_ip` varchar(15) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
- `web_aktiviert` varchar(32) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
- `first_login` int(20) NOT NULL,
- `free_shop` int(11) NOT NULL,
- `marken` int(11) NOT NULL,
- PRIMARY KEY (`id`) USING BTREE,
- UNIQUE INDEX `login`(`login`) USING BTREE,
- INDEX `social_id`(`social_id`) USING BTREE
- ) ENGINE = MyISAM AUTO_INCREMENT = 54728 CHARACTER SET = ascii COLLATE = ascii_general_ci ROW_FORMAT = Dynamic;
- SET FOREIGN_KEY_CHECKS = 1;