add factories.yml.tmpl
authorIRI
Wed, 24 Mar 2010 17:16:21 +0100
changeset 24 8faec1632643
parent 23 6c5bf4fc94ee
child 25 31cc2136a768
add factories.yml.tmpl
.hgignore
web/thdProject/apps/frontend/config/factories.yml
web/thdProject/apps/frontend/config/factories.yml.tmpl
web/thdProject/data/sql/schema.sql
web/thdProject/lib/model/doctrine/base/BaseThdFilm.class.php
web/thdProject/lib/model/doctrine/base/BaseThdImage.class.php
web/thdProject/lib/model/doctrine/base/BaseThdSegment.class.php
web/thdProject/lib/model/doctrine/base/BaseThdVideo.class.php
--- 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/.*$
 
--- 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
--- /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
--- 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;
--- 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 @@
-<?php
-
-/**
- * This class has been auto-generated by the Doctrine ORM Framework
- */
-abstract class BaseThdFilm extends sfDoctrineRecord
-{
-    public function setTableDefinition()
-    {
-        $this->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'));
-    }
+<?php
+
+/**
+ * This class has been auto-generated by the Doctrine ORM Framework
+ */
+abstract class BaseThdFilm extends sfDoctrineRecord
+{
+    public function setTableDefinition()
+    {
+        $this->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
--- 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 @@
-<?php
-
-/**
- * This class has been auto-generated by the Doctrine ORM Framework
- */
-abstract class BaseThdImage extends sfDoctrineRecord
-{
-    public function setTableDefinition()
-    {
-        $this->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'));
-    }
+<?php
+
+/**
+ * This class has been auto-generated by the Doctrine ORM Framework
+ */
+abstract class BaseThdImage extends sfDoctrineRecord
+{
+    public function setTableDefinition()
+    {
+        $this->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
--- 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 @@
-<?php
-
-/**
- * This class has been auto-generated by the Doctrine ORM Framework
- */
-abstract class BaseThdSegment extends sfDoctrineRecord
-{
-    public function setTableDefinition()
-    {
-        $this->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'));
-    }
+<?php
+
+/**
+ * This class has been auto-generated by the Doctrine ORM Framework
+ */
+abstract class BaseThdSegment extends sfDoctrineRecord
+{
+    public function setTableDefinition()
+    {
+        $this->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
--- 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 @@
-<?php
-
-/**
- * This class has been auto-generated by the Doctrine ORM Framework
- */
-abstract class BaseThdVideo extends sfDoctrineRecord
-{
-    public function setTableDefinition()
-    {
-        $this->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'));
-    }
+<?php
+
+/**
+ * This class has been auto-generated by the Doctrine ORM Framework
+ */
+abstract class BaseThdVideo extends sfDoctrineRecord
+{
+    public function setTableDefinition()
+    {
+        $this->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