Code: Select all
INSERT INTO sss_users ('active', 'name', 'gender', 'username', 'password', 'email', 'regstr', 'regtime', 'tickets', 'ip') VALUES ('0', 'Max', 'm', 'Starcraftmazter', '2e81f355049b5861d4d17cf470cb2b8a1538b418', 'starcraftmazter@gmail.com', 'I8L6I0daJT21fQly5M50e0j2uAog22wWDlC83Iz85S27PgReD7az9AZ877J5J68WM5hM80322dV7MKlXFPyj2nCy29Q30n3i30z6', '1152023040', '0', '2130706433 ');Code: Select all
$sql = 'CREATE TABLE `sss_users` ('
. ' `id` SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, '
. ' `active` ENUM(\'0\',\'1\') NOT NULL, '
. ' `name` VARCHAR(100) NOT NULL, '
. ' `gender` ENUM(\'m\',\'f\') NOT NULL, '
. ' `username` VARCHAR(32) NOT NULL, '
. ' `password` VARCHAR(40) NOT NULL, '
. ' `email` VARCHAR(255) NOT NULL, '
. ' `regstr` VARCHAR(100) NOT NULL, '
. ' `regtime` INT UNSIGNED NOT NULL, '
. ' `tickets` SMALLINT UNSIGNED NOT NULL, '
. ' `ip` INT UNSIGNED NOT NULL, '
. ' `type` TINYINT UNSIGNED NOT NULL, '
. ' `staff` ENUM(\'0\',\'1\') NOT NULL DEFAULT \'0\''
. ' )'
. ' TYPE = innodb;';