[DATABASE][User_openid_prefs] Fix wrong type for modified column

[quix0rs-gnu-social.git] / db / site.sql

diff --git a/db/site.sql b/db/site.sql
index c630a83d522cfdbf7c35f72adfb572d65b5b5bbb..9e33fc007ccdcae8f9742e8917976a625b15785e 100644 (file)
--- a/db/site.sql
+++ b/db/site.sql
@@ -18,10 +18,10 @@ create table status_network (
     
     tags text comment 'site meta-info tags (pipe-separated)',
 
-    created datetime not null comment 'date this record was created',
-    modified timestamp comment 'date this record was modified'
+    created datetime not null comment 'date this record was created' default now(),
+    modified timestamp comment 'date this record was modified' default now()
 
-) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
+) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
 
 create table status_network_tag (
     site_id integer  comment 'unique id',
@@ -30,5 +30,5 @@ create table status_network_tag (
 
     constraint primary key (site_id, tag),
     index status_network_tag_tag_idx (tag)
-) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
+) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;