d7ytWMWf

1use master;
2go
3
4
5drop database if exists [wiki_mobile];
6go
7
8
9create database wiki_mobile;
10go
11
12use wiki_mobile;
13go
14
15create table [User]
16(
17    ID                 varchar(50) primary key not null,
18    Name               varchar(30)             not null,
19    Location           varchar(30)             not null,
20    Role               int                     not null,
21    DateOfRegistration datetime                not null,
22    LastModifiedDate   datetime                not null,
23);
24go
25
26create table [Article]
27(
28    ID               varchar(50) primary key not null,
29    Name             varchar(30)             not null,
30    AuthorID         int                     not null,
31    DateOfCreation   datetime                not null,
32    LastModifiedDate datetime                not null,
33)
34go
35
36create table [Category]
37(
38    Name varchar(50) primary key not null,
39)
40go
41
42create table [Image]
43(
44    ID        varchar(50) primary key not null,
45    DateAdded datetime                not null,
46)
47
48declare @links_here table
49                    (
50                        Ind  int identity (1, 1),
51                        Link varchar(100)
52                    )
53
54/*select *
55from [User]
56go*/
57
58/*delete from [User];*/