aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/assets/schema_dump_5_1.yml
blob: f37977daf24be5158b30e2ed49476af7a33cd649 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
--- !ruby/object:ActiveRecord::ConnectionAdapters::SchemaCache
columns:
  posts:
  - &1 !ruby/object:ActiveRecord::ConnectionAdapters::Column
    name: id
    table_name: posts
    sql_type_metadata: !ruby/object:ActiveRecord::ConnectionAdapters::SqlTypeMetadata
      sql_type: INTEGER
      type: :integer
      limit: 
      precision: 
      scale: 
    'null': false
    default: 
    default_function: 
    collation: 
    comment: 
  - &2 !ruby/object:ActiveRecord::ConnectionAdapters::Column
    name: author_id
    table_name: posts
    sql_type_metadata: !ruby/object:ActiveRecord::ConnectionAdapters::SqlTypeMetadata
      sql_type: integer
      type: :integer
      limit: 
      precision: 
      scale: 
    'null': true
    default: 
    default_function: 
    collation: 
    comment: 
  - &3 !ruby/object:ActiveRecord::ConnectionAdapters::Column
    name: title
    table_name: posts
    sql_type_metadata: !ruby/object:ActiveRecord::ConnectionAdapters::SqlTypeMetadata
      sql_type: varchar
      type: :string
      limit: 
      precision: 
      scale: 
    'null': false
    default: 
    default_function: 
    collation: 
    comment: 
  - &4 !ruby/object:ActiveRecord::ConnectionAdapters::Column
    name: body
    table_name: posts
    sql_type_metadata: !ruby/object:ActiveRecord::ConnectionAdapters::SqlTypeMetadata
      sql_type: text
      type: :text
      limit: 
      precision: 
      scale: 
    'null': false
    default: 
    default_function: 
    collation: 
    comment: 
  - &5 !ruby/object:ActiveRecord::ConnectionAdapters::Column
    name: type
    table_name: posts
    sql_type_metadata: !ruby/object:ActiveRecord::ConnectionAdapters::SqlTypeMetadata
      sql_type: varchar
      type: :string
      limit: 
      precision: 
      scale: 
    'null': true
    default: 
    default_function: 
    collation: 
    comment: 
  - &6 !ruby/object:ActiveRecord::ConnectionAdapters::Column
    name: comments_count
    table_name: posts
    sql_type_metadata: !ruby/object:ActiveRecord::ConnectionAdapters::SqlTypeMetadata
      sql_type: integer
      type: :integer
      limit: 
      precision: 
      scale: 
    'null': true
    default: '0'
    default_function: 
    collation: 
    comment: 
  - &7 !ruby/object:ActiveRecord::ConnectionAdapters::Column
    name: taggings_with_delete_all_count
    table_name: posts
    sql_type_metadata: !ruby/object:ActiveRecord::ConnectionAdapters::SqlTypeMetadata
      sql_type: integer
      type: :integer
      limit: 
      precision: 
      scale: 
    'null': true
    default: '0'
    default_function: 
    collation: 
    comment: 
  - &8 !ruby/object:ActiveRecord::ConnectionAdapters::Column
    name: taggings_with_destroy_count
    table_name: posts
    sql_type_metadata: !ruby/object:ActiveRecord::ConnectionAdapters::SqlTypeMetadata
      sql_type: integer
      type: :integer
      limit: 
      precision: 
      scale: 
    'null': true
    default: '0'
    default_function: 
    collation: 
    comment: 
  - &9 !ruby/object:ActiveRecord::ConnectionAdapters::Column
    name: tags_count
    table_name: posts
    sql_type_metadata: !ruby/object:ActiveRecord::ConnectionAdapters::SqlTypeMetadata
      sql_type: integer
      type: :integer
      limit: 
      precision: 
      scale: 
    'null': true
    default: '0'
    default_function: 
    collation: 
    comment: 
  - &10 !ruby/object:ActiveRecord::ConnectionAdapters::Column
    name: tags_with_destroy_count
    table_name: posts
    sql_type_metadata: !ruby/object:ActiveRecord::ConnectionAdapters::SqlTypeMetadata
      sql_type: integer
      type: :integer
      limit: 
      precision: 
      scale: 
    'null': true
    default: '0'
    default_function: 
    collation: 
    comment: 
  - &11 !ruby/object:ActiveRecord::ConnectionAdapters::Column
    name: tags_with_nullify_count
    table_name: posts
    sql_type_metadata: !ruby/object:ActiveRecord::ConnectionAdapters::SqlTypeMetadata
      sql_type: integer
      type: :integer
      limit: 
      precision: 
      scale: 
    'null': true
    default: '0'
    default_function: 
    collation: 
    comment: 
columns_hash:
  posts:
    id: *1
    author_id: *2
    title: *3
    body: *4
    type: *5
    comments_count: *6
    taggings_with_delete_all_count: *7
    taggings_with_destroy_count: *8
    tags_count: *9
    tags_with_destroy_count: *10
    tags_with_nullify_count: *11
primary_keys:
  posts: id
data_sources:
  ar_internal_metadata: true
  table_with_autoincrement: true
  accounts: true
  admin_accounts: true
  admin_users: true
  aircraft: true
  articles: true
  articles_magazines: true
  articles_tags: true
  audit_logs: true
  authors: true
  author_addresses: true
  author_favorites: true
  auto_id_tests: true
  binaries: true
  birds: true
  books: true
  booleans: true
  bulbs: true
  CamelCase: true
  cars: true
  carriers: true
  categories: true
  categories_posts: true
  categorizations: true
  citations: true
  clubs: true
  collections: true
  colnametests: true
  columns: true
  comments: true
  companies: true
  content: true
  content_positions: true
  vegetables: true
  computers: true
  computers_developers: true
  contracts: true
  customers: true
  customer_carriers: true
  dashboards: true
  developers: true
  developers_projects: true
  dog_lovers: true
  dogs: true
  doubloons: true
  edges: true
  engines: true
  entrants: true
  essays: true
  events: true
  eyes: true
  funny_jokes: true
  cold_jokes: true
  friendships: true
  goofy_string_id: true
  having: true
  guids: true
  guitars: true
  inept_wizards: true
  integer_limits: true
  invoices: true
  iris: true
  items: true
  jobs: true
  jobs_pool: true
  keyboards: true
  legacy_things: true
  lessons: true
  lessons_students: true
  students: true
  lint_models: true
  line_items: true
  lions: true
  lock_without_defaults: true
  lock_without_defaults_cust: true
  magazines: true
  mateys: true
  members: true
  member_details: true
  member_friends: true
  memberships: true
  member_types: true
  mentors: true
  minivans: true
  minimalistics: true
  mixed_case_monkeys: true
  mixins: true
  movies: true
  notifications: true
  numeric_data: true
  orders: true
  organizations: true
  owners: true
  paint_colors: true
  paint_textures: true
  parrots: true
  parrots_pirates: true
  parrots_treasures: true
  people: true
  peoples_treasures: true
  personal_legacy_things: true
  pets: true
  pets_treasures: true
  pirates: true
  posts: true
  serialized_posts: true
  images: true
  price_estimates: true
  products: true
  product_types: true
  projects: true
  randomly_named_table1: true
  randomly_named_table2: true
  randomly_named_table3: true
  ratings: true
  readers: true
  references: true
  shape_expressions: true
  ships: true
  ship_parts: true
  prisoners: true
  shop_accounts: true
  speedometers: true
  sponsors: true
  string_key_objects: true
  subscribers: true
  subscriptions: true
  tags: true
  taggings: true
  tasks: true
  topics: true
  toys: true
  traffic_lights: true
  treasures: true
  tuning_pegs: true
  tyres: true
  variants: true
  vertices: true
  warehouse-things: true
  circles: true
  squares: true
  triangles: true
  non_poly_ones: true
  non_poly_twos: true
  men: true
  faces: true
  interests: true
  zines: true
  wheels: true
  countries: true
  treaties: true
  countries_treaties: true
  liquid: true
  molecules: true
  electrons: true
  weirds: true
  nodes: true
  trees: true
  hotels: true
  departments: true
  cake_designers: true
  drink_designers: true
  chefs: true
  recipes: true
  records: true
  overloaded_types: true
  users: true
  test_with_keyword_column_name: true
  fk_test_has_pk: true
  fk_test_has_fk: true
version: 0