restore.sql
1.6 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
-- TODO: Padronizar datafiles da base de dados em SQL Server
RESTORE DATABASE [sei] FROM DISK = N'/tmp/sei_sqlserver.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5,
MOVE 'gedoc' TO '/var/opt/mssql/data/sei_data.mdf',
MOVE 'SEI_data3' TO '/var/opt/mssql/data/sei_data1.ndf',
MOVE 'SEI_data4' TO '/var/opt/mssql/data/sei_data2.ndf',
MOVE 'SEI_log2' TO '/var/opt/mssql/data/sei_data3.ndf',
MOVE 'Sei_Log3' TO '/var/opt/mssql/data/sei_data4.ndf',
MOVE 'gedoc_log' TO '/var/opt/mssql/data/sei_1og.ldf'
GO
-- TODO: Padronizar datafiles da base de dados em SQL Server
RESTORE DATABASE [sip] FROM DISK = N'/tmp/sip_sqlserver.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5,
MOVE 'sip_Data' TO '/var/opt/mssql/data/sip_data.mdf',
MOVE 'sip_Log' TO '/var/opt/mssql/data/sip_log.ldf'
GO
USE sei;
GO
CREATE LOGIN sei_user
WITH PASSWORD = 'sei_user', CHECK_POLICY=OFF;
GO
CREATE USER sei_user FOR LOGIN sei_user;
GO
EXEC sp_addrolemember 'db_owner', 'sei_user'
GO
update orgao set sigla='ABC', descricao='ORGAO ABC' where id_orgao=0;
GO
delete from auditoria_protocolo;
GO
USE sip;
GO
CREATE LOGIN sip_user
WITH PASSWORD = 'sip_user', CHECK_POLICY=OFF;
GO
CREATE USER sip_user FOR LOGIN sip_user;
GO
EXEC sp_addrolemember 'db_owner', 'sip_user'
GO
update orgao set sigla='ABC', descricao='ORGAO ABC' where id_orgao=0;
GO
update sistema set pagina_inicial='http://localhost/sip' where sigla='SIP';
GO
update sistema set pagina_inicial='http://localhost/sei/inicializar.php', web_service='http://localhost/sei/controlador_ws.php?servico=sip' where sigla='SEI';
GO
update orgao set sin_autenticar='N' where id_orgao=0;
GO