Add album, user and path asset unique index

[treebundle] / config / doctrine / Asset.orm.yml

diff --git a/config/doctrine/Asset.orm.yml b/config/doctrine/Asset.orm.yml
new file mode 100644 (file)
index 0000000..0147e90
--- /dev/null
+++ b/config/doctrine/Asset.orm.yml
@@ -0,0 +1,32 @@
+Rapsys\TreeBundle\Entity\Asset:
+    type: entity
+    #repositoryClass: Rapsys\TreeBundle\Repository\AssetRepository
+    table: assets
+    id:
+        id:
+            type: integer
+            generator:
+                strategy: AUTO
+            options:
+                unsigned: true
+    fields:
+        path:
+            type: string
+            length: 4096
+            nullable: true
+        created:
+            type: datetime
+        updated:
+            type: datetime
+    manyToOne:
+        album:
+            targetEntity: Rapsys\TreeBundle\Entity\Album
+            inversedBy: assets
+        user:
+            targetEntity: Rapsys\TreeBundle\Entity\User
+            inversedBy: assets
+    uniqueConstraints:
+        album_user_path:
+            columns: [ album_id, user_id, path ]
+    lifecycleCallbacks:
+        preUpdate: ['preUpdate']