install-0.0.1.php
6.8 KB
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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
<?php
/**
* @copyright (c) 2014, netz.coop eG
*/
/**
* @var Mage_Sales_Model_Mysql4_Setup $installer
*/
$installer = $this;
$installer->startSetup();
// Erstellen der anc_pricespercustomer Tabelle
$tableName = $installer->getTable('anc_image/ncimage');
//D::li('***************: '.$tableName);
if ($installer->getConnection()->isTableExists($tableName) != true ){
$table = $installer->getConnection()->newTable($tableName)
->addColumn('entity_id', Varien_Db_Ddl_Table::TYPE_INTEGER,null,array('identity' => true,'unsigned' => true,'nullable' => false,'primary' => true,),'Id')
->addColumn('customer_id', Varien_Db_Ddl_Table::TYPE_INTEGER,null,array('unsigned' => true,'nullable' => false,'default' => '0',),'Who Created frontend')
->addColumn('admin_user_id',Varien_Db_Ddl_Table::TYPE_INTEGER,null,array('unsigned' => true,'nullable' => false,'default' => '0',),'Who Created backend')
->addColumn('created_at', Varien_Db_Ddl_Table::TYPE_TIMESTAMP,null,array(),'When beginn')
->addColumn('updated_at', Varien_Db_Ddl_Table::TYPE_TIMESTAMP,null,array(),'When updated')
->addColumn('deleted_at', Varien_Db_Ddl_Table::TYPE_TIMESTAMP,null, array(), 'When deleted')
->addColumn('deleted', Varien_Db_Ddl_Table::TYPE_TINYINT,null,array('default' => '0'),'Deleted')
->addColumn('path', Varien_Db_Ddl_Table::TYPE_VARCHAR,null,array(),'file path')
->addColumn('file', Varien_Db_Ddl_Table::TYPE_VARCHAR,null,array(),'file')
->addColumn('name', Varien_Db_Ddl_Table::TYPE_VARCHAR,null,array(),'Name')
->addColumn('comment', Varien_Db_Ddl_Table::TYPE_VARCHAR,null,array(),'comment')
->addColumn('ncalbum_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array('unsigned' => true,'nullable' => false,'default' => '0',),'gehört zum album')
->addColumn('original_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array('unsigned' => true,'nullable' => false,'default' => '0',),'wenn album dupliziert wird, würde hier die original album id angezeigt werden')
->addColumn('ncright_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array('unsigned' => true,'nullable' => false,'default' => '0',),'Who Created frontend')
->addIndex($installer->getIdxName('anc_image/ncimage', array('customer_id')), array('customer_id'))
->addIndex($installer->getIdxName('anc_image/ncimage', array('admin_user_id')), array('admin_user_id'))
->addIndex($installer->getIdxName('anc_image/ncimage', array('original_id')), array('original_id'))
->addIndex($installer->getIdxName('anc_image/ncimage', array('ncalbum_id')), array('ncalbum_id'))
// http://docs.magentocommerce.com/Varien/Varien_Db/Varien_Db_Ddl_Table.html#addForeignKey
// ->addForeignKey(
// $installer->getFkName( 'anc_image/ncimage','customer_id','customer/entity','entity_id'), 'customer_id',
// $installer->getTable('customer/entity'), 'entity_id',
// Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE
// )
// ->addForeignKey(
// $installer->getFkName( 'anc_image/ncimage','admin_user_id','admin/user','user_id'), 'admin_user_id',
// $installer->getTable('admin/user'), 'user_id',
// Varien_Db_Ddl_Table::ACTION_NO_ACTION, Varien_Db_Ddl_Table::ACTION_NO_ACTION
// )
// ->addForeignKey(
// $installer->getFkName( 'anc_image/ncimage','original_id','anc_image/ncimage','entity_id'), 'original_id',
// $installer->getTable('anc_image/ncimage'), 'entity_id',
// Varien_Db_Ddl_Table::ACTION_NO_ACTION, Varien_Db_Ddl_Table::ACTION_NO_ACTION
// )
// ->addForeignKey(
// $installer->getFkName( 'anc_image/ncimage','ncalbum_id','anc_album/ncalbum','entity_id'), 'ncalbum_id',
// $installer->getTable('anc_album/ncalbum'), 'entity_id',
// Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE
// )
;
$installer->getConnection()->createTable($table);
}
/**
* für die anzeige ob kunde schon mal bild benutzt hat, und wenn ja wan
* redudant weil info ansich vorhanden, aber zu performant um ran zukommen
*/
$tableName = $installer->getTable('anc_image/ncimage_quoteitemoption');
if ($installer->getConnection()->isTableExists($tableName) != true ){
$table = $installer->getConnection()->newTable($tableName)
->addColumn('entity_id', Varien_Db_Ddl_Table::TYPE_INTEGER,null,array('identity' => true,'unsigned' => true,'nullable' => false,'primary' => true,),'Id')
->addColumn('customer_id', Varien_Db_Ddl_Table::TYPE_INTEGER,null,array('unsigned' => true,'nullable' => false,'default' => '0',),'Who Created frontend')
->addColumn('ncimage_id', Varien_Db_Ddl_Table::TYPE_INTEGER,null,array('unsigned' => true,'nullable' => false,'default' => '0',),'Who Created backend')
->addColumn('order_id', Varien_Db_Ddl_Table::TYPE_INTEGER,null,array('unsigned' => true,'nullable' => false,'default' => '0',),'Who Created backend')
->addColumn('quote_item_id',Varien_Db_Ddl_Table::TYPE_INTEGER,null,array('unsigned' => true,'nullable' => false,'default' => '0',),'Who Created backend')
->addColumn('ordertime', Varien_Db_Ddl_Table::TYPE_TIMESTAMP,null,array(),'Bestellzeitpunkt')
->addColumn('product_name', Varien_Db_Ddl_Table::TYPE_VARCHAR,null,array(),'Produktname')
->addIndex($installer->getIdxName('anc_image/ncimage_quoteitemoption', array('customer_id')),array('customer_id'))
->addIndex($installer->getIdxName('anc_image/ncimage_quoteitemoption', array('ncimage_id')),array('ncimage_id'))
->addIndex($installer->getIdxName('anc_image/ncimage_quoteitemoption', array('order_id')),array('order_id'))
->addIndex($installer->getIdxName('anc_image/ncimage_quoteitemoption', array('quote_item_id')),array('quote_item_id'))
// ->addForeignKey(
// $installer->getFkName( 'anc_image/ncimage_quoteitemoption','customer_id','customer/entity','entity_id'), 'customer_id',
// $installer->getTable('customer/entity'), 'entity_id',
// Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE
// )
// ->addForeignKey(
// $installer->getFkName( 'anc_image/ncimage_quoteitemoption','ncimage_id','anc_image/ncimage','entity_id'), 'ncimage_id',
// $installer->getTable('anc_image/ncimage'), 'entity_id',
// Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE
// )
// ->addForeignKey(
// $installer->getFkName( 'anc_image/ncimage_quoteitemoption','order_id','sales/order','entity_id'), 'order_id',
// $installer->getTable('sales/order'), 'entity_id',
// Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE
// )
// ->addForeignKey(
// $installer->getFkName( 'anc_image/ncimage_quoteitemoption','quote_item_id','sales/quote_item','item_id'), 'quote_item_id',
// $installer->getTable('sales/quote_item'), 'item_id',
// Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE
// )
;
$installer->getConnection()->createTable($table);
}
$installer->endSetup();
?>