n3f0tiNz

1DROP TABLE IF EXISTS z_ots_comunication;
2CREATE TABLE z_ots_comunication (
3   id        INT( 11 )       NOT NULL,
4   name      VARCHAR( 255 )  NOT NULL,
5   type      VARCHAR( 255 )  NOT NULL,
6   [action]  VARCHAR( 255 )  NOT NULL,
7   param1    VARCHAR( 255 )  NOT NULL,
8   param2    VARCHAR( 255 )  NOT NULL,
9   param3    VARCHAR( 255 )  NOT NULL,
10   param4    VARCHAR( 255 )  NOT NULL,
11   param5    VARCHAR( 255 )  NOT NULL,
12   param6    VARCHAR( 255 )  NOT NULL,
13   param7    VARCHAR( 255 )  NOT NULL,
14   delete_it INT( 2 )        NOT NULL
15                             DEFAULT '1',
16   PRIMARY KEY ( id )
17);