You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 

344 lines
11 KiB

  1. --
  2. -- Table structure for table 'tx_dlf_documents'
  3. --
  4. CREATE TABLE tx_dlf_documents (
  5. uid int(11) NOT NULL auto_increment,
  6. pid int(11) DEFAULT '0' NOT NULL,
  7. tstamp int(11) DEFAULT '0' NOT NULL,
  8. crdate int(11) DEFAULT '0' NOT NULL,
  9. cruser_id int(11) DEFAULT '0' NOT NULL,
  10. deleted smallint(6) DEFAULT '0' NOT NULL,
  11. hidden smallint(6) DEFAULT '0' NOT NULL,
  12. starttime int(11) DEFAULT '0' NOT NULL,
  13. endtime int(11) DEFAULT '0' NOT NULL,
  14. fe_group varchar(100) DEFAULT '' NOT NULL,
  15. prod_id varchar(255) DEFAULT '' NOT NULL,
  16. location varchar(255) DEFAULT '' NOT NULL,
  17. record_id varchar(255) DEFAULT '' NOT NULL,
  18. opac_id varchar(255) DEFAULT '' NOT NULL,
  19. union_id varchar(255) DEFAULT '' NOT NULL,
  20. urn varchar(255) DEFAULT '' NOT NULL,
  21. purl varchar(255) DEFAULT '' NOT NULL,
  22. title text NOT NULL,
  23. title_sorting text NOT NULL,
  24. author varchar(255) DEFAULT '' NOT NULL,
  25. year varchar(255) DEFAULT '' NOT NULL,
  26. place varchar(255) DEFAULT '' NOT NULL,
  27. thumbnail varchar(255) DEFAULT '' NOT NULL,
  28. metadata text NOT NULL,
  29. metadata_sorting text NOT NULL,
  30. structure int(11) DEFAULT '0' NOT NULL,
  31. partof int(11) DEFAULT '0' NOT NULL,
  32. volume varchar(255) DEFAULT '' NOT NULL,
  33. volume_sorting varchar(255) DEFAULT '' NOT NULL,
  34. license varchar(255) DEFAULT '' NOT NULL,
  35. terms varchar(255) DEFAULT '' NOT NULL,
  36. restrictions varchar(255) DEFAULT '' NOT NULL,
  37. out_of_print text NOT NULL,
  38. rights_info text NOT NULL,
  39. collections int(11) DEFAULT '0' NOT NULL,
  40. mets_label varchar(255) DEFAULT '' NOT NULL,
  41. mets_orderlabel varchar(255) DEFAULT '' NOT NULL,
  42. owner int(11) DEFAULT '0' NOT NULL,
  43. solrcore int(11) DEFAULT '0' NOT NULL,
  44. status smallint(6) unsigned DEFAULT '0' NOT NULL,
  45. document_format varchar(100) DEFAULT '' NOT NULL,
  46. PRIMARY KEY (uid),
  47. KEY parent (pid),
  48. KEY location (location),
  49. KEY record_id (record_id),
  50. KEY partof (partof)
  51. );
  52. --
  53. -- Table structure for table 'tx_dlf_structures'
  54. --
  55. CREATE TABLE tx_dlf_structures (
  56. uid int(11) NOT NULL auto_increment,
  57. pid int(11) DEFAULT '0' NOT NULL,
  58. tstamp int(11) DEFAULT '0' NOT NULL,
  59. crdate int(11) DEFAULT '0' NOT NULL,
  60. cruser_id int(11) DEFAULT '0' NOT NULL,
  61. deleted smallint(6) DEFAULT '0' NOT NULL,
  62. sys_language_uid int(11) DEFAULT '0' NOT NULL,
  63. l18n_parent int(11) DEFAULT '0' NOT NULL,
  64. l18n_diffsource mediumblob NOT NULL,
  65. hidden smallint(6) DEFAULT '0' NOT NULL,
  66. toplevel smallint(6) DEFAULT '0' NOT NULL,
  67. label varchar(255) DEFAULT '' NOT NULL,
  68. index_name varchar(255) DEFAULT '' NOT NULL,
  69. oai_name varchar(255) DEFAULT '' NOT NULL,
  70. thumbnail int(11) DEFAULT '0' NOT NULL,
  71. status smallint(6) unsigned DEFAULT '0' NOT NULL,
  72. PRIMARY KEY (uid),
  73. KEY parent (pid),
  74. KEY language (l18n_parent,sys_language_uid),
  75. KEY index_name (index_name)
  76. );
  77. --
  78. -- Table structure for table 'tx_dlf_metadata'
  79. --
  80. CREATE TABLE tx_dlf_metadata (
  81. uid int(11) NOT NULL auto_increment,
  82. pid int(11) DEFAULT '0' NOT NULL,
  83. tstamp int(11) DEFAULT '0' NOT NULL,
  84. crdate int(11) DEFAULT '0' NOT NULL,
  85. cruser_id int(11) DEFAULT '0' NOT NULL,
  86. deleted smallint(6) DEFAULT '0' NOT NULL,
  87. sys_language_uid int(11) DEFAULT '0' NOT NULL,
  88. l18n_parent int(11) DEFAULT '0' NOT NULL,
  89. l18n_diffsource mediumblob NOT NULL,
  90. hidden smallint(6) DEFAULT '0' NOT NULL,
  91. sorting int(11) DEFAULT '0' NOT NULL,
  92. label varchar(255) DEFAULT '' NOT NULL,
  93. index_name varchar(255) DEFAULT '' NOT NULL,
  94. format int(11) DEFAULT '0' NOT NULL,
  95. default_value varchar(255) DEFAULT '' NOT NULL,
  96. wrap text NOT NULL,
  97. index_tokenized smallint(6) DEFAULT '0' NOT NULL,
  98. index_stored smallint(6) DEFAULT '0' NOT NULL,
  99. index_indexed smallint(6) DEFAULT '0' NOT NULL,
  100. index_boost float(4,2) DEFAULT '1.00' NOT NULL,
  101. is_sortable smallint(6) DEFAULT '0' NOT NULL,
  102. is_facet smallint(6) DEFAULT '0' NOT NULL,
  103. is_listed smallint(6) DEFAULT '0' NOT NULL,
  104. index_autocomplete smallint(6) DEFAULT '0' NOT NULL,
  105. status smallint(6) unsigned DEFAULT '0' NOT NULL,
  106. PRIMARY KEY (uid),
  107. KEY parent (pid),
  108. KEY language (l18n_parent,sys_language_uid),
  109. KEY index_name (index_name),
  110. KEY index_autocomplete (index_autocomplete),
  111. KEY is_sortable (is_sortable),
  112. KEY is_facet (is_facet),
  113. KEY is_listed (is_listed)
  114. );
  115. --
  116. -- Table structure for table 'tx_dlf_metadataformat'
  117. --
  118. CREATE TABLE tx_dlf_metadataformat (
  119. uid int(11) NOT NULL auto_increment,
  120. pid int(11) DEFAULT '0' NOT NULL,
  121. tstamp int(11) DEFAULT '0' NOT NULL,
  122. crdate int(11) DEFAULT '0' NOT NULL,
  123. cruser_id int(11) DEFAULT '0' NOT NULL,
  124. deleted smallint(6) DEFAULT '0' NOT NULL,
  125. parent_id int(11) DEFAULT '0' NOT NULL,
  126. encoded int(11) DEFAULT '0' NOT NULL,
  127. xpath varchar(1024) DEFAULT '' NOT NULL,
  128. xpath_sorting varchar(1024) DEFAULT '' NOT NULL,
  129. mandatory smallint(6) DEFAULT '0' NOT NULL,
  130. PRIMARY KEY (uid),
  131. KEY parent (pid),
  132. KEY parent_id (parent_id)
  133. );
  134. --
  135. -- Table structure for table 'tx_dlf_formats'
  136. --
  137. CREATE TABLE tx_dlf_formats (
  138. uid int(11) NOT NULL auto_increment,
  139. pid int(11) DEFAULT '0' NOT NULL,
  140. tstamp int(11) DEFAULT '0' NOT NULL,
  141. crdate int(11) DEFAULT '0' NOT NULL,
  142. cruser_id int(11) DEFAULT '0' NOT NULL,
  143. deleted smallint(6) DEFAULT '0' NOT NULL,
  144. type varchar(255) DEFAULT '' NOT NULL,
  145. root varchar(255) DEFAULT '' NOT NULL,
  146. namespace varchar(255) DEFAULT '' NOT NULL,
  147. class varchar(255) DEFAULT '' NOT NULL,
  148. PRIMARY KEY (uid),
  149. KEY parent (pid)
  150. );
  151. --
  152. -- Table structure for table 'tx_dlf_solrcores'
  153. --
  154. CREATE TABLE tx_dlf_solrcores (
  155. uid int(11) NOT NULL auto_increment,
  156. pid int(11) DEFAULT '0' NOT NULL,
  157. tstamp int(11) DEFAULT '0' NOT NULL,
  158. crdate int(11) DEFAULT '0' NOT NULL,
  159. cruser_id int(11) DEFAULT '0' NOT NULL,
  160. deleted smallint(6) DEFAULT '0' NOT NULL,
  161. label varchar(255) DEFAULT '' NOT NULL,
  162. index_name varchar(255) DEFAULT '' NOT NULL,
  163. PRIMARY KEY (uid),
  164. KEY parent (pid),
  165. KEY index_name (index_name)
  166. );
  167. --
  168. -- Table structure for table 'tx_dlf_collections'
  169. --
  170. CREATE TABLE tx_dlf_collections (
  171. uid int(11) NOT NULL auto_increment,
  172. pid int(11) DEFAULT '0' NOT NULL,
  173. tstamp int(11) DEFAULT '0' NOT NULL,
  174. crdate int(11) DEFAULT '0' NOT NULL,
  175. cruser_id int(11) DEFAULT '0' NOT NULL,
  176. fe_cruser_id int(11) DEFAULT '0' NOT NULL,
  177. fe_admin_lock smallint(6) DEFAULT '0' NOT NULL,
  178. deleted smallint(6) DEFAULT '0' NOT NULL,
  179. sys_language_uid int(11) DEFAULT '0' NOT NULL,
  180. l18n_parent int(11) DEFAULT '0' NOT NULL,
  181. l18n_diffsource mediumblob NOT NULL,
  182. hidden smallint(6) DEFAULT '0' NOT NULL,
  183. fe_group varchar(100) DEFAULT '' NOT NULL,
  184. label varchar(255) DEFAULT '' NOT NULL,
  185. index_name varchar(255) DEFAULT '' NOT NULL,
  186. index_search text NOT NULL,
  187. oai_name varchar(255) DEFAULT '' NOT NULL,
  188. description text NOT NULL,
  189. thumbnail text NOT NULL,
  190. priority smallint(6) DEFAULT '3' NOT NULL,
  191. documents int(11) DEFAULT '0' NOT NULL,
  192. owner int(11) DEFAULT '0' NOT NULL,
  193. status smallint(6) unsigned DEFAULT '0' NOT NULL,
  194. PRIMARY KEY (uid),
  195. KEY parent (pid),
  196. KEY language (l18n_parent,sys_language_uid),
  197. KEY index_name (index_name),
  198. KEY oai_name (oai_name),
  199. KEY pid_cruser (pid,fe_cruser_id)
  200. );
  201. --
  202. -- Table structure for table 'tx_dlf_libraries'
  203. --
  204. CREATE TABLE tx_dlf_libraries (
  205. uid int(11) NOT NULL auto_increment,
  206. pid int(11) DEFAULT '0' NOT NULL,
  207. tstamp int(11) DEFAULT '0' NOT NULL,
  208. crdate int(11) DEFAULT '0' NOT NULL,
  209. cruser_id int(11) DEFAULT '0' NOT NULL,
  210. deleted smallint(6) DEFAULT '0' NOT NULL,
  211. sys_language_uid int(11) DEFAULT '0' NOT NULL,
  212. l18n_parent int(11) DEFAULT '0' NOT NULL,
  213. l18n_diffsource mediumblob NOT NULL,
  214. label varchar(255) DEFAULT '' NOT NULL,
  215. index_name varchar(255) DEFAULT '' NOT NULL,
  216. website varchar(255) DEFAULT '' NOT NULL,
  217. contact varchar(255) DEFAULT '' NOT NULL,
  218. image mediumblob NOT NULL,
  219. oai_label varchar(255) DEFAULT '' NOT NULL,
  220. oai_base int(11) DEFAULT '0' NOT NULL,
  221. opac_label varchar(255) DEFAULT '' NOT NULL,
  222. opac_base varchar(255) DEFAULT '' NOT NULL,
  223. union_label varchar(255) DEFAULT '' NOT NULL,
  224. union_base varchar(255) DEFAULT '' NOT NULL,
  225. PRIMARY KEY (uid),
  226. KEY parent (pid),
  227. KEY language (l18n_parent,sys_language_uid),
  228. KEY index_name (index_name)
  229. );
  230. --
  231. -- Table structure for table 'tx_dlf_tokens'
  232. --
  233. CREATE TABLE tx_dlf_tokens (
  234. uid int(11) NOT NULL auto_increment,
  235. tstamp int(11) DEFAULT '0' NOT NULL,
  236. token varchar(255) DEFAULT '' NOT NULL,
  237. options mediumtext NOT NULL,
  238. ident varchar(30) DEFAULT '' NOT NULL,
  239. PRIMARY KEY (uid),
  240. KEY token (token)
  241. );
  242. --
  243. -- Table structure for table 'tx_dlf_relations'
  244. --
  245. CREATE TABLE tx_dlf_relations (
  246. uid int(11) NOT NULL auto_increment,
  247. uid_local int(11) DEFAULT '0' NOT NULL,
  248. uid_foreign int(11) DEFAULT '0' NOT NULL,
  249. tablenames varchar(30) DEFAULT '' NOT NULL,
  250. sorting int(11) DEFAULT '0' NOT NULL,
  251. sorting_foreign int(11) DEFAULT '0' NOT NULL,
  252. ident varchar(30) DEFAULT '' NOT NULL,
  253. PRIMARY KEY (uid),
  254. KEY local_foreign (uid_local,uid_foreign,ident)
  255. );
  256. --
  257. -- Table structure for table 'tx_dlf_basket'
  258. --
  259. CREATE TABLE tx_dlf_basket (
  260. uid int(11) NOT NULL auto_increment,
  261. pid int(11) DEFAULT '0' NOT NULL,
  262. tstamp int(11) DEFAULT '0' NOT NULL,
  263. fe_user_id int(11) DEFAULT '0' NOT NULL,
  264. deleted smallint(6) DEFAULT '0' NOT NULL,
  265. sys_language_uid int(11) DEFAULT '0' NOT NULL,
  266. l18n_parent int(11) DEFAULT '0' NOT NULL,
  267. l18n_diffsource mediumblob NOT NULL,
  268. label varchar(255) DEFAULT '' NOT NULL,
  269. session_id varchar(32) DEFAULT '' NOT NULL,
  270. doc_ids varchar(255) DEFAULT '' NOT NULL,
  271. PRIMARY KEY (uid),
  272. KEY parent (pid),
  273. KEY language (l18n_parent,sys_language_uid)
  274. );
  275. --
  276. -- Table structure for table 'tx_dlf_printer'
  277. --
  278. CREATE TABLE tx_dlf_printer (
  279. uid int(11) NOT NULL auto_increment,
  280. pid int(11) DEFAULT '0' NOT NULL,
  281. deleted smallint(6) DEFAULT '0' NOT NULL,
  282. print varchar(255) DEFAULT '' NOT NULL,
  283. label varchar(255) DEFAULT '' NOT NULL,
  284. PRIMARY KEY (uid),
  285. KEY parent (pid)
  286. );
  287. --
  288. -- Table structure for table 'tx_dlf_mail'
  289. --
  290. CREATE TABLE tx_dlf_mail (
  291. uid int(11) NOT NULL auto_increment,
  292. pid int(11) DEFAULT '0' NOT NULL,
  293. deleted smallint(6) DEFAULT '0' NOT NULL,
  294. sorting int(11) DEFAULT '0' NOT NULL,
  295. mail varchar(255) DEFAULT '' NOT NULL,
  296. name varchar(255) DEFAULT '' NOT NULL,
  297. label varchar(255) DEFAULT '' NOT NULL,
  298. PRIMARY KEY (uid),
  299. KEY parent (pid)
  300. );
  301. --
  302. -- Table structure for table 'tx_dlf_actionlog'
  303. --
  304. CREATE TABLE tx_dlf_actionlog (
  305. uid int(11) NOT NULL auto_increment,
  306. pid int(11) DEFAULT '0' NOT NULL,
  307. crdate int(11) DEFAULT '0' NOT NULL,
  308. deleted smallint(6) DEFAULT '0' NOT NULL,
  309. user_id int(11) DEFAULT '0' NOT NULL,
  310. file_name varchar(255) DEFAULT '' NOT NULL,
  311. count_pages int(11) DEFAULT '0' NOT NULL,
  312. name varchar(100) DEFAULT '' NOT NULL,
  313. label varchar(255) DEFAULT '' NOT NULL,
  314. PRIMARY KEY (uid),
  315. KEY parent (pid)
  316. );