Login   Register  
PHP Classes
elePHPant
Icontem

File: installdb.inc

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Voznyak Nazar  >  MVC Membership System  >  installdb.inc  >  Download  
File: installdb.inc
Role: Configuration script
Content type: text/plain
Description: sql commands for installation
Class: MVC Membership System
Membership system using the MVC design pattern
Author: By
Last change:
Date: 2003-12-30 00:03
Size: 937 bytes
 

Contents

Class file image Download
<?

/*** create admins table */
define('CREATE_ADMINS_TABLE', <<<EOS
create table admins (
    username varchar(20) not null primary key,
    password varchar(20) not null)
EOS
);

/*** drop admins table */
define('DROP_ADMINS_TABLE', <<<EOS
drop table admins
EOS
);

/*** create members table */
define('CREATE_MEMBERS_TABLE', <<<EOS
create table members (
    username varchar(20) not null primary key,
    password varchar(20) not null,
    status int not null)
EOS
);

/*** drop members table */
define('DROP_MEMBERS_TABLE', <<<EOS
drop table members
EOS
);

/*** create partners table */
define('CREATE_PARTNERS_TABLE', <<<EOS
create table partners (
    username varchar(20) not null primary key,
    password varchar(20) not null,
    status int not null)
EOS
);
// partner status: 0 - non active, 1 - active

/*** drop partners table */
define('DROP_PARTNERS_TABLE', <<<EOS
drop table partners
EOS
);

?>