@@ 20-90 (lines=71) @@ | ||
17 | * @author JJDai <http://xoops.kiolo.com> |
|
18 | **/ |
|
19 | //---------------------------------------------------- |
|
20 | class Extcal_2_28 |
|
21 | { |
|
22 | //---------------------------------------------------- |
|
23 | ||
24 | /** |
|
25 | * @param XoopsModule $module |
|
26 | * @param $options |
|
27 | */ |
|
28 | public function __construct(XoopsModule $module, $options) |
|
29 | { |
|
30 | global $xoopsDB; |
|
31 | ||
32 | $this->addTable_etablissement(); |
|
33 | $this->alterTable_event(); |
|
34 | } |
|
35 | ||
36 | //---------------------------------------------------- |
|
37 | public function alterTable_event() |
|
38 | { |
|
39 | global $xoopsDB; |
|
40 | ||
41 | $tbl = $xoopsDB->prefix('extcal_event'); |
|
42 | ||
43 | $sql = <<<__sql__ |
|
44 | ALTER TABLE `{$tbl}` |
|
45 | add `event_organisateur` varchar(255) NOT NULL default '', |
|
46 | add `event_picture1` varchar(255) NOT NULL, |
|
47 | add `event_picture2` varchar(255) NOT NULL, |
|
48 | add `event_price` varchar(255) NOT NULL default '', |
|
49 | add `event_etablissement` int(5) NOT NULL DEFAULT '1'; |
|
50 | __sql__; |
|
51 | ||
52 | $xoopsDB->queryF($sql); |
|
53 | } |
|
54 | ||
55 | //---------------------------------------------------- |
|
56 | public function addTable_etablissement() |
|
57 | { |
|
58 | global $xoopsDB; |
|
59 | ||
60 | $tbl = $xoopsDB->prefix('extcal_etablissement'); |
|
61 | ||
62 | $sql = <<<__sql__ |
|
63 | CREATE TABLE `{$tbl}` ( |
|
64 | `id` int(5) NOT NULL auto_increment, |
|
65 | `nom` varchar(255) NOT NULL, |
|
66 | `desc` text NOT NULL, |
|
67 | `logo` varchar(255) NOT NULL, |
|
68 | `categorie` varchar(255) NOT NULL, |
|
69 | `adresse` varchar(255) NOT NULL, |
|
70 | `adresse2` varchar(255) NOT NULL, |
|
71 | `cp` varchar(10) NOT NULL, |
|
72 | `ville` varchar(50) NOT NULL, |
|
73 | `tel_fixe` varchar(20) NOT NULL, |
|
74 | `tel_portable` varchar(20) NOT NULL, |
|
75 | `mail` varchar(255) NOT NULL, |
|
76 | `site` varchar(255) NOT NULL, |
|
77 | `horaires` text NOT NULL, |
|
78 | `divers` text NOT NULL, |
|
79 | `tarifs` text NOT NULL, |
|
80 | `map` text NOT NULL, |
|
81 | ||
82 | PRIMARY KEY (`id`) |
|
83 | ) ENGINE = MYISAM ; |
|
84 | __sql__; |
|
85 | ||
86 | $xoopsDB->queryF($sql); |
|
87 | //--------------------------------------------------- |
|
88 | } |
|
89 | //----------------------------------------------------------------- |
|
90 | } // fin de la classe |
|
91 |
@@ 20-65 (lines=46) @@ | ||
17 | * @author JJDai <http://xoops.kiolo.com> |
|
18 | **/ |
|
19 | //---------------------------------------------------- |
|
20 | class Extcal_2_33 |
|
21 | { |
|
22 | //---------------------------------------------------- |
|
23 | ||
24 | /** |
|
25 | * @param XoopsModule $module |
|
26 | * @param $options |
|
27 | */ |
|
28 | public function __construct(XoopsModule $module, $options) |
|
29 | { |
|
30 | global $xoopsDB; |
|
31 | ||
32 | $this->alterTable_cat(); |
|
33 | $this->alterTable_eventmember(); |
|
34 | } |
|
35 | ||
36 | //---------------------------------------------------- |
|
37 | public function alterTable_cat() |
|
38 | { |
|
39 | global $xoopsDB; |
|
40 | $tbl = $xoopsDB->prefix('extcal_cat'); |
|
41 | ||
42 | $sql = <<<__sql__ |
|
43 | ALTER TABLE `{$tbl}` |
|
44 | ADD `cat_weight` INT NOT NULL DEFAULT '0'; |
|
45 | __sql__; |
|
46 | ||
47 | $xoopsDB->queryF($sql); |
|
48 | } |
|
49 | ||
50 | //---------------------------------------------------- |
|
51 | public function alterTable_eventmember() |
|
52 | { |
|
53 | global $xoopsDB; |
|
54 | $tbl = $xoopsDB->prefix('eventmember'); |
|
55 | ||
56 | $sql = <<<__sql__ |
|
57 | ALTER TABLE `{$tbl}` |
|
58 | ADD `status` INT NOT NULL DEFAULT '0'; |
|
59 | __sql__; |
|
60 | ||
61 | $xoopsDB->queryF($sql); |
|
62 | } |
|
63 | ||
64 | //----------------------------------------------------------------- |
|
65 | } // fin de la classe |
|
66 |
@@ 20-64 (lines=45) @@ | ||
17 | * @author JJDai <http://xoops.kiolo.com> |
|
18 | **/ |
|
19 | //---------------------------------------------------- |
|
20 | class Extcal_2_37 |
|
21 | { |
|
22 | //---------------------------------------------------- |
|
23 | ||
24 | /** |
|
25 | * @param XoopsModule $module |
|
26 | * @param $options |
|
27 | */ |
|
28 | public function __construct(XoopsModule $module, $options) |
|
29 | { |
|
30 | global $xoopsDB; |
|
31 | ||
32 | $this->alterTable_event(); |
|
33 | $this->alterTable_cat(); |
|
34 | } |
|
35 | ||
36 | //---------------------------------------------------- |
|
37 | public function alterTable_event() |
|
38 | { |
|
39 | global $xoopsDB; |
|
40 | $tbl = $xoopsDB->prefix('extcal_event'); |
|
41 | ||
42 | $sql = <<<__sql__ |
|
43 | ALTER TABLE `{$tbl}` ADD `event_icone` VARCHAR(50) NOT NULL; |
|
44 | __sql__; |
|
45 | ||
46 | $xoopsDB->queryF($sql); |
|
47 | } |
|
48 | ||
49 | //----------------------------------------------------------------- |
|
50 | ||
51 | public function alterTable_cat() |
|
52 | { |
|
53 | global $xoopsDB; |
|
54 | $tbl = $xoopsDB->prefix('extcal_cat'); |
|
55 | ||
56 | $sql = <<<__sql__ |
|
57 | ALTER TABLE `{$tbl}` ADD `cat_icone` VARCHAR(50) NOT NULL ; |
|
58 | __sql__; |
|
59 | ||
60 | $xoopsDB->queryF($sql); |
|
61 | } |
|
62 | ||
63 | //----------------------------------------------------------------- |
|
64 | } // fin de la classe |
|
65 |