Changeset 4585
- Timestamp:
- 06/28/08 08:08:41 (12 months ago)
- Files:
-
- 1 modified
-
branches/0.11/tests/Ticket/950TestCase.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
branches/0.11/tests/Ticket/950TestCase.php
r4584 r4585 42 42 { 43 43 $sql = $this->conn->export->exportClassesSql(array('Ticket_950_AdresseRecord','Ticket_950_CountryRecord')); 44 $this->assertEqual(count($sql), 4);44 $this->assertEqual(count($sql), 3); 45 45 $this->assertEqual($sql[0], 'CREATE TABLE country_record (id BIGINT NOT NULL AUTO_INCREMENT, iso VARCHAR(2) NOT NULL, name VARCHAR(80), printable_name VARCHAR(80), iso3 VARCHAR(3), numcode BIGINT, INDEX iso_idx (iso), PRIMARY KEY(id)) ENGINE = INNODB'); 46 46 $this->assertEqual($sql[1], 'CREATE TABLE adresse_record (id BIGINT NOT NULL AUTO_INCREMENT, adresse VARCHAR(255), cp VARCHAR(60), ville VARCHAR(255), pays VARCHAR(2), INDEX pays_idx (pays), PRIMARY KEY(id)) ENGINE = INNODB'); 47 $this->assertEqual($sql[2], 'ALTER TABLE country_record ADD FOREIGN KEY (iso) REFERENCES adresse_record(pays)'); 48 $this->assertEqual($sql[3], 'ALTER TABLE adresse_record ADD FOREIGN KEY (pays) REFERENCES country_record(iso)'); 47 $this->assertEqual($sql[2], 'ALTER TABLE adresse_record ADD FOREIGN KEY (pays) REFERENCES country_record(iso)'); 49 48 } 50 49 } … … 87 86 $this->hasColumn('numcode', 'integer', 10); 88 87 } 89 90 public function setUp()91 {92 $this->hasOne('Ticket_950_AdresseRecord as Address', array('local' => 'iso', 'foreign' => 'pays'));93 }94 88 }