Author: jablko
Date: Thu Sep 17 16:47:39 2009
New Revision: 3393
Log:
Build SQL, forgot in last commit : P
Modified:
trunk/data/sql/lib.model.schema.sql
trunk/data/sql/plugins.qbAclPlugin.lib.model.schema.sql
Modified: trunk/data/sql/lib.model.schema.sql
==============================================================================
--- trunk/data/sql/lib.model.schema.sql Thu Sep 17 16:43:49 2009 (r3392)
+++ trunk/data/sql/lib.model.schema.sql Thu Sep 17 16:47:39 2009 (r3393)
@@ -72,6 +72,7 @@
`revision_history` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
CONSTRAINT `q_actor_i18n_FK_1`
FOREIGN KEY (`id`)
@@ -94,6 +95,7 @@
`updated_at` DATETIME NOT NULL,
`source_culture` VARCHAR(7) NOT NULL,
`id` INTEGER NOT NULL AUTO_INCREMENT,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `q_actor_name_FI_1` (`actor_id`),
CONSTRAINT `q_actor_name_FK_1`
@@ -120,6 +122,7 @@
`note` VARCHAR(255),
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
CONSTRAINT `q_actor_name_i18n_FK_1`
FOREIGN KEY (`id`)
@@ -152,6 +155,7 @@
`updated_at` DATETIME NOT NULL,
`source_culture` VARCHAR(7) NOT NULL,
`id` INTEGER NOT NULL AUTO_INCREMENT,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `q_contact_information_FI_1` (`actor_id`),
CONSTRAINT `q_contact_information_FK_1`
@@ -175,6 +179,7 @@
`note` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
CONSTRAINT `q_contact_information_i18n_FK_1`
FOREIGN KEY (`id`)
@@ -288,6 +293,7 @@
`date_display` VARCHAR(255),
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
CONSTRAINT `q_event_i18n_FK_1`
FOREIGN KEY (`id`)
@@ -350,6 +356,7 @@
`revision_history` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
CONSTRAINT `q_function_i18n_FK_1`
FOREIGN KEY (`id`)
@@ -472,6 +479,7 @@
`revision_history` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
CONSTRAINT `q_information_object_i18n_FK_1`
FOREIGN KEY (`id`)
@@ -492,6 +500,7 @@
`updated_at` DATETIME NOT NULL,
`source_culture` VARCHAR(7) NOT NULL,
`id` INTEGER NOT NULL AUTO_INCREMENT,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`)
)Type=InnoDB;
@@ -508,6 +517,7 @@
`description` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
CONSTRAINT `q_map_i18n_FK_1`
FOREIGN KEY (`id`)
@@ -533,6 +543,7 @@
`updated_at` DATETIME NOT NULL,
`source_culture` VARCHAR(7) NOT NULL,
`id` INTEGER NOT NULL AUTO_INCREMENT,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `q_menu_FI_1` (`parent_id`),
CONSTRAINT `q_menu_FK_1`
@@ -554,6 +565,7 @@
`description` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
CONSTRAINT `q_menu_i18n_FK_1`
FOREIGN KEY (`id`)
@@ -581,6 +593,7 @@
`updated_at` DATETIME NOT NULL,
`source_culture` VARCHAR(7) NOT NULL,
`id` INTEGER NOT NULL AUTO_INCREMENT,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `q_note_FI_1` (`object_id`),
CONSTRAINT `q_note_FK_1`
@@ -614,6 +627,7 @@
`content` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
CONSTRAINT `q_note_i18n_FK_1`
FOREIGN KEY (`id`)
@@ -634,6 +648,7 @@
`created_at` DATETIME NOT NULL,
`updated_at` DATETIME NOT NULL,
`id` INTEGER NOT NULL AUTO_INCREMENT,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`)
)Type=InnoDB;
@@ -680,6 +695,7 @@
`module` VARCHAR(255),
`action` VARCHAR(255),
`id` INTEGER NOT NULL AUTO_INCREMENT,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`)
)Type=InnoDB;
@@ -698,6 +714,7 @@
`role_id` INTEGER,
`user_id` INTEGER,
`id` INTEGER NOT NULL AUTO_INCREMENT,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `q_permission_scope_FI_1` (`permission_id`),
CONSTRAINT `q_permission_scope_FK_1`
@@ -761,6 +778,7 @@
`location` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
CONSTRAINT `q_physical_object_i18n_FK_1`
FOREIGN KEY (`id`)
@@ -814,6 +832,7 @@
`postal_code` VARCHAR(255),
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
CONSTRAINT `q_place_i18n_FK_1`
FOREIGN KEY (`id`)
@@ -877,6 +896,7 @@
`updated_at` DATETIME NOT NULL,
`source_culture` VARCHAR(7) NOT NULL,
`id` INTEGER NOT NULL AUTO_INCREMENT,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `q_property_FI_1` (`object_id`),
CONSTRAINT `q_property_FK_1`
@@ -897,6 +917,7 @@
`value` VARCHAR(255),
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
CONSTRAINT `q_property_i18n_FK_1`
FOREIGN KEY (`id`)
@@ -919,6 +940,7 @@
`updated_at` DATETIME NOT NULL,
`source_culture` VARCHAR(7) NOT NULL,
`id` INTEGER NOT NULL AUTO_INCREMENT,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `q_rights_FI_1` (`object_id`),
CONSTRAINT `q_rights_FK_1`
@@ -1029,6 +1051,7 @@
`desc_revision_history` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
CONSTRAINT `q_repository_i18n_FK_1`
FOREIGN KEY (`id`)
@@ -1048,6 +1071,7 @@
`description` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
CONSTRAINT `q_rights_i18n_FK_1`
FOREIGN KEY (`id`)
@@ -1105,6 +1129,7 @@
`created_at` DATETIME NOT NULL,
`updated_at` DATETIME NOT NULL,
`id` INTEGER NOT NULL AUTO_INCREMENT,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `q_rights_term_relation_FI_1` (`rights_id`),
CONSTRAINT `q_rights_term_relation_FK_1`
@@ -1133,6 +1158,7 @@
(
`name` VARCHAR(255),
`id` INTEGER NOT NULL AUTO_INCREMENT,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`)
)Type=InnoDB;
@@ -1148,6 +1174,7 @@
`role_id` INTEGER NOT NULL,
`permission_id` INTEGER NOT NULL,
`id` INTEGER NOT NULL AUTO_INCREMENT,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `q_role_permission_relation_FI_1` (`role_id`),
CONSTRAINT `q_role_permission_relation_FK_1`
@@ -1176,6 +1203,7 @@
`deleteable` TINYINT default 0,
`source_culture` VARCHAR(7) NOT NULL,
`id` INTEGER NOT NULL AUTO_INCREMENT,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`)
)Type=InnoDB;
@@ -1191,6 +1219,7 @@
`value` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
CONSTRAINT `q_setting_i18n_FK_1`
FOREIGN KEY (`id`)
@@ -1230,6 +1259,7 @@
`content` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
CONSTRAINT `q_static_page_i18n_FK_1`
FOREIGN KEY (`id`)
@@ -1252,6 +1282,7 @@
`created_at` DATETIME NOT NULL,
`updated_at` DATETIME NOT NULL,
`id` INTEGER NOT NULL AUTO_INCREMENT,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `q_status_FI_1` (`object_id`),
CONSTRAINT `q_status_FK_1`
@@ -1289,6 +1320,7 @@
`created_at` DATETIME NOT NULL,
`updated_at` DATETIME NOT NULL,
`id` INTEGER NOT NULL AUTO_INCREMENT,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `q_system_event_FI_1` (`type_id`),
CONSTRAINT `q_system_event_FK_1`
@@ -1314,6 +1346,7 @@
`updated_at` DATETIME NOT NULL,
`source_culture` VARCHAR(7) NOT NULL,
`id` INTEGER NOT NULL AUTO_INCREMENT,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`)
)Type=InnoDB;
@@ -1330,6 +1363,7 @@
`note` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
CONSTRAINT `q_taxonomy_i18n_FK_1`
FOREIGN KEY (`id`)
@@ -1381,6 +1415,7 @@
`name` VARCHAR(255),
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
CONSTRAINT `q_term_i18n_FK_1`
FOREIGN KEY (`id`)
@@ -1421,6 +1456,7 @@
`user_id` INTEGER NOT NULL,
`role_id` INTEGER NOT NULL,
`id` INTEGER NOT NULL AUTO_INCREMENT,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `q_user_role_relation_FI_1` (`user_id`),
CONSTRAINT `q_user_role_relation_FK_1`
@@ -1450,6 +1486,7 @@
`earliest_timestamp` DATETIME,
`created_at` DATETIME NOT NULL,
`updated_at` DATETIME NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`)
)Type=InnoDB;
@@ -1471,6 +1508,7 @@
`metadataPrefix` VARCHAR(255),
`set` VARCHAR(255),
`created_at` DATETIME NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `q_oai_harvest_FI_1` (`oai_repository_id`),
CONSTRAINT `q_oai_harvest_FK_1`
Modified: trunk/data/sql/plugins.qbAclPlugin.lib.model.schema.sql
==============================================================================
--- trunk/data/sql/plugins.qbAclPlugin.lib.model.schema.sql Thu Sep 17
16:43:49 2009 (r3392)
+++ trunk/data/sql/plugins.qbAclPlugin.lib.model.schema.sql Thu Sep 17
16:47:39 2009 (r3393)
@@ -14,6 +14,7 @@
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`source_culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`)
)Type=InnoDB;
@@ -30,6 +31,7 @@
`description` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
UNIQUE KEY `q_acl_action_i18n_U_1` (`name`),
CONSTRAINT `q_acl_action_i18n_FK_1`
@@ -54,6 +56,7 @@
`created_at` DATETIME NOT NULL,
`updated_at` DATETIME NOT NULL,
`source_culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `q_acl_group_FI_1` (`parent_id`),
CONSTRAINT `q_acl_group_FK_1`
@@ -75,6 +78,7 @@
`description` TEXT,
`id` INTEGER NOT NULL,
`culture` VARCHAR(7) NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`,`culture`),
CONSTRAINT `q_acl_group_i18n_FK_1`
FOREIGN KEY (`id`)
@@ -101,6 +105,7 @@
`constants` TEXT,
`created_at` DATETIME NOT NULL,
`updated_at` DATETIME NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `q_acl_permission_FI_1` (`user_id`),
CONSTRAINT `q_acl_permission_FK_1`
@@ -136,6 +141,7 @@
`id` INTEGER NOT NULL AUTO_INCREMENT,
`user_id` INTEGER NOT NULL,
`group_id` INTEGER NOT NULL,
+ `serial_number` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `q_acl_user_group_FI_1` (`user_id`),
CONSTRAINT `q_acl_user_group_FK_1`
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Qubit Toolkit Commits" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.ca/group/qubit-commits?hl=en
-~----------~----~----~----~------~----~------~--~---
