gistfile1.sql

CREATE TABLE `party`
(
    `party_id` INTEGER NOT NULL AUTO_INCREMENT COMMENT 'Party ID',
    `first_name` VARCHAR(128) COMMENT 'First Name',
    `middle_name` VARCHAR(128) COMMENT 'Middle Name',
    `last_name` VARCHAR(128) COMMENT 'Last Name',
    `prefix` VARCHAR(64) COMMENT 'Prefix',
    `suffix` VARCHAR(64) COMMENT 'Suffix',
    `birthday` DATETIME COMMENT 'Birthday',
    `gender` VARCHAR(32),
    `timezone` VARCHAR(3) COMMENT 'Timezone',
    `url` VARCHAR(255) COMMENT 'URL',
    `organization_name` VARCHAR(255) COMMENT 'Organization Name',
    `is_company` TINYINT(1) DEFAULT 0 COMMENT 'Is Company',
    `title` VARCHAR(128) COMMENT 'Title',
    `telephone` VARCHAR(32) COMMENT 'Telephone',
    `email` VARCHAR(255) COMMENT 'Email',
    `twitter` VARCHAR(255) COMMENT 'twitter',
    `facebook` VARCHAR(255) COMMENT 'Facebook',
    `agreed_to_tc` TINYINT(1) DEFAULT 0 NOT NULL,
    `opt_in_to_mailing` TINYINT(1) DEFAULT 0 NOT NULL,
    `note` LONGTEXT COMMENT 'Note',
    `created_at` DATETIME,
    `updated_at` DATETIME,
    PRIMARY KEY (`party_id`),
    UNIQUE INDEX `party_U_1` (`email`)
) ENGINE=InnoDB COMMENT='Party Table';