Code: Select all
INSERT INTO permissions (name, level, ownerCode, permissionCode, permissionOperation, requiresPermissionCode) VALUES ('Tim', 'USER', 'OWN_USER_DATA', 'CUSTOM_USER_DATA', 'CUSTOM', NULL);
FEHLER 1265 (01000): Daten für Spalte „permissionOperation“ abgeschnitten in Zeile 1
Meine Tabelle sieht so aus:
Code: Select all
| permissions | CREATE TABLE `permissions` (
`name` varchar(255) NOT NULL,
`level` enum('ADMIN','USER') DEFAULT NULL,
`ownerCode` varchar(255) NOT NULL,
`permissionCode` varchar(255) NOT NULL,
`permissionOperation` enum('CREATE','READ','UPDATE','DELETE','HISTORY','CUSTOM') DEFAULT NULL,
`requiresPermissionCode` varchar(255) DEFAULT NULL,
PRIMARY KEY (`permissionCode`),
KEY `permissions_name` (`name`),
KEY `permissions_ownerCode` (`ownerCode`),
KEY `permissions_requiresPermissionCode` (`requiresPermissionCode`),
CONSTRAINT `permissions_chk_2` CHECK ((`permissionOperation` in (_latin1'CREATE',_latin1'READ',_latin1'UPDATE',_latin1'DELETE',_latin1'HISTORY',_latin1'CUSTOM')))
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
mysql> describe permissions;
+------------------------+------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+------------------------------------------------------------+------+-----+---------+-------+
| name | varchar(255) | NO | MUL | NULL | |
| level | enum('ADMIN','USER') | YES | | NULL | |
| ownerCode | varchar(255) | NO | MUL | NULL | |
| permissionCode | varchar(255) | NO | PRI | NULL | |
| permissionOperation | enum('CREATE','READ','UPDATE','DELETE','HISTORY','CUSTOM') | YES | | NULL | |
| requiresPermissionCode | varchar(255) | YES | MUL | NULL | |
+------------------------+------------------------------------------------------------+------+-----+---------+-------+
6 rows in set (0.01 sec)