# HG changeset patch # User IRI # Date 1269447381 -3600 # Node ID 8faec1632643fd2dff341a2dfc5c1853f59de161 # Parent 6c5bf4fc94eea64eadc0386630d0f9e4976ecc56 add factories.yml.tmpl diff -r 6c5bf4fc94ee -r 8faec1632643 .hgignore --- a/.hgignore Wed Mar 24 17:10:22 2010 +0100 +++ b/.hgignore Wed Mar 24 17:16:21 2010 +0100 @@ -7,7 +7,8 @@ ^web/thdProject/web/phpinfo.php$ ^web/thdProject/log/.*$ ^web/thdProject/upload/.*$ -^web/thdProject/apps/frontend/configi/app.yml$ +^web/thdProject/apps/frontend/config/app.yml$ +^web/thdProject/apps/frontend/config/factories.yml$ ^engine/solr/context.xml$ ^engine/solr/solr/data/.*$ diff -r 6c5bf4fc94ee -r 8faec1632643 web/thdProject/apps/frontend/config/factories.yml --- a/web/thdProject/apps/frontend/config/factories.yml Wed Mar 24 17:10:22 2010 +0100 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,140 +0,0 @@ -prod: - logger: - class: sfNoLogger - param: - level: err - loggers: ~ - -cli: - controller: - class: sfConsoleController - request: - class: sfConsoleRequest - response: - class: sfConsoleResponse - -test: - storage: - class: sfSessionTestStorage - param: - session_path: %SF_TEST_CACHE_DIR%/sessions - - response: - class: sfWebResponse - param: - send_http_headers: false - -all: - routing: - class: sfPatternRouting - param: - generate_shortest_url: true - extra_parameters_as_query_string: true - - request: - class: sfWebRequest - param: - logging: %SF_LOGGING_ENABLED% - path_info_array: SERVER - path_info_key: PATH_INFO - relative_url_root: /web/thdProject/web - -#all: -# controller: -# class: sfFrontWebController -# -# request: -# class: sfWebRequest -# param: -# logging: %SF_LOGGING_ENABLED% -# path_info_array: SERVER -# path_info_key: PATH_INFO -# relative_url_root: ~ -# formats: -# txt: text/plain -# js: [application/javascript, application/x-javascript, text/javascript] -# css: text/css -# json: [application/json, application/x-json] -# xml: [text/xml, application/xml, application/x-xml] -# rdf: application/rdf+xml -# atom: application/atom+xml -# -# response: -# class: sfWebResponse -# param: -# logging: %SF_LOGGING_ENABLED% -# charset: %SF_CHARSET% -# send_http_headers: true -# -# user: -# class: myUser -# param: -# timeout: 1800 -# logging: %SF_LOGGING_ENABLED% -# use_flash: true -# default_culture: %SF_DEFAULT_CULTURE% -# -# storage: -# class: sfSessionStorage -# param: -# session_name: symfony -# -# view_cache: -# class: sfFileCache -# param: -# automatic_cleaning_factor: 0 -# cache_dir: %SF_TEMPLATE_CACHE_DIR% -# lifetime: 86400 -# prefix: %SF_APP_DIR%/template -# -# i18n: -# class: sfI18N -# param: -# source: XLIFF -# debug: off -# untranslated_prefix: "[T]" -# untranslated_suffix: "[/T]" -# cache: -# class: sfFileCache -# param: -# automatic_cleaning_factor: 0 -# cache_dir: %SF_I18N_CACHE_DIR% -# lifetime: 31556926 -# prefix: %SF_APP_DIR%/i18n -# -# routing: -# class: sfPatternRouting -# param: -# load_configuration: true -# suffix: '' -# default_module: default -# default_action: index -# debug: %SF_DEBUG% -# logging: %SF_LOGGING_ENABLED% -# generate_shortest_url: false -# extra_parameters_as_query_string: false -# cache: -# class: sfFileCache -# param: -# automatic_cleaning_factor: 0 -# cache_dir: %SF_CONFIG_CACHE_DIR%/routing -# lifetime: 31556926 -# prefix: %SF_APP_DIR%/routing -# -# logger: -# class: sfAggregateLogger -# param: -# level: debug -# loggers: -# sf_web_debug: -# class: sfWebDebugLogger -# param: -# level: debug -# condition: %SF_WEB_DEBUG% -# xdebug_logging: true -# web_debug_class: sfWebDebug -# sf_file_debug: -# class: sfFileLogger -# param: -# level: debug -# file: %SF_LOG_DIR%/%SF_APP%_%SF_ENVIRONMENT%.log diff -r 6c5bf4fc94ee -r 8faec1632643 web/thdProject/apps/frontend/config/factories.yml.tmpl --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/web/thdProject/apps/frontend/config/factories.yml.tmpl Wed Mar 24 17:16:21 2010 +0100 @@ -0,0 +1,140 @@ +prod: + logger: + class: sfNoLogger + param: + level: err + loggers: ~ + +cli: + controller: + class: sfConsoleController + request: + class: sfConsoleRequest + response: + class: sfConsoleResponse + +test: + storage: + class: sfSessionTestStorage + param: + session_path: %SF_TEST_CACHE_DIR%/sessions + + response: + class: sfWebResponse + param: + send_http_headers: false + +all: + routing: + class: sfPatternRouting + param: + generate_shortest_url: true + extra_parameters_as_query_string: true + + request: + class: sfWebRequest + param: + logging: %SF_LOGGING_ENABLED% + path_info_array: SERVER + path_info_key: PATH_INFO + relative_url_root: /mosatags + +#all: +# controller: +# class: sfFrontWebController +# +# request: +# class: sfWebRequest +# param: +# logging: %SF_LOGGING_ENABLED% +# path_info_array: SERVER +# path_info_key: PATH_INFO +# relative_url_root: ~ +# formats: +# txt: text/plain +# js: [application/javascript, application/x-javascript, text/javascript] +# css: text/css +# json: [application/json, application/x-json] +# xml: [text/xml, application/xml, application/x-xml] +# rdf: application/rdf+xml +# atom: application/atom+xml +# +# response: +# class: sfWebResponse +# param: +# logging: %SF_LOGGING_ENABLED% +# charset: %SF_CHARSET% +# send_http_headers: true +# +# user: +# class: myUser +# param: +# timeout: 1800 +# logging: %SF_LOGGING_ENABLED% +# use_flash: true +# default_culture: %SF_DEFAULT_CULTURE% +# +# storage: +# class: sfSessionStorage +# param: +# session_name: symfony +# +# view_cache: +# class: sfFileCache +# param: +# automatic_cleaning_factor: 0 +# cache_dir: %SF_TEMPLATE_CACHE_DIR% +# lifetime: 86400 +# prefix: %SF_APP_DIR%/template +# +# i18n: +# class: sfI18N +# param: +# source: XLIFF +# debug: off +# untranslated_prefix: "[T]" +# untranslated_suffix: "[/T]" +# cache: +# class: sfFileCache +# param: +# automatic_cleaning_factor: 0 +# cache_dir: %SF_I18N_CACHE_DIR% +# lifetime: 31556926 +# prefix: %SF_APP_DIR%/i18n +# +# routing: +# class: sfPatternRouting +# param: +# load_configuration: true +# suffix: '' +# default_module: default +# default_action: index +# debug: %SF_DEBUG% +# logging: %SF_LOGGING_ENABLED% +# generate_shortest_url: false +# extra_parameters_as_query_string: false +# cache: +# class: sfFileCache +# param: +# automatic_cleaning_factor: 0 +# cache_dir: %SF_CONFIG_CACHE_DIR%/routing +# lifetime: 31556926 +# prefix: %SF_APP_DIR%/routing +# +# logger: +# class: sfAggregateLogger +# param: +# level: debug +# loggers: +# sf_web_debug: +# class: sfWebDebugLogger +# param: +# level: debug +# condition: %SF_WEB_DEBUG% +# xdebug_logging: true +# web_debug_class: sfWebDebug +# sf_file_debug: +# class: sfFileLogger +# param: +# level: debug +# file: %SF_LOG_DIR%/%SF_APP%_%SF_ENVIRONMENT%.log diff -r 6c5bf4fc94ee -r 8faec1632643 web/thdProject/data/sql/schema.sql --- a/web/thdProject/data/sql/schema.sql Wed Mar 24 17:10:22 2010 +0100 +++ b/web/thdProject/data/sql/schema.sql Wed Mar 24 17:16:21 2010 +0100 @@ -1,7 +1,7 @@ CREATE TABLE thd_film (id INT UNSIGNED AUTO_INCREMENT, ref VARCHAR(255) NOT NULL, title VARCHAR(255) NOT NULL, pitch TEXT NOT NULL, duration INT NOT NULL, directors TEXT NOT NULL, actors TEXT NOT NULL, slug_url VARCHAR(255) NOT NULL, original_title VARCHAR(255), production_countries TEXT NOT NULL, production_year BIGINT, uniqueid VARCHAR(36) NOT NULL, UNIQUE INDEX uniqueidindex_idx (uniqueid), PRIMARY KEY(id)) ENGINE = INNODB; CREATE TABLE thd_image (id INT UNSIGNED AUTO_INCREMENT, type TINYINT NOT NULL, file VARCHAR(255) NOT NULL, film_id INT UNSIGNED NOT NULL, INDEX film_id_idx (film_id), PRIMARY KEY(id)) ENGINE = INNODB; +CREATE TABLE thd_segment (id INT UNSIGNED AUTO_INCREMENT, title VARCHAR(255), tags TEXT, description TEXT, video_ref INT NOT NULL, start DOUBLE NOT NULL, end DOUBLE NOT NULL, user_id INT NOT NULL, creation_date DATETIME NOT NULL, uniqueid VARCHAR(36) NOT NULL, video_id INT UNSIGNED NOT NULL, UNIQUE INDEX uniqueidindex_idx (uniqueid), INDEX video_id_idx (video_id), PRIMARY KEY(id)) ENGINE = INNODB; CREATE TABLE thd_video (id INT UNSIGNED AUTO_INCREMENT, ref VARCHAR(255) NOT NULL, file VARCHAR(255) NOT NULL, title VARCHAR(255), film_id INT UNSIGNED NOT NULL, INDEX film_id_idx (film_id), PRIMARY KEY(id)) ENGINE = INNODB; -CREATE TABLE thd_segment (id INT UNSIGNED AUTO_INCREMENT, title VARCHAR(255), tags TEXT, description TEXT, video_ref INT NOT NULL, start DOUBLE NOT NULL, end DOUBLE NOT NULL, user_id INT NOT NULL, creation_date DATETIME NOT NULL, uniqueid VARCHAR(36) NOT NULL, video_id INT UNSIGNED NOT NULL, UNIQUE INDEX uniqueidindex_idx (uniqueid), INDEX video_id_idx (video_id), PRIMARY KEY(id)) ENGINE = INNODB; ALTER TABLE thd_image ADD FOREIGN KEY (film_id) REFERENCES thd_film(id) ON DELETE CASCADE; +ALTER TABLE thd_segment ADD FOREIGN KEY (video_id) REFERENCES thd_video(id) ON DELETE CASCADE; ALTER TABLE thd_video ADD FOREIGN KEY (film_id) REFERENCES thd_film(id) ON DELETE CASCADE; -ALTER TABLE thd_segment ADD FOREIGN KEY (video_id) REFERENCES thd_video(id) ON DELETE CASCADE; diff -r 6c5bf4fc94ee -r 8faec1632643 web/thdProject/lib/model/doctrine/base/BaseThdFilm.class.php --- a/web/thdProject/lib/model/doctrine/base/BaseThdFilm.class.php Wed Mar 24 17:10:22 2010 +0100 +++ b/web/thdProject/lib/model/doctrine/base/BaseThdFilm.class.php Wed Mar 24 17:16:21 2010 +0100 @@ -1,92 +1,92 @@ -setTableName('thd_film'); - $this->hasColumn('id', 'integer', 4, array( - 'type' => 'integer', - 'unsigned' => '1', - 'primary' => true, - 'autoincrement' => true, - 'length' => '4', - )); - $this->hasColumn('ref', 'string', 255, array( - 'type' => 'string', - 'notnull' => true, - 'length' => '255', - )); - $this->hasColumn('title', 'string', 255, array( - 'type' => 'string', - 'notnull' => true, - 'length' => '255', - )); - $this->hasColumn('pitch', 'string', 2147483647, array( - 'type' => 'string', - 'notnull' => true, - 'length' => '2147483647', - )); - $this->hasColumn('duration', 'integer', 4, array( - 'type' => 'integer', - 'notnull' => true, - 'length' => '4', - )); - $this->hasColumn('directors', 'string', 2147483647, array( - 'type' => 'string', - 'notnull' => true, - 'length' => '2147483647', - )); - $this->hasColumn('actors', 'string', 2147483647, array( - 'type' => 'string', - 'notnull' => true, - 'length' => '2147483647', - )); - $this->hasColumn('slug_url', 'string', 255, array( - 'type' => 'string', - 'notnull' => true, - 'length' => '255', - )); - $this->hasColumn('original_title', 'string', 255, array( - 'type' => 'string', - 'length' => '255', - )); - $this->hasColumn('production_countries', 'string', 2147483647, array( - 'type' => 'string', - 'notnull' => true, - 'length' => '2147483647', - )); - $this->hasColumn('production_year', 'integer', 8, array( - 'type' => 'integer', - 'length' => '8', - )); - $this->hasColumn('uniqueid', 'string', 36, array( - 'type' => 'string', - 'notnull' => true, - 'length' => '36', - )); - - - $this->index('uniqueidindex', array( - 'fields' => - array( - 0 => 'uniqueid', - ), - 'type' => 'unique', - )); - } - - public function setUp() - { - $this->hasMany('ThdImage as images', array( - 'local' => 'id', - 'foreign' => 'film_id')); - - $this->hasMany('ThdVideo as videos', array( - 'local' => 'id', - 'foreign' => 'film_id')); - } +setTableName('thd_film'); + $this->hasColumn('id', 'integer', 4, array( + 'type' => 'integer', + 'unsigned' => '1', + 'primary' => true, + 'autoincrement' => true, + 'length' => '4', + )); + $this->hasColumn('ref', 'string', 255, array( + 'type' => 'string', + 'notnull' => true, + 'length' => '255', + )); + $this->hasColumn('title', 'string', 255, array( + 'type' => 'string', + 'notnull' => true, + 'length' => '255', + )); + $this->hasColumn('pitch', 'string', 2147483647, array( + 'type' => 'string', + 'notnull' => true, + 'length' => '2147483647', + )); + $this->hasColumn('duration', 'integer', 4, array( + 'type' => 'integer', + 'notnull' => true, + 'length' => '4', + )); + $this->hasColumn('directors', 'string', 2147483647, array( + 'type' => 'string', + 'notnull' => true, + 'length' => '2147483647', + )); + $this->hasColumn('actors', 'string', 2147483647, array( + 'type' => 'string', + 'notnull' => true, + 'length' => '2147483647', + )); + $this->hasColumn('slug_url', 'string', 255, array( + 'type' => 'string', + 'notnull' => true, + 'length' => '255', + )); + $this->hasColumn('original_title', 'string', 255, array( + 'type' => 'string', + 'length' => '255', + )); + $this->hasColumn('production_countries', 'string', 2147483647, array( + 'type' => 'string', + 'notnull' => true, + 'length' => '2147483647', + )); + $this->hasColumn('production_year', 'integer', 8, array( + 'type' => 'integer', + 'length' => '8', + )); + $this->hasColumn('uniqueid', 'string', 36, array( + 'type' => 'string', + 'notnull' => true, + 'length' => '36', + )); + + + $this->index('uniqueidindex', array( + 'fields' => + array( + 0 => 'uniqueid', + ), + 'type' => 'unique', + )); + } + + public function setUp() + { + $this->hasMany('ThdImage as images', array( + 'local' => 'id', + 'foreign' => 'film_id')); + + $this->hasMany('ThdVideo as videos', array( + 'local' => 'id', + 'foreign' => 'film_id')); + } } \ No newline at end of file diff -r 6c5bf4fc94ee -r 8faec1632643 web/thdProject/lib/model/doctrine/base/BaseThdImage.class.php --- a/web/thdProject/lib/model/doctrine/base/BaseThdImage.class.php Wed Mar 24 17:10:22 2010 +0100 +++ b/web/thdProject/lib/model/doctrine/base/BaseThdImage.class.php Wed Mar 24 17:16:21 2010 +0100 @@ -1,43 +1,43 @@ -setTableName('thd_image'); - $this->hasColumn('id', 'integer', 4, array( - 'type' => 'integer', - 'unsigned' => '1', - 'primary' => true, - 'autoincrement' => true, - 'length' => '4', - )); - $this->hasColumn('type', 'integer', 1, array( - 'type' => 'integer', - 'notnull' => true, - 'length' => '1', - )); - $this->hasColumn('file', 'string', 255, array( - 'type' => 'string', - 'notnull' => true, - 'length' => '255', - )); - $this->hasColumn('film_id', 'integer', 4, array( - 'type' => 'integer', - 'unsigned' => '1', - 'notnull' => true, - 'length' => '4', - )); - } - - public function setUp() - { - $this->hasOne('ThdFilm', array( - 'local' => 'film_id', - 'foreign' => 'id', - 'onDelete' => 'CASCADE')); - } +setTableName('thd_image'); + $this->hasColumn('id', 'integer', 4, array( + 'type' => 'integer', + 'unsigned' => '1', + 'primary' => true, + 'autoincrement' => true, + 'length' => '4', + )); + $this->hasColumn('type', 'integer', 1, array( + 'type' => 'integer', + 'notnull' => true, + 'length' => '1', + )); + $this->hasColumn('file', 'string', 255, array( + 'type' => 'string', + 'notnull' => true, + 'length' => '255', + )); + $this->hasColumn('film_id', 'integer', 4, array( + 'type' => 'integer', + 'unsigned' => '1', + 'notnull' => true, + 'length' => '4', + )); + } + + public function setUp() + { + $this->hasOne('ThdFilm', array( + 'local' => 'film_id', + 'foreign' => 'id', + 'onDelete' => 'CASCADE')); + } } \ No newline at end of file diff -r 6c5bf4fc94ee -r 8faec1632643 web/thdProject/lib/model/doctrine/base/BaseThdSegment.class.php --- a/web/thdProject/lib/model/doctrine/base/BaseThdSegment.class.php Wed Mar 24 17:10:22 2010 +0100 +++ b/web/thdProject/lib/model/doctrine/base/BaseThdSegment.class.php Wed Mar 24 17:16:21 2010 +0100 @@ -1,84 +1,84 @@ -setTableName('thd_segment'); - $this->hasColumn('id', 'integer', 4, array( - 'type' => 'integer', - 'unsigned' => '1', - 'primary' => true, - 'autoincrement' => true, - 'length' => '4', - )); - $this->hasColumn('title', 'string', 255, array( - 'type' => 'string', - 'length' => '255', - )); - $this->hasColumn('tags', 'string', 1024, array( - 'type' => 'string', - 'length' => '1024', - )); - $this->hasColumn('description', 'string', 2147483647, array( - 'type' => 'string', - 'length' => '2147483647', - )); - $this->hasColumn('video_ref', 'integer', 4, array( - 'type' => 'integer', - 'notnull' => true, - 'length' => '4', - )); - $this->hasColumn('start', 'float', 2147483647, array( - 'type' => 'float', - 'notnull' => true, - 'length' => '2147483647', - )); - $this->hasColumn('end', 'float', 2147483647, array( - 'type' => 'float', - 'notnull' => true, - 'length' => '2147483647', - )); - $this->hasColumn('user_id', 'integer', 4, array( - 'type' => 'integer', - 'notnull' => true, - 'length' => '4', - )); - $this->hasColumn('creation_date', 'timestamp', 25, array( - 'type' => 'timestamp', - 'notnull' => true, - 'length' => '25', - )); - $this->hasColumn('uniqueid', 'string', 36, array( - 'type' => 'string', - 'notnull' => true, - 'length' => '36', - )); - $this->hasColumn('video_id', 'integer', 4, array( - 'type' => 'integer', - 'unsigned' => '1', - 'notnull' => true, - 'length' => '4', - )); - - - $this->index('uniqueidindex', array( - 'fields' => - array( - 0 => 'uniqueid', - ), - 'type' => 'unique', - )); - } - - public function setUp() - { - $this->hasOne('ThdVideo', array( - 'local' => 'video_id', - 'foreign' => 'id', - 'onDelete' => 'CASCADE')); - } +setTableName('thd_segment'); + $this->hasColumn('id', 'integer', 4, array( + 'type' => 'integer', + 'unsigned' => '1', + 'primary' => true, + 'autoincrement' => true, + 'length' => '4', + )); + $this->hasColumn('title', 'string', 255, array( + 'type' => 'string', + 'length' => '255', + )); + $this->hasColumn('tags', 'string', 1024, array( + 'type' => 'string', + 'length' => '1024', + )); + $this->hasColumn('description', 'string', 2147483647, array( + 'type' => 'string', + 'length' => '2147483647', + )); + $this->hasColumn('video_ref', 'integer', 4, array( + 'type' => 'integer', + 'notnull' => true, + 'length' => '4', + )); + $this->hasColumn('start', 'float', 2147483647, array( + 'type' => 'float', + 'notnull' => true, + 'length' => '2147483647', + )); + $this->hasColumn('end', 'float', 2147483647, array( + 'type' => 'float', + 'notnull' => true, + 'length' => '2147483647', + )); + $this->hasColumn('user_id', 'integer', 4, array( + 'type' => 'integer', + 'notnull' => true, + 'length' => '4', + )); + $this->hasColumn('creation_date', 'timestamp', 25, array( + 'type' => 'timestamp', + 'notnull' => true, + 'length' => '25', + )); + $this->hasColumn('uniqueid', 'string', 36, array( + 'type' => 'string', + 'notnull' => true, + 'length' => '36', + )); + $this->hasColumn('video_id', 'integer', 4, array( + 'type' => 'integer', + 'unsigned' => '1', + 'notnull' => true, + 'length' => '4', + )); + + + $this->index('uniqueidindex', array( + 'fields' => + array( + 0 => 'uniqueid', + ), + 'type' => 'unique', + )); + } + + public function setUp() + { + $this->hasOne('ThdVideo', array( + 'local' => 'video_id', + 'foreign' => 'id', + 'onDelete' => 'CASCADE')); + } } \ No newline at end of file diff -r 6c5bf4fc94ee -r 8faec1632643 web/thdProject/lib/model/doctrine/base/BaseThdVideo.class.php --- a/web/thdProject/lib/model/doctrine/base/BaseThdVideo.class.php Wed Mar 24 17:10:22 2010 +0100 +++ b/web/thdProject/lib/model/doctrine/base/BaseThdVideo.class.php Wed Mar 24 17:16:21 2010 +0100 @@ -1,51 +1,51 @@ -setTableName('thd_video'); - $this->hasColumn('id', 'integer', 4, array( - 'type' => 'integer', - 'unsigned' => '1', - 'primary' => true, - 'autoincrement' => true, - 'length' => '4', - )); - $this->hasColumn('ref', 'string', 255, array( - 'type' => 'string', - 'notnull' => true, - 'length' => '255', - )); - $this->hasColumn('file', 'string', 255, array( - 'type' => 'string', - 'notnull' => true, - 'length' => '255', - )); - $this->hasColumn('title', 'string', 255, array( - 'type' => 'string', - 'length' => '255', - )); - $this->hasColumn('film_id', 'integer', 4, array( - 'type' => 'integer', - 'unsigned' => '1', - 'notnull' => true, - 'length' => '4', - )); - } - - public function setUp() - { - $this->hasOne('ThdFilm', array( - 'local' => 'film_id', - 'foreign' => 'id', - 'onDelete' => 'CASCADE')); - - $this->hasMany('ThdSegment as segments', array( - 'local' => 'id', - 'foreign' => 'video_id')); - } +setTableName('thd_video'); + $this->hasColumn('id', 'integer', 4, array( + 'type' => 'integer', + 'unsigned' => '1', + 'primary' => true, + 'autoincrement' => true, + 'length' => '4', + )); + $this->hasColumn('ref', 'string', 255, array( + 'type' => 'string', + 'notnull' => true, + 'length' => '255', + )); + $this->hasColumn('file', 'string', 255, array( + 'type' => 'string', + 'notnull' => true, + 'length' => '255', + )); + $this->hasColumn('title', 'string', 255, array( + 'type' => 'string', + 'length' => '255', + )); + $this->hasColumn('film_id', 'integer', 4, array( + 'type' => 'integer', + 'unsigned' => '1', + 'notnull' => true, + 'length' => '4', + )); + } + + public function setUp() + { + $this->hasOne('ThdFilm', array( + 'local' => 'film_id', + 'foreign' => 'id', + 'onDelete' => 'CASCADE')); + + $this->hasMany('ThdSegment as segments', array( + 'local' => 'id', + 'foreign' => 'video_id')); + } } \ No newline at end of file