/* Expected Revision: 2009-12-31 */

/* A Table to track binary references. The actual data is stored outside the database to provide
 * for easier dumping/loading capabilities.
 */
create table %PREFIX%resource (
	`ID` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
	`Name` VARCHAR(200) NOT NULL,
	`ExportName` VARCHAR(100),
	`Type` VARCHAR(200) NOT NULL,
	`Uploader` INT UNSIGNED NOT NULL,
	`When` DATETIME NOT NULL,
	`Status` TINYINT NOT NULL,
	`MD5Hash` CHAR(32) NOT NULL,
	INDEX( `Name` )
)
	CHARACTER SET utf8 
	COLLATE utf8_unicode_ci
;

UPDATE %PREFIX%meta Set Value='2010-01-03' WHERE Name='Version';
