abdullah almesbahi
03/08/2019, 2:27 PMam_user
(
user_id
int(10) unsigned NOT NULL AUTO_INCREMENT,
login
varchar(64) NOT NULL,
pass
varchar(64) DEFAULT NULL,
remember_key
varchar(40) DEFAULT NULL,
pass_dattm
datetime DEFAULT NULL,
email
varchar(64) DEFAULT NULL,
name_f
varchar(64) NOT NULL,
name_l
varchar(64) NOT NULL,
street
varchar(255) DEFAULT NULL,
street2
varchar(255) DEFAULT NULL,
city
varchar(255) DEFAULT NULL,
state
varchar(255) DEFAULT NULL,
zip
varchar(255) DEFAULT NULL,
country
varchar(255) DEFAULT NULL,
phone
varchar(255) DEFAULT NULL,
added
datetime DEFAULT NULL,
remote_addr
varchar(39) DEFAULT NULL,
user_agent
varchar(255) DEFAULT NULL,
saved_form_id
int(10) unsigned DEFAULT NULL,
status
smallint(6) NOT NULL DEFAULT '0',
unsubscribed
tinyint(4) NOT NULL DEFAULT '0',
lang
varchar(32) DEFAULT NULL,
i_agree
tinyint(4) DEFAULT '0',
is_approved
tinyint(4) DEFAULT '1',
is_locked
tinyint(4) DEFAULT '0',
disable_lock_until
datetime DEFAULT NULL,
reseller_id
int(11) DEFAULT NULL,
comment
text,
tax_id
varchar(255) DEFAULT NULL,
last_login
datetime DEFAULT NULL,
last_ip
varchar(39) DEFAULT NULL,
last_user_agent
varchar(255) DEFAULT NULL,
last_session
varchar(32) DEFAULT NULL,
aff_id
int(10) unsigned DEFAULT NULL,
aff_added
datetime DEFAULT NULL,
is_affiliate
tinyint(4) DEFAULT NULL,
aff_payout_type
varchar(32) DEFAULT NULL,
PRIMARY KEY (user_id
),
UNIQUE KEY login
(login
),
KEY email
(email
),
KEY country
(`country`(3)),
KEY state
(`state`(191))
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4;
is there any solution to auto generate datamodel.graphql from existing mysql ?
it going to save me a lot of time
I also see prisma using CamelCase for table name and fields
is possible to re-map fields and table in datamodel.graphql without changing it in mysql?
like table am_user to User and field user_id to id