123456789101112131415161718192021222324 |
- :VERSION 1 # --------------------------
- BEGIN;
- CREATE TABLE `GridUser` (
- `UserID` VARCHAR(255) NOT NULL,
- `HomeRegionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
- `HomePosition` CHAR(64) NOT NULL DEFAULT '<0,0,0>',
- `HomeLookAt` CHAR(64) NOT NULL DEFAULT '<0,0,0>',
- `LastRegionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
- `LastPosition` CHAR(64) NOT NULL DEFAULT '<0,0,0>',
- `LastLookAt` CHAR(64) NOT NULL DEFAULT '<0,0,0>',
- `Online` CHAR(5) NOT NULL DEFAULT 'false',
- `Login` CHAR(16) NOT NULL DEFAULT '0',
- `Logout` CHAR(16) NOT NULL DEFAULT '0',
- PRIMARY KEY (`UserID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- COMMIT;
- :VERSION 2 # --------------------------
- BEGIN;
- COMMIT;
|