database_tables

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
database_tables [2009/06/05 23:46]
Glarawyn
database_tables [2009/06/06 00:01]
Glarawyn
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.txt
  • Last modified: 2020/09/12 01:30
  • (external edit)