Changeset View
Changeset View
Standalone View
Standalone View
modules/custom/install/install_schema.sql
CREATE TABLE Widgets ( | CREATE TABLE Widgets ( | ||||
WidgetId int(11) NOT NULL AUTO_INCREMENT, | WidgetId int(11) NOT NULL AUTO_INCREMENT, | ||||
Title varchar(255) NOT NULL DEFAULT '', | Title varchar(255) NOT NULL DEFAULT '', | ||||
Description text, | Description text, | ||||
Email varchar(255) NOT NULL DEFAULT '', | Email varchar(255) NOT NULL DEFAULT '', | ||||
`Type` tinyint(4) NOT NULL DEFAULT '1', | `Type` tinyint(4) NOT NULL DEFAULT '1', | ||||
Phone varchar(50) NOT NULL DEFAULT '', | Phone varchar(50) NOT NULL DEFAULT '', | ||||
Qty double NOT NULL DEFAULT '0', | Qty double NOT NULL DEFAULT '0', | ||||
`Status` tinyint(4) NOT NULL DEFAULT '2', | `Status` tinyint(4) NOT NULL DEFAULT '2', | ||||
CreatedOn int(10) unsigned DEFAULT NULL, | CreatedOn int(10) unsigned DEFAULT NULL, | ||||
Good tinyint(4) NOT NULL DEFAULT '0', | Good tinyint(4) NOT NULL DEFAULT '0', | ||||
BirthTime int(10) unsigned DEFAULT NULL, | BirthTime int(10) unsigned DEFAULT NULL, | ||||
Image text, | Image text, | ||||
DataFile text, | DataFile text, | ||||
Priority int(11) NOT NULL DEFAULT '0', | |||||
PRIMARY KEY (WidgetId) | PRIMARY KEY (WidgetId) | ||||
); | ); | ||||