TY1kgp8j

1CREATE TABLE IF NOT EXISTS `fields` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `id_fields_type` tinyint(2) NOT NULL DEFAULT '1',
4  `active` tinyint(1) NOT NULL DEFAULT '1',
5  `user_id` int(11) NOT NULL,
6  `published_time` bigint(20) NOT NULL,
7  PRIMARY KEY (`id`)
8) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
9
10-- --------------------------------------------------------
11
12--
13-- Estrutura da tabela `fields_descriptions`
14--
15
16CREATE TABLE IF NOT EXISTS `fields_descriptions` (
17  `id` int(11) NOT NULL AUTO_INCREMENT,
18  `id_fields` int(11) NOT NULL,
19  `id_languages` tinyint(2) NOT NULL,
20  `title` varchar(250) NOT NULL,
21  `unit` varchar(100) NOT NULL,
22  `published_time` bigint(20) NOT NULL,
23  PRIMARY KEY (`id`)
24) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
25
26-- --------------------------------------------------------
27
28--
29-- Estrutura da tabela `fields_values`
30--
31
32CREATE TABLE IF NOT EXISTS `fields_values` (
33  `id` int(11) NOT NULL AUTO_INCREMENT,
34  `id_fields` int(11) NOT NULL,
35  `id_item` int(11) NOT NULL,
36  `id_table` varchar(50) NOT NULL,
37  `sort_order` int(11) NOT NULL,
38  `active` tinyint(1) NOT NULL DEFAULT '1',
39  `user_id` int(11) NOT NULL,
40  `published_time` bigint(20) NOT NULL,
41  PRIMARY KEY (`id`)
42) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
43
44-- --------------------------------------------------------
45
46--
47-- Estrutura da tabela `fields_values_descriptions`
48--
49
50CREATE TABLE IF NOT EXISTS `fields_values_descriptions` (
51  `id` int(11) NOT NULL AUTO_INCREMENT,
52  `id_fields_values` int(11) NOT NULL,
53  `id_languages` int(2) NOT NULL,
54  `value` varchar(250) NOT NULL,
55  PRIMARY KEY (`id`)
56) ENGINE=MyISAM  DEFAULT CHARSET=latin1;