users

[loginews]

CREATE TABLE users ( id int(5) unsigned NOT NULL AUTO_INCREMENT, username varchar(12) NOT NULL, password varchar(255) NOT NULL, role varchar(20) NOT NULL, psales char(1) NOT NULL DEFAULT 'N', po char(1) NOT NULL DEFAULT 'N', cptran char(1) NOT NULL DEFAULT 'N', outtran char(1) NOT NULL DEFAULT 'N', gl char(1) NOT NULL DEFAULT 'N', stkmain_gldept varchar(2) NOT NULL DEFAULT '*', recon char(1) NOT NULL DEFAULT 'N', startupform varchar(50) NOT NULL DEFAULT 'psales', invoiceform char(2) NOT NULL DEFAULT '01', TIMESTAMP timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, outlet char(2) NOT NULL DEFAULT '""', cashier char(1) NOT NULL DEFAULT 'N', bajunior char(1) NOT NULL DEFAULT 'N', possales char(1) NOT NULL DEFAULT 'N', storekeeper char(1) NOT NULL DEFAULT 'N', shopname varchar(100) NOT NULL DEFAULT 'shop name', street varchar(100) NOT NULL DEFAULT 'street', STORENUM char(2) NOT NULL DEFAULT '', phone char(15) NOT NULL DEFAULT '', superuser char(1) NOT NULL DEFAULT 'N', customer char(1) NOT NULL DEFAULT 'N', created datetime DEFAULT NULL, modified datetime DEFAULT NULL, param_id int(11) NOT NULL DEFAULT '1', PRIMARY KEY (id), UNIQUE KEY id (id) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8