uQk5gvSm

1-- ----------------------------
2-- Table structure for roombots
3-- ----------------------------
4DROP TABLE IF EXISTS `roombots`;
5CREATE TABLE `roombots` (
6 `id` int(10) NOT NULL auto_increment,
7 `roomid` int(10) NOT NULL,
8 `name` varchar(50) collate latin1_general_ci NOT NULL,
9 `mission` varchar(100) collate latin1_general_ci default NULL,
10 `figure` text collate latin1_general_ci NOT NULL,
11 `x` int(5) NOT NULL,
12 `y` int(5) NOT NULL,
13 `z` int(1) NOT NULL,
14 `freeroam` enum('1','0') collate latin1_general_ci NOT NULL default '0',
15 `message_noshouting` varchar(200) collate latin1_general_ci NOT NULL default 'Shouting is not neccessary.',
16 PRIMARY KEY  (`id`)
17) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
18-- ----------------------------
19-- Table structure for roombots_coords
20-- ----------------------------
21DROP TABLE IF EXISTS `roombots_coords`;
22CREATE TABLE `roombots_coords` (
23 `id` int(10) NOT NULL,
24 `x` int(5) NOT NULL,
25 `y` int(5) NOT NULL
26) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
27
28-- ----------------------------
29-- Table structure for roombots_texts
30-- ----------------------------
31DROP TABLE IF EXISTS `roombots_texts`;
32CREATE TABLE `roombots_texts` (
33 `id` int(10) NOT NULL,
34 `type` enum('shout','say') collate latin1_general_ci NOT NULL,
35 `text` varchar(255) collate latin1_general_ci NOT NULL
36) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
37
38-- ----------------------------
39-- Table structure for roombots_texts_triggers
40-- ----------------------------
41DROP TABLE IF EXISTS `roombots_texts_triggers`;
42CREATE TABLE `roombots_texts_triggers` (
43 `id` int(10) NOT NULL,
44 `words` text collate latin1_general_ci NOT NULL,
45 `replies` text collate latin1_general_ci NOT NULL,
46 `serve_replies` text collate latin1_general_ci NOT NULL,
47 `serve_item` varchar(20) collate latin1_general_ci NOT NULL
48) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;