Skip to content

Instantly share code, notes, and snippets.

@khannedy
Created July 19, 2011 09:11
Show Gist options
  • Save khannedy/1091790 to your computer and use it in GitHub Desktop.
Save khannedy/1091790 to your computer and use it in GitHub Desktop.
MySQL Create Table Account Temp
create table accounts_temp(
cust_no varchar(255),
acctno varchar(255),
cycle varchar(255),
lsstdt date,
bk1 varchar(255),
abc varchar(255),
open date,
crelim varchar(255),
hibal varchar(255),
purdt date,
pymdt date,
dqamcr varchar(255),
dqamx varchar(255),
dqam30 varchar(255),
dqam60 varchar(255),
dqam90 varchar(255),
dqam120 varchar(255),
dqam150 varchar(255),
dqam180 varchar(255),
dqam210 varchar(255),
dqamto varchar(255),
hist24 varchar(255),
pydudt date,
amlspy varchar(255),
stcode varchar(255),
dtstch date,
sex varchar(255),
dob date,
stdt date,
newbl varchar(255),
cycdu varchar(255),
bi varchar(255),
tot_currbal varchar(255),
cardno varchar(255),
bkc varchar(255),
blockdtc date,
basu varchar(255),
expdtc date,
chargeoff varchar(255),
name1 varchar(255),
name2 varchar(255),
haddr1 varchar(255),
haddr2 varchar(255),
haddr3 varchar(255),
city varchar(255),
hposc varchar(255),
hphone1 varchar(255),
hphone2 varchar(255),
mobile_phone_1 varchar(255),
employer_1 varchar(255),
offaddr1 varchar(255),
offaddr2 varchar(255),
offaddr3 varchar(255),
offcity varchar(255),
offposc varchar(255),
offphone1 varchar(255),
offphone2 varchar(255),
ecname varchar(255),
ecadr1 varchar(255),
ecadr2 varchar(255),
echph varchar(255),
ecoph varchar(255),
agnttag varchar(255),
pcode varchar(255),
logo varchar(255),
due varchar(255)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment