-
Notifications
You must be signed in to change notification settings - Fork 2
/
pviewgallery_sql.php
149 lines (75 loc) · 2.65 KB
/
pviewgallery_sql.php
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
CREATE TABLE pview_album (
albumId int(10) unsigned NOT NULL auto_increment,
galleryId int(10) unsigned default NULL,
parentAlbumId int(10) unsigned default NULL,
name varchar(60) default NULL,
description mediumtext,
albumImage varchar(100) default NULL,
permUpload varchar(100) default NULL,
permEdit varchar(100) default NULL,
permView varchar(100) default NULL,
permCreateAlbum varchar(100) default NULL,
PRIMARY KEY (albumId)
) TYPE=MyISAM;
CREATE TABLE pview_config (
configName varchar(25) NOT NULL default '',
configValue varchar(60) default NULL,
PRIMARY KEY (configName)
) TYPE=MyISAM;
CREATE TABLE pview_gallery (
galleryId int(10) unsigned NOT NULL default '0',
name varchar(60) default NULL,
active tinyint(1) default NULL,
permEdit varchar(100) default NULL,
permView varchar(100) default NULL,
permCreateAlbum varchar(100) default NULL,
PRIMARY KEY (galleryId)
) TYPE=MyISAM;
CREATE TABLE pview_image (
imageId int(10) unsigned NOT NULL auto_increment,
albumId int(10) unsigned NOT NULL default '0',
name varchar(60) default NULL,
description mediumtext,
filename varchar(100) default NULL,
filenameResized varchar(100) default NULL,
thumbnail varchar(100) default NULL,
uploaderUserId varchar(10) default NULL,
uploadDate int(11) default NULL,
approved tinyint(1) default NULL,
permEdit varchar(100) default NULL,
permView varchar(100) default NULL,
views int(10) default '0',
cat int(10) default '0',
sendImage tinyint(1) NOT NULL default '0',
externalImage tinyint(1) NOT NULL default '0',
PRIMARY KEY (imageId)
) TYPE=MyISAM;
CREATE TABLE pview_comment (
commentId int(10) unsigned NOT NULL auto_increment,
commente107userId int(10) unsigned NOT NULL default '0',
commentDate int(11) default NULL,
commentText mediumtext,
commentImageId int(10) unsigned NOT NULL default '0',
PRIMARY KEY (commentId)
) TYPE=MyISAM;
CREATE TABLE pview_rating (
ratingId int(10) unsigned NOT NULL auto_increment,
rating107userId int(10) unsigned NOT NULL default '0',
ratingDate int(11) default NULL,
ratingValue int(5) default NULL,
ratingImageId int(10) unsigned NOT NULL default '0',
PRIMARY KEY (ratingId)
) TYPE=MyISAM;
CREATE TABLE pview_tmpip (
ip_addr varchar(20) NOT NULL default '0',
images mediumtext default NULL,
time varchar(12) default NULL,
PRIMARY KEY (ip_addr)
) TYPE=MyISAM;
CREATE TABLE pview_cat (
catId int(10) unsigned NOT NULL auto_increment,
name varchar(60) default NULL,
description mediumtext default NULL,
icon varchar(250) default NULL,
PRIMARY KEY (catId)
) TYPE=MyISAM;