OS/2 Shareware BBS: 6 File/06-File.zip/dirsc01a.zip/createfilestable.sql

Text File | 2000-06-12 | 523b | 1 lines

CREATE TABLE Files (ID int(11) DEFAULT '0' NOT NULL AUTO_INCREMENT,Platform ENUM('BeOS x86','DOS','Linux x86','Netware','OS/2','Solaris x86','Unix','Windows','Other') DEFAULT 'Windows' NOT NULL,Application ENUM('Graphics','Utils','Drivers','Operation System','Networks','Internet','WEB Design','Audio Tools','Music','Video','Video Tools','3D Animation','Bussines','Other') DEFAULT 'Utils' NOT NULL, Header VARCHAR (50),Date DATE,Times TIME,Autor VARCHAR (60),Email VARCHAR (60),URL VARCHAR (80),Text BLOB,PRIMARY KEY (ID));