Microsoft SQL Server Support

[deltaforce]

Here is the SQL required for Microsoft SQL Server database

CREATE TABLE users (
id int NOT NULL primary key,
admin bit NOT NULL DEFAULT(0),
name varchar(40) NOT NULL,
email varchar(40) NOT NULL,
password varchar(255) NOT NULL,
salt varchar(255) NOT NULL,
passwordresettoken varchar(255) DEFAULT NULL,
passwordresetat datetime DEFAULT NULL,
confirmed bit NOT NULL DEFAULT '0',
emailconfirmationtoken varchar(255) DEFAULT NULL,
createdat datetime DEFAULT NULL,
updatedat datetime DEFAULT NULL,
deletedat datetime DEFAULT NULL)

INSERT INTO users (id,admin,name,email,password,salt,passwordresettoken,passwordresetat,confirmed,emailconfirmationtoken,createdat,updatedat,deletedat) VALUES ('1', '1', 'Mohamad El-Husseini', '[email protected]', '$2a$10$N8usJ.eUcZpeMHTDfHCi0.lxicICYTz4GROUcLb4pIFVtLRjx0JI2', '$2a$10$N8usJ.eUcZpeMHTDfHCi0.', null, null, '1', null, '2012-06-30 17:57:22', '2012-07-02 14:27:22', null);
INSERT INTO users (id,admin,name,email,password,salt,passwordresettoken,passwordresetat,confirmed,emailconfirmationtoken,createdat,updatedat,deletedat) VALUES ('2', '0', 'Bart Simpson', '[email protected]', '$2a$10$iFKdRNNJwYBrDeIz4bVMR.dd7D.u9G7aj2FrkW5SNjzttfTQtCbaC', '$2a$10$iFKdRNNJwYBrDeIz4bVMR.', null, null, '1', null, '2012-06-30 17:57:55', '2012-06-30 17:57:55', null);
INSERT INTO users (id,admin,name,email,password,salt,passwordresettoken,passwordresetat,confirmed,emailconfirmationtoken,createdat,updatedat,deletedat) VALUES ('3', '0', 'Lisa Simpson', '[email protected]', '$2a$10$34ct8DzjNvbIhFEPWNFBZ.q.dGY2ZhQAPuWtZ2mM2edLay./LYAaa', '$2a$10$34ct8DzjNvbIhFEPWNFBZ.', null, null, '1', null, '2012-06-30 17:58:12', '2012-06-30 17:58:12', null);
INSERT INTO users (id,admin,name,email,password,salt,passwordresettoken,passwordresetat,confirmed,emailconfirmationtoken,createdat,updatedat,deletedat) VALUES ('4', '0', 'Jack Sparrow', '[email protected]', '$2a$10$VR/7LU4oVGvEIFG3xkxwc.lLovW/CGWOCOp6g28AF6LoDisnO2khi', '$2a$10$VR/7LU4oVGvEIFG3xkxwc.', null, null, '0', '3380e3cd65a443b281ddda491588e842', '2012-07-02 14:36:55', '2012-07-02 14:36:55', null);

[abitdodgy]

Thanks for providing that. I'll integrate it. This project needs some love, and I need some time 😄