Select Code to Download

CREATE TABLE secure_fields (
    id     INTEGER UNSIGNED PRIMARY KEY AUTO_INCREMENT NOT NULL, 
    salt   INTEGER UNSIGNED NOT NULL, 
    passwd CHAR(40) NOT NULL 
);

plaintex_passwd  = The plaintext password from the user 
hex()  = Hex encoding function
...
+      = String concat

hex( SHA1( salt + SHA1( salt + plaintext_passwd ) ) )