<?php
//Installation
function calendar_install () {
global $wpdb;
$table_name = $wpdb->prefix . "bontivCalendar";
if($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name) {
$sql = "
CREATE TABLE IF NOT EXISTS `$table_name` (
`event_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` tinytext NOT NULL,
`dateStart` datetime NOT NULL,
`dateEnd` datetime DEFAULT NULL,
`categorie` varchar(60) DEFAULT NULL,
`text` text NOT NULL,
`lien` tinytext DEFAULT NULL,
PRIMARY KEY (`event_id`),
KEY `dateStart` (`dateStart`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
dbDelta($sql);
}
}
function calendar_uninstall () {
global $wpdb;
echo "cousu";
$table_name = $wpdb->prefix . "bontivCalendar";
$sql = "DROP TABLE `$table_name`;";
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
$obj = dbDelta($sql);
}
?>