47 lines
2.6 KiB
PHP
47 lines
2.6 KiB
PHP
|
<?php
|
||
|
|
|
||
|
|
$SQL = "CREATE TABLE fwc_recreational_licenses (
|
||
|
|
|
||
|
|
license_serial BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
|
|
license_source_file VARCHAR(100) NOT NULL DEFAULT '',
|
||
|
|
|
||
|
|
license_last_name VARCHAR(100) NOT NULL DEFAULT '',
|
||
|
|
license_first_name VARCHAR(100) NOT NULL DEFAULT '',
|
||
|
|
license_middle_name VARCHAR(100) NOT NULL DEFAULT '',
|
||
|
|
|
||
|
|
license_street1 VARCHAR(255) NOT NULL DEFAULT '',
|
||
|
|
license_city VARCHAR(100) NOT NULL DEFAULT '',
|
||
|
|
license_state VARCHAR(50) NOT NULL DEFAULT '',
|
||
|
|
license_zip_code VARCHAR(20) NOT NULL DEFAULT '',
|
||
|
|
|
||
|
|
license_phone_number VARCHAR(30) NOT NULL DEFAULT '',
|
||
|
|
license_email_address VARCHAR(150) NOT NULL DEFAULT '',
|
||
|
|
|
||
|
|
license_gender VARCHAR(50) NOT NULL DEFAULT '',
|
||
|
|
license_ethnicity VARCHAR(100) NOT NULL DEFAULT '',
|
||
|
|
|
||
|
|
license_type VARCHAR(255) NOT NULL DEFAULT '',
|
||
|
|
|
||
|
|
license_expire_date DATETIME NULL,
|
||
|
|
license_start_date DATETIME NULL,
|
||
|
|
|
||
|
|
license_age_at_time_of_run INT UNSIGNED NULL,
|
||
|
|
license_county VARCHAR(100) NOT NULL DEFAULT '',
|
||
|
|
|
||
|
|
import_batch_code CHAR(36) NOT NULL DEFAULT '',
|
||
|
|
imported_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
|
||
|
|
PRIMARY KEY (license_serial),
|
||
|
|
|
||
|
|
KEY idx_source_file (license_source_file),
|
||
|
|
KEY idx_name (license_last_name, license_first_name, license_middle_name),
|
||
|
|
KEY idx_license_type (license_type),
|
||
|
|
KEY idx_expire_date (license_expire_date),
|
||
|
|
KEY idx_start_date (license_start_date),
|
||
|
|
KEY idx_county (license_county),
|
||
|
|
KEY idx_email (license_email_address),
|
||
|
|
KEY idx_import_batch (import_batch_code))
|
||
|
|
|
||
|
|
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4";
|
||
|
|
?>
|