# 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> ``` ``` 效果