daily pastebin goal
7%
SHARE
TWEET

Untitled

a guest Oct 17th, 2017 54,234 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE `master_deeds` (
  2.   `NEW_IDN` bigint(20) NOT NULL,
  3.   `EXPORTED` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'This is used to determine what has not been exported yet',
  4.   `ID10` bigint(20) DEFAULT NULL,
  5.   `TITLE` varchar(20) DEFAULT NULL,
  6.   `FIRST_NAME` varchar(60) DEFAULT NULL,
  7.   `SURNAME` varchar(60) DEFAULT NULL,
  8.   `DECEASED_STATUS` varchar(20) DEFAULT NULL,
  9.   `CITIZENSHIP` varchar(20) DEFAULT NULL,
  10.   `GENDER` varchar(20) DEFAULT NULL,
  11.   `AGE_GROUP` varchar(20) DEFAULT NULL,
  12.   `POPULATION_GROUP` varchar(20) DEFAULT NULL,
  13.   `LOCATION` varchar(20) DEFAULT NULL,
  14.   `MARITAL_STATUS1` varchar(20) DEFAULT NULL,
  15.   `LSM_GROUP` varchar(20) DEFAULT NULL,
  16.   `ESTIMATED_INCOME` varchar(20) DEFAULT NULL,
  17.   `HOMEOWNERSHIP` varchar(20) DEFAULT NULL,
  18.   `DIRECTORSHIP1` varchar(20) DEFAULT NULL,
  19.   `CIV_NET` varchar(20) DEFAULT NULL,
  20.   `MOST_RECENT_PHYSICAL_ADDR_LINE1` varchar(100) DEFAULT NULL,
  21.   `MOST_RECENT_PHYSICAL_ADDR_LINE2` varchar(100) DEFAULT NULL,
  22.   `MOST_RECENT_PHYSICAL_ADDR_LINE3` varchar(100) DEFAULT NULL,
  23.   `MOST_RECENT_PHYSICAL_ADDR_LINE4` varchar(100) DEFAULT NULL,
  24.   `MOST_MAIL_PHYSICAL_ADDR_LINE1` varchar(100) DEFAULT NULL,
  25.   `MOST_MAIL_PHYSICAL_ADDR_LINE2` varchar(100) DEFAULT NULL,
  26.   `MOST_MAIL_PHYSICAL_ADDR_LINE3` varchar(100) DEFAULT NULL,
  27.   `MOST_MAIL_PHYSICAL_ADDR_LINE4` varchar(100) DEFAULT NULL,
  28.   `MOST_RECENT_POSTAL_ADDR_LINE1` varchar(100) DEFAULT NULL,
  29.   `MOST_RECENT_POSTAL_ADDR_LINE2` varchar(100) DEFAULT NULL,
  30.   `MOST_RECENT_POSTAL_ADDR_LINE3` varchar(100) DEFAULT NULL,
  31.   `MOST_RECENT_POSTAL_ADDR_LINE4` varchar(100) DEFAULT NULL,
  32.   `POC` varchar(20) DEFAULT NULL,
  33.   `POP` varchar(20) DEFAULT NULL,
  34.   `CPC` varchar(20) DEFAULT NULL,
  35.   `BAI` varchar(20) DEFAULT NULL,
  36.   `CELL_1` varchar(20) DEFAULT NULL,
  37.   `CELL_2` varchar(20) DEFAULT NULL,
  38.   `CELL_3` varchar(20) DEFAULT NULL,
  39.   `WORK_1` varchar(20) DEFAULT NULL,
  40.   `WORK_2` varchar(20) DEFAULT NULL,
  41.   `WORK_3` varchar(20) DEFAULT NULL,
  42.   `HOME_1` varchar(20) DEFAULT NULL,
  43.   `HOME_2` varchar(20) DEFAULT NULL,
  44.   `HOME_3` varchar(20) DEFAULT NULL,
  45.   `EMAIL_1` varchar(20) DEFAULT NULL,
  46.   `EMAIL_2` varchar(20) DEFAULT NULL,
  47.   `EMAIL_3` varchar(50) DEFAULT NULL,
  48.   `OCCUPATION_1` varchar(20) DEFAULT NULL,
  49.   `OCCUPATION_2` varchar(20) DEFAULT NULL,
  50.   `OCCUPATION_3` varchar(20) DEFAULT NULL,
  51.   `EMPLOYER_1` varchar(20) DEFAULT NULL,
  52.   `EMPLOYER_2` varchar(20) DEFAULT NULL,
  53.   `EMPLOYER_3` varchar(20) DEFAULT NULL,
  54.   `PROPERTY_1_TRANSFER_DATE` varchar(20) DEFAULT NULL,
  55.   `PROPERTY_ID10` varchar(50) DEFAULT NULL,
  56.   `PROPERTY_1_PROVINCE` varchar(50) DEFAULT NULL,
  57.   `PROPERTY_1_TOWNSHIP` varchar(50) DEFAULT NULL,
  58.   `PROPERTY_1_ERF_NUMBER` varchar(20) DEFAULT NULL,
  59.   `PROPERTY_1_UNIT_NUMBER` varchar(20) DEFAULT NULL,
  60.   `PROPERTY_1_SALES_PRICE` varchar(20) DEFAULT NULL,
  61.   `PROPERTY_1_BOND_AMOUNT` varchar(20) DEFAULT NULL,
  62.   `PROPERTY_1_BOND_HOLDER` varchar(20) DEFAULT NULL,
  63.   `PROPERTY_1_TITLE_DEED` varchar(20) DEFAULT NULL,
  64.   `PROPERTY_2_TRANSFER_DATE` varchar(20) DEFAULT NULL,
  65.   `PROPERTY_2_PROVINCE` varchar(50) DEFAULT NULL,
  66.   `PROPERTY_2_TOWNSHIP` varchar(50) DEFAULT NULL,
  67.   `PROPERTY_2_ERF_NUMBER` varchar(20) DEFAULT NULL,
  68.   `PROPERTY_2_UNIT_NUMBER` varchar(20) DEFAULT NULL,
  69.   `PROPERTY_2_SALES_PRICE` varchar(20) DEFAULT NULL,
  70.   `PROPERTY_2_BOND_AMOUNT` varchar(20) DEFAULT NULL,
  71.   `PROPERTY_2_BOND_HOLDER` varchar(20) DEFAULT NULL,
  72.   `PROPERTY_2_TITLE_DEED` varchar(20) DEFAULT NULL,
  73.   `PROPERTY_3_TRANSFER_DATE` varchar(20) DEFAULT NULL,
  74.   `PROPERTY_3_PROVINCE` varchar(20) DEFAULT NULL,
  75.   `PROPERTY_3_TOWNSHIP` varchar(20) DEFAULT NULL,
  76.   `PROPERTY_3_ERF_NUMBER` varchar(20) DEFAULT NULL,
  77.   `PROPERTY_3_UNIT_NUMBER` varchar(20) DEFAULT NULL,
  78.   `PROPERTY_3_SALES_PRICE` varchar(20) DEFAULT NULL,
  79.   `PROPERTY_3_BOND_AMOUNT` varchar(20) DEFAULT NULL,
  80.   `PROPERTY_3_BOND_HOLDER` varchar(20) DEFAULT NULL,
  81.   `PROPERTY_3_TITLE_DEED` varchar(20) DEFAULT NULL,
  82.   PRIMARY KEY (`NEW_IDN`),
  83.   KEY `MOST_RECENT_PHYSICAL_ADDR_LINE3` (`MOST_RECENT_PHYSICAL_ADDR_LINE3`),
  84.   KEY `PROPERTY_1_TOWNSHIP` (`PROPERTY_1_TOWNSHIP`),
  85.   KEY `PROPERTY_2_TOWNSHIP` (`PROPERTY_2_TOWNSHIP`),
  86.   KEY `PROPERTY_3_TOWNSHIP` (`PROPERTY_3_TOWNSHIP`),
  87.   KEY `EXPORTED` (`EXPORTED`)
  88. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  89. /*!40101 SET character_set_client = @saved_cs_client */;
RAW Paste Data
Top