Home

Welcome to the Maryland wiki!

Information on database setup for install

CREATE TABLE `signatures` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `VTRID` int(11) NOT NULL,
  `VoterList_table` varchar(50) NOT NULL DEFAULT 'VoterList',
  `ip_address` varchar(200) NOT NULL,
  `date_of_birth` varchar(200) NOT NULL,
  `date_time_signed` datetime NOT NULL,
  `just_date` date NOT NULL,
  `petition_id` int(11) NOT NULL,
  `signed_name_as` varchar(250) NOT NULL,
  `signed_name_as_circulator` varchar(250) NOT NULL,
  `contact_phone` varchar(250) NOT NULL,
  `shared_email` varchar(300) NOT NULL,
  `signature_status` varchar(250) NOT NULL,
  `printed_status` varchar(250) NOT NULL,
  `bot_check` text NOT NULL,
  `php_session_id` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10519 DEFAULT CHARSET=latin1


CREATE TABLE `presign` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_on` varchar(100) NOT NULL,
  `only_date` date NOT NULL,
  `php_session_id` varchar(300) NOT NULL,
  `php_page` varchar(300) NOT NULL,
  `name` varchar(200) NOT NULL,
  `petition` varchar(200) NOT NULL,
  `invite` varchar(200) NOT NULL,
  `invite_error` varchar(200) NOT NULL,
  `email_for_follow_up` varchar(200) NOT NULL,
  `phone_for_validation` varchar(200) NOT NULL,
  `presign_status` varchar(200) DEFAULT 'NEW',
  `ip_address` varchar(300) NOT NULL,
  `browser_string` varchar(300) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `email_for_follow_up` (`email_for_follow_up`),
  KEY `php_page` (`php_page`),
  KEY `only_date` (`only_date`)
) ENGINE=InnoDB AUTO_INCREMENT=276815 DEFAULT CHARSET=latin1


CREATE TABLE `follow_up` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `email` varchar(300) NOT NULL,
  `php_session` varchar(300) NOT NULL,
  `status` varchar(300) NOT NULL DEFAULT 'NEW',
  `petition_id` int(10) NOT NULL,
  `feedback_message` text NOT NULL,
  `system_response` text NOT NULL,
  `date_sent` date NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=3104 DEFAULT CHARSET=latin1