|
Author |
Topic: Required MySQL tables |
Title: Site Admin
Posts: 559
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
|
Title: Site Admin
Posts: 559
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
|
Title: Site Admin
Posts: 559
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
|
Title: Site Admin
Posts: 559
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( , int( 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
|
Title: Site Admin
Posts: 559
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
|
Title: Site Admin
Posts: 559
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 Mon Dec 09, 2019 6:17 pm
|
powered by hailBoards v.1.2.0 ©2006 SPIRE / [based on phpBB©]
|
| |