Sql Guide:
- [Url] http://img101.yfrog.com/img101/4958/guiasql.png [/ url] -
Well we continue to finish all this will end and then we open the sql 2005 (SQL Server Management Studio Express) to connect there and then give turn to create the database TantraGM we click right to put databases and create database in this case we create TantraGM.
here I leave the code to not make them look weba xD
-------------------------------------------------- --------------
Code:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo]. [GMInfo] (
[Id] [int] IDENTITY (1,1) NOT NULL,
[GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMPassword] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMName] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMLevel] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMPart] [nvarchar] (50) COLLATE NULL Latin1_General_CI_AS
) ON [PRIMARY]
CREATE TABLE [dbo]. [GMLog] (
[LogIndex] [int] IDENTITY (1,1) NOT NULL,
[GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[SaveData] [datetime] NULL
[Description] [text] NULL Latin1_General_CI_AS COLLATE
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
CREATE TABLE [dbo]. [GMLogView] (
[LogIndex] [int] IDENTITY (1,1) NOT NULL,
[GMID] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMPassword] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMName] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMLevel] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[GMPart] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL,
[SaveData] [datetime] NULL,
[Description] [text] COLLATE NULL Latin1_General_CI_AS
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-------------------------------------------------- ---------------