22 lines
561 B
SQL
Executable File
22 lines
561 B
SQL
Executable File
-- we choose not to have any default DATETIME values
|
|
ALTER TABLE `ApplicationPeriod` CHANGE `startDate` `startDate` DATETIME NOT NULL,
|
|
CHANGE `endDate` `endDate` DATETIME NOT NULL,
|
|
CHANGE `name` `name` varchar(255) NOT NULL
|
|
|
|
|
|
-- Add Thesis Support-user to Scipro database.
|
|
INSERT INTO `scipro`.`user` (
|
|
`id` ,
|
|
`dateCreated` ,
|
|
`lastModified` ,
|
|
`deleted` ,
|
|
`emailAddress` ,
|
|
`firstName` ,
|
|
`identifier` ,
|
|
`lastName` ,
|
|
`version`
|
|
)
|
|
VALUES (
|
|
NULL , '2012-02-21 10:27:30', '2012-02-21 10:27:35','0', 'thesissupport@dsv.su.se', 'Thesis', NULL , 'Support', '0'
|
|
);
|