diff options
| author | 阔落 <45323514+BigCoke233@users.noreply.github.com> | 2019-03-24 18:02:47 +0800 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-03-24 18:02:47 +0800 |
| commit | 4353a0f3f12ca253285e3edf9f2206e526f112ce (patch) | |
| tree | efd983701eeba6622028563048927aa848d239e8 /plugins/Links/Update_SQLite.sql | |
| parent | 107e63005d013dd3caea541c921dcf8be415014e (diff) | |
Add files via upload
Diffstat (limited to 'plugins/Links/Update_SQLite.sql')
| -rw-r--r-- | plugins/Links/Update_SQLite.sql | 25 |
1 files changed, 25 insertions, 0 deletions
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`;
|