-- MySQL DB consistency check/fix
--
-- Usage:
-- cat dbfix.sql | mysql -u user -p puppet
--
-- WARNING: perform a database backup before running this script

-- Remove duplicate resources, and keep the latest one
DELETE bad_rows.*
FROM resources AS bad_rows
  INNER JOIN (
    SELECT title,restype,host_id, MAX(id) as max_id
    FROM resources
    GROUP BY title,restype,host_id
    HAVING count(*) > 1
  ) AS good_rows
  ON
    good_rows.title = bad_rows.title AND
    good_rows.restype = bad_rows.restype AND
    good_rows.host_id = bad_rows.host_id AND
    good_rows.max_id <> bad_rows.id;

-- Remove duplicate param_values, and keep the latest one
DELETE bad_rows.*
FROM param_values AS bad_rows
  INNER JOIN (
    SELECT value,param_name_id,resource_id, MAX(id) as max_id
    FROM param_values
    GROUP BY value,param_name_id,resource_id
    HAVING count(*) > 1
  ) AS good_rows
  ON
    good_rows.value = bad_rows.value AND
    good_rows.param_name_id = bad_rows.param_name_id AND
    good_rows.resource_id = bad_rows.resource_id AND
    good_rows.max_id <> bad_rows.id;

-- rewrite param_values that points to duplicated param_names
-- to point to the highest param_name id.
UPDATE
  param_values v
  INNER JOIN
  param_names n
  ON n.id = v.param_name_id
  INNER JOIN
  (
    SELECT name, MAX(id) as max_id
    FROM param_names
    GROUP BY name
    HAVING count(*) > 1
  ) nmax ON n.name = nmax.name
SET
  v.param_name_id = nmax.max_id;

-- Remove duplicate param_names, and keep the latest one
DELETE bad_rows.*
FROM param_names AS bad_rows
  INNER JOIN (
    SELECT name, MAX(id) as max_id
    FROM param_names
    GROUP BY name
    HAVING count(*) > 1
  ) AS good_rows
  ON
    good_rows.name = bad_rows.name AND
    good_rows.max_id <> bad_rows.id;

-- Remove duplicate resource_tags, and keep the highest one
DELETE bad_rows.*
FROM resource_tags AS bad_rows
  INNER JOIN (
    SELECT resource_id,puppet_tag_id, MAX(id) as max_id
    FROM resource_tags
    GROUP BY resource_id,puppet_tag_id
    HAVING count(*) > 1
  ) AS good_rows
  ON
    good_rows.resource_id = bad_rows.resource_id AND
    good_rows.puppet_tag_id = bad_rows.puppet_tag_id AND
    good_rows.max_id <> bad_rows.id;

-- rewrite resource_tags that points to duplicated puppet_tags
-- to point to the highest puppet_tags id.
UPDATE
  resource_tags v
  INNER JOIN
  puppet_tags n
  ON n.id = v.puppet_tag_id
  INNER JOIN
  (
    SELECT name, MAX(id) as max_id
    FROM puppet_tags
    GROUP BY name
    HAVING count(*) > 1
  ) nmax ON n.name = nmax.name
SET
  v.puppet_tag_id = nmax.max_id;

-- Remove duplicate puppet_tags, and keep the highest one
DELETE bad_rows.*
FROM puppet_tags AS bad_rows
  INNER JOIN (
    SELECT name, MAX(id) as max_id
    FROM puppet_tags
    GROUP BY name
    HAVING count(*) > 1
  ) AS good_rows
  ON
    good_rows.name = bad_rows.name AND
    good_rows.max_id <> bad_rows.id;

-- Fix dangling resources
-- note: we use a table to not exceed the number of InnoDB locks if there are two much
-- rows to delete.
-- this is an alternative to: DELETE resources FROM resources r LEFT JOIN hosts h ON h.id=r.host_id WHERE h.id IS NULL;
--
CREATE TABLE resources_c LIKE resources;
INSERT INTO resources_c SELECT r.* FROM resources r INNER JOIN hosts h ON h.id=r.host_id;
RENAME TABLE resources TO resources_old, resources_c TO resources;
DROP TABLE resources_old;

-- Fix dangling param_values
CREATE TABLE param_values_c LIKE param_values;
INSERT INTO param_values_c SELECT v.* FROM param_values v INNER JOIN resources r ON r.id=v.resource_id;
RENAME TABLE param_values TO param_values_old, param_values_c TO param_values;
DROP TABLE param_values_old;

-- Fix dangling resource_tags
CREATE TABLE resource_tags_c LIKE resource_tags;
INSERT INTO resource_tags_c SELECT t.* FROM resource_tags t INNER JOIN resources r ON r.id=t.resource_id;
RENAME TABLE resource_tags TO resource_tags_old, resource_tags_c TO resource_tags;
DROP TABLE resource_tags_old;
ef='#n14'>14</a>
<a id='n15' href='#n15'>15</a>
<a id='n16' href='#n16'>16</a>
<a id='n17' href='#n17'>17</a>
<a id='n18' href='#n18'>18</a>
<a id='n19' href='#n19'>19</a>
<a id='n20' href='#n20'>20</a>
<a id='n21' href='#n21'>21</a>
<a id='n22' href='#n22'>22</a>
<a id='n23' href='#n23'>23</a>
<a id='n24' href='#n24'>24</a>
<a id='n25' href='#n25'>25</a>
<a id='n26' href='#n26'>26</a>
<a id='n27' href='#n27'>27</a>
<a id='n28' href='#n28'>28</a>
<a id='n29' href='#n29'>29</a>
<a id='n30' href='#n30'>30</a>
<a id='n31' href='#n31'>31</a>
<a id='n32' href='#n32'>32</a>
<a id='n33' href='#n33'>33</a>
<a id='n34' href='#n34'>34</a>
<a id='n35' href='#n35'>35</a>
<a id='n36' href='#n36'>36</a>
<a id='n37' href='#n37'>37</a>
<a id='n38' href='#n38'>38</a>
<a id='n39' href='#n39'>39</a>
<a id='n40' href='#n40'>40</a>
<a id='n41' href='#n41'>41</a>
<a id='n42' href='#n42'>42</a>
<a id='n43' href='#n43'>43</a>
<a id='n44' href='#n44'>44</a>
<a id='n45' href='#n45'>45</a>
<a id='n46' href='#n46'>46</a>
<a id='n47' href='#n47'>47</a>
<a id='n48' href='#n48'>48</a>
<a id='n49' href='#n49'>49</a>
<a id='n50' href='#n50'>50</a>
<a id='n51' href='#n51'>51</a>
<a id='n52' href='#n52'>52</a>
<a id='n53' href='#n53'>53</a>
<a id='n54' href='#n54'>54</a>
<a id='n55' href='#n55'>55</a>
<a id='n56' href='#n56'>56</a>
<a id='n57' href='#n57'>57</a>
<a id='n58' href='#n58'>58</a>
<a id='n59' href='#n59'>59</a>
<a id='n60' href='#n60'>60</a>
<a id='n61' href='#n61'>61</a>
<a id='n62' href='#n62'>62</a>
<a id='n63' href='#n63'>63</a>
<a id='n64' href='#n64'>64</a>
<a id='n65' href='#n65'>65</a>
<a id='n66' href='#n66'>66</a>
<a id='n67' href='#n67'>67</a>
<a id='n68' href='#n68'>68</a>
<a id='n69' href='#n69'>69</a>
<a id='n70' href='#n70'>70</a>
<a id='n71' href='#n71'>71</a>
<a id='n72' href='#n72'>72</a>
<a id='n73' href='#n73'>73</a>
<a id='n74' href='#n74'>74</a>
<a id='n75' href='#n75'>75</a>
<a id='n76' href='#n76'>76</a>
<a id='n77' href='#n77'>77</a>
<a id='n78' href='#n78'>78</a>
<a id='n79' href='#n79'>79</a>
<a id='n80' href='#n80'>80</a>
<a id='n81' href='#n81'>81</a>
<a id='n82' href='#n82'>82</a>
<a id='n83' href='#n83'>83</a>
<a id='n84' href='#n84'>84</a>
<a id='n85' href='#n85'>85</a>
<a id='n86' href='#n86'>86</a>
<a id='n87' href='#n87'>87</a>
<a id='n88' href='#n88'>88</a>
<a id='n89' href='#n89'>89</a>
<a id='n90' href='#n90'>90</a>
<a id='n91' href='#n91'>91</a>
<a id='n92' href='#n92'>92</a>
<a id='n93' href='#n93'>93</a>
<a id='n94' href='#n94'>94</a>
<a id='n95' href='#n95'>95</a>
<a id='n96' href='#n96'>96</a>
<a id='n97' href='#n97'>97</a>
<a id='n98' href='#n98'>98</a>
<a id='n99' href='#n99'>99</a>
<a id='n100' href='#n100'>100</a>
<a id='n101' href='#n101'>101</a>
<a id='n102' href='#n102'>102</a>
<a id='n103' href='#n103'>103</a>
<a id='n104' href='#n104'>104</a>
<a id='n105' href='#n105'>105</a>
<a id='n106' href='#n106'>106</a>
<a id='n107' href='#n107'>107</a>
<a id='n108' href='#n108'>108</a>
<a id='n109' href='#n109'>109</a>
<a id='n110' href='#n110'>110</a>
<a id='n111' href='#n111'>111</a>
<a id='n112' href='#n112'>112</a>
<a id='n113' href='#n113'>113</a>
<a id='n114' href='#n114'>114</a>
<a id='n115' href='#n115'>115</a>
<a id='n116' href='#n116'>116</a>
<a id='n117' href='#n117'>117</a>
<a id='n118' href='#n118'>118</a>
<a id='n119' href='#n119'>119</a>
<a id='n120' href='#n120'>120</a>
<a id='n121' href='#n121'>121</a>
<a id='n122' href='#n122'>122</a>
<a id='n123' href='#n123'>123</a>
<a id='n124' href='#n124'>124</a>
<a id='n125' href='#n125'>125</a>
<a id='n126' href='#n126'>126</a>
<a id='n127' href='#n127'>127</a>
<a id='n128' href='#n128'>128</a>
<a id='n129' href='#n129'>129</a>
<a id='n130' href='#n130'>130</a>
<a id='n131' href='#n131'>131</a>
<a id='n132' href='#n132'>132</a>
<a id='n133' href='#n133'>133</a>
<a id='n134' href='#n134'>134</a>
<a id='n135' href='#n135'>135</a>
<a id='n136' href='#n136'>136</a>
<a id='n137' href='#n137'>137</a>
<a id='n138' href='#n138'>138</a>
<a id='n139' href='#n139'>139</a>
<a id='n140' href='#n140'>140</a>
<a id='n141' href='#n141'>141</a>
<a id='n142' href='#n142'>142</a>
<a id='n143' href='#n143'>143</a>
<a id='n144' href='#n144'>144</a>
<a id='n145' href='#n145'>145</a>
<a id='n146' href='#n146'>146</a>
<a id='n147' href='#n147'>147</a>
<a id='n148' href='#n148'>148</a>
<a id='n149' href='#n149'>149</a>
<a id='n150' href='#n150'>150</a>
<a id='n151' href='#n151'>151</a>
<a id='n152' href='#n152'>152</a>
<a id='n153' href='#n153'>153</a>
<a id='n154' href='#n154'>154</a>
<a id='n155' href='#n155'>155</a>
<a id='n156' href='#n156'>156</a>
<a id='n157' href='#n157'>157</a>
<a id='n158' href='#n158'>158</a>
<a id='n159' href='#n159'>159</a>
<a id='n160' href='#n160'>160</a>
<a id='n161' href='#n161'>161</a>
<a id='n162' href='#n162'>162</a>
<a id='n163' href='#n163'>163</a>
<a id='n164' href='#n164'>164</a>
<a id='n165' href='#n165'>165</a>
<a id='n166' href='#n166'>166</a>
<a id='n167' href='#n167'>167</a>
<a id='n168' href='#n168'>168</a>
<a id='n169' href='#n169'>169</a>
<a id='n170' href='#n170'>170</a>
<a id='n171' href='#n171'>171</a>
<a id='n172' href='#n172'>172</a>
<a id='n173' href='#n173'>173</a>
<a id='n174' href='#n174'>174</a>
<a id='n175' href='#n175'>175</a>
<a id='n176' href='#n176'>176</a>
<a id='n177' href='#n177'>177</a>
<a id='n178' href='#n178'>178</a>
<a id='n179' href='#n179'>179</a>
<a id='n180' href='#n180'>180</a>
<a id='n181' href='#n181'>181</a>
<a id='n182' href='#n182'>182</a>
<a id='n183' href='#n183'>183</a>
<a id='n184' href='#n184'>184</a>
<a id='n185' href='#n185'>185</a>
<a id='n186' href='#n186'>186</a>
<a id='n187' href='#n187'>187</a>
<a id='n188' href='#n188'>188</a>
<a id='n189' href='#n189'>189</a>
<a id='n190' href='#n190'>190</a>
<a id='n191' href='#n191'>191</a>
<a id='n192' href='#n192'>192</a>
<a id='n193' href='#n193'>193</a>
<a id='n194' href='#n194'>194</a>
<a id='n195' href='#n195'>195</a>
<a id='n196' href='#n196'>196</a>
<a id='n197' href='#n197'>197</a>
<a id='n198' href='#n198'>198</a>
<a id='n199' href='#n199'>199</a>
<a id='n200' href='#n200'>200</a>
<a id='n201' href='#n201'>201</a>
<a id='n202' href='#n202'>202</a>
<a id='n203' href='#n203'>203</a>
<a id='n204' href='#n204'>204</a>
<a id='n205' href='#n205'>205</a>
<a id='n206' href='#n206'>206</a>
<a id='n207' href='#n207'>207</a>
<a id='n208' href='#n208'>208</a>
<a id='n209' href='#n209'>209</a>
<a id='n210' href='#n210'>210</a>
<a id='n211' href='#n211'>211</a>
<a id='n212' href='#n212'>212</a>
<a id='n213' href='#n213'>213</a>
<a id='n214' href='#n214'>214</a>
<a id='n215' href='#n215'>215</a>
<a id='n216' href='#n216'>216</a>
<a id='n217' href='#n217'>217</a>
<a id='n218' href='#n218'>218</a>
<a id='n219' href='#n219'>219</a>
<a id='n220' href='#n220'>220</a>
<a id='n221' href='#n221'>221</a>
<a id='n222' href='#n222'>222</a>
<a id='n223' href='#n223'>223</a>
<a id='n224' href='#n224'>224</a>
<a id='n225' href='#n225'>225</a>
<a id='n226' href='#n226'>226</a>
<a id='n227' href='#n227'>227</a>
<a id='n228' href='#n228'>228</a>
<a id='n229' href='#n229'>229</a>
<a id='n230' href='#n230'>230</a>
<a id='n231' href='#n231'>231</a>
<a id='n232' href='#n232'>232</a>
<a id='n233' href='#n233'>233</a>
<a id='n234' href='#n234'>234</a>
<a id='n235' href='#n235'>235</a>
<a id='n236' href='#n236'>236</a>
<a id='n237' href='#n237'>237</a>
<a id='n238' href='#n238'>238</a>
<a id='n239' href='#n239'>239</a>
<a id='n240' href='#n240'>240</a>
<a id='n241' href='#n241'>241</a>
<a id='n242' href='#n242'>242</a>
<a id='n243' href='#n243'>243</a>
<a id='n244' href='#n244'>244</a>
<a id='n245' href='#n245'>245</a>
<a id='n246' href='#n246'>246</a>
<a id='n247' href='#n247'>247</a>
<a id='n248' href='#n248'>248</a>
<a id='n249' href='#n249'>249</a>
<a id='n250' href='#n250'>250</a>
<a id='n251' href='#n251'>251</a>
<a id='n252' href='#n252'>252</a>
<a id='n253' href='#n253'>253</a>
<a id='n254' href='#n254'>254</a>
<a id='n255' href='#n255'>255</a>
<a id='n256' href='#n256'>256</a>
<a id='n257' href='#n257'>257</a>
<a id='n258' href='#n258'>258</a>
<a id='n259' href='#n259'>259</a>
<a id='n260' href='#n260'>260</a>
<a id='n261' href='#n261'>261</a>
<a id='n262' href='#n262'>262</a>
<a id='n263' href='#n263'>263</a>
<a id='n264' href='#n264'>264</a>
<a id='n265' href='#n265'>265</a>
<a id='n266' href='#n266'>266</a>
<a id='n267' href='#n267'>267</a>
<a id='n268' href='#n268'>268</a>
<a id='n269' href='#n269'>269</a>
<a id='n270' href='#n270'>270</a>
<a id='n271' href='#n271'>271</a>
<a id='n272' href='#n272'>272</a>
<a id='n273' href='#n273'>273</a>
<a id='n274' href='#n274'>274</a>
<a id='n275' href='#n275'>275</a>
<a id='n276' href='#n276'>276</a>
<a id='n277' href='#n277'>277</a>
<a id='n278' href='#n278'>278</a>
<a id='n279' href='#n279'>279</a>
<a id='n280' href='#n280'>280</a>
<a id='n281' href='#n281'>281</a>
<a id='n282' href='#n282'>282</a>
<a id='n283' href='#n283'>283</a>
<a id='n284' href='#n284'>284</a>
<a id='n285' href='#n285'>285</a>
<a id='n286' href='#n286'>286</a>
<a id='n287' href='#n287'>287</a>
<a id='n288' href='#n288'>288</a>
<a id='n289' href='#n289'>289</a>
<a id='n290' href='#n290'>290</a>
<a id='n291' href='#n291'>291</a>
<a id='n292' href='#n292'>292</a>
<a id='n293' href='#n293'>293</a>
<a id='n294' href='#n294'>294</a>
<a id='n295' href='#n295'>295</a>
<a id='n296' href='#n296'>296</a>
<a id='n297' href='#n297'>297</a>
<a id='n298' href='#n298'>298</a>
<a id='n299' href='#n299'>299</a>
<a id='n300' href='#n300'>300</a>
<a id='n301' href='#n301'>301</a>
<a id='n302' href='#n302'>302</a>
<a id='n303' href='#n303'>303</a>
<a id='n304' href='#n304'>304</a>
<a id='n305' href='#n305'>305</a>
<a id='n306' href='#n306'>306</a>
<a id='n307' href='#n307'>307</a>
<a id='n308' href='#n308'>308</a>
<a id='n309' href='#n309'>309</a>
<a id='n310' href='#n310'>310</a>
<a id='n311' href='#n311'>311</a>
<a id='n312' href='#n312'>312</a>
<a id='n313' href='#n313'>313</a>
<a id='n314' href='#n314'>314</a>
<a id='n315' href='#n315'>315</a>
<a id='n316' href='#n316'>316</a>
<a id='n317' href='#n317'>317</a>
<a id='n318' href='#n318'>318</a>
<a id='n319' href='#n319'>319</a>
<a id='n320' href='#n320'>320</a>
<a id='n321' href='#n321'>321</a>
<a id='n322' href='#n322'>322</a>
<a id='n323' href='#n323'>323</a>
<a id='n324' href='#n324'>324</a>
<a id='n325' href='#n325'>325</a>
<a id='n326' href='#n326'>326</a>
<a id='n327' href='#n327'>327</a>
<a id='n328' href='#n328'>328</a>
<a id='n329' href='#n329'>329</a>
<a id='n330' href='#n330'>330</a>
<a id='n331' href='#n331'>331</a>
<a id='n332' href='#n332'>332</a>
<a id='n333' href='#n333'>333</a>
<a id='n334' href='#n334'>334</a>
<a id='n335' href='#n335'>335</a>
<a id='n336' href='#n336'>336</a>
<a id='n337' href='#n337'>337</a>
<a id='n338' href='#n338'>338</a>
<a id='n339' href='#n339'>339</a>
<a id='n340' href='#n340'>340</a>
<a id='n341' href='#n341'>341</a>
<a id='n342' href='#n342'>342</a>
<a id='n343' href='#n343'>343</a>
<a id='n344' href='#n344'>344</a>
<a id='n345' href='#n345'>345</a>
<a id='n346' href='#n346'>346</a>
<a id='n347' href='#n347'>347</a>
<a id='n348' href='#n348'>348</a>
<a id='n349' href='#n349'>349</a>
<a id='n350' href='#n350'>350</a>
<a id='n351' href='#n351'>351</a>
<a id='n352' href='#n352'>352</a>
<a id='n353' href='#n353'>353</a>
<a id='n354' href='#n354'>354</a>
<a id='n355' href='#n355'>355</a>
<a id='n356' href='#n356'>356</a>
<a id='n357' href='#n357'>357</a>
<a id='n358' href='#n358'>358</a>
<a id='n359' href='#n359'>359</a>
<a id='n360' href='#n360'>360</a>
<a id='n361' href='#n361'>361</a>
<a id='n362' href='#n362'>362</a>
<a id='n363' href='#n363'>363</a>
<a id='n364' href='#n364'>364</a>
<a id='n365' href='#n365'>365</a>
<a id='n366' href='#n366'>366</a>
<a id='n367' href='#n367'>367</a>
<a id='n368' href='#n368'>368</a>
<a id='n369' href='#n369'>369</a>
<a id='n370' href='#n370'>370</a>
<a id='n371' href='#n371'>371</a>
<a id='n372' href='#n372'>372</a>
<a id='n373' href='#n373'>373</a>
<a id='n374' href='#n374'>374</a>
<a id='n375' href='#n375'>375</a>
<a id='n376' href='#n376'>376</a>
<a id='n377' href='#n377'>377</a>
<a id='n378' href='#n378'>378</a>
<a id='n379' href='#n379'>379</a>
<a id='n380' href='#n380'>380</a>
<a id='n381' href='#n381'>381</a>
<a id='n382' href='#n382'>382</a>
<a id='n383' href='#n383'>383</a>
<a id='n384' href='#n384'>384</a>
<a id='n385' href='#n385'>385</a>
<a id='n386' href='#n386'>386</a>
<a id='n387' href='#n387'>387</a>
<a id='n388' href='#n388'>388</a>
<a id='n389' href='#n389'>389</a>
<a id='n390' href='#n390'>390</a>
<a id='n391' href='#n391'>391</a>
<a id='n392' href='#n392'>392</a>
<a id='n393' href='#n393'>393</a>
<a id='n394' href='#n394'>394</a>
<a id='n395' href='#n395'>395</a>
<a id='n396' href='#n396'>396</a>
<a id='n397' href='#n397'>397</a>
<a id='n398' href='#n398'>398</a>
<a id='n399' href='#n399'>399</a>
<a id='n400' href='#n400'>400</a>
<a id='n401' href='#n401'>401</a>
<a id='n402' href='#n402'>402</a>
<a id='n403' href='#n403'>403</a>
<a id='n404' href='#n404'>404</a>
<a id='n405' href='#n405'>405</a>
<a id='n406' href='#n406'>406</a>
<a id='n407' href='#n407'>407</a>
<a id='n408' href='#n408'>408</a>
<a id='n409' href='#n409'>409</a>
<a id='n410' href='#n410'>410</a>
<a id='n411' href='#n411'>411</a>
<a id='n412' href='#n412'>412</a>
<a id='n413' href='#n413'>413</a>
<a id='n414' href='#n414'>414</a>
<a id='n415' href='#n415'>415</a>
<a id='n416' href='#n416'>416</a>
<a id='n417' href='#n417'>417</a>
<a id='n418' href='#n418'>418</a>
<a id='n419' href='#n419'>419</a>
<a id='n420' href='#n420'>420</a>
<a id='n421' href='#n421'>421</a>
<a id='n422' href='#n422'>422</a>
<a id='n423' href='#n423'>423</a>
<a id='n424' href='#n424'>424</a>
<a id='n425' href='#n425'>425</a>
<a id='n426' href='#n426'>426</a>
</pre></td>
<td class='lines'><pre><code><span class="hl com">/*</span>
<span class="hl com"> * (C) Copyright 2006</span>
<span class="hl com"> * Markus Klotzbuecher, DENX Software Engineering, mk&#64;denx.de</span>
<span class="hl com"> *</span>
<span class="hl com"> * Configuation settings for the SPC1920 board.</span>
<span class="hl com"> *</span>
<span class="hl com"> * This program is free software; you can redistribute it and/or</span>
<span class="hl com"> * modify it under the terms of the GNU General Public License as</span>
<span class="hl com"> * published by the Free Software Foundation; either version 2 of</span>
<span class="hl com"> * the License, or (at your option) any later version.</span>
<span class="hl com"> *</span>
<span class="hl com"> * This program is distributed in the hope that it will be useful,</span>
<span class="hl com"> * but WITHOUT ANY WARRANTY; without even the implied warranty of</span>
<span class="hl com"> * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.	 See the</span>
<span class="hl com"> * GNU General Public License for more details.</span>
<span class="hl com"> *</span>
<span class="hl com"> * You should have received a copy of the GNU General Public License</span>
<span class="hl com"> * along with this program; if not, write to the Free Software</span>
<span class="hl com"> * Foundation, Inc., 59 Temple Place, Suite 330, Boston,</span>
<span class="hl com"> * MA 02111-1307 USA</span>
<span class="hl com"> */</span>

<span class="hl ppc">#ifndef __H</span>
<span class="hl ppc">#define __CONFIG_H</span>

<span class="hl ppc">#define CONFIG_SPC1920			1</span>	<span class="hl com">/* SPC1920 board */</span><span class="hl ppc"></span>
<span class="hl ppc">#define CONFIG_MPC885			1</span>	<span class="hl com">/* MPC885 CPU */</span><span class="hl ppc"></span>

<span class="hl ppc">#define	CONFIG_SYS_TEXT_BASE	0xFFF00000</span>

<span class="hl ppc">#define	CONFIG_8xx_CONS_SMC1</span>		<span class="hl com">/* Console is on SMC1 */</span><span class="hl ppc"></span>
<span class="hl ppc">#undef	CONFIG_8xx_CONS_SMC2</span>
<span class="hl ppc">#undef	CONFIG_8xx_CONS_NONE</span>

<span class="hl ppc">#define CONFIG_MII</span>
<span class="hl ppc">#define CONFIG_MII_INIT		1</span>
<span class="hl ppc">#undef CONFIG_ETHER_ON_FEC1</span>
<span class="hl ppc">#define CONFIG_ETHER_ON_FEC2</span>
<span class="hl ppc">#define FEC_ENET</span>
<span class="hl ppc">#define CONFIG_FEC2_PHY		1</span>

<span class="hl ppc">#define CONFIG_BAUDRATE		19200</span>

<span class="hl com">/* use PLD CLK4 instead of brg */</span>
<span class="hl ppc">#define CONFIG_SYS_SPC1920_SMC1_CLK4</span>

<span class="hl ppc">#define CONFIG_8xx_OSCLK		10000000</span> <span class="hl com">/* 10 MHz oscillator on EXTCLK  */</span><span class="hl ppc"></span>
<span class="hl ppc">#define CONFIG_8xx_CPUCLK_DEFAULT	50000000</span>
<span class="hl ppc">#define CONFIG_SYS_8xx_CPUCLK_MIN		40000000</span>
<span class="hl ppc">#define CONFIG_SYS_8xx_CPUCLK_MAX		133000000</span>

<span class="hl ppc">#define CONFIG_SYS_RESET_ADDRESS		0xC0000000</span>

<span class="hl ppc">#define CONFIG_BOARD_EARLY_INIT_F</span>
<span class="hl ppc">#define CONFIG_LAST_STAGE_INIT</span>

<span class="hl ppc">#if 0</span>
<span class="hl ppc">#define CONFIG_BOOTDELAY	-1</span>	<span class="hl com">/* autoboot disabled		*/</span><span class="hl ppc"></span>
<span class="hl ppc">#else</span>
<span class="hl ppc">#define CONFIG_BOOTDELAY	5</span>	<span class="hl com">/* autoboot after 5 seconds	*/</span><span class="hl ppc"></span>
<span class="hl ppc">#endif</span>

<span class="hl ppc">#define CONFIG_ENV_OVERWRITE</span>

<span class="hl ppc">#define CONFIG_NFSBOOTCOMMAND							\</span>
<span class="hl ppc"></span>    <span class="hl pps">&quot;dhcp;&quot;</span><span class="hl ppc">									\</span>
<span class="hl ppc"></span>    <span class="hl pps">&quot;setenv bootargs root=/dev/nfs rw nfsroot=$rootpath &quot;</span><span class="hl ppc">			\</span>
<span class="hl ppc"></span>    <span class="hl pps">&quot;ip=$ipaddr:$serverip:$gatewayip:$netmask:$hostname:eth0:off;&quot;</span><span class="hl ppc">		\</span>
<span class="hl ppc"></span>    <span class="hl pps">&quot;bootm&quot;</span><span class="hl ppc"></span>

<span class="hl ppc">#define CONFIG_BOOTCOMMAND							\</span>
<span class="hl ppc"></span>    <span class="hl pps">&quot;setenv bootargs root=/dev/mtdblock2 rw mtdparts=phys:1280K(ROM)ro,-(root) &quot;</span><span class="hl ppc">\</span>
<span class="hl ppc"></span>    <span class="hl pps">&quot;ip=$ipaddr:$serverip:$gatewayip:$netmask:$hostname:eth0:off;&quot;</span><span class="hl ppc">		\</span>
<span class="hl ppc"></span>    <span class="hl pps">&quot;bootm fe080000&quot;</span><span class="hl ppc"></span>

<span class="hl ppc">#undef CONFIG_BOOTARGS</span>

<span class="hl ppc">#undef	CONFIG_WATCHDOG</span>			<span class="hl com">/* watchdog disabled		*/</span><span class="hl ppc"></span>
<span class="hl ppc">#define CONFIG_BZIP2</span>	 <span class="hl com">/* include support for bzip2 compressed images */</span><span class="hl ppc"></span>


<span class="hl com">/*</span>
<span class="hl com"> * BOOTP options</span>
<span class="hl com"> */</span>
<span class="hl ppc">#define CONFIG_BOOTP_BOOTFILESIZE</span>
<span class="hl ppc">#define CONFIG_BOOTP_BOOTPATH</span>
<span class="hl ppc">#define CONFIG_BOOTP_GATEWAY</span>
<span class="hl ppc">#define CONFIG_BOOTP_HOSTNAME</span>


<span class="hl com">/*</span>
<span class="hl com"> * Command line configuration.</span>
<span class="hl com"> */</span>
<span class="hl ppc">#include &lt;config_cmd_default.h&gt;</span>

<span class="hl ppc">#define CONFIG_CMD_ASKENV</span>
<span class="hl ppc">#define CONFIG_CMD_DATE</span>
<span class="hl ppc">#define CONFIG_CMD_ECHO</span>
<span class="hl ppc">#define CONFIG_CMD_IMMAP</span>
<span class="hl ppc">#define CONFIG_CMD_JFFS2</span>
<span class="hl ppc">#define CONFIG_CMD_NET</span>
<span class="hl ppc">#define CONFIG_CMD_PING</span>
<span class="hl ppc">#define CONFIG_CMD_DHCP</span>
<span class="hl ppc">#define CONFIG_CMD_I2C</span>
<span class="hl ppc">#define CONFIG_CMD_MII</span>

<span class="hl com">/*</span>
<span class="hl com"> * Miscellaneous configurable options</span>
<span class="hl com"> */</span>
<span class="hl ppc">#define	CONFIG_SYS_LONGHELP</span>				<span class="hl com">/* undef to save memory		*/</span><span class="hl ppc"></span>
<span class="hl ppc">#define	CONFIG_SYS_PROMPT</span>		<span class="hl pps">&quot;=&gt;&quot;</span><span class="hl ppc"></span>		<span class="hl com">/* Monitor Command Prompt	*/</span><span class="hl ppc"></span>
<span class="hl ppc">#define CONFIG_SYS_HUSH_PARSER</span>
<span class="hl ppc">#define CONFIG_SYS_PROMPT_HUSH_PS2</span>	<span class="hl pps">&quot;&gt; &quot;</span><span class="hl ppc"></span>

<span class="hl ppc">#if defined(CONFIG_CMD_KGDB)</span>
<span class="hl ppc">#define	CONFIG_SYS_CBSIZE		1024</span>		<span class="hl com">/* Console I/O Buffer Size	*/</span><span class="hl ppc"></span>
<span class="hl ppc">#else</span>
<span class="hl ppc">#define	CONFIG_SYS_CBSIZE		256</span>		<span class="hl com">/* Console I/O Buffer Size	*/</span><span class="hl ppc"></span>
<span class="hl ppc">#endif</span>

<span class="hl ppc">#define	CONFIG_SYS_PBSIZE (CONFIG_SYS_CBSIZE + sizeof(CONFIG_SYS_PROMPT) + 16)</span> <span class="hl com">/* Print Buffer Size	*/</span><span class="hl ppc"></span>
<span class="hl ppc">#define	CONFIG_SYS_MAXARGS		16</span>		<span class="hl com">/* max number of command args	*/</span><span class="hl ppc">