# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost Database : agenda

# --------------------------------------------------------
#
# Table structure for table 'AGENDA'
#

CREATE TABLE AGENDA (
   agenda tinyint(4) DEFAULT '0' NOT NULL auto_increment,
   user tinyint(4) DEFAULT '0' NOT NULL,
   path varchar(20) DEFAULT '0' NOT NULL,
   seccao tinyint(4) DEFAULT '0' NOT NULL,
   dataini date DEFAULT '0000-00-00' NOT NULL,
   datalim date DEFAULT '0000-00-00' NOT NULL,
   titulo varchar(200) NOT NULL,
   texto text NOT NULL,
   img varchar(200) NOT NULL,
   PRIMARY KEY (agenda)
);

#
# Dumping data for table 'AGENDA'
#

INSERT INTO AGENDA VALUES ( '44', '1', ';1;2;5;', '1', '2001-05-16', '2001-05-16', 'Xutos e Pontapés', '24:00 - Concerto dos Xutos e Pontapés no NERVA

Semana Académica de Bragança', '');
INSERT INTO AGENDA VALUES ( '43', '2', ';1;2;8;', '7', '2001-05-16', '2001-05-16', '2001-5-16', '2001-5-16', '');
INSERT INTO AGENDA VALUES ( '42', '2', ';1;2;5;', '4', '2001-05-16', '2001-05-16', 'Xutos e Pontapés', '24:00 - Concerto dos Xutos e Pontapés no NERVA

Semana Académica de Bragança', '');
INSERT INTO AGENDA VALUES ( '37', '1', ';1;2;4;', '4', '2001-05-17', '2001-05-17', 'xx', 'xx', '');
INSERT INTO AGENDA VALUES ( '38', '1', ';1;2;4;', '1', '2001-05-17', '2001-05-17', 'xx', 'xx', '');
INSERT INTO AGENDA VALUES ( '36', '1', ';1;2;4;', '3', '2001-01-01', '2001-06-06', '9999', '9999999999', '');

# --------------------------------------------------------
#
# Table structure for table 'LOCAL'
#

CREATE TABLE LOCAL (
   local tinyint(4) DEFAULT '0' NOT NULL auto_increment,
   nome varchar(200) NOT NULL,
   link tinyint(4) DEFAULT '0' NOT NULL,
   path varchar(20) NOT NULL,
   PRIMARY KEY (local)
);

#
# Dumping data for table 'LOCAL'
#

INSERT INTO LOCAL VALUES ( '1', 'Trás-os-montes', '0', ';1;');
INSERT INTO LOCAL VALUES ( '2', 'Distritro de Bragança', '1', ';1;2;');
INSERT INTO LOCAL VALUES ( '3', 'Distritro de Vila Real', '1', ';1;3;');
INSERT INTO LOCAL VALUES ( '6', 'Carrazeda de Ansiães', '2', ';1;2;6;');
INSERT INTO LOCAL VALUES ( '7', 'Freixo de Espada à Cinta', '2', ';1;2;7;');
INSERT INTO LOCAL VALUES ( '4', 'Alfândega da Fé', '2', ';1;2;4;');
INSERT INTO LOCAL VALUES ( '5', 'Bragança', '2', ';1;2;5;');
INSERT INTO LOCAL VALUES ( '8', 'Macedo de Cavaleiros', '2', ';1;2;8;');
INSERT INTO LOCAL VALUES ( '9', 'Miranda do Douro', '2', ';1;2;9;');
INSERT INTO LOCAL VALUES ( '10', 'Mirandela', '2', ';1;2;10;');
INSERT INTO LOCAL VALUES ( '11', 'Mogadouro', '2', ';1;2;11;');
INSERT INTO LOCAL VALUES ( '12', 'Torre de Moncorvo', '2', ';1;2;12;');
INSERT INTO LOCAL VALUES ( '13', 'Vila Flor', '2', ';1;2;13;');
INSERT INTO LOCAL VALUES ( '14', 'Vimioso', '2', ';1;2;14;');
INSERT INTO LOCAL VALUES ( '15', 'Vinhais', '2', ';1;2;15;');
INSERT INTO LOCAL VALUES ( '16', 'Alijó', '3', ';1;3;16;');
INSERT INTO LOCAL VALUES ( '17', 'Boticas', '3', ';1;3;17;');
INSERT INTO LOCAL VALUES ( '18', 'Chaves', '3', ';1;3;18;');
INSERT INTO LOCAL VALUES ( '19', 'Mesão Frio', '3', ';1;3;19;');
INSERT INTO LOCAL VALUES ( '20', 'Mondim de Bastos', '3', ';1;3;20;');
INSERT INTO LOCAL VALUES ( '21', 'Montalegre', '3', ';1;3;21;');
INSERT INTO LOCAL VALUES ( '22', 'Murga', '3', ';1;3;22;');
INSERT INTO LOCAL VALUES ( '23', 'Peso da Régua', '3', ';1;3;23;');
INSERT INTO LOCAL VALUES ( '24', 'Ribeira de Pena', '3', ';1;3;24;');
INSERT INTO LOCAL VALUES ( '25', 'Sabrosa', '3', ';1;3;25;');
INSERT INTO LOCAL VALUES ( '26', 'Stª Marta de Penaguião', '3', ';1;3;26;');
INSERT INTO LOCAL VALUES ( '27', 'Valpaços', '3', ';1;3;27;');
INSERT INTO LOCAL VALUES ( '28', 'Vila Pouca de Aguiar', '3', ';1;3;28;');
INSERT INTO LOCAL VALUES ( '29', 'Vila Real', '3', ';1;3;29;');

# --------------------------------------------------------
#
# Table structure for table 'SECCAO'
#

CREATE TABLE SECCAO (
   seccao int(11) DEFAULT '0' NOT NULL auto_increment,
   nome varchar(200) NOT NULL,
   disponivel char(1) NOT NULL,
   PRIMARY KEY (seccao)
);

#
# Dumping data for table 'SECCAO'
#

INSERT INTO SECCAO VALUES ( '1', 'Destaque', 'n');
INSERT INTO SECCAO VALUES ( '2', 'Desporto', 's');
INSERT INTO SECCAO VALUES ( '3', 'Cinema', 's');
INSERT INTO SECCAO VALUES ( '4', 'Concertos', 's');
INSERT INTO SECCAO VALUES ( '5', 'Exposições', 's');
INSERT INTO SECCAO VALUES ( '6', 'Feiras', 'n');
INSERT INTO SECCAO VALUES ( '7', 'Festas', 's');
INSERT INTO SECCAO VALUES ( '8', 'Romarias', 's');
INSERT INTO SECCAO VALUES ( '9', 'Teatro', 's');
INSERT INTO SECCAO VALUES ( '10', 'Missas', 'n');

# --------------------------------------------------------
#
# Table structure for table 'auth_user'
#

CREATE TABLE auth_user (
   user tinyint(4) DEFAULT '0' NOT NULL auto_increment,
   login varchar(20) NOT NULL,
   password varchar(30) NOT NULL,
   perm varchar(30) NOT NULL,
   nome varchar(255) NOT NULL,
   email varchar(150) NOT NULL,
   activo char(1) NOT NULL,
   PRIMARY KEY (user)
);

#
# Dumping data for table 'auth_user'
#

INSERT INTO auth_user VALUES ( '1', 'moga', '1952a56a4b571c5f', 'admin', 'Jorge Varejão', 'mogadix@bcd.pt', 's');
INSERT INTO auth_user VALUES ( '2', 'x', '606706156665cd86', 'Utilizador', 'meu nome', 'x@x.pt', 's');