character_tpbookmark.sql 347 B

1234567891011
  1. CREATE TABLE IF NOT EXISTS `character_tpbookmark` (
  2. `charId` int(20) NOT NULL,
  3. `Id` int(20) NOT NULL,
  4. `x` int(20) NOT NULL,
  5. `y` int(20) NOT NULL,
  6. `z` int(20) NOT NULL,
  7. `icon` int(20) NOT NULL,
  8. `tag` varchar(50) DEFAULT NULL,
  9. `name` varchar(50) NOT NULL,
  10. PRIMARY KEY (`charId`,`Id`)
  11. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;