Repository navigation
Expand file tree
/
Copy pathinit.sql
More file actions
78 lines (68 loc) · 2.31 KB
/
Copy pathinit.sql
File metadata and controls
78 lines (68 loc) · 2.31 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
create table Category
(
Id INTEGER,
Name NVARCHAR(255),
ParentId INTEGER not null,
primary key (Id autoincrement)
);
create table FeaturedCategory
(
Id INTEGER,
CategoryId INTEGER not null,
Name NVARCHAR(255),
Description NVARCHAR(255),
IconCssClass NVARCHAR(255),
primary key (Id autoincrement)
);
create table FeaturedPhoto
(
Id INTEGER,
PhotoId NVARCHAR(255),
primary key (Id autoincrement)
);
create table FeaturedPost
(
Id INTEGER,
PostId NVARCHAR(255),
primary key (Id autoincrement)
);
create table Photo
(
Id NVARCHAR(255),
Title NVARCHAR(255),
Location NVARCHAR(255),
FilePath NVARCHAR(255),
Height INTEGER not null,
Width INTEGER not null,
CreateTime DATETIME not null,
primary key (Id)
);
create table Post
(
Id NVARCHAR(255),
Title NVARCHAR(255),
Summary NVARCHAR(255),
Content NVARCHAR(255),
Path NVARCHAR(255),
CreationTime DATETIME not null,
LastUpdateTime DATETIME not null,
CategoryId INTEGER not null,
Categories NVARCHAR(255),
primary key (Id)
);
create table TopPost
(
Id INTEGER,
PostId NVARCHAR(255),
primary key (Id autoincrement)
);
create table User
(
Id NVARCHAR(255),
Name NVARCHAR(255),
Password NVARCHAR(255),
primary key (Id)
);
INSERT INTO FeaturedCategory (Id, CategoryId, Name, Description, IconCssClass) VALUES (1, 3, 'C# / Asp.Net Core', 'Paragraph of text beneath the heading to explain the heading. We''ll add onto it with another sentence and probably just keep going until we run out of words.', 'fa-solid fa-c');
INSERT INTO FeaturedCategory (Id, CategoryId, Name, Description, IconCssClass) VALUES (2, 8, 'Python / Django', 'Paragraph of text beneath the heading to explain the heading. We''ll add onto it with another sentence and probably just keep going until we run out of words.', 'fa-brands fa-python');
INSERT INTO FeaturedCategory (Id, CategoryId, Name, Description, IconCssClass) VALUES (3, 2, 'Flutter / Android', 'Paragraph of text beneath the heading to explain the heading. We''ll add onto it with another sentence and probably just keep going until we run out of words.', 'fa-brands fa-android');