8YgFWj5h

1
2--
3-- Base de données: FULL FLASH CMS TEMPLATE CAMALEON
4--
5
6-- --------------------------------------------------------
7
8--
9-- Structure de la table `cms_about_v1`
10--
11
12CREATE TABLE IF NOT EXISTS `cms_about_v1` (
13  `id` int(11) NOT NULL auto_increment,
14  `date` varchar(100) character set utf8 collate utf8_unicode_ci NOT NULL default '',
15  `headline` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL default '',
16  `details` text character set utf8 collate utf8_unicode_ci NOT NULL,
17  `link` tinytext character set utf8 collate utf8_unicode_ci NOT NULL,
18  `thumbnail` tinytext character set utf8 collate utf8_unicode_ci NOT NULL,
19  `image` tinytext character set utf8 collate utf8_unicode_ci NOT NULL,
20  PRIMARY KEY  (`id`)
21) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
22
23-- --------------------------------------------------------
24
25--
26-- Structure de la table `cms_contact_v1`
27--
28
29CREATE TABLE IF NOT EXISTS `cms_contact_v1` (
30  `id` int(11) NOT NULL auto_increment,
31  `fullname` tinytext character set utf8 collate utf8_unicode_ci NOT NULL,
32  `phone` tinytext character set utf8 collate utf8_unicode_ci NOT NULL,
33  `email` tinytext character set utf8 collate utf8_unicode_ci NOT NULL,
34  `adress` tinytext character set utf8 collate utf8_unicode_ci NOT NULL,
35  `thumbnail` tinytext character set utf8 collate utf8_unicode_ci NOT NULL,
36  PRIMARY KEY  (`id`)
37) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
38
39-- --------------------------------------------------------
40
41--
42-- Structure de la table `cms_guestbook_v1`
43--
44
45CREATE TABLE IF NOT EXISTS `cms_guestbook_v1` (
46  `id` int(11) NOT NULL auto_increment,
47  `date` varchar(100) character set utf8 collate utf8_unicode_ci NOT NULL default '',
48  `headline` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL default '',
49  `details` text character set utf8 collate utf8_unicode_ci NOT NULL,
50  `link` tinytext character set utf8 collate utf8_unicode_ci NOT NULL,
51  `email` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL default '',
52  `country` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL default '',
53  `thumbnail` tinytext character set utf8 collate utf8_unicode_ci NOT NULL,
54  PRIMARY KEY  (`id`)
55) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
56
57-- --------------------------------------------------------
58
59--
60-- Structure de la table `cms_links_v1`
61--
62
63CREATE TABLE IF NOT EXISTS `cms_links_v1` (
64  `id` int(11) NOT NULL auto_increment,
65  `date` varchar(100) character set utf8 collate utf8_unicode_ci NOT NULL default '',
66  `headline` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL default '',
67  `details` text character set utf8 collate utf8_unicode_ci NOT NULL,
68  `link` tinytext character set utf8 collate utf8_unicode_ci NOT NULL,
69  `thumbnail` tinytext character set utf8 collate utf8_unicode_ci NOT NULL,
70  PRIMARY KEY  (`id`)
71) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
72
73-- --------------------------------------------------------
74
75--
76-- Structure de la table `cms_login_v1`
77--
78
79CREATE TABLE IF NOT EXISTS `cms_login_v1` (
80  `id` int(11) NOT NULL auto_increment,
81  `username` varchar(100) NOT NULL default '',
82  `userpassword` varchar(100) NOT NULL default '',
83  PRIMARY KEY  (`id`)
84) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
85
86-- --------------------------------------------------------
87
88--
89-- Structure de la table `cms_news_v1`
90--
91
92CREATE TABLE IF NOT EXISTS `cms_news_v1` (
93  `id` int(11) NOT NULL auto_increment,
94  `date` varchar(100) character set utf8 collate utf8_unicode_ci NOT NULL default '',
95  `headline` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL default '',
96  `details` text character set utf8 collate utf8_unicode_ci NOT NULL,
97  `link` tinytext character set utf8 collate utf8_unicode_ci NOT NULL,
98  `thumbnail` tinytext character set utf8 collate utf8_unicode_ci NOT NULL,
99  `image` tinytext character set utf8 collate utf8_unicode_ci NOT NULL,
100  PRIMARY KEY  (`id`)
101) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
102
103-- --------------------------------------------------------
104
105--
106-- Structure de la table `cms_portfolio_v1`
107--
108
109CREATE TABLE IF NOT EXISTS `cms_portfolio_v1` (
110  `id` int(11) NOT NULL auto_increment,
111  `date` varchar(100) character set utf8 collate utf8_unicode_ci NOT NULL default '',
112  `headline` varchar(250) character set utf8 collate utf8_unicode_ci NOT NULL default '',
113  `details` text character set utf8 collate utf8_unicode_ci NOT NULL,
114  `link` tinytext character set utf8 collate utf8_unicode_ci NOT NULL,
115  `thumbnail` tinytext character set utf8 collate utf8_unicode_ci NOT NULL,
116  `image` tinytext character set utf8 collate utf8_unicode_ci NOT NULL,
117  PRIMARY KEY  (`id`)
118) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;