EsoTalk database - Revision history

Grntbg at 05:32, 18 February 2024

2024-02-18T05:32:07Z

← Older revision		Revision as of 05:32, 18 February 2024
Line 1:		Line 1:
	[[Category:esoTalk]]		[[Category:esoTalk]]
			[[Category:Forum software]]
	[[Category:Serious]]		[[Category:Serious]]
	The '''esoTalk database schema''' refers to the database structure used by [[esoTalk]] and its derivative project [[esoBB]]. The forum software uses a relatively simple database structure categorized into the separate categorical aspects of a basic forum. The tables are as follows: conversations, logins, members, posts, searches, shouts, status and tags. Each table contains a primary or borrowed key which is used to reference the conversation or post number (<code>conversationId</code> and <code>postId</code> respectively) and member count (<code>memberId</code>).		The '''esoTalk database schema''' refers to the database structure used by [[esoTalk]] and its derivative project [[esoBB]]. The forum software uses a relatively simple database structure categorized into the separate categorical aspects of a basic forum. The tables are as follows: conversations, logins, members, posts, searches, shouts, status and tags. Each table contains a primary or borrowed key which is used to reference the conversation or post number (<code>conversationId</code> and <code>postId</code> respectively) and member count (<code>memberId</code>).

Grntbg at 05:20, 18 February 2024

2024-02-18T05:20:13Z

← Older revision		Revision as of 05:20, 18 February 2024
Line 1:		Line 1:
			[[Category:esoTalk]]
			[[Category:Serious]]
	The '''esoTalk database schema''' refers to the database structure used by [[esoTalk]] and its derivative project [[esoBB]]. The forum software uses a relatively simple database structure categorized into the separate categorical aspects of a basic forum. The tables are as follows: conversations, logins, members, posts, searches, shouts, status and tags. Each table contains a primary or borrowed key which is used to reference the conversation or post number (<code>conversationId</code> and <code>postId</code> respectively) and member count (<code>memberId</code>).		The '''esoTalk database schema''' refers to the database structure used by [[esoTalk]] and its derivative project [[esoBB]]. The forum software uses a relatively simple database structure categorized into the separate categorical aspects of a basic forum. The tables are as follows: conversations, logins, members, posts, searches, shouts, status and tags. Each table contains a primary or borrowed key which is used to reference the conversation or post number (<code>conversationId</code> and <code>postId</code> respectively) and member count (<code>memberId</code>).

Grntbg at 00:42, 23 January 2024

2024-01-23T00:42:33Z

← Older revision		Revision as of 00:42, 23 January 2024
Line 1:		Line 1:
	The '''esoTalk database schema''' refers to the database structure used by [[esoTalk]] and its derivative project [[esoBB]]. The forum software uses a relatively simple database structure categorized into the separate categorical aspects of a basic forum. The tables are as follows: conversations, logins, members, posts, searches, shouts, status and tags. Each table contains a primary or borrowed key which is used to reference the conversation or post number (conversationId and postId respectively) and member (memberId).		The '''esoTalk database schema''' refers to the database structure used by [[esoTalk]] and its derivative project [[esoBB]]. The forum software uses a relatively simple database structure categorized into the separate categorical aspects of a basic forum. The tables are as follows: conversations, logins, members, posts, searches, shouts, status and tags. Each table contains a primary or borrowed key which is used to reference the conversation or post number (<code>conversationId</code> and <code>postId</code> respectively) and member count (<code>memberId</code>).

	The forum software relies upon a relational SQL-based database system in order to manage members, conversations and posts. The software officially supports MySQL and MariaDB; other MySQL-based softwares are known to work.		The forum software relies upon a relational SQL-based database system in order to manage members, conversations and posts. The software officially supports MySQL and MariaDB; other MySQL-based softwares are known to work. On a default installation, the database prefix is <code>et_</code>.

			==History==
			esoTalk has used the same basic database schema since its inception, with tables being added by way of new features. During beta 1, the <code>et_status</code> table was added to the schema in order to recall the conversation page being viewed by a particular user.

			==Terminology==
			Since esoTalk beta 1, user log-ins have recorded the client's IP address in the form of a "cookie IP." The <code>cookieIP</code> column is used in both the members and logins tables, the latter of which is used to record the number of attempted log-ins and password requests in order to prevent spam. The purpose of the cookie IP was highly conflated by the [[Esoteric Chat]] community, with its purpose often going exaggerated. Since esoBB beta 2, the cookie IP has been stored in a hashed form.

Grntbg: Created page with "The '''esoTalk database schema''' refers to the database structure used by esoTalk and its derivative project esoBB. The forum software uses a relatively simple database structure categorized into the separate categorical aspects of a basic forum. The tables are as follows: conversations, logins, members, posts, searches, shouts, status and tags. Each table contains a primary or borrowed key which is used to reference the conversation or post number (conversat..."

2024-01-21T23:15:55Z

Created page with "The '''esoTalk database schema''' refers to the database structure used by esoTalk and its derivative project esoBB. The forum software uses a relatively simple database structure categorized into the separate categorical aspects of a basic forum. The tables are as follows: conversations, logins, members, posts, searches, shouts, status and tags. Each table contains a primary or borrowed key which is used to reference the conversation or post number (conversat..."

New page

The '''esoTalk database schema''' refers to the database structure used by [[esoTalk]] and its derivative project [[esoBB]]. The forum software uses a relatively simple database structure categorized into the separate categorical aspects of a basic forum. The tables are as follows: conversations, logins, members, posts, searches, shouts, status and tags. Each table contains a primary or borrowed key which is used to reference the conversation or post number (conversationId and postId respectively) and member (memberId).

The forum software relies upon a relational SQL-based database system in order to manage members, conversations and posts. The software officially supports MySQL and MariaDB; other MySQL-based softwares are known to work.