[FEATURE] Report wrong database character set
[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' NOT NULL,
6 status varchar(24) DEFAULT '' NOT NULL,
7 keywords text NOT NULL,
8 caption varchar(255) DEFAULT '' NOT NULL,
9 creator_tool varchar(255) DEFAULT '' NOT NULL,
10 download_name varchar(255) DEFAULT '' NOT NULL,
11 creator varchar(255) DEFAULT '' NOT NULL,
12 publisher varchar(45) DEFAULT '' NOT NULL,
13 source varchar(255) DEFAULT '' NOT NULL,
14 copyright varchar(255) DEFAULT '' NOT NULL,
15 location_country varchar(45) DEFAULT '' NOT NULL,
16 location_region varchar(45) DEFAULT '' NOT NULL,
17 location_city varchar(45) DEFAULT '' NOT NULL,
18 latitude decimal(24,14) DEFAULT '0.00000000000000' NOT NULL,
19 longitude decimal(24,14) DEFAULT '0.00000000000000' NOT NULL,
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 NOT NULL,
24
25 # px,mm,cm,m,p, ...
26 unit char(3) DEFAULT '' NOT NULL,
27
28 # AUDIO + VIDEO
29 duration float unsigned DEFAULT '0' NOT NULL,
30
31 # RGB,sRGB,YUV, ...
32 color_space varchar(4) DEFAULT '' NOT NULL,
33
34 # TEXT ASSET
35 # text document include x pages
36 pages int(4) unsigned DEFAULT '0' NOT NULL,
37
38 # TEXT + AUDIO + VIDEO
39 # correspond to the language of the document
40 language varchar(12) DEFAULT '' NOT NULL,
41
42 # FE permissions
43 fe_groups tinytext NOT NULL,
44 );