tigbit

delete from users where userid=56

create sha1 password

dovecotpw -s SHA1


INSERT INTO `user` (`username`, `domain`, `password`, `Full Name`) VALUES ('test', 'example.com', 'W6ph5Mm5Pz8GgiULbPgzG37mj9g=', 'test user entry for demo')



UPDATE user set password = '/g6tntvFBy6iq2V3YaBwYz5PbR0=' WHERE username = 'gaz';

CREATE TABLE jos_reviews ( id int(11) NOT NULL auto_increment,   name varchar(255) NOT NULL,   address varchar(255) NOT NULL,   reservations varchar(31) NOT NULL,   quicktake text NOT NULL,   review text NOT NULL,    notes text NOT NULL,    smoking tinyint(1) unsigned NOT NULL default 0,    credit_cards varchar(255) NOT NULL, cuisine varchar(31) NOT NULL, avg_dinner_price tinyint(3) unsigned NOT NULL default 0, review_date datetime NOT NULL, published tinyint(1) unsigned NOT NULL default 0, PRIMARY KEY  (id) );