1. /* Add the `Memory' category. */
2. insert into category (`name`) values ('Memory');
3. ​
4. /* And add the following sub-categories to it:
5. ​
6. Batteries
7. Configuration Proms for FPGAs
8. Controllers
9. Memory. */
10. insert into sub_category (`name`, `category_key`) values ('Batteries', (select `key` from `category` where `name` = 'Memory'));
11. ​
12. insert into sub_category (`name`, `category_key`) values ('Configuration Proms for FPGAs',(select `key` from `category` where `name` = 'Memory'));
13. ​
14. insert into sub_category (`name`, `category_key`) values ('Controllers',(select `key` from `category` where `name` = 'Memory'));
15. ​
16. insert into sub_category (`name`, `category_key`) values ('Memory',(select `key` from `category` where `name` = 'Memory'));
17. ​
18. /* Add a couple of manufacturers. */
19. insert into manufacturer (`name`) values ('Analog Devices/Maxim Integrated');
20. insert into manufacturer (`name`) values ('Atmel');
21. insert into manufacturer (`name`) values ('Dallas Semiconductor');
22. insert into manufacturer (`name`) values ('Fairchild Semiconductor');
23. insert into manufacturer (`name`) values ('Honeywell Aerospace');
24. insert into manufacturer (`name`) values ('Intersil');
25. insert into manufacturer (`name`) values ('Microchip Technology');
26. insert into manufacturer (`name`) values ('NXP Semiconductors');
27. insert into manufacturer (`name`) values ('onsemi');
28. insert into manufacturer (`name`) values ('STMicroelectronics');
29. ​
30. /* Add them all to the `sub-categories-per-manufacturer' table. */
31. insert into sub_categories_per_manufacturer (`sub_category_key`, `manufacturer_key`) values
32. ((select `key` from `sub_category` where `name` = 'Memory'),
33. (select `key` from `manufacturer` where `name` = 'Analog Devices/Maxim Integrated'));
34. ​
35. insert into sub_categories_per_manufacturer (`sub_category_key`, `manufacturer_key`) values
36. ((select `key` from `sub_category` where `name` = 'Memory'),
37. (select `key` from `manufacturer` where `name` = 'Atmel'));
38. ​
39. insert into sub_categories_per_manufacturer (`sub_category_key`, `manufacturer_key`) values
40. ((select `key` from `sub_category` where `name` = 'Memory'),
41. (select `key` from `manufacturer` where `name` = 'Dallas Semiconductor'));
42. ​
43. insert into sub_categories_per_manufacturer (`sub_category_key`, `manufacturer_key`) values
44. ((select `key` from `sub_category` where `name` = 'Memory'),
45. (select `key` from `manufacturer` where `name` = 'Fairchild Semiconductor'));
46. ​
47. insert into sub_categories_per_manufacturer (`sub_category_key`, `manufacturer_key`) values
48. ((select `key` from `sub_category` where `name` = 'Memory'),
49. (select `key` from `manufacturer` where `name` = 'Honeywell Aerospace'));
50. ​
51. insert into sub_categories_per_manufacturer (`sub_category_key`, `manufacturer_key`) values
52. ((select `key` from `sub_category` where `name` = 'Memory'),
53. (select `key` from `manufacturer` where `name` = 'Intersil'));
54. ​
55. insert into sub_categories_per_manufacturer (`sub_category_key`, `manufacturer_key`) values
56. ((select `key` from `sub_category` where `name` = 'Memory'),
57. (select `key` from `manufacturer` where `name` = 'Microchip Technology'));
58. ​
59. insert into sub_categories_per_manufacturer (`sub_category_key`, `manufacturer_key`) values
60. ((select `key` from `sub_category` where `name` = 'Memory'),
61. (select `key` from `manufacturer` where `name` = 'NXP Semiconductors'));
62. ​
63. insert into sub_categories_per_manufacturer (`sub_category_key`, `manufacturer_key`) values
64. ((select `key` from `sub_category` where `name` = 'Memory'),
65. (select `key` from `manufacturer` where `name` = 'onsemi'));
66. ​
67. insert into sub_categories_per_manufacturer (`sub_category_key`, `manufacturer_key`) values
68. ((select `key` from `sub_category` where `name` = 'Memory'),
69. (select `key` from `manufacturer` where `name` = 'STMicroelectronics'));
70. ​
71. /*
72. * Populate the rest of the tables, and add an eeprom.
73. */
74. insert into memory_series (`name`) values ('24CW');
75. insert into memory_series (`name`) values ('25CS');
76. insert into memory_series (`name`) values ('25CS');
77. insert into memory_series (`name`) values ('Automotive, AEC-Q100');
78. insert into memory_series (`name`) values ('Automotive, AEC-Q101');
79. insert into memory_series (`name`) values ('CAT25040');
80. insert into memory_series (`name`) values ('CAT25640');
81. insert into memory_series (`name`) values ('CAT25C128');
82. insert into memory_series (`name`) values ('CAT25C17A');
83. insert into memory_series (`name`) values ('CAT25LV256');
84. insert into memory_series (`name`) values ('CAT25LV65');
85. insert into memory_series (`name`) values ('CAT25LC40');
86. insert into memory_series (`name`) values ('CAT93CT6');
87. ​
88. insert into memory_technology (`name`) values ('EEPROM');
89. insert into memory_technology (`name`) values ('FLASH-NAND, DRAM-LPDDR');
90. ​
91. insert into memory_size (`name`) values ('256bit');
92. insert into memory_size (`name`) values ('896bit');
93. insert into memory_size (`name`) values ('1Kbit');
94. insert into memory_size (`name`) values ('1.25Kbit');
95. insert into memory_size (`name`) values ('2Kbit');
96. insert into memory_size (`name`) values ('4Kbit');
97. insert into memory_size (`name`) values ('8Kbit');
98. insert into memory_size (`name`) values ('16Kbit');
99. insert into memory_size (`name`) values ('32Kbit');
100. insert into memory_size (`name`) values ('64Kbit');
101. insert into memory_size (`name`) values ('128Kbit');
102. insert into memory_size (`name`) values ('256Kbit');
103. insert into memory_size (`name`) values ('512Kbit');
104. insert into memory_size (`name`) values ('20Kbit');
105. insert into memory_size (`name`) values ('1Mbit');
106. ​
107. insert into memory_organization (`name`) values ('32 Bytes x 5 Pages');
108. insert into memory_organization (`name`) values ('32 Bytes x 8 Pages');
109. insert into memory_organization (`name`) values ('112 Bytes x 8 Pages');
110. insert into memory_organization (`name`) values ('128 Bytes x 8 Pages');
111. insert into memory_organization (`name`) values ('256 Bytes x 16 Pages');
112. insert into memory_organization (`name`) values ('256 Bytes x 4 Pages');
113. insert into memory_organization (`name`) values ('256 Bytes x 8 Pages');
114. insert into memory_organization (`name`) values ('256 Bytes x 80 Pages');
115. insert into memory_organization (`name`) values ('512 Bytes x 8 Pages');
116. insert into memory_organization (`name`) values ('1K x 1 Page');
117. insert into memory_organization (`name`) values ('2K x 1 Page');
118. ​
119. insert into memory_interface (`name`) values ('1-Wire');
120. insert into memory_interface (`name`) values ('3-Wire Serial');
121. insert into memory_interface (`name`) values ('Parallel');
122. insert into memory_interface (`name`) values ('I2C');
123. insert into memory_interface (`name`) values ('SPI');
124. ​
125. insert into memory_frequency (`name`) values ('400 Khz');
126. insert into memory_frequency (`name`) values ('2 Mhz');
127. insert into memory_frequency (`name`) values ('1 Mhz');
128. insert into memory_frequency (`name`) values ('3 Mhz');
129. insert into memory_frequency (`name`) values ('5 Mhz');
130. insert into memory_frequency (`name`) values ('10 Mhz');
131. insert into memory_frequency (`name`) values ('20 Mhz');
132. ​
133. insert into memory_write_cycle_time (`name`) values ('1us');
134. insert into memory_write_cycle_time (`name`) values ('5us');
135. insert into memory_write_cycle_time (`name`) values ('10ms');
136. insert into memory_write_cycle_time (`name`) values ('25ms');
137. ​
138. insert into memory_access_time (`name`) values ('40ns');
139. insert into memory_access_time (`name`) values ('80ns');
140. insert into memory_access_time (`name`) values ('90ns');
141. insert into memory_access_time (`name`) values ('120ns');
142. insert into memory_access_time (`name`) values ('150ns');
143. insert into memory_access_time (`name`) values ('200ns');
144. insert into memory_access_time (`name`) values ('250ns');
145. insert into memory_access_time (`name`) values ('550ns');
146. insert into memory_access_time (`name`) values ('900ns');
147. insert into memory_access_time (`name`) values ('4.5us');
148. insert into memory_access_time (`name`) values ('2us');
149. insert into memory_access_time (`name`) values ('15us');
150. ​
151. insert into memory_voltage_supply (`name`) values ('1.62V ~ 5.5V');
152. insert into memory_voltage_supply (`name`) values ('1.7V ~ 3.6V');
153. insert into memory_voltage_supply (`name`) values ('1.7V ~ 5.5V');
154. insert into memory_voltage_supply (`name`) values ('1.8V ~ 3.6V');
155. insert into memory_voltage_supply (`name`) values ('1.8V ~ 5.5V');
156. insert into memory_voltage_supply (`name`) values ('1.71V ~ 3.63V');
157. insert into memory_voltage_supply (`name`) values ('1.75V ~ 3.65V');
158. insert into memory_voltage_supply (`name`) values ('2V ~ 5.25V');
159. insert into memory_voltage_supply (`name`) values ('2.2V ~ 5.25V');
160. insert into memory_voltage_supply (`name`) values ('2.5V ~ 5.25V');
161. insert into memory_voltage_supply (`name`) values ('2.5V ~ 5.5V');
162. insert into memory_voltage_supply (`name`) values ('2.7V ~ 5.5V');
163. insert into memory_voltage_supply (`name`) values ('2.7V ~ 3.6V');
164. insert into memory_voltage_supply (`name`) values ('2.8V ~ 5.25V');
165. insert into memory_voltage_supply (`name`) values ('2.8V ~ 6V');
166. insert into memory_voltage_supply (`name`) values ('2.85V ~ 5.25V');
167. insert into memory_voltage_supply (`name`) values ('2.97V ~ 3.63V');
168. insert into memory_voltage_supply (`name`) values ('3V ~ 3.6V');
169. insert into memory_voltage_supply (`name`) values ('3V ~ 5.25V');
170. insert into memory_voltage_supply (`name`) values ('4.5V ~ 5.5V');
171. ​
172. insert into memory_operating_temperature (`name`) values ('-55C ~ 125C (TA)');
173. insert into memory_operating_temperature (`name`) values ('-55C ~ 125C (TC)');
174. insert into memory_operating_temperature (`name`) values ('-40C ~ 125C (TA)');
175. insert into memory_operating_temperature (`name`) values ('-40C ~ 85C (TA)');
176. insert into memory_operating_temperature (`name`) values ('-40C ~ 85C');
177. insert into memory_operating_temperature (`name`) values ('-30C ~ 85C (TA)');
178. insert into memory_operating_temperature (`name`) values ('-20C ~ 85C (TA)');
179. insert into memory_operating_temperature (`name`) values ('0C ~ 70C (TA)');
180. ​
181. insert into memory_mounting_type (`name`) values ('Surface Mount');
182. insert into memory_mounting_type (`name`) values ('Through Hole');
183. ​
184. insert into memory_package (`name`) values ('2-SFN');
185. insert into memory_package (`name`) values ('2-WDFN');
186. insert into memory_package (`name`) values ('2-XDFN');
187. insert into memory_package (`name`) values ('4-UBGA,FCBGA');
188. insert into memory_package (`name`) values ('4-XFBGA, WLBGA');
189. insert into memory_package (`name`) values ('6-SMD, J-Lead');
190. insert into memory_package (`name`) values ('6-VBGA, FCBGA');
191. insert into memory_package (`name`) values ('6-WDFN, Exposed Pad');
192. insert into memory_package (`name`) values ('6-WDFBGA, CSPBGA');
193. insert into memory_package (`name`) values ('6-XBGA, FCBGA');
194. insert into memory_package (`name`) values ('8-SOIC (3.9 mm width)');
195. insert into memory_package (`name`) values ('8-SOIC (5.3 mm width)');
196. insert into memory_package (`name`) values ('8-TSSOP, 8-MSOP (3.0 mm width)');
197. insert into memory_package (`name`) values ('8-TSSOP, 4.40mm width)');
198. insert into memory_package (`name`) values ('8-WFBGA, CSPBGA');
199. insert into memory_package (`name`) values ('8-WFDFN Exposed Pad');
200. insert into memory_package (`name`) values ('8-UDFN Exposed Pad');
201. insert into memory_package (`name`) values ('8-UFDFN Exposed Pad');
202. insert into memory_package (`name`) values ('8-VFBGA');
203. insert into memory_package (`name`) values ('8-VFDFN Exposed Pad');
204. insert into memory_package (`name`) values ('8-XDFN');
205. insert into memory_package (`name`) values ('28-BCPGA');
206. insert into memory_package (`name`) values ('28-CFlatPack');
207. insert into memory_package (`name`) values ('12-WQFN Exposed Pad');
208. insert into memory_package (`name`) values ('8-SOIC (3.90 mm. width)');
209. insert into memory_package (`name`) values ('16-SOIC (3.90 mm. width)');
210. insert into memory_package (`name`) values ('28-TSSOP (4.40 mm. width) Exposed Pad');
211. insert into memory_package (`name`) values ('28-TSSOP (11.8 mm. width)');
212. insert into memory_package (`name`) values ('32-CLCC');
213. insert into memory_package (`name`) values ('36-WFQFN Exposed Pad');
214. insert into memory_package (`name`) values ('TO-226-3, TO-92-3 (TO-226AA) Formed Leads');
215. insert into memory_package (`name`) values ('TO-226-3, TO-92-3 (TO-226AA)');
216. insert into memory_package (`name`) values ('TO-226-3, TO-92-3 Long Body');
217. insert into memory_package (`name`) values ('TO-226-3, SC-59, SOT-23-3');
218. insert into memory_package (`name`) values ('8-DIP (7.62 mm)');
219. ​
220. /* Finally, add an eeprom. */
221. insert into memory_eeprom
222. (
223. `part_number`,
224. `manufacturer_part_number`,
225. `description`,
226. `detailed_description`,
227. `picture`,
228. `data_sheet`,
229. `eda_model`,
230. `rohs_compilant_p`,
231. `moisture_sensitivity_level`,
232. `reach_status`,
233. `eccn`,
234. `htsus`,
235. `lead_time`,
236. `standard_packaging`,
237. `stock_type`,
238. `quantity_available`,
239. `price`,
240. `manufacturer`,
241. `series`,
242. `product_status`,
243. `technology`,
244. `memory_size`,
245. `memory_organization`,
246. `memory_interface`,
247. `clock_frequency`,
248. `write_cycle_time`,
249. `access_time`,
250. `voltage_supply`,
251. `operating_temperature`,
252. `mounting_type`,
253. `package`) values
254. ('2156-AT25020N-10SA-5.0C-ND',
255. 'AT25020N-10SA-5.0C',
256. 'IC EEPROM 2KBIT SPI 3MHZ 8SOIC',
257. 'EEPROM Memory IC 2Kbit SPI 3 MHz 8-SOIC',
258. null,
259. null,
260. null,
261. '1',
262. '3',
263. 'Vendor Undefined',
264. 'EAR99',
265. '8542.32.0051',
266. '0',
267. '2500',
268. 'in-stock',
269. '902',
270. '0.33000',
271. (select `key` from `manufacturer` where `name` = 'Atmel'),
272. (select `key` from `memory_series` where `name` = '-'),
273. 'active',
274. (select `key` from memory_technology where name = 'EEPROM'),
275. (select `key` from memory_size where name = '2Kbit'),
276. (select `key` from memory_organization where name = '256 Bytes x 8 Pages'),
277. (select `key` from memory_interface where name = 'SPI'),
278. (select `key` from memory_frequency where name = '3 Mhz'),
279. (select `key` from memory_write_cycle_time where name = '5ms'),
280. (select `key` from `memory_access_time` where `name` = '-'),
281. (select `key` from memory_voltage_supply where name = '4.5V ~ 5.5V'),
282. (select `key` from memory_operating_temperature where name = '-55C ~ 125C (TA)'),
283. (select `key` from memory_mounting_type where name = 'Surface Mount'),
284. (select `key` from memory_package where name = '8-SOIC (3.90 mm. width)')
285. );