{"action":"opened","issue":{"url":"https://api.github.com/repos/fblupi/grado_informatica-DIU/issues/7","labels_url":"https://api.github.com/repos/fblupi/grado_informatica-DIU/issues/7/labels{/name}","comments_url":"https://api.github.com/repos/fblupi/grado_informatica-DIU/issues/7/comments","events_url":"https://api.github.com/repos/fblupi/grado_informatica-DIU/issues/7/events","html_url":"https://github.com/fblupi/grado_informatica-DIU/issues/7","id":120566965,"number":7,"title":"Cambiar BD 2","user":{"login":"louri91","id":9786318,"avatar_url":"https://avatars.githubusercontent.com/u/9786318?v=3","gravatar_id":"","url":"https://api.github.com/users/louri91","html_url":"https://github.com/louri91","followers_url":"https://api.github.com/users/louri91/followers","following_url":"https://api.github.com/users/louri91/following{/other_user}","gists_url":"https://api.github.com/users/louri91/gists{/gist_id}","starred_url":"https://api.github.com/users/louri91/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/louri91/subscriptions","organizations_url":"https://api.github.com/users/louri91/orgs","repos_url":"https://api.github.com/users/louri91/repos","events_url":"https://api.github.com/users/louri91/events{/privacy}","received_events_url":"https://api.github.com/users/louri91/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-12-05T15:51:35Z","updated_at":"2015-12-05T15:51:35Z","closed_at":null,"body":"Script de inserción de las contraseñas encriptadas (ojo que la de admin tenía que ser de 6 y la he cambiado por \"admin2\")\r\n```sql \r\nUPDATE `Usuario` SET pass = 'c84258e9c39059a89ab77d846ddab909',\r\nnombre = 'Usuario Administrador', \r\ntelefono = '655555555', \r\nsexo = 'Hombre', \r\npais = 'España', \r\nlocalidad = 'Granada', \r\ndireccion = 'Calle Falsa', \r\ncodigoPostal = '18001' \r\nWHERE id = 1;\r\nUPDATE `Usuario` SET pass = 'f8032d5cae3de20fcec887f395ec9a6a', \r\nnombre = 'Usuario normal', \r\ntelefono = '677777777',\r\nsexo = 'Hombre', \r\npais = 'España', \r\nlocalidad = 'Granada', \r\ndireccion = 'Calle Falsa', \r\ncodigoPostal = '18001' \r\nWHERE id = 2;\r\n```\r\n\r\nScript que añade la modificación para que los eventos tengan fecha de inicio y fecha de fin obligatorios y las empresas cuando reservan sala también\r\n\r\n```sql\r\nALTER TABLE `diu`.`Evento` \r\nCHANGE COLUMN `fecha` `fechaInicio` DATETIME NOT NULL ,\r\nADD COLUMN `fechaFin` DATETIME NOT NULL AFTER `fechaInicio`;\r\nALTER TABLE `diu`.`Empresa` \r\nADD COLUMN `fechaInicio` DATETIME NULL AFTER `sala`,\r\nADD COLUMN `fechaFin` DATETIME NULL AFTER `fechaInicio`;\r\n```"}}