diff --git a/protected/data/database-schema.sql b/protected/data/database-schema.sql index 982c8f0e..5baa86e0 100644 --- a/protected/data/database-schema.sql +++ b/protected/data/database-schema.sql @@ -1,43 +1,43 @@ SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; CREATE TABLE IF NOT EXISTS `account_security` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` varchar(255) NOT NULL, `event_count` int(11) NOT NULL, `last_event` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `developer_applications` ( `id` int(11) NOT NULL AUTO_INCREMENT, `status` int(1) NOT NULL, `uid` varchar(64) NOT NULL, `supporter_uid` varchar(64) NOT NULL, `special_reason` tinyint(1) NOT NULL, `justification` text NOT NULL, `evidence_links` text NOT NULL, `ssh_key` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; CREATE TABLE IF NOT EXISTS `tokens` ( `id` int(11) NOT NULL AUTO_INCREMENT, `token` varchar(50) NOT NULL, `type` int(1) NOT NULL, - `mail` varchar(255) NOT NULL, - `uid` varchar(255) NOT NULL, - `givenName` varchar(255) NOT NULL, - `sn` varchar(255) NOT NULL, + `mail` varchar(255) NOT NULL DEFAULT '', + `uid` varchar(255) NOT NULL DEFAULT '', + `givenName` varchar(255) NOT NULL DEFAULT '', + `sn` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;