aCkmjJge

1--Adiciona novos atributos a seleção de produtos
2insert into product_attributes values (8, 'B', true, 8, 4), (9, 'Cu', true, 9, 4),(10, 'Mn', true, 10, 4),(11, 'Fe', true, 11, 4),(12, 'Zn', true, 12, 4);
3
4--Atualiza o nome dos tipos de produto
5update product_types set name = 'Corretivos' where id = 1;
6update product_types set alias = 'corretivos' where id = 1;
7update product_types set name = 'Fertilizantes' where id = 3;
8update product_types set alias = 'fertilizantes' where id = 3;
9
10
11---- Altera pest stages para pheno stages
12ALTER TABLE pest_stages RENAME TO pheno_stages;
13ALTER TABLE pheno_stages DROP CONSTRAINT pest_stages_culture_id_foreign;
14ALTER TABLE pheno_stages ADD CONSTRAINT pest_stages_culture_id_foreign FOREIGN KEY (culture_id) REFERENCES cultures (id);
15
16--Agendas de Campo
17
18CREATE TABLE treatment_types
19(
20  id serial,
21  name text NOT NULL,
22  created_at timestamp(0) without time zone,
23  updated_at timestamp(0) without time zone,
24  CONSTRAINT treatment_types_pkey PRIMARY KEY (id)
25)
26WITH (
27  OIDS=FALSE
28);
29
30------
31CREATE TABLE handle_soil_types
32(
33  id serial,
34  name text NOT NULL,
35  created_at timestamp(0) without time zone,
36  updated_at timestamp(0) without time zone,
37  CONSTRAINT handle_soil_types_pkey PRIMARY KEY (id)
38)
39WITH (
40  OIDS=FALSE
41);
42
43-------
44
45CREATE TABLE planting_materials (
46    id serial,
47    name text NOT NULL,
48    created_at timestamp(0) without time zone,
49    updated_at timestamp(0) without time zone,
50    culture_id integer NOT NULL,
51    CONSTRAINT planting_materials_pkey PRIMARY KEY (id),
52    CONSTRAINT planting_materials_culture_id_foreign FOREIGN KEY (culture_id)
53    REFERENCES cultures (id) MATCH SIMPLE
54    ON UPDATE NO ACTION ON DELETE NO ACTION
55) WITH (
56    OIDS=FALSE
57);
58
59------
60
61CREATE TABLE agendas
62(
63  id serial,
64  field_id bigint NOT NULL,
65  treatment_type_id integer,
66  handle_soil_type_id integer NOT NULL,
67  planting_material_id integer,
68  culture_id integer NOT NULL,
69  treatment_date date,
70  handle_soil_date date,
71  planting_date date NOT NULL,
72  emergence_date date NOT NULL,
73  pp_planting double precision NOT NULL,
74  pp_emergence double precision NOT NULL,
75  cicle integer,
76  spacing double precision NOT NULL,
77  speed double precision,
78  operator text,
79  harvest_date date,
80  productivity integer,
81  loss_perc double precision,
82  humidity double precision,
83  pms double precision,
84  impurities double precision,
85  created_at timestamp(0) without time zone,
86  updated_at timestamp(0) without time zone,
87  created_by integer NOT NULL,
88  updated_by integer,
89  CONSTRAINT agendas_pkey PRIMARY KEY (id),
90  CONSTRAINT agendas_created_by_foreign FOREIGN KEY (created_by)
91      REFERENCES users (id) MATCH SIMPLE
92      ON UPDATE NO ACTION ON DELETE CASCADE,
93  CONSTRAINT agendas_culture_id_foreign FOREIGN KEY (culture_id)
94      REFERENCES cultures (id) MATCH SIMPLE
95      ON UPDATE NO ACTION ON DELETE NO ACTION,
96  CONSTRAINT agendas_field_id_foreign FOREIGN KEY (field_id)
97      REFERENCES fields (id) MATCH SIMPLE
98      ON UPDATE NO ACTION ON DELETE CASCADE,
99  CONSTRAINT agendas_handle_soil_type_id_foreign FOREIGN KEY (handle_soil_type_id)
100      REFERENCES handle_soil_types (id) MATCH SIMPLE
101      ON UPDATE NO ACTION ON DELETE NO ACTION,
102  CONSTRAINT agendas_planting_material_id_foreign FOREIGN KEY (planting_material_id)
103      REFERENCES planting_materials (id) MATCH SIMPLE
104      ON UPDATE NO ACTION ON DELETE NO ACTION,
105  CONSTRAINT agendas_treatment_type_id_foreign FOREIGN KEY (treatment_type_id)
106      REFERENCES treatment_types (id) MATCH SIMPLE
107      ON UPDATE NO ACTION ON DELETE NO ACTION
108)
109WITH (
110  OIDS=FALSE
111);
112
113-----
114ALTER TABLE pheno_stages ADD CONSTRAINT IF NOT EXISTS pheno_stages_id_unique UNIQUE (id);
115
116CREATE TABLE agenda_applications
117(
118  id serial,
119  agenda_id bigint NOT NULL,
120  pheno_stage_id integer NOT NULL,
121  name text NOT NULL,
122  operator text NOT NULL,
123  performed_at date NOT NULL,
124  CONSTRAINT agenda_applications_pkey PRIMARY KEY (id),
125  CONSTRAINT agenda_applications_agenda_id_foreign FOREIGN KEY (agenda_id)
126      REFERENCES agendas (id) MATCH SIMPLE
127      ON UPDATE NO ACTION ON DELETE CASCADE,
128  CONSTRAINT agenda_applications_pheno_stage_id_foreign FOREIGN KEY (pheno_stage_id)
129      REFERENCES pheno_stages (id) MATCH SIMPLE
130      ON UPDATE NO ACTION ON DELETE CASCADE
131)
132WITH (
133  OIDS=FALSE
134);
135
136-----
137
138CREATE TABLE agenda_products
139(
140  id serial,
141  agenda_id bigint NOT NULL,
142  application_id bigint,
143  type_id integer NOT NULL,
144  applied_at date,
145  name text NOT NULL,
146  dosage double precision NOT NULL,
147  price double precision NOT NULL,
148  created_at timestamp(0) without time zone,
149  updated_at timestamp(0) without time zone,
150  CONSTRAINT agenda_products_pkey PRIMARY KEY (id),
151  CONSTRAINT agenda_products_agenda_id_foreign FOREIGN KEY (agenda_id)
152      REFERENCES agendas (id) MATCH SIMPLE
153      ON UPDATE NO ACTION ON DELETE CASCADE,
154  CONSTRAINT agenda_products_application_id_foreign FOREIGN KEY (application_id)
155      REFERENCES agenda_applications (id) MATCH SIMPLE
156      ON UPDATE NO ACTION ON DELETE CASCADE
157)
158WITH (
159  OIDS=FALSE
160);
161
162--treatment types
163INSERT INTO treatment_types VALUES (1, 'On Farm', NULL, NULL);
164INSERT INTO treatment_types VALUES (2, 'TSI', NULL, NULL);
165
166--handle_soil_types
167INSERT INTO handle_soil_types (id, name, created_at, updated_at) VALUES (1, 'Gradagem', NULL, NULL);
168INSERT INTO handle_soil_types (id, name, created_at, updated_at) VALUES (2, 'Subsolagem', NULL, NULL);
169INSERT INTO handle_soil_types (id, name, created_at, updated_at) VALUES (3, 'Outro', NULL, NULL);
170INSERT INTO handle_soil_types (id, name, created_at, updated_at) VALUES (4, 'Não Fez', NULL, NULL);
171
172--users 
173ALTER TABLE users ADD COLUMN john_deere_token TEXT;
174
175--crop
176ALTER TABLE crops ADD COLUMN expired_at date null;
177UPDATE crops SET expired_at = created_at + interval '1 year';
178
179
180
181
182update cultures set name = 'Citros' where name = 'Citrús';
183
184--Novas Culturas
185insert into cultures (id, name) VALUES 
186(15, 'Amendoim'),
187(16, 'Batata'),
188(17, 'Cevada'),
189(18, 'Gergelim');
190
191--planting_materials
192
193--Soja
194insert into planting_materials (culture_id, name) VALUES (1, '59 MS 01 IPRO');
195insert into planting_materials (culture_id, name) VALUES (1, '5D6215 IPRO');
196insert into planting_materials (culture_id, name) VALUES (1, '5D634 RR');
197insert into planting_materials (culture_id, name) VALUES (1, '5G7315');
198insert into planting_materials (culture_id, name) VALUES (1, '5G8015 IPRO');
199insert into planting_materials (culture_id, name) VALUES (1, '60 MS 01 IPRO');
200insert into planting_materials (culture_id, name) VALUES (1, '62MS00 RR');
201insert into planting_materials (culture_id, name) VALUES (1, '71MF00 RR');
202insert into planting_materials (culture_id, name) VALUES (1, '75MF00 RR');
203insert into planting_materials (culture_id, name) VALUES (1, '76MS00 IPRO');
204insert into planting_materials (culture_id, name) VALUES (1, '82MS00 IPRO');
205insert into planting_materials (culture_id, name) VALUES (1, '84186RSF IPRO');
206insert into planting_materials (culture_id, name) VALUES (1, 'ADV 4317 IPRO');
207insert into planting_materials (culture_id, name) VALUES (1, 'ADV 4341 IPRO');
208insert into planting_materials (culture_id, name) VALUES (1, 'ADV 4672 IPRO');
209insert into planting_materials (culture_id, name) VALUES (1, 'ADV 4681 IPRO');
210insert into planting_materials (culture_id, name) VALUES (1, 'ADV 4766 IPRO');
211insert into planting_materials (culture_id, name) VALUES (1, 'ADV 4779 IPRO');
212insert into planting_materials (culture_id, name) VALUES (1, 'AG 6500');
213insert into planting_materials (culture_id, name) VALUES (1, 'AG 6525');
214insert into planting_materials (culture_id, name) VALUES (1, 'AG 6565');
215insert into planting_materials (culture_id, name) VALUES (1, 'AMS TIBAGI RR');
216insert into planting_materials (culture_id, name) VALUES (1, 'ANITA RR');
217insert into planting_materials (culture_id, name) VALUES (1, 'ANRR 77051');
218insert into planting_materials (culture_id, name) VALUES (1, 'ANRR 84024');
219insert into planting_materials (culture_id, name) VALUES (1, 'ANRR 85509');
220insert into planting_materials (culture_id, name) VALUES (1, 'ANSC 75136');
221insert into planting_materials (culture_id, name) VALUES (1, 'ANSC 79020');
222insert into planting_materials (culture_id, name) VALUES (1, 'ANSC 83022');
223insert into planting_materials (culture_id, name) VALUES (1, 'ANSC 89109');
224insert into planting_materials (culture_id, name) VALUES (1, 'ANSC 93101');
225insert into planting_materials (culture_id, name) VALUES (1, 'ANTA 82');
226insert into planting_materials (culture_id, name) VALUES (1, 'AS 3570 IPRO');
227insert into planting_materials (culture_id, name) VALUES (1, 'AS 3575 IPRO');
228insert into planting_materials (culture_id, name) VALUES (1, 'AS 3590 IPRO');
229insert into planting_materials (culture_id, name) VALUES (1, 'AS 3610 IPRO');
230insert into planting_materials (culture_id, name) VALUES (1, 'AS 3680 IPRO');
231insert into planting_materials (culture_id, name) VALUES (1, 'AS 3730 IPRO');
232insert into planting_materials (culture_id, name) VALUES (1, 'AS 3797 IPRO');
233insert into planting_materials (culture_id, name) VALUES (1, 'AS 3810 IPRO');
234insert into planting_materials (culture_id, name) VALUES (1, 'AS 3820 IPRO');
235insert into planting_materials (culture_id, name) VALUES (1, 'AS 3850 IPRO');
236insert into planting_materials (culture_id, name) VALUES (1, 'AV MAMBA RR');
237insert into planting_materials (culture_id, name) VALUES (1, 'BG 4290');
238insert into planting_materials (culture_id, name) VALUES (1, 'BG 4377');
239insert into planting_materials (culture_id, name) VALUES (1, 'BG 4668');
240insert into planting_materials (culture_id, name) VALUES (1, 'BG 4781 IPRO');
241insert into planting_materials (culture_id, name) VALUES (1, 'BG 4786');
242insert into planting_materials (culture_id, name) VALUES (1, 'BG 5860 IPRO');
243insert into planting_materials (culture_id, name) VALUES (1, 'BG4184');
244insert into planting_materials (culture_id, name) VALUES (1, 'BMX ALVO RR');
245insert into planting_materials (culture_id, name) VALUES (1, 'BMX APOLO RR');
246insert into planting_materials (culture_id, name) VALUES (1, 'BMX ATIVA RR');
247insert into planting_materials (culture_id, name) VALUES (1, 'BMX BONUS IPRO');
248insert into planting_materials (culture_id, name) VALUES (1, 'BMX BRAVA RR');
249insert into planting_materials (culture_id, name) VALUES (1, 'BMX CERTA IPRO');
250insert into planting_materials (culture_id, name) VALUES (1, 'BMX CLASSE RR');
251insert into planting_materials (culture_id, name) VALUES (1, 'BMX COMPACTA IPRO');
252insert into planting_materials (culture_id, name) VALUES (1, 'BMX DELTA IPRO');
253insert into planting_materials (culture_id, name) VALUES (1, 'BMX DESAFIO RR');
254insert into planting_materials (culture_id, name) VALUES (1, 'BMX DOMINIO IPRO');
255insert into planting_materials (culture_id, name) VALUES (1, 'BMX ENERGIA RR');
256insert into planting_materials (culture_id, name) VALUES (1, 'BMX EXTRA IPRO');
257insert into planting_materials (culture_id, name) VALUES (1, 'BMX EXTREMA IPRO');
258insert into planting_materials (culture_id, name) VALUES (1, 'BMX FIBRA IPRO');
259insert into planting_materials (culture_id, name) VALUES (1, 'BMX FLECHA IPRO');
260insert into planting_materials (culture_id, name) VALUES (1, 'BMX FOCO IPRO');
261insert into planting_materials (culture_id, name) VALUES (1, 'BMX FORCA RR');
262insert into planting_materials (culture_id, name) VALUES (1, 'BMX FORTE RR');
263insert into planting_materials (culture_id, name) VALUES (1, 'BMX FURIA RR');
264insert into planting_materials (culture_id, name) VALUES (1, 'BMX GARRA IPRO');
265insert into planting_materials (culture_id, name) VALUES (1, 'BMX ICONE IPRO');
266insert into planting_materials (culture_id, name) VALUES (1, 'BMX LANCA IPRO');
267insert into planting_materials (culture_id, name) VALUES (1, 'BMX MAGNA RR');
268insert into planting_materials (culture_id, name) VALUES (1, 'BMX OPUS IPRO');
269insert into planting_materials (culture_id, name) VALUES (1, 'BMX PONTA IPRO');
270insert into planting_materials (culture_id, name) VALUES (1, 'BMX POTENCIA RR');
271insert into planting_materials (culture_id, name) VALUES (1, 'BMX POWER IPRO');
272insert into planting_materials (culture_id, name) VALUES (1, 'BMX PRISMA IPRO');
273insert into planting_materials (culture_id, name) VALUES (1, 'BMX RACA RR');
274insert into planting_materials (culture_id, name) VALUES (1, 'BMX RAIO IPRO');
275insert into planting_materials (culture_id, name) VALUES (1, 'BMX TORNADO RR');
276insert into planting_materials (culture_id, name) VALUES (1, 'BMX TURBO RR');
277insert into planting_materials (culture_id, name) VALUES (1, 'BMX ULTRA IPRO');
278insert into planting_materials (culture_id, name) VALUES (1, 'BMX UNICA IPRO');
279insert into planting_materials (culture_id, name) VALUES (1, 'BMX VALENTE RR');
280insert into planting_materials (culture_id, name) VALUES (1, 'BMX VANGUARDA IPRO');
281insert into planting_materials (culture_id, name) VALUES (1, 'BMX VELOZ RR');
282insert into planting_materials (culture_id, name) VALUES (1, 'BMX VORAZ IPRO');
283insert into planting_materials (culture_id, name) VALUES (1, 'BMX ZEUS IPRO');
284insert into planting_materials (culture_id, name) VALUES (1, 'BRS 1001 IPRO');
285insert into planting_materials (culture_id, name) VALUES (1, 'BRS 1003 IPRO');
286insert into planting_materials (culture_id, name) VALUES (1, 'BRS 1007 IPRO');
287insert into planting_materials (culture_id, name) VALUES (1, 'BRS 232');
288insert into planting_materials (culture_id, name) VALUES (1, 'BRS 284');
289insert into planting_materials (culture_id, name) VALUES (1, 'BRS 317');
290insert into planting_materials (culture_id, name) VALUES (1, 'BRS 359 RR');
291insert into planting_materials (culture_id, name) VALUES (1, 'BRS 360 RR');
292insert into planting_materials (culture_id, name) VALUES (1, 'BRS 378');
293insert into planting_materials (culture_id, name) VALUES (1, 'BRS 388 RR');
294insert into planting_materials (culture_id, name) VALUES (1, 'BRS 399 RR');
295insert into planting_materials (culture_id, name) VALUES (1, 'BRS 511');
296insert into planting_materials (culture_id, name) VALUES (1, 'BRS 5601 RR');
297insert into planting_materials (culture_id, name) VALUES (1, 'BRS 5804 RR');
298insert into planting_materials (culture_id, name) VALUES (1, 'BRS 5980 IPRO');
299insert into planting_materials (culture_id, name) VALUES (1, 'BRS 611');
300insert into planting_materials (culture_id, name) VALUES (1, 'BRS 6970 IPRO');
301insert into planting_materials (culture_id, name) VALUES (1, 'BRS 6980');
302insert into planting_materials (culture_id, name) VALUES (1, 'BRS 706 IPRO');
303insert into planting_materials (culture_id, name) VALUES (1, 'BRS 713 IPRO');
304insert into planting_materials (culture_id, name) VALUES (1, 'BRS 7170 IPRO');
305insert into planting_materials (culture_id, name) VALUES (1, 'BRS 7270 IPRO');
306insert into planting_materials (culture_id, name) VALUES (1, 'BRS 729 IPRO');
307insert into planting_materials (culture_id, name) VALUES (1, 'BRS 7380 RR');
308insert into planting_materials (culture_id, name) VALUES (1, 'BRS 7460 RR');
309insert into planting_materials (culture_id, name) VALUES (1, 'BRS 7470 IPRO');
310insert into planting_materials (culture_id, name) VALUES (1, 'BRS 752');
311insert into planting_materials (culture_id, name) VALUES (1, 'BRS 7570 IPRO');
312insert into planting_materials (culture_id, name) VALUES (1, 'BRS 760 RR');
313insert into planting_materials (culture_id, name) VALUES (1, 'BRS 7680 RR');
314insert into planting_materials (culture_id, name) VALUES (1, 'BRS 7780 IPRO');
315insert into planting_materials (culture_id, name) VALUES (1, 'BRS 7960');
316insert into planting_materials (culture_id, name) VALUES (1, 'BRS 7980');
317insert into planting_materials (culture_id, name) VALUES (1, 'BRS 811 RR');
318insert into planting_materials (culture_id, name) VALUES (1, 'BRS 8170 IPRO');
319insert into planting_materials (culture_id, name) VALUES (1, 'BRS 820 RR');
320insert into planting_materials (culture_id, name) VALUES (1, 'BRS 8280 RR');
321insert into planting_materials (culture_id, name) VALUES (1, 'BRS 8360');
322insert into planting_materials (culture_id, name) VALUES (1, 'BRS 8381');
323insert into planting_materials (culture_id, name) VALUES (1, 'BRS 8560 RR');
324insert into planting_materials (culture_id, name) VALUES (1, 'BRS 8581');
325insert into planting_materials (culture_id, name) VALUES (1, 'BRS 8781 RR');
326insert into planting_materials (culture_id, name) VALUES (1, 'BRS 9180 IPRO');
327insert into planting_materials (culture_id, name) VALUES (1, 'BRS 9383 IPRO');
328insert into planting_materials (culture_id, name) VALUES (1, 'BRS CONQUISTA');
329insert into planting_materials (culture_id, name) VALUES (1, 'BRS PEROLA');
330insert into planting_materials (culture_id, name) VALUES (1, 'BRS RAIMUNDA');
331insert into planting_materials (culture_id, name) VALUES (1, 'BRS SAMBAIBA RR');
332insert into planting_materials (culture_id, name) VALUES (1, 'BRS VALIOSA RR');
333insert into planting_materials (culture_id, name) VALUES (1, 'BRSMG 810C');
334insert into planting_materials (culture_id, name) VALUES (1, 'BRSMG 810C');
335insert into planting_materials (culture_id, name) VALUES (1, 'BRUNA IPRO');
336insert into planting_materials (culture_id, name) VALUES (1, 'BS 2606 IPRO');
337insert into planting_materials (culture_id, name) VALUES (1, 'Brasmax Olimpo IPRO');
338insert into planting_materials (culture_id, name) VALUES (1, 'Brasmax Origem IPRO');
339insert into planting_materials (culture_id, name) VALUES (1, 'C 2830 IPRO');
340insert into planting_materials (culture_id, name) VALUES (1, 'C 2834 IPRO');
341insert into planting_materials (culture_id, name) VALUES (1, 'C 4383');
342insert into planting_materials (culture_id, name) VALUES (1, 'CD 202');
343insert into planting_materials (culture_id, name) VALUES (1, 'CD 202 IPRO');
344insert into planting_materials (culture_id, name) VALUES (1, 'CD 202 RR');
345insert into planting_materials (culture_id, name) VALUES (1, 'CD 206');
346insert into planting_materials (culture_id, name) VALUES (1, 'CD 206 RR');
347insert into planting_materials (culture_id, name) VALUES (1, 'CD 208');
348insert into planting_materials (culture_id, name) VALUES (1, 'CD 214 RR');
349insert into planting_materials (culture_id, name) VALUES (1, 'CD 215');
350insert into planting_materials (culture_id, name) VALUES (1, 'CD 215 RR');
351insert into planting_materials (culture_id, name) VALUES (1, 'CD 219 RR');
352insert into planting_materials (culture_id, name) VALUES (1, 'CD 221');
353insert into planting_materials (culture_id, name) VALUES (1, 'CD 224 STS');
354insert into planting_materials (culture_id, name) VALUES (1, 'CD 226 RR');
355insert into planting_materials (culture_id, name) VALUES (1, 'CD 231 RR');
356insert into planting_materials (culture_id, name) VALUES (1, 'CD 233 RR');
357insert into planting_materials (culture_id, name) VALUES (1, 'CD 234 RR');
358insert into planting_materials (culture_id, name) VALUES (1, 'CD 235 RR');
359insert into planting_materials (culture_id, name) VALUES (1, 'CD 236 RR STS');
360insert into planting_materials (culture_id, name) VALUES (1, 'CD 237 RR');
361insert into planting_materials (culture_id, name) VALUES (1, 'CD 238 RR');
362insert into planting_materials (culture_id, name) VALUES (1, 'CD 239 RR');
363insert into planting_materials (culture_id, name) VALUES (1, 'CD 241 RR');
364insert into planting_materials (culture_id, name) VALUES (1, 'CD 249 RR STS');
365insert into planting_materials (culture_id, name) VALUES (1, 'CD 250 RR STS');
366insert into planting_materials (culture_id, name) VALUES (1, 'CD 251 RR');
367insert into planting_materials (culture_id, name) VALUES (1, 'CD 252 STS');
368insert into planting_materials (culture_id, name) VALUES (1, 'CD 2585 RR');
369insert into planting_materials (culture_id, name) VALUES (1, 'CD 2630 RR STS');
370insert into planting_materials (culture_id, name) VALUES (1, 'CD 2644 IPRO');
371insert into planting_materials (culture_id, name) VALUES (1, 'CD 266');
372insert into planting_materials (culture_id, name) VALUES (1, 'CD 2687 RR');
373insert into planting_materials (culture_id, name) VALUES (1, 'CD 2694 IPRO');
374insert into planting_materials (culture_id, name) VALUES (1, 'CD 2700 IPRO');
375insert into planting_materials (culture_id, name) VALUES (1, 'CD 2720 IPRO');
376insert into planting_materials (culture_id, name) VALUES (1, 'CD 2728 IPRO');
377insert into planting_materials (culture_id, name) VALUES (1, 'CD 2730 IPRO');
378insert into planting_materials (culture_id, name) VALUES (1, 'CD 2737 RR');
379insert into planting_materials (culture_id, name) VALUES (1, 'CD 2750 IPRO');
380insert into planting_materials (culture_id, name) VALUES (1, 'CD 2820 IPRO');
381insert into planting_materials (culture_id, name) VALUES (1, 'CD 2851 IPRO');
382insert into planting_materials (culture_id, name) VALUES (1, 'CD 2857 RR');
383insert into planting_materials (culture_id, name) VALUES (1, 'CG 65 RR');
384insert into planting_materials (culture_id, name) VALUES (1, 'CG 67 RR');
385insert into planting_materials (culture_id, name) VALUES (1, 'CG 7464 RR');
386insert into planting_materials (culture_id, name) VALUES (1, 'CG 7665 RR');
387insert into planting_materials (culture_id, name) VALUES (1, 'CG 8166 RR');
388insert into planting_materials (culture_id, name) VALUES (1, 'CG ARAGUAIA RR');
389insert into planting_materials (culture_id, name) VALUES (1, 'CG FORTUNA RR');
390insert into planting_materials (culture_id, name) VALUES (1, 'CG MAPITOBAPA RR');
391insert into planting_materials (culture_id, name) VALUES (1, 'CG NITRO');
392insert into planting_materials (culture_id, name) VALUES (1, 'CG PRODUTIVA RR');
393insert into planting_materials (culture_id, name) VALUES (1, 'CG ROBUSTA RR');
394insert into planting_materials (culture_id, name) VALUES (1, 'CG SPEED');
395insert into planting_materials (culture_id, name) VALUES (1, 'CG VIGOR RR');
396insert into planting_materials (culture_id, name) VALUES (1, 'CM 422 MILAGROSA');
397insert into planting_materials (culture_id, name) VALUES (1, 'CZ 0121 LL');
398insert into planting_materials (culture_id, name) VALUES (1, 'CZ 0525 LL');
399insert into planting_materials (culture_id, name) VALUES (1, 'CZ 0767 RY');
400insert into planting_materials (culture_id, name) VALUES (1, 'CZ 0848 LL');
401insert into planting_materials (culture_id, name) VALUES (1, 'CZ 1332 LL');
402insert into planting_materials (culture_id, name) VALUES (1, 'CZ 15B92 IPRO');
403insert into planting_materials (culture_id, name) VALUES (1, 'CZ 1623 LL');
404insert into planting_materials (culture_id, name) VALUES (1, 'CZ 16B39 LL');
405insert into planting_materials (culture_id, name) VALUES (1, 'CZ 1787 RY');
406insert into planting_materials (culture_id, name) VALUES (1, 'CZ 1845 LL');
407insert into planting_materials (culture_id, name) VALUES (1, 'CZ 2312 LL');
408insert into planting_materials (culture_id, name) VALUES (1, 'CZ 2474 RY');
409insert into planting_materials (culture_id, name) VALUES (1, 'CZ 2510 LL');
410insert into planting_materials (culture_id, name) VALUES (1, 'CZ 26B42 IPRO');
411insert into planting_materials (culture_id, name) VALUES (1, 'CZ 26B77 IPRO');
412insert into planting_materials (culture_id, name) VALUES (1, 'CZ 2788 RY');
413insert into planting_materials (culture_id, name) VALUES (1, 'CZ 2810 LL');
414insert into planting_materials (culture_id, name) VALUES (1, 'CZ 2915 LL');
415insert into planting_materials (culture_id, name) VALUES (1, 'CZ 3060 RY');
416insert into planting_materials (culture_id, name) VALUES (1, 'CZ 3233 LL');
417insert into planting_materials (culture_id, name) VALUES (1, 'CZ 3383 RY');
418insert into planting_materials (culture_id, name) VALUES (1, 'CZ 3443 LL');
419insert into planting_materials (culture_id, name) VALUES (1, 'CZ 3560 RY');
420insert into planting_materials (culture_id, name) VALUES (1, 'CZ 36B31 IPRO');
421insert into planting_materials (culture_id, name) VALUES (1, 'CZ 36B60 LL');
422insert into planting_materials (culture_id, name) VALUES (1, 'CZ 36B80 RR');
423insert into planting_materials (culture_id, name) VALUES (1, 'CZ 3737 LL');
424insert into planting_materials (culture_id, name) VALUES (1, 'CZ 37B19 LL');
425insert into planting_materials (culture_id, name) VALUES (1, 'CZ 37B22 IPRO');
426insert into planting_materials (culture_id, name) VALUES (1, 'CZ 37B43 IPRO');
427insert into planting_materials (culture_id, name) VALUES (1, 'CZ 3841 LL');
428insert into planting_materials (culture_id, name) VALUES (1, 'CZ 3945 LL');
429insert into planting_materials (culture_id, name) VALUES (1, 'CZ 3991 RT');
430insert into planting_materials (culture_id, name) VALUES (1, 'CZ 3991 RY');
431insert into planting_materials (culture_id, name) VALUES (1, 'CZ 4044 LL');
432insert into planting_materials (culture_id, name) VALUES (1, 'CZ 4105 LL');
433insert into planting_materials (culture_id, name) VALUES (1, 'CZ 4181 RY');
434insert into planting_materials (culture_id, name) VALUES (1, 'CZ 4540 LL');
435insert into planting_materials (culture_id, name) VALUES (1, 'CZ 4656 RY');
436insert into planting_materials (culture_id, name) VALUES (1, 'CZ 4748 LL');
437insert into planting_materials (culture_id, name) VALUES (1, 'CZ 47B90 IPRO');
438insert into planting_materials (culture_id, name) VALUES (1, 'CZ 4818 LL');
439insert into planting_materials (culture_id, name) VALUES (1, 'CZ 4898 RY');
440insert into planting_materials (culture_id, name) VALUES (1, 'CZ 48B32 IPRO');
441insert into planting_materials (culture_id, name) VALUES (1, 'CZ 48B41 RR');
442insert into planting_materials (culture_id, name) VALUES (1, 'CZ 48B50 LL');
443insert into planting_materials (culture_id, name) VALUES (1, 'CZ 48B71 RR');
444insert into planting_materials (culture_id, name) VALUES (1, 'CZ 48B79 LL');
445insert into planting_materials (culture_id, name) VALUES (1, 'CZ 4959 RY');
446insert into planting_materials (culture_id, name) VALUES (1, 'CZ 5147 LL');
447insert into planting_materials (culture_id, name) VALUES (1, 'CZ 5150 LL');
448insert into planting_materials (culture_id, name) VALUES (1, 'CZ 5225 LL');
449insert into planting_materials (culture_id, name) VALUES (1, 'CZ 5242 LL');
450insert into planting_materials (culture_id, name) VALUES (1, 'CZ 5295 RY');
451insert into planting_materials (culture_id, name) VALUES (1, 'CZ 5375 RY');
452insert into planting_materials (culture_id, name) VALUES (1, 'CZ 5445 LL');
453insert into planting_materials (culture_id, name) VALUES (1, 'CZ 5515 LL');
454insert into planting_materials (culture_id, name) VALUES (1, 'CZ 5727 LL');
455insert into planting_materials (culture_id, name) VALUES (1, 'CZ 58B28 IPRO');
456insert into planting_materials (culture_id, name) VALUES (1, 'CZ 58B61 IPRO');
457insert into planting_materials (culture_id, name) VALUES (1, 'CZ 58B81 RR');
458insert into planting_materials (culture_id, name) VALUES (1, 'CZ 5907 IPRO');
459insert into planting_materials (culture_id, name) VALUES (1, 'CZ 5947 LL');
460insert into planting_materials (culture_id, name) VALUES (1, 'CZ 6060 RY');
461insert into planting_materials (culture_id, name) VALUES (1, 'CZ 6109 LL');
462insert into planting_materials (culture_id, name) VALUES (1, 'CZ 6205 RR');
463insert into planting_materials (culture_id, name) VALUES (1, 'CZ 6316 LL');
464insert into planting_materials (culture_id, name) VALUES (1, 'CZ 6505 RR');
465insert into planting_materials (culture_id, name) VALUES (1, 'CZ 6515 LL');
466insert into planting_materials (culture_id, name) VALUES (1, 'CZ 6806IPRO');
467insert into planting_materials (culture_id, name) VALUES (1, 'CZ 7007 LL');
468insert into planting_materials (culture_id, name) VALUES (1, 'CZ 7070 RY');
469insert into planting_materials (culture_id, name) VALUES (1, 'CZ 7132 LL');
470insert into planting_materials (culture_id, name) VALUES (1, 'DM 53i54 IPRO');
471insert into planting_materials (culture_id, name) VALUES (1, 'DM 54i52 IPRO');
472insert into planting_materials (culture_id, name) VALUES (1, 'DM 57i52 IPRO');
473insert into planting_materials (culture_id, name) VALUES (1, 'DM 5958 IPRO');
474insert into planting_materials (culture_id, name) VALUES (1, 'DM 6.2i RR');
475insert into planting_materials (culture_id, name) VALUES (1, 'DM 60i62 IPRO');
476insert into planting_materials (culture_id, name) VALUES (1, 'DM 61i59 IPRO');
477insert into planting_materials (culture_id, name) VALUES (1, 'DM 6262 IPRO');
478insert into planting_materials (culture_id, name) VALUES (1, 'DM 62R63 IPRO');
479insert into planting_materials (culture_id, name) VALUES (1, 'DM 6458 IPRO');
480insert into planting_materials (culture_id, name) VALUES (1, 'DM 6563 IPRO');
481insert into planting_materials (culture_id, name) VALUES (1, 'DM 65i59 IPRO');
482insert into planting_materials (culture_id, name) VALUES (1, 'DM 66i68 IPRO');
483insert into planting_materials (culture_id, name) VALUES (1, 'DM 68i69 IPRO');
484insert into planting_materials (culture_id, name) VALUES (1, 'DM 73i75 IPRO');
485insert into planting_materials (culture_id, name) VALUES (1, 'DM 75i74 IPRO');
486insert into planting_materials (culture_id, name) VALUES (1, 'DM 75i76 IPRO');
487insert into planting_materials (culture_id, name) VALUES (1, 'DM 80i79 IPRO');
488insert into planting_materials (culture_id, name) VALUES (1, 'DM 81i84 IPRO');
489insert into planting_materials (culture_id, name) VALUES (1, 'DM 82i78 IPRO');
490insert into planting_materials (culture_id, name) VALUES (1, 'DS 5916 IPRO');
491insert into planting_materials (culture_id, name) VALUES (1, 'DS 6217 IPRO');
492insert into planting_materials (culture_id, name) VALUES (1, 'DS6017 IPRO');
493insert into planting_materials (culture_id, name) VALUES (1, 'DS7417 IPRO');
494insert into planting_materials (culture_id, name) VALUES (1, 'EMGOPA 313');
495insert into planting_materials (culture_id, name) VALUES (1, 'FPS ANTARES RR');
496insert into planting_materials (culture_id, name) VALUES (1, 'FPS IGUACU RR');
497insert into planting_materials (culture_id, name) VALUES (1, 'FPS JUPITER RR');
498insert into planting_materials (culture_id, name) VALUES (1, 'FTR 1154 RR');
499insert into planting_materials (culture_id, name) VALUES (1, 'FTR 1156 IPRO');
500insert into planting_materials (culture_id, name) VALUES (1, 'FTR 1157 RR');
501insert into planting_materials (culture_id, name) VALUES (1, 'FTR 1186 IPRO');
502insert into planting_materials (culture_id, name) VALUES (1, 'FTR 1192 IPRO');
503insert into planting_materials (culture_id, name) VALUES (1, 'FTR 2050 IPRO');
504insert into planting_materials (culture_id, name) VALUES (1, 'FTR 2155 RR');
505insert into planting_materials (culture_id, name) VALUES (1, 'FTR 2161 RR');
506insert into planting_materials (culture_id, name) VALUES (1, 'FTR 2182 IPRO');
507insert into planting_materials (culture_id, name) VALUES (1, 'FTR 2557 RR');
508insert into planting_materials (culture_id, name) VALUES (1, 'FTR 2660 IPRO');
509insert into planting_materials (culture_id, name) VALUES (1, 'FTR 2949 IPRO');
510insert into planting_materials (culture_id, name) VALUES (1, 'FTR 3156 IPRO');
511insert into planting_materials (culture_id, name) VALUES (1, 'FTR 3165 IPRO');
512insert into planting_materials (culture_id, name) VALUES (1, 'FTR 3178 IPRO');
513insert into planting_materials (culture_id, name) VALUES (1, 'FTR 3179 IPRO');
514insert into planting_materials (culture_id, name) VALUES (1, 'FTR 3180 IPRO');
515insert into planting_materials (culture_id, name) VALUES (1, 'FTR 3185 IPRO');
516insert into planting_materials (culture_id, name) VALUES (1, 'FTR 3191 IPRO');
517insert into planting_materials (culture_id, name) VALUES (1, 'FTR 3366 IPRO ');
518insert into planting_materials (culture_id, name) VALUES (1, 'FTR 3757 IPRO');
519insert into planting_materials (culture_id, name) VALUES (1, 'FTR 3848 IPRO');
520insert into planting_materials (culture_id, name) VALUES (1, 'FTR 4153 IPRO');
521insert into planting_materials (culture_id, name) VALUES (1, 'FTR 4160 IPRO');
522insert into planting_materials (culture_id, name) VALUES (1, 'FTR 4179 IPRO');
523insert into planting_materials (culture_id, name) VALUES (1, 'FTR 4180 IPRO');
524insert into planting_materials (culture_id, name) VALUES (1, 'FTR 4181 IPRO');
525insert into planting_materials (culture_id, name) VALUES (1, 'FTR 4182 IPRO');
526insert into planting_materials (culture_id, name) VALUES (1, 'FTR 4280 IPRO');
527insert into planting_materials (culture_id, name) VALUES (1, 'FTR 4465 IPRO');
528insert into planting_materials (culture_id, name) VALUES (1, 'FTR 4959 IPRO');
529insert into planting_materials (culture_id, name) VALUES (1, 'FTS 2178');
530insert into planting_materials (culture_id, name) VALUES (1, 'FTS 3190 IPRO');
531insert into planting_materials (culture_id, name) VALUES (1, 'FTS 4183 IPRO');
532insert into planting_materials (culture_id, name) VALUES (1, 'FTS 4188');
533insert into planting_materials (culture_id, name) VALUES (1, 'FTS 4288 IPRO');
534insert into planting_materials (culture_id, name) VALUES (1, 'FTS ATHENA RR');
535insert into planting_materials (culture_id, name) VALUES (1, 'FTS CAMPO MOURAO RR');
536insert into planting_materials (culture_id, name) VALUES (1, 'FTS CAMPO NOVO RR');
537insert into planting_materials (culture_id, name) VALUES (1, 'FTS FENIX');
538insert into planting_materials (culture_id, name) VALUES (1, 'FTS GALANTE RR');
539insert into planting_materials (culture_id, name) VALUES (1, 'FTS GRACIOSA RR');
540insert into planting_materials (culture_id, name) VALUES (1, 'FTS MASTER RR');
541insert into planting_materials (culture_id, name) VALUES (1, 'FTS PARAGOMINAS');
542insert into planting_materials (culture_id, name) VALUES (1, 'FTS TRIUNFO RR');
543insert into planting_materials (culture_id, name) VALUES (1, 'FTS URUCUI RR');
544insert into planting_materials (culture_id, name) VALUES (1, 'GB 874 RR');
545insert into planting_materials (culture_id, name) VALUES (1, 'GMX CANCHEIRO RR');
546insert into planting_materials (culture_id, name) VALUES (1, 'GMX GUAPO RR');
547insert into planting_materials (culture_id, name) VALUES (1, 'GMX GURI RR');
548insert into planting_materials (culture_id, name) VALUES (1, 'GMX REDOMAO RR');
549insert into planting_materials (culture_id, name) VALUES (1, 'GMX XIRU RR');
550insert into planting_materials (culture_id, name) VALUES (1, 'GNZ 550S RR');
551insert into planting_materials (culture_id, name) VALUES (1, 'GNZ 660S RR');
552insert into planting_materials (culture_id, name) VALUES (1, 'GNZ 721S RR');
553insert into planting_materials (culture_id, name) VALUES (1, 'GP 5917 RR');
554insert into planting_materials (culture_id, name) VALUES (1, 'GUAIA 6510 RR');
555insert into planting_materials (culture_id, name) VALUES (1, 'GUAIA 7379 IPRO');
556insert into planting_materials (culture_id, name) VALUES (1, 'GUAIA 7487 RR');
557insert into planting_materials (culture_id, name) VALUES (1, 'HBK LL4953');
558insert into planting_materials (culture_id, name) VALUES (1, 'HBK LL 4653');
559insert into planting_materials (culture_id, name) VALUES (1, 'HBK LL 4950');
560insert into planting_materials (culture_id, name) VALUES (1, 'HBK RY 4721');
561insert into planting_materials (culture_id, name) VALUES (1, 'HBK RY 5221');
562insert into planting_materials (culture_id, name) VALUES (1, 'HBK RY 7523');
563insert into planting_materials (culture_id, name) VALUES (1, 'HO AMAMBAY IPRO');
564insert into planting_materials (culture_id, name) VALUES (1, 'HO APAUE IPRO');
565insert into planting_materials (culture_id, name) VALUES (1, 'HO APORE IPRO');
566insert into planting_materials (culture_id, name) VALUES (1, 'HO CHOPIM IPRO');
567insert into planting_materials (culture_id, name) VALUES (1, 'HO CORUMBA IPRO');
568insert into planting_materials (culture_id, name) VALUES (1, 'HO CRISTALINO IPRO');
569insert into planting_materials (culture_id, name) VALUES (1, 'HO CRIXA IPRO');
570insert into planting_materials (culture_id, name) VALUES (1, 'HO IGUACU IPRO');
571insert into planting_materials (culture_id, name) VALUES (1, 'HO JACUTINGA IPRO');
572insert into planting_materials (culture_id, name) VALUES (1, 'HO JAURU IPRO');
573insert into planting_materials (culture_id, name) VALUES (1, 'HO JAVAES IPRO');
574insert into planting_materials (culture_id, name) VALUES (1, 'HO JURUENA IPRO');
575insert into planting_materials (culture_id, name) VALUES (1, 'HO MAMORÉ IPRO');
576insert into planting_materials (culture_id, name) VALUES (1, 'HO MARACAI IPRO ');
577insert into planting_materials (culture_id, name) VALUES (1, 'HO PARANAIBA IPRO');
578insert into planting_materials (culture_id, name) VALUES (1, 'HO PIRAPO IPRO');
579insert into planting_materials (culture_id, name) VALUES (1, 'HO TERERE IPRO');
580insert into planting_materials (culture_id, name) VALUES (1, 'ICS 7019');
581insert into planting_materials (culture_id, name) VALUES (1, 'IGRA 545 RR');
582insert into planting_materials (culture_id, name) VALUES (1, 'IGRA 626 RR');
583insert into planting_materials (culture_id, name) VALUES (1, 'IGRA 645 RR');
584insert into planting_materials (culture_id, name) VALUES (1, 'IMA 80118 RR');
585insert into planting_materials (culture_id, name) VALUES (1, 'IMA 84114 RR');
586insert into planting_materials (culture_id, name) VALUES (1, 'INT 6300 RR');
587insert into planting_materials (culture_id, name) VALUES (1, 'LDC 5.9 RR');
588insert into planting_materials (culture_id, name) VALUES (1, 'LDC 6.0 RR');
589insert into planting_materials (culture_id, name) VALUES (1, 'LDC 6.9IPRO');
590insert into planting_materials (culture_id, name) VALUES (1, 'LG 60150 IPRO');
591insert into planting_materials (culture_id, name) VALUES (1, 'LG 60158 IPRO');
592insert into planting_materials (culture_id, name) VALUES (1, 'LG 60162 IPRO');
593insert into planting_materials (culture_id, name) VALUES (1, 'LG 60163 IPRO');
594insert into planting_materials (culture_id, name) VALUES (1, 'LG 60174 IPRO');
595insert into planting_materials (culture_id, name) VALUES (1, 'LG 60177 IPRO');
596insert into planting_materials (culture_id, name) VALUES (1, 'LG 60180 IPRO');
597insert into planting_materials (culture_id, name) VALUES (1, 'LG 60184 IPRO');
598insert into planting_materials (culture_id, name) VALUES (1, 'M 5410 IPRO');
599insert into planting_materials (culture_id, name) VALUES (1, 'M 5705 IPRO');
600insert into planting_materials (culture_id, name) VALUES (1, 'M 5730 IPRO');
601insert into planting_materials (culture_id, name) VALUES (1, 'M 5838 IPRO');
602insert into planting_materials (culture_id, name) VALUES (1, 'M 5892 IPRO');
603insert into planting_materials (culture_id, name) VALUES (1, 'M 5917 IPRO');
604insert into planting_materials (culture_id, name) VALUES (1, 'M 5947 IPRO');
605insert into planting_materials (culture_id, name) VALUES (1, 'M 6210 IPRO');
606insert into planting_materials (culture_id, name) VALUES (1, 'M 6211IPRO');
607insert into planting_materials (culture_id, name) VALUES (1, 'M 6410 IPRO');
608insert into planting_materials (culture_id, name) VALUES (1, 'M 6952 IPRO');
609insert into planting_materials (culture_id, name) VALUES (1, 'M 6972 IPRO');
610insert into planting_materials (culture_id, name) VALUES (1, 'M 7110 IPRO');
611insert into planting_materials (culture_id, name) VALUES (1, 'M 7198 IPRO');
612insert into planting_materials (culture_id, name) VALUES (1, 'M 7639 RR');
613insert into planting_materials (culture_id, name) VALUES (1, 'M 7739 IPRO');
614insert into planting_materials (culture_id, name) VALUES (1, 'M 8133 IPRO');
615insert into planting_materials (culture_id, name) VALUES (1, 'M 8210 IPRO');
616insert into planting_materials (culture_id, name) VALUES (1, 'M 8330 IPRO');
617insert into planting_materials (culture_id, name) VALUES (1, 'M 8349 IPRO');
618insert into planting_materials (culture_id, name) VALUES (1, 'M 8372 IPRO');
619insert into planting_materials (culture_id, name) VALUES (1, 'M 8473 IPRO');
620insert into planting_materials (culture_id, name) VALUES (1, 'M 8527 RR');
621insert into planting_materials (culture_id, name) VALUES (1, 'M 8615 IPRO');
622insert into planting_materials (culture_id, name) VALUES (1, 'M 8644 IPRO');
623insert into planting_materials (culture_id, name) VALUES (1, 'M 8766 RR');
624insert into planting_materials (culture_id, name) VALUES (1, 'M 8808 IPRO');
625insert into planting_materials (culture_id, name) VALUES (1, 'M 8866');
626insert into planting_materials (culture_id, name) VALUES (1, 'M 8867 RR');
627insert into planting_materials (culture_id, name) VALUES (1, 'M 9056 RR');
628insert into planting_materials (culture_id, name) VALUES (1, 'M 9144 RR');
629insert into planting_materials (culture_id, name) VALUES (1, 'M-SOY 7900');
630insert into planting_materials (culture_id, name) VALUES (1, 'M-SOY 8757');
631insert into planting_materials (culture_id, name) VALUES (1, 'M-SOY 9350');
632insert into planting_materials (culture_id, name) VALUES (1, 'MS 6.3 IPRO');
633insert into planting_materials (culture_id, name) VALUES (1, 'NA 5959 IPRO');
634insert into planting_materials (culture_id, name) VALUES (1, 'NA 7337 RR');
635insert into planting_materials (culture_id, name) VALUES (1, 'NA 8500');
636insert into planting_materials (culture_id, name) VALUES (1, 'NA 8572');
637insert into planting_materials (culture_id, name) VALUES (1, 'NS 4823 RR');
638insert into planting_materials (culture_id, name) VALUES (1, 'NS 5000 IPRO');
639insert into planting_materials (culture_id, name) VALUES (1, 'NS 5106 IPRO');
640insert into planting_materials (culture_id, name) VALUES (1, 'NS 5258 RR');
641insert into planting_materials (culture_id, name) VALUES (1, 'NS 5445 IPRO');
642insert into planting_materials (culture_id, name) VALUES (1, 'NS 5727 IPRO');
643insert into planting_materials (culture_id, name) VALUES (1, 'NS 5858');
644insert into planting_materials (culture_id, name) VALUES (1, 'NS 5909 RR');
645insert into planting_materials (culture_id, name) VALUES (1, 'NS 5959 IPRO');
646insert into planting_materials (culture_id, name) VALUES (1, 'NS 5960 RR');
647insert into planting_materials (culture_id, name) VALUES (1, 'NS 6006 IPRO');
648insert into planting_materials (culture_id, name) VALUES (1, 'NS 6209 RR');
649insert into planting_materials (culture_id, name) VALUES (1, 'NS 6248 RR');
650insert into planting_materials (culture_id, name) VALUES (1, 'NS 6390 IPRO');
651insert into planting_materials (culture_id, name) VALUES (1, 'NS 6483 RR');
652insert into planting_materials (culture_id, name) VALUES (1, 'NS 6535 IPRO');
653insert into planting_materials (culture_id, name) VALUES (1, 'NS 6601 IPRO');
654insert into planting_materials (culture_id, name) VALUES (1, 'NS 6700 IPRO');
655insert into planting_materials (culture_id, name) VALUES (1, 'NS 6767 RR');
656insert into planting_materials (culture_id, name) VALUES (1, 'NS 6823 IPRO');
657insert into planting_materials (culture_id, name) VALUES (1, 'NS 6823 RR');
658insert into planting_materials (culture_id, name) VALUES (1, 'NS 6828 IPRO');
659insert into planting_materials (culture_id, name) VALUES (1, 'NS 6906 IPRO');
660insert into planting_materials (culture_id, name) VALUES (1, 'NS 6909 IPRO');
661insert into planting_materials (culture_id, name) VALUES (1, 'NS 7000 IPRO');
662insert into planting_materials (culture_id, name) VALUES (1, 'NS 7002');
663insert into planting_materials (culture_id, name) VALUES (1, 'NS 7007 IPRO');
664insert into planting_materials (culture_id, name) VALUES (1, 'NS 7200 RR');
665insert into planting_materials (culture_id, name) VALUES (1, 'NS 7202 IPRO');
666insert into planting_materials (culture_id, name) VALUES (1, 'NS 7209 IPRO');
667insert into planting_materials (culture_id, name) VALUES (1, 'NS 7227 RR');
668insert into planting_materials (culture_id, name) VALUES (1, 'NS 7237 IPRO');
669insert into planting_materials (culture_id, name) VALUES (1, 'NS 7300 IPRO');
670insert into planting_materials (culture_id, name) VALUES (1, 'NS 7338 IPRO');
671insert into planting_materials (culture_id, name) VALUES (1, 'NS 7399 IPRO');
672insert into planting_materials (culture_id, name) VALUES (1, 'NS 7447 IPRO');
673insert into planting_materials (culture_id, name) VALUES (1, 'NS 7490 RR');
674insert into planting_materials (culture_id, name) VALUES (1, 'NS 7497 RR');
675insert into planting_materials (culture_id, name) VALUES (1, 'NS 7505 IPRO');
676insert into planting_materials (culture_id, name) VALUES (1, 'NS 7667 IPRO');
677insert into planting_materials (culture_id, name) VALUES (1, 'NS 7670 RR');
678insert into planting_materials (culture_id, name) VALUES (1, 'NS 7700 IPRO');
679insert into planting_materials (culture_id, name) VALUES (1, 'NS 7709 IPRO');
680insert into planting_materials (culture_id, name) VALUES (1, 'NS 7780 IPRO');
681insert into planting_materials (culture_id, name) VALUES (1, 'NS 7901');
682insert into planting_materials (culture_id, name) VALUES (1, 'NS 8094 RR');
683insert into planting_materials (culture_id, name) VALUES (1, 'NS 8270');
684insert into planting_materials (culture_id, name) VALUES (1, 'NS 8300 PRO');
685insert into planting_materials (culture_id, name) VALUES (1, 'NS 8338 IPRO');
686insert into planting_materials (culture_id, name) VALUES (1, 'NS 8383 RR');
687insert into planting_materials (culture_id, name) VALUES (1, 'NS 8393 RR');
688insert into planting_materials (culture_id, name) VALUES (1, 'NS 8399 IPRO');
689insert into planting_materials (culture_id, name) VALUES (1, 'NS 8400 IPRO');
690insert into planting_materials (culture_id, name) VALUES (1, 'NS 8490 RR');
691insert into planting_materials (culture_id, name) VALUES (1, 'NS 8693 RR');
692insert into planting_materials (culture_id, name) VALUES (1, 'NT 1478SP');
693insert into planting_materials (culture_id, name) VALUES (1, 'NT 1479MX');
694insert into planting_materials (culture_id, name) VALUES (1, 'P 95R51');
695insert into planting_materials (culture_id, name) VALUES (1, 'P 95R90 IPRO');
696insert into planting_materials (culture_id, name) VALUES (1, 'P 95R95 IPRO');
697insert into planting_materials (culture_id, name) VALUES (1, 'P 95Y21');
698insert into planting_materials (culture_id, name) VALUES (1, 'P 95Y52');
699insert into planting_materials (culture_id, name) VALUES (1, 'P 95Y72');
700insert into planting_materials (culture_id, name) VALUES (1, 'P 96Y90 RR');
701insert into planting_materials (culture_id, name) VALUES (1, 'P 97R21');
702insert into planting_materials (culture_id, name) VALUES (1, 'P 97R22 IPRO');
703insert into planting_materials (culture_id, name) VALUES (1, 'P 97R50 IPRO');
704insert into planting_materials (culture_id, name) VALUES (1, 'P 97R73');
705insert into planting_materials (culture_id, name) VALUES (1, 'P 97Y07');
706insert into planting_materials (culture_id, name) VALUES (1, 'P 98C81');
707insert into planting_materials (culture_id, name) VALUES (1, 'P 98R35 IPRO');
708insert into planting_materials (culture_id, name) VALUES (1, 'P 98Y01 IPRO');
709insert into planting_materials (culture_id, name) VALUES (1, 'P 98Y11');
710insert into planting_materials (culture_id, name) VALUES (1, 'P 98Y12');
711insert into planting_materials (culture_id, name) VALUES (1, 'P 98Y20 IPRO');
712insert into planting_materials (culture_id, name) VALUES (1, 'P 98Y21 IPRO');
713insert into planting_materials (culture_id, name) VALUES (1, 'P 98Y30 RR');
714insert into planting_materials (culture_id, name) VALUES (1, 'P 98Y31 IPRO');
715insert into planting_materials (culture_id, name) VALUES (1, 'P 98Y51');
716insert into planting_materials (culture_id, name) VALUES (1, 'P 98Y52');
717insert into planting_materials (culture_id, name) VALUES (1, 'P 98Y70');
718insert into planting_materials (culture_id, name) VALUES (1, 'P 98Y71');
719insert into planting_materials (culture_id, name) VALUES (1, 'P 99R03');
720insert into planting_materials (culture_id, name) VALUES (1, 'P 99R09');
721insert into planting_materials (culture_id, name) VALUES (1, 'P98R41');
722insert into planting_materials (culture_id, name) VALUES (1, 'PINTADO');
723insert into planting_materials (culture_id, name) VALUES (1, 'PP 7500 IPRO');
724insert into planting_materials (culture_id, name) VALUES (1, 'PP 8201 IPRO');
725insert into planting_materials (culture_id, name) VALUES (1, 'Produza IPRO');
726insert into planting_materials (culture_id, name) VALUES (1, 'RA 5715 IPRO');
727insert into planting_materials (culture_id, name) VALUES (1, 'RK 5813 RR');
728insert into planting_materials (culture_id, name) VALUES (1, 'RK 6210 IPRO');
729insert into planting_materials (culture_id, name) VALUES (1, 'RK 6316 IPRO');
730insert into planting_materials (culture_id, name) VALUES (1, 'RK 6719 IPRO');
731insert into planting_materials (culture_id, name) VALUES (1, 'RK 6813 RR');
732insert into planting_materials (culture_id, name) VALUES (1, 'RK 7214 IPRO');
733insert into planting_materials (culture_id, name) VALUES (1, 'RK 7518 IPRO');
734insert into planting_materials (culture_id, name) VALUES (1, 'RK 7814 IPRO');
735insert into planting_materials (culture_id, name) VALUES (1, 'RK 8115 IPRO');
736insert into planting_materials (culture_id, name) VALUES (1, 'RK 8307 RR');
737insert into planting_materials (culture_id, name) VALUES (1, 'RK 8317 IPRO');
738insert into planting_materials (culture_id, name) VALUES (1, 'RMO 5885 RR');
739insert into planting_materials (culture_id, name) VALUES (1, 'RMO 6001 RR');
740insert into planting_materials (culture_id, name) VALUES (1, 'SEMPRE 8230 IPRO');
741insert into planting_materials (culture_id, name) VALUES (1, 'SOJAPAR R 19');
742insert into planting_materials (culture_id, name) VALUES (1, 'SOJAPAR R24');
743insert into planting_materials (culture_id, name) VALUES (1, 'SOJAPAR R34');
744insert into planting_materials (culture_id, name) VALUES (1, 'SOY PESO RR');
745insert into planting_materials (culture_id, name) VALUES (1, 'ST 620 IPRO');
746insert into planting_materials (culture_id, name) VALUES (1, 'ST 644 IPRO');
747insert into planting_materials (culture_id, name) VALUES (1, 'ST 693 IPRO');
748insert into planting_materials (culture_id, name) VALUES (1, 'ST 719 LL');
749insert into planting_materials (culture_id, name) VALUES (1, 'ST 721 IPRO');
750insert into planting_materials (culture_id, name) VALUES (1, 'ST 729 LL');
751insert into planting_materials (culture_id, name) VALUES (1, 'ST 777 IPRO');
752insert into planting_materials (culture_id, name) VALUES (1, 'ST 797 IPRO');
753insert into planting_materials (culture_id, name) VALUES (1, 'ST 804 IPRO');
754insert into planting_materials (culture_id, name) VALUES (1, 'ST 815 RR');
755insert into planting_materials (culture_id, name) VALUES (1, 'ST 820 RR');
756insert into planting_materials (culture_id, name) VALUES (1, 'ST 830 IPRO');
757insert into planting_materials (culture_id, name) VALUES (1, 'ST 845 IPRO');
758insert into planting_materials (culture_id, name) VALUES (1, 'ST 860 RR');
759insert into planting_materials (culture_id, name) VALUES (1, 'ST 879 LL');
760insert into planting_materials (culture_id, name) VALUES (1, 'ST 920 RR');
761insert into planting_materials (culture_id, name) VALUES (1, 'SW ATRIA RR');
762insert into planting_materials (culture_id, name) VALUES (1, 'SW BRIZA RR');
763insert into planting_materials (culture_id, name) VALUES (1, 'SW GURIA RR');
764insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1059 RR');
765insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1080 RR');
766insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1152 RR');
767insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1157 RR');
768insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1158 RR');
769insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1161 RR');
770insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1163 RR');
771insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1180 RR');
772insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1182 RR');
773insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1183 RR');
774insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1190 RR');
775insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1257 RR');
776insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1281 RR');
777insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1285 RR');
778insert into planting_materials (culture_id, name) VALUES (1, 'SYN 13561 IPRO');
779insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1359S IPRO');
780insert into planting_materials (culture_id, name) VALUES (1, 'SYN 13610 IPRO');
781insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1366 IPRO');
782insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1366C IPRO');
783insert into planting_materials (culture_id, name) VALUES (1, 'SYN 13671 IPRO');
784insert into planting_materials (culture_id, name) VALUES (1, 'SYN 13840 IPRO');
785insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1561 IPRO');
786insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1562 IPRO');
787insert into planting_materials (culture_id, name) VALUES (1, 'SYN 15630 IPRO');
788insert into planting_materials (culture_id, name) VALUES (1, 'SYN 15640 IPRO');
789insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1585 IPRO');
790insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1657 IPRO');
791insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1665 IPRO');
792insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1686 IPRO');
793insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1687 IPRO');
794insert into planting_materials (culture_id, name) VALUES (1, 'SYN 1785 IPRO');
795insert into planting_materials (culture_id, name) VALUES (1, 'SYN 3358 RR');
796insert into planting_materials (culture_id, name) VALUES (1, 'SYN 9070 RR');
797insert into planting_materials (culture_id, name) VALUES (1, 'SYN 9074 RR');
798insert into planting_materials (culture_id, name) VALUES (1, 'SYN 9078 RR');
799insert into planting_materials (culture_id, name) VALUES (1, 'SYN V-MAX RR');
800insert into planting_materials (culture_id, name) VALUES (1, 'SYN V-TOP RR');
801insert into planting_materials (culture_id, name) VALUES (1, 'TEC 6702 IPRO');
802insert into planting_materials (culture_id, name) VALUES (1, 'TEC 7021 IPRO');
803insert into planting_materials (culture_id, name) VALUES (1, 'TEC 7022 IPRO');
804insert into planting_materials (culture_id, name) VALUES (1, 'TEC 7022 IPRO');
805insert into planting_materials (culture_id, name) VALUES (1, 'TEC 7548 IPRO');
806insert into planting_materials (culture_id, name) VALUES (1, 'TEC 7548 IPRO');
807insert into planting_materials (culture_id, name) VALUES (1, 'TEC 7849 IPRO');
808insert into planting_materials (culture_id, name) VALUES (1, 'TMG 1067 RR');
809insert into planting_materials (culture_id, name) VALUES (1, 'TMG 115 RR');
810insert into planting_materials (culture_id, name) VALUES (1, 'TMG 1174 RR');
811insert into planting_materials (culture_id, name) VALUES (1, 'TMG 1175 RR');
812insert into planting_materials (culture_id, name) VALUES (1, 'TMG 1176 RR');
813insert into planting_materials (culture_id, name) VALUES (1, 'TMG 1179 RR');
814insert into planting_materials (culture_id, name) VALUES (1, 'TMG 1180 RR');
815insert into planting_materials (culture_id, name) VALUES (1, 'TMG 1182 RR');
816insert into planting_materials (culture_id, name) VALUES (1, 'TMG 1187 RR');
817insert into planting_materials (culture_id, name) VALUES (1, 'TMG 1188 RR');
818insert into planting_materials (culture_id, name) VALUES (1, 'TMG 123 RR');
819insert into planting_materials (culture_id, name) VALUES (1, 'TMG 1264 RR');
820insert into planting_materials (culture_id, name) VALUES (1, 'TMG 1266 RR');
821insert into planting_materials (culture_id, name) VALUES (1, 'TMG 127 RR');
822insert into planting_materials (culture_id, name) VALUES (1, 'TMG 1288 RR');
823insert into planting_materials (culture_id, name) VALUES (1, 'TMG 132 RR');
824insert into planting_materials (culture_id, name) VALUES (1, 'TMG 133 RR');
825insert into planting_materials (culture_id, name) VALUES (1, 'TMG 1759 RR');
826insert into planting_materials (culture_id, name) VALUES (1, 'TMG 2158 IPRO');
827insert into planting_materials (culture_id, name) VALUES (1, 'TMG 2173 IPRO');
828insert into planting_materials (culture_id, name) VALUES (1, 'TMG 2179 IPRO');
829insert into planting_materials (culture_id, name) VALUES (1, 'TMG 2181 IPRO');
830insert into planting_materials (culture_id, name) VALUES (1, 'TMG 2182 IPRO');
831insert into planting_materials (culture_id, name) VALUES (1, 'TMG 2183 IPRO');
832insert into planting_materials (culture_id, name) VALUES (1, 'TMG 2185 IPRO');
833insert into planting_materials (culture_id, name) VALUES (1, 'TMG 2187 IPRO');
834insert into planting_materials (culture_id, name) VALUES (1, 'TMG 2286 IPRO');
835insert into planting_materials (culture_id, name) VALUES (1, 'TMG 2378 IPRO');
836insert into planting_materials (culture_id, name) VALUES (1, 'TMG 2379 IPRO');
837insert into planting_materials (culture_id, name) VALUES (1, 'TMG 2381 IPRO');
838insert into planting_materials (culture_id, name) VALUES (1, 'TMG 2383 IPRO');
839insert into planting_materials (culture_id, name) VALUES (1, 'TMG 4182');
840insert into planting_materials (culture_id, name) VALUES (1, 'TMG 4185');
841insert into planting_materials (culture_id, name) VALUES (1, 'TMG 4190');
842insert into planting_materials (culture_id, name) VALUES (1, 'TMG 4377');
843insert into planting_materials (culture_id, name) VALUES (1, 'TMG 7060 IPRO');
844insert into planting_materials (culture_id, name) VALUES (1, 'TMG 7061 IPRO');
845insert into planting_materials (culture_id, name) VALUES (1, 'TMG 7062 IPRO');
846insert into planting_materials (culture_id, name) VALUES (1, 'TMG 7063 IPRO');
847insert into planting_materials (culture_id, name) VALUES (1, 'TMG 7067 IPRO');
848insert into planting_materials (culture_id, name) VALUES (1, 'TMG 7161 RR');
849insert into planting_materials (culture_id, name) VALUES (1, 'TMG 7188 RR');
850insert into planting_materials (culture_id, name) VALUES (1, 'TMG 7260 IPRO');
851insert into planting_materials (culture_id, name) VALUES (1, 'TMG 7262 RR');
852insert into planting_materials (culture_id, name) VALUES (1, 'TMG 7363 RR');
853insert into planting_materials (culture_id, name) VALUES (1, 'TMG 7662 RR');
854insert into planting_materials (culture_id, name) VALUES (1, 'TUCUNARE');
855insert into planting_materials (culture_id, name) VALUES (1, 'W 712 RR');
856insert into planting_materials (culture_id, name) VALUES (1, 'W 787 RR');
857insert into planting_materials (culture_id, name) VALUES (1, 'W 791 RR');
858insert into planting_materials (culture_id, name) VALUES (1, 'W 799 RR');
859insert into planting_materials (culture_id, name) VALUES (1, 'W 842 RR');
860insert into planting_materials (culture_id, name) VALUES (1, 'W 870');
861insert into planting_materials (culture_id, name) VALUES (1, 'W 875 RR');
862insert into planting_materials (culture_id, name) VALUES (1, 'W 888 CV');
863insert into planting_materials (culture_id, name) VALUES (1, 'neo 680 IPRO');
864insert into planting_materials (culture_id, name) VALUES (1, 'neo 710 IPRO');
865insert into planting_materials (culture_id, name) VALUES (1, 'neo 740 IPRO');
866insert into planting_materials (culture_id, name) VALUES (1, 'neo 750 IPRO');
867
868--Milho
869insert into planting_materials (culture_id, name) VALUES (4, '2A401PW');
870insert into planting_materials (culture_id, name) VALUES (4, '2A401RR');
871insert into planting_materials (culture_id, name) VALUES (4, '2A510PW');
872insert into planting_materials (culture_id, name) VALUES (4, '2B433PW');
873insert into planting_materials (culture_id, name) VALUES (4, '2B688PW');
874insert into planting_materials (culture_id, name) VALUES (4, '2B688RR');
875insert into planting_materials (culture_id, name) VALUES (4, '2B810PW');
876insert into planting_materials (culture_id, name) VALUES (4, '30F35');
877insert into planting_materials (culture_id, name) VALUES (4, '30F35R');
878insert into planting_materials (culture_id, name) VALUES (4, '30F35VYHR');
879insert into planting_materials (culture_id, name) VALUES (4, '30F53');
880insert into planting_materials (culture_id, name) VALUES (4, '30F53R');
881insert into planting_materials (culture_id, name) VALUES (4, '30F53VYH');
882insert into planting_materials (culture_id, name) VALUES (4, '30F53VYHR');
883insert into planting_materials (culture_id, name) VALUES (4, '30S31');
884insert into planting_materials (culture_id, name) VALUES (4, '30S31VYH');
885insert into planting_materials (culture_id, name) VALUES (4, '30S31VYHR');
886insert into planting_materials (culture_id, name) VALUES (4, '32R22VYH');
887insert into planting_materials (culture_id, name) VALUES (4, '32R22VYHR');
888insert into planting_materials (culture_id, name) VALUES (4, '32R22YHR');
889insert into planting_materials (culture_id, name) VALUES (4, 'B2360PW');
890insert into planting_materials (culture_id, name) VALUES (4, 'B2401PWU');
891insert into planting_materials (culture_id, name) VALUES (4, 'B2410PWU');
892insert into planting_materials (culture_id, name) VALUES (4, 'B2418VYHR');
893insert into planting_materials (culture_id, name) VALUES (4, 'B2433PWU');
894insert into planting_materials (culture_id, name) VALUES (4, 'B2510PWU');
895insert into planting_materials (culture_id, name) VALUES (4, 'B2612PWU');
896insert into planting_materials (culture_id, name) VALUES (4, 'B2620PWU');
897insert into planting_materials (culture_id, name) VALUES (4, 'B2688PWU');
898insert into planting_materials (culture_id, name) VALUES (4, 'B2702VYHR');
899insert into planting_materials (culture_id, name) VALUES (4, 'B2730VYH');
900insert into planting_materials (culture_id, name) VALUES (4, 'B2782PWU');
901insert into planting_materials (culture_id, name) VALUES (4, 'B2810PWU');
902insert into planting_materials (culture_id, name) VALUES (4, 'B2828');
903insert into planting_materials (culture_id, name) VALUES (4, 'B2856VYHR');
904insert into planting_materials (culture_id, name) VALUES (4, 'BG7037VYH');
905insert into planting_materials (culture_id, name) VALUES (4, 'BG7049');
906insert into planting_materials (culture_id, name) VALUES (4, 'BG7318');
907insert into planting_materials (culture_id, name) VALUES (4, 'BG7318R');
908insert into planting_materials (culture_id, name) VALUES (4, 'BG7318VYH');
909insert into planting_materials (culture_id, name) VALUES (4, 'BG7318YH');
910insert into planting_materials (culture_id, name) VALUES (4, 'BG7640R');
911insert into planting_materials (culture_id, name) VALUES (4, 'BG7640VYH');
912insert into planting_materials (culture_id, name) VALUES (4, 'CD3410PW');
913insert into planting_materials (culture_id, name) VALUES (4, 'CD3612PW');
914insert into planting_materials (culture_id, name) VALUES (4, 'CD3612RR');
915insert into planting_materials (culture_id, name) VALUES (4, 'P3340VYHR');
916insert into planting_materials (culture_id, name) VALUES (4, 'P3380HR');
917insert into planting_materials (culture_id, name) VALUES (4, 'P3380R');
918insert into planting_materials (culture_id, name) VALUES (4, 'P3456');
919insert into planting_materials (culture_id, name) VALUES (4, 'P3456R');
920insert into planting_materials (culture_id, name) VALUES (4, 'P3565PWU');
921insert into planting_materials (culture_id, name) VALUES (4, 'P3646');
922insert into planting_materials (culture_id, name) VALUES (4, 'P3646YHR');
923insert into planting_materials (culture_id, name) VALUES (4, 'P3707VYH');
924insert into planting_materials (culture_id, name) VALUES (4, 'P3754PWU');
925insert into planting_materials (culture_id, name) VALUES (4, 'P3898');
926insert into planting_materials (culture_id, name) VALUES (4, 'P4285');
927insert into planting_materials (culture_id, name) VALUES (4, 'P4285R');
928insert into planting_materials (culture_id, name) VALUES (4, 'P4285VYHR');
929insert into planting_materials (culture_id, name) VALUES (4, 'P4285YHR');
930insert into planting_materials (culture_id, name) VALUES (4, 'Ferox Viptera');
931insert into planting_materials (culture_id, name) VALUES (4, 'Ferox Viptera 3');
932insert into planting_materials (culture_id, name) VALUES (4, 'Fórmula');
933insert into planting_materials (culture_id, name) VALUES (4, 'Fórmula Viptera 2');
934insert into planting_materials (culture_id, name) VALUES (4, 'Fórmula Viptera');
935insert into planting_materials (culture_id, name) VALUES (4, 'Impacto');
936insert into planting_materials (culture_id, name) VALUES (4, 'Impacto Viptera 3');
937insert into planting_materials (culture_id, name) VALUES (4, 'Maximus');
938insert into planting_materials (culture_id, name) VALUES (4, 'Maximus Viptera 3');
939insert into planting_materials (culture_id, name) VALUES (4, 'NK422 VIP3 (SYN422 VIP3)');
940insert into planting_materials (culture_id, name) VALUES (4, 'NK555 VIP3 (SYN555 VIP3)');
941insert into planting_materials (culture_id, name) VALUES (4, 'StatusTG');
942insert into planting_materials (culture_id, name) VALUES (4, 'Status Viptera 3');
943insert into planting_materials (culture_id, name) VALUES (4, 'Supremo');
944insert into planting_materials (culture_id, name) VALUES (4, 'Supremo Viptera');
945insert into planting_materials (culture_id, name) VALUES (4, 'Supremo Viptera 3');
946insert into planting_materials (culture_id, name) VALUES (4, 'Syn422 Vip3');
947insert into planting_materials (culture_id, name) VALUES (4, 'Syn488 Vip3');
948insert into planting_materials (culture_id, name) VALUES (4, 'AS 1551');
949insert into planting_materials (culture_id, name) VALUES (4, 'AS 1555');
950insert into planting_materials (culture_id, name) VALUES (4, 'AS 1581');
951insert into planting_materials (culture_id, name) VALUES (4, 'AS 1590');
952insert into planting_materials (culture_id, name) VALUES (4, 'AS 1598');
953insert into planting_materials (culture_id, name) VALUES (4, 'AS 1633');
954insert into planting_materials (culture_id, name) VALUES (4, 'AS 1656');
955insert into planting_materials (culture_id, name) VALUES (4, 'AS 1677');
956insert into planting_materials (culture_id, name) VALUES (4, 'AS 1770');
957insert into planting_materials (culture_id, name) VALUES (4, 'AS 1777');
958insert into planting_materials (culture_id, name) VALUES (4, 'AS 1780');
959insert into planting_materials (culture_id, name) VALUES (4, 'AS 1820');
960insert into planting_materials (culture_id, name) VALUES (4, 'AS 1844');
961insert into planting_materials (culture_id, name) VALUES (4, 'AS 1850');
962insert into planting_materials (culture_id, name) VALUES (4, 'AS 1868');
963insert into planting_materials (culture_id, name) VALUES (4, 'AS 1575');
964insert into planting_materials (culture_id, name) VALUES (4, 'AS 1596');
965insert into planting_materials (culture_id, name) VALUES (4, 'AS 1666');
966insert into planting_materials (culture_id, name) VALUES (4, 'AS 1730');
967insert into planting_materials (culture_id, name) VALUES (4, 'AS 1757');
968
969
970-- Lista de Pragas
971
972--Feijão
973insert into pests (culture_id, name, scientific_name) VALUES (2, 'Lagarta-rosca', ' ');
974insert into pests (culture_id, name, scientific_name) VALUES (2, 'Lagarta-elasmo', ' ');
975insert into pests (culture_id, name, scientific_name) VALUES (2, 'Vaquinha-verde-amarela', ' ');
976insert into pests (culture_id, name, scientific_name) VALUES (2, 'Lagarta falsa-medideira', ' ');
977insert into pests (culture_id, name, scientific_name) VALUES (2, 'Mosca-branca', ' ');
978insert into pests (culture_id, name, scientific_name) VALUES (2, 'Broca-das-axilas', ' ');
979insert into pests (culture_id, name, scientific_name) VALUES (2, 'Tamanduá-da-soja', ' ');
980insert into pests (culture_id, name, scientific_name) VALUES (2, 'Lagarta-das-vagens', ' ');
981insert into pests (culture_id, name, scientific_name) VALUES (2, 'Lagarta-helicoverpa', ' ');
982
983--Algodão
984insert into pests (culture_id, name, scientific_name) VALUES (12, 'Bicudo do algodoeiro', ' ');
985insert into pests (culture_id, name, scientific_name) VALUES (12, 'Curuquerê do algodoeiro', ' ');
986insert into pests (culture_id, name, scientific_name) VALUES (12, 'Lagarta das maças', ' ');
987insert into pests (culture_id, name, scientific_name) VALUES (12, 'Lagarta rosada', ' ');
988insert into pests (culture_id, name, scientific_name) VALUES (12, 'Lagarta-do-cartucho (Spodoptera f.)', ' ');
989insert into pests (culture_id, name, scientific_name) VALUES (12, 'Lagarta-rosca', ' ');
990insert into pests (culture_id, name, scientific_name) VALUES (12, 'Mosca-branca', ' ');
991insert into pests (culture_id, name, scientific_name) VALUES (12, 'Percevejo rajado', ' ');
992insert into pests (culture_id, name, scientific_name) VALUES (12, 'Percevejo-castanho', ' ');
993insert into pests (culture_id, name, scientific_name) VALUES (12, 'Percevejo-manchador', ' ');
994insert into pests (culture_id, name, scientific_name) VALUES (12, 'Pulgão do algodoeiro', ' ');
995insert into pests (culture_id, name, scientific_name) VALUES (12, 'Tripes', ' ');
996insert into pests (culture_id, name, scientific_name) VALUES (12, 'Broca da raiz', ' ');
997insert into pests (culture_id, name, scientific_name) VALUES (12, 'Percevjo castanho da raiz', ' ');
998insert into pests (culture_id, name, scientific_name) VALUES (12, 'Lagarta falsa-medideira', ' ');
999
1000
1001--Arroz
1002insert into pests (culture_id, name, scientific_name) VALUES (3, 'Lagarta-elasmo', ' ');
1003insert into pests (culture_id, name, scientific_name) VALUES (3, 'Cascudo-preto', ' ');
1004insert into pests (culture_id, name, scientific_name) VALUES (3, 'Pulgão da raiz', ' ');
1005insert into pests (culture_id, name, scientific_name) VALUES (3, 'Pulga do arroz', ' ');
1006insert into pests (culture_id, name, scientific_name) VALUES (3, 'Lagarta da folha (Spodoptera f.)', ' ');
1007insert into pests (culture_id, name, scientific_name) VALUES (3, 'Lagarta boiadeira', ' ');
1008insert into pests (culture_id, name, scientific_name) VALUES (3, 'Bicheira da raiz', ' ');
1009insert into pests (culture_id, name, scientific_name) VALUES (3, 'Broca do colmo', ' ');
1010insert into pests (culture_id, name, scientific_name) VALUES (3, 'Percevejo do colmo', ' ');
1011insert into pests (culture_id, name, scientific_name) VALUES (3, 'Percevejo do grão', ' ');
1012
1013--Aveia
1014insert into pests (culture_id, name, scientific_name) VALUES (14, 'Coró do trigo', ' ');
1015insert into pests (culture_id, name, scientific_name) VALUES (14, 'Pulgão da aveia', ' ');
1016insert into pests (culture_id, name, scientific_name) VALUES (14, 'Lagarta do trigo', ' ');
1017insert into pests (culture_id, name, scientific_name) VALUES (14, 'Grilo', ' ');
1018insert into pests (culture_id, name, scientific_name) VALUES (14, 'Lagarta-enroladeira', ' ');
1019insert into pests (culture_id, name, scientific_name) VALUES (14, 'Mosca-branca', ' ');
1020insert into pests (culture_id, name, scientific_name) VALUES (14, 'Cigarrinha-verde', ' ');
1021insert into pests (culture_id, name, scientific_name) VALUES (14, 'Saúvas', ' ');
1022
1023-- Café
1024insert into pests (culture_id, name, scientific_name) VALUES (7, 'Broca do café', ' ');
1025insert into pests (culture_id, name, scientific_name) VALUES (7, 'Cigarra do cafeeiro', ' ');
1026insert into pests (culture_id, name, scientific_name) VALUES (7, 'Cochonilha farinhenta', ' ');
1027insert into pests (culture_id, name, scientific_name) VALUES (7, 'Cochonilha de placa', ' ');
1028insert into pests (culture_id, name, scientific_name) VALUES (7, 'Lagarta dos cafezais', ' ');
1029insert into pests (culture_id, name, scientific_name) VALUES (7, 'Lagarta rosca', ' ');
1030insert into pests (culture_id, name, scientific_name) VALUES (7, 'Bicho mineiro', ' ');
1031insert into pests (culture_id, name, scientific_name) VALUES (7, 'Ácaro da leprose', ' ');
1032insert into pests (culture_id, name, scientific_name) VALUES (7, 'Ácarro vermelho', ' ');
1033insert into pests (culture_id, name, scientific_name) VALUES (7, 'Lagarta mede palmo', ' ');
1034insert into pests (culture_id, name, scientific_name) VALUES (7, 'Broca dos ramos', ' ');
1035
1036--Cana de Açúcar
1037insert into pests (culture_id, name, scientific_name) VALUES (5, 'Lagarta-elasmo', ' ');
1038insert into pests (culture_id, name, scientific_name) VALUES (5, 'Cigarrinha-da-cana', ' ');
1039insert into pests (culture_id, name, scientific_name) VALUES (5, 'Bicudo-da-cana', ' ');
1040insert into pests (culture_id, name, scientific_name) VALUES (5, 'Broca-da-cana', ' ');
1041insert into pests (culture_id, name, scientific_name) VALUES (5, 'Cupim', ' ');
1042insert into pests (culture_id, name, scientific_name) VALUES (5, 'Formiga cortadeira', ' ');
1043insert into pests (culture_id, name, scientific_name) VALUES (5, 'Corós', ' ');
1044insert into pests (culture_id, name, scientific_name) VALUES (5, 'Percevejo-castanho', ' ');
1045insert into pests (culture_id, name, scientific_name) VALUES (5, 'Besouro Migdolus', ' ');
1046
1047--Citros
1048insert into pests (culture_id, name, scientific_name) VALUES (8, 'Ácaro da ferrugem', ' ');
1049insert into pests (culture_id, name, scientific_name) VALUES (8, 'Ácaro branco', ' ');
1050insert into pests (culture_id, name, scientific_name) VALUES (8, 'Ácaro vermelho', ' ');
1051insert into pests (culture_id, name, scientific_name) VALUES (8, 'Cochonilha ortézia', ' ');
1052insert into pests (culture_id, name, scientific_name) VALUES (8, 'Larva minadora', ' ');
1053insert into pests (culture_id, name, scientific_name) VALUES (8, 'Broca das laranjeiras', ' ');
1054insert into pests (culture_id, name, scientific_name) VALUES (8, 'Mosca-das-frutas', ' ');
1055insert into pests (culture_id, name, scientific_name) VALUES (8, 'Ácaro da leprose dos citros', ' ');
1056insert into pests (culture_id, name, scientific_name) VALUES (8, 'Mosca-branca', ' ');
1057insert into pests (culture_id, name, scientific_name) VALUES (8, 'Pulgão preto', ' ');
1058insert into pests (culture_id, name, scientific_name) VALUES (8, 'Cochonilha verde', ' ');
1059insert into pests (culture_id, name, scientific_name) VALUES (8, 'Cochonilha cabeça-de-prego', ' ');
1060insert into pests (culture_id, name, scientific_name) VALUES (8, 'Cigarrinha', ' ');
1061
1062--Milheto
1063insert into pests (culture_id, name, scientific_name) VALUES (11, 'Lagarta elasmo', ' ');
1064insert into pests (culture_id, name, scientific_name) VALUES (11, 'Broca da cana-de-açúcar', ' ');
1065insert into pests (culture_id, name, scientific_name) VALUES (11, 'Lagarta do cartucho', ' ');
1066insert into pests (culture_id, name, scientific_name) VALUES (11, 'Pulgão verde', ' ');
1067insert into pests (culture_id, name, scientific_name) VALUES (11, 'Percevejo verde', ' ');
1068insert into pests (culture_id, name, scientific_name) VALUES (11, 'Lagarta da espiga', ' ');
1069insert into pests (culture_id, name, scientific_name) VALUES (11, 'Vaquinha verde e amarela', ' ');
1070insert into pests (culture_id, name, scientific_name) VALUES (11, 'Curuquerê dos capinzais', ' ');
1071insert into pests (culture_id, name, scientific_name) VALUES (11, 'Percevejo das gramíneas', ' ');
1072insert into pests (culture_id, name, scientific_name) VALUES (11, 'Coró pão de galinha', ' ');
1073insert into pests (culture_id, name, scientific_name) VALUES (11, 'Larva arame', ' ');
1074
1075--Pastagem
1076insert into pests (culture_id, name, scientific_name) VALUES (6, 'Cochonilha da pastagem', ' ');
1077insert into pests (culture_id, name, scientific_name) VALUES (6, 'Lagarta dos capinzais', ' ');
1078insert into pests (culture_id, name, scientific_name) VALUES (6, 'Formiga desfolhadora', ' ');
1079insert into pests (culture_id, name, scientific_name) VALUES (6, 'Cigarrinha das pastagens', ' ');
1080insert into pests (culture_id, name, scientific_name) VALUES (6, 'Cupim', ' ');
1081
1082--Soja
1083insert into pests (culture_id, name, scientific_name) VALUES (1, 'Broca-das-axilas', ' ');
1084insert into pests (culture_id, name, scientific_name) VALUES (1, 'Broca-da-vagem', ' ');
1085insert into pests (culture_id, name, scientific_name) VALUES (1, 'Burrinho', ' ');
1086insert into pests (culture_id, name, scientific_name) VALUES (1, 'Cascudinho-verde', ' ');
1087insert into pests (culture_id, name, scientific_name) VALUES (1, 'Coró-da-soja', ' ');
1088insert into pests (culture_id, name, scientific_name) VALUES (1, 'Formiga-cortadeira', ' ');
1089insert into pests (culture_id, name, scientific_name) VALUES (1, 'Gafanhoto', ' ');
1090insert into pests (culture_id, name, scientific_name) VALUES (1, 'Lagarta-cabeça-de-fósforo', ' ');
1091insert into pests (culture_id, name, scientific_name) VALUES (1, 'Lagarta-da-soja', ' ');
1092insert into pests (culture_id, name, scientific_name) VALUES (1, 'Lagarta-da-vagem (Spodoptera eridania)', ' ');
1093insert into pests (culture_id, name, scientific_name) VALUES (1, 'Lagarta-da-vagem (Spodoptera cosmioides)', ' ');
1094insert into pests (culture_id, name, scientific_name) VALUES (1, 'Lagarta-elasmo', ' ');
1095insert into pests (culture_id, name, scientific_name) VALUES (1, 'Lagarta-enroladeira', ' ');
1096insert into pests (culture_id, name, scientific_name) VALUES (1, 'Lagarta-falsa-medideira', ' ');
1097insert into pests (culture_id, name, scientific_name) VALUES (1, 'Lagarta-medideira', ' ');
1098insert into pests (culture_id, name, scientific_name) VALUES (1, 'Lagarta-do-cartucho (Spodoptera frugiperda)', ' ');
1099insert into pests (culture_id, name, scientific_name) VALUES (1, 'Lagarta-rosca', ' ');
1100insert into pests (culture_id, name, scientific_name) VALUES (1, 'Mosca-branca', ' ');
1101insert into pests (culture_id, name, scientific_name) VALUES (1, 'Percevejo-asa-preta', ' ');
1102insert into pests (culture_id, name, scientific_name) VALUES (1, 'Percevejo-barriga-verde', ' ');
1103insert into pests (culture_id, name, scientific_name) VALUES (1, 'Percevejo-castanho', ' ');
1104insert into pests (culture_id, name, scientific_name) VALUES (1, 'Percevejo-formigão', ' ');
1105insert into pests (culture_id, name, scientific_name) VALUES (1, 'Percevejo-marrom', ' ');
1106insert into pests (culture_id, name, scientific_name) VALUES (1, 'Percevejo-verde', ' ');
1107insert into pests (culture_id, name, scientific_name) VALUES (1, 'Percevejo-verde-pequeno', ' ');
1108insert into pests (culture_id, name, scientific_name) VALUES (1, 'Tamanduá-da-soja', ' ');
1109insert into pests (culture_id, name, scientific_name) VALUES (1, 'Torrãozinho', ' ');
1110insert into pests (culture_id, name, scientific_name) VALUES (1, 'Tripes', ' ');
1111insert into pests (culture_id, name, scientific_name) VALUES (1, 'Vaquinha-verde-amarela', ' ');
1112insert into pests (culture_id, name, scientific_name) VALUES (1, 'Vaquinha-preta-e-amarela', ' ');
1113
1114--Sorgo
1115insert into pests (culture_id, name, scientific_name) VALUES (10, 'Larva-arame', ' ');
1116insert into pests (culture_id, name, scientific_name) VALUES (10, 'Coró', ' ');
1117insert into pests (culture_id, name, scientific_name) VALUES (10, 'Brocas-do-colmo', ' ');
1118insert into pests (culture_id, name, scientific_name) VALUES (10, 'Lagarta-elasmo', ' ');
1119insert into pests (culture_id, name, scientific_name) VALUES (10, 'Broca-da-cana-de-açúcar', ' ');
1120insert into pests (culture_id, name, scientific_name) VALUES (10, 'Pulgão-verde', ' ');
1121insert into pests (culture_id, name, scientific_name) VALUES (10, 'Pulgão-do-milho', ' ');
1122insert into pests (culture_id, name, scientific_name) VALUES (10, 'Lagarta-do-cartucho (Spodoptera f.)', ' ');
1123insert into pests (culture_id, name, scientific_name) VALUES (10, 'Curuquerê-dos-capinzais', ' ');
1124insert into pests (culture_id, name, scientific_name) VALUES (10, 'Mosca-do-sorgo', ' ');
1125insert into pests (culture_id, name, scientific_name) VALUES (10, 'Lagarta-da-espiga (Helicoverpa z.)', ' ');
1126insert into pests (culture_id, name, scientific_name) VALUES (10, 'Percevejo-barriga-verde', ' ');
1127
1128--Trigo 
1129insert into pests (culture_id, name, scientific_name) VALUES (13, 'Lagarta Spodoptera', ' ');
1130insert into pests (culture_id, name, scientific_name) VALUES (13, 'Pulgão da folha do trigo', ' ');
1131insert into pests (culture_id, name, scientific_name) VALUES (13, 'Pulgão do colmo', ' ');
1132insert into pests (culture_id, name, scientific_name) VALUES (13, 'Pulgão da espiga do trigo', ' ');
1133insert into pests (culture_id, name, scientific_name) VALUES (13, 'Coró do trigo', ' ');
1134insert into pests (culture_id, name, scientific_name) VALUES (13, 'Pulgão da aveia', ' ');
1135insert into pests (culture_id, name, scientific_name) VALUES (13, 'Lagarta do trigo', ' ');
1136insert into pests (culture_id, name, scientific_name) VALUES (13, 'Grilo', ' ');
1137insert into pests (culture_id, name, scientific_name) VALUES (13, 'Lagarta-enroladeira', ' ');
1138insert into pests (culture_id, name, scientific_name) VALUES (13, 'Mosca-branca', ' ');
1139insert into pests (culture_id, name, scientific_name) VALUES (13, 'Cigarrinha-verde', ' ');
1140insert into pests (culture_id, name, scientific_name) VALUES (13, 'Saúvas', ' ');
1141
1142--Amendoim
1143insert into pests (culture_id, name, scientific_name) VALUES (15, 'Tripes-do-prateamento', ' ');
1144insert into pests (culture_id, name, scientific_name) VALUES (15, 'Lagarta-do-pescoço-vermelho', ' ');
1145insert into pests (culture_id, name, scientific_name) VALUES (15, 'Lagarta-da-soja', ' ');
1146insert into pests (culture_id, name, scientific_name) VALUES (15, 'Lagarta-marrom (Spodoptera spp.)', ' ');
1147insert into pests (culture_id, name, scientific_name) VALUES (15, 'Percevejo-preto', ' ');
1148insert into pests (culture_id, name, scientific_name) VALUES (15, 'Percevejo-castanho', ' ');
1149insert into pests (culture_id, name, scientific_name) VALUES (15, 'Vaquinha-verde-amarela', ' ');
1150insert into pests (culture_id, name, scientific_name) VALUES (15, 'Lagarta-rosca', ' ');
1151insert into pests (culture_id, name, scientific_name) VALUES (15, 'Lagarta-elasmo', ' ');
1152insert into pests (culture_id, name, scientific_name) VALUES (15, 'Cigarrinha-verde', ' ');
1153insert into pests (culture_id, name, scientific_name) VALUES (15, 'Gafanhoto', ' ');
1154insert into pests (culture_id, name, scientific_name) VALUES (15, 'Curuquerê-dos-capinzais', ' ');
1155insert into pests (culture_id, name, scientific_name) VALUES (15, 'Lagarta-da-teia', ' ');
1156
1157--Batata
1158insert into pests (culture_id, name, scientific_name) VALUES (16, 'Vaquinha-verde-amarela', ' ');
1159insert into pests (culture_id, name, scientific_name) VALUES (16, 'Mosca-minadora', ' ');
1160insert into pests (culture_id, name, scientific_name) VALUES (16, 'Traça', ' ');
1161insert into pests (culture_id, name, scientific_name) VALUES (16, 'Cigarrinha', ' ');
1162insert into pests (culture_id, name, scientific_name) VALUES (16, 'Lagarta rosca', ' ');
1163insert into pests (culture_id, name, scientific_name) VALUES (16, 'Vaquinha-da-batata', ' ');
1164insert into pests (culture_id, name, scientific_name) VALUES (16, 'Mosca-branca', ' ');
1165insert into pests (culture_id, name, scientific_name) VALUES (16, 'Cochonilha branca', ' ');
1166insert into pests (culture_id, name, scientific_name) VALUES (16, 'Lagarta Spodoptera spp.', ' ');
1167
1168--Cevada 
1169insert into pests (culture_id, name, scientific_name) VALUES (17, 'Pulgão', ' ');
1170insert into pests (culture_id, name, scientific_name) VALUES (17, 'Lagarta-do-trigo', ' ');
1171insert into pests (culture_id, name, scientific_name) VALUES (17, 'Coró-do-trigo', ' ');
1172insert into pests (culture_id, name, scientific_name) VALUES (17, 'Coró-das-pastagens', ' ');
1173
1174--Gergelim
1175insert into pests (culture_id, name, scientific_name) VALUES (18, 'Lagarta-enroladeira', ' ');
1176insert into pests (culture_id, name, scientific_name) VALUES (18, 'Pulgão', ' ');
1177insert into pests (culture_id, name, scientific_name) VALUES (18, 'Mosca-branca', ' ');
1178insert into pests (culture_id, name, scientific_name) VALUES (18, 'Cigarrinha-verde', ' ');
1179insert into pests (culture_id, name, scientific_name) VALUES (18, 'Saúvas', ' ');