Location: PHPKode > projects > PhpChangeLog > phpchangelog-0.6/mysql/create_db.inc.php
INSERT INTO db (db) VALUES ('$dbname');

CREATE TABLE $dbname_changelog (
  id int(11) NOT NULL auto_increment,
  project_id int(11) NOT NULL default '0',
  maintainer_id int(11) NOT NULL default '0',
  date varchar(20) NOT NULL default '0',
  comment text NOT NULL,
  UNIQUE KEY id (id)
) TYPE=MyISAM;

CREATE TABLE $dbname_maintainers (
  id int(11) NOT NULL auto_increment,
  maintainer varchar(255) NOT NULL default '',
  password varchar(250) NOT NULL default '',
  UNIQUE KEY id (id)
) TYPE=MyISAM;

INSERT INTO $dbname_maintainers VALUES (1,'admin', MD5('admin'));

CREATE TABLE $dbname_projects (
  id int(11) NOT NULL auto_increment,
  project varchar(255) NOT NULL default '',
  UNIQUE KEY id (id)
) TYPE=MyISAM;
Return current item: PhpChangeLog