25e3a7669b7e798d054cf045e1b4a63d34dfdb74
[Packages/TYPO3.CMS.git] / typo3 / sysext / filemetadata / ext_tables.sql
1 #
2 # Table structure for table 'sys_file_metadata'
3 #
4 CREATE TABLE sys_file_metadata (
5 visible int(11) unsigned DEFAULT '1',
6 status varchar(24) DEFAULT '',
7 keywords text,
8 caption varchar(255) DEFAULT '',
9 creator_tool varchar(255) DEFAULT '',
10 download_name varchar(255) DEFAULT '',
11 creator varchar(255) DEFAULT '',
12 publisher varchar(45) DEFAULT '',
13 source varchar(255) DEFAULT '',
14 copyright varchar(255) DEFAULT '',
15 location_country varchar(45) DEFAULT '',
16 location_region varchar(45) DEFAULT '',
17 location_city varchar(45) DEFAULT '',
18 latitude decimal(24,14) DEFAULT '0.00000000000000',
19 longitude decimal(24,14) DEFAULT '0.00000000000000',
20 ranking int(11) unsigned DEFAULT '0',
21 content_creation_date int(11) unsigned DEFAULT '0',
22 content_modification_date int(11) unsigned DEFAULT '0',
23 note text,
24
25 # px,mm,cm,m,p, ...
26 unit char(3) DEFAULT '',
27
28 # AUDIO + VIDEO
29 duration float unsigned DEFAULT '0',
30
31 # RGB,sRGB,YUV, ...
32 color_space varchar(4) DEFAULT '',
33
34 # TEXT ASSET
35 # text document include x pages
36 pages int(4) unsigned DEFAULT '0',
37
38 # TEXT + AUDIO + VIDEO
39 # correspond to the language of the document
40 language varchar(12) DEFAULT '',
41
42 # FE permissions
43 fe_groups tinytext
44 );