Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/patches/099.drydock.sql
| CREATE TABLE {$NAMESPACE}_drydock.drydock_resource ( | CREATE TABLE {$NAMESPACE}_drydock.drydock_resource ( | ||||
| id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, | id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, | ||||
| phid VARCHAR(64) BINARY NOT NULL, | phid VARCHAR(64) BINARY NOT NULL, | ||||
| name VARCHAR(255) NOT NULL, | name VARCHAR(255) NOT NULL, | ||||
| ownerPHID varchar(64) BINARY, | ownerPHID varchar(64) BINARY, | ||||
| status INT UNSIGNED NOT NULL, | status INT UNSIGNED NOT NULL, | ||||
| blueprintClass VARCHAR(255) NOT NULL, | blueprintClass VARCHAR(255) NOT NULL, | ||||
| type VARCHAR(64) NOT NULL, | type VARCHAR(64) NOT NULL, | ||||
| Show All 19 Lines | |||||