From 5de4171a81407686bd7bb30789b33b7f69903df4 Mon Sep 17 00:00:00 2001 From: Daniel Vassdal 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') 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 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') 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 From afaf9495c1f2d5f1ba7b01c3b8a437083d91abb2 Mon Sep 17 00:00:00 2001 From: Daniel Vassdal Date: Sat, 21 Feb 2015 12:37:42 +0100 Subject: m_sqloper.mssql.sql: Add `active` column --- extras/m_sqloper.mssql.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'extras') diff --git a/extras/m_sqloper.mssql.sql b/extras/m_sqloper.mssql.sql index 5056e12e9..7580a4391 100644 --- a/extras/m_sqloper.mssql.sql +++ b/extras/m_sqloper.mssql.sql @@ -4,5 +4,6 @@ CREATE TABLE [dbo].[ircd_opers] ( [password] varchar(255) NULL, [hostname] varchar(255) NULL, [type] varchar(255) NULL, + [active] bit NOT NULL DEFAULT 1, PRIMARY KEY CLUSTERED ([id]) ) -- cgit v1.2.3 From 0b1315b1da2d5274b6a9f61eaa30bc731e066639 Mon Sep 17 00:00:00 2001 From: Daniel Vassdal Date: Sat, 21 Feb 2015 12:39:31 +0100 Subject: m_sqloper.postgresql.sql: Add `active` column --- extras/m_sqloper.postgresql.sql | 8 ++------ 1 file changed, 2 insertions(+), 6 deletions(-) (limited to 'extras') diff --git a/extras/m_sqloper.postgresql.sql b/extras/m_sqloper.postgresql.sql index fd640949f..4244abc22 100644 --- a/extras/m_sqloper.postgresql.sql +++ b/extras/m_sqloper.postgresql.sql @@ -1,14 +1,10 @@ --- --- PostgreSQL database dump --- - CREATE TABLE ircd_opers ( id serial NOT NULL, username text, "password" text, hostname text, - "type" text + "type" text, + active boolean NOT NULL DEFAULT 1 ); ALTER TABLE ONLY ircd_opers ADD CONSTRAINT ircd_opers_pkey PRIMARY KEY (id); - -- cgit v1.2.3 From 0a195d3dc2a1d3f63560d8010cde5cb89e025cd9 Mon Sep 17 00:00:00 2001 From: Daniel Vassdal Date: Sun, 22 Feb 2015 14:35:34 +0100 Subject: m_sqloper.sqlite3.sql: Add `active` column --- extras/m_sqloper.sqlite3.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'extras') diff --git a/extras/m_sqloper.sqlite3.sql b/extras/m_sqloper.sqlite3.sql index 1bb2937b8..1c607e664 100644 --- a/extras/m_sqloper.sqlite3.sql +++ b/extras/m_sqloper.sqlite3.sql @@ -3,5 +3,5 @@ id integer primary key, username text, password text, hostname text, -type text); - +type text, +active integer NOT NULL DEFAULT 1); -- cgit v1.2.3