wget http://ftp.gnu.org/gnu/gdb/gdb-12.1.tar.gz
tar -zxvf gdb-12.1.tar.gz
sudo zypper install make gcc gcc-c++ gmp-devel    #安装编译工具
./configure
make
sudo make install

#登录SQLServer
sqlcmd -S localhost -U sa -P 'Asdf1234' 

#3DPassport数据库
use master;

#创建passdb数据库
CREATE DATABASE passdb COLLATE SQL_Latin1_General_CP1_CI_AS;

#最大限度减小死锁
ALTER DATABASE passdb SET READ_COMMITTED_SNAPSHOT ON;

#创建登录用户
CREATE LOGIN x3dpass WITH PASSWORD = 'Asdf1234';
CREATE LOGIN x3dpassadmin WITH PASSWORD = 'Asdf1234';

USE passdb;

#数据库中创建用户
CREATE USER x3dpass FOR LOGIN x3dpass WITH DEFAULT_SCHEMA = passdb;
CREATE USER x3dpassadmin FOR LOGIN x3dpassadmin WITH DEFAULT_SCHEMA = passdb;

#创建schema
CREATE SCHEMA passdb AUTHORIZATION x3dpassadmin;

#配置权限
GRANT CREATE TABLE, ALTER, SELECT, INSERT, UPDATE, DELETE ON DATABASE::passdb TO x3dpassadmin;
GRANT SELECT, INSERT, UPDATE, DELETE, ALTER ON SCHEMA::passdb TO x3dpass;

#创建令牌数据库
CREATE DATABASE passtkdb COLLATE SQL_Latin1_General_CP1_CI_AS;
#同上
ALTER DATABASE passtkdb SET READ_COMMITTED_SNAPSHOT ON;

CREATE LOGIN x3dpasstokens WITH PASSWORD = 'Asdf1234';

USE passtkdb;

CREATE USER x3dpasstokens FOR LOGIN x3dpasstokens WITH DEFAULT_SCHEMA = passtkdb;

CREATE SCHEMA passtkdb AUTHORIZATION x3dpasstokens;

GRANT CREATE TABLE, ALTER, SELECT, INSERT, UPDATE, DELETE ON DATABASE::passtkdb TO x3dpasstokens;

#3DDashbord数据库
USE master;

#创建dashdb数据库
CREATE DATABASE dashdb COLLATE SQL_Latin1_General_CP1_CI_AS;

ALTER DATABASE dashdb SET READ_COMMITTED_SNAPSHOT ON;

CREATE LOGIN x3ddash WITH PASSWORD = 'Asdf1234';
CREATE LOGIN x3ddashadmin WITH PASSWORD = 'Asdf1234';
USE dashdb;


CREATE USER x3ddash FOR LOGIN x3ddash WITH DEFAULT_SCHEMA = dashdb;
CREATE USER x3ddashadmin FOR LOGIN x3ddashadmin WITH DEFAULT_SCHEMA = dashdb;

CREATE SCHEMA dashdb AUTHORIZATION x3ddashadmin;

GRANT CREATE TABLE, ALTER, SELECT, INSERT, UPDATE, DELETE ON DATABASE::dashdb TO x3ddashadmin;
GRANT SELECT, INSERT, UPDATE, DELETE, ALTER ON SCHEMA::dashdb TO x3ddash;

 USE master;

CREATE DATABASE spacedb ON PRIMARY (NAME=spacedb, FILENAME='/var/db/spacedb.mdf',SIZE=500MB, FILEGROWTH=10MB) ,FILEGROUP I1_DATA (NAME=I1_DATA , FILENAME='/var/db/I1_DATA.mdf',SIZE=500MB,FILEGROWTH=10MB) ,FILEGROUP I1_INDEX (NAME=I1_INDEX , FILENAME='/var/db/I1_INDEX.mdf',SIZE=500MB,FILEGROWTH=10MB),FILEGROUP M1_DATA (NAME=M1_DATA , FILENAME='/var/db/M1_DATA.mdf',SIZE=500MB,FILEGROWTH=10MB),FILEGROUP M1_INDEX (NAME=M1_INDEX , FILENAME='/var/db/M1_INDEX.mdf',SIZE=500MB,FILEGROWTH=10MB),FILEGROUP V1_DATA (NAME=V1_DATA , FILENAME='/var/db/V1_DATA.mdf',SIZE=500MB,FILEGROWTH=10MB),FILEGROUP V1_INDEX (NAME=V1_INDEX , FILENAME='/var/db/V1_INDEX.mdf',SIZE=500MB,FILEGROWTH=10MB) LOG ON (NAME=spacedb_log ,FILENAME='/var/db/spacedb.ldf',SIZE=100MB) COLLATE SQL_Latin1_General_CP1_CS_AS;


ALTER DATABASE spacedb SET AUTO_CLOSE OFF ; 
ALTER DATABASE spacedb SET READ_COMMITTED_SNAPSHOT ON; 
ALTER DATABASE spacedb SET AUTO_CREATE_STATISTICS ON; 
ALTER DATABASE spacedb SET AUTO_UPDATE_STATISTICS ON; 
ALTER DATABASE spacedb SET AUTO_UPDATE_STATISTICS_ASYNC ON;

CREATE LOGIN m1 WITH PASSWORD = 'Asdf1234';
USE spacedb;
-- Create user on correct DATABASE (after use) and with correct schema
CREATE USER m1 FOR LOGIN m1 WITH DEFAULT_SCHEMA = spacedb;
-- Create schema
CREATE SCHEMA spacedb AUTHORIZATION m1;
-- Grant access
GRANT CREATE TABLE, ALTER, SELECT, INSERT, UPDATE, DELETE ON DATABASE::spacedb TO m1;