]> Raphaƫl G. Git Repositories - airbundle/blob - Resources/config/doctrine/Location.orm.yml
Update zipcode index with two leading characters
[airbundle] / Resources / config / doctrine / Location.orm.yml
1 Rapsys\AirBundle\Entity\Location:
2 type: entity
3 repositoryClass: Rapsys\AirBundle\Repository\LocationRepository
4 table: locations
5 id:
6 id:
7 type: integer
8 generator:
9 strategy: AUTO
10 options:
11 unsigned: true
12 fields:
13 title:
14 type: string
15 length: 32
16 description:
17 type: text
18 nullable: true
19 address:
20 type: string
21 length: 32
22 zipcode:
23 type: string
24 length: 5
25 city:
26 type: string
27 length: 64
28 latitude:
29 type: decimal
30 precision: 8
31 scale: 6
32 longitude:
33 type: decimal
34 precision: 9
35 scale: 6
36 indoor:
37 type: boolean
38 hotspot:
39 type: boolean
40 created:
41 type: datetime
42 updated:
43 type: datetime
44 oneToMany:
45 sessions:
46 targetEntity: Rapsys\AirBundle\Entity\Session
47 mappedBy: location
48 snippets:
49 targetEntity: Rapsys\AirBundle\Entity\Snippet
50 mappedBy: location
51 manyToMany:
52 users:
53 targetEntity: Rapsys\AirBundle\Entity\User
54 mappedBy: locations
55 indexes:
56 #XXX: used in SessionRepository::(findAllPendingDailyWeather|findAllPendingHourlyWeather)
57 zipcode:
58 columns: [ zipcode ]
59 city_zipcode3:
60 columns: [ city, zipcode ]
61 #XXX: see https://github.com/doctrine/dbal/pull/2412 and https://stackoverflow.com/questions/32539973/configuring-index-text-length-mysql-in-doctrine
62 options:
63 lengths: [ ~, 2 ]
64 lifecycleCallbacks:
65 preUpdate: ['preUpdate']