Archive:Database Schema 4.0 - Revision history

Karellen at 06:31, 1 August 2020

2020-08-01T06:31:52Z

← Older revision		Revision as of 06:31, 1 August 2020
Line 1:		Line 1:
	~~{{mininav\|[[Development]]}}~~

	'''Revision: 1400h - 25 Sep 10'''		'''Revision: 1400h - 25 Sep 10'''

Line 748:		Line 746:
	</pre>		</pre>

	[[Category:Development]]		[[Category:Development-Archived]]

2020-08-01T06:31:24Z

Karellen moved page Database Schema 4.0 to Archive:Database Schema 4.0 without leaving a redirect: Proposed 2010 design

← Older revision	Revision as of 06:31, 1 August 2020
(No difference)

2013-09-02T08:12:14Z

2011-11-27T02:29:16Z

2011-11-27T02:28:28Z

2011-11-27T02:28:01Z

2011-09-07T16:08:38Z

Robot: Cosmetic changes

← Older revision		Revision as of 16:08, 7 September 2011
Line 283:		Line 283:
	You can see the inheritance at work here and the versatility provided by the EAV/CR structure.		You can see the inheritance at work here and the versatility provided by the EAV/CR structure.

	The "hybrid" comes from the fact that there are still some legacy tables remaining that I haven't yet determined if they would be suitable in the EAV/CR portion and perhaps would be better suited at remaining a dedicated tables. The latest schema has been able to reduce all the link tables down to one - objectlinkdirent. This link table is the primary link between the metadata and the playable/viewable item.		The "hybrid" comes from the fact that there are still some legacy tables remaining that I haven't yet determined if they would be suitable in the EAV/CR portion and perhaps would be better suited at remaining a dedicated tables. The latest schema has been able to reduce all the link tables down to one - objectlinkdirent. This link table is the primary link between the metadata and the playable/viewable item.

2010-09-24T04:55:31Z

Updated to the EAV/CR schema

2010-06-18T06:32:34Z

Table: content: renamed videocontent to content in index

← Older revision		Revision as of 06:32, 18 June 2010
Line 229:		Line 229:
	);		);

	CREATE INDEX ixEpisodeSeason ON ~~videocontent~~ (episode ASC, season ASC) ;		CREATE INDEX ixEpisodeSeason ON content (episode ASC, season ASC) ;
	</pre>		</pre>

2010-06-18T05:24:18Z

Table: dirents

← Older revision		Revision as of 05:24, 18 June 2010
Line 328:		Line 328:
	direntFileHash VARCHAR(32) NULL ,		direntFileHash VARCHAR(32) NULL ,
	direntContentHash VARCHAR(32) NULL ,		direntContentHash VARCHAR(32) NULL ,
	settings TEXT NULL ,		settings TEXT NULL
	);		);

	CREATE INDEX ixPathFilename ON dirents (idPath ASC, direntFilename ASC) ;		CREATE INDEX ixPathFilename ON dirents (idPath ASC, direntFilename ASC) ;
	</pre>		</pre>



	=== Table: contentlinkdirent ===		=== Table: contentlinkdirent ===