001: -- phpMyAdmin SQL Dump
002: -- version 2.11.10
003: -- http://www.phpmyadmin.net
004: --
005: -- Serveur: localhost
006: -- G�n�r� le : Sam 06 Novembre 2010 � 11:59
007: -- Version du serveur: 5.0.84
008: -- Version de PHP: 5.2.11
009:
010: SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
011:
012:
013: /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
014: /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
015: /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
016: /*!40101 SET NAMES utf8 */;
017:
018: -- --------------------------------------------------------
019:
020: --
021: -- Structure de la table `content_field_entity_address`
022: --
023:
024: CREATE TABLE IF NOT EXISTS `content_field_entity_address` (
025: `vid` int(10) unsigned NOT NULL default '0',
026: `nid` int(10) unsigned NOT NULL default '0',
027: `field_entity_address_value` longtext,
028: PRIMARY KEY (`vid`),
029: KEY `nid` (`nid`)
030: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
031:
032: --
033: -- Contenu de la table `content_field_entity_address`
034: --
035:
036: -- --------------------------------------------------------
037:
038: --
039: -- Structure de la table `content_field_entity_city`
040: --
041:
042: CREATE TABLE IF NOT EXISTS `content_field_entity_city` (
043: `vid` int(10) unsigned NOT NULL default '0',
044: `nid` int(10) unsigned NOT NULL default '0',
045: `field_entity_city_value` longtext,
046: PRIMARY KEY (`vid`),
047: KEY `nid` (`nid`)
048: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
049:
050: --
051: -- Contenu de la table `content_field_entity_city`
052: --
053:
054: -- --------------------------------------------------------
055:
056: --
057: -- Structure de la table `content_field_entity_contactperson`
058: --
059:
060: CREATE TABLE IF NOT EXISTS `content_field_entity_contactperson` (
061: `vid` int(10) unsigned NOT NULL default '0',
062: `nid` int(10) unsigned NOT NULL default '0',
063: `field_entity_contactperson_value` longtext,
064: PRIMARY KEY (`vid`),
065: KEY `nid` (`nid`)
066: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
067:
068: --
069: -- Contenu de la table `content_field_entity_contactperson`
070: --
071:
072: -- --------------------------------------------------------
073:
074: --
075: -- Structure de la table `content_field_entity_faxnumber`
076: --
077:
078: CREATE TABLE IF NOT EXISTS `content_field_entity_faxnumber` (
079: `vid` int(10) unsigned NOT NULL default '0',
080: `nid` int(10) unsigned NOT NULL default '0',
081: `field_entity_faxnumber_value` varchar(255) default NULL,
082: PRIMARY KEY (`vid`),
083: KEY `nid` (`nid`)
084: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
085:
086: --
087: -- Contenu de la table `content_field_entity_faxnumber`
088: --
089:
090: -- --------------------------------------------------------
091:
092: --
093: -- Structure de la table `content_field_entity_longdesc`
094: --
095:
096: CREATE TABLE IF NOT EXISTS `content_field_entity_longdesc` (
097: `vid` int(10) unsigned NOT NULL default '0',
098: `nid` int(10) unsigned NOT NULL default '0',
099: `field_entity_longdesc_value` longtext,
100: `field_entity_longdesc_format` int(10) unsigned default NULL,
101: PRIMARY KEY (`vid`),
102: KEY `nid` (`nid`)
103: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
104:
105: --
106: -- Contenu de la table `content_field_entity_longdesc`
107: --
108:
109: -- --------------------------------------------------------
110:
111: --
112: -- Structure de la table `content_field_entity_mail`
113: --
114:
115: CREATE TABLE IF NOT EXISTS `content_field_entity_mail` (
116: `vid` int(10) unsigned NOT NULL default '0',
117: `nid` int(10) unsigned NOT NULL default '0',
118: `field_entity_mail_email` varchar(255) default NULL,
119: PRIMARY KEY (`vid`),
120: KEY `nid` (`nid`)
121: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
122:
123: --
124: -- Contenu de la table `content_field_entity_mail`
125: --
126:
127: -- --------------------------------------------------------
128:
129: --
130: -- Structure de la table `content_field_entity_npa`
131: --
132:
133: CREATE TABLE IF NOT EXISTS `content_field_entity_npa` (
134: `vid` int(10) unsigned NOT NULL default '0',
135: `nid` int(10) unsigned NOT NULL default '0',
136: `field_entity_npa_value` int(11) default NULL,
137: PRIMARY KEY (`vid`),
138: KEY `nid` (`nid`)
139: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
140:
141: --
142: -- Contenu de la table `content_field_entity_npa`
143: --
144:
145: -- --------------------------------------------------------
146:
147: --
148: -- Structure de la table `content_field_entity_phonenumber`
149: --
150:
151: CREATE TABLE IF NOT EXISTS `content_field_entity_phonenumber` (
152: `vid` int(10) unsigned NOT NULL default '0',
153: `nid` int(10) unsigned NOT NULL default '0',
154: `delta` int(10) unsigned NOT NULL default '0',
155: `field_entity_phonenumber_value` varchar(255) default NULL,
156: PRIMARY KEY (`vid`,`delta`),
157: KEY `nid` (`nid`)
158: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
159:
160: --
161: -- Contenu de la table `content_field_entity_phonenumber`
162: --
163:
164: -- --------------------------------------------------------
165:
166: --
167: -- Structure de la table `content_field_entity_phonenumber_more`
168: --
169:
170: CREATE TABLE IF NOT EXISTS `content_field_entity_phonenumber_more` (
171: `vid` int(10) unsigned NOT NULL default '0',
172: `nid` int(10) unsigned NOT NULL default '0',
173: `delta` int(10) unsigned NOT NULL default '0',
174: `field_entity_phonenumber_more_value` varchar(100) default NULL,
175: PRIMARY KEY (`vid`,`delta`),
176: KEY `nid` (`nid`)
177: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
178:
179: --
180: -- Contenu de la table `content_field_entity_phonenumber_more`
181: --
182:
183: -- --------------------------------------------------------
184:
185: --
186: -- Structure de la table `content_field_entity_picture`
187: --
188:
189: CREATE TABLE IF NOT EXISTS `content_field_entity_picture` (
190: `vid` int(10) unsigned NOT NULL default '0',
191: `nid` int(10) unsigned NOT NULL default '0',
192: `field_entity_picture_fid` int(11) default NULL,
193: `field_entity_picture_list` tinyint(4) default NULL,
194: `field_entity_picture_data` text,
195: PRIMARY KEY (`vid`),
196: KEY `nid` (`nid`)
197: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
198:
199: --
200: -- Contenu de la table `content_field_entity_picture`
201: --
202:
203: -- --------------------------------------------------------
204:
205: --
206: -- Structure de la table `content_field_entity_region`
207: --
208:
209: CREATE TABLE IF NOT EXISTS `content_field_entity_region` (
210: `vid` int(10) unsigned NOT NULL default '0',
211: `nid` int(10) unsigned NOT NULL default '0',
212: `field_entity_region_value` int(11) default NULL,
213: PRIMARY KEY (`vid`),
214: KEY `nid` (`nid`)
215: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
216:
217: --
218: -- Contenu de la table `content_field_entity_region`
219: --
220:
221: -- --------------------------------------------------------
222:
223: --
224: -- Structure de la table `content_field_entity_shortdesc`
225: --
226:
227: CREATE TABLE IF NOT EXISTS `content_field_entity_shortdesc` (
228: `vid` int(10) unsigned NOT NULL default '0',
229: `nid` int(10) unsigned NOT NULL default '0',
230: `field_entity_shortdesc_value` longtext,
231: PRIMARY KEY (`vid`),
232: KEY `nid` (`nid`)
233: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
234:
235: --
236: -- Contenu de la table `content_field_entity_shortdesc`
237: --
238:
239: -- --------------------------------------------------------
240:
241: --
242: -- Structure de la table `content_field_entity_website`
243: --
244:
245: CREATE TABLE IF NOT EXISTS `content_field_entity_website` (
246: `vid` int(10) unsigned NOT NULL default '0',
247: `nid` int(10) unsigned NOT NULL default '0',
248: `field_entity_website_url` varchar(2048) default NULL,
249: `field_entity_website_title` varchar(255) default NULL,
250: `field_entity_website_attributes` mediumtext,
251: PRIMARY KEY (`vid`),
252: KEY `nid` (`nid`)
253: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
254:
255: --
256: -- Contenu de la table `content_field_entity_website`
257: --
258:
259: -- --------------------------------------------------------
260:
261: --
262: -- Structure de la table `content_field_event_city`
263: --
264:
265: CREATE TABLE IF NOT EXISTS `content_field_event_city` (
266: `vid` int(10) unsigned NOT NULL default '0',
267: `nid` int(10) unsigned NOT NULL default '0',
268: `delta` int(10) unsigned NOT NULL default '0',
269: `field_event_city_value` longtext,
270: PRIMARY KEY (`vid`,`delta`),
271: KEY `nid` (`nid`)
272: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
273:
274: --
275: -- Contenu de la table `content_field_event_city`
276: --
277:
278: -- --------------------------------------------------------
279:
280: --
281: -- Structure de la table `content_field_fetch_news`
282: --
283:
284: CREATE TABLE IF NOT EXISTS `content_field_fetch_news` (
285: `vid` int(10) unsigned NOT NULL default '0',
286: `nid` int(10) unsigned NOT NULL default '0',
287: `field_fetch_news_value` longtext,
288: PRIMARY KEY (`vid`),
289: KEY `nid` (`nid`)
290: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
291:
292: --
293: -- Contenu de la table `content_field_fetch_news`
294: --
295:
296: -- --------------------------------------------------------
297:
298: --
299: -- Structure de la table `content_type_entity`
300: --
301:
302: CREATE TABLE IF NOT EXISTS `content_type_entity` (
303: `vid` int(10) unsigned NOT NULL default '0',
304: `nid` int(10) unsigned NOT NULL default '0',
305: PRIMARY KEY (`vid`),
306: KEY `nid` (`nid`)
307: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
308:
309: --
310: -- Contenu de la table `content_type_entity`
311: --
312:
313: -- --------------------------------------------------------
314:
315: --
316: -- Structure de la table `content_type_hosting`
317: --
318:
319: CREATE TABLE IF NOT EXISTS `content_type_hosting` (
320: `vid` int(10) unsigned NOT NULL default '0',
321: `nid` int(10) unsigned NOT NULL default '0',
322: `field_hosting_category_value` int(11) default NULL,
323: `field_hosting_room_view_value` longtext,
324: `field_hosting_additional_value` longtext,
325: `field_hosting_additional_format` int(10) unsigned default NULL,
326: PRIMARY KEY (`vid`),
327: KEY `nid` (`nid`)
328: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
329:
330: --
331: -- Contenu de la table `content_type_hosting`
332: --
333:
334: -- --------------------------------------------------------
335:
336: --
337: -- Structure de la table `content_type_longdesc`
338: --
339:
340: CREATE TABLE IF NOT EXISTS `content_type_longdesc` (
341: `vid` int(10) unsigned NOT NULL default '0',
342: `nid` int(10) unsigned NOT NULL default '0',
343: `field_desc_hosting_nid_nid` int(10) unsigned default NULL,
344: PRIMARY KEY (`vid`),
345: KEY `nid` (`nid`),
346: KEY `field_desc_hosting_nid_nid` (`field_desc_hosting_nid_nid`)
347: ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
348:
349: --
350: -- Contenu de la table `content_type_longdesc`
351: --
352:
353: -- --------------------------------------------------------
354:
355: --
356: -- Structure de la table `node`
357: --
358:
359: CREATE TABLE IF NOT EXISTS `node` (
360: `nid` int(10) unsigned NOT NULL auto_increment,
361: `vid` int(10) unsigned NOT NULL default '0',
362: `type` varchar(32) NOT NULL default '',
363: `language` varchar(12) NOT NULL default '',
364: `title` varchar(255) NOT NULL default '',
365: `uid` int(11) NOT NULL default '0',
366: `status` int(11) NOT NULL default '1',
367: `created` int(11) NOT NULL default '0',
368: `changed` int(11) NOT NULL default '0',
369: `comment` int(11) NOT NULL default '0',
370: `promote` int(11) NOT NULL default '0',
371: `moderate` int(11) NOT NULL default '0',
372: `sticky` int(11) NOT NULL default '0',
373: `tnid` int(10) unsigned NOT NULL default '0',
374: `translate` int(11) NOT NULL default '0',
375: PRIMARY KEY (`nid`),
376: UNIQUE KEY `vid` (`vid`),
377: KEY `node_changed` (`changed`),
378: KEY `node_created` (`created`),
379: KEY `node_moderate` (`moderate`),
380: KEY `node_promote_status` (`promote`,`status`),
381: KEY `node_status_type` (`status`,`type`,`nid`),
382: KEY `node_title_type` (`title`,`type`(4)),
383: KEY `node_type` (`type`(4)),
384: KEY `uid` (`uid`),
385: KEY `tnid` (`tnid`),
386: KEY `translate` (`translate`)
387: ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=801 ;
388:
389: --
390: -- Contenu de la table `node`
391: --
392:
393: -- --------------------------------------------------------
394:
395: --
396: -- Structure de la table `node_revisions`
397: --
398:
399: CREATE TABLE IF NOT EXISTS `node_revisions` (
400: `nid` int(10) unsigned NOT NULL default '0',
401: `vid` int(10) unsigned NOT NULL auto_increment,
402: `uid` int(11) NOT NULL default '0',
403: `title` varchar(255) NOT NULL default '',
404: `body` longtext NOT NULL,
405: `teaser` longtext NOT NULL,
406: `log` longtext NOT NULL,
407: `timestamp` int(11) NOT NULL default '0',
408: `format` int(11) NOT NULL default '0',
409: PRIMARY KEY (`vid`),
410: KEY `nid` (`nid`),
411: KEY `uid` (`uid`)
412: ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=801 ;
413:
414: --
415: -- Contenu de la table `node_revisions`
416: --
417:
418: /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
419: /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
420: /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;