Skip to content
This repository was archived by the owner on Feb 11, 2018. It is now read-only.
This repository was archived by the owner on Feb 11, 2018. It is now read-only.

AL5 changed where containers are stored #87

Description

@MightySCollins

Containers are now stored in there own table with the below schema

CREATE TABLE `containers` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `pid` varchar(17) NOT NULL,
  `classname` varchar(32) NOT NULL,
  `pos` varchar(64) DEFAULT NULL,
  `inventory` text NOT NULL,
  `gear` text NOT NULL,
  `dir` varchar(128) DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `owned` tinyint(1) DEFAULT '0',
  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`,`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

And a sample row

INSERT INTO `containers` (`id`, `pid`, `classname`, `pos`, `inventory`, `gear`, `dir`, `active`, `owned`, `insert_time`)
VALUES (1,'76560000000000000','B_supplyCrate_F','[20767.8,6730.18,0.402126]','\"[[[`peach`,4]],4]\"','\"[[[],[]],[[`Chemlight_yellow`],[2]],[[],[]],[[],[]]]\"','[[-0.663391,-0.748273,0],[0,0,1]]',0,1,'2016-11-14 04:16:43')

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Labels

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions