From 212edb5034a60a6fbef83bd40636ac1447951415 Mon Sep 17 00:00:00 2001 From: Yehonal Date: Fri, 18 Nov 2016 13:23:30 +0100 Subject: Archived old sql files, they are now integrated in base --- data/sql/base/db_auth/auth_db_version.sql | 26 -------------------------- data/sql/base/db_auth/logs.sql | 30 ++++++++++++++++++++++++++++++ data/sql/base/db_auth/version_db_auth.sql | 31 +++++++++++++++++++++++++++++++ 3 files changed, 61 insertions(+), 26 deletions(-) delete mode 100644 data/sql/base/db_auth/auth_db_version.sql create mode 100644 data/sql/base/db_auth/logs.sql create mode 100644 data/sql/base/db_auth/version_db_auth.sql (limited to 'data/sql/base/db_auth') diff --git a/data/sql/base/db_auth/auth_db_version.sql b/data/sql/base/db_auth/auth_db_version.sql deleted file mode 100644 index 6733d6a918..0000000000 --- a/data/sql/base/db_auth/auth_db_version.sql +++ /dev/null @@ -1,26 +0,0 @@ -/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; -/*!40103 SET TIME_ZONE='+00:00' */; -/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; -/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; -/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -DROP TABLE IF EXISTS `auth_db_version`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `auth_db_version` -( - `2016_07_10_00` bit(1) DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Last applied sql update to DB'; -/*!40101 SET character_set_client = @saved_cs_client */; - -LOCK TABLES `auth_db_version` WRITE; -/*!40000 ALTER TABLE `auth_db_version` DISABLE KEYS */; -/*!40000 ALTER TABLE `auth_db_version` ENABLE KEYS */; -UNLOCK TABLES; -/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; - -/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; -/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; -/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; -/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; - diff --git a/data/sql/base/db_auth/logs.sql b/data/sql/base/db_auth/logs.sql new file mode 100644 index 0000000000..ef8d5849ac --- /dev/null +++ b/data/sql/base/db_auth/logs.sql @@ -0,0 +1,30 @@ +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; +/*!40103 SET TIME_ZONE='+00:00' */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; +DROP TABLE IF EXISTS `logs`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `logs` +( + `time` int(10) unsigned NOT NULL, + `realm` int(10) unsigned NOT NULL, + `type` varchar(250) NOT NULL, + `level` tinyint(3) unsigned NOT NULL DEFAULT '0', + `string` text CHARACTER SET latin1 +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +LOCK TABLES `logs` WRITE; +/*!40000 ALTER TABLE `logs` DISABLE KEYS */; +/*!40000 ALTER TABLE `logs` ENABLE KEYS */; +UNLOCK TABLES; +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + diff --git a/data/sql/base/db_auth/version_db_auth.sql b/data/sql/base/db_auth/version_db_auth.sql new file mode 100644 index 0000000000..8e34016ae4 --- /dev/null +++ b/data/sql/base/db_auth/version_db_auth.sql @@ -0,0 +1,31 @@ +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; +/*!40103 SET TIME_ZONE='+00:00' */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; +DROP TABLE IF EXISTS `version_db_auth`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `version_db_auth` +( + `sql_rev` varchar(100) NOT NULL, + `required_rev` varchar(100) DEFAULT NULL, + `2016_09_04_00` bit(1) DEFAULT NULL, + PRIMARY KEY (`sql_rev`), + KEY `required` (`required_rev`), + CONSTRAINT `required` FOREIGN KEY (`required_rev`) REFERENCES `version_db_auth` (`sql_rev`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Last applied sql update to DB'; +/*!40101 SET character_set_client = @saved_cs_client */; + +LOCK TABLES `version_db_auth` WRITE; +/*!40000 ALTER TABLE `version_db_auth` DISABLE KEYS */; +/*!40000 ALTER TABLE `version_db_auth` ENABLE KEYS */; +UNLOCK TABLES; +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + -- cgit v1.2.3