· 8 years ago · Feb 13, 2018, 08:32 AM
1CREATE TABLE IF NOT EXISTS `AdminMapping` (
2`am_uid` int(11) NOT NULL,
3 `am_admin` varchar(24) CHARACTER SET cp1251 NOT NULL,
4 `am_admin_uid` int(11) NOT NULL,
5 `am_mark` varchar(32) CHARACTER SET cp1251 NOT NULL,
6 `am_date` varchar(20) NOT NULL,
7 `am_model` int(11) NOT NULL,
8 `am_x` double NOT NULL,
9 `am_y` double NOT NULL,
10 `am_z` double NOT NULL,
11 `am_rx` double NOT NULL,
12 `am_ry` double NOT NULL,
13 `am_rz` double NOT NULL
14) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;