# 12. 卸載刪除演示數據 ## 卸載刪除演示數據 用于刪除導入的演示數據，如果開發者提供了演示數據就必須提供一份刪除演示數據的sql文件 在模板主題根目錄命名為：undemodata.sql 數據庫里面的表前綴使用`@prefix@` 代替，如下 ``` <pre class="calibre16">``` insert into `@prefix@archives`<span class="token1">(</span>`id`<span class="token1">,</span>`category_id`<span class="token1">,</span>`model_id`<span class="token1">,</span>`admin_id`<span class="token1">,</span>`title`<span class="token1">,</span>`thumb`<span class="token1">,</span>`seotitle`<span class="token1">,</span>`keywords`<span class="token1">,</span>`description`<span class="token1">,</span>`tags`<span class="token1">,</span>`show_tpl`<span class="token1">,</span>`publish_time`<span class="token1">,</span>`create_time`<span class="token1">,</span>`update_time`<span class="token1">,</span>`delete_time`<span class="token1">,</span>`weigh`<span class="token1">,</span>`author`<span class="token1">,</span>`url`<span class="token1">,</span>`views`<span class="token1">,</span>`lang`<span class="token1">,</span>`status`<span class="token1">,</span>`flags`<span class="token1">)</span> values <span class="token1">(</span><span class="token2">null</span><span class="token1">,</span><span class="token3">6</span><span class="token1">,</span><span class="token3">1</span><span class="token1">,</span><span class="token3">1</span><span class="token1">,</span><span class="token4">'Honor certificate'</span><span class="token1">,</span><span class="token4">'/static/module/index/default/img/honor.jpg'</span><span class="token1">,</span><span class="token4">''</span><span class="token1">,</span><span class="token4">''</span><span class="token1">,</span><span class="token4">''</span><span class="token1">,</span><span class="token4">''</span><span class="token1">,</span><span class="token4">'show.html'</span><span class="token1">,</span><span class="token3">1636988345</span><span class="token1">,</span><span class="token3">1636988345</span><span class="token1">,</span><span class="token3">1636988345</span><span class="token1">,</span>NULL<span class="token1">,</span><span class="token3">0</span><span class="token1">,</span><span class="token4">'小編'</span><span class="token1">,</span><span class="token4">''</span><span class="token1">,</span><span class="token3">0</span><span class="token1">,</span><span class="token4">'en'</span><span class="token1">,</span><span class="token4">'normal'</span><span class="token1">,</span><span class="token4">''</span><span class="token1">)</span><span class="token1">;</span> ``` ``` 將在卸載模板時執行undemodata.sql文件