Changeset 10987 for extensions/typetags/maintain.inc.php
- Timestamp:
- May 22, 2011, 12:52:49 PM (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/typetags/maintain.inc.php
r9863 r10987 4 4 function plugin_install() 5 5 { 6 6 global $prefixeTable; 7 7 8 9 10 11 12 13 8 $query = 'SHOW FULL COLUMNS FROM ' . TAGS_TABLE . ';'; 9 $result = array_from_query($query, 'Field'); 10 if (!in_array('id_typetags', $result)) 11 { 12 pwg_query('ALTER TABLE '.TAGS_TABLE.' ADD COLUMN `id_typetags` SMALLINT(5)'); 13 } 14 14 15 16 17 18 19 20 21 22 23 24 15 $result = pwg_query('SHOW TABLES LIKE "' . $prefixeTable .'typetags"'); 16 if (!mysql_fetch_row($result)) 17 { 18 $q = 'CREATE TABLE '. $prefixeTable .'typetags( 19 id smallint(5) unsigned NOT NULL auto_increment, 20 name VARCHAR(255) NOT NULL, 21 color VARCHAR(255) NOT NULL, 22 PRIMARY KEY (id));'; 23 pwg_query($q); 24 } 25 25 } 26 26 27 27 function plugin_uninstall() 28 28 { 29 29 global $prefixeTable; 30 30 31 32 31 $q = ' ALTER TABLE '.TAGS_TABLE.' DROP COLUMN `id_typetags`'; 32 pwg_query( $q ); 33 33 34 35 34 $q = ' DROP TABLE '. $prefixeTable .'typetags;'; 35 pwg_query($q); 36 36 } 37 37
Note: See TracChangeset
for help on using the changeset viewer.