Changeset 12192 for extensions/Copyrights/maintain.inc.php
- Timestamp:
- Sep 20, 2011, 8:11:51 PM (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/Copyrights/maintain.inc.php
r11844 r12192 3 3 // | Piwigo - a PHP based picture gallery | 4 4 // +-----------------------------------------------------------------------+ 5 // | Copyright(C) 2008-20 09Piwigo Team http://piwigo.org |5 // | Copyright(C) 2008-2011 Piwigo Team http://piwigo.org | 6 6 // | Copyright(C) 2003-2008 PhpWebGallery Team http://phpwebgallery.net | 7 7 // | Copyright(C) 2002-2003 Pierrick LE GALL http://le-gall.net/pierrick | … … 23 23 24 24 function plugin_install() { 25 global $conf,$prefixeTable;26 $query = " 27 CREATE TABLE IF NOT EXISTS ".$prefixeTable."copyrights_admin (28 29 30 31 32 33 34 35 ;";36 25 global $prefixeTable; 26 $query = ' 27 CREATE TABLE IF NOT EXISTS '.$prefixeTable.'copyrights_admin ( 28 cr_id int(11) NOT NULL AUTO_INCREMENT, 29 name varchar(255) UNIQUE NOT NULL, 30 url varchar(255) NOT NULL, 31 descr text DEFAULT NULL, 32 visible bool DEFAULT 0, 33 PRIMARY KEY (cr_id) 34 ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8 35 ;'; 36 pwg_query($query); 37 37 38 $query = "39 CREATE TABLE IF NOT EXISTS ".$prefixeTable."copyrights_media (38 $query = ' 39 CREATE TABLE IF NOT EXISTS '.$prefixeTable.'copyrights_media ( 40 40 media_id int(11) NOT NULL, 41 41 cr_id int(11) NOT NULL, 42 42 PRIMARY KEY (media_id) 43 43 ) ENGINE = MyISAM DEFAULT CHARACTER SET utf8 44 ; ";44 ;'; 45 45 pwg_query($query); 46 46 } … … 62 62 global $prefixeTable; 63 63 64 $query = "65 DROP TABLE ".$prefixeTable."copyrights_admin66 ; ";64 $query = ' 65 DROP TABLE '.$prefixeTable.'copyrights_admin 66 ;'; 67 67 pwg_query($query); 68 68 69 $query = "70 DROP TABLE ".$prefixeTable."copyrights_media71 ; ";69 $query = ' 70 DROP TABLE '.$prefixeTable.'copyrights_media 71 ;'; 72 72 pwg_query($query); 73 73 }
Note: See TracChangeset
for help on using the changeset viewer.