29 lines
788 B
PHP
29 lines
788 B
PHP
<?php
|
|
|
|
namespace Zotlabs\Update;
|
|
|
|
class _1030 {
|
|
function run() {
|
|
$r = q("CREATE TABLE IF NOT EXISTS `issue` (
|
|
`issue_id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
|
|
`issue_created` DATETIME NOT NULL DEFAULT '0001-01-01 00:00:00',
|
|
`issue_updated` DATETIME NOT NULL DEFAULT '0001-01-01 00:00:00',
|
|
`issue_assigned` CHAR( 255 ) NOT NULL ,
|
|
`issue_priority` INT NOT NULL ,
|
|
`issue_status` INT NOT NULL ,
|
|
`issue_component` CHAR( 255 ) NOT NULL,
|
|
KEY `issue_created` (`issue_created`),
|
|
KEY `issue_updated` (`issue_updated`),
|
|
KEY `issue_assigned` (`issue_assigned`),
|
|
KEY `issue_priority` (`issue_priority`),
|
|
KEY `issue_status` (`issue_status`),
|
|
KEY `issue_component` (`issue_component`)
|
|
) ENGINE = MYISAM DEFAULT CHARSET=utf8");
|
|
|
|
if($r)
|
|
return UPDATE_SUCCESS;
|
|
return UPDATE_FAILED;
|
|
}
|
|
|
|
|
|
} |