phpwcms_file

TABLE	TYPE	DESCRIPTION	EXAMPLE
f_id	int(11)	running unique ID	24 . . .
f_pid	int(11)	ID of parent entry from [f_id]	2
f_uid	int(11)	Owner-ID from phpwcms_user[usr_id]	2
f_kid	int(2)	———–
f_order	int(11)	———–
f_trash	int(1)	trashed = 1	0/1
f_aktiv	int(1)	Activ - state from entry at BE	0/1
f_public	int(1)	Pblic - state from entry at BE	0/1
f_tstamp	timestamp	Last changes made date:	2009-01-31 19:35:25
f_name	varchar(255)	Folder- or filename	ambiente_bad_raum.png
f_cat	varchar(255)	———–
f_created	int(11)	Date of data set entry created	11233426925
f_changed	int(11)	Date of data set entry changed	1232968793
f_size	int(15)	Größe (nur bei Dateien) in kbyte	433905
f_type	varchar(200)	file type (only for files)	image/png
f_ext	varchar(50)	Datei Extend (nur bei Dateien)	png
f_shortinfo	varchar(255)	Entry from field keyword in BE	Keyword
f_longinfo	text	Entry from info field in BE	Infotext
f_thumb_list	varchar(255)	———–
f_thumb_preview	varchar(255)	———–
f_keywords	varchar(255)	———–
f_hash	varchar(50)	Hash filename	0e537d421ec6f3….
f_dlstart	int(11)	number of downloads started	2
f_dlfinal	int(11)	number of downloads finished	1
f_refid	int(11)	———–
f_copyright	varchar(255)	Entry copyright text in BE	Copyrighttext
f_tags	varchar(255)	Entry tag field in BE	Schlagwort
f_granted	int(11)	Secured frontend download only in BE	0/1
f_gallerystatus	int(1)	Allow download in gallery in BE	0/1
f_vars	blob	———–
f_sort	int(11)	Sort field	1 2 3 4 . . .

english/technics/database/phpwcms_file.txt · Last modified: 2018/06/03 18:09 (external edit)