search

revol-tech / mole

mole
Other
0 stars 2 forks source link

added the db migration. #6

Closed maan81 closed 11 years ago

maan81 commented 11 years ago

make sure u have a db "mole" with username "root" & password "password"

when going to http://localhost/mole/update_db/ the db will be configured. a nu migration table & a users table should appear in mysql.

the sql that will be executed (automatically) : 

CREATE TABLE `mole_users` ( 
    `user_id` INT UNSIGNED NOT NULL AUTO_INCREMENT, 
    `username` VARCHAR(127) NOT NULL, 
    `password` VARCHAR(127) NOT NULL, 
    PRIMARY KEY `user_id` (`user_id`) 
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;