]> jfr.im git - erebus.git/commitdiff
update sql: remove unsigned from users.level
authorJohn Runyon <redacted>
Sat, 3 Feb 2024 11:01:01 +0000 (04:01 -0700)
committerJohn Runyon <redacted>
Sat, 3 Feb 2024 11:01:01 +0000 (04:01 -0700)
alter table users modify level tinyint(3) not null;

dump.sql

index c4962cd8dbc98d4d4fe01bd43848ea92d9e81b3f..29cfe0c877b536c12c1d13f3376f80e72fbc51d8 100644 (file)
--- a/dump.sql
+++ b/dump.sql
@@ -107,7 +107,7 @@ DROP TABLE IF EXISTS `users`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `users` (
   `auth` varchar(30) NOT NULL,
-  `level` tinyint(3) unsigned NOT NULL,
+  `level` tinyint(3) NOT NULL,
   PRIMARY KEY (`auth`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;