[Memship-cvs] memship/doc STYLE,NONE,1.1 TODO,NONE,1.1 memship_schema_mysql.txt,NONE,1.1 memship_schema_pgsql.txt,NONE,1.1

[<se...@us...>]

Update of /cvsroot/memship/memship/doc
In directory usw-pr-cvs1:/tmp/cvs-serv10778/doc

Added Files:
	STYLE TODO memship_schema_mysql.txt memship_schema_pgsql.txt 
Log Message:
Reorganize source code a bit. Added doc/ directory


--- NEW FILE: STYLE ---
Not much.

- All files that are includes should be called "lib*".
- All include files should be put in include/ directory.
- Never use session_register(), session_is_registered() or session_unregister()
- Never rely on register_globals setting (it will be turned off for security reasons)

--- NEW FILE: TODO ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: memship_schema_mysql.txt ---
create table member (member INT NOT NULL AUTO_INCREMENT, forename
varchar(40), surname varchar(40), address varchar(60), postal
varchar(12), phone_home varchar(20), phone_work varchar(20),
phone_mobile varchar(20), email varchar(30), gender bool, occupation
varchar(30), comments varchar(200), secret_delivery bool, address_error
bool, synchronised bool, country char(2), last_login timestamp, password
varchar(20), login_errors smallint, primary key(member));

create table postal_errors (member INT NOT NULL, subgroup INT NOT NULL,
unit int, primary key(member, subgroup));

create table payment_required (member INT NOT NULL, subgroup INT NOT
NULL, unit int, payment int, primary key(member, subgroup));

create table access (member int not null, country char(2) not null,
postal varchar(12) not null, primary key (member,country,postal));

create table login_log (member int not null, login_time timestamp not
null, ip_address char(15), dns_name varchar(40), primary
key(member,login_time));

create table user_change_log (member int not null, changed_time
timestamp not null, changed_member int not null, primary key(member,
changed_time, changed_member));

create table subgroup_change_log (member int not null, changed_time
timestamp not null, changed_subgroup int not null, primary key (member,
changed_time, changed_subgroup));

create table subgroup (subgroup int not null, member int not null,
member_status int default '0', member_type int default '0', primary
key(subgroup, member));

create table group_description (subgroup int not null auto_increment,
name varchar(30), account varchar(20), address varchar(40), postal
varchar(12), country char(2), phone varchar(20), email varchar(30),
primary key(subgroup));

create table group_administration (member int not null, subgroup int not
null, primary key(member, subgroup));

create table payment (member int not null, start int not null, subgroup
int not null, units int default 0, payment int default 0, primary
key(member, start, subgroup));

create table postal (postal_number int not null, postal_address
varchar(40), country char(2) not null, primary key (postal_number,
country));

create table ipaccess (member int not null, ipclass char(11) not null,
access bool, password varchar(12), primary key (member, ipclass));

create table member_status (member_status varchar(20) not null, primary
key(member_status));

create table member_type (member_type varchar(20) not null, primary
key(member_type));


--- NEW FILE: memship_schema_pgsql.txt ---
# Changed from mysql original: SERIAL instead of int AUTO_INCREMENT NOT
# NULL) and datetime instead of timestamp

create table member (member SERIAL, forename
varchar(40), surname varchar(40), address varchar(60), postal
varchar(12), phone_home varchar(20), phone_work varchar(20),
phone_mobile varchar(20), email varchar(30), gender bool, occupation
varchar(30), comments varchar(200), secret_delivery bool, address_error
bool, synchronised bool, country char(2), last_login timestamp, password
varchar(20), login_errors smallint, primary key(member));

create table postal_errors (member INT NOT NULL, subgroup INT NOT NULL,
unit int, primary key(member, subgroup));

create table payment_required (member INT NOT NULL, subgroup INT NOT
NULL, unit int, payment int, primary key(member, subgroup));

create table access (member int not null, country char(2) not null,
postal varchar(12) not null, primary key (member,country,postal));

create table login_log (member int not null, login_time datetime not
null, ip_address char(15), dns_name varchar(40), primary key(member,
login_time));

create table user_change_log (member int not null, changed_time
datetime not null, changed_member int not null, primary key(member,
changed_time, changed_member));

create table subgroup_change_log (member int not null, changed_time
datetime not null, changed_subgroup int not null, primary key (member,
changed_time, changed_subgroup));

create table subgroup (subgroup int not null, member int not null,
member_status int default '0', member_type int default '0', primary
key(subgroup, member));

create table group_description (subgroup SERIAL,
name varchar(30), account varchar(20), address varchar(40), postal
varchar(12), country char(2), phone varchar(20), email varchar(30),
primary key(subgroup));

create table group_administration (member int not null, subgroup int not
null, primary key(member, subgroup));

create table payment (member int not null, start int not null, subgroup
int not null, units int default 0, payment int default 0, primary
key(member, start, subgroup));

create table postal (postal_number int not null, postal_address
varchar(40), country char(2) not null, primary key (postal_number,
country));

create table ipaccess (member int not null, ipclass char(11) not null,
access bool, password varchar(12), primary key (member, ipclass));

create table member_status (member_status varchar(20) not null, primary
key(member_status));

create table member_type (member_type varchar(20) not null, primary
key(member_type));