建表的时候int 类型的不能用@Default

CREATE TABLE mark_config(
id VARCHAR(50),
on BOOLEAN DEFAULT '1',
min_width INT(32) DEFAULT '120',
min_height INT(32) DEFAULT '120',
image_path VARCHAR(50) DEFAULT '/res/cms/www/watermark.png',
content VARCHAR(50) DEFAULT 'www.shanggame.com',
size INT(32) DEFAULT '20',
color VARCHAR(50) DEFAULT '#FF0000',
alpha INT(32) DEFAULT '50',
pos INT(32) DEFAULT '1',
offset_x INT(32) DEFAULT '0',
offset_y INT(32) DEFAULT '0',
PRIMARY KEY (id)
) ENGINE=InnoDB CHARSET=utf8'
PreparedStatement: 
'CREATE TABLE mark_config(
id VARCHAR(50),
on BOOLEAN DEFAULT '1',
min_width INT(32) DEFAULT '120',
min_height INT(32) DEFAULT '120',
image_path VARCHAR(50) DEFAULT '/res/cms/www/watermark.png',
content VARCHAR(50) DEFAULT 'www.shanggame.com',
size INT(32) DEFAULT '20',
color VARCHAR(50) DEFAULT '#FF0000',
alpha INT(32) DEFAULT '50',
pos INT(32) DEFAULT '1',
offset_x INT(32) DEFAULT '0',
offset_y INT(32) DEFAULT '0',
PRIMARY KEY (id)
) ENGINE=InnoDB CHARSET=utf8'

我只是马甲(qq_4504aa9352519830c8c0befeea35c757) 1楼•3377天前

多了单引号吧?

我只是马甲(qq_4504aa9352519830c8c0befeea35c757) 2楼•3377天前

有这个bug,但没去fix

wendal

3楼•3376天前

CREATE TABLE Shelf
(
   ID SMALLINT UNSIGNED NOT NULL,
   YearBorn YEAR NOT NULL,
   NumBooks SMALLINT NOT NULL DEFAULT 1
);

想想怎么fix先

wendal

4楼•3376天前

fixed at https://github.com/nutzam/nutz/commit/ff2bb456cb8551a2693edf58dd49cb9b75cd628c

请先登陆