From 4353a0f3f12ca253285e3edf9f2206e526f112ce Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?=E9=98=94=E8=90=BD?=
 <45323514+BigCoke233@users.noreply.github.com>
Date: Sun, 24 Mar 2019 18:02:47 +0800
Subject: Add files via upload

---
 plugins/Links/Update_SQLite.sql | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)
 create mode 100644 plugins/Links/Update_SQLite.sql

(limited to 'plugins/Links/Update_SQLite.sql')

diff --git a/plugins/Links/Update_SQLite.sql b/plugins/Links/Update_SQLite.sql
new file mode 100644
index 0000000..6bced38
--- /dev/null
+++ b/plugins/Links/Update_SQLite.sql
@@ -0,0 +1,25 @@
+CREATE TABLE `typecho_links_upgrade` (
+  `lid` INTEGER NOT NULL PRIMARY KEY,
+  `name` varchar(200) default NULL,
+  `url` varchar(200) default NULL,
+  `sort` varchar(200) default NULL,
+  `image` varchar(200) default NULL,
+  `description` varchar(200) default NULL,
+  `user` varchar(200) default NULL,
+  `order` int(10) default '0'
+);
+INSERT INTO `typecho_links_upgrade` (`lid`, `name`, `url`, `sort`, `image`, `description`, `user`, `order`)
+SELECT `lid`, `name`, `url`, NULL, NULL, `description`, NULL, `order` FROM `typecho_links`;
+DROP TABLE `typecho_links`;
+CREATE TABLE `typecho_links` (
+  `lid` INTEGER NOT NULL PRIMARY KEY,
+  `name` varchar(200) default NULL,
+  `url` varchar(200) default NULL,
+  `sort` varchar(200) default NULL,
+  `image` varchar(200) default NULL,
+  `description` varchar(200) default NULL,
+  `user` varchar(200) default NULL,
+  `order` int(10) default '0'
+);
+INSERT INTO `typecho_links` SELECT * FROM `typecho_links_upgrade`;
+DROP TABLE `typecho_links_upgrade`;
-- 
cgit v1.2.3