-
Notifications
You must be signed in to change notification settings - Fork 22
/
sql_install.php
80 lines (73 loc) · 3.15 KB
/
sql_install.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
<?php
/*
* 2007-2016 PrestaShop
*
* NOTICE OF LICENSE
*
* This source file is subject to the Academic Free License (AFL 3.0)
* that is bundled with this package in the file LICENSE.txt.
* It is also available through the world-wide-web at this URL:
* http://opensource.org/licenses/afl-3.0.php
* If you did not receive a copy of the license and are unable to
* obtain it through the world-wide-web, please send an email
* to [email protected] so we can send you a copy immediately.
*
* DISCLAIMER
*
* Do not edit or add to this file if you wish to upgrade PrestaShop to newer
* versions in the future. If you wish to customize PrestaShop for your
* needs please refer to http://www.prestashop.com for more information.
*
* @author PrestaShop SA <[email protected]>
* @copyright 2007-2016 PrestaShop SA
* @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0)
* International Registered Trademark & Property of PrestaShop SA
*/
$sql = [];
$sql[_DB_PREFIX_ . 'condition'] = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'condition` (
`id_condition` int(11) NOT NULL AUTO_INCREMENT,
`id_ps_condition` int(11) NOT NULL,
`type` enum(\'configuration\', \'install\', \'sql\') NOT NULL,
`request` text ,
`operator` varchar(32),
`value` varchar(64),
`result` varchar(64),
`calculation_type` enum(\'hook\', \'time\'),
`calculation_detail` varchar(64),
`validated` tinyint(1) unsigned NOT NULL DEFAULT 0,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id_condition`, `id_ps_condition`)
) ENGINE=' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET=utf8;';
$sql[_DB_PREFIX_ . 'advice'] = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'advice` (
`id_advice` int(11) NOT NULL AUTO_INCREMENT,
`id_ps_advice` int(11) NOT NULL,
`id_tab` int(11) NOT NULL,
`ids_tab` TEXT,
`validated` tinyint(1) unsigned NOT NULL DEFAULT 0,
`hide` tinyint(1) NOT NULL DEFAULT 0,
`location` enum(\'after\', \'before\') NOT NULL,
`selector` varchar(255),
`start_day` int(11) NOT NULL DEFAULT 0,
`stop_day` int(11) NOT NULL DEFAULT 0,
`weight` int(11) NULL DEFAULT \'1\',
PRIMARY KEY (`id_advice`)
) ENGINE=' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET=utf8;';
$sql[_DB_PREFIX_ . 'advice_lang'] = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'advice_lang` (
`id_advice` int(11) NOT NULL,
`id_lang` int(11) NOT NULL,
`html` TEXT,
PRIMARY KEY (`id_advice`, `id_lang`)
) ENGINE=' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET=utf8;';
$sql[_DB_PREFIX_ . 'condition_advice'] = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'condition_advice` (
`id_condition` int(11) NOT NULL,
`id_advice` int(11) NOT NULL,
`display` tinyint(1) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id_condition`, `id_advice`)
) ENGINE=' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET=utf8;';
$sql[_DB_PREFIX_ . 'tab_advice'] = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'tab_advice` (
`id_tab` int(11) NOT NULL,
`id_advice` int(11) NOT NULL,
PRIMARY KEY (`id_tab`, `id_advice`)
) ENGINE=' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET=utf8;';
return $sql;