CREATE TABLE IF NOT EXISTS `settings` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`site_name` varchar(255) DEFAULT NULL,
`site_tagline` varchar(255) DEFAULT NULL,
`site_banner_id` int(11) DEFAULT NULL,
`site_email` varchar(120) DEFAULT NULL,
`site_key` varchar(100) DEFAULT NULL,
`site_language` varchar(10) NOT NULL DEFAULT 'en_US',
`site_style` varchar(50) NOT NULL DEFAULT 'default',
`site_timezone` varchar(80) DEFAULT NULL,
`site_contact_page` tinyint(4) NOT NULL DEFAULT '1',
`site_help_page` tinyint(4) NOT NULL DEFAULT '1',
`site_message` text NOT NULL,
`site_copyright_statement` text,
`site_submit_report_message` text NOT NULL,
`allow_reports` tinyint(4) NOT NULL DEFAULT '1',
`allow_comments` tinyint(4) NOT NULL DEFAULT '1',
`allow_feed` tinyint(4) NOT NULL DEFAULT '1',
`allow_stat_sharing` tinyint(4) NOT NULL DEFAULT '1',
`allow_clustering` tinyint(4) NOT NULL DEFAULT '0',
`cache_pages` tinyint(4) NOT NULL DEFAULT '0',
`cache_pages_lifetime` int(4) NOT NULL DEFAULT '1800',
`private_deployment` tinyint(4) NOT NULL DEFAULT '0',
`default_map` varchar(100) NOT NULL DEFAULT 'osm_mapnik',
`default_map_all` varchar(20) NOT NULL DEFAULT 'CC0000',
`default_map_all_icon_id` int(11) DEFAULT NULL,
`api_google` varchar(200) DEFAULT NULL,
`api_live` varchar(200) DEFAULT NULL,
`api_akismet` varchar(200) DEFAULT NULL,
`default_country` int(11) DEFAULT NULL,
`multi_country` tinyint(4) NOT NULL DEFAULT '0',
`default_city` varchar(150) DEFAULT NULL,
`default_lat` varchar(100) DEFAULT NULL,
`default_lon` varchar(100) DEFAULT NULL,
`default_zoom` tinyint(4) NOT NULL DEFAULT '10',
`items_per_page` smallint(6) NOT NULL DEFAULT '5',
`items_per_page_admin` smallint(6) NOT NULL DEFAULT '20',
`sms_provider` varchar(100) DEFAULT NULL,
`sms_no1` varchar(100) DEFAULT NULL,
`sms_no2` varchar(100) DEFAULT NULL,
`sms_no3` varchar(100) DEFAULT NULL,
`google_analytics` text,
`twitter_hashtags` text,
`blocks` text,
`blocks_per_row` tinyint(4) NOT NULL DEFAULT '2',
`date_modify` datetime DEFAULT NULL,
`stat_id` bigint(20) DEFAULT NULL COMMENT 'comes from centralized stats',
`stat_key` varchar(30) NOT NULL,
`email_username` varchar(100) NOT NULL,
`email_password` varchar(100) NOT NULL,
`email_port` int(11) NOT NULL,
`email_host` varchar(100) NOT NULL,
`email_servertype` varchar(100) NOT NULL,
`email_ssl` int(5) NOT NULL,
`ftp_server` varchar(100) DEFAULT NULL,
`ftp_user_name` varchar(100) DEFAULT NULL,
`alerts_email` varchar(120) NOT NULL,
`checkins` tinyint(4) NOT NULL DEFAULT '0',
`facebook_appid` varchar(150) DEFAULT NULL,
`facebook_appsecret` varchar(150) DEFAULT NULL,
`allow_alerts` tinyint(4) NOT NULL DEFAULT '0',
`manually_approve_users` tinyint(4) NOT NULL DEFAULT '0',
`require_email_confirmation` tinyint(4) NOT NULL DEFAULT '0',
`db_version` varchar(20) DEFAULT NULL,
`ushahidi_version` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores a deployment’s general settings' AUTO_INCREMENT=2 ;
|