MWUjgR2M

1Table structures
2
3
4CREATE TABLE IF NOT EXISTS `ndb` (
5  `Create Timestamp` datetime DEFAULT NULL,
6  `Edit Timestamp` datetime DEFAULT NULL,
7  `Merge Timestamp` datetime DEFAULT NULL,
8  `Record Manager` varchar(50) DEFAULT NULL,
9  `Type` varchar(100) DEFAULT NULL,
10  `Regarding` text,
11  `Date/Time` varchar(12) DEFAULT NULL,
12  `X_CDBJOIN` varchar(27) DEFAULT NULL,
13  `X_GDBJOIN` varchar(27) DEFAULT NULL,
14  `X_NDBJOIN` varchar(27) DEFAULT NULL,
15  `X_NDBID12` varchar(12) DEFAULT NULL,
16  `X_TYPE` varchar(75) DEFAULT NULL,
17  `X_COMPANY` varchar(100) DEFAULT NULL,
18  `X_CONTACT` varchar(75) DEFAULT NULL,
19  `X_FNAME` varchar(50) DEFAULT NULL,
20  `X_LNAME` varchar(50) DEFAULT NULL,
21  `processed` tinyint(1) NOT NULL
22) ENGINE=MyISAM DEFAULT CHARSET=utf8;
23
24CREATE TABLE IF NOT EXISTS `cdb` (
25  `Create Timestamp` datetime DEFAULT NULL,
26  `Edit Timestamp` datetime DEFAULT NULL,
27  `Merge Timestamp` datetime DEFAULT NULL,
28  `Public/Private` double DEFAULT NULL,
29  `Record Manager` varchar(50) DEFAULT NULL,
30  `Company` varchar(50) DEFAULT NULL,
31  `Contact Name` varchar(50) DEFAULT NULL,
32  `Address 1` varchar(50) DEFAULT NULL,
33  `Address 2` varchar(30) DEFAULT NULL,
34  `Address 3` varchar(30) DEFAULT NULL,
35  `City` varchar(30) DEFAULT NULL,
36  `State` varchar(20) DEFAULT NULL,
37  `Zip` varchar(10) DEFAULT NULL,
38  `Country` varchar(25) DEFAULT NULL,
39  `ID/Status` varchar(25) DEFAULT NULL,
40  `Phone` varchar(42) DEFAULT NULL,
41  `Fax` varchar(42) DEFAULT NULL,
42  `Home Phone` varchar(42) DEFAULT NULL,
43  `Mobile Phone` varchar(42) DEFAULT NULL,
44  `Pager` varchar(42) DEFAULT NULL,
45  `Salutation` varchar(30) DEFAULT NULL,
46  `Last Meeting` datetime DEFAULT NULL,
47  `Last Reach` datetime DEFAULT NULL,
48  `Last Attempt` datetime DEFAULT NULL,
49  `Letter Date` datetime DEFAULT NULL,
50  `Title` varchar(50) DEFAULT NULL,
51  `Assistant` varchar(50) DEFAULT NULL,
52  `Last Results` varchar(75) DEFAULT NULL,
53  `Referred By` varchar(30) DEFAULT NULL,
54  `User 1` text,
55  `User 2` text,
56  `User 3` text,
57  `User 4` text,
58  `User 5` text,
59  `User 6` text,
60  `User 7` text,
61  `User 8` text,
62  `User 9` text,
63  `User 10` text,
64  `User 11` text,
65  `User 12` text,
66  `User 13` text,
67  `User 14` text,
68  `User 15` text,
69  `Home Address 1` varchar(50) DEFAULT NULL,
70  `Home Address 2` varchar(30) DEFAULT NULL,
71  `Home City` varchar(30) DEFAULT NULL,
72  `Home State` varchar(20) DEFAULT NULL,
73  `Home Zip` varchar(10) DEFAULT NULL,
74  `Home Country` varchar(25) DEFAULT NULL,
75  `Alt Phone` varchar(42) DEFAULT NULL,
76  `2nd Contact` varchar(50) DEFAULT NULL,
77  `2nd Title` varchar(50) DEFAULT NULL,
78  `2nd Phone` varchar(42) DEFAULT NULL,
79  `3rd Contact` varchar(50) DEFAULT NULL,
80  `3rd Title` varchar(50) DEFAULT NULL,
81  `3rd Phone` varchar(42) DEFAULT NULL,
82  `First Name` varchar(50) DEFAULT NULL,
83  `Last Name` varchar(50) DEFAULT NULL,
84  `Phone Ext#` varchar(8) DEFAULT NULL,
85  `Fax Ext#` varchar(8) DEFAULT NULL,
86  `Alt Phone Ext#` varchar(8) DEFAULT NULL,
87  `2nd Phone Ext#` varchar(8) DEFAULT NULL,
88  `3rd Phone Ext#` varchar(8) DEFAULT NULL,
89  `Asst# Title` varchar(50) DEFAULT NULL,
90  `Asst# Phone` varchar(42) DEFAULT NULL,
91  `Asst# Phone Ext#` varchar(8) DEFAULT NULL,
92  `Department` varchar(50) DEFAULT NULL,
93  `Spouse` varchar(50) DEFAULT NULL,
94  `Record Creator` varchar(50) DEFAULT NULL,
95  `Owner` varchar(50) DEFAULT NULL,
96  `2nd Last Reach` datetime DEFAULT NULL,
97  `3rd Last Reach` datetime DEFAULT NULL,
98  `Web Site` varchar(75) DEFAULT NULL,
99  `Ticker Symbol` varchar(12) DEFAULT NULL,
100  `Birth Date` datetime DEFAULT NULL,
101  `Contact Type` double DEFAULT NULL,
102  `X_CDBJOIN` varchar(27) DEFAULT NULL,
103  `X_PEMAIL` varchar(100) DEFAULT NULL,
104  `X_SEMAIL` varchar(100) DEFAULT NULL,
105  `X_PREFIX` varchar(30) DEFAULT NULL,
106  `X_SUFFIX` varchar(30) DEFAULT NULL,
107  `account_id` varchar(50) DEFAULT NULL,
108  `contact_id` varchar(50) NOT NULL,
109  `accounts_processed` tinyint(1) NOT NULL,
110  `contacts_processed` tinyint(1) NOT NULL,
111  UNIQUE KEY `X_CDBJOIN` (`X_CDBJOIN`)
112) ENGINE=MyISAM DEFAULT CHARSET=utf8;