| 1 | <?php |
|---|
| 2 | // $Id$ |
|---|
| 3 | |
|---|
| 4 | /** |
|---|
| 5 | * MediaMosa is Open Source Software to build a Full Featured, Webservice |
|---|
| 6 | * Oriented Media Management and Distribution platform (http://mediamosa.org) |
|---|
| 7 | * |
|---|
| 8 | * Copyright (C) 2009 SURFnet BV (http://www.surfnet.nl) and Kennisnet |
|---|
| 9 | * (http://www.kennisnet.nl) |
|---|
| 10 | * |
|---|
| 11 | * MediaMosa is based on the open source Drupal platform and |
|---|
| 12 | * was originally developed by Madcap BV (http://www.madcap.nl) |
|---|
| 13 | * |
|---|
| 14 | * This program is free software; you can redistribute it and/or modify |
|---|
| 15 | * it under the terms of the GNU General Public License version 2 as |
|---|
| 16 | * published by the Free Software Foundation. |
|---|
| 17 | * This program is distributed in the hope that it will be useful, but |
|---|
| 18 | * WITHOUT ANY WARRANTY; without even the implied warranty of |
|---|
| 19 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU |
|---|
| 20 | * General Public License for more details. |
|---|
| 21 | * |
|---|
| 22 | * You should have received a copy of the GNU General Public License along |
|---|
| 23 | * with this program; if not, you can find it at: |
|---|
| 24 | * http://www.gnu.org/licenses/old-licenses/gpl-2.0.html |
|---|
| 25 | */ |
|---|
| 26 | |
|---|
| 27 | /** |
|---|
| 28 | * @file |
|---|
| 29 | * The database class of the asset_mediafile metadata module. |
|---|
| 30 | */ |
|---|
| 31 | |
|---|
| 32 | class mediamosa_asset_mediafile_metadata_db { |
|---|
| 33 | // ------------------------------------------------------------------ Consts. |
|---|
| 34 | // Table name; |
|---|
| 35 | const TABLE_NAME = 'mediamosa_asset_mediafile_metadata'; |
|---|
| 36 | |
|---|
| 37 | // Database fields; |
|---|
| 38 | const ID = 'metadata_id'; |
|---|
| 39 | const MEDIAFILE_ID = 'mediafile_id'; // 1.x name: mediafile_id. |
|---|
| 40 | const VIDEO_CODEC = 'video_codec'; |
|---|
| 41 | const VIDEO_CODEC_LENGTH = 50; |
|---|
| 42 | const COLORSPACE = 'colorspace'; |
|---|
| 43 | const COLORSPACE_LENGTH = 10; |
|---|
| 44 | const WIDTH = 'width'; |
|---|
| 45 | const HEIGHT = 'height'; |
|---|
| 46 | const FPS = 'fps'; |
|---|
| 47 | const FPS_LENGTH = 10; |
|---|
| 48 | const AUDIO_CODEC = 'audio_codec'; |
|---|
| 49 | const AUDIO_CODEC_LENGTH = 50; |
|---|
| 50 | const SAMPLE_RATE = 'sample_rate'; |
|---|
| 51 | const CHANNELS = 'channels'; |
|---|
| 52 | const CHANNELS_LENGTH = 10; |
|---|
| 53 | const FILE_DURATION = 'file_duration'; |
|---|
| 54 | const FILE_DURATION_LENGTH = 11; |
|---|
| 55 | const CONTAINER_TYPE = 'container_type'; |
|---|
| 56 | const CONTAINER_TYPE_LENGTH = 50; |
|---|
| 57 | const BITRATE = 'bitrate'; |
|---|
| 58 | const BPP = 'bpp'; |
|---|
| 59 | const BPP_LENGTH = 5; |
|---|
| 60 | const FILESIZE = 'filesize'; |
|---|
| 61 | const MIME_TYPE = 'mime_type'; |
|---|
| 62 | const MIME_TYPE_LENGTH = 80; |
|---|
| 63 | const CREATED = 'created'; |
|---|
| 64 | const CHANGED = 'changed'; |
|---|
| 65 | const IS_HINTED = 'is_hinted'; |
|---|
| 66 | const IS_HINTED_TRUE = 'TRUE'; |
|---|
| 67 | const IS_HINTED_FALSE = 'FALSE'; |
|---|
| 68 | const IS_INSERTED_MD = 'is_inserted_md'; |
|---|
| 69 | const IS_INSERTED_MD_TRUE = 'TRUE'; |
|---|
| 70 | const IS_INSERTED_MD_FALSE = 'FALSE'; |
|---|
| 71 | const STILL_TIME_CODE = 'still_time_code'; |
|---|
| 72 | const STILL_ORDER = 'still_order'; |
|---|
| 73 | const STILL_TYPE = 'still_type'; |
|---|
| 74 | const STILL_TYPE_NONE = 'NONE'; |
|---|
| 75 | const STILL_TYPE_NORMAL = 'NORMAL'; |
|---|
| 76 | const STILL_TYPE_SECONDS = 'SECONDS'; |
|---|
| 77 | const STILL_TYPE_SCENE = 'SCENE'; |
|---|
| 78 | const STILL_TYPE_PICTURE = 'PICTURE'; |
|---|
| 79 | const STILL_FORMAT = 'still_format'; |
|---|
| 80 | const STILL_FORMAT_LENGTH = 50; |
|---|
| 81 | const STILL_DEFAULT = 'still_default'; |
|---|
| 82 | const STILL_DEFAULT_TRUE = 'TRUE'; |
|---|
| 83 | const STILL_DEFAULT_FALSE = 'FALSE'; |
|---|
| 84 | } |
|---|