ext_tables.sql 8.51 KB
Newer Older
1 2 3 4
# ======================================================================
# Table configuration for table "tx_terfe2_domain_model_extension"
# ======================================================================
CREATE TABLE tx_terfe2_domain_model_extension (
5 6 7 8 9
  uid int(11) NOT NULL auto_increment,
  pid int(11) DEFAULT '0' NOT NULL,

  ext_key tinytext,
  forge_link tinytext,
10
  composer_name varchar(60) DEFAULT '' NOT NULL,
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
  last_upload int(11) unsigned DEFAULT '0',
  last_maintained int(11) unsigned DEFAULT '0',
  tags int(11) unsigned DEFAULT '0' NOT NULL,
  versions int(11) unsigned DEFAULT '0' NOT NULL,
  last_version int(11) unsigned DEFAULT '0' NOT NULL,
  frontend_user tinytext,
  downloads int(11) unsigned DEFAULT '0' NOT NULL,
  repository_url varchar(255) DEFAULT '' NOT NULL,
  external_manual varchar(255) DEFAULT '' NOT NULL,
  paypal_url varchar(255) DEFAULT '' NOT NULL,
  expire int(11) unsigned default '0' NOT NULL,

  tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  crdate int(11) unsigned DEFAULT '0' NOT NULL,
  deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
  hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,

  t3ver_oid int(11) DEFAULT '0' NOT NULL,
  t3ver_id int(11) DEFAULT '0' NOT NULL,
  t3ver_wsid int(11) DEFAULT '0' NOT NULL,
  t3ver_label varchar(30) DEFAULT '' NOT NULL,
  t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
  t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
  t3ver_count int(11) DEFAULT '0' NOT NULL,
  t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
  t3_origuid int(11) DEFAULT '0' NOT NULL,

  sys_language_uid int(11) DEFAULT '0' NOT NULL,
  l18n_parent int(11) DEFAULT '0' NOT NULL,
  l18n_diffsource mediumblob NOT NULL,

  PRIMARY KEY (uid),
  KEY parent (pid)
44 45 46 47 48 49
);

# ======================================================================
# Table configuration for table "tx_terfe2_domain_model_tag"
# ======================================================================
CREATE TABLE tx_terfe2_domain_model_tag (
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
  uid int(11) NOT NULL auto_increment,
  pid int(11) DEFAULT '0' NOT NULL,

  extensions int(11) unsigned DEFAULT '0' NOT NULL,
  title tinytext,

  tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  crdate int(11) unsigned DEFAULT '0' NOT NULL,
  deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
  hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,

  t3ver_oid int(11) DEFAULT '0' NOT NULL,
  t3ver_id int(11) DEFAULT '0' NOT NULL,
  t3ver_wsid int(11) DEFAULT '0' NOT NULL,
  t3ver_label varchar(30) DEFAULT '' NOT NULL,
  t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
  t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
  t3ver_count int(11) DEFAULT '0' NOT NULL,
  t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
  t3_origuid int(11) DEFAULT '0' NOT NULL,

  sys_language_uid int(11) DEFAULT '0' NOT NULL,
  l18n_parent int(11) DEFAULT '0' NOT NULL,
  l18n_diffsource mediumblob NOT NULL,

  PRIMARY KEY (uid),
  KEY parent (pid)
77 78 79 80 81 82
);

# ======================================================================
# Table configuration for table "tx_terfe2_domain_model_version"
# ======================================================================
CREATE TABLE tx_terfe2_domain_model_version (
83 84 85 86 87 88 89 90 91 92 93
  uid int(11) NOT NULL auto_increment,
  pid int(11) DEFAULT '0' NOT NULL,

  extension int(11) unsigned DEFAULT '0' NOT NULL,
  title tinytext,
  description text,
  file_hash varchar(50) DEFAULT '' NOT NULL,
  author int(11) DEFAULT '0' NOT NULL,
  version_number int(11) DEFAULT '0' NOT NULL,
  version_string tinytext,
  upload_date int(11) DEFAULT '0' NOT NULL,
94
  upload_comment longtext,
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
  download_counter int(11) DEFAULT '0' NOT NULL,
  frontend_download_counter int(11) DEFAULT '0' NOT NULL,
  state tinytext,
  em_category tinytext,
  load_order tinytext,
  priority tinytext,
  shy tinyint(4) unsigned DEFAULT '0' NOT NULL,
  internal tinyint(4) unsigned DEFAULT '0' NOT NULL,
  do_not_load_in_fe tinyint(4) unsigned DEFAULT '0' NOT NULL,
  uploadfolder tinyint(4) unsigned DEFAULT '0' NOT NULL,
  clear_cache_on_load tinyint(4) unsigned DEFAULT '0' NOT NULL,
  module tinytext,
  create_dirs tinytext,
  modify_tables tinytext,
  lock_type tinytext,
  cgl_compliance tinytext,
  cgl_compliance_note text,
  review_state int(11) DEFAULT '0' NOT NULL,
  manual tinytext,
  has_manual tinyint(4) unsigned DEFAULT '0' NOT NULL,
  software_relations int(11) unsigned DEFAULT '0' NOT NULL,
  extension_provider tinytext,
  has_zip_file tinyint(4) unsigned DEFAULT '0' NOT NULL,
  has_images tinyint(4) unsigned DEFAULT '0' NOT NULL,
  t3x_file_size bigint(15) unsigned DEFAULT '0' NOT NULL,
  zip_file_size bigint(15) unsigned DEFAULT '0' NOT NULL,
121
  composer_info text NOT NULL,
122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144

  tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  crdate int(11) unsigned DEFAULT '0' NOT NULL,
  deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
  hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,

  t3ver_oid int(11) DEFAULT '0' NOT NULL,
  t3ver_id int(11) DEFAULT '0' NOT NULL,
  t3ver_wsid int(11) DEFAULT '0' NOT NULL,
  t3ver_label varchar(30) DEFAULT '' NOT NULL,
  t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
  t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
  t3ver_count int(11) DEFAULT '0' NOT NULL,
  t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
  t3_origuid int(11) DEFAULT '0' NOT NULL,

  sys_language_uid int(11) DEFAULT '0' NOT NULL,
  l18n_parent int(11) DEFAULT '0' NOT NULL,
  l18n_diffsource mediumblob NOT NULL,

  PRIMARY KEY (uid),
  KEY parent (pid),
  KEY author (author)
145 146 147 148 149 150
);

# ======================================================================
# Table configuration for table "tx_terfe2_domain_model_relation"
# ======================================================================
CREATE TABLE tx_terfe2_domain_model_relation (
151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181
  uid int(11) NOT NULL auto_increment,
  pid int(11) DEFAULT '0' NOT NULL,

  version int(11) unsigned DEFAULT '0' NOT NULL,
  relation_type tinytext,
  relation_key tinytext,
  minimum_version int(11) unsigned DEFAULT '0' NOT NULL,
  maximum_version int(11) unsigned DEFAULT '0' NOT NULL,
  related_extension int(11) unsigned DEFAULT '0' NOT NULL,

  tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  crdate int(11) unsigned DEFAULT '0' NOT NULL,
  deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
  hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,

  t3ver_oid int(11) DEFAULT '0' NOT NULL,
  t3ver_id int(11) DEFAULT '0' NOT NULL,
  t3ver_wsid int(11) DEFAULT '0' NOT NULL,
  t3ver_label varchar(30) DEFAULT '' NOT NULL,
  t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
  t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
  t3ver_count int(11) DEFAULT '0' NOT NULL,
  t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
  t3_origuid int(11) DEFAULT '0' NOT NULL,

  sys_language_uid int(11) DEFAULT '0' NOT NULL,
  l18n_parent int(11) DEFAULT '0' NOT NULL,
  l18n_diffsource mediumblob NOT NULL,

  PRIMARY KEY (uid),
  KEY parent (pid)
182 183
);

speedprogs_de's avatar
speedprogs_de committed
184 185 186 187
# ======================================================================
# Table configuration for table "tx_terfe2_domain_model_author"
# ======================================================================
CREATE TABLE tx_terfe2_domain_model_author (
188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220
  uid int(11) NOT NULL auto_increment,
  pid int(11) DEFAULT '0' NOT NULL,

  name tinytext,
  email tinytext,
  company tinytext,
  forge_link tinytext,
  username tinytext,
  versions int(11) unsigned DEFAULT '0' NOT NULL,
  frontend_user int(11) unsigned DEFAULT '0' NOT NULL,
  author_type int(11) unsigned DEFAULT '0' NOT NULL,

  tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  crdate int(11) unsigned DEFAULT '0' NOT NULL,
  deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
  hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,

  t3ver_oid int(11) DEFAULT '0' NOT NULL,
  t3ver_id int(11) DEFAULT '0' NOT NULL,
  t3ver_wsid int(11) DEFAULT '0' NOT NULL,
  t3ver_label varchar(30) DEFAULT '' NOT NULL,
  t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
  t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
  t3ver_count int(11) DEFAULT '0' NOT NULL,
  t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
  t3_origuid int(11) DEFAULT '0' NOT NULL,

  sys_language_uid int(11) DEFAULT '0' NOT NULL,
  l18n_parent int(11) DEFAULT '0' NOT NULL,
  l18n_diffsource mediumblob NOT NULL,

  PRIMARY KEY (uid),
  KEY parent (pid)
speedprogs_de's avatar
speedprogs_de committed
221 222
);

223 224 225 226
# ======================================================================
# Table configuration for table "tx_terfe2_extension_tag_mm"
# ======================================================================
CREATE TABLE tx_terfe2_extension_tag_mm (
227 228 229 230
  uid_local int(10) unsigned DEFAULT '0' NOT NULL,
  uid_foreign int(10) unsigned DEFAULT '0' NOT NULL,
  sorting int(10) unsigned DEFAULT '0' NOT NULL,
  sorting_foreign int(10) unsigned DEFAULT '0' NOT NULL,
231

232 233
  KEY uid_local (uid_local),
  KEY uid_foreign (uid_foreign)
234
);