Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
database_tables [2009/06/05 23:46]
Glarawyn
database_tables [2013/09/12 22:49] (current)
Line 1: Line 1:
 ====== BeBot Default Tables ====== ====== BeBot Default Tables ======
 ===== BeBot 0.6 Default Tables ===== ===== BeBot 0.6 Default Tables =====
 +==== access_control ====
 +<code sql>​TABLE `access_control` (
 +`command` varchar(50) NOT NULL default '',​
 +`subcommand` varchar(50) NOT NULL default '​*',​
 +`channel` varchar(20) NOT NULL default '',​
 +`minlevel` enum('​ANONYMOUS','​GUEST','​MEMBER','​LEADER','​ADMIN','​SUPERADMIN','​OWNER','​DISABLED','​DELETED'​) NOT NULL default '​DISABLED',​
 +PRIMARY KEY  (`command`,​`subcommand`,​`channel`)
 +)
 +</​code>​
 +
 ==== access_control_saves ==== ==== access_control_saves ====
 <code sql>​TABLE `access_control_saves` ( <code sql>​TABLE `access_control_saves` (
Line 58: Line 68:
 `code` varchar(25) NOT NULL default '',​ `code` varchar(25) NOT NULL default '',​
 PRIMARY KEY  (`name`) PRIMARY KEY  (`name`)
 +)
 +</​code>​
 +
 +==== color_schemes ====
 +<code sql>​TABLE `color_schemes` (
 +`module` varchar(25) NOT NULL default '',​
 +`name` varchar(25) NOT NULL default '',​
 +`color_code` varchar(25) NOT NULL default '',​
 +PRIMARY KEY  (`module`,​`name`)
 ) )
 </​code>​ </​code>​
Line 68: Line 87:
 </​code>​ </​code>​
  
-==== #​____access_control ​==== +==== land_control_zones ​==== 
-<code sql>​TABLE `#​____access_control` ( +<code sql>​TABLE `land_control_zones` ( 
-`commandvarchar(50) NOT NULL default '',​ +`idint(11) NOT NULL default '0', 
-`subcommand` varchar(50) ​NOT NULL default ​'​*'​+`lrange` int(10) default NULL, 
-`channel` varchar(20NOT NULL default ​''​+`hrange` int(10) default NULL, 
-`minlevelenum('​ANONYMOUS','​GUEST','​MEMBER','​LEADER','​ADMIN','​SUPERADMIN','​OWNER','​DISABLED','​DELETED'​NOT NULL default '​DISABLED'​+`area` varchar(50) ​default ​NULL
-PRIMARY KEY  (`command`,`subcommand`,`channel`) +`huge` varchar(10) ​default ​NULL
-+`x` varchar(10default ​NULL
-</​code>​ +`y` varchar(10) ​default ​NULL
- +`namevarchar(250default ​NULL, 
-==== #​____color_schemes ==== +PRIMARY KEY  (`id`), 
-<code sql>​TABLE ​`#​____color_schemes` ( +UNIQUE KEY `area` (`area`,`name`), 
-`modulevarchar(25NOT NULL default ''​+KEY `lrange` (`lrange`), 
-`namevarchar(25) NOT NULL default '',​ +KEY `hrange` (`hrange`), 
-`color_codevarchar(25NOT NULL default ''​+KEY `area_2(`area`)
-PRIMARY ​KEY  (`module`,`name`)+
 ) )
 </​code>​ </​code>​
  
-==== #​____log_message ​==== +==== log_message ​==== 
-<code sql>​TABLE `#​____log_message` (+<code sql>​TABLE `log_message` (
 `id` int(10) unsigned NOT NULL auto_increment,​ `id` int(10) unsigned NOT NULL auto_increment,​
 `message` varchar(500) NOT NULL, `message` varchar(500) NOT NULL,
Line 98: Line 116:
 </​code>​ </​code>​
  
-==== #​____logon ​==== +==== logon ==== 
-<code sql>​TABLE `#____logon` (+<code sql>​TABLE `logon` (
 `id` int(11) NOT NULL, `id` int(11) NOT NULL,
 `message` varchar(255) default NULL, `message` varchar(255) default NULL,
Line 106: Line 124:
 </​code>​ </​code>​
  
-==== #​____mail_message ​==== +==== mail_message ​==== 
-<code sql>​TABLE `#​____mail_message` (+<code sql>​TABLE `mail_message` (
 `id` int(11) NOT NULL auto_increment,​ `id` int(11) NOT NULL auto_increment,​
 `recieved` timestamp NOT NULL default CURRENT_TIMESTAMP,​ `recieved` timestamp NOT NULL default CURRENT_TIMESTAMP,​
Line 120: Line 138:
 </​code>​ </​code>​
  
-==== #​____news ​==== +==== news ==== 
-<code sql>​TABLE `#____news` (+<code sql>​TABLE `news` (
 `id` int(11) NOT NULL auto_increment,​ `id` int(11) NOT NULL auto_increment,​
 `type` int(11) default '​1',​ `type` int(11) default '​1',​
Line 131: Line 149:
 </​code>​ </​code>​
  
-==== #​____org_city ​==== +==== online ​==== 
-<code sql>​TABLE `#​____org_city` (+<code sql>​TABLE `online` ( 
 +`nickname` varchar(25) NOT NULL, 
 +`botname` varchar(25) NOT NULL, 
 +`status_gc` int(1) default '​0',​ 
 +`status_gc_changetime` int(11) default '​0',​ 
 +`status_pg` int(1) default '​0',​ 
 +`status_pg_changetime` int(11) default '​0',​ 
 +`reinvite` int(1) default '​0',​ 
 +`level` int(1) default '​0',​ 
 +PRIMARY KEY  (`nickname`,​`botname`) 
 +
 +</​code>​ 
 + 
 +==== org_city ==== 
 +<code sql>​TABLE `org_city` (
 `id` int(11) NOT NULL auto_increment,​ `id` int(11) NOT NULL auto_increment,​
 `time` int(11) default NULL, `time` int(11) default NULL,
Line 141: Line 173:
 </​code>​ </​code>​
  
-==== #​____preferences ​==== +==== player_notes ​==== 
-<code sql>​TABLE `#​____preferences` (+<code sql>​TABLE `player_notes` ( 
 +`pnid` int(11) NOT NULL auto_increment,​ 
 +`player` varchar(30) NOT NULL, 
 +`author` varchar(30) NOT NULL, 
 +`note` varchar(255) NOT NULL, 
 +`class` tinyint(4) NOT NULL default '​0',​ 
 +`timestamp` int(10) unsigned NOT NULL, 
 +PRIMARY KEY  (`pnid`) 
 +
 +</​code>​ 
 + 
 +==== pocketbosses ==== 
 +<code sql>​TABLE `pocketbosses` ( 
 +`ID` int(11) NOT NULL auto_increment,​ 
 +`is_pocket` tinyint(1) default '​1',​ 
 +`name` varchar(50) NOT NULL default '​Broken!',​ 
 +`level` int(11) default NULL, 
 +`Playfield` varchar(30) default NULL, 
 +`Place` varchar(50) default NULL, 
 +`pattern_mobs` varchar(50) default NULL, 
 +PRIMARY KEY  (`ID`) 
 +
 +</​code>​ 
 + 
 +==== preferences ==== 
 +<code sql>​TABLE `preferences` (
 `ID` int(11) NOT NULL auto_increment,​ `ID` int(11) NOT NULL auto_increment,​
 `pref_id` int(11) NOT NULL, `pref_id` int(11) NOT NULL,
Line 151: Line 208:
 </​code>​ </​code>​
  
-==== #​____preferences_def ​==== +==== preferences_def ​==== 
-<code sql>​TABLE `#​____preferences_def` (+<code sql>​TABLE `preferences_def` (
 `ID` int(11) NOT NULL auto_increment,​ `ID` int(11) NOT NULL auto_increment,​
 `module` varchar(30) default NULL, `module` varchar(30) default NULL,
Line 163: Line 220:
 </​code>​ </​code>​
  
-==== #​____raid_points ​==== +==== raid_points ​==== 
-<code sql>​TABLE `#​____raid_points` (+<code sql>​TABLE `raid_points` (
 `id` int(11) NOT NULL, `id` int(11) NOT NULL,
 `nickname` varchar(20) default NULL, `nickname` varchar(20) default NULL,
Line 174: Line 231:
 </​code>​ </​code>​
  
-==== #​____raid_points_log ​==== +==== raid_points_log ​==== 
-<code sql>​TABLE `#​____raid_points_log` (+<code sql>​TABLE `raid_points_log` (
 `id` int(11) NOT NULL auto_increment,​ `id` int(11) NOT NULL auto_increment,​
 `name` varchar(20) default NULL, `name` varchar(20) default NULL,
Line 186: Line 243:
 </​code>​ </​code>​
  
-==== #​____security_flexible ​==== +==== relay ==== 
-<code sql>​TABLE `#​____security_flexible` (+<code sql>​TABLE `relay` ( 
 +`id` int(11) NOT NULL auto_increment,​ 
 +`botname` varchar(20) default NULL, 
 +`type` varchar(30) default NULL, 
 +`time` int(11) default NULL, 
 +`msg` text, 
 +PRIMARY KEY  (`id`) 
 +
 +</​code>​ 
 + 
 +==== security_flexible ==== 
 +<code sql>​TABLE `security_flexible` (
 `id` int(10) unsigned NOT NULL auto_increment,​ `id` int(10) unsigned NOT NULL auto_increment,​
 `gid` int(10) unsigned NOT NULL, `gid` int(10) unsigned NOT NULL,
Line 197: Line 265:
 </​code>​ </​code>​
  
-==== #​____security_groups ​==== +==== security_groups ​==== 
-<code sql>​TABLE `#​____security_groups` (+<code sql>​TABLE `security_groups` (
 `gid` int(10) unsigned NOT NULL auto_increment,​ `gid` int(10) unsigned NOT NULL auto_increment,​
 `name` varchar(35) default NULL, `name` varchar(35) default NULL,
Line 208: Line 276:
 </​code>​ </​code>​
  
-==== #​____security_members ​==== +==== security_members ​==== 
-<code sql>​TABLE `#​____security_members` (+<code sql>​TABLE `security_members` (
 `id` int(11) NOT NULL auto_increment,​ `id` int(11) NOT NULL auto_increment,​
 `name` varchar(50) NOT NULL default '',​ `name` varchar(50) NOT NULL default '',​
Line 219: Line 287:
 </​code>​ </​code>​
  
-==== #​____security_org ​==== +==== security_org ​==== 
-<code sql>​TABLE `#​____security_org` (+<code sql>​TABLE `security_org` (
 `org_gov` varchar(25) NOT NULL, `org_gov` varchar(25) NOT NULL,
 `org_rank` varchar(25) NOT NULL, `org_rank` varchar(25) NOT NULL,
Line 229: Line 297:
 </​code>​ </​code>​
  
-==== #​____settings ​==== +==== settings ​==== 
-<code sql>​TABLE `#​____settings` (+<code sql>​TABLE `settings` (
 `module` varchar(25) NOT NULL, `module` varchar(25) NOT NULL,
 `setting` varchar(50) NOT NULL, `setting` varchar(50) NOT NULL,
Line 243: Line 311:
 </​code>​ </​code>​
  
-==== #​____statistics ​==== +==== shortcuts ​==== 
-<code sql>​TABLE `#​____statistics` (+<code sql>​TABLE `shortcuts` ( 
 +`id` int(11) NOT NULL auto_increment,​ 
 +`shortcut` varchar(20) NOT NULL, 
 +`long_desc` varchar(255) NOT NULL, 
 +PRIMARY KEY  (`shortcut`),​ 
 +UNIQUE KEY `id` (`id`), 
 +UNIQUE KEY `long_desc` (`long_desc`) 
 +
 +</​code>​ 
 + 
 +==== statistics ==== 
 +<code sql>​TABLE `statistics` (
 `id` int(10) unsigned NOT NULL auto_increment,​ `id` int(10) unsigned NOT NULL auto_increment,​
 `module` varchar(100) NOT NULL, `module` varchar(100) NOT NULL,
Line 254: Line 333:
 </​code>​ </​code>​
  
-==== #​____string_filter ​==== +==== string_filter ​==== 
-<code sql>​TABLE `#​____string_filter` (+<code sql>​TABLE `string_filter` (
 `search` varchar(255) NOT NULL, `search` varchar(255) NOT NULL,
 `new` varchar(255) NOT NULL default '​**bleep**',​ `new` varchar(255) NOT NULL default '​**bleep**',​
Line 262: Line 341:
 </​code>​ </​code>​
  
-==== #​____tablenames ​==== +==== symbiants ​==== 
-<code sql>​TABLE `#​____tablenames` (+<code sql>​TABLE `symbiants` ( 
 +`boss_id` int(11) NOT NULL, 
 +`QL` int(11) default NULL, 
 +`slot` varchar(10) default NULL, 
 +`unit` varchar(50) default NULL, 
 +`Name` varchar(59) default NULL, 
 +`itemref` int(11) default NULL 
 +
 +</​code>​ 
 + 
 +==== tablenames ==== 
 +<code sql>​TABLE `tablenames` (
 `internal_name` varchar(255) NOT NULL, `internal_name` varchar(255) NOT NULL,
 `prefix` varchar(100) default NULL, `prefix` varchar(100) default NULL,
Line 272: Line 362:
 </​code>​ </​code>​
  
-==== #​____timer ​==== +==== table_versions ​==== 
-<code sql>​TABLE `#____timer` (+<code sql>​TABLE `table_versions` ( 
 +`internal_name` varchar(255) NOT NULL, 
 +`schemaversion` int(3) NOT NULL default '​1',​ 
 +PRIMARY KEY  (`internal_name`) 
 +
 +</​code>​ 
 + 
 +==== timer ==== 
 +<code sql>​TABLE `timer` (
 `id` bigint(100) unsigned NOT NULL auto_increment,​ `id` bigint(100) unsigned NOT NULL auto_increment,​
 `name` varchar(200) NOT NULL default '',​ `name` varchar(200) NOT NULL default '',​
Line 283: Line 381:
 PRIMARY KEY  (`id`), PRIMARY KEY  (`id`),
 KEY `endtime` (`endtime`) KEY `endtime` (`endtime`)
-) 
-</​code>​ 
- 
-==== #​____timer_class_settings ==== 
-<code sql>​TABLE `#​____timer_class_settings` ( 
-`id` int(10) unsigned NOT NULL auto_increment,​ 
-`name` varchar(25) NOT NULL default '',​ 
-`current_class` int(10) unsigned NOT NULL, 
-`default_class` int(10) unsigned NOT NULL, 
-`description` varchar(255) NOT NULL default '',​ 
-PRIMARY KEY  (`name`), 
-UNIQUE KEY `id` (`id`) 
-) 
-</​code>​ 
- 
-==== #____users ==== 
-<code sql>​TABLE `#​____users` ( 
-`id` int(11) NOT NULL auto_increment,​ 
-`char_id` int(11) NOT NULL, 
-`nickname` varchar(25) default NULL, 
-`password` varchar(64) default NULL, 
-`password_salt` varchar(5) default NULL, 
-`last_seen` int(11) default '​0',​ 
-`last_raid` int(11) default '​0',​ 
-`added_by` varchar(25) default NULL, 
-`added_at` int(11) default '​0',​ 
-`deleted_by` varchar(25) default NULL, 
-`deleted_at` int(11) default NULL, 
-`banned_by` varchar(25) default NULL, 
-`banned_at` int(11) default NULL, 
-`banned_for` varchar(100) default NULL, 
-`banned_until` int(11) default '​0',​ 
-`notify` int(1) default '​0',​ 
-`user_level` int(1) default '​0',​ 
-`updated_at` int(11) default '​0',​ 
-PRIMARY KEY  (`id`), 
-UNIQUE KEY `char_id` (`char_id`),​ 
-UNIQUE KEY `nickname` (`nickname`),​ 
-KEY `user_level` (`user_level`),​ 
-KEY `banned_until` (`banned_until`),​ 
-KEY `notify` (`notify`), 
-KEY `user_level_2` (`user_level`),​ 
-KEY `banned_until_2` (`banned_until`),​ 
-KEY `notify_2` (`notify`) 
-) 
-</​code>​ 
- 
-==== land_control_zones ==== 
-<code sql>​TABLE `land_control_zones` ( 
-`id` int(11) NOT NULL default '​0',​ 
-`lrange` int(10) default NULL, 
-`hrange` int(10) default NULL, 
-`area` varchar(50) default NULL, 
-`huge` varchar(10) default NULL, 
-`x` varchar(10) default NULL, 
-`y` varchar(10) default NULL, 
-`name` varchar(250) default NULL, 
-PRIMARY KEY  (`id`), 
-UNIQUE KEY `area` (`area`,​`name`),​ 
-KEY `lrange` (`lrange`), 
-KEY `hrange` (`hrange`), 
-KEY `area_2` (`area`) 
-) 
-</​code>​ 
- 
-==== online ==== 
-<code sql>​TABLE `online` ( 
-`nickname` varchar(25) NOT NULL, 
-`botname` varchar(25) NOT NULL, 
-`status_gc` int(1) default '​0',​ 
-`status_gc_changetime` int(11) default '​0',​ 
-`status_pg` int(1) default '​0',​ 
-`status_pg_changetime` int(11) default '​0',​ 
-`reinvite` int(1) default '​0',​ 
-`level` int(1) default '​0',​ 
-PRIMARY KEY  (`nickname`,​`botname`) 
-) 
-</​code>​ 
- 
-==== player_notes ==== 
-<code sql>​TABLE `player_notes` ( 
-`pnid` int(11) NOT NULL auto_increment,​ 
-`player` varchar(30) NOT NULL, 
-`author` varchar(30) NOT NULL, 
-`note` varchar(255) NOT NULL, 
-`class` tinyint(4) NOT NULL default '​0',​ 
-`timestamp` int(10) unsigned NOT NULL, 
-PRIMARY KEY  (`pnid`) 
-) 
-</​code>​ 
- 
-==== pocketbosses ==== 
-<code sql>​TABLE `pocketbosses` ( 
-`ID` int(11) NOT NULL auto_increment,​ 
-`is_pocket` tinyint(1) default '​1',​ 
-`name` varchar(50) NOT NULL default '​Broken!',​ 
-`level` int(11) default NULL, 
-`Playfield` varchar(30) default NULL, 
-`Place` varchar(50) default NULL, 
-`pattern_mobs` varchar(50) default NULL, 
-PRIMARY KEY  (`ID`) 
-) 
-</​code>​ 
- 
-==== relay ==== 
-<code sql>​TABLE `relay` ( 
-`id` int(11) NOT NULL auto_increment,​ 
-`botname` varchar(20) default NULL, 
-`type` varchar(30) default NULL, 
-`time` int(11) default NULL, 
-`msg` text, 
-PRIMARY KEY  (`id`) 
-) 
-</​code>​ 
- 
-==== shortcuts ==== 
-<code sql>​TABLE `shortcuts` ( 
-`id` int(11) NOT NULL auto_increment,​ 
-`shortcut` varchar(20) NOT NULL, 
-`long_desc` varchar(255) NOT NULL, 
-PRIMARY KEY  (`shortcut`),​ 
-UNIQUE KEY `id` (`id`), 
-UNIQUE KEY `long_desc` (`long_desc`) 
-) 
-</​code>​ 
- 
-==== symbiants ==== 
-<code sql>​TABLE `symbiants` ( 
-`boss_id` int(11) NOT NULL, 
-`QL` int(11) default NULL, 
-`slot` varchar(10) default NULL, 
-`unit` varchar(50) default NULL, 
-`Name` varchar(59) default NULL, 
-`itemref` int(11) default NULL 
-) 
-</​code>​ 
- 
-==== table_versions ==== 
-<code sql>​TABLE `table_versions` ( 
-`internal_name` varchar(255) NOT NULL, 
-`schemaversion` int(3) NOT NULL default '​1',​ 
-PRIMARY KEY  (`internal_name`) 
 ) )
 </​code>​ </​code>​
Line 446: Line 402:
 `id` int(10) unsigned NOT NULL auto_increment,​ `id` int(10) unsigned NOT NULL auto_increment,​
 `name` varchar(25) NOT NULL default '',​ `name` varchar(25) NOT NULL default '',​
 +`description` varchar(255) NOT NULL default '',​
 +PRIMARY KEY  (`name`),
 +UNIQUE KEY `id` (`id`)
 +)
 +</​code>​
 +
 +==== timer_class_settings ====
 +<code sql>​TABLE `timer_class_settings` (
 +`id` int(10) unsigned NOT NULL auto_increment,​
 +`name` varchar(25) NOT NULL default '',​
 +`current_class` int(10) unsigned NOT NULL,
 +`default_class` int(10) unsigned NOT NULL,
 `description` varchar(255) NOT NULL default '',​ `description` varchar(255) NOT NULL default '',​
 PRIMARY KEY  (`name`), PRIMARY KEY  (`name`),
Line 494: Line 462:
 KEY `win_side_2` (`win_side`),​ KEY `win_side_2` (`win_side`),​
 KEY `zone_2` (`zone`) KEY `zone_2` (`zone`)
 +)
 +</​code>​
 +
 +==== users ====
 +<code sql>​TABLE `users` (
 +`id` int(11) NOT NULL auto_increment,​
 +`char_id` int(11) NOT NULL,
 +`nickname` varchar(25) default NULL,
 +`password` varchar(64) default NULL,
 +`password_salt` varchar(5) default NULL,
 +`last_seen` int(11) default '​0',​
 +`last_raid` int(11) default '​0',​
 +`added_by` varchar(25) default NULL,
 +`added_at` int(11) default '​0',​
 +`deleted_by` varchar(25) default NULL,
 +`deleted_at` int(11) default NULL,
 +`banned_by` varchar(25) default NULL,
 +`banned_at` int(11) default NULL,
 +`banned_for` varchar(100) default NULL,
 +`banned_until` int(11) default '​0',​
 +`notify` int(1) default '​0',​
 +`user_level` int(1) default '​0',​
 +`updated_at` int(11) default '​0',​
 +PRIMARY KEY  (`id`),
 +UNIQUE KEY `char_id` (`char_id`),​
 +UNIQUE KEY `nickname` (`nickname`),​
 +KEY `user_level` (`user_level`),​
 +KEY `banned_until` (`banned_until`),​
 +KEY `notify` (`notify`),
 +KEY `user_level_2` (`user_level`),​
 +KEY `banned_until_2` (`banned_until`),​
 +KEY `notify_2` (`notify`)
 ) )
 </​code>​ </​code>​
Line 529: Line 529:
 ) )
 </​code>​ </​code>​
- 
- 
- 
- 
  
 ===== PHP Script to Generate this Documentation from a MySQL Dump ===== ===== PHP Script to Generate this Documentation from a MySQL Dump =====
 
database_tables.1244238386.txt.bz2 · Last modified: 2013/09/12 22:49 (external edit)
[unknown button type]
 
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 3.0 Unported
WikiForumIRCBugs
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki