[FEATURE] Doctrine: Implement SchemaMigrationService
[Packages/TYPO3.CMS.git] / typo3 / sysext / core / Tests / Functional / Database / Fixtures / newTable.sql
1 CREATE TABLE aTestTable (
2 uid INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
3 pid INT(11) UNSIGNED DEFAULT '0' NOT NULL,
4 tstamp INT(11) UNSIGNED DEFAULT '0' NOT NULL,
5 hidden TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
6 deleted TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
7
8 PRIMARY KEY (uid),
9 KEY parent (pid)
10 );