=@@COLLATION_CONNECTION * /;
/*! 40101 SET NAMES utf8 * /;
: `provod`
-
-
`brands`
TABLE IF NOT EXISTS `brands` (
`brand_id` tinyint (3) unsigned NOT NULL AUTO_INCREMENT,
`brand_name` varchar (255) NOT NULL,
`parent_id` tinyint (3) unsigned NOT NULL DEFAULT 0 , KEY (` brand_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=32;
`brands`
INTO `brands` (` brand_id`, `brand_name`,` parent_id`) VALUES
(23, raquo ;, 0),
(25, raquo ;, 0),
(26, raquo ;, 0),
(27, raquo ;, 0),
(29, raquo ;, 0),
(30, raquo ;, 0),
(31, raquo ;, 0);
-
`customers`
- TABLE IF NOT EXISTS `customers` (
`customer_id` int (10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar (255) NOT NULL,
`email` varchar (255) NOT NULL,
`phone` varchar (255) DEFAULT NULL,
`address` varchar (255) DEFAULT NULL,
`login` varchar (20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`password` varchar (32) DEFAULT NULL,
`id_role` tinyint (3) unsigned NOT NULL DEFAULT 1 , KEY (` customer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=38;
`customers`
INTO `customers` (` customer_id`, `name`,` email`, `phone`,` address`, `login`,` password`, `id_role`) VALUES
(33, raquo ;, ognishvetal@gmailraquo ;, NULL, NULL, ognish raquo ;, c8b3915fd812039a06da096f0c79f69a raquo ;, 1),
(32, raquo ;, teef @ ggg raquo ;, 8937999 99 99 raquo ;, fbgdbg raquo ;, NULL, NULL, 1),
(12, 1 raquo ;, guest@mailraquo ;, 111 raquo ;, raquo ;, NULL, NULL, 1),
(13, 2 raquo ;, guest2@mailraquo ;, 222 raquo ;, 2 raquo ;, NULL, NULL, 1),
(15, 3 raquo ;, guest3@mailraquo ;, 333 raquo ;, 3 raquo ;, NULL, NULL, 1),
(31, raquo ;, test@mailraquo ;, 8937999 99 99 raquo ;, laquo ;.,.,.. 19, 51. raquo ;, NULL , NULL, 1),
(21, raquo ;, mail@mailraquo ;, 5 555-55-55 raquo ;, raquo ;, NULL, NULL, 1),
(22, raquo ;, admin @ ishop raquo ;, + 111111111 raquo ;, raquo ;, admin raquo ;, 21232f297a57a5a743894a0e4a801fc3 raquo ;, 2),
(23, raquo ;, client @ com raquo ;, 123-123 raquo ;, raquo ;, NULL, NULL, 1),
(30, raquo ;, test@mailraquo ;, 8937999 99 99 raquo ;, fvvfvf raquo ;, NULL, NULL, 1),
(26, raquo ;, test@mailraquo ;, 8937999 99 99 raquo ;, laquo ;.,.,.. 19, 51. raquo ;, NULL , NULL, 1),
(27, cxzcxzczc raquo ;, dvccxvc @ dfdfd raquo ;, 6555 raquo ;, dfdf raquo ;, NULL, NULL, 1),
(28, raquo ;, test@mailraquo ;, 8937999 99 99 raquo ;, laquo ;.,.,.. 19, 51. raquo ;, NULL , NULL, 1),
(29, raquo ;, test@mailraquo ;, 8937999 99 99 raquo ;, laquo ;.,.,.. 19, 51. raquo ;, NULL , NULL, 1),
(35, laquo ;; lk; lk; raquo ;, test@mailraquo ;, 354353 raquo ;, dffdfdv raquo ;, NULL, NULL, 1),
(36, raquo ;, ognishvetal@gmailraquo ;, 098881 10 січня raquo ;, .,.. 13, 22. raquo ;, NULL, NULL, 1),
(37, 1111 raquo ;, 1111 raquo ;, 1111 raquo ;, 1111 raquo ;, 1111 raquo ;, b59c67bf196a4758191e42f76670ceba raquo ;, 1);
- -
`dostavka`
TABLE IF NOT EXISTS `dostavka` (
`dostavka_id` tinyint (3) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar (255) NOT NULL, KEY (` dostavka_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5;
`dostavka`
INTO `dostavka` (` dostavka_id`, `name`) VALUES
(1, ),
(2, ),
(3, ),
(4, );
