26 lines
563 B
MySQL
26 lines
563 B
MySQL
|
create or replace table newnpcsnew
|
||
|
|
(
|
||
|
|
id int default 0 not null
|
||
|
|
primary key,
|
||
|
|
name varchar(255) null,
|
||
|
|
world varchar(50) not null,
|
||
|
|
x float not null,
|
||
|
|
y float not null,
|
||
|
|
z float not null,
|
||
|
|
helmet tinytext null,
|
||
|
|
chestplate tinytext null,
|
||
|
|
leggings tinytext null,
|
||
|
|
boots tinytext null,
|
||
|
|
in_hand tinytext null,
|
||
|
|
info tinytext null,
|
||
|
|
yaw float default 1 not null,
|
||
|
|
pitch float default 1 not null,
|
||
|
|
in_hand_data int null,
|
||
|
|
metadata varchar(32) null,
|
||
|
|
skin_signature varchar(700) null,
|
||
|
|
skin_value varchar(400) null,
|
||
|
|
entity_type varchar(32) null
|
||
|
|
)
|
||
|
|
charset=latin1;
|
||
|
|
|