Awakened Worlds Forum Index
 
[Awakened Worlds] Forums » Awakened Worlds Forums
Login | Register | Log in to check your private messages | Options
Search | Help | Member List | Usergroups | Who's Online | Statistics | Connect to Awake
AwakeMUD Core Development » Required MySQL tables
Author Topic: Required MySQL tables
Che Site Admin
Title: Site Admin
Posts: 558
Joined: 03 Apr 2005

 Date Posted: Sun Jul 01, 2007 12:05 am Subject: Required MySQL tables Date Edited: Mon Mar 17, 2008 6:43 am (edits total: 3) Edited By: Che
Code:

CREATE TABLE `pfiles` (
  `idnum` mediumint(5) unsigned unique default '0',
  `Name` varchar(21) default '',
  `Password` varchar(30),
  `Race` tinyint(2) default '0',
  `Gender` tinyint(2) default '0',
  `Rank` tinyint(2) default '1',
  `AffFlags` varchar(128) default '0',
  `PlrFlags` varchar(128) default '0',
  `PrfFlags` varchar(128) default '0',
  `Voice` varchar(200) default '',
  `Background` text NOT NULL,
  `Physical_Keywords` varchar(200) default '',
  `Physical_Name` varchar(200) default '',
  `Physical_LookDesc` text NOT NULL,
  `Matrix_Keywords` varchar(200) default 'Icon',
  `Matrix_Name` varchar(200) default 'An Icon',
  `Matrix_RoomDesc` varchar(200) default 'An Icon is here.',
  `Matrix_LookDesc` text NOT NULL,
  `Astral_Keywords` varchar(200) default 'reflection',
  `Astral_Name` varchar(200) default 'A reflection',
  `Astral_RoomDesc` varchar(200) default 'A reflection hovers here.',
  `Astral_LookDesc` text NOT NULL,
  `LeaveMsg` varchar(200) default 'leaves',
  `EnterMsg` varchar(200) default 'enters',
  `Title` varchar(48) default '^y(Newbie)^n',
  `Pretitle` varchar(48) default '',
  `Whotitle` varchar(10),
  `Prompt` varchar(79) default '<pP> ',
  `MatrixPrompt` varchar(79) default '<pP> ',
  `Host` varchar(72),
  `Bod` tinyint(2) default '0',
  `Qui` tinyint(2) default '0',
  `Str` tinyint(2) default '0',
  `Cha` tinyint(2) default '0',
  `Intel` tinyint(2) default '0',
  `Wil` tinyint(2) default '0',
  `EssenceTotal` smallint(3) unsigned default '0',
  `EssenceHole` smallint(3) unsigned default '0',
  `BiowareIndex` smallint(3) unsigned default '0',
  `HighestIndex` smallint(3) unsigned default '0',
  `Pool_MaxHacking` tinyint(2) default '0',
  `Pool_Body` tinyint(2) default '0',
  `Pool_Dodge` tinyint(2) default '0',
  `Height` int(3) default '0',
  `Weight` int(3) default '0',
  `Tradition` tinyint(2) default '2',
  `Cash` int(8) unsigned default '0',
  `Bank` int(8) unsigned default '0',
  `Karma` smallint(6) unsigned default '0',
  `Rep` smallint(6) unsigned default '0',
  `Notor` smallint(6) unsigned default '0',
  `TKE` smallint(6) unsigned default '0',
  `Hardcore` bool default FALSE,
  `Dead` bool default FALSE,
  `Physical` smallint(3) unsigned default '1000',
  `PhysicalLoss` smallint(3) unsigned default '0',
  `Mental` smallint(3) unsigned default '1000',
  `MentalLoss` smallint(3) unsigned default '0',
  `PermBodLoss` tinyint(1) default '0',
  `Lefthanded` bool default FALSE,
  `Curlang` smallint(3) default '73',
  `Wimplevel` tinyint(2) default '10',
  `LoadRoom` mediumint(5) unsigned default '0',
  `LastRoom` mediumint(5) unsigned default '0',
  `LastD` int unsigned default '0',
  `Born` int unsigned default '0',
  `Played` int unsigned default '0',
  `Hunger` tinyint(2) default 0,
  `Thirst` tinyint(2) default 0,
  `Drunk` tinyint(2) default 0,
  PRIMARY KEY (`idnum`),
  KEY (`name`)
);

CREATE TABLE `pfiles_immortdata` (
  `idnum` mediumint(5) unsigned unique default '0',
  `InvisLevel` tinyint(1) default '0',
  `IncogLevel` tinyint(1) default '0',
  `Zonenumber` mediumint(3),
  `PoofIn` varchar(200) default 'Someone appears from nowhere',
  `PoofOut` varchar(200) default 'You blink and someone is gone',
  PRIMARY KEY (`idnum`)
);


CREATE TABLE `pfiles_chargendata` (
  `idnum` mediumint(5) unsigned unique default '0', 
  `AttPoints` tinyint(2) unsigned default '0',
  `SkillPoints` tinyint(2) unsigned default '0',
  `ForcePoints` tinyint(2) unsigned default '0',
  `RestringPoints` tinyint(2) unsigned default '5',
  PRIMARY KEY (`idnum`)
);


CREATE TABLE `pfiles_magic` (
  `idnum` mediumint(5) unsigned unique default '0', 
  `Mag` smallint(3) unsigned default '600',
  `Pool_Casting` tinyint(2) default '0',
  `Pool_SpellDefense` tinyint(2) default '0',
  `Pool_Drain` tinyint(2) default '0',
  `Pool_Reflecting` tinyint(2) default '0',
  `Totem` tinyint(2) default '0',
  `TotemSpirit` tinyint(2) default '0',
  `Aspect` tinyint(2) default '0',
  `UsedGrade` tinyint(2) unsigned default '0',
  `ExtraPower` tinyint(2) unsigned default '0',
  `PowerPoints` smallint(3) unsigned default '600',
  `Sig` tinyint(2) unsigned default '0',
  `Masking` tinyint(1) unsigned default '0',
  PRIMARY KEY (`idnum`)
);

CREATE TABLE `pfiles_drugdata` (
  `idnum` mediumint(5) unsigned unique default '0',
  `Affect` tinyint(2) unsigned default '0',
  `Stage` tinyint(2) unsigned default '0',
  `Duration` tinyint(2) unsigned default '0',
  `Dose` tinyint(2) unsigned default '0',
  PRIMARY KEY(`idnum`)
);

CREATE TABLE `pfiles_drugs` (
  `idnum` mediumint(5) unsigned default '0',
  `DrugType` smallint(2) unsigned default '0',
  `Addict` smallint(2) unsigned default '0',
  `Doses` smallint(2) unsigned default '0',
  `Edge` smallint(2) unsigned default '0',
  `LastFix` mediumint(2) unsigned default '0',
  `Addtime` smallint(2) unsigned default '0',
  `Tolerant` smallint(2) unsigned default '0',
  `LastWith` smallint(2) unsigned default '0',
  KEY(`idnum`)
);

CREATE TABLE `pfiles_skills` (
  `idnum` mediumint(5) unsigned default '0',
  `skillnum` smallint(3) unsigned default '0',
  `rank` tinyint(2) unsigned default '0',
  KEY(`idnum`)
);

CREATE TABLE `pfiles_adeptpowers` (
  `idnum` mediumint(5) unsigned default '0',
  `powernum` smallint(3) unsigned default '0',
  `rank` smallint(3) unsigned default '0', 
  KEY(`idnum`)
);

CREATE TABLE `pfiles_metamagic` (
  `idnum` mediumint(5) unsigned default '0',
  `metamagicnum` smallint(3) unsigned default '0',
  `rank` smallint(3) unsigned default '0',
  KEY(`idnum`)
);

CREATE TABLE `pfiles_quests` (
  `idnum` mediumint(5) unsigned default '0',
  `number` smallint(3) unsigned default '0',
  `questnum` mediumint(3) unsigned default '0',
  KEY(`idnum`)
);

CREATE TABLE `pfiles_spirits` (
  `idnum` mediumint(5) unsigned default '0',
  `Type` smallint(3) unsigned default '0',
  `Rating` smallint(3) unsigned default '0',
  `Services` smallint(3) unsigned default '0',
  `spiritID` smallint(4) unsigned default '0',
  KEY(`idnum`)
);

CREATE TABLE `pfiles_bioware` (
  `idnum` mediumint(5) unsigned default '0',
  `Vnum` mediumint(5) unsigned default '0',
  `Cost` mediumint(5) unsigned default '0',
  `Value0` mediumint(2) default '0',
  `Value1` mediumint(2) default '0',
  `Value2` mediumint(2) default '0',
  `Value3` mediumint(2) default '0',
  `Value4` mediumint(2) default '0',
  `Value5` mediumint(2) default '0',
  `Value6` mediumint(2) default '0',
  `Value7` mediumint(2) default '0',
  `Value8` mediumint(2) default '0',
  `Value9` mediumint(2) default '0',
  `Value10` mediumint(2) default '0',
  `Value11` mediumint(2) default '0',
  KEY(`idnum`)
);

CREATE TABLE `pfiles_cyberware` (
  `idnum` mediumint(5) unsigned default '0',
  `Vnum` mediumint(5) unsigned default '0',
  `Cost` mediumint(5) unsigned default '0',
  `Restring` varchar(256),
  `Photo` text,
  `Value0` mediumint(2) default '0',
  `Value1` mediumint(2) default '0',
  `Value2` mediumint(2) default '0',
  `Value3` mediumint(2) default '0',
  `Value4` mediumint(2) default '0',
  `Value5` mediumint(2) default '0',
  `Value6` mediumint(2) default '0',
  `Value7` mediumint(2) default '0',
  `Value8` mediumint(2) default '0',
  `Value9` mediumint(2) default '0',
  `Value10` mediumint(2) unsigned default '0',
  `Value11` mediumint(2) unsigned default '0',
  `Level` tinyint(1) unsigned default '0',
  `posi` smallint(1) unsigned default '0',
  KEY(`idnum`)
);

CREATE TABLE `pfiles_inv` (
  `idnum` mediumint(5) unsigned default '0',
  `Vnum` mediumint(5) unsigned default '0',
  `Cost` mediumint(5) unsigned default '0',
  `Restring` varchar(256),
  `Photo` text,
  `Value0` mediumint(2) default '0',
  `Value1` mediumint(2) default '0',
  `Value2` mediumint(2) default '0',
  `Value3` mediumint(2) default '0',
  `Value4` mediumint(2) default '0',
  `Value5` mediumint(2) default '0',
  `Value6` mediumint(2) default '0',
  `Value7` mediumint(2) default '0',
  `Value8` mediumint(2) default '0',
  `Value9` mediumint(2) default '0',
  `Value10` mediumint(2) default '0',
  `Value11` mediumint(2) default '0',
  `Inside` tinyint(1) unsigned default '0',
  `Timer` mediumint(1) default '0',
  `ExtraFlags` varchar(128) default '0',
  `Attempt` tinyint(1) unsigned default '0',
  `Cond` tinyint(1) unsigned default '0',
  `posi` smallint(1) unsigned default '0',
  KEY(`idnum`)
);

CREATE TABLE `pfiles_worn` (
  `idnum` mediumint(5) unsigned default '0',
  `Vnum` mediumint(5) unsigned default '0',
  `Cost` mediumint(5) unsigned default '0',
  `Restring` varchar(256),
  `Photo` text,
  `Value0` mediumint(2) default '0',
  `Value1` mediumint(2) default '0',
  `Value2` mediumint(2) default '0',
  `Value3` mediumint(2) default '0',
  `Value4` mediumint(2) default '0',
  `Value5` mediumint(2) default '0',
  `Value6` mediumint(2) default '0',
  `Value7` mediumint(2) default '0',
  `Value8` mediumint(2) default '0',
  `Value9` mediumint(2) default '0',
  `Value10` mediumint(2) default '0',
  `Value11` mediumint(2) default '0',
  `Inside` tinyint(1) unsigned default '0',
  `Position` tinyint(1) unsigned default '0',
  `Timer` mediumint(1) default '0',
  `ExtraFlags` varchar(128) default '0',
  `Attempt` tinyint(1) unsigned default '0',
  `Cond` tinyint(1) unsigned default '0',
  `posi` smallint(1) unsigned default '0',
  KEY(`idnum`)
);

CREATE TABLE `pfiles_spells` (
  `idnum` mediumint(5) unsigned default '0',
  `Name` varchar(255) NOT NULL,
  `Type` tinyint(2) unsigned default '0',
  `Subtype` tinyint(2) unsigned default '0',
  `Rating` tinyint(2) unsigned default '0',
  `Category` tinyint(2) unsigned default '0',
  KEY(`idnum`)
);

CREATE TABLE `pfiles_memory` (
  `idnum` mediumint(5) unsigned default '0',
  `remembered` mediumint(5) unsigned default '0',
  `asname` varchar(80) NOT NULL,
  KEY(`idnum`)
);

CREATE TABLE `pfiles_alias` (
  `idnum` mediumint(5) unsigned default '0',
  `command` varchar(40) NOT NULL,
  `replacement` varchar(255) NOT NULL,
  KEY(`idnum`)
);



Post Reply | Quote | Private Message 
Che Site Admin
Title: Site Admin
Posts: 558
Joined: 03 Apr 2005

 Date Posted: Fri Nov 09, 2007 5:17 am Subject:
ALTER TABLE pfiles_spells ADD `Category` tinyint(2) unsigned default '0';
Post Reply | Quote | Private Message 
Che Site Admin
Title: Site Admin
Posts: 558
Joined: 03 Apr 2005

 Date Posted: Sun Feb 10, 2008 9:37 am Subject:
New trideo code requires

Code:

CREATE TABLE `trideo_broadcast` (
  `idnum` int unsigned auto_increment,
  `author` mediumint(5) unsigned default '0',
  `message` text,
  PRIMARY KEY(`idnum`)
);



Post Reply | Quote | Private Message 
Che Site Admin
Title: Site Admin
Posts: 558
Joined: 03 Apr 2005

 Date Posted: Mon Mar 17, 2008 6:43 am Subject:
New ignore code requires

Code:
CREATE TABLE `pfiles_ignore` (
  `idnum` mediumint(5) unsigned default '0',
  `remembered` mediumint(5) unsigned default '0',
  KEY(`idnum`)
);



Post Reply | Quote | Private Message 
Title: Neophyte
Posts: 5
Joined: 05 Aug 2008

 Date Posted: Wed Sep 03, 2008 12:31 am Subject:
Che, in the course of working with the latest (B20), it appears you left 3 columns out of the initial pfiles table.

ShotsFired, ShotsTriggered, and NoDelete. I put them in as int(Cool, int(Cool and tinyint(1) respectively, immediately following Drunk.

I'm still trying to cure the Segfaults that pop up, but now people can at least load after creating/logging out.
Post Reply | Quote | Private Message 
Che Site Admin
Title: Site Admin
Posts: 558
Joined: 03 Apr 2005

 Date Posted: Sun Nov 30, 2008 2:46 pm Subject:
Code:
CREATE TABLE `help_topic` (
  `name` varchar(128) NOT NULL,
  `body` text NOT NULL,
  `category` tinyint(2) default '0',
  `links` varchar(200),
  PRIMARY KEY(`name`)
);

CREATE TABLE `help_category` (
  `idnum` mediumint(5) unique default '0',
  `category` varchar(200),
   PRIMARY KEY(`idnum`)
);



Post Reply | Quote | Private Message 
Che Site Admin
Title: Site Admin
Posts: 558
Joined: 03 Apr 2005

 Date Posted: Wed Jan 26, 2011 4:10 am Subject:
Code:
ALTER TABLE pfiles ADD `CostTime` tinyint(1) unsigned default '0';
ALTER TABLE pfiles ADD `AvailOffset` tinyint(1) unsigned default '0';



Post Reply | Quote | Private Message 
 
Awakened Worlds Forum Index » AwakeMUD Core Development   All times are GMT
Page 1 of 1  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum
 
The time now is Tue Jan 22, 2019 11:06 pm powered by hailBoards v.1.2.0 ©2006 SPIRE / [based on phpBB©]