Update zipcode index with two leading characters

[airbundle] / Resources / config / doctrine / User.orm.yml

diff --git a/Resources/config/doctrine/User.orm.yml b/Resources/config/doctrine/User.orm.yml
index 8a9b7de6fcf787cb82a6b63bd8b832038c40b6fb..600265143341e2a5fcc2e992288a715081cc4781 100644 (file)
--- a/Resources/config/doctrine/User.orm.yml
+++ b/Resources/config/doctrine/User.orm.yml
@@ -3,19 +3,22 @@ Rapsys\AirBundle\Entity\User:
     repositoryClass: Rapsys\AirBundle\Repository\UserRepository
     table: users
     fields:
     repositoryClass: Rapsys\AirBundle\Repository\UserRepository
     table: users
     fields:

-        pseudonym:
+        city:

             type: string
             type: string

-            length: 32
+            length: 64

             nullable: true
         phone:
             type: string
             length: 16
             nullable: true
             nullable: true
         phone:
             type: string
             length: 16
             nullable: true

-        slug:
+        pseudonym:

             type: string
             type: string

-            unique: true

             length: 32
             nullable: true
             length: 32
             nullable: true

+        zipcode:
+            type: string
+            length: 5
+            nullable: true

     oneToMany:
         applications:
             targetEntity: Rapsys\AirBundle\Entity\Application
     oneToMany:
         applications:
             targetEntity: Rapsys\AirBundle\Entity\Application


@@ -23,6 +26,9 @@ Rapsys\AirBundle\Entity\User:
         snippets:
             targetEntity: Rapsys\AirBundle\Entity\Snippet
             mappedBy: user
         snippets:
             targetEntity: Rapsys\AirBundle\Entity\Snippet
             mappedBy: user

+        googleTokens:
+            targetEntity: Rapsys\AirBundle\Entity\GoogleToken
+            mappedBy: user

     manyToMany:
         dances:
             targetEntity: Rapsys\AirBundle\Entity\Dance
     manyToMany:
         dances:
             targetEntity: Rapsys\AirBundle\Entity\Dance


@@ -37,7 +43,10 @@ Rapsys\AirBundle\Entity\User:
                         name: dance_id
         subscribers:
             targetEntity: Rapsys\AirBundle\Entity\User
                         name: dance_id
         subscribers:
             targetEntity: Rapsys\AirBundle\Entity\User

-            inversedBy: subscriptions
+            mappedBy: subscriptions
+        subscriptions:
+            targetEntity: Rapsys\AirBundle\Entity\User
+            inversedBy: subscribers

             joinTable:
                 name: users_subscriptions
                 joinColumns:
             joinTable:
                 name: users_subscriptions
                 joinColumns:


@@ -46,9 +55,6 @@ Rapsys\AirBundle\Entity\User:
                 inverseJoinColumns:
                     id:
                         name: subscriber_id
                 inverseJoinColumns:
                     id:
                         name: subscriber_id

-        subscriptions:
-            targetEntity: Rapsys\AirBundle\Entity\User
-            mappedBy: subscribers

         locations:
             targetEntity: Rapsys\AirBundle\Entity\Location
             inversedBy: users
         locations:
             targetEntity: Rapsys\AirBundle\Entity\Location
             inversedBy: users


@@ -60,6 +66,10 @@ Rapsys\AirBundle\Entity\User:
                 inverseJoinColumns:
                     id:
                         name: location_id
                 inverseJoinColumns:
                     id:
                         name: location_id

+    manyToOne:
+        country:
+            targetEntity: Rapsys\AirBundle\Entity\Country
+            inversedBy: users

 #    manyToMany:
 #        groups:
 #            targetEntity: Group
 #    manyToMany:
 #        groups:
 #            targetEntity: Group