Differential D98 Diff 330 branches/1.2.x/install/install_schema.sql

Changeset View

Standalone View

	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)
	);			);