Changeset 99807 in spip-zone for _plugins_/albums
- Timestamp:
- Oct 4, 2016, 12:48:16 PM (5 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
_plugins_/albums/trunk/base/albums.php
r86340 r99807 11 11 12 12 // Sécurité 13 if (!defined('_ECRIRE_INC_VERSION')) return; 13 if (!defined('_ECRIRE_INC_VERSION')) { 14 return; 15 } 14 16 15 17 … … 40 42 * Description complétée des tables 41 43 */ 42 function albums_declarer_tables_objets_sql($tables) {44 function albums_declarer_tables_objets_sql($tables) { 43 45 44 46 /* ALBUMS */ 45 47 $tables['spip_albums'] = array( 46 'type' => "album",47 'principale' => "oui",48 'type' => 'album', 49 'principale' => 'oui', 48 50 'field'=> array( 49 "id_album" => "bigint(21) NOT NULL",50 "titre"=> "text DEFAULT '' NOT NULL",51 "descriptif"=> "text DEFAULT '' NOT NULL",52 "date"=> "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",53 "statut"=> "varchar(10) DEFAULT '' NOT NULL",54 "lang"=> "VARCHAR(10) DEFAULT '' NOT NULL",55 "langue_choisie"=> "VARCHAR(3) DEFAULT 'non'",56 "id_trad"=> "bigint(21) DEFAULT '0' NOT NULL",57 "maj" => "TIMESTAMP"51 'id_album' => 'bigint(21) NOT NULL', 52 'titre' => "text DEFAULT '' NOT NULL", 53 'descriptif' => "text DEFAULT '' NOT NULL", 54 'date' => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL", 55 'statut' => "varchar(10) DEFAULT '' NOT NULL", 56 'lang' => "VARCHAR(10) DEFAULT '' NOT NULL", 57 'langue_choisie' => "VARCHAR(3) DEFAULT 'non'", 58 'id_trad' => "bigint(21) DEFAULT '0' NOT NULL", 59 'maj' => 'TIMESTAMP' 58 60 ), 59 61 'key' => array( 60 "PRIMARY KEY" => "id_album",61 "KEY lang" => "lang",62 "KEY id_trad" => "id_trad",63 "KEY statut" => "statut",62 'PRIMARY KEY' => 'id_album', 63 'KEY lang' => 'lang', 64 'KEY id_trad' => 'id_trad', 65 'KEY statut' => 'statut', 64 66 ), 65 'titre' => "titre, lang AS lang",66 'date' => "date",67 'titre' => 'titre, lang AS lang', 68 'date' => 'date', 67 69 'champs_editables' => array('titre', 'descriptif'), 68 70 'champs_versionnes' => array('titre', 'descriptif'), … … 113 115 $tables['spip_albums_liens'] = array( 114 116 'field' => array( 115 "id_album"=> "bigint(21) DEFAULT '0' NOT NULL",116 "id_objet"=> "bigint(21) DEFAULT '0' NOT NULL",117 "objet"=> "VARCHAR (25) DEFAULT '' NOT NULL",118 "vu"=> "ENUM('non', 'oui') DEFAULT 'non' NOT NULL"117 'id_album' => "bigint(21) DEFAULT '0' NOT NULL", 118 'id_objet' => "bigint(21) DEFAULT '0' NOT NULL", 119 'objet' => "VARCHAR (25) DEFAULT '' NOT NULL", 120 'vu' => "ENUM('non', 'oui') DEFAULT 'non' NOT NULL" 119 121 ), 120 122 'key' => array( 121 "PRIMARY KEY" => "id_album,id_objet,objet",122 "KEY id_album" => "id_album",123 'PRIMARY KEY' => 'id_album,id_objet,objet', 124 'KEY id_album' => 'id_album', 123 125 ) 124 126 ); … … 126 128 return $tables; 127 129 } 128 129 ?>
Note: See TracChangeset
for help on using the changeset viewer.