[Memship-devel] mysqltabeller

[Per I M. <pe...@le...>]

Da har jeg laget tabellene i mysql.

M=E5tte endre "index" =3D> "member", "group" =3D> "subgroup" og "time" =3D>=
 annet
fordi f=F8rstnevnte er reserverte ord, enten i mysql eller ansi sql. Endret
ogs=E5 gruppeindeks fra streng til tall, fordi dette er mye raskere.

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), synchronised bool, country char(2), last_login timestamp,
password varchar(20), login_errors smallint, primary key(member));

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));

Det er veldig enkelt =E5 endre ting n=E5 f=F8r noe data er i tabellene, men
vennligst send create kommandoene til lista s=E5 en kan f=F8lge med hva som
blir gjort.

Skal se om jeg klarer =E5 sette opp en cvs-epostliste for =E5 f=F8lge endri=
nger
i cvs.

Mvh
Per