Re: Update result frid from stored procedure
Posted by:
S Scott
Date: June 25, 2020 11:33AM
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`first_name` varchar(255) NOT NULL,
`last_name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`password` text NOT NULL,
`phone` varchar(20) NOT NULL,
`type` varchar(255) DEFAULT NULL,
`address` varchar(255) NOT NULL,
`unit` varchar(255) NOT NULL,
`buzz` varchar(255) NOT NULL,
`city` varchar(255) NOT NULL,
`postal` varchar(255) DEFAULT NULL,
`pick_up_store` int(4) NOT NULL DEFAULT '0',
`instructions` varchar(255) NOT NULL,
`free_stamps` int(11) NOT NULL DEFAULT '0',
`correction_stamps` int(11) NOT NULL DEFAULT '0',
`user_agent` varchar(1000) NOT NULL,
`level` tinyint(2) NOT NULL DEFAULT '10',
`is_subscribed` tinyint(1) NOT NULL DEFAULT '1',
`limit_advertising` tinyint(4) NOT NULL DEFAULT '0',
`is_active` tinyint(1) NOT NULL DEFAULT '1',
`is_deleted` tinyint(1) NOT NULL DEFAULT '0',
`is_passport` tinyint(1) NOT NULL DEFAULT '0',
`is_coupon` tinyint(1) NOT NULL,
`passported` datetime DEFAULT NULL,
`passport_expiry` datetime DEFAULT NULL,
`passport_stamps` int(11) NOT NULL,
`passport_extensions` int(11) NOT NULL,
`logged` datetime DEFAULT NULL,
`modified` datetime DEFAULT NULL,
`created` datetime DEFAULT NULL,
`group_id` int(11) NOT NULL,
`json_passport` text NOT NULL,
`session_id` varchar(100) DEFAULT NULL,
`store` varchar(10) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=1000000001 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT