7gTe70j6

1/*
2SQLyog - Free MySQL GUI v5.14
3Host - 5.0.18-nt : Database - galway
4*********************************************************************
5Server version : 5.0.18-nt
6*/
7
8
9SET NAMES utf8;
10
11SET SQL_MODE='';
12
13create database if not exists `galway`;
14SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO';
15
16/*Table structure for table `admins` */
17
18CREATE TABLE `admins` (
19  `id` int(4) NOT NULL auto_increment,
20  `username` varchar(200) default NULL,
21  `password` varchar(32) default NULL,
22  `status` tinyint(1) default NULL,
23  PRIMARY KEY  (`id`)
24) ENGINE=InnoDB DEFAULT CHARSET=latin1;
25
26/*Data for the table `admins` */
27
28insert into `admins` (`id`,`username`,`password`,`status`) values (1,'admin','0192023a7bbd73250516f069df18b500',1);
29insert into `admins` (`id`,`username`,`password`,`status`) values (2,'user1','pass1',NULL);
30
31/*Table structure for table `coursegroups` */
32
33CREATE TABLE `coursegroups` (
34  `id` int(4) NOT NULL auto_increment,
35  `name` varchar(255) default NULL,
36  `colour` varchar(7) default NULL,
37  PRIMARY KEY  (`id`),
38  UNIQUE KEY `id` (`id`)
39) ENGINE=InnoDB DEFAULT CHARSET=latin1;
40
41/*Data for the table `coursegroups` */
42
43insert into `coursegroups` (`id`,`name`,`colour`) values (1,'group1',NULL);
44insert into `coursegroups` (`id`,`name`,`colour`) values (2,'group2','#ff0000');
45insert into `coursegroups` (`id`,`name`,`colour`) values (3,'group3',NULL);
46insert into `coursegroups` (`id`,`name`,`colour`) values (4,'group4',NULL);
47
48/*Table structure for table `courses` */
49
50CREATE TABLE `courses` (
51  `id` int(4) NOT NULL auto_increment,
52  `gr_id` int(4) NOT NULL default '0',
53  `course_aim` text,
54  `content` text,
55  `venue` varchar(255) default NULL,
56  `organiser` varchar(255) default NULL,
57  `target_group` varchar(255) default NULL,
58  `prec_req` text,
59  `certification` text,
60  `stime` date default NULL,
61  `duration` int(3) default '0',
62  `deadline` date default NULL,
63  `noplaces` int(4) default '0',
64  `placesleft` int(4) default '0',
65  `retraining` date default NULL,
66  PRIMARY KEY  (`id`)
67) ENGINE=InnoDB DEFAULT CHARSET=latin1;
68
69/*Data for the table `courses` */
70
71insert into `courses` (`id`,`gr_id`,`course_aim`,`content`,`venue`,`organiser`,`target_group`,`prec_req`,`certification`,`stime`,`duration`,`deadline`,`noplaces`,`placesleft`,`retraining`) values (1,1,'wer','wer2','wer','wer','wer','wer','wer','2008-03-15',20,'2008-03-31',30,29,'2008-04-30');
72insert into `courses` (`id`,`gr_id`,`course_aim`,`content`,`venue`,`organiser`,`target_group`,`prec_req`,`certification`,`stime`,`duration`,`deadline`,`noplaces`,`placesleft`,`retraining`) values (2,2,'asdf','asdf','ds','sdfffds','sdffds','sdffdsdf','sdfsdfs','2008-03-14',0,'0000-00-00',0,1,'0000-00-00');
73insert into `courses` (`id`,`gr_id`,`course_aim`,`content`,`venue`,`organiser`,`target_group`,`prec_req`,`certification`,`stime`,`duration`,`deadline`,`noplaces`,`placesleft`,`retraining`) values (3,1,'aaaaaa','aaaa','aaacccc','abababab','aeaeaeaeae','arrrrrrr','cfcfcfcf','2008-03-16',20,'2008-03-25',10,4,'2008-03-31');
74insert into `courses` (`id`,`gr_id`,`course_aim`,`content`,`venue`,`organiser`,`target_group`,`prec_req`,`certification`,`stime`,`duration`,`deadline`,`noplaces`,`placesleft`,`retraining`) values (4,2,'sdfg','sdfg','sdfg','sdfg','sdfg','sdfg','sdfg','2008-03-20',0,NULL,0,1,NULL);
75insert into `courses` (`id`,`gr_id`,`course_aim`,`content`,`venue`,`organiser`,`target_group`,`prec_req`,`certification`,`stime`,`duration`,`deadline`,`noplaces`,`placesleft`,`retraining`) values (6,3,'sdfg','sdfg','sdfg','sdfgsdfg','g','gsdfg','sdfg','2008-03-14',40,'2008-03-31',55,43,'2008-05-29');
76insert into `courses` (`id`,`gr_id`,`course_aim`,`content`,`venue`,`organiser`,`target_group`,`prec_req`,`certification`,`stime`,`duration`,`deadline`,`noplaces`,`placesleft`,`retraining`) values (7,3,'[copy] sdfg','sdfg','sdfg','sdfgsdfg','g','gsdfg','sdfg','2008-03-14',40,'2008-03-31',55,1,'2008-05-29');
77
78/*Table structure for table `depts` */
79
80CREATE TABLE `depts` (
81  `id` int(4) NOT NULL auto_increment,
82  `name` varchar(255) default NULL,
83  PRIMARY KEY  (`id`)
84) ENGINE=InnoDB DEFAULT CHARSET=latin1;
85
86/*Data for the table `depts` */
87
88insert into `depts` (`id`,`name`) values (1,'dept1');
89insert into `depts` (`id`,`name`) values (2,'dept2');
90insert into `depts` (`id`,`name`) values (3,'dept3');
91
92/*Table structure for table `heads` */
93
94CREATE TABLE `heads` (
95  `id` int(4) NOT NULL auto_increment,
96  `id_dept` int(4) default NULL,
97  `name` varchar(255) default NULL,
98  `emailadr` varchar(255) default NULL,
99  PRIMARY KEY  (`id`)
100) ENGINE=InnoDB DEFAULT CHARSET=latin1;
101
102/*Data for the table `heads` */
103
104insert into `heads` (`id`,`id_dept`,`name`,`emailadr`) values (1,1,'head1','sdfsdf');
105insert into `heads` (`id`,`id_dept`,`name`,`emailadr`) values (2,2,'head2','sdfsdf');
106insert into `heads` (`id`,`id_dept`,`name`,`emailadr`) values (3,1,'head11','ginfocomp@yahoo.com');
107
108/*Table structure for table `pagecategs` */
109
110CREATE TABLE `pagecategs` (
111  `id` int(4) NOT NULL auto_increment,
112  `supcat` int(4) default '0',
113  `name` varchar(255) default NULL,
114  `colour` varchar(7) default NULL,
115  `description` text,
116  `active` smallint(1) default '0',
117  `restrict` smallint(1) default '0',
118  PRIMARY KEY  (`id`)
119) ENGINE=InnoDB DEFAULT CHARSET=latin1;
120
121/*Data for the table `pagecategs` */
122
123insert into `pagecategs` (`id`,`supcat`,`name`,`colour`,`description`,`active`,`restrict`) values (1,0,'Welcome',NULL,'',1,0);
124insert into `pagecategs` (`id`,`supcat`,`name`,`colour`,`description`,`active`,`restrict`) values (2,0,'About the Office',NULL,'',1,0);
125insert into `pagecategs` (`id`,`supcat`,`name`,`colour`,`description`,`active`,`restrict`) values (3,0,'NUI, Galway Safety Statement',NULL,'',1,0);
126insert into `pagecategs` (`id`,`supcat`,`name`,`colour`,`description`,`active`,`restrict`) values (4,0,'Training courses ',NULL,'',1,0);
127insert into `pagecategs` (`id`,`supcat`,`name`,`colour`,`description`,`active`,`restrict`) values (6,0,'Emergency Information ',NULL,NULL,1,0);
128insert into `pagecategs` (`id`,`supcat`,`name`,`colour`,`description`,`active`,`restrict`) values (7,0,'Information Resources',NULL,NULL,1,0);
129insert into `pagecategs` (`id`,`supcat`,`name`,`colour`,`description`,`active`,`restrict`) values (8,1,'About ','#ff0000','',1,0);
130insert into `pagecategs` (`id`,`supcat`,`name`,`colour`,`description`,`active`,`restrict`) values (9,1,'Services ',NULL,NULL,1,0);
131insert into `pagecategs` (`id`,`supcat`,`name`,`colour`,`description`,`active`,`restrict`) values (10,1,'NUI, Galway Safety Statement ',NULL,'',1,0);
132insert into `pagecategs` (`id`,`supcat`,`name`,`colour`,`description`,`active`,`restrict`) values (11,1,'Training courses ',NULL,NULL,1,0);
133insert into `pagecategs` (`id`,`supcat`,`name`,`colour`,`description`,`active`,`restrict`) values (12,1,'Emergency Information ',NULL,NULL,1,0);
134insert into `pagecategs` (`id`,`supcat`,`name`,`colour`,`description`,`active`,`restrict`) values (13,1,'Information resources ',NULL,NULL,1,0);
135insert into `pagecategs` (`id`,`supcat`,`name`,`colour`,`description`,`active`,`restrict`) values (15,6,'Emergency Telephone Numbers',NULL,NULL,1,0);
136insert into `pagecategs` (`id`,`supcat`,`name`,`colour`,`description`,`active`,`restrict`) values (16,6,'Occupational First Aiders',NULL,NULL,1,0);
137insert into `pagecategs` (`id`,`supcat`,`name`,`colour`,`description`,`active`,`restrict`) values (17,6,'Fire Procedures',NULL,NULL,1,0);
138insert into `pagecategs` (`id`,`supcat`,`name`,`colour`,`description`,`active`,`restrict`) values (18,6,'Local Procedure',NULL,NULL,1,0);
139insert into `pagecategs` (`id`,`supcat`,`name`,`colour`,`description`,`active`,`restrict`) values (19,6,'General Advice',NULL,NULL,1,0);
140insert into `pagecategs` (`id`,`supcat`,`name`,`colour`,`description`,`active`,`restrict`) values (20,2,'About the office',NULL,NULL,1,0);
141
142/*Table structure for table `pagecontents` */
143
144CREATE TABLE `pagecontents` (
145  `id` int(4) NOT NULL auto_increment,
146  `gr_id` int(4) NOT NULL default '0',
147  `title` varchar(255) default NULL,
148  `text_content` blob,
149  `pic1` varchar(255) default NULL,
150  `pic2` varchar(255) default NULL,
151  `pic3` varchar(255) default NULL,
152  `bannerpic` varchar(255) default NULL,
153  PRIMARY KEY  (`id`),
154  UNIQUE KEY `id` (`id`)
155) ENGINE=InnoDB DEFAULT CHARSET=latin1;
156
157/*Data for the table `pagecontents` */
158
159insert into `pagecontents` (`id`,`gr_id`,`title`,`text_content`,`pic1`,`pic2`,`pic3`,`bannerpic`) values (4,8,'About','About <span style=\"font-style: italic; font-weight: bold;\">text </span>content          ','','','',NULL);
160insert into `pagecontents` (`id`,`gr_id`,`title`,`text_content`,`pic1`,`pic2`,`pic3`,`bannerpic`) values (5,12,'Emergency Information Title','Emergency Information Content','','','',NULL);
161insert into `pagecontents` (`id`,`gr_id`,`title`,`text_content`,`pic1`,`pic2`,`pic3`,`bannerpic`) values (6,15,'Emergency Telephone Numbers ','555-123321 <br>\r\n444-123321 <br>\r\n666-567765 <br>\r\n555-123321 <br>\r\n444-123321 <br>\r\n666-567765 <br>\r\n555-1233214 <br>\r\n444-123321 <br>\r\n666-567765 <br>\r\n555-123321 <br>\r\n444-123321 <br>\r\n666-567765 <br>\r\n','','','PULSAR.GIF',NULL);
162insert into `pagecontents` (`id`,`gr_id`,`title`,`text_content`,`pic1`,`pic2`,`pic3`,`bannerpic`) values (7,17,'Fire Procedures ','STOP, DROP AND ROLL','','','',NULL);
163insert into `pagecontents` (`id`,`gr_id`,`title`,`text_content`,`pic1`,`pic2`,`pic3`,`bannerpic`) values (11,10,'sdfsdf','sdfsdf sdf sdf sdf ',NULL,NULL,NULL,NULL);
164insert into `pagecontents` (`id`,`gr_id`,`title`,`text_content`,`pic1`,`pic2`,`pic3`,`bannerpic`) values (12,9,'wolcomeserv','      Welcome <span style=\"font-weight: bold;\">Services </span>                  ',NULL,NULL,NULL,'students.jpg');
165insert into `pagecontents` (`id`,`gr_id`,`title`,`text_content`,`pic1`,`pic2`,`pic3`,`bannerpic`) values (13,11,NULL,NULL,NULL,NULL,NULL,NULL);
166insert into `pagecontents` (`id`,`gr_id`,`title`,`text_content`,`pic1`,`pic2`,`pic3`,`bannerpic`) values (14,16,NULL,NULL,NULL,NULL,NULL,NULL);
167insert into `pagecontents` (`id`,`gr_id`,`title`,`text_content`,`pic1`,`pic2`,`pic3`,`bannerpic`) values (15,20,'About the Office','qgvdw',NULL,NULL,NULL,NULL);
168
169/*Table structure for table `pagefiles` */
170
171CREATE TABLE `pagefiles` (
172  `id` int(4) NOT NULL auto_increment,
173  `page_id` int(4) NOT NULL,
174  `text_link` varchar(255) NOT NULL,
175  `filename` varchar(255) NOT NULL,
176  PRIMARY KEY  (`id`),
177  UNIQUE KEY `id` (`id`)
178) ENGINE=InnoDB DEFAULT CHARSET=latin1;
179
180/*Data for the table `pagefiles` */
181
182insert into `pagefiles` (`id`,`page_id`,`text_link`,`filename`) values (1,6,'tertert','tst.txt');
183insert into `pagefiles` (`id`,`page_id`,`text_link`,`filename`) values (3,11,'dfghdfgh','tst.txt');
184insert into `pagefiles` (`id`,`page_id`,`text_link`,`filename`) values (4,12,'dfghdfgh','tst.txt');
185insert into `pagefiles` (`id`,`page_id`,`text_link`,`filename`) values (5,13,'tst','tst.txt');
186insert into `pagefiles` (`id`,`page_id`,`text_link`,`filename`) values (6,12,'ert','tst.txt');
187
188/*Table structure for table `pagelinks` */
189
190CREATE TABLE `pagelinks` (
191  `id` int(4) NOT NULL auto_increment,
192  `page_id` int(4) NOT NULL,
193  `text_link` varchar(255) default NULL,
194  `type` tinyint(1) default '0',
195  `link_url` varchar(255) default NULL,
196  PRIMARY KEY  (`id`)
197) ENGINE=InnoDB DEFAULT CHARSET=latin1;
198
199/*Data for the table `pagelinks` */
200
201insert into `pagelinks` (`id`,`page_id`,`text_link`,`type`,`link_url`) values (3,6,'yahoo',0,'http://www.yahoo.com');
202insert into `pagelinks` (`id`,`page_id`,`text_link`,`type`,`link_url`) values (4,6,'google',1,'http://www.google.ro');
203insert into `pagelinks` (`id`,`page_id`,`text_link`,`type`,`link_url`) values (5,6,'altavista',0,'http://www.altavista.com');
204insert into `pagelinks` (`id`,`page_id`,`text_link`,`type`,`link_url`) values (8,11,'sdfsdf',0,'sdfsdf.com');
205insert into `pagelinks` (`id`,`page_id`,`text_link`,`type`,`link_url`) values (9,5,'dfgdfgdfg',0,'dfgdfgdfg.com');
206insert into `pagelinks` (`id`,`page_id`,`text_link`,`type`,`link_url`) values (10,12,'gggggg',0,'www.ggggg.com');
207insert into `pagelinks` (`id`,`page_id`,`text_link`,`type`,`link_url`) values (11,4,'emergency telephone numbers',1,'index.php?menu=6&page=15');
208insert into `pagelinks` (`id`,`page_id`,`text_link`,`type`,`link_url`) values (12,4,'About the Office ',1,'index.php?menu=2');
209insert into `pagelinks` (`id`,`page_id`,`text_link`,`type`,`link_url`) values (13,14,'fff',0,NULL);
210insert into `pagelinks` (`id`,`page_id`,`text_link`,`type`,`link_url`) values (14,14,'ff',0,NULL);
211insert into `pagelinks` (`id`,`page_id`,`text_link`,`type`,`link_url`) values (15,14,'ff',0,NULL);
212insert into `pagelinks` (`id`,`page_id`,`text_link`,`type`,`link_url`) values (16,14,'fff',0,NULL);
213insert into `pagelinks` (`id`,`page_id`,`text_link`,`type`,`link_url`) values (17,14,'fff',0,NULL);
214insert into `pagelinks` (`id`,`page_id`,`text_link`,`type`,`link_url`) values (18,14,'fff',0,NULL);
215insert into `pagelinks` (`id`,`page_id`,`text_link`,`type`,`link_url`) values (19,14,'fff',0,NULL);
216
217/*Table structure for table `updates` */
218
219CREATE TABLE `updates` (
220  `id` int(4) NOT NULL auto_increment,
221  `name` varchar(255) default NULL,
222  `description` text,
223  `link` varchar(255) default NULL,
224  `homepage` smallint(1) NOT NULL default '0',
225  PRIMARY KEY  (`id`)
226) ENGINE=InnoDB DEFAULT CHARSET=latin1;
227
228/*Data for the table `updates` */
229
230insert into `updates` (`id`,`name`,`description`,`link`,`homepage`) values (1,'sdfg1','sdfg','index.php?menu=1&page=9',1);
231insert into `updates` (`id`,`name`,`description`,`link`,`homepage`) values (2,'sdfg','sdfg','sdfg',0);
232insert into `updates` (`id`,`name`,`description`,`link`,`homepage`) values (3,'aaa','aaa','index.php?menu=1&page=9',1);
233
234/*Table structure for table `userapply` */
235
236CREATE TABLE `userapply` (
237  `id` int(4) NOT NULL auto_increment,
238  `userid` int(4) default NULL,
239  `courseid` int(4) default NULL,
240  `status` smallint(1) default '0',
241  PRIMARY KEY  (`id`)
242) ENGINE=InnoDB DEFAULT CHARSET=latin1;
243
244/*Data for the table `userapply` */
245
246insert into `userapply` (`id`,`userid`,`courseid`,`status`) values (3,2,1,0);
247insert into `userapply` (`id`,`userid`,`courseid`,`status`) values (20,4,6,1);
248insert into `userapply` (`id`,`userid`,`courseid`,`status`) values (31,6,1,0);
249insert into `userapply` (`id`,`userid`,`courseid`,`status`) values (40,6,7,3);
250insert into `userapply` (`id`,`userid`,`courseid`,`status`) values (42,4,3,0);
251
252/*Table structure for table `users` */
253
254CREATE TABLE `users` (
255  `id` int(4) NOT NULL auto_increment,
256  `username` varchar(255) default NULL,
257  `password` varchar(32) default NULL,
258  `active` smallint(1) default '0',
259  `name` varchar(255) default NULL,
260  `dept_id` int(4) default NULL,
261  `ext_number` varchar(10) default NULL,
262  `emailadr` varchar(255) default NULL,
263  `stuff_id` varchar(30) default NULL,
264  `head_id` int(4) default NULL,
265  `auth_super_name` varchar(255) default NULL,
266  `auth_super_email` varchar(255) default NULL,
267  `special_need` text,
268  PRIMARY KEY  (`id`)
269) ENGINE=InnoDB DEFAULT CHARSET=latin1;
270
271/*Data for the table `users` */
272
273insert into `users` (`id`,`username`,`password`,`active`,`name`,`dept_id`,`ext_number`,`emailadr`,`stuff_id`,`head_id`,`auth_super_name`,`auth_super_email`,`special_need`) values (1,'user1','pass1',0,NULL,1,'',NULL,NULL,NULL,NULL,NULL,NULL);
274insert into `users` (`id`,`username`,`password`,`active`,`name`,`dept_id`,`ext_number`,`emailadr`,`stuff_id`,`head_id`,`auth_super_name`,`auth_super_email`,`special_need`) values (2,'qwe','qwep',1,'qwe',2,'','ginfocomp@yahoo.com','',NULL,'qwe','ovipt@yahoo.com','qweqwe');
275insert into `users` (`id`,`username`,`password`,`active`,`name`,`dept_id`,`ext_number`,`emailadr`,`stuff_id`,`head_id`,`auth_super_name`,`auth_super_email`,`special_need`) values (3,'sdf','sdfp',1,'sdf',2,'','ginfocomp@yahoo.com',NULL,NULL,'sdf','sdf','sdf');
276insert into `users` (`id`,`username`,`password`,`active`,`name`,`dept_id`,`ext_number`,`emailadr`,`stuff_id`,`head_id`,`auth_super_name`,`auth_super_email`,`special_need`) values (4,'user5','pass5',1,'er re',3,'','ovipt@yahoo.com','344',NULL,'Xu','ginfocomp@yahoo.com','need to test');
277insert into `users` (`id`,`username`,`password`,`active`,`name`,`dept_id`,`ext_number`,`emailadr`,`stuff_id`,`head_id`,`auth_super_name`,`auth_super_email`,`special_need`) values (6,'user6','pass6',1,'user_6',1,'123','nrpo@mail.com','234',NULL,'nrpo','nrpo@mail.com','qwe req');
278
279SET SQL_MODE=@OLD_SQL_MODE;