Z5kX0zPR

1-- MySQL Administrator dump 1.4
2--
3-- ------------------------------------------------------
4-- Server version	5.0.26
5
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11
12/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15
16
17--
18-- Create schema BDsol
19--
20
21CREATE DATABASE IF NOT EXISTS BDsol;
22USE BDsol;
23
24--
25-- Definition of table `BDsol`.`Noticias`
26--
27
28DROP TABLE IF EXISTS `BDsol`.`Noticias`;
29CREATE TABLE  `BDsol`.`Noticias` (
30  `id` int(11) NOT NULL auto_increment,
31  `id_seccion` int(11) NOT NULL,
32  `antetitulo` text,
33  `titulo` text,
34  `cuerpo` text,
35  `fecha` datetime default NULL,
36  `imagen_id` text,
37  `reportero` text,
38  `fuente` text,
39  PRIMARY KEY  USING BTREE (`id`,`id_seccion`)
40) ENGINE=MyISAM DEFAULT CHARSET=latin1;
41
42--
43-- Dumping data for table `BDsol`.`Noticias`
44--
45
46/*!40000 ALTER TABLE `Noticias` DISABLE KEYS */;
47LOCK TABLES `Noticias` WRITE;
48UNLOCK TABLES;
49/*!40000 ALTER TABLE `Noticias` ENABLE KEYS */;
50
51
52--
53-- Definition of table `BDsol`.`seccion`
54--
55
56DROP TABLE IF EXISTS `BDsol`.`seccion`;
57CREATE TABLE  `BDsol`.`seccion` (
58  `id` int(11) NOT NULL auto_increment,
59  `nombre` text NOT NULL,
60  `hint` text NOT NULL,
61  `orden` int(11) NOT NULL,
62  PRIMARY KEY  (`id`)
63) ENGINE=MyISAM DEFAULT CHARSET=latin1;
64
65--
66-- Dumping data for table `BDsol`.`seccion`
67--
68
69/*!40000 ALTER TABLE `seccion` DISABLE KEYS */;
70LOCK TABLES `seccion` WRITE;
71UNLOCK TABLES;
72/*!40000 ALTER TABLE `seccion` ENABLE KEYS */;
73
74
75
76
77/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
78/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
79/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
80/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
81/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
82/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
83/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;