[Scrymud] Re: [Scrymud] MySql
Justin Piper
kat_skan at mailandnews.com
Mon Jul 24 05:24:25 PDT 2000
Dunno if rpm does this for you or not, but you usually have to run
ldconfig as root before you can use a newly installed library.
I'd be thrilled to get someone testing what's there, but you'll need to
keep in mind there's no way to save anything to a MySQL database yet, and
nothing in place to create the needed tables (I've attached the
sql scripts that should set things up right). You'll need to put the
essential rooms, objects and mobs in the database manually, though.
Needless to say, at this stage you'll need a fairly good understanding of
what info Scry saves about all the game elements, and you'll need a basic
understanding of SQL queries.
If you haven't been scared off yet, I'll be happy to answer any questions
you have about what's supposed to go in what fields.
--
"Picture the sun as the origin of two intersecting 6-dimensional
hyperplanes from which we can deduce a certain transformational
sequence which gives us the terminal velocity of a rubber duck ..."
On 23 Jul 2000, Blink wrote:
> I just instaled mysql, i donno if i made it right but on my
> old 486 that
> i use to test i made this
>
> rpm -i mysql-3.22.32-1.i386.rpm
> rpm -i mysql-client-3.22.32-1.i386.rpm
> rpm -i mysql-devel-3.22.32-1.i386.rpm
>
> seem that all warked right...
>
> now i compile the mud but i get that..
>
> g++ -g -D_GNU_SOURCE -fguiding-decls -fhuge-objects -W
> all -I/home/blink/lin/include
> -DUSEMYSQL -L/home/blink/lin/lib -o ./code_gen
> code_gen.o -lm -lstring2 -lbitfield -lcrypt -lmysqlclient
>
> /usr/bin/ld: cannot find -lmysqlclient
>
> collect2: ld returned 1 exit status
> make: *** [code_gen] Error 1
>
> but i've those libs....
>
> /usr/lib/mysql/libdbug.a
> /usr/lib/mysql/libheap.a
> /usr/lib/mysql/libmerge.a
> /usr/lib/mysql/libmysqlclient.a
> /usr/lib/mysql/libmysqlclient.la
> /usr/lib/mysql/libmystrings.a
> /usr/lib/mysql/libmysys.a
> /usr/lib/mysql/libnisam.a
>
>
> BLINK
>
> ps now i'm gonna try to install on the pentium who i'm
> writing but i've to reboot
> with linux.. :)
>
>
>
> ¤º°`°º¤,¸¸,¤º°`°º¤,¸¸,¤º°`°º¤,¸¸,¤º°`°º¤,¸¸,¤º°`°º¤
>
> Email : mario.magenta at libero.it
> blink at fattorek.com (Allegati)
> mario.magenta at iname.com
> mario.magenta at mail.omnitel.it (Email
> Urgenti)
>
> ICQ: 69974584
>
> ¤º°`°º¤,¸¸,¤º°`°º¤,¸¸,¤º°`°º¤,¸¸,¤º°`°º¤,¸¸,¤º°`°º¤
>
>
> _______________________________________________
> Scrymud mailing list - Scrymud at scry.WANfear.com
> http://www.WANfear.com/mailman/listinfo/scrymud
-------------- next part --------------
CREATE DATABASE gmud;
CREATE TABLE Critters (MOB_NUMBER INTEGER UNSIGNED NOT NULL,
PC_NUMBER INTEGER UNSIGNED NOT NULL,
SHORT_DESC TEXT NOT NULL,
IN_ROOM_DESC TEXT NOT NULL,
LONG_DESC TEXT NOT NULL,
EXP_WORTH BIGINT NOT NULL,
GOLD BIGINT NOT NULL,
BANK_GOLD BIGINT NOT NULL,
POSITION TINYINT UNSIGNED NOT NULL,
STR TINYINT UNSIGNED NOT NULL,
INTELLIGENCE TINYINT UNSIGNED NOT NULL,
CON TINYINT UNSIGNED NOT NULL,
CHA TINYINT UNSIGNED NOT NULL,
WIS TINYINT UNSIGNED NOT NULL,
DEX TINYINT UNSIGNED NOT NULL,
HIT TINYINT UNSIGNED NOT NULL,
DAM TINYINT UNSIGNED NOT NULL,
AC SMALLINT UNSIGNED NOT NULL,
ATTACKS TINYINT UNSIGNED NOT NULL,
BHD_COUNT TINYINT UNSIGNED NOT NULL,
BHD_SIDES TINYINT UNSIGNED NOT NULL,
PAUSE_COUNT TINYINT UNSIGNED NOT NULL,
SEX TINYINT UNSIGNED NOT NULL,
CLASS TINYINT UNSIGNED NOT NULL,
RACE TINYINT UNSIGNED NOT NULL,
ALIGNMENT SMALLINT NOT NULL,
LEVEL TINYINT UNSIGNED NOT NULL,
IMM_LEVEL TINYINT UNSIGNED NOT NULL,
HOMETOWN SMALLINT UNSIGNED NOT NULL,
WIMPY SMALLINT UNSIGNED NOT NULL,
PRACTICES SMALLINT UNSIGNED NOT NULL,
MOB_TYPE TINYINT UNSIGNED NOT NULL,
RELIGION TINYINT UNSIGNED NOT NULL,
GUILD TINYINT UNSIGNED NOT NULL,
FROM_ZONE SMALLINT UNSIGNED NOT NULL,
VIS_BITS BIGINT NOT NULL,
SEE_BITS BIGINT NOT NULL,
IN_ROOM INTEGER UNSIGNED NOT NULL,
SKIN INTEGER UNSIGNED NOT NULL,
HP SMALLINT UNSIGNED NOT NULL,
MANA SMALLINT UNSIGNED NOT NULL,
MOV SMALLINT UNSIGNED NOT NULL,
HP_MAX SMALLINT UNSIGNED NOT NULL,
DAM_REC_MOD SMALLINT NOT NULL,
DAM_GIV_MOD SMALLINT NOT NULL,
HEAT_RESIS SMALLINT NOT NULL,
COLD_RESIS SMALLINT NOT NULL,
ELECT_RESIS SMALLINT NOT NULL,
SPELL_RESIS SMALLINT NOT NULL,
WEIGHT SMALLINT UNSIGNED NOT NULL,
MAX_IN_GAME SMALLINT NULL,
BIRTH_DAY SMALLINT UNSIGNED NULL,
BIRTH_YEAR INTEGER UNSIGNED NULL,
RENT_DAY SMALLINT UNSIGNED NULL,
RENT_YEAR INTEGER UNSIGNED NULL,
LAST_LOGIN_TIME INTEGER UNSIGNED NULL,
TOTAL_TIME_ONLINE INTEGER UNSIGNED NULL,
AGE SMALLINT UNSIGNED NULL,
HUNGER TINYINT UNSIGNED NULL,
THIRST TINYINT UNSIGNED NULL,
DRUGGEDNESS TINYINT UNSIGNED NULL,
PKILLS SMALLINT NULL,
DEATHS SMALLINT UNSIGNED NULL,
QUEST_POINTS SMALLINT UNSIGNED NULL,
POOFIN_MSG TEXT NULL,
POOFOUT_MSG TEXT NULL,
PREFERRED_LANGUAGE TINYINT NULL,
PASSWORD TEXT NULL,
LINES_ON_PAGE SMALLINT UNSIGNED NULL,
PROMPT TEXT NULL,
GOS_COLOR TEXT NULL,
SAY_COLOR TEXT NULL,
YELL_COLOR TEXT NULL,
TELL_COLOR TEXT NULL,
DESC_COLOR TEXT NULL,
OBJ_LIST_COLOR TEXT NULL,
MOB_LIST_COLOR TEXT NULL,
DEFAULT_COLOR TEXT NULL,
BACKGROUND_COLOR TEXT NULL,
BATTLE_COLOR TEXT NULL,
USER1_COLOR TEXT NULL,
USER2_COLOR TEXT NULL,
USER3_COLOR TEXT NULL,
GUARDING_DIRECTION SMALLINT UNSIGNED NULL,
STORE_MANAGER TEXT NULL,
WRONG_ALIGN_MSG TEXT NULL,
WRONG_CLASS_MSG TEXT NULL,
WRONG_RACE_MSG TEXT NULL,
MARKUP TINYINT NULL,
BUY_PERCENTAGE TINYINT NULL,
OPEN_TIME TINYINT NULL,
CLOSE_TIME TINYINT NULL,
SKILL_VIOLENCE TINYINT NULL,
BENEVOLENCE TINYINT NULL,
DEFENSIVENESS TINYINT NULL,
BAD_ASSEDNESS TINYINT NULL,
SOCIAL_AWARENESS TINYINT NULL,
CAN_SEE_INVENTORY TINYINT UNSIGNED NOT NULL,
USING_LIGHT_SOURCE TINYINT UNSIGNED NOT NULL,
IS_FLYING TINYINT UNSIGNED NOT NULL,
HAS_BOAT TINYINT UNSIGNED NOT NULL,
CAN_CLIMB TINYINT UNSIGNED NOT NULL,
GOSSIPS TINYINT UNSIGNED NOT NULL,
YELLS TINYINT UNSIGNED NOT NULL,
GRATZ TINYINT UNSIGNED NOT NULL,
AUCTIONS TINYINT UNSIGNED NOT NULL,
SHOUTS TINYINT UNSIGNED NOT NULL,
SAYS TINYINT UNSIGNED NOT NULL,
TELLS TINYINT UNSIGNED NOT NULL,
WIZNETS TINYINT UNSIGNED NOT NULL,
IS_PARALYZED TINYINT UNSIGNED NOT NULL,
IS_PERM_SLEEPED TINYINT UNSIGNED NOT NULL,
IS_DUAL_WIELDING TINYINT UNSIGNED NOT NULL,
IS_SNEAKING TINYINT UNSIGNED NOT NULL,
IN_USE TINYINT UNSIGNED NOT NULL,
CAN_DIVE TINYINT UNSIGNED NOT NULL,
IS_HIDE TINYINT UNSIGNED NOT NULL,
IS_FROZEN TINYINT UNSIGNED NULL,
IS_GAGGED TINYINT UNSIGNED NULL,
HAS_IMM_DATA TINYINT UNSIGNED NULL,
CLOAKED TINYINT UNSIGNED NULL,
TANK_GRAPH TINYINT UNSIGNED NULL,
USING_CLIENT TINYINT UNSIGNED NULL,
AUTO_EXIT TINYINT UNSIGNED NULL,
NO_HASSLE TINYINT UNSIGNED NULL,
BRIEF TINYINT UNSIGNED NULL,
IS_BUILDER TINYINT UNSIGNED NULL,
AUTOLOOT TINYINT UNSIGNED NULL,
AUTOSPLIT TINYINT UNSIGNED NULL,
EXTRA_INFO TINYINT UNSIGNED NULL,
CR_BEHIND TINYINT UNSIGNED NULL,
DO_CARRIAGE_RETURN TINYINT UNSIGNED NULL,
CAN_DETECT_MAGIC TINYINT UNSIGNED NULL,
DETECT_INVENTORY TINYINT UNSIGNED NULL,
SHOW_VNUMS TINYINT UNSIGNED NULL,
HAS_POOFIN_POOFOUT_MSG TINYINT UNSIGNED NULL,
PAGE_OUTPUT TINYINT UNSIGNED NULL,
IN_PAGE_BREAK_MODE TINYINT UNSIGNED NULL,
NO_WIZCHAT TINYINT UNSIGNED NULL,
HAS_COLORS TINYINT UNSIGNED NULL,
USE_COLOR TINYINT UNSIGNED NULL,
HAS_LANGUAGE_CHOICE TINYINT UNSIGNED NULL,
NO_SHOW_NPC_ENTRY TINYINT UNSIGNED NULL,
NO_BEEP TINYINT UNSIGNED NULL,
IS_REMORT TINYINT UNSIGNED NULL,
HAS_SACRIFICED TINYINT UNSIGNED NULL,
HAS_PROC_DATA TINYINT UNSIGNED NULL,
SCAVENGE TINYINT UNSIGNED NULL,
WANDER TINYINT UNSIGNED NULL,
SHOULD_DO_PROCS TINYINT UNSIGNED NULL,
EDIBLE TINYINT UNSIGNED NULL,
IS_BANKER TINYINT UNSIGNED NULL,
IS_SESSILE TINYINT UNSIGNED NULL,
NO_HOMING TINYINT UNSIGNED NULL,
DISOLVABLE TINYINT UNSIGNED NULL,
HAS_SKIN TINYINT UNSIGNED NULL,
HAS_MOB_SCRIPTS TINYINT UNSIGNED NULL,
IS_SHOPKEEPER TINYINT UNSIGNED NULL,
IS_TEACHER TINYINT UNSIGNED NULL,
LET_SAME_CLASS_PASS TINYINT UNSIGNED NULL,
LET_SAME_RACE_PASS TINYINT UNSIGNED NULL,
HAS_MOB_GIV_PROC TINYINT UNSIGNED NULL,
HAS_MOB_SAY_PROC TINYINT UNSIGNED NULL,
HAS_MOB_BOW_PROC TINYINT UNSIGNED NULL,
HAS_MOB_CURSE_PROC TINYINT UNSIGNED NULL,
PROC_WITH_SAME_RACE TINYINT UNSIGNED NULL,
PROC_WITH_SAME_ALIGN TINYINT UNSIGNED NULL,
PROC_WITH_SAME_CLASS TINYINT UNSIGNED NULL,
HAS_AI TINYINT UNSIGNED NULL,
BUY_0 TINYINT UNSIGNED NULL,
SELL_0 TINYINT UNSIGNED NULL,
OFFER_0 TINYINT UNSIGNED NULL,
IS_PLAYER_OWNED TINYINT UNSIGNED NULL,
BUYS_NON_WEAPONS TINYINT UNSIGNED NULL,
BUYS_SLASHING_WEAPONS TINYINT UNSIGNED NULL,
BUYS_SMASHING_WEAPONS TINYINT UNSIGNED NULL,
BUYS_PIERCING_WEAPONS TINYINT UNSIGNED NULL,
BUYS_WHIPS TINYINT UNSIGNED NULL,
BUYS_AMMO_NEEDING_WEAPONS TINYINT UNSIGNED NULL,
BUYS_DART_THROWERS TINYINT UNSIGNED NULL,
BUYS_BOWS TINYINT UNSIGNED NULL,
BUYS_DARTS TINYINT UNSIGNED NULL,
BUYS_ARROWS TINYINT UNSIGNED NULL,
BUYS_JUNK TINYINT UNSIGNED NULL,
BUYS_WANDS TINYINT UNSIGNED NULL,
BUYS_POTIONS TINYINT UNSIGNED NULL,
BUYS_SCROLLS TINYINT UNSIGNED NULL,
BUYS_CONTAINERS TINYINT UNSIGNED NULL,
BUYS_COINS TINYINT UNSIGNED NULL,
BUYS_ARMOR TINYINT UNSIGNED NULL,
BUYS_WEAPONS TINYINT UNSIGNED NULL,
BUYS_LIGHTS TINYINT UNSIGNED NULL,
BUYS_CANTEENS TINYINT UNSIGNED NULL,
BUYS_LIQUIDS TINYINT UNSIGNED NULL,
BUYS_FOOD TINYINT UNSIGNED NULL,
BUYS_BOATS TINYINT UNSIGNED NULL,
BUYS_TOOLBOXES TINYINT UNSIGNED NULL,
BUYS_CAULDRENS TINYINT UNSIGNED NULL,
BUYS_PENS TINYINT UNSIGNED NULL,
BUYS_CONSTRUCT_COMPONENTS TINYINT UNSIGNED NULL,
BUYS_CONCOCT_COMPONENTS TINYINT UNSIGNED NULL,
BUYS_PARCHMENTS TINYINT UNSIGNED NULL,
BUYS_HERBS TINYINT UNSIGNED NULL,
BUYS_VENDING_MACHINES TINYINT UNSIGNED NULL,
TEACHES_WARRIORS TINYINT UNSIGNED NULL,
TEACHES_SAGES TINYINT UNSIGNED NULL,
TEACHES_WIZARDS TINYINT UNSIGNED NULL,
TEACHES_RANGERS TINYINT UNSIGNED NULL,
TEACHES_THIEVES TINYINT UNSIGNED NULL,:w
TEACHES_ALCHEMISTS TINYINT UNSIGNED NULL,
TEACHES_CLERICS TINYINT UNSIGNED NULL,
TEACHES_BARDS TINYINT UNSIGNED NULL,
UNIQUE CrittersIndex (MOB_NUMBER));
CREATE TABLE CritEq (MOB_NUMBER INTEGER UNSIGNED NOT NULL,
PC_NUMBER INTEGER UNSIGNED NOT NULL,
POSITION INTEGER UNSIGNED NOT NULL,
OBJ_NUM INTEGER NULL,
SOBJ_NUM INTEGER NULL,
UNIQUE CritEqIndex(MOB_NUMBER, POSITION));
CREATE TABLE CritInv (MOB_NUMBER INTEGER UNSIGNED NOT NULL,
OBJECT_NUMBER INTEGER UNSIGNED NOT NULL,
SOBJ_NUM INTEGER NOT NULL,
QUANTITY SMALLINT UNSIGNED NOT NULL,
UNIQUE CritInvIndex(MOB_NUMBER, OBJECT_NUMBER, SOBJ_NUM));
CREATE TABLE CritPermInv (MOB_NUMBER INTEGER UNSIGNED NOT NULL,
OBJECT_NUMBER INTEGER UNSIGNED NOT NULL,
SOBJ_NUM INTEGER NOT NULL,
QUANTITY SMALLINT UNSIGNED NOT NULL,
UNIQUE CritPermInvIndex(MOB_NUMBER, OBJECT_NUMBER,
SOBJ_NUM));
CREATE TABLE CritPOwnInv (MOB_NUMBER INTEGER UNSIGNED NOT NULL,
OBJECT_NUMBER INTEGER UNSIGNED NOT NULL,
SELL_AT INTEGER UNSIGNED NOT NULL,
BUY_AT INTEGER UNSIGNED NOT NULL,
UNIQUE CritPermInvIndex(MOB_NUMBER, OBJECT_NUMBER,
SOBJ_NUM));
CREATE TABLE CritSpells (PC_NUMBER INTEGER UNSIGNED NOT NULL,
SPELL_NUMBER INTEGER UNSIGNED NOT NULL,
DURATION INTEGER NOT NULL,
UNIQUE CritSpellsIndex(MOB_NUMBER, SPELL_NUMBER));
CREATE TABLE CritLrnd (MOB_NUMBER INTEGER UNSIGNED NOT NULL,
SKILL_NUMBER INTEGER UNSIGNED NOT NULL,
PERCENT_LEARNED TINYINT UNSIGNED NOT NULL,
UNIQUE CritLrndIndex(MOB_NUMBER, SKILL_NUMBER));
CREATE TABLE CritNames (MOB_NUMBER INTEGER UNSIGNED NOT NULL,
PC_NUMBER INTEGER UNSIGNED NOT NULL,
NAME VARCHAR(128) NOT NULL,
UNIQUE CritNamesIndex(MOB_NUMBER, NAME));
CREATE TABLE CritProcs (MOB_NUMBER INTEGER UNSIGNED NOT NULL,
PROC_TYPE TINYINT UNSIGNED NOT NULL,
PROC_TOPIC VARCHAR(128) NOT NULL,
CORRECT_MSG TEXT NOT NULL,
INCORRECT_MSG TEXT NOT NULL,
TEST_ONUM INTEGER UNSIGNED NOT NULL,
AWARD_ONUM INTEGER UNSIGNED NOT NULL,
SKILL_NAME TEXT NOT NULL,
TRANS_ROOM INTEGER UNSIGNED NOT NULL,
UNIQUE CritProcsIndex(MOB_NUMBER, PROC_TYPE,
PROC_TOPIC));
CREATE TABLE CritScripts (MOB_NUMBER INTEGER UNSIGNED NOT NULL,
TRIGGER_CMD VARCHAR(32) NOT NULL,
TARGET INTEGER UNSIGNED NOT NULL,
ACTOR INTEGER UNSIGNED NOT NULL,
DISCRIMINATOR VARCHAR(96) NOT NULL,
PRECEDENCE INTEGER NOT NULL,
SCRIPT_COMMANDS TEXT NOT NULL,
UNIQUE CritScriptsIndex(MOB_NUMBER, TRIGGER_CMD,
TARGET, ACTOR, DISCRIMINATOR));
CREATE TABLE Objects (OBJ_NUM INTEGER NOT NULL,
SOBJ_NUM INTEGER NOT NULL,
SHORT_DESC TEXT NOT NULL,
IN_ROOM_DESC TEXT NOT NULL,
LONG_DESC TEXT NOT NULL,
CHARGES SMALLINT NOT NULL,
TIMES_RECHARGABLE SMALLINT NOT NULL,
PERCENT_LOAD TINYINT NOT NULL,
VIS_BIT BIGINT NOT NULL,
PRICE INTEGER NOT NULL,
FROM_ZONE SMALLINT NOT NULL,
SKIN_NUMBER SMALLINT NOT NULL,
MAX_IN_GAME INTEGER UNSIGNED NOT NULL,
WEIGHT SMALLINT UNSIGNED NOT NULL,
DICE_SIDES SMALLINT UNSIGNED NOT NULL,
DICE_COUNT SMALLINT UNSIGNED NOT NULL,
LEVEL TINYINT UNSIGNED NOT NULL,
KEY_NUM SMALLINT NULL,
MAX_WEIGHT SMALLINT UNSIGNED NULL,
PERCENT_WEIGHT TINYINT NULL,
TIME_TILL_DISSOLVE SMALLINT NULL,
NO_REST TINYINT UNSIGNED NOT NULL,
ANTI_EVIL TINYINT UNSIGNED NOT NULL,
ANTI_NEUTRAL TINYINT UNSIGNED NOT NULL,
ANTI_GOOD TINYINT UNSIGNED NOT NULL,
ANTI_DONATE TINYINT UNSIGNED NOT NULL,
ANTI_DROP TINYINT UNSIGNED NOT NULL,
ANTI_REMOVE TINYINT UNSIGNED NOT NULL,
ANTI_MORTAL TINYINT UNSIGNED NOT NULL,
ANTI_IMMORTAL TINYINT UNSIGNED NOT NULL,
ANTI_DEMI TINYINT UNSIGNED NOT NULL,
IN_USE TINYINT UNSIGNED NOT NULL,
ANTI_WARRIOR TINYINT UNSIGNED NOT NULL,
ANTI_SAGE TINYINT UNSIGNED NOT NULL,
ANTI_WIZARD TINYINT UNSIGNED NOT NULL,
ANTI_RANGER TINYINT UNSIGNED NOT NULL,
ANTI_THIEF TINYINT UNSIGNED NOT NULL,
ANTI_ALCHEMIST TINYINT UNSIGNED NOT NULL,
ANTI_CLERIC TINYINT UNSIGNED NOT NULL,
ANTI_BARD TINYINT UNSIGNED NOT NULL,
ANTI_MOB TINYINT UNSIGNED NOT NULL,
ANTI_PC TINYINT UNSIGNED NOT NULL,
NOT_WORN TINYINT UNSIGNED NOT NULL,
HEAD TINYINT UNSIGNED NOT NULL,
NECK1 TINYINT UNSIGNED NOT NULL,
NECK2 TINYINT UNSIGNED NOT NULL,
AROUND_BODY TINYINT UNSIGNED NOT NULL,
ARMS TINYINT UNSIGNED NOT NULL,
WRIST1 TINYINT UNSIGNED NOT NULL,
WRIST2 TINYINT UNSIGNED NOT NULL,
HANDS TINYINT UNSIGNED NOT NULL,
WIELDED TINYINT UNSIGNED NOT NULL,
HELD TINYINT UNSIGNED NOT NULL,
LIGHT TINYINT UNSIGNED NOT NULL,
BODY TINYINT UNSIGNED NOT NULL,
BELT TINYINT UNSIGNED NOT NULL,
LEGS TINYINT UNSIGNED NOT NULL,
FEET TINYINT UNSIGNED NOT NULL,
FINGER1 TINYINT UNSIGNED NOT NULL,
FINGER2 TINYINT UNSIGNED NOT NULL,
SHIELD TINYINT UNSIGNED NOT NULL,
NOT_A_WEAPON TINYINT UNSIGNED NOT NULL,
SLASH TINYINT UNSIGNED NOT NULL,
SMASH TINYINT UNSIGNED NOT NULL,
PIERCE TINYINT UNSIGNED NOT NULL,
WHIP TINYINT UNSIGNED NOT NULL,
NEEDS_AMMO TINYINT UNSIGNED NOT NULL,
DART_THROWER TINYINT UNSIGNED NOT NULL,
BOW TINYINT UNSIGNED NOT NULL,
DART TINYINT UNSIGNED NOT NULL,
ARROW TINYINT UNSIGNED NOT NULL,
JUNK TINYINT UNSIGNED NOT NULL,
WAND TINYINT UNSIGNED NOT NULL,
POTION TINYINT UNSIGNED NOT NULL,
SCROLL TINYINT UNSIGNED NOT NULL,
CONTAINER TINYINT UNSIGNED NOT NULL,
COINS TINYINT UNSIGNED NOT NULL,
ARMOR TINYINT UNSIGNED NOT NULL,
WEAPON TINYINT UNSIGNED NOT NULL,
LIGHT_SOURCE TINYINT UNSIGNED NOT NULL,
CANTEEN TINYINT UNSIGNED NOT NULL,
LIQUID TINYINT UNSIGNED NOT NULL,
FOOD TINYINT UNSIGNED NOT NULL,
BOAT TINYINT UNSIGNED NOT NULL,
HAS_SPEC_PROC_DATA TINYINT UNSIGNED NOT NULL,
TOOLBOX TINYINT UNSIGNED NOT NULL,
CAULDRON TINYINT UNSIGNED NOT NULL,
PEN TINYINT UNSIGNED NOT NULL,
CONSTRUCT_COMPONENT TINYINT UNSIGNED NOT NULL,
CONCOCT_COMPONENT TINYINT UNSIGNED NOT NULL,
PARCHMENT TINYINT UNSIGNED NOT NULL,
NEEDS_RESETTING TINYINT UNSIGNED NOT NULL,
HERB TINYINT UNSIGNED NOT NULL,
VENDING_MACHINE TINYINT UNSIGNED NOT NULL,
BULLETIN_BOARD TINYINT UNSIGNED NOT NULL,
IS_BUTCHERABLE TINYINT UNSIGNED NOT NULL,
HAS_OBJ_SCRIPT TINYINT UNSIGNED NOT NULL,
IS_CLOSED TINYINT UNSIGNED NULL,
IS_PICKABLE TINYINT UNSIGNED NULL,
IS_LOCKED TINYINT UNSIGNED NULL,
IS_MAG_LOCKABLE TINYINT UNSIGNED NULL,
IS_MAG_LOCKED TINYINT UNSIGNED NULL,
IS_DESCTRUCTABLE TINYINT UNSIGNED NULL,
IS_CORPSE TINYINT UNSIGNED NULL,
NOT_CLOSABLE TINYINT UNSIGNED NULL,
IS_PLAYER_OWNED TINYINT UNSIGNED NULL,
CONSUMES_KEY TINYINT UNSIGNED NULL,
CONSUME_TELEPORT TINYINT UNSIGNED NULL,
HAS_CONSTRUCT_DATA TINYINT UNSIGNED NULL,
HAS_SKIN TINYINT UNSIGNED NULL,
CONSUME_POISON TINYINT UNSIGNED NULL,
CASTS_SPELLS TINYINT UNSIGNED NULL,
UNIQUE ObjectsIndex(OBJ_NUM, SOBJ_NUM));
CREATE TABLE ObjSpells (OBJ_NUM INTEGER NOT NULL,
SOBJ_NUM INTEGER NOT NULL,
SPELL_NUM SMALLINT UNSIGNED NOT NULL,
DURATION SMALLINT NOT NULL,
UNIQUE ObjSpellsIndex(OBJ_NUM, SOBJ_NUM, SPELL_NUM));
CREATE TABLE ObjStatAff (OBJ_NUM INTEGER NOT NULL,
SOBJ_NUM INTEGER NOT NULL,
STAT SMALLINT UNSIGNED NOT NULL,
ADJUSTMENT SMALLINT NOT NULL,
UNIQUE ObjStatAffIndex(OBJ_NUM, SOBJ_NUM, STAT));
CREATE TABLE ObjCasts (OBJ_NUM INTEGER NOT NULL,
SOBJ_NUM INTEGER NOT NULL,
SPELL_NUM SMALLINT UNSIGNED NOT NULL,
LEVEL TINYINT UNSIGNED NOT NULL,
UNIQUE ObjCastsIndex(OBJ_NUM, SOBJ_NUM, SPELL_NUM));
CREATE TABLE ObjInv (OBJ_NUM INTEGER NOT NULL,
SOBJ_NUM INTEGER NOT NULL,
CONTENT_OBJ_NUM INTEGER NOT NULL,
CONTENT_SOBJ_NUM INTEGER NOT NULL,
QUANTITY SMALLINT UNSIGNED NOT NULL,
UNIQUE ObjInvIndex(OBJ_NUM, SOBJ_NUM, CONTENT_OBJ_NUM,
CONTENT_SOBJ_NUM));
CREATE TABLE ObjScripts (OBJ_NUM INTEGER NOT NULL,
SOBJ_NUM INTEGER NOT NULL,
TRIGGER_CMD VARCHAR(32) NOT NULL,
TARGET INTEGER NOT NULL,
ACTOR INTEGER NOT NULL,
DISCRIMINATOR VARCHAR(96) NOT NULL,
PRECEDENCE SMALLINT NOT NULL,
SCRIPT_COMMANDS TEXT NOT NULL,
UNIQUE ObjScriptsIndex(OBJ_NUM, SOBJ_NUM, TRIGGER_CMD,
TARGET, ACTOR, DISCRIMINATOR));
CREATE TABLE ObjNames (OBJ_NUM INTEGER NOT NULL,
SOBJ_NUM INTEGER NOT NULL,
NAME VARCHAR(128) NOT NULL,
UNIQUE ObjNamesIndex(OBJ_NUM, SOBJ_NUM, NAME));
CREATE TABLE Componants (TARGET_OBJ_NUM INTEGER NOT NULL,
COMPONANT_OBJ_NUM INTEGER NOT NULL,
UNIQUE ComponantsIndex(TARGET_OBJ_NUM,
COMPONANT_OBJ_NUM));
CREATE TABLE Vehicles (ROOM_NUM INTEGER UNSIGNED NOT NULL,
IN_ROOM INTEGER UNSIGNED NOT NULL,
TICKS_BETWEEN_STOPS SMALLINT UNSIGNED NOT NULL,
CUR_FUEL SMALLINT UNSIGNED NOT NULL,
MAX_FUEL SMALLINT UNSIGNED NOT NULL,
SELF_GUIDED TINYINT UNSIGNED NOT NULL,
STEALTHY TINYINT UNSIGNED NOT NULL,
UNLIMITED_FUEL TINYINT UNSIGNED NOT NULL,
FLIES TINYINT UNSIGNED NOT NULL,
CLIMBS TINYINT UNSIGNED NOT NULL,
FLOATS TINYINT UNSIGNED NOT NULL,
DIVES TINYINT UNSIGNED NOT NULL,
CAN_SEE_OUT TINYINT UNSIGNED NOT NULL,
UNIQUE VehiclesIndex (ROOM_NUM));
CREATE TABLE VehiclePaths (ROOM_NUM INTEGER UNSIGNED NOT NULL,
STOP_NUM SMALLINT UNSIGNED NOT NULL,
STOP_ROOM_NUM INTEGER UNSIGNED NOT NULL,
UNIQUE VehiclePathsIndex (ROOM_NUM, STOP_NUM));
CREATE TABLE Rooms (ROOM_NUM INTEGER UNSIGNED NOT NULL,
SHORT_DESC TEXT NOT NULL,
LONG_DESC TEXT NOT NULL,
VIS_BIT BIGINT NOT NULL,
MOVEMENT_COST SMALLINT NOT NULL,
FALL_TO INTEGER UNSIGNED NOT NULL,
IN_ZONE SMALLINT NOT NULL,
NO_RESTRICTIONS TINYINT UNSIGNED NOT NULL,
NO_IMM TINYINT UNSIGNED NOT NULL,
NO_GOD TINYINT UNSIGNED NOT NULL,
IS_PERM_DARK TINYINT UNSIGNED NOT NULL,
WEATHER TINYINT UNSIGNED NOT NULL,
NO_SHOUT TINYINT UNSIGNED NOT NULL,
NO_MAGICAL_EXIT TINYINT UNSIGNED NOT NULL,
IS_HAVEN TINYINT UNSIGNED NOT NULL,
NO_PK TINYINT UNSIGNED NOT NULL,
NO_MAGIC TINYINT UNSIGNED NOT NULL,
NO_MOB TINYINT UNSIGNED NOT NULL,
NO_POTIONS TINYINT UNSIGNED NOT NULL,
NO_STAFFS TINYINT UNSIGNED NOT NULL,
NO_MORTALS TINYINT UNSIGNED NOT NULL,
NORMALLY_DARK TINYINT UNSIGNED NOT NULL,
SHALLOW_WATER TINYINT UNSIGNED NOT NULL,
DEEP_WATER TINYINT UNSIGNED NOT NULL,
SWAMP TINYINT UNSIGNED NOT NULL,
NEED_FLY TINYINT UNSIGNED NOT NULL,
NEED_BOAT TINYINT UNSIGNED NOT NULL,
NEED_CLIMB TINYINT UNSIGNED NOT NULL,
NO_MAGICAL_ENTRY TINYINT UNSIGNED NOT NULL,
NO_VEHICLES TINYINT UNSIGNED NOT NULL,
CRAMPED TINYINT UNSIGNED NOT NULL,
NO_RANGED_ATTACK TINYINT UNSIGNED NOT NULL,
NEED_DIVE TINYINT UNSIGNED NOT NULL,
USED_IN_TRACK TINYINT UNSIGNED NOT NULL,
CAN_CAMP TINYINT UNSIGNED NOT NULL,
HAS_KEYWORDS TINYINT UNSIGNED NOT NULL,
NO_WANDERING_MOBS TINYINT UNSIGNED NOT NULL,
NO_FOREIGN_WANDERING_MOBS TINYINT UNSIGNED NOT NULL,
HAS_PROC_SCRIPT TINYINT UNSIGNED NOT NULL,
UNIQUE RoomsIndex(ROOM_NUM));
CREATE TABLE RoomSpells (ROOM_NUM INTEGER UNSIGNED NOT NULL,
SPELL_NUM SMALLINT UNSIGNED NOT NULL,
DURATION SMALLINT NOT NULL,
UNIQUE RoomSpellsIndex(ROOM_NUM, SPELL_NUM));
CREATE TABLE RoomExits (ROOM_NUM INTEGER UNSIGNED NOT NULL,
EXIT_NUM SMALLINT UNSIGNED NOT NULL,
DOOR_NUM INTEGER UNSIGNED NOT NULL,
DESTINATION INTEGER UNSIGNED NOT NULL,
DISTANCE TINYINT NOT NULL,
UNIQUE RoomExitsIndex(ROOM_NUM, EXIT_NUM));
CREATE TABLE RoomExitSplls (ROOM_NUM INTEGER UNSIGNED NOT NULL,
EXIT_NUM SMALLINT UNSIGNED NOT NULL,
SPELL_NUM SMALLINT UNSIGNED NOT NULL,
DURATION SMALLINT NOT NULL,
UNIQUE RoomExitSpllsIndex(ROOM_NUM, EXIT_NUM,
SPELL_NUM));
CREATE TABLE RoomScripts (ROOM_NUM INTEGER UNSIGNED NOT NULL,
TRIGGER_CMD VARCHAR(32) NOT NULL,
TARGET INTEGER NOT NULL,
ACTOR INTEGER NOT NULL,
DISCRIMINATOR VARCHAR(96) NOT NULL,
PRECEDENCE SMALLINT NOT NULL,
SCRIPT_COMMANDS TEXT NOT NULL,
UNIQUE RoomScriptsIndex(ROOM_NUM, TRIGGER_CMD, TARGET,
ACTOR, DISCRIMINATOR));
CREATE TABLE RoomInv (ROOM_NUM INTEGER UNSIGNED NOT NULL,
OBJ_NUM INTEGER NOT NULL,
SOBJ_NUM INTEGER NOT NULL,
QUANTITY SMALLINT UNSIGNED NOT NULL,
UNIQUE RoomInvIndex(ROOM_NUM, OBJ_NUM, SOBJ_NUM));
CREATE TABLE RoomMobs (ROOM_NUM INTEGER UNSIGNED NOT NULL,
MOB_NUM INTEGER UNSIGNED NOT NULL,
QUANTITY SMALLINT UNSIGNED NOT NULL,
UNIQUE RoomMobsIndex(ROOM_NUM, MOB_NUM));
CREATE TABLE RoomKeywords (ROOM_NUM INTEGER UNSIGNED NOT NULL,
KEYWORD_INDEX SMALLINT UNSIGNED NOT NULL,
DESCRIPTION TEXT NOT NULL,
UNIQUE RoomKeywords(ROOM_NUM, KEYWORD_INDEX));
CREATE TABLE RoomKeynames (ROOM_NUM INTEGER UNSIGNED NOT NULL,
KEYWORD_INDEX SMALLINT UNSIGNED NOT NULL,
KEYWORD VARCHAR(128) NOT NULL,
UNIQUE RoomKeynamesIndex(ROOM_NUM, KEYWORD_INDEX,
KEYWORD));
CREATE TABLE RoomNames (ROOM_NUM INTEGER UNSIGNED NOT NULL,
NAME VARCHAR(128) NOT NULL,
UNIQUE RoomNamesIndex(ROOM_NUM, NAME));
CREATE TABLE Doors (DOOR_NUM INTEGER UNSIGNED NOT NULL,
LONG_DESC TEXT NOT NULL,
VIS_BIT INTEGER UNSIGNED NOT NULL,
TOKEN_NUM INTEGER UNSIGNED NOT NULL,
IN_ZONE INTEGER UNSIGNED NOT NULL,
OPEN_EXIT TINYINT UNSIGNED NOT NULL,
MAGIC_LOCKABLE TINYINT UNSIGNED NOT NULL,
CLOSED TINYINT UNSIGNED NOT NULL,
LOCKED TINYINT UNSIGNED NOT NULL,
PICKABLE TINYINT UNSIGNED NOT NULL,
LOCKABLE TINYINT UNSIGNED NOT NULL,
MAG_LOCKED TINYINT UNSIGNED NOT NULL,
DESTRUCTABLE TINYINT UNSIGNED NOT NULL,
CLOSABLE TINYINT UNSIGNED NOT NULL,
FLIPPABLE TINYINT UNSIGNED NOT NULL,
PC_CANT_OPEN TINYINT UNSIGNED NOT NULL,
VEHICLE_EXIT TINYINT UNSIGNED NOT NULL,
SECRET TINYINT UNSIGNED NOT NULL,
BLOCKED TINYINT UNSIGNED NOT NULL,
SECRET_WHEN_OPEN TINYINT UNSIGNED NOT NULL,
CONSUMES_KEY TINYINT UNSIGNED NOT NULL,
NO_PASSDOOR TINYINT UNSIGNED NOT NULL,
UNIQUE DoorsIndex(DOOR_NUM));
CREATE TABLE DoorNames (DOOR_NUM INTEGER UNSIGNED NOT NULL,
NAME VARCHAR(128) NOT NULL,
UNIQUE DoorNamesIndex(DOOR_NUM, NAME));
CREATE TABLE Zones (ZONE_NUM INTEGER UNSIGNED NOT NULL,
TICKS_IN_REGEN_CYCLE SMALLINT UNSIGNED NOT NULL,
TICKS_TILL_REGEN SMALLINT UNSIGNED NOT NULL,
ZONE_NAME TEXT NOT NULL,
BEGIN_ROOM_NUM INTEGER UNSIGNED NOT NULL,
END_ROOM_NUM INTEGER UNSIGNED NOT NULL,
UNIQUE ZonesIndex(ZONE_NUM));
CREATE TABLE ZoneOwners (ZONE_NUM INTEGER UNSIGNED NOT NULL,
OWNER VARCHAR(128) NOT NULL,
UNIQUE ZoneOwnersIndex(ZONE_NUM, OWNER));
More information about the ScryMUD
mailing list