Difference between revisions of "AudioFerret/v2/files"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(Created page with "==About== * '''Status''': there will be more to this table later, including length (# of samples, sample rate), type (WAV, FLAC, OGG, MP3...), and possibly other things. ==SQL...")
 
m
 
Line 4: Line 4:
 
<mysql>CREATE TABLE `files` (
 
<mysql>CREATE TABLE `files` (
 
   `ID`        INT              NOT NULL AUTO_INCREMENT,
 
   `ID`        INT              NOT NULL AUTO_INCREMENT,
   `Spec`      VARCHAR(255)    NOT NULL COMMENT "filespec, relative to AudioFerret's storage folder"
+
   `Spec`      VARCHAR(255)    NOT NULL COMMENT "filespec, relative to AudioFerret's storage folder",
 
   PRIMARY KEY(`ID`)
 
   PRIMARY KEY(`ID`)
 
) ENGINE = MYISAM;</mysql>
 
) ENGINE = MYISAM;</mysql>

Latest revision as of 22:25, 25 August 2013

About

  • Status: there will be more to this table later, including length (# of samples, sample rate), type (WAV, FLAC, OGG, MP3...), and possibly other things.

SQL

<mysql>CREATE TABLE `files` (

 `ID`        INT              NOT NULL AUTO_INCREMENT,
 `Spec`      VARCHAR(255)     NOT NULL COMMENT "filespec, relative to AudioFerret's storage folder",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>