Eu estou com um problema na hora de executar o banco de dados que eu tenho aqui de Suporte Online.
Quando executo ele original do jeito que veio no arquivo ele demostra uma mensagem de erro e não consigo resolver este problema, por isso vim aqui pedir alguma ajuda se possivel e claro, me auxiliar neste problema.
Código do Erro
consulta SQL:
/* helpdesk.sql ** ** This is the SQL schema file for Liberum Helpdesk. ** It was created using SQL Server 2000 but should work fine under ** 6.5 or newer. ** ** Before using, change the FILENAME locations in the CREATE DATABASE ** statement to match your SQL server settings. ** ** $Revision: 1.6 $ ** $Date: 2001/09/17 15:22:11 $ */
USE MASTER GO CREATE DATABASE HelpDesk ON (
NAME = HelpDesk,
FILENAME = 'c:\mssql\data\helpdesk.mdf',
SIZE =5,
FILEGROWTH =5
)LOG ON (
NAME = 'HelpDesk_log',
FILENAME = 'c:\mssql\data\helpdesk_log.ldf',
SIZE = 5MB,
FILEGROWTH = 5MB
)GO USE HelpDeskGO CREATE TABLE [dbo].[categories](
[category_id][int] NOT NULL ,
[cname][varchar]( 50 ) NULL ,
[rep_id][int] NULL
) ON [ PRIMARY ]GO CREATE TABLE [dbo].[db_keys](
[problems][int] NULL ,
[departments][int] NULL ,
[categories][int] NULL ,
[users][int] NULL
) ON [ PRIMARY ]GO CREATE TABLE [dbo].[departments](
[department_id][int] NOT NULL ,
[dname][varchar]( 50 ) NULL
) ON [ PRIMARY ]GO CREATE TABLE [dbo].[priority](
[priority_id][int] NOT NULL ,
[pname][varchar]( 50 ) NULL
) ON [ PRIMARY ]GO CREATE TABLE [dbo].[problems](
[id][int] NOT NULL ,
[uid][varchar]( 50 ) NULL ,
[uemail][varchar]( 50 ) NULL ,
[ulocation][varchar]( 50 ) NULL ,
[uphone][varchar]( 50 ) NULL ,
[rep][int] NULL ,
[ STATUS ][int] NULL ,
[time_spent][int] NULL ,
[category][int] NULL ,
[priority][int] NULL ,
[department][int] NULL ,
[title][varchar]( 50 ) NULL ,
[description][text] NULL ,
[solution][text] NULL ,
[start_date][datetime] NULL ,
[close_date][datetime] NULL
) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [dbo].[ STATUS ](
[status_id][int] NOT NULL ,
[sname][varchar]( 50 ) NULL
) ON [ PRIMARY ]GO CREATE TABLE [dbo].[tblConfig](
[SiteName][varchar]( 50 ) NULL ,
[BaseURL][varchar]( 50 ) NULL ,
[AdminPass][varchar]( 50 ) NULL ,
[EmailType][int] NULL ,
[SMTPServer][varchar]( 50 ) NULL ,
[HDName][varchar]( 50 ) NULL ,
[HDReply][varchar]( 50 ) NULL ,
[BaseEmail][varchar]( 50 ) NULL ,
[EnablePager][int] NULL ,
[NotifyUser][int] NULL ,
[EnableKB][int] NULL ,
[DefaultPriority][int] NULL ,
[DefaultStatus][int] NULL ,
[CloseStatus][int] NULL ,
[AuthType][int] NULL ,
[Color1][varchar]( 15 ) NULL ,
[Color2][varchar]( 15 ) NULL ,
[BGColor][varchar]( 15 ) NULL ,
[TextColor][varchar]( 15 ) NULL ,
[LinkColor][varchar]( 15 ) NULL ,
[VLinkcolor][varchar]( 15 ) NULL ,
[ALinkColor][varchar]( 15 ) NULL ,
[Version][varchar]( 6 ) NULL
) ON [ PRIMARY ]GO CREATE TABLE [dbo].[tblConfig_Auth](
[ID][int] NOT NULL ,
[ TYPE ][varchar]( 50 ) NULL
) ON [ PRIMARY ]GO CREATE TABLE [dbo].[tblConfig_Email](
[ID][int] NOT NULL ,
[ TYPE ][varchar]( 50 ) NULL
) ON [ PRIMARY ]GO CREATE TABLE [dbo].[tblEmailMsg](
[ TYPE ][varchar]( 50 ) NOT NULL ,
[subject][varchar]( 50 ) NULL ,
[body][text] NULL
) ON [ PRIMARY ]TEXTIMAGE_ON[ PRIMARY ]GO CREATE TABLE [dbo].[tblUsers](
[sid][int] NOT NULL ,
[uid][varchar]( 50 ) NULL ,
[ PASSWORD ][varchar]( 50 ) NULL ,
[fname][varchar]( 50 ) NULL ,
[email1][varchar]( 50 ) NULL ,
[email2][varchar]( 50 ) NULL ,
[phone][varchar]( 50 ) NULL ,
[location1][varchar]( 50 ) NULL ,
[location2][varchar]( 50 ) NULL ,
[department][int] NULL ,
[IsRep][int] NULL ,
[dtCreated][datetime] NULL ,
[dtLastAccess][datetime] NULL
) ON [ PRIMARY ]GO ALTER TABLE [dbo].[categories] WITH NOCHECK ADD PRIMARY KEY CLUSTERED(
[category_id]
) ON [ PRIMARY ]GO ALTER TABLE [dbo].[departments] WITH NOCHECK ADD PRIMARY KEY CLUSTERED(
[department_id]
) ON [ PRIMARY ]GO ALTER TABLE [dbo].[priority] WITH NOCHECK ADD PRIMARY KEY CLUSTERED(
[priority_id]
) ON [ PRIMARY ]GO ALTER TABLE [dbo].[problems] WITH NOCHECK ADD PRIMARY KEY CLUSTERED(
[id]
) ON [ PRIMARY ]GO ALTER TABLE [dbo].[ STATUS ] WITH NOCHECK ADD PRIMARY KEY CLUSTERED(
[status_id]
) ON [ PRIMARY ]GO ALTER TABLE [dbo].[tblConfig_Auth] WITH NOCHECK ADD PRIMARY KEY CLUSTERED(
[ID]
) ON [ PRIMARY ]GO ALTER TABLE [dbo].[tblConfig_Email] WITH NOCHECK ADD PRIMARY KEY CLUSTERED(
[ID]
) ON [ PRIMARY ]GO ALTER TABLE [dbo].[tblEmailMsg] WITH NOCHECK ADD PRIMARY KEY CLUSTERED(
[ TYPE ]
) ON [ PRIMARY ]GO ALTER TABLE [dbo].[tblUsers] WITH NOCHECK ADD PRIMARY KEY CLUSTERED(
[sid]
) ON [ PRIMARY ]GO ALTER TABLE [dbo].[tblUsers] WITH NOCHECK ADD CONSTRAINT [DF_tblUsers_department]DEFAULT( 0 ) FOR [department],
CONSTRAINT [DF_tblUsers_IsRep]DEFAULT( 0 ) FOR [IsRep],
CONSTRAINT [DF_tblUsers_dtCreated]DEFAULT(
getdate(
)
) FOR [dtCreated],
CONSTRAINT [DF_tblUsers_dtLastAccess]DEFAULT(
getdate(
)
) FOR [dtLastAccess]GO INSERT INTO tblconfig(
SiteName,
BaseURL,
AdminPass,
EmailType,
SMTPServer,
HDName,
HDReply,
BaseEmail,
EnablePager,
NotifyUser,
EnableKB,
DefaultPriority,
DefaultStatus,
CloseStatus,
AuthType,
Color1,
Color2,
BGColor,
TextColor,
LinkColor,
VLinkColor,
ALinkColor
)
VALUES (
'Company Name', 'http://www.company.com/helpdesk', 'admin', 1, 'smtp.company.com', 'Consultant', 'helpdesk@company.com', '@company.com', 0, 0, 1, 1, 1, 100, 2, '#6080B0', '#EEEEEE', '#FFFFFF', '#000000', '#6080B0', '#7090C0', '#7090C0'
)GO
INSERT INTO tblConfig_Auth( ID,
TYPE )
VALUES ( 1, 'NT Authentication' )
INSERT INTO tblConfig_Auth( ID,
TYPE )
VALUES ( 2, 'Database' )
INSERT INTO tblConfig_Auth( ID,
TYPE )
VALUES ( 3, 'External Authentication' ) GO
INSERT INTO tblConfig_Email( ID,
TYPE )
VALUES ( 0, 'Disabled' )
INSERT INTO tblConfig_Email( ID,
TYPE )
VALUES ( 1, 'CDONTS' )
INSERT INTO tblConfig_Email( ID,
TYPE )
VALUES ( 2, 'JMail' )
INSERT INTO tblConfig_Email( ID,
TYPE )
VALUES ( 3, 'ASPEmail' ) GO
INSERT INTO tblEmailMsg(
TYPE , subject, body )
VALUES (
'repclose', 'HELPDESK: Problem [problemid] Closed', 'The following problem has been closed. You can view the problem at [rurl]' + CHAR( 13 ) + CHAR( 13 ) + 'PROBLEM DETAILS' + CHAR( 13 ) + '---------------' + CHAR( 13 ) + 'ID: [problemid]' + CHAR( 13 ) + 'User: [uid]' + CHAR( 13 ) + 'Date: [startdate]' + CHAR( 13 ) + 'Title: [title]' + CHAR( 13 ) + 'Priority: [priority]' + CHAR( 13 ) + 'Category: [category]' + CHAR( 13 ) + CHAR( 13 ) + 'SOLUTION' + CHAR( 13 ) + '--------' + CHAR( 13 ) + '[solution]'
)
INSERT INTO tblEmailMsg(
TYPE , subject, body )
VALUES (
'repnew', 'HELPDESK: Problem [problemid] Assigned', 'The following problem has been assigned to you. You can update the problem at [rurl]' + CHAR( 13 ) + CHAR( 13 ) + 'PROBLEM DETAILS' + CHAR( 13 ) + '---------------' + CHAR( 13 ) + 'ID: [problemid]' + CHAR( 13 ) + 'Date: [startdate]' + CHAR( 13 ) + 'Title: [title]' + CHAR( 13 ) + 'Priority: [priority]' + CHAR( 13 ) + 'Category: [category]' + CHAR( 13 ) + CHAR( 13 ) + 'USER INFORMATION' + CHAR( 13 ) + '----------------' + CHAR( 13 ) + 'Username: [uid]' + CHAR( 13 ) + 'Email: [uemail]' + CHAR( 13 ) + 'Phone: [phone]' + CHAR( 13 ) + 'Location: [location]' + CHAR( 13 ) + 'Department: [department]' + CHAR( 13 ) + CHAR( 13 ) + 'DESCRIPTION' + CHAR( 13 ) + '-----------' + CHAR( 13 ) + '[description]'
)
INSERT INTO tblEmailMsg(
TYPE , subject, body )
VALUES (
'reppager', 'HELPDESK: Problem [problemid] Assigned', 'Title: [title]' + CHAR( 13 ) + 'Priority: [priority]' + CHAR( 13 ) + 'User: [uid]'
)
INSERT INTO tblEmailMsg(
TYPE , subject, body )
VALUES (
'repupdate', 'HELPDESK: Problem [problemid] Updated', 'The following problem has been updated. You can view the problem at [rurl]' + CHAR( 13 ) + CHAR( 13 ) + 'PROBLEM DETAILS' + CHAR( 13 ) + '---------------' + CHAR( 13 ) + 'ID: [problemid]' + CHAR( 13 ) + 'User: [uid]' + CHAR( 13 ) + 'Date: [startdate]' + CHAR( 13 ) + 'Title: [title]' + CHAR( 13 ) + 'Priority: [priority]' + CHAR( 13 ) + 'Category: [category]' + CHAR( 13 ) + CHAR( 13 ) + 'DESCRIPTION' + CHAR( 13 ) + '-----------' + CHAR( 13 ) + '[description]'
)
INSERT INTO tblEmailMsg(
TYPE , subject, body )
VALUES (
'userclose', 'HELPDESK: Problem [problemid] Closed', 'Your help desk problem has been closed. You can view the solution below or at: [uurl]' + CHAR( 13 ) + CHAR( 13 ) + 'PROBLEM DETAILS' + CHAR( 13 ) + '---------------' + CHAR( 13 ) + 'ID: [problemid]' + CHAR( 13 ) + 'User: [uid]' + CHAR( 13 ) + 'Date: [startdate]' + CHAR( 13 ) + 'Title: [title]' + CHAR( 13 ) + CHAR( 13 ) + 'SOLUTION' + CHAR( 13 ) + '--------' + CHAR( 13 ) + '[solution]'
)
INSERT INTO tblEmailMsg(
TYPE , subject, body )
VALUES (
'usernew', 'HELPDESK: Problem [problemid] Created', 'Thank you for submitting your problem to the help desk. You can view or update the problem at: [uurl]' + CHAR( 13 ) + CHAR( 13 ) + 'PROBLEM DETAILS' + CHAR( 13 ) + '---------------' + CHAR( 13 ) + 'ID: [problemid]' + CHAR( 13 ) + 'User: [uid]' + CHAR( 13 ) + 'Date: [startdate]' + CHAR( 13 ) + 'Title: [title]' + CHAR( 13 ) + CHAR( 13 ) + 'DESCRIPTION' + CHAR( 13 ) + '-----------' + CHAR( 13 ) + '[description]'
)
INSERT INTO tblEmailMsg(
TYPE , subject, body )
VALUES (
'userupdate', 'HELPDESK: Problem [problemid] Updated', 'Your help desk problem has been updated. You can view the problem at: [uurl]' + CHAR( 13 ) + CHAR( 13 ) + 'PROBLEM DETAILS' + CHAR( 13 ) + '---------------' + CHAR( 13 ) + 'ID: [problemid]' + CHAR( 13 ) + 'User: [uid]' + CHAR( 13 ) + 'Date: [startdate]' + CHAR( 13 ) + 'Title: [title]' + CHAR( 13 ) + CHAR( 13 ) + 'DESCRIPTION' + CHAR( 13 ) + '-----------' + CHAR( 13 ) + '[description]'
)GO
INSERT INTO tblUsers( sid, uid, fname, email1 )
VALUES ( 0, 'unknown', 'Unknown', 'none@localhost' ) GO
INSERT INTO db_keys( problems, departments, categories, users )
VALUES ( 1, 2, 1, 1 ) GO
INSERT INTO STATUS ( status_id, sname )
VALUES ( 0, 'UNKNOWN' )
INSERT INTO STATUS ( status_id, sname )
VALUES ( 1, 'OPEN' )
INSERT INTO STATUS ( status_id, sname )
VALUES ( 100, 'CLOSED' ) GO
INSERT INTO priority( priority_id, pname )
VALUES ( 0, 'UNKNOWN' )
INSERT INTO priority( priority_id, pname )
VALUES ( 1, 'LOW' )
INSERT INTO priority( priority_id, pname )
VALUES ( 2, 'HIGH' ) GO
INSERT INTO departments( department_id, dname )
VALUES ( 0, 'UNKNOWN' )
INSERT INTO departments( department_id, dname )
VALUES ( 1, 'Dept1' ) GO
Mensagens do MySQL : Documentação
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GO
CREATE DATABASE HelpDesk
ON
(
NAME = HelpDesk,
Aqui está o Código Original do Arquivo.
/* helpdesk.sql
**
** This is the SQL schema file for Liberum Helpdesk.
** It was created using SQL Server 2000 but should work fine under
** 6.5 or newer.
**
** Before using, change the FILENAME locations in the CREATE DATABASE
** statement to match your SQL server settings.
**
** $Revision: 1.6 $
** $Date: 2001/09/17 15:22:11 $
*/
USE master
GO
CREATE DATABASE HelpDesk
ON
(
NAME = HelpDesk,
FILENAME = 'c:\mssql\data\helpdesk.mdf',
SIZE = 5,
FILEGROWTH = 5
)
LOG ON
(
NAME = 'HelpDesk_log',
FILENAME = 'c:\mssql\data\helpdesk_log.ldf',
SIZE = 5MB,
FILEGROWTH = 5MB
)
GO
USE HelpDesk
GO
CREATE TABLE [dbo].[categories]
(
[category_id] [int] NOT NULL ,
[cname] [varchar] (50) NULL ,
[rep_id] [int] NULL
)
ON [PRIMARY]
GO
CREATE TABLE [dbo].[db_keys]
(
[problems] [int] NULL ,
[departments] [int] NULL ,
[categories] [int] NULL ,
[users] [int] NULL
)
ON [PRIMARY]
GO
CREATE TABLE [dbo].[departments]
(
[department_id] [int] NOT NULL ,
[dname] [varchar] (50) NULL
)
ON [PRIMARY]
GO
CREATE TABLE [dbo].[priority]
(
[priority_id] [int] NOT NULL ,
[pname] [varchar] (50) NULL
)
ON [PRIMARY]
GO
CREATE TABLE [dbo].[problems]
(
[id] [int] NOT NULL ,
[uid] [varchar] (50) NULL ,
[uemail] [varchar] (50) NULL ,
[ulocation] [varchar] (50) NULL ,
[uphone] [varchar] (50) NULL ,
[rep] [int] NULL ,
[status] [int] NULL ,
[time_spent] [int] NULL ,
[category] [int] NULL ,
[priority] [int] NULL ,
[department] [int] NULL ,
[title] [varchar] (50) NULL ,
[description] [text] NULL ,
[solution] [text] NULL ,
[start_date] [datetime] NULL ,
[close_date] [datetime] NULL
)
ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[status]
(
[status_id] [int] NOT NULL ,
[sname] [varchar] (50) NULL
)
ON [PRIMARY]
GO
CREATE TABLE [dbo].[tblConfig]
(
[SiteName] [varchar] (50) NULL ,
[BaseURL] [varchar] (50) NULL ,
[AdminPass] [varchar] (50) NULL ,
[EmailType] [int] NULL ,
[SMTPServer] [varchar] (50) NULL ,
[HDName] [varchar] (50) NULL ,
[HDReply] [varchar] (50) NULL ,
[BaseEmail] [varchar] (50) NULL ,
[EnablePager] [int] NULL ,
[NotifyUser] [int] NULL ,
[EnableKB] [int] NULL ,
[DefaultPriority] [int] NULL ,
[DefaultStatus] [int] NULL ,
[CloseStatus] [int] NULL ,
[AuthType] [int] NULL ,
[Color1] [varchar] (15) NULL ,
[Color2] [varchar] (15) NULL ,
[BGColor] [varchar] (15) NULL ,
[TextColor] [varchar] (15) NULL ,
[LinkColor] [varchar] (15) NULL ,
[VLinkcolor] [varchar] (15) NULL ,
[ALinkColor] [varchar] (15) NULL ,
[Version] [varchar] (6) NULL
)
ON [PRIMARY]
GO
CREATE TABLE [dbo].[tblConfig_Auth]
(
[ID] [int] NOT NULL ,
[Type] [varchar] (50) NULL
)
ON [PRIMARY]
GO
CREATE TABLE [dbo].[tblConfig_Email]
(
[ID] [int] NOT NULL ,
[Type] [varchar] (50) NULL
)
ON [PRIMARY]
GO
CREATE TABLE [dbo].[tblEmailMsg]
(
[type] [varchar] (50) NOT NULL ,
[subject] [varchar] (50) NULL ,
[body] [text] NULL
)
ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[tblUsers]
(
[sid] [int] NOT NULL ,
[uid] [varchar] (50) NULL ,
[password] [varchar] (50) NULL ,
[fname] [varchar] (50) NULL ,
[email1] [varchar] (50) NULL ,
[email2] [varchar] (50) NULL ,
[phone] [varchar] (50) NULL ,
[location1] [varchar] (50) NULL ,
[location2] [varchar] (50) NULL ,
[department] [int] NULL ,
[IsRep] [int] NULL ,
[dtCreated] [datetime] NULL ,
[dtLastAccess] [datetime] NULL
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[categories] WITH NOCHECK ADD
PRIMARY key CLUSTERED
(
[category_id]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[departments] WITH NOCHECK ADD
PRIMARY key CLUSTERED
(
[department_id]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[priority] WITH NOCHECK ADD
PRIMARY key CLUSTERED
(
[priority_id]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[problems] WITH NOCHECK ADD
PRIMARY key CLUSTERED
(
[id]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[status] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[status_id]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[tblConfig_Auth] WITH NOCHECK ADD
PRIMARY key CLUSTERED
(
[ID]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[tblConfig_Email] WITH NOCHECK ADD
PRIMARY key CLUSTERED
(
[ID]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[tblEmailMsg] WITH NOCHECK ADD
PRIMARY key CLUSTERED
(
[type]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[tblUsers] WITH NOCHECK ADD
PRIMARY key CLUSTERED
(
[sid]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[tblUsers] WITH NOCHECK ADD
CONSTRAINT [DF_tblUsers_department] DEFAULT (0) FOR [department],
CONSTRAINT [DF_tblUsers_IsRep] DEFAULT (0) FOR [IsRep],
CONSTRAINT [DF_tblUsers_dtCreated] DEFAULT (getdate()) FOR [dtCreated],
CONSTRAINT [DF_tblUsers_dtLastAccess] DEFAULT (getdate()) FOR [dtLastAccess]
GO
INSERT INTO tblconfig
(
SiteName, BaseURL, AdminPass, EmailType, SMTPServer, HDName, HDReply,
BaseEmail, EnablePager, NotifyUser, EnableKB, DefaultPriority, DefaultStatus, CloseStatus, AuthType,
Color1, Color2, BGColor, TextColor, LinkColor, VLinkColor, ALinkColor
)
VALUES
(
'Company Name', 'http://www.company.com/helpdesk', 'admin', 1, 'smtp.company.com',
'Consultant', 'helpdesk@company.com', '@company.com', 0, 0, 1, 1, 1, 100, 2,
'#6080B0', '#EEEEEE', '#FFFFFF', '#000000', '#6080B0', '#7090C0', '#7090C0'
)
GO
INSERT INTO tblConfig_Auth (ID, Type)
VALUES (1, 'NT Authentication')
INSERT INTO tblConfig_Auth (ID, Type)
VALUES (2, 'Database')
INSERT INTO tblConfig_Auth (ID, Type)
VALUES (3, 'External Authentication')
GO
INSERT INTO tblConfig_Email (ID, Type)
VALUES (0, 'Disabled')
INSERT INTO tblConfig_Email (ID, Type)
VALUES (1, 'CDONTS')
INSERT INTO tblConfig_Email (ID, Type)
VALUES (2, 'JMail')
INSERT INTO tblConfig_Email (ID, Type)
VALUES (3, 'ASPEmail')
GO
INSERT INTO tblEmailMsg(type, subject, body)
VALUES
(
'repclose', 'HELPDESK: Problem [problemid] Closed',
'The following problem has been closed. You can view the problem at [rurl]' + CHAR(13) + CHAR(13) +
'PROBLEM DETAILS' + CHAR(13) +
'---------------' + CHAR(13) +
'ID: [problemid]' + CHAR(13) +
'User: [uid]' + CHAR(13) +
'Date: [startdate]' + CHAR(13) +
'Title: [title]' + CHAR(13) +
'Priority: [priority]' + CHAR(13) +
'Category: [category]' + CHAR(13) + CHAR(13) +
'SOLUTION' + CHAR(13) +
'--------' + CHAR(13) +
'[solution]'
)
INSERT INTO tblEmailMsg(type, subject, body)
VALUES
(
'repnew', 'HELPDESK: Problem [problemid] Assigned',
'The following problem has been assigned to you. You can update the problem at [rurl]' + CHAR(13) + CHAR(13) +
'PROBLEM DETAILS' + CHAR(13) +
'---------------' + CHAR(13) +
'ID: [problemid]' + CHAR(13) +
'Date: [startdate]' + CHAR(13) +
'Title: [title]' + CHAR(13) +
'Priority: [priority]' + CHAR(13) +
'Category: [category]' + CHAR(13) + CHAR(13) +
'USER INFORMATION' + CHAR(13) +
'----------------' + CHAR(13) +
'Username: [uid]' + CHAR(13) +
'Email: [uemail]' + CHAR(13) +
'Phone: [phone]' + CHAR(13) +
'Location: [location]' + CHAR(13) +
'Department: [department]' + CHAR(13) + CHAR(13) +
'DESCRIPTION' + CHAR(13) +
'-----------' + CHAR(13) +
'[description]'
)
INSERT INTO tblEmailMsg(type, subject, body)
VALUES
(
'reppager', 'HELPDESK: Problem [problemid] Assigned',
'Title: [title]' + CHAR(13) +
'Priority: [priority]' + CHAR(13) +
'User: [uid]'
)
INSERT INTO tblEmailMsg(type, subject, body)
VALUES
(
'repupdate', 'HELPDESK: Problem [problemid] Updated',
'The following problem has been updated. You can view the problem at [rurl]' + CHAR(13) + CHAR(13) +
'PROBLEM DETAILS' + CHAR(13) +
'---------------' + CHAR(13) +
'ID: [problemid]' + CHAR(13) +
'User: [uid]' + CHAR(13) +
'Date: [startdate]' + CHAR(13) +
'Title: [title]' + CHAR(13) +
'Priority: [priority]' + CHAR(13) +
'Category: [category]' + CHAR(13) + CHAR(13) +
'DESCRIPTION' + CHAR(13) +
'-----------' + CHAR(13) +
'[description]'
)
INSERT INTO tblEmailMsg(type, subject, body)
VALUES
(
'userclose', 'HELPDESK: Problem [problemid] Closed',
'Your help desk problem has been closed. You can view the solution below or at: [uurl]' + CHAR(13) + CHAR(13) +
'PROBLEM DETAILS' + CHAR(13) +
'---------------' + CHAR(13) +
'ID: [problemid]' + CHAR(13) +
'User: [uid]' + CHAR(13) +
'Date: [startdate]' + CHAR(13) +
'Title: [title]' + CHAR(13) + CHAR(13) +
'SOLUTION' + CHAR(13) +
'--------' + CHAR(13) +
'[solution]'
)
INSERT INTO tblEmailMsg(type, subject, body)
VALUES ('usernew', 'HELPDESK: Problem [problemid] Created',
'Thank you for submitting your problem to the help desk. You can view or update the problem at: [uurl]' + CHAR(13) + CHAR(13) +
'PROBLEM DETAILS' + CHAR(13) +
'---------------' + CHAR(13) +
'ID: [problemid]' + CHAR(13) +
'User: [uid]' + CHAR(13) +
'Date: [startdate]' + CHAR(13) +
'Title: [title]' + CHAR(13) + CHAR(13) +
'DESCRIPTION' + CHAR(13) +
'-----------' + CHAR(13) +
'[description]'
)
INSERT INTO tblEmailMsg(type, subject, body)
VALUES ('userupdate', 'HELPDESK: Problem [problemid] Updated',
'Your help desk problem has been updated. You can view the problem at: [uurl]' + CHAR(13) + CHAR(13) +
'PROBLEM DETAILS' + CHAR(13) +
'---------------' + CHAR(13) +
'ID: [problemid]' + CHAR(13) +
'User: [uid]' + CHAR(13) +
'Date: [startdate]' + CHAR(13) +
'Title: [title]' + CHAR(13) + CHAR(13) +
'DESCRIPTION' + CHAR(13) +
'-----------' + CHAR(13) +
'[description]'
)
GO
INSERT INTO tblUsers(sid, uid, fname, email1)
VALUES (0, 'unknown', 'Unknown', 'none@localhost')
GO
INSERT INTO db_keys(problems, departments, categories, users)
VALUES (1,2,1,1)
GO
INSERT INTO status(status_id, sname)
VALUES (0,'UNKNOWN')
INSERT INTO status(status_id, sname)
VALUES (1,'OPEN')
INSERT INTO status(status_id, sname)
VALUES (100,'CLOSED')
GO
INSERT INTO priority(priority_id, pname)
VALUES (0,'UNKNOWN')
INSERT INTO priority(priority_id, pname)
VALUES (1,'LOW')
INSERT INTO priority(priority_id, pname)
VALUES (2,'HIGH')
GO
INSERT INTO departments(department_id, dname)
VALUES (0,'UNKNOWN')
INSERT INTO departments(department_id, dname)
VALUES (1,'Dept1')
GO
Pergunta
drodrigo
Boa noite galera.
Eu estou com um problema na hora de executar o banco de dados que eu tenho aqui de Suporte Online.
Quando executo ele original do jeito que veio no arquivo ele demostra uma mensagem de erro e não consigo resolver este problema, por isso vim aqui pedir alguma ajuda se possivel e claro, me auxiliar neste problema.
Código do Erro
Aqui está o Código Original do Arquivo./* helpdesk.sql ** ** This is the SQL schema file for Liberum Helpdesk. ** It was created using SQL Server 2000 but should work fine under ** 6.5 or newer. ** ** Before using, change the FILENAME locations in the CREATE DATABASE ** statement to match your SQL server settings. ** ** $Revision: 1.6 $ ** $Date: 2001/09/17 15:22:11 $ */ USE master GO CREATE DATABASE HelpDesk ON ( NAME = HelpDesk, FILENAME = 'c:\mssql\data\helpdesk.mdf', SIZE = 5, FILEGROWTH = 5 ) LOG ON ( NAME = 'HelpDesk_log', FILENAME = 'c:\mssql\data\helpdesk_log.ldf', SIZE = 5MB, FILEGROWTH = 5MB ) GO USE HelpDesk GO CREATE TABLE [dbo].[categories] ( [category_id] [int] NOT NULL , [cname] [varchar] (50) NULL , [rep_id] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[db_keys] ( [problems] [int] NULL , [departments] [int] NULL , [categories] [int] NULL , [users] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[departments] ( [department_id] [int] NOT NULL , [dname] [varchar] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[priority] ( [priority_id] [int] NOT NULL , [pname] [varchar] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[problems] ( [id] [int] NOT NULL , [uid] [varchar] (50) NULL , [uemail] [varchar] (50) NULL , [ulocation] [varchar] (50) NULL , [uphone] [varchar] (50) NULL , [rep] [int] NULL , [status] [int] NULL , [time_spent] [int] NULL , [category] [int] NULL , [priority] [int] NULL , [department] [int] NULL , [title] [varchar] (50) NULL , [description] [text] NULL , [solution] [text] NULL , [start_date] [datetime] NULL , [close_date] [datetime] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[status] ( [status_id] [int] NOT NULL , [sname] [varchar] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[tblConfig] ( [SiteName] [varchar] (50) NULL , [BaseURL] [varchar] (50) NULL , [AdminPass] [varchar] (50) NULL , [EmailType] [int] NULL , [SMTPServer] [varchar] (50) NULL , [HDName] [varchar] (50) NULL , [HDReply] [varchar] (50) NULL , [BaseEmail] [varchar] (50) NULL , [EnablePager] [int] NULL , [NotifyUser] [int] NULL , [EnableKB] [int] NULL , [DefaultPriority] [int] NULL , [DefaultStatus] [int] NULL , [CloseStatus] [int] NULL , [AuthType] [int] NULL , [Color1] [varchar] (15) NULL , [Color2] [varchar] (15) NULL , [BGColor] [varchar] (15) NULL , [TextColor] [varchar] (15) NULL , [LinkColor] [varchar] (15) NULL , [VLinkcolor] [varchar] (15) NULL , [ALinkColor] [varchar] (15) NULL , [Version] [varchar] (6) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[tblConfig_Auth] ( [ID] [int] NOT NULL , [Type] [varchar] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[tblConfig_Email] ( [ID] [int] NOT NULL , [Type] [varchar] (50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[tblEmailMsg] ( [type] [varchar] (50) NOT NULL , [subject] [varchar] (50) NULL , [body] [text] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[tblUsers] ( [sid] [int] NOT NULL , [uid] [varchar] (50) NULL , [password] [varchar] (50) NULL , [fname] [varchar] (50) NULL , [email1] [varchar] (50) NULL , [email2] [varchar] (50) NULL , [phone] [varchar] (50) NULL , [location1] [varchar] (50) NULL , [location2] [varchar] (50) NULL , [department] [int] NULL , [IsRep] [int] NULL , [dtCreated] [datetime] NULL , [dtLastAccess] [datetime] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[categories] WITH NOCHECK ADD PRIMARY key CLUSTERED ( [category_id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[departments] WITH NOCHECK ADD PRIMARY key CLUSTERED ( [department_id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[priority] WITH NOCHECK ADD PRIMARY key CLUSTERED ( [priority_id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[problems] WITH NOCHECK ADD PRIMARY key CLUSTERED ( [id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[status] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [status_id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[tblConfig_Auth] WITH NOCHECK ADD PRIMARY key CLUSTERED ( [ID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[tblConfig_Email] WITH NOCHECK ADD PRIMARY key CLUSTERED ( [ID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[tblEmailMsg] WITH NOCHECK ADD PRIMARY key CLUSTERED ( [type] ) ON [PRIMARY] GO ALTER TABLE [dbo].[tblUsers] WITH NOCHECK ADD PRIMARY key CLUSTERED ( [sid] ) ON [PRIMARY] GO ALTER TABLE [dbo].[tblUsers] WITH NOCHECK ADD CONSTRAINT [DF_tblUsers_department] DEFAULT (0) FOR [department], CONSTRAINT [DF_tblUsers_IsRep] DEFAULT (0) FOR [IsRep], CONSTRAINT [DF_tblUsers_dtCreated] DEFAULT (getdate()) FOR [dtCreated], CONSTRAINT [DF_tblUsers_dtLastAccess] DEFAULT (getdate()) FOR [dtLastAccess] GO INSERT INTO tblconfig ( SiteName, BaseURL, AdminPass, EmailType, SMTPServer, HDName, HDReply, BaseEmail, EnablePager, NotifyUser, EnableKB, DefaultPriority, DefaultStatus, CloseStatus, AuthType, Color1, Color2, BGColor, TextColor, LinkColor, VLinkColor, ALinkColor ) VALUES ( 'Company Name', 'http://www.company.com/helpdesk', 'admin', 1, 'smtp.company.com', 'Consultant', 'helpdesk@company.com', '@company.com', 0, 0, 1, 1, 1, 100, 2, '#6080B0', '#EEEEEE', '#FFFFFF', '#000000', '#6080B0', '#7090C0', '#7090C0' ) GO INSERT INTO tblConfig_Auth (ID, Type) VALUES (1, 'NT Authentication') INSERT INTO tblConfig_Auth (ID, Type) VALUES (2, 'Database') INSERT INTO tblConfig_Auth (ID, Type) VALUES (3, 'External Authentication') GO INSERT INTO tblConfig_Email (ID, Type) VALUES (0, 'Disabled') INSERT INTO tblConfig_Email (ID, Type) VALUES (1, 'CDONTS') INSERT INTO tblConfig_Email (ID, Type) VALUES (2, 'JMail') INSERT INTO tblConfig_Email (ID, Type) VALUES (3, 'ASPEmail') GO INSERT INTO tblEmailMsg(type, subject, body) VALUES ( 'repclose', 'HELPDESK: Problem [problemid] Closed', 'The following problem has been closed. You can view the problem at [rurl]' + CHAR(13) + CHAR(13) + 'PROBLEM DETAILS' + CHAR(13) + '---------------' + CHAR(13) + 'ID: [problemid]' + CHAR(13) + 'User: [uid]' + CHAR(13) + 'Date: [startdate]' + CHAR(13) + 'Title: [title]' + CHAR(13) + 'Priority: [priority]' + CHAR(13) + 'Category: [category]' + CHAR(13) + CHAR(13) + 'SOLUTION' + CHAR(13) + '--------' + CHAR(13) + '[solution]' ) INSERT INTO tblEmailMsg(type, subject, body) VALUES ( 'repnew', 'HELPDESK: Problem [problemid] Assigned', 'The following problem has been assigned to you. You can update the problem at [rurl]' + CHAR(13) + CHAR(13) + 'PROBLEM DETAILS' + CHAR(13) + '---------------' + CHAR(13) + 'ID: [problemid]' + CHAR(13) + 'Date: [startdate]' + CHAR(13) + 'Title: [title]' + CHAR(13) + 'Priority: [priority]' + CHAR(13) + 'Category: [category]' + CHAR(13) + CHAR(13) + 'USER INFORMATION' + CHAR(13) + '----------------' + CHAR(13) + 'Username: [uid]' + CHAR(13) + 'Email: [uemail]' + CHAR(13) + 'Phone: [phone]' + CHAR(13) + 'Location: [location]' + CHAR(13) + 'Department: [department]' + CHAR(13) + CHAR(13) + 'DESCRIPTION' + CHAR(13) + '-----------' + CHAR(13) + '[description]' ) INSERT INTO tblEmailMsg(type, subject, body) VALUES ( 'reppager', 'HELPDESK: Problem [problemid] Assigned', 'Title: [title]' + CHAR(13) + 'Priority: [priority]' + CHAR(13) + 'User: [uid]' ) INSERT INTO tblEmailMsg(type, subject, body) VALUES ( 'repupdate', 'HELPDESK: Problem [problemid] Updated', 'The following problem has been updated. You can view the problem at [rurl]' + CHAR(13) + CHAR(13) + 'PROBLEM DETAILS' + CHAR(13) + '---------------' + CHAR(13) + 'ID: [problemid]' + CHAR(13) + 'User: [uid]' + CHAR(13) + 'Date: [startdate]' + CHAR(13) + 'Title: [title]' + CHAR(13) + 'Priority: [priority]' + CHAR(13) + 'Category: [category]' + CHAR(13) + CHAR(13) + 'DESCRIPTION' + CHAR(13) + '-----------' + CHAR(13) + '[description]' ) INSERT INTO tblEmailMsg(type, subject, body) VALUES ( 'userclose', 'HELPDESK: Problem [problemid] Closed', 'Your help desk problem has been closed. You can view the solution below or at: [uurl]' + CHAR(13) + CHAR(13) + 'PROBLEM DETAILS' + CHAR(13) + '---------------' + CHAR(13) + 'ID: [problemid]' + CHAR(13) + 'User: [uid]' + CHAR(13) + 'Date: [startdate]' + CHAR(13) + 'Title: [title]' + CHAR(13) + CHAR(13) + 'SOLUTION' + CHAR(13) + '--------' + CHAR(13) + '[solution]' ) INSERT INTO tblEmailMsg(type, subject, body) VALUES ('usernew', 'HELPDESK: Problem [problemid] Created', 'Thank you for submitting your problem to the help desk. You can view or update the problem at: [uurl]' + CHAR(13) + CHAR(13) + 'PROBLEM DETAILS' + CHAR(13) + '---------------' + CHAR(13) + 'ID: [problemid]' + CHAR(13) + 'User: [uid]' + CHAR(13) + 'Date: [startdate]' + CHAR(13) + 'Title: [title]' + CHAR(13) + CHAR(13) + 'DESCRIPTION' + CHAR(13) + '-----------' + CHAR(13) + '[description]' ) INSERT INTO tblEmailMsg(type, subject, body) VALUES ('userupdate', 'HELPDESK: Problem [problemid] Updated', 'Your help desk problem has been updated. You can view the problem at: [uurl]' + CHAR(13) + CHAR(13) + 'PROBLEM DETAILS' + CHAR(13) + '---------------' + CHAR(13) + 'ID: [problemid]' + CHAR(13) + 'User: [uid]' + CHAR(13) + 'Date: [startdate]' + CHAR(13) + 'Title: [title]' + CHAR(13) + CHAR(13) + 'DESCRIPTION' + CHAR(13) + '-----------' + CHAR(13) + '[description]' ) GO INSERT INTO tblUsers(sid, uid, fname, email1) VALUES (0, 'unknown', 'Unknown', 'none@localhost') GO INSERT INTO db_keys(problems, departments, categories, users) VALUES (1,2,1,1) GO INSERT INTO status(status_id, sname) VALUES (0,'UNKNOWN') INSERT INTO status(status_id, sname) VALUES (1,'OPEN') INSERT INTO status(status_id, sname) VALUES (100,'CLOSED') GO INSERT INTO priority(priority_id, pname) VALUES (0,'UNKNOWN') INSERT INTO priority(priority_id, pname) VALUES (1,'LOW') INSERT INTO priority(priority_id, pname) VALUES (2,'HIGH') GO INSERT INTO departments(department_id, dname) VALUES (0,'UNKNOWN') INSERT INTO departments(department_id, dname) VALUES (1,'Dept1') GOObrigado.
Abraços
Link para o comentário
Compartilhar em outros sites
3 respostass a esta questão
Posts Recomendados