create-clips.sql

CREATE TABLE IF NOT EXISTS `DATABASE_NAME`.`clips` ( `id` INT NOT NULL AUTO_INCREMENT, `shortname` VARCHAR(11) NOT NULL , `title` VARCHAR(255) NOT NULL, `extension` VARCHAR(5) NOT NULL , `description` TEXT NOT NULL , `host` VARCHAR(255) NOT NULL , `posted` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `user` INT NOT NULL , `views` INT NOT NULL DEFAULT '0' , PRIMARY KEY (`id`) , UNIQUE `shortname` (`shortname`) ) ENGINE = InnoDB;