Access requirement 548 - Revision history

Admin at 23:05, 8 August 2021

2021-08-08T23:05:13Z

← Older revision		Revision as of 18:05, 8 August 2021
Line 126:		Line 126:
	{\| border="1"<br>		{\| border="1"<br>
	<pre style="color: red">		<pre style="color: red">
	~~<code>~~		CREATE TABLE `access_requirement` (
	CREATE TABLE `access_requirement` (~~<br>~~		`mapId` MEDIUMINT NOT NULL,
	`mapId` MEDIUMINT NOT NULL,~~<br>~~		`difficulty` TINYINT NOT NULL DEFAULT '0',
	`difficulty` TINYINT NOT NULL DEFAULT '0',~~<br>~~		`level_min` TINYINT NOT NULL DEFAULT '0',
	`level_min` TINYINT NOT NULL DEFAULT '0',~~<br>~~		`level_max` TINYINT NOT NULL DEFAULT '0',
	`level_max` TINYINT NOT NULL DEFAULT '0',~~<br>~~		`item` MEDIUMINT NOT NULL DEFAULT '0',
	`item` MEDIUMINT NOT NULL DEFAULT '0',~~<br>~~		`item2` MEDIUMINT NOT NULL DEFAULT '0',
	`item2` MEDIUMINT NOT NULL DEFAULT '0',~~<br>~~		`quest_done_A` MEDIUMINT NOT NULL DEFAULT '0',
	`quest_done_A` MEDIUMINT NOT NULL DEFAULT '0',~~<br>~~		`quest_done_H` MEDIUMINT NOT NULL DEFAULT '0',
	`quest_done_H` MEDIUMINT NOT NULL DEFAULT '0',~~<br>~~		`completed_achievement` MEDIUMINT NOT NULL DEFAULT '0',
	`completed_achievement` MEDIUMINT NOT NULL DEFAULT '0',~~<br>~~		`quest_failed_text` TEXT NULL COLLATE 'utf8_general_ci',
	`quest_failed_text` TEXT NULL COLLATE 'utf8_general_ci',~~<br>~~		`iLvl` MEDIUMINT NOT NULL DEFAULT '0',
	`iLvl` MEDIUMINT NOT NULL DEFAULT '0',~~<br>~~		`comment` TEXT NULL COLLATE 'utf8_general_ci',
	`comment` TEXT NULL COLLATE 'utf8_general_ci',~~<br>~~		PRIMARY KEY (`mapId`, `difficulty`) USING BTREE
	PRIMARY KEY (`mapId`, `difficulty`) USING BTREE~~<br>~~		)
	)~~<br>~~		COMMENT='Access Requirements'
	COMMENT='Access Requirements'~~<br>~~		COLLATE='utf8_general_ci'
	COLLATE='utf8_general_ci'~~<br>~~		ENGINE=MyISAM
	ENGINE=MyISAM~~<br>~~		ROW_FORMAT=DYNAMIC
	ROW_FORMAT=DYNAMIC~~<br>~~
	;		;
	~~</code>~~
	</pre>		</pre>
	<br>		<br>

Admin: Derp

2021-08-08T22:59:21Z

Derp

← Older revision		Revision as of 17:59, 8 August 2021
Line 199:		Line 199:

	This field is for any comment you want to make about the requirements. It is arbitrary text.		This field is for any comment you want to make about the requirements. It is arbitrary text.

	~~[[World_18414\|Return to world database structure]]~~

Admin at 22:58, 8 August 2021

2021-08-08T22:58:53Z

← Older revision		Revision as of 17:58, 8 August 2021
Line 200:		Line 200:
	This field is for any comment you want to make about the requirements. It is arbitrary text.		This field is for any comment you want to make about the requirements. It is arbitrary text.

	[[~~DB:World~~\|Return to world database structure]]		[[World_18414\|Return to world database structure]]

Admin: Update structure and add DB structure.

2021-08-08T22:57:46Z

Update structure and add DB structure.

← Older revision		Revision as of 17:57, 8 August 2021
Line 122:		Line 122:
	\|}		\|}

			<br> <big>'''DB Structure'''</big>
			<br>
			{\| border="1"<br>
			<pre style="color: red">
			<code>
			CREATE TABLE `access_requirement` (<br>
			`mapId` MEDIUMINT NOT NULL,<br>
			`difficulty` TINYINT NOT NULL DEFAULT '0',<br>
			`level_min` TINYINT NOT NULL DEFAULT '0',<br>
			`level_max` TINYINT NOT NULL DEFAULT '0',<br>
			`item` MEDIUMINT NOT NULL DEFAULT '0',<br>
			`item2` MEDIUMINT NOT NULL DEFAULT '0',<br>
			`quest_done_A` MEDIUMINT NOT NULL DEFAULT '0',<br>
			`quest_done_H` MEDIUMINT NOT NULL DEFAULT '0',<br>
			`completed_achievement` MEDIUMINT NOT NULL DEFAULT '0',<br>
			`quest_failed_text` TEXT NULL COLLATE 'utf8_general_ci',<br>
			`iLvl` MEDIUMINT NOT NULL DEFAULT '0',<br>
			`comment` TEXT NULL COLLATE 'utf8_general_ci',<br>
			PRIMARY KEY (`mapId`, `difficulty`) USING BTREE<br>
			)<br>
			COMMENT='Access Requirements'<br>
			COLLATE='utf8_general_ci'<br>
			ENGINE=MyISAM<br>
			ROW_FORMAT=DYNAMIC<br>
			;
			</code>
			</pre>
			<br>
	<br> <big>'''Description of the fields'''</big>		<br> <big>'''Description of the fields'''</big>

Admin at 21:08, 8 August 2021

2021-08-08T21:08:23Z

← Older revision		Revision as of 16:08, 8 August 2021
Line 3:		Line 3:
	\| __TOC__		\| __TOC__
	\|}		\|}
	{{Back-to~~:DB~~:World_18414}}		{{Back-to:World_18414}}

	<br> <big>'''The `access_requirement` table'''</big>		<br> <big>'''The `access_requirement` table'''</big>

Admin at 21:06, 8 August 2021

2021-08-08T21:06:39Z

← Older revision		Revision as of 16:06, 8 August 2021
Line 3:		Line 3:
	\| __TOC__		\| __TOC__
	\|}		\|}
	{{Back-to:~~World_548~~}}		{{Back-to:DB:World_18414}}

	<br> <big>'''The `access_requirement` table'''</big>		<br> <big>'''The `access_requirement` table'''</big>
Line 172:		Line 172:
	This field is for any comment you want to make about the requirements. It is arbitrary text.		This field is for any comment you want to make about the requirements. It is arbitrary text.

	[[DB:~~World_548~~\|Return to world database structure]]		[[DB:World\|Return to world database structure]]

Admin at 21:05, 8 August 2021

2021-08-08T21:05:18Z

Show changes

Admin at 21:04, 8 August 2021

2021-08-08T21:04:11Z

← Older revision		Revision as of 16:04, 8 August 2021
Line 1:		Line 1:
	Back to [[DB:~~World~~\|world database]] list of tables.		Back to [[DB:World_548\|world database]] list of tables.

Admin: Created page with "Back to world database list of tables."

2021-08-08T21:03:53Z

Created page with "Back to world database list of tables."

New page

Back to [[DB:World|world database]] list of tables.