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