t3ext-pubdb/ext_tables.sql at master · twaurisch/t3ext-pubdb · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
# TYPO3 Extension Manager dump 1.1
#
# Host: localhost    Database: typo3_argesim
#--------------------------------------------------------


#
# Table structure for table "tx_pubdb_data_category_mm"
#
CREATE TABLE tx_pubdb_data_category_mm (
  uid_local int(11) default '0',
  uid_foreign int(11) default '0',
  tablenames varchar(30) default '',
  sorting int(11) default '0',
  KEY uid_local (uid_local),
  KEY uid_foreign (uid_foreign)
);


#
# Table structure for table "tx_pubdb_category_fegroups_mm"
#
CREATE TABLE tx_pubdb_category_fegroups_mm (
  uid_local int(11) default '0',
  uid_foreign int(11) default '0',
  tablenames varchar(30) default '',
  sorting int(11) default '0',
  KEY uid_local (uid_local),
  KEY uid_foreign (uid_foreign)
);


#
# Table structure for table "tx_pubdb_data"
#
CREATE TABLE tx_pubdb_data (
  uid int(11) auto_increment,
  pid int(11) default '0',
  tstamp int(11) default '0',
  crdate int(11) default '0',
  cruser_id int(11) default '0',
  deleted tinyint(4) default '0',
  hidden tinyint(4) default '0',
  title tinytext,
  abbrev_title tinytext,
  author tinytext,
  author_email tinytext,
  author_address tinytext,
  coauthors tinytext,
  pubtype tinytext,
  subpubtype tinytext,
  year int(11) default '0',
  series tinytext,
  number tinytext,
  issue tinytext,
  pages tinytext,
  isbn tinytext,
  isbn2 tinytext,
  media_type tinytext,
  doi tinytext,
  internalNumber tinytext,
  file blob,
  fileType int(11) default '0',
  openFile blob,
  openFileType int(11) default '0',
  category int(11) default '0',
  abstract text,
  subtitle tinytext,
  publisher tinytext,
  location tinytext,
  hashardcopy int(11) default '0',
  price tinytext,
  reducedprice tinytext,
  parent_pubid int(11) default '0',
  hascrossrefentry int(11) default '0',
  sponsors tinytext,
  startdate tinytext,
  enddate tinytext,
  contributors int(11) default '0',
  theme tinytext,
  booktype tinytext,
  edition int(11) default '0',
  PRIMARY KEY (uid),
  KEY parent (pid)
);


#
# Table structure for table "tx_pubdb_categories"
#
CREATE TABLE tx_pubdb_categories (
  uid int(11) auto_increment,
  pid int(11) default '0',
  tstamp int(11) default '0',
  crdate int(11) default '0',
  cruser_id int(11) default '0',
  deleted tinyint(4) default '0',
  hidden tinyint(4) default '0',
  name tinytext,
  pub blob,
  publications int(11) default '0',
  fegroup int(11) default '0',
  PRIMARY KEY (uid),
  KEY parent (pid)
);


create TABLE tx_pubdb_contributors (
	uid int(11) auto_increment,
 	pid int(11) default '0',
	tstamp int(11) default '0',
	crdate int(11) default '0',
	cruser_id int(11) default '0',
	deleted tinyint(4) default '0',
	hidden tinyint(4) default '0',
	organization tinytext,
	surname tinytext,
	given_name tinytext,
	suffix tinytext,
	affiliation tinytext,
	orcid tinytext,
	contributor_type tinytext,
	pubids int(11) default '0',
	showinlist int(11) default '0',
	PRIMARY KEY (uid),
	KEY parent (pid)
);
#
#	Intermediate table for N:M relations between publications and contributors with extra fields
#
create TABLE tx_pubdb_pub_contributors (
	uid int(11) auto_increment,
 	pid int(11) default '0',
	tstamp int(11) default '0',
	crdate int(11) default '0',
	cruser_id int(11) default '0',
	deleted tinyint(4) default '0',
	hidden tinyint(4) default '0',
	pubid int(11) default '0',
	contributorid int(11) default '0',
	role tinytext,
	pubsort int(10) DEFAULT '0' NOT NULL,
	contributorsort int(10) DEFAULT '0' NOT NULL,
	PRIMARY KEY (uid),
	KEY parent (pid)
);

#
# Table structure for table 'tt_news'
#
CREATE TABLE tt_news (
        tx_pubdb_link_title tinytext,
	tx_pubdb_newslink int(11) DEFAULT '0' NOT NULL
);