1 CREATE TABLE IF NOT EXISTS `form_CAMOS` (
2 id bigint(20) NOT NULL auto_increment,
3 date datetime default NULL,
4 pid bigint(20) default NULL,
5 user varchar(255) default NULL,
6 groupname varchar(255) default NULL,
7 authorized tinyint(4) default NULL,
8 activity tinyint(4) default NULL,
17 CREATE TABLE IF NOT EXISTS `form_CAMOS_category` (
18 id bigint(20) NOT NULL auto_increment,
19 date datetime default NULL,
20 pid bigint(20) default NULL,
21 user varchar(255) default NULL,
22 groupname varchar(255) default NULL,
23 authorized tinyint(4) default NULL,
24 activity tinyint(4) default NULL,
31 CREATE TABLE IF NOT EXISTS `form_CAMOS_subcategory` (
32 id bigint(20) NOT NULL auto_increment,
33 date datetime default NULL,
34 pid bigint(20) default NULL,
35 user varchar(255) default NULL,
36 groupname varchar(255) default NULL,
37 authorized tinyint(4) default NULL,
38 activity tinyint(4) default NULL,
41 category_id bigint(20) NOT NULL,
46 CREATE TABLE IF NOT EXISTS `form_CAMOS_item` (
47 id bigint(20) NOT NULL auto_increment,
48 date datetime default NULL,
49 pid bigint(20) default NULL,
50 user varchar(255) default NULL,
51 groupname varchar(255) default NULL,
52 authorized tinyint(4) default NULL,
53 activity tinyint(4) default NULL,
57 subcategory_id bigint(20) NOT NULL,