# 11. 導入演示數據 ## 導入演示數據 在模板主題根目錄命名為：demodata.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> ``` ``` 效果