Woozle at 22:27, 25 August 2013

2013-08-25T22:27:54Z

← Older revision		Revision as of 22:27, 25 August 2013
Line 13:		Line 13:
	`SampSta` INT DEFAULT NULL COMMENT "where the cut starts",		`SampSta` INT DEFAULT NULL COMMENT "where the cut starts",
	`SampFin` INT DEFAULT NULL COMMENT "where the cut ends",		`SampFin` INT DEFAULT NULL COMMENT "where the cut ends",
	PRIMARY KEY(`ID_Cut`,`~~ID_Topic~~`)		PRIMARY KEY(`ID_Cut`,`ID_File`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>

Woozle: Created page with "==About== * '''Purpose''': maps correspondence between cuts and files. Most of the time this will be 1:1, but frequently a single file will contain multiple cuts; a single cut..."

2012-12-25T03:04:37Z

Created page with "==About== * '''Purpose''': maps correspondence between cuts and files. Most of the time this will be 1:1, but frequently a single file will contain multiple cuts; a single cut..."

New page

==About==
* '''Purpose''': maps correspondence between cuts and files. Most of the time this will be 1:1, but frequently a single file will contain multiple cuts; a single cut can also be represented by different files (e.g. different encodings, or different analogue sources).
* '''Relates to''': {{l/same|cuts}}, {{l/same|files}}
* '''Fields''':
** '''SampSta''': sequence number of first sample in the cut; NULL means beginning of file
** '''SampFin''': sequence number of final sample in the cut; NULL means end of file
* '''History''':
** '''2012-12-24''' adapted from {{l/same|cut_x_topic}}
==SQL==
<mysql>CREATE TABLE `cut_x_file` (
`ID_Cut` INT NOT NULL COMMENT "cuts.ID",
`ID_File` INT NOT NULL COMMENT "files.ID",
`SampSta` INT DEFAULT NULL COMMENT "where the cut starts",
`SampFin` INT DEFAULT NULL COMMENT "where the cut ends",
PRIMARY KEY(`ID_Cut`,`ID_Topic`)
) ENGINE = MYISAM;</mysql>

AudioFerret/v2/cut x file - Revision history

Woozle at 22:27, 25 August 2013

Woozle: Created page with "==About== * '''Purpose''': maps correspondence between cuts and files. Most of the time this will be 1:1, but frequently a single file will contain multiple cuts; a single cut..."