· 8 years ago · Feb 20, 2018, 07:18 PM
1--
2-- Base de données : `stantalone`
3--
4
5-- --------------------------------------------------------
6
7--
8-- Structure de la table `GridUser`
9--
10
11CREATE TABLE IF NOT EXISTS `GridUser` (
12 `UserID` varchar(255) NOT NULL,
13 `HomeRegionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
14 `HomePosition` char(64) NOT NULL DEFAULT '<0,0,0>',
15 `HomeLookAt` char(64) NOT NULL DEFAULT '<0,0,0>',
16 `LastRegionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
17 `LastPosition` char(64) NOT NULL DEFAULT '<0,0,0>',
18 `LastLookAt` char(64) NOT NULL DEFAULT '<0,0,0>',
19 `Online` char(5) NOT NULL DEFAULT 'false',
20 `Login` char(16) NOT NULL DEFAULT '0',
21 `Logout` char(16) NOT NULL DEFAULT '0'
22) ENGINE=InnoDB DEFAULT CHARSET=utf8;
23
24--
25-- Index pour les tables exportées
26--
27
28--
29-- Index pour la table `GridUser`
30--
31ALTER TABLE `GridUser`
32 ADD PRIMARY KEY (`UserID`);
33
34/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
35/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
36/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;