[BUGFIX] filemetadata: differenciate between file types
[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 '0' 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 location_country varchar(45) DEFAULT '' NOT NULL,
15 location_region varchar(45) DEFAULT '' NOT NULL,
16 location_city varchar(45) DEFAULT '' NOT NULL,
17 latitude decimal(24,14) DEFAULT '0.00000000000000' NOT NULL,
18 longitude decimal(24,14) DEFAULT '0.00000000000000' NOT NULL,
19 ranking int(11) unsigned DEFAULT '0',
20 content_creation_date int(11) unsigned DEFAULT '0',
21 content_modification_date int(11) unsigned DEFAULT '0',
22 note text NOT NULL,
23
24 # px,mm,cm,m,p, ...
25 unit char(3) DEFAULT '' NOT NULL,
26
27 # AUDIO + VIDEO
28 duration float unsigned DEFAULT '0' NOT NULL,
29
30 # RGB,sRGB,YUV, ...
31 color_space varchar(4) DEFAULT '' NOT NULL,
32
33 # TEXT ASSET
34 # text document include x pages
35 pages int(4) unsigned DEFAULT '0' NOT NULL,
36
37 # TEXT + AUDIO + VIDEO
38 # correspond to the language of the document
39 language varchar(12) DEFAULT '' NOT NULL,
40
41 # FE permissions
42 fe_groups int(11) unsigned DEfAULT '0' NOT NULL,
43 );
44
45 #
46 # Table structure for table 'sys_file_fegroups_mm'
47 #
48 CREATE TABLE sys_file_fegroups_mm (
49 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
50 uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
51 sorting int(11) unsigned DEFAULT '0' NOT NULL,
52 sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
53
54 KEY uid_local (uid_local),
55 KEY uid_foreign (uid_foreign)
56 );