/*
Navicat SQL Server Data Transfer

Source Server         : StormZ
Source Server Version : 105000
Source Host           : 192.99.45.228,1465:1433
Source Database       : StormZ
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 105000
File Encoding         : 65001

Date: 2015-07-05 15:36:51
*/


-- ----------------------------
-- Table structure for WEB_Bulletin
-- ----------------------------
DROP TABLE [WEB_Bulletin]
GO
CREATE TABLE [WEB_Bulletin] (
[id] INT NOT NULL IDENTITY(1,1) ,
[CustomerID] INT NULL ,
[title] VARCHAR(255) NULL ,
[content] text NULL ,
[enableComment] INT NULL ,
[STATUS] INT NULL ,
[datacreated] datetime NULL ,
[TYPE] VARCHAR(20) NULL
)


GO

-- ----------------------------
-- Records of WEB_Bulletin
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [WEB_Bulletin] ON
GO
SET IDENTITY_INSERT [WEB_Bulletin] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for WEB_Bulletin_Category
-- ----------------------------
DROP TABLE [WEB_Bulletin_Category]
GO
CREATE TABLE [WEB_Bulletin_Category] (
[id] INT NOT NULL IDENTITY(1,1) ,
[name] VARCHAR(255) NULL ,
[STATUS] INT NULL
)


GO
DBCC CHECKIDENT(N'[WEB_Bulletin_Category]', RESEED, 3)
GO

-- ----------------------------
-- Records of WEB_Bulletin_Category
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [WEB_Bulletin_Category] ON
GO
SET IDENTITY_INSERT [WEB_Bulletin_Category] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for WEB_Bulletin_Comment
-- ----------------------------
DROP TABLE [WEB_Bulletin_Comment]
GO
CREATE TABLE [WEB_Bulletin_Comment] (
[id] INT NOT NULL IDENTITY(1,1) ,
[BulletinID] INT NULL ,
[CustomerID] INT NULL ,
[title] VARCHAR(255) NULL ,
[content] text NULL ,
[datecomment] datetime NULL
)


GO

-- ----------------------------
-- Records of WEB_Bulletin_Comment
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [WEB_Bulletin_Comment] ON
GO
SET IDENTITY_INSERT [WEB_Bulletin_Comment] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for WEB_Config
-- ----------------------------
DROP TABLE [WEB_Config]
GO
CREATE TABLE [WEB_Config] (
[id] INT NOT NULL IDENTITY(1,1) ,
[config_name] VARCHAR(255) NULL ,
[VALUE] VARCHAR(255) NULL
)


GO
DBCC CHECKIDENT(N'[WEB_Config]', RESEED, 8)
GO

-- ----------------------------
-- Records of WEB_Config
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [WEB_Config] ON
GO
INSERT INTO [WEB_Config] ([id], [config_name], [VALUE]) VALUES (N'1', N'title', N'StormZ Panel'), (N'2', N'description', N'Content Manager System to StormZ Servers www.stormz.com.br'), (N'3', N'lang', N'en'), (N'4', N'app_name', N'StormZ'), (N'5', N'last_update', N'2015-07-05 02:48:15'), (N'6', N'store', N''), (N'7', N'maintenance', N'0'), (N'8', N'register', N'1')
GO
GO
SET IDENTITY_INSERT [WEB_Config] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for WEB_Donate
-- ----------------------------
DROP TABLE [WEB_Donate]
GO
CREATE TABLE [WEB_Donate] (
[id] INT NOT NULL IDENTITY(1,1) ,
[CustomerID] INT NULL ,
[quantity] INT NULL ,
[lastdonate] datetime NULL DEFAULT (getdate())
)


GO
DBCC CHECKIDENT(N'[WEB_Donate]', RESEED, 2)
GO

-- ----------------------------
-- Records of WEB_Donate
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [WEB_Donate] ON
GO
SET IDENTITY_INSERT [WEB_Donate] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for WEB_Downloads
-- ----------------------------
DROP TABLE [WEB_Downloads]
GO
CREATE TABLE [WEB_Downloads] (
[id] INT NOT NULL IDENTITY(1,1) ,
[name] VARCHAR(100) NULL ,
[description] VARCHAR(100) NULL ,
[SIZE] VARCHAR(4) NULL ,
[size_type] VARCHAR(2) NULL ,
[url] VARCHAR(255) NULL ,
[dateupdated] datetime NULL DEFAULT (getdate())
)


GO

-- ----------------------------
-- Records of WEB_Downloads
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [WEB_Downloads] ON
GO
SET IDENTITY_INSERT [WEB_Downloads] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for WEB_H_Category
-- ----------------------------
DROP TABLE [WEB_H_Category]
GO
CREATE TABLE [WEB_H_Category] (
[id] INT NOT NULL IDENTITY(1,1) ,
[name] VARCHAR(50) NULL ,
[STATUS] INT NULL
)


GO

-- ----------------------------
-- Records of WEB_H_Category
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [WEB_H_Category] ON
GO
SET IDENTITY_INSERT [WEB_H_Category] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for WEB_H_Reply
-- ----------------------------
DROP TABLE [WEB_H_Reply]
GO
CREATE TABLE [WEB_H_Reply] (
[id] INT NOT NULL IDENTITY(1,1) ,
[TicketID] INT NULL ,
[CustomerID] INT NULL ,
[content] text NULL ,
[attach] VARCHAR(255) NULL ,
[datereply] datetime NULL DEFAULT (getdate())
)


GO

-- ----------------------------
-- Records of WEB_H_Reply
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [WEB_H_Reply] ON
GO
SET IDENTITY_INSERT [WEB_H_Reply] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for WEB_H_Tickets
-- ----------------------------
DROP TABLE [WEB_H_Tickets]
GO
CREATE TABLE [WEB_H_Tickets] (
[id] INT NOT NULL IDENTITY(1,1) ,
[PCustomerID] INT NULL ,
[ACustomerID] INT NULL ,
[title] VARCHAR(255) NULL ,
[content] text NULL ,
[category] INT NULL ,
[STATUS] INT NULL ,
[lastreply] VARCHAR(255) NULL ,
[replydate] datetime NULL DEFAULT '' ,
[createdate] datetime NULL DEFAULT (getdate())
)


GO

-- ----------------------------
-- Records of WEB_H_Tickets
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [WEB_H_Tickets] ON
GO
SET IDENTITY_INSERT [WEB_H_Tickets] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for WEB_Log
-- ----------------------------
DROP TABLE [WEB_Log]
GO
CREATE TABLE [WEB_Log] (
[id] INT NOT NULL IDENTITY(1,1) ,
[LogID] INT NULL ,
[CustomerID] INT NULL ,
[action] VARCHAR(255) NULL ,
[msg] VARCHAR(255) NULL ,
[datereported] datetime NULL DEFAULT (getdate())
)


GO
DBCC CHECKIDENT(N'[WEB_Log]', RESEED, 58)
GO

-- ----------------------------
-- Records of WEB_Log
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [WEB_Log] ON
GO
SET IDENTITY_INSERT [WEB_Log] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for WEB_MyPurchases
-- ----------------------------
DROP TABLE [WEB_MyPurchases]
GO
CREATE TABLE [WEB_MyPurchases] (
[id] INT NOT NULL IDENTITY(1,1) ,
[donateID] INT NULL ,
[packid] INT NULL ,
[CustomerID] INT NULL ,
[donatedate] datetime NULL DEFAULT (getdate())
)


GO
DBCC CHECKIDENT(N'[WEB_MyPurchases]', RESEED, 6)
GO

-- ----------------------------
-- Records of WEB_MyPurchases
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [WEB_MyPurchases] ON
GO
SET IDENTITY_INSERT [WEB_MyPurchases] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for WEB_Perm_Extras
-- ----------------------------
DROP TABLE [WEB_Perm_Extras]
GO
CREATE TABLE [WEB_Perm_Extras] (
[id] INT NOT NULL IDENTITY(1,1) ,
[CustomerID] INT NULL ,
[ban_perm] INT NULL
)


GO

-- ----------------------------
-- Records of WEB_Perm_Extras
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [WEB_Perm_Extras] ON
GO
SET IDENTITY_INSERT [WEB_Perm_Extras] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for WEB_Perm_Menus
-- ----------------------------
DROP TABLE [WEB_Perm_Menus]
GO
CREATE TABLE [WEB_Perm_Menus] (
[id] INT NOT NULL IDENTITY(1,1) ,
[CustomerID] INT NULL ,
[server_admin] INT NULL ,
[web_admin] INT NULL ,
[management] INT NULL
)


GO
DBCC CHECKIDENT(N'[WEB_Perm_Menus]', RESEED, 2)
GO

-- ----------------------------
-- Records of WEB_Perm_Menus
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [WEB_Perm_Menus] ON
GO
INSERT INTO [WEB_Perm_Menus] ([id], [CustomerID], [server_admin], [web_admin], [management]) VALUES (N'2', N'1000051', N'1', N'1', N'1')
GO
GO
SET IDENTITY_INSERT [WEB_Perm_Menus] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for WEB_Redeem_Code
-- ----------------------------
DROP TABLE [WEB_Redeem_Code]
GO
CREATE TABLE [WEB_Redeem_Code] (
[id] INT NOT NULL IDENTITY(1,1) ,
[code] VARCHAR(32) NULL ,
[items] VARCHAR(100) NULL ,
[quantity] INT NULL ,
[STATUS] VARCHAR(1) NULL ,
[datecreated] datetime NULL DEFAULT (getdate())
)


GO
DBCC CHECKIDENT(N'[WEB_Redeem_Code]', RESEED, 9)
GO

-- ----------------------------
-- Records of WEB_Redeem_Code
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [WEB_Redeem_Code] ON
GO
SET IDENTITY_INSERT [WEB_Redeem_Code] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for WEB_Redeem_CodesUsed
-- ----------------------------
DROP TABLE [WEB_Redeem_CodesUsed]
GO
CREATE TABLE [WEB_Redeem_CodesUsed] (
[CodeID] INT NOT NULL ,
[CustomerID] INT NULL ,
[code] VARCHAR(20) NULL ,
[dateused] datetime NULL DEFAULT (getdate())
)


GO

-- ----------------------------
-- Records of WEB_Redeem_CodesUsed
-- ----------------------------
BEGIN TRANSACTION
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for WEB_Referral_Status
-- ----------------------------
DROP TABLE [WEB_Referral_Status]
GO
CREATE TABLE [WEB_Referral_Status] (
[ReferralID] INT NOT NULL ,
[CustomerID] INT NULL ,
[STATUS] INT NULL
)


GO

-- ----------------------------
-- Records of WEB_Referral_Status
-- ----------------------------
BEGIN TRANSACTION
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for WEB_ServerStatus
-- ----------------------------
DROP TABLE [WEB_ServerStatus]
GO
CREATE TABLE [WEB_ServerStatus] (
[id] INT NOT NULL IDENTITY(1,1) ,
[status_name] VARCHAR(255) NULL ,
[VALUE] VARCHAR(255) NULL
)


GO

-- ----------------------------
-- Records of WEB_ServerStatus
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [WEB_ServerStatus] ON
GO
INSERT INTO [WEB_ServerStatus] ([id], [status_name], [VALUE]) VALUES (N'1', N'is_online', N'1')
GO
GO
SET IDENTITY_INSERT [WEB_ServerStatus] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for WEB_Store_PayMethods
-- ----------------------------
DROP TABLE [WEB_Store_PayMethods]
GO
CREATE TABLE [WEB_Store_PayMethods] (
[id] INT NOT NULL IDENTITY(1,1) ,
[paypal] INT NULL ,
[paypal_email] VARCHAR(80) NULL
)


GO

-- ----------------------------
-- Records of WEB_Store_PayMethods
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [WEB_Store_PayMethods] ON
GO
SET IDENTITY_INSERT [WEB_Store_PayMethods] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for WEB_User_Info
-- ----------------------------
DROP TABLE [WEB_User_Info]
GO
CREATE TABLE [WEB_User_Info] (
[CustomerID] INT NOT NULL ,
[name] VARCHAR(100) NULL ,
[last_name] VARCHAR(100) NULL ,
[born] DATE NULL DEFAULT '' ,
[last_login] datetime NULL DEFAULT '' ,
[avatarProfile] VARCHAR(255) NULL ,
[last_update] datetime NULL DEFAULT '' ,
[secret_word] VARCHAR(50) NULL
)


GO

-- ----------------------------
-- Records of WEB_User_Info
-- ----------------------------
BEGIN TRANSACTION
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Table structure for WEB_UserSerial
-- ----------------------------
DROP TABLE [WEB_UserSerial]
GO
CREATE TABLE [WEB_UserSerial] (
[id] INT NOT NULL IDENTITY(1,1) ,
[CustomerID] INT NULL ,
[email] VARCHAR(255) NULL ,
[serial] VARCHAR(50) NULL ,
[isUsed] INT NULL DEFAULT ((0)) ,
[dateused] datetime NULL DEFAULT (getdate())
)


GO
DBCC CHECKIDENT(N'[WEB_UserSerial]', RESEED, 6)
GO

-- ----------------------------
-- Records of WEB_UserSerial
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [WEB_UserSerial] ON
GO
SET IDENTITY_INSERT [WEB_UserSerial] OFF
GO
COMMIT TRANSACTION
GO

-- ----------------------------
-- Procedure structure for WEB_AddDonate
-- ----------------------------
DROP PROCEDURE [WEB_AddDonate]
GO
CREATE PROCEDURE [WEB_AddDonate]
    @in_CustomerID INT,
    @in_cost INT,
    @in_LastDonate datetime
AS
BEGIN
  UPDATE WEB_Donate SET quantity=(quantity+@in_cost), lastdonate=@in_LastDonate WHERE CustomerID=@in_CustomerID
    RETURN
END
GO

-- ----------------------------
-- Indexes structure for table WEB_Bulletin
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_Bulletin
-- ----------------------------
ALTER TABLE [WEB_Bulletin] ADD PRIMARY KEY ([id])
GO

-- ----------------------------
-- Indexes structure for table WEB_Bulletin_Category
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_Bulletin_Category
-- ----------------------------
ALTER TABLE [WEB_Bulletin_Category] ADD PRIMARY KEY ([id])
GO

-- ----------------------------
-- Indexes structure for table WEB_Bulletin_Comment
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_Bulletin_Comment
-- ----------------------------
ALTER TABLE [WEB_Bulletin_Comment] ADD PRIMARY KEY ([id])
GO

-- ----------------------------
-- Indexes structure for table WEB_Config
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_Config
-- ----------------------------
ALTER TABLE [WEB_Config] ADD PRIMARY KEY ([id])
GO

-- ----------------------------
-- Indexes structure for table WEB_Donate
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_Donate
-- ----------------------------
ALTER TABLE [WEB_Donate] ADD PRIMARY KEY ([id])
GO

-- ----------------------------
-- Indexes structure for table WEB_Downloads
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_Downloads
-- ----------------------------
ALTER TABLE [WEB_Downloads] ADD PRIMARY KEY ([id])
GO

-- ----------------------------
-- Indexes structure for table WEB_H_Category
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_H_Category
-- ----------------------------
ALTER TABLE [WEB_H_Category] ADD PRIMARY KEY ([id])
GO

-- ----------------------------
-- Indexes structure for table WEB_H_Reply
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_H_Reply
-- ----------------------------
ALTER TABLE [WEB_H_Reply] ADD PRIMARY KEY ([id])
GO

-- ----------------------------
-- Indexes structure for table WEB_H_Tickets
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_H_Tickets
-- ----------------------------
ALTER TABLE [WEB_H_Tickets] ADD PRIMARY KEY ([id])
GO

-- ----------------------------
-- Indexes structure for table WEB_Log
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_Log
-- ----------------------------
ALTER TABLE [WEB_Log] ADD PRIMARY KEY ([id])
GO

-- ----------------------------
-- Indexes structure for table WEB_MyPurchases
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_MyPurchases
-- ----------------------------
ALTER TABLE [WEB_MyPurchases] ADD PRIMARY KEY ([id])
GO

-- ----------------------------
-- Indexes structure for table WEB_Perm_Extras
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_Perm_Extras
-- ----------------------------
ALTER TABLE [WEB_Perm_Extras] ADD PRIMARY KEY ([id])
GO

-- ----------------------------
-- Indexes structure for table WEB_Perm_Menus
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_Perm_Menus
-- ----------------------------
ALTER TABLE [WEB_Perm_Menus] ADD PRIMARY KEY ([id])
GO

-- ----------------------------
-- Indexes structure for table WEB_Redeem_Code
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_Redeem_Code
-- ----------------------------
ALTER TABLE [WEB_Redeem_Code] ADD PRIMARY KEY ([id])
GO

-- ----------------------------
-- Indexes structure for table WEB_Redeem_CodesUsed
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_Redeem_CodesUsed
-- ----------------------------
ALTER TABLE [WEB_Redeem_CodesUsed] ADD PRIMARY KEY ([CodeID])
GO

-- ----------------------------
-- Indexes structure for table WEB_Referral_Status
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_Referral_Status
-- ----------------------------
ALTER TABLE [WEB_Referral_Status] ADD PRIMARY KEY ([ReferralID])
GO

-- ----------------------------
-- Indexes structure for table WEB_ServerStatus
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_ServerStatus
-- ----------------------------
ALTER TABLE [WEB_ServerStatus] ADD PRIMARY KEY ([id])
GO

-- ----------------------------
-- Indexes structure for table WEB_Store_PayMethods
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_Store_PayMethods
-- ----------------------------
ALTER TABLE [WEB_Store_PayMethods] ADD PRIMARY KEY ([id])
GO

-- ----------------------------
-- Indexes structure for table WEB_User_Info
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_User_Info
-- ----------------------------
ALTER TABLE [WEB_User_Info] ADD PRIMARY KEY ([CustomerID])
GO

-- ----------------------------
-- Indexes structure for table WEB_UserSerial
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table WEB_UserSerial
-- ----------------------------
ALTER TABLE [WEB_UserSerial] ADD PRIMARY KEY ([id])
GO