· 8 years ago · Jul 03, 2018, 02:02 AM
1if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MobileVerification]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
2drop table [dbo].[MobileVerification]
3GO
4
5if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YahooIdVerification]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
6drop table [dbo].[YahooIdVerification]
7GO
8
9if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[accounts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
10drop table [dbo].[accounts]
11GO
12
13if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[countries]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
14drop table [dbo].[countries]
15GO
16
17if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[invitations]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
18drop table [dbo].[invitations]
19GO
20
21if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[newsletter]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
22drop table [dbo].[newsletter]
23GO
24
25if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[provinces]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
26drop table [dbo].[provinces]
27GO
28
29if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[themes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
30drop table [dbo].[themes]
31GO
32
33CREATE TABLE [dbo].[MobileVerification] (
34 [id] [bigint] IDENTITY (1, 1) NOT NULL ,
35 [BlogID] [bigint] NOT NULL ,
36 [MobileNumber] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
37 [VerificationCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
38) ON [PRIMARY]
39GO
40
41CREATE TABLE [dbo].[YahooIdVerification] (
42 [id] [bigint] IDENTITY (1, 1) NOT NULL ,
43 [BlogId] [bigint] NOT NULL ,
44 [YahooId] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
45 [VerificationCode] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
46) ON [PRIMARY]
47GO
48
49CREATE TABLE [dbo].[accounts] (
50 [id] [bigint] IDENTITY (1, 1) NOT NULL ,
51 [username] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
52 [password] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
53 [name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
54 [email] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
55 [ImageGuid] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
56 [TimeZone] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
57 [mobile] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
58 [sex] [bit] NOT NULL ,
59 [BirthYear] [int] NOT NULL ,
60 [BirthMonth] [int] NOT NULL ,
61 [BirthDay] [int] NOT NULL ,
62 [CountryKey] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
63 [ProvinceKey] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
64 [city] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
65 [DateRegister] [datetime] NOT NULL ,
66 [about] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
67 [url] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
68 [ShowAgeEnabled] [bit] NOT NULL ,
69 [ShowCityEnabled] [bit] NOT NULL ,
70 [ThemeID] [int] NOT NULL ,
71 [NewFriendEmails] [bit] NOT NULL ,
72 [DirectTextEmails] [bit] NOT NULL ,
73 [AutoNudge] [bit] NOT NULL ,
74 [SubdomainServer] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
75 [HasReadPrivateMessages] [bit] NOT NULL ,
76 [ShowLive] [bit] NOT NULL ,
77 [yahooid] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
78 [PostNum] [int] NOT NULL ,
79 [CommentNum] [int] NOT NULL ,
80 [PrivateMessagesNum] [int] NOT NULL ,
81 [FriendNum] [int] NOT NULL ,
82 [FollowerNum] [int] NOT NULL ,
83 [StarredPostNum] [int] NOT NULL ,
84 [IsDeleted] [bit] NOT NULL
85) ON [PRIMARY]
86GO
87
88CREATE TABLE [dbo].[countries] (
89 [id] [int] IDENTITY (1, 1) NOT NULL ,
90 [CountryKey] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
91 [country] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
92) ON [PRIMARY]
93GO
94
95CREATE TABLE [dbo].[invitations] (
96 [id] [int] IDENTITY (1, 1) NOT NULL ,
97 [_ref] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
98) ON [PRIMARY]
99GO
100
101CREATE TABLE [dbo].[newsletter] (
102 [id] [bigint] NOT NULL ,
103 [BlogID] [bigint] NOT NULL
104) ON [PRIMARY]
105GO
106
107CREATE TABLE [dbo].[provinces] (
108 [id] [int] IDENTITY (1, 1) NOT NULL ,
109 [ProvinceKey] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
110 [province] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
111) ON [PRIMARY]
112GO
113
114CREATE TABLE [dbo].[themes] (
115 [id] [int] IDENTITY (1, 1) NOT NULL ,
116 [ThemeString] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
117) ON [PRIMARY]
118GO
119
120*****************************************
121
122if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[friends]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
123drop table [dbo].[friends]
124GO
125
126CREATE TABLE [dbo].[friends] (
127 [id] [bigint] IDENTITY (1, 1) NOT NULL ,
128 [BlogID] [bigint] NOT NULL ,
129 [FriendBlogID] [bigint] NOT NULL ,
130 [IsFriend] [bit] NOT NULL ,
131 [IsFollower] [bit] NOT NULL ,
132 [IHaveBlocked] [bit] NOT NULL ,
133 [HeHasBlocked] [bit] NOT NULL ,
134 [IsDeleted] [bit] NOT NULL
135) ON [PRIMARY]
136GO