ext_tables.sql 3.59 KB
Newer Older
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

#
# Table structure for table 'tx_ter_extensionkeys'
#
CREATE TABLE tx_ter_extensionkeys ( 
  uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
  pid int(11) unsigned DEFAULT '0' NOT NULL,
  tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  crdate int(11) unsigned DEFAULT '0' NOT NULL,
  title varchar(50) DEFAULT '' NOT NULL,
  description text NOT NULL,
  extensionkey varchar(30) DEFAULT '' NOT NULL,
  ownerusername varchar(30) DEFAULT '' NOT NULL,
  maxstoresize int(11) DEFAULT '0' NOT NULL,
  downloadcounter int(11) DEFAULT '0' NOT NULL,

  PRIMARY KEY (uid),
  KEY extkey (extensionkey,pid),
  KEY exttitle (title,pid)
);

#
# Table structure for table 'tx_ter_extensionmembers'
#
CREATE TABLE tx_ter_extensionmembers ( 
  uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
  pid int(11) DEFAULT '0' NOT NULL,
  extensionkey varchar(30) DEFAULT '' NOT NULL,
  username varchar(30) DEFAULT '' NOT NULL,

  PRIMARY KEY (uid),
  KEY extkey (extensionkey),
  KEY usern (username)
);


#
# Table structure for table 'tx_ter_extensions'
#
CREATE TABLE tx_ter_extensions (
  uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
  pid int(11) DEFAULT '0' NOT NULL,
  tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  crdate int(11) unsigned DEFAULT '0' NOT NULL,
  extensionkey varchar(30) DEFAULT '' NOT NULL,
  version varchar(11) DEFAULT '' NOT NULL,
  title varchar(50) DEFAULT '' NOT NULL,
  description text NOT NULL,
  state varchar(15) DEFAULT '' NOT NULL,
  reviewstate int(11) DEFAULT '0' NOT NULL,
  category varchar(30) DEFAULT '' NOT NULL,
  downloadcounter int(11) DEFAULT '0' NOT NULL,
  ismanualincluded int(11) DEFAULT '0' NOT NULL,
  t3xfilemd5 varchar(32) DEFAULT '' NOT NULL,
  
  PRIMARY KEY (uid),
  KEY extkey (extensionkey,pid),
  KEY extcat (category,pid),
  KEY exttitle (title,pid)
);

#
# Table structure for table 'tx_ter_extensiondetails'
#
CREATE TABLE tx_ter_extensiondetails (
  uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
  pid int(11) unsigned DEFAULT '0' NOT NULL,
  extensionuid int(11) unsigned DEFAULT '0' NOT NULL,
  uploadcomment varchar(255) DEFAULT '' NOT NULL,
  lastuploadbyusername varchar(30) DEFAULT '0' NOT NULL,
  lastuploaddate int(11) DEFAULT '0' NOT NULL,
  datasize int(11) DEFAULT '0' NOT NULL,
  datasizecompressed int(11) DEFAULT '0' NOT NULL,
  files text NOT NULL,
  codelines int(11) DEFAULT '0' NOT NULL,
  codebytes int(11) DEFAULT '0' NOT NULL,
  techinfo text NOT NULL,
  composerinfo text NOT NULL,
  shy tinyint(4) DEFAULT '0' NOT NULL,
  dependencies text NOT NULL,
  createdirs text NOT NULL,
  priority varchar(10) DEFAULT '' NOT NULL,
  modules tinytext NOT NULL,
  uploadfolder tinyint(4) DEFAULT '0' NOT NULL,
  modifytables tinytext NOT NULL,
  clearcacheonload tinyint(4) DEFAULT '0' NOT NULL,
  locktype char(1) DEFAULT '' NOT NULL,
  authorname tinytext NOT NULL,
  authoremail tinytext NOT NULL,
  authorcompany tinytext NOT NULL,
  codingguidelinescompliance varchar(10) DEFAULT '' NOT NULL,
  codingguidelinescompliancenote tinytext NOT NULL,
  loadorder tinytext NOT NULL,
  
  PRIMARY KEY (uid),
  KEY extuid (extensionuid)
);  

#
# Table structure for table 'tx_ter_extensionqueue'
#
CREATE TABLE tx_ter_extensionqueue (
  uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
  pid int(11) DEFAULT '0' NOT NULL,
  extensionkey varchar(30) DEFAULT '' NOT NULL,
  extensionuid int(11) DEFAULT '0' NOT NULL,
  deleted tinyint(4) DEFAULT '0' NOT NULL,
  tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  crdate int(11) unsigned DEFAULT '0' NOT NULL,
  imported_to_fe tinyint(4) DEFAULT '0' NOT NULL,

  PRIMARY KEY (uid),
  KEY imported (imported_to_fe)
);