From 5de4171a81407686bd7bb30789b33b7f69903df4 Mon Sep 17 00:00:00 2001
From: Daniel Vassdal <shutter@canternet.org>
Date: Sat, 21 Feb 2015 12:09:40 +0100
Subject: m_sqloper.mysql.sql: TYPE is deprecated as of MySQL 5.5 "The older
 TYPE option that was synonymous with ENGINE was removed in MySQL 5.5."
 https://dev.mysql.com/doc/refman/5.6/en/create-table.html

---
 extras/m_sqloper.mysql.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'extras/m_sqloper.mysql.sql')

diff --git a/extras/m_sqloper.mysql.sql b/extras/m_sqloper.mysql.sql
index 293a2aa70..9464adc1d 100644
--- a/extras/m_sqloper.mysql.sql
+++ b/extras/m_sqloper.mysql.sql
@@ -15,7 +15,7 @@ CREATE TABLE ircd_opers (
   hostname text,
   type text,
   PRIMARY KEY  (id)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
 
 --
 -- Dumping data for table `ircd_opers`
-- 
cgit v1.2.3


From dddfcadebd313ab8b9fbaf4769d65f6473e1614a Mon Sep 17 00:00:00 2001
From: Daniel Vassdal <shutter@canternet.org>
Date: Sat, 21 Feb 2015 12:18:27 +0100
Subject: m_sqloper.mysql.sql: Add `active` column

---
 extras/m_sqloper.mysql.sql | 17 +----------------
 1 file changed, 1 insertion(+), 16 deletions(-)

(limited to 'extras/m_sqloper.mysql.sql')

diff --git a/extras/m_sqloper.mysql.sql b/extras/m_sqloper.mysql.sql
index 9464adc1d..f43495806 100644
--- a/extras/m_sqloper.mysql.sql
+++ b/extras/m_sqloper.mysql.sql
@@ -1,24 +1,9 @@
--- MySQL dump 9.11
---
--- Host: localhost    Database: brain
--- ------------------------------------------------------
--- Server version	4.0.20
-
---
--- Table structure for table `ircd_opers`
---
-
 CREATE TABLE ircd_opers (
   id bigint(20) NOT NULL auto_increment,
   username text,
   password text,
   hostname text,
   type text,
+  active tinyint(1) NOT NULL DEFAULT 1,
   PRIMARY KEY  (id)
 ) ENGINE=MyISAM;
-
---
--- Dumping data for table `ircd_opers`
---
-
-
-- 
cgit v1.2.3

