10173ca

1drop table if exists accessgroup;
2create table accessgroup ( id tinyint(4) default '0' NOT NULL AUTO_INCREMENT PRIMARY KEY,
3   groupname varchar(10) NOT NULL,
4   createperm char(1) default 'n' NOT NULL,
5   questionperm char(1) default 'y' NOT NULL,
6   answerperm char(1) default 'n' NOT NULL,
7   deleteperm char(1) default 'n' NOT NULL );
8
9insert into accessgroup set groupname='admin', createperm='Y', questionperm='Y', answerperm='Y', deleteperm='Y';
10insert into accessgroup set groupname='user', createperm='Y', questionperm='Y', answerperm='Y', deleteperm='N';
11
12drop table if exists topics;
13create table topics ( id tinyint(4) default '0' NOT NULL AUTO_INCREMENT PRIMARY KEY,
14   topicname varchar(32) NOT NULL,
15   keywords varchar(255) NOT NULL );
16   login varchar(10) NOT NULL,
17   password varchar(10) NOT NULL );
18
19insert into topics set topicname='OA&M - System', keywords='OA&M System', login='oam_sys', password='oam_sys';
20insert into topics set topicname='OA&M - Framework', keywords='OA&M Framework', login='oam_fmwk', password='oam_fmwk';
21insert into topics set topicname='OA&M - GUI', keywords='OA&M GUI', login='oam_gui', password='oam_gui';
22insert into topics set topicname='OA&M - Internal', keywords='OA&M Internal', login='oam_int', password='oam_int';
23insert into topics set topicname='CVS', keywords='CVS', login='cvs', password='cvs';
24insert into topics set topicname='Mailing List', keywords='Mail Mailing List emobmail', login='mail', password='mail';
25insert into topics set topicname='Database', keywords='Mail Mailing List emobmail', login='db', password='db';
26
27drop table if exists users;
28create table users ( id tinyint(4) default '0' NOT NULL AUTO_INCREMENT PRIMARY KEY,
29			lastname varchar(32) NOT NULL,
30			firstname varchar(32) NOT NULL,
31			login varchar(10) NOT NULL,
32			email varchar(32) NOT NULL,
33   accessgroup varchar(10) NOT NULL,
34   password varchar(10) NOT NULL, KEY(email));
35insert into users set lastname='Administrator', firstname='Admin', login='admin', email='chetangadgil@home.com', accessgroup='admin', password='b.admin';
36
37
38drop table if exists questions;
39create table questions ( id tinyint(4) default '0' NOT NULL AUTO_INCREMENT PRIMARY KEY,
40   keywords varchar(128),
41   questiontext varchar(255) NOT NULL,
42			answertext blob,
43			topicname varchar(32) NOT NULL,
44			answered varchar(1) default 'n' NOT NULL );
45