changeset 10204 | f8ccae1e271d |
parent 10202 | aaabcb64f77f |
child 10443 | 2d3834df64ab |
10203:1443fe643a38 | 10204:f8ccae1e271d |
---|---|
128 cp varchar(12), |
128 cp varchar(12), |
129 ville varchar(32) |
129 ville varchar(32) |
130 ); |
130 ); |
131 |
131 |
132 CREATE TABLE State( |
132 CREATE TABLE State( |
133 eid integer PRIMARY KEY, |
133 eid integer PRIMARY KEY REFERENCES entities (eid), |
134 name varchar(256) NOT NULL, |
134 name varchar(256) NOT NULL, |
135 description text |
135 description text |
136 ); |
136 ); |
137 CREATE INDEX state_name_idx ON State(name); |
137 CREATE INDEX state_name_idx ON State(name); |
138 |
138 |