1 def migrate_up(manager): 2 """migrate up the database schema. 3 4 @param manager: Instance of MigrationManager. 5 """ 6 manager.execute_script(INIT_DB_SQL) 7 manager.execute_script(INIT_VERSION_SQL) 8 9 10 def migrate_down(manager): 11 """migrate down the database schema. 12 13 @param manager: Instance of MigrationManager. 14 """ 15 manager.execute_script(DROP_DB_SQL) 16 17 18 INIT_VERSION_SQL = """\ 19 INSERT INTO migrate_info VALUES (0) 20 """ 21 22 INIT_DB_SQL = """\ 23 -- MySQL dump 10.13 Distrib 5.5.40, for debian-linux-gnu (x86_64) 24 -- 25 -- Host: localhost Database: chromeos_lab_servers 26 -- ------------------------------------------------------ 27 -- Server version 5.5.40-0ubuntu0.14.04.1 28 29 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 30 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 31 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 32 /*!40101 SET NAMES utf8 */; 33 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; 34 /*!40103 SET TIME_ZONE='+00:00' */; 35 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; 36 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; 37 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; 38 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; 39 40 -- 41 -- Table structure for table `migrate_info` 42 -- 43 44 DROP TABLE IF EXISTS `migrate_info`; 45 /*!40101 SET @saved_cs_client = @@character_set_client */; 46 /*!40101 SET character_set_client = utf8 */; 47 CREATE TABLE `migrate_info` ( 48 `version` int(11) DEFAULT NULL 49 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 50 /*!40101 SET character_set_client = @saved_cs_client */; 51 52 -- 53 -- Table structure for table `server_roles` 54 -- 55 56 DROP TABLE IF EXISTS `server_roles`; 57 /*!40101 SET @saved_cs_client = @@character_set_client */; 58 /*!40101 SET character_set_client = utf8 */; 59 CREATE TABLE `server_roles` ( 60 `id` int(11) NOT NULL auto_increment, 61 `server_id` int(11) DEFAULT NULL, 62 `role` varchar(128) DEFAULT NULL, 63 PRIMARY KEY (`id`), 64 KEY `fk_server_roles_server_idx` (`server_id`), 65 CONSTRAINT `fk_server_roles_server` FOREIGN KEY (`server_id`) REFERENCES `servers` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION 66 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 67 /*!40101 SET character_set_client = @saved_cs_client */; 68 69 -- 70 -- Table structure for table `servers` 71 -- 72 73 DROP TABLE IF EXISTS `servers`; 74 /*!40101 SET @saved_cs_client = @@character_set_client */; 75 /*!40101 SET character_set_client = utf8 */; 76 CREATE TABLE `servers` ( 77 `id` int(11) NOT NULL auto_increment, 78 `hostname` varchar(128) NOT NULL, 79 `cname` varchar(128) DEFAULT NULL, 80 `status` varchar(128) DEFAULT NULL, 81 `date_created` datetime DEFAULT NULL, 82 `date_modified` datetime DEFAULT NULL, 83 `note` text, 84 PRIMARY KEY (`id`), 85 UNIQUE KEY `hostname_UNIQUE` (`hostname`), 86 UNIQUE KEY `cname_UNIQUE` (`cname`) 87 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 88 /*!40101 SET character_set_client = @saved_cs_client */; 89 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; 90 91 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 92 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; 93 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; 94 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 95 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 96 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 97 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 98 99 -- Dump completed on 2014-10-28 12:08:40 100 """ 101 102 DROP_DB_SQL = """\ 103 DROP TABLE IF EXISTS `server_roles`; 104 DROP TABLE IF EXISTS `servers`; 105 """ 106
