my sql

Jump to bottom Edit New page

rril edited this page Dec 29, 2014 · 1 revision

Create table in mysql:

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL,
  `username` varchar(1024) COLLATE utf16_unicode_ci NOT NULL,
  `password` varchar(64) COLLATE utf16_unicode_ci NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `block` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB;