#Table structure for table 'dms_users'
CREATE TABLE dms_users (
  username   VARCHAR(40) DEFAULT '' NOT NULL,
  password   VARCHAR(25),
  e_mail     VARCHAR(150),
  phone      VARCHAR(25),
  group_id   VARCHAR(25),
  PRIMARY KEY (username)
);


#Table structure for table 'dms_files'
CREATE TABLE dms_files (
  file_id      INT(11) DEFAULT '0' NOT NULL AUTO_INCREMENT,
  filename     VARCHAR(255),
  description  VARCHAR(255),
  location     VARCHAR(255),
  mime_type    VARCHAR(50),
  group_id     VARCHAR(25),
  who_to       VARCHAR(40),
  out_date     VARCHAR(20),
  PRIMARY KEY (file_id)
);