Love Fuel?    Donate

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.
Create table for auth
  • Hello!


    I do not found, where is sql code for creating "users" table?
  • This?

    CREATE TABLE `users` (
        `id` INT(11) NOT NULL AUTO_INCREMENT,
        `username` VARCHAR(255) NOT NULL,
        `password` VARCHAR(255) NOT NULL,
        `email` VARCHAR(255) NOT NULL,
        `profile_fields` TEXT NOT NULL,
        `group` INT(11) NOT NULL,
        `last_login` INT(20) NOT NULL,
        `login_hash` VARCHAR(255) NOT NULL,
        `created_at` INT(11) NOT NULL,
        `updated_at` INT(11) NOT NULL,
        PRIMARY KEY (`id`)
    )
    COLLATE='utf8_general_ci'
    ENGINE=InnoDB;

  • The Auth package comes with it's own migrations.

    Make sure you have a working database config, and a properly setup auth.php config file in app/config, and run the migrations. The required tables (for simpleauth or ormauth, depending on your config file) will be created automatically,

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion