Mr. Furxheir, R.M.W.
Group: admins
(1791 posts total)
(last post: November 24, 2007 - 15:07)
Citizen #20:
Martí- Paìr Furxhéir | CREATE TABLE `Election` (
`ElectionNumber` INT NOT NULL AUTO_INCREMENT ,
`Name` TEXT,
`VoteType` ENUM( 'Preferential', 'ClosedList', 'Referendum2Choices', 'Referendum3Choices' ) DEFAULT 'Preferential' NOT NULL ,
`Office` INT,
`Province` TINYINT,
`StartDate` DATE,
`Duration` TINYINT DEFAULT '21' NOT NULL ,
`Status` ENUM( 'Pending', 'Running', 'Closed' ) DEFAULT 'Pending' NOT NULL ,
`Description` LONGTEXT,
`SoS` TINYINT,
PRIMARY KEY ( `ElectionNumber` )
);
CREATE TABLE `ElectionCandidates` (
`ElectionNumber` INT NOT NULL ,
`CitizenNumber` INT NOT NULL ,
`CandidatePartyInitials` TINYTEXT,
`BallotRank` INT DEFAULT '0' NOT NULL ,
PRIMARY KEY ( `ElectionNumber` , `CitizenNumber` )
);
CREATE TABLE `ElectionVote` (
`ElectionNumber` INT NOT NULL ,
`VoteKey` VARCHAR( 40 ) NOT NULL ,
`VoteText` TEXT NOT NULL ,
PRIMARY KEY ( `ElectionNumber` , `VoteKey` ) ,
FULLTEXT (
`VoteText`
)
);
CREATE TABLE `VoteCensus` (
`ElectionNumber` INT NOT NULL ,
`CitizenNumber` INT NOT NULL ,
`IPAddress` TINYTEXT NOT NULL ,
`UserAgent` TEXT NOT NULL ,
PRIMARY KEY ( `ElectionNumber` , `CitizenNumber` )
);
Do you like my stupid hair?
Would you guess that I didn't know what to wear?
I'm just scared of what you think
You make me nervous so I really can't eat.
When you smile, I melt inside
I'm not worthy for a minute of your time
|
