Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 3.5.7
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: Sep 03, 2013 at 05:33 PM
- -- Server version: 5.5.29
- -- PHP Version: 5.4.10
- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- --
- -- Database: `interestdb`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `media_type`
- --
- CREATE TABLE `media_type` (
- `name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'The machine name of the media type.',
- `label` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'The label of the media type.',
- `base` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'If this is a base type (i.e. cannot be deleted)',
- `weight` INT(11) NOT NULL DEFAULT '0' COMMENT 'Weight of media type. Determines which one wins when claiming a piece of media (first wins)',
- `type_callback` VARCHAR(255) DEFAULT '' COMMENT 'Callback to determine if provided media is of this type.',
- `type_callback_args` longtext COMMENT 'A serialized array of name value pairs that will be passed to the callback function',
- PRIMARY KEY (`name`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores the settings for media types.';
- --
- -- Dumping data for table `media_type`
- --
- INSERT INTO `media_type` (`name`, `label`, `base`, `weight`, `type_callback`, `type_callback_args`) VALUES
- ('audio', 'Audio', 1, 0, 'media_is_type', 'a:4:{s:10:"match_type";s:3:"all";s:9:"mimetypes";a:1:{i:0;s:8:"/^audio/";}s:10:"extensions";a:3:{i:0;s:3:"mp3";i:1;s:3:"ogg";i:2;s:3:"wma";}s:7:"streams";a:2:{i:0;s:6:"public";i:1;s:7:"private";}}'),
- ('default', 'Other', 1, 1000, 'media_is_type', 'a:2:{s:10:"match_type";s:3:"any";s:9:"mimetypes";a:1:{i:0;s:4:"/.*/";}}'),
- ('image', 'Image', 1, 0, 'media_is_type', 'a:4:{s:10:"match_type";s:3:"all";s:9:"mimetypes";a:1:{i:0;s:8:"/^image/";}s:10:"extensions";a:5:{i:0;s:3:"jpg";i:1;s:4:"jpeg";i:2;s:3:"gif";i:3;s:3:"png";i:4;s:4:"tiff";}s:7:"streams";a:2:{i:0;s:6:"public";i:1;s:7:"private";}}'),
- ('video', 'Video', 1, 0, 'media_is_type', 'a:4:{s:10:"match_type";s:3:"all";s:9:"mimetypes";a:1:{i:0;s:8:"/^video/";}s:10:"extensions";a:3:{i:0;s:3:"mov";i:1;s:3:"mp4";i:2;s:3:"avi";}s:7:"streams";a:2:{i:0;s:6:"public";i:1;s:7:"private";}}');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement