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